-
Titel
Error System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'START_NEW_SESSION'. -
Beschreibung
After installing a hotfix for Migration Manager for Exchange, mail synchronization fails and the following error is written to the MAgE.log:
2017-08-07 11:39:10.9537 PxAE8 Tx1C A5 C- M- Error System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'START_NEW_SESSION'.at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()at Dell.MigrationManagerForExchange.General.Database.SqlConnector.ExecuteNonQueryInternal(Int32 retryCount, Func`2 prepareCommand, String commandName)at Dell.MigrationManagerForExchange.General.Database.SqlConnector.ExecuteNonQuery(String command, SPParam[] list)at Dell.MigrationManagerForExchange.General.Database.SqlConnector.ExecuteNonQuery(String command, Object anonimousPairs)at Dell.MigrationManagerForExchange.Shared.Database.SqlRecentSessionStorage.StartNewSession(Int32 collectionId, Int32 mailboxId)at Quest.MigrationManager.Exchange.Agent.Jobs.DisPlusO365JobBase.RunJob()at Quest.MigrationManager.Exchange.Agent.Tasks.QWorkTask.Run()at Quest.MigrationManager.Exchange.Agent.QThreadManager.RunTask(Object ctx)ClientConnectionId:df4fb488-ec38-4c83-80e5-ed1db6cc3a2fError Number:2812,State:62,Class:16 -
Ursache
The SQL database update did not complete successfully during the hotfix installation. -
Lösung
To resolve this issue, locate and run the UPDATEDB.sql against the Migration Manager for Exchange SQL database. The UPDATEDB.sql script is located at the following path on the QMM console machine: C:\Program Files (x86)\Quest Software\Migration Manager\Exchange Data\DB.
If the SQL server is local to the console machine:
1. Double-click the UPDATEDB.sql file which will launch SQL Management Studio.
2. In the 'Available Databases' drop-down list, ensure the Migration Manager for Exchange database is selected.
3. Click the 'Execute' button.
If the SQL server is remote:
1. Open the UPDATEDB.sql file in Notepad and copy the contents.
2. On the SQL Server, open SQL Management Studio and select the 'New Query' button.
3. Paste the contents of the UPDATEDB.sql file into the new query window.
4. In the 'Available Databases' drop-down list, ensure the Migration Manager for Exchange database is selected.
5. Click the 'Execute' button.