I would recommend that you open a support case for this.
http://world.episerver.com/Support/Register-Support-Incident/
The upgrade scripts also does programmatic maintentance tasks against DDS that does not get executed when you run the scripts manually. In this case I beleive the problem is a cmdlet that basically runs this code which I guess you can run yourself:
foreach (var storeDefinition in StoreDefinition.GetAll())
{
DataStoreProvider.CreateInstance().SaveStoreDefinition(storeDefinition);
}
For example add it to Application_Start, start the site 1 time then remove the code again. Its just a 1 time operation that needs to run to recreate store definitions in the database.
Thanks for the quick reply Per Bjurström, unfortunately this did not work for us
Did anyone manage to do it? I can't understand why the Deployment Center doesn't have an option to upgrade the database only. For example I already have the sources and the database from the test server upgraded, now I need to upgrade the database from production.
How do we do it? There are tons of scripts under "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql".
Hi
We are upgrading our Episerver 6R2 site to Episerver 7.
We used the Deployment Center to upgrade the development database, but when we tryed to run the appropiate scripts from C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql and C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\Upgrade\Database\sql to upgrade the test server we get a exception:
Server Error in '/' Application.
Cannot insert the value NULL into column 'StoreName', table 'xxx.dbo.tblBigTableIdentity'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'pkId', table 'xxx.dbo.tblBigTable'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'StoreName', table 'xxx.dbo.tblBigTableIdentity'; column does not allow nulls. INSERT fails.
Cannot insert the value NULL into column 'pkId', table 'xxx.dbo.tblBigTable'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.
Source Error:
Line 118: Line 119: ConvertPageDataToIndexItem(page, item); Line 120: SearchHandler.Instance.UpdateIndex(item); Line 121: } Line 122:
Stack Trace: