London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

[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.