I just tried the TXDictionary project from CubeStore and managed to deploy the ODX (Business Unit) but when I start execution I get the following error:
Invalid object name 'etl.ExecutionPackageLogs_I'.
Running TX 20.10.1.64
Solved
TX Dictionary from CubeStore error on Execute
Best answer by thagin
Hi Martin,
Great question! I just ran through the TX Dictionary project myself using the latest version (20.10.6) and found the same error, which 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:
- Open the Data Extraction tab under Table Settings
- Change the top-most setting from Automatic to Incremental
- Deploy and Execute the ODX layer, or the entire project
Best,
Taylor
Hi Martin,
Great question! I just ran through the TX Dictionary project myself using the latest version (20.10.6) and found the same error, which 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:
- Open the Data Extraction tab under Table Settings
- Change the top-most setting from Automatic to Incremental
- Deploy and Execute the ODX layer, or the entire project
Best,
Taylor
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
