AnsweredAssumed Answered

Load Data Warehouse - Failed

Question asked by RnFernandez on Apr 4, 2018
Latest reply on Apr 6, 2018 by RnFernandez

Could you help us with this?
We are available to provide you with the information you need.

 

After running the job he displayed the following errors:

 

File: bg-ca.log

ERROR 2018-04-03 15:54:57,451 [Dispatch Load Data Warehouse : bg@NXCAPPM01 (tenant=clarity)] niku.njs (clarity:lvilla:6443497__5BCD6754-6B24-46F1-B28C-C6286D616B76:Load Data Warehouse) Error executing job: 5033032
java.lang.Exception: ETL Job Failed. Please see log bg-dwh.log for details.
____________________________________________________

File: bg-dwh.log

ERROR 2018-04-03 15:54:57,422 [Dispatch Load Data Warehouse : bg@NXCAPPM01 (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
2018/04/03 15:54:57 - MSSQL? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2018/04/03 15:54:57 - MSSQL? - Couldn't execute SQL: EXEC DWH_CFG_ADDIN_EXTRAS_SP 'PPMDBLINK.niku.niku'
2018/04/03 15:54:57 - MSSQL? -
2018/04/03 15:54:57 - MSSQL? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'DWH_INV_STATUS_REPORT'.
____________________________________________________

After running the "Load Data Warehouse" job, the ppm_dwh.DWH INV_STATUS_REPORT and ppm_dwh.DWH_INV_STATUS_REPORT_LN tables was deleted

Outcomes