Skip to main content

I get the followinf error after transferring the latest version van OT to A environment and full managed deployment:


Finished executing project 'RobidusDWH' Execution Package 'Laden ACC'


Execution failed


Start Time : 4/3/2020 7:16:52 AM End Time : 4/3/2020 7:25:01 AM on server: WIN6682 -Execute Execution Package Laden ACC 'Failed'


               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.


              


               Details:


              


               SQL Server: 'cf15a5af617c.tr6225.westeurope1-a.worker.database.windows.net,11009'


               SQL Procedure: 'DMA_TX.usp_CrDM_DMA_TX_Feit_OpenstaandeTaken_HDA_HDA_V_DMA_Feit_OpenstaandeTaken'


               SQL Line Number: 12


               SQL Error Number: 208


              


               Invalid object name 'HDA_V_DMA.DM_HDA_HDA_V_DMA_Feit_OpenstaandeTaken_DMA_DMA_Feit_OpenstaandeTaken_T'.


               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)

Hi Huub

The _T table is a transfer view. Have you added some transformation on a field, you will see it there. You should be able to see it by going to the customize code area.

And then checking the transformation view.

What happens on line 12 in the transfer view?


You may "Uncheck" differential deployment and attempt to deploy the table again to see if that resolves the error.


Reply