AnsweredAssumed Answered

Data warehouse load job failed without error message

Question asked by matej256 on Nov 21, 2017
Latest reply on Nov 29, 2017 by matej256

Hi All, 

 

Have you ever met with issue that DWH job failed without any error message? Our Niku and DWH databases are available also with PPMDWH db link. Data warehouse db is accessible through SQL developer. However, when started DWH load job, it failed immediately. In our bg-dwh logs is only following in spite of we have log for "dwh" set to trace and also enabled tracing jobs:

 

INFO 2017-11-21 14:47:09,604 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event Job Parameters
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event SRC_DATABASE_URL: jdbc:clarity:oracle://dedusfpora01.xxxxxxxxxx.net:1532;SID=PPMDEV;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event SRC_DATABASE_CLASS: com.ca.clarity.jdbc.oracle.OracleDriver
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event SRC_DATABASE_USER: niku
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event TGT_DATABASE_URL: jdbc:clarity:oracle://dedusfpora01.xxxxxxxxxxx.net :1532;SID=PPMDEVDWH;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxxxnet (tenant=clarity)] dwh.event TGT_DATABASE_CLASS: com.ca.clarity.jdbc.oracle.OracleDriver
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxx.net (tenant=clarity)] dwh.event TGT_DATABASE_USER: PPM_DWH
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxxx.net (tenant=clarity)] dwh.event CLARITY_DB_TYPE: oracle
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxxx.net (tenant=clarity)] dwh.event DWH_DB_TYPE: oracle
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxxx.net (tenant=clarity)] dwh.event SRC_DBNAME: PPMDEV
INFO 2017-11-21 14:47:09,605 [Dispatch Load Data Warehouse 2 : bg@dedussv-sjsdevxxxxxxxxxx.net (tenant=clarity)] dwh.event DB_LINK: PPMDBLINK


Do you know how we can get to the error in background or what else we can check? 

 

Thanks,

Matej

Attachments

Outcomes