Clarity

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

The bg-dwh.log already gets filled completely with a single execution of the DWH job. So, I am wondering if setting the logging level at "Trace" is resulting in the error logs getting flooded out..

Do any errors get logged if you change the logging level to "Error" or "Info"..?

Hi Jeevan,

that's the strange that any error message didn't show at logs. However with John's and your help we found it when opened Jobs -> Logs -> Clicked on Load DWH job name:

Then followed Nika's tip and our job finished successfully. Thanks to both!

Matej

Hi,

Could you check "Data Warehouse Options" in Administration->System Options.

 Languages, Entity are defined correctly?

For example, 

Thank you.

Hi, 

No, entity was defined correctly. Problem was with the fin plan periods as stated above. 

Matej