November Happy Hour will be moved to Thursday December 5th.

[6.0.441.2] Exception in Migrate Data taask

Vote:
 

This error occurs if the site files and configuration are already upgraded to EPiServer 6 but not the database.

Steps:

* Have two working EPiServer 5.2. site (prod and test)

* Run upgrade on test site and get it to work

* Copy all files from test to prod folder (except connectionstrings.config and some web.config settings like VPP folders)

* Use EPiServer Deployment Center and start the Migrate Data task

Expected: Database should be upgraded from 5.2 to 6.0 format

Actual: The exception below occurs.

 

An unhandled error has occured:
Det gick inte att hitta den lagrade proceduren sp_FxDatabaseVersion.
When executing

At C:\Program Files (x86)\EPiServer\CMS\6.0.441.2\Upgrade\System Scripts\Migrat
e Data (SqlServer).ps1:68 char:27
+     Set-EPiLongStringSettings <<<<  -DestinationDirectory $wizard.SelectedApplic
ation.PhysicalPath    

=
Get-EPiIsBulkInstalling
Error - System.Management.Automation.CmdletInvocationException: Det gick inte att hitta den lagrade proceduren sp_FxDatabaseVersion. ---> System.Data.SqlClient.SqlException: Det gick inte att hitta den lagrade proceduren sp_FxDatabaseVersion.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.ValidateVersion()
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.get_Connection()
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.OpenConnection()
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.<>c__DisplayClass1`1.<Execute>b__0()
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.InternalExecute[TResult](Func`1 method)
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.Execute[TResult](Func`1 action)
   at EPiServer.Data.Dynamic.Providers.DbDataStoreProvider.LoadStoreDefinition(String storeName)
   at EPiServer.Data.Dynamic.StoreDefinition.<>c__DisplayClass1.<InternalGet>b__0()
   at EPiServer.Data.Cache.LocalCache`2.Add(TKey key, Boolean cacheNullValues, Boolean overwriteExistingValue, Func`1 action)
   at EPiServer.Data.Dynamic.StoreDefinition.InternalGet(String storeName)
   at EPiServer.Data.Dynamic.StoreDefinition.InternalCreate(String storeName, IDictionary`2 typeBag, StoreDefinitionParameters parameters)
   at EPiServer.Data.Dynamic.EPiServerDynamicDataStoreFactory.CreateStore(String storeName, Type type, StoreDefinitionParameters parameters)
   at EPiServer.Data.Dynamic.EPiServerDynamicDataStoreFactory.CreateStore(Type type)
   at EPiServer.Web.InitializationModule.InitializeDynamicDataStore()
   at EPiServer.Web.InitializationModule.<Initialize>b__1a()
   at EPiServer.Web.InitializeEngine.Initialize()
   at EPiServer.Web.InitializationModule.Initialize(EPiServerSection config, Settings settings, ConnectionStringSettingsCollection connectionStringSettings)
   at EPiServer.Install.CMS.Common.EPiServerCMSWrapper.InitalizeEPiServer(String webConfigPath)
   at EPiServer.Install.CMS.Common.EPiServerCMSWrapper.Initialize(String destinationPath, String virtualDirectory)
   at EPiServer.Install.CMS.Common.EPiServerCMSWrapper.Initialize(String destinationPath, String virtualDirectory)
   at EPiServer.Install.CMS.Modules.CmdLets.SetLongStringSettings.ProcessRecord()
   at System.Management.Automation.Cmdlet.DoProcessRecord()
   at System.Management.Automation.CommandProcessor.ProcessRecord()
   --- End of inner exception stack trace ---
   at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)
   at System.Management.Automation.PipelineNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
   at System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode statement, Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)

#35655
Dec 19, 2009 14:58
Vote:
 

Hi Fredrik,

 

I am currently investigating this.

 

Mvh Paul

#35686
Dec 21, 2009 11:15
Vote:
 
#38030
Mar 26, 2010 16:55
Vote:
 

If you are still having this problem with the release version of CMS then ensure that the EPiServer Framework Version 6.0.318.113 is installed by checking in the Control Panel

/Paul.

#38093
Mar 29, 2010 16:36
Vote:
 

I am getting the same error with CMS version 6.0.650, framework version is 6.0.318.113  what can be the cause for this? It happens when trying to migrate the long string settings.

#46077
Edited, Nov 25, 2010 17:42
Vote:
 

Hi. Have you raised a case with EPiServer Support for this. If not then you need to asap.

Regards

Paul.

#46198
Dec 01, 2010 14:48
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.