AnsweredAssumed Answered

Load Data Warehouse job failed with "invalid column name SLICE_CREATED_DATE"

Question asked by VitorPauloM.Correia1307048 on Sep 15, 2017
Latest reply on Sep 15, 2017 by Suman Pramanik

Hi Experts,


My DataWarehouse job had been running without any problems, for months. However, suddenly an error was thrown. The job runs ok only with the "full load" option.

The log is as follows, after running the job (incremental, not full load)

ERROR 2017-09-15 09:32:39,484 [dwh_tme_entry_facts UUID: 80751433-d2fe-4887-9b6b-4eabf1aa39e7] dwh.event ClarityDB - isOracle? - An error occurred executing this job entry : Couldn't execute SQL: DELETE FROM DWH_TME_ENTRY_FACTS WHERE EXISTS (SELECT 1 FROM [CLARITYDBLINK].niku.niku.DWH_TME_ENTRY_FACTS_V src WHERE DWH_TME_ENTRY_FACTS.TIMEENTRY_KEY = src.TIMEENTRY_KEY AND src.SLICE_CREATED_DATE BETWEEN CONVERT(DATETIME,'2017-09-15 08:52:39') AND CONVERT(DATETIME, '2017/09/15 09:29:35')) [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'SLICE_CREATED_DATE'.


Does anyone had the same issue ?

Thanks in advance !