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 !