Return
-
Title
The MAgE log shows a SQL error regarding the @INTERVAL parameter after applying a hotfix. -
Description
After applying a hotfix to Migration Manager for Exchange, a SQL error may be witnessed in the MAgE.log file showing the following log lines:2015-08-12 13:14:10.8929 Px11D8 Tx9 A- C- M- Error System.Data.SqlClient.SqlException: Procedure or function 'GET_NEXT_ASSIGNMENT' expects parameter '@INTERVAL', which was not supplied.
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)
-
Cause
The repair function on the MAgE agents was not fully completed or run after the hotfix was installed to the console, as per the readme. -
Resolution
In the agent management section of the console, run the "repair" option for all MAgE agents. When completed, this error should no longer occur from that point forward.