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.


r84s3d6skl0FbgdJowtv3w.png


And then checking the transformation view.


E5Gag7wsJ7Pys_Py16fwAA.png


What happens on line 12 in the transfer view?


Hi Huub, I have created a ticket in our support system for this issue where our support staff can look into this further. 


Reply