Solved

TX Dictionary from CubeStore error on Execute

  • 16 December 2020
  • 1 reply
  • 23 views

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

icon

Best answer by thagin 17 December 2020, 20:20

View original

1 reply

Badge

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:

  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,

Taylor

Reply