When I do Deploy and Execute on my fact table, I get the following exception:
Must declare the scalar variable "@batchFirstId".Details:SQL Server: 'abea5b3595a5-0.tr624.northeurope1-a.worker.database.windows.net,11014'
SQL Procedure: ''
SQL Line Number: 1
SQL Error Number: 137Must declare the scalar variable "@batchFirstId".
Module: .Net SqlClient Data Provider
System.Data.SqlClient.SqlException
at System.Data.SqlClient.SqlConnection.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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at TimeXtender.DataManager.StepDataCleansingDeploy.DeployDataCleansingStoredProcedure(DataManTable dataManTable, VariableResolveObject dynamicResolveObject, StringBuilder script, TXCheckSumCache checkSumCache)
at TimeXtender.DataManager.StepDataCleansingDeploy.DoAbstractStep(StepSetup stepSetup)
Why do I get an exception? I am expecting an informative error message.