Solved

Data Dictionary - Failed Execution StepExecutionTime (MDW)

  • 13 January 2021
  • 2 replies
  • 34 views

I'm making a TimeXtender Dictionary using Azure (Azure SQL DB's & Azure Analysis Services). When deploying & executing the project I got an error for the StepExecutionTime table:


Invalid object name 'MDW_etl.StepExecutionTime_I'.

Details:

SQL Server: 'bffa063c7c84.tr366.westeurope1-a.worker.database.windows.net,11009'
SQL Procedure: 'MDW_etl.usp_CrDM_MDW_etl_StepExecutionTime_DSA_DSA_etl_StepExecutionTime'
SQL Line Number: 16
SQL Error Number: 208

Invalid object name 'MDW_etl.StepExecutionTime_I'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, 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& usedCache, Boolean asyncWrite, Boolean inRetry)
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.StepTransferSSISExecute.DoDataWarehouse(StepSetup stepSetup, VariableResolveObject dynamicResolveObject)
at TimeXtender.DataManager.StepTransferSSISExecute.DoAbstractStep(StepSetup stepSetup)

icon

Best answer by AvanWijnen 1 March 2021, 10:10

View original

2 replies

Badge

Arne, just mark the table as incremental and re deploy and execute the table. That will solve the issue

Badge

Hi Arne and Roy,

First of all, I hope that you got it working with the help from Roy.

Thanks Roy for your input, very helpful and the help here in the community is very much appreciated!

To check where the error is coming from, I just ran through the TX Dictionary project myself using the version (20.10.12) and found the same error.

This can be quickly remedied. There are three tables in the ODX (business unit) that need adjustment in the Table Settings:

  • TX.ExecutionPackageLogs
  • TX.ExecutionPackageLogDetails
  • TX.TIMEXTENDERTABLESCHEMA.

To resolve the error, perform the following on each of the tables:

  1. Open the Data Extraction tab under Table Settings
  2. Change the top-most setting from Automatic to Incremental
  3. Deploy and Execute the ODX layer, or the entire project

Best Regards,

Alex

 

Reply