Error 42703 when running Data Warehouse Load for the 1st time

[Dimitris Tranoudis]

We are on SaaS Clarity 16.3.0

We are running for the 1st time DWH Jobs.

Time Slicing ran smoothly.

Load Data Warehouse Access Rights ran smoothly.

Load Data Warehouse when run through the interface always fails.

Refers to the table DWH_INV_INVESTMENT that a column does not exist.

DWH_INV_INVESTMENT

ENCOUNTERED EXCEPTION WHILE MERGING INTO DWH_INV_INVESTMENT. column "dw_entity_id_caption" does not exist

Error number raised is 42703

Any support would be appreciated.

[Suman Pramanik]

Before you run DWH there are some pre-requisites like setting entity, details can be found here