Hi Suman, this is the file bg-dwh of that date...
Please you see my last response to Shubham about the sentence admin...
thank you in advance
INFO 2017-05-03 15:45:14,464 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event Job Parameters
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event SRC_DATABASE_URL: jdbc:clarity:sqlserver://NXPPMLAB;DatabaseName=niku;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event SRC_DATABASE_CLASS: com.ca.clarity.jdbc.sqlserver.SQLServerDriver
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event SRC_DATABASE_USER: niku
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event TGT_DATABASE_URL: jdbc:clarity:sqlserver://NXPPMLAB;DatabaseName=ppm_dwh;InsensitiveResultSetBufferSize=0;ProgramName=Clarity
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event TGT_DATABASE_CLASS: com.ca.clarity.jdbc.sqlserver.SQLServerDriver
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event TGT_DATABASE_USER: ppm_dwh
INFO 2017-05-03 15:45:14,465 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event CLARITY_DB_TYPE: mssql
INFO 2017-05-03 15:45:14,466 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event DWH_DB_TYPE: mssql
INFO 2017-05-03 15:45:14,466 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event SRC_DBNAME: niku
INFO 2017-05-03 15:45:14,466 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event DB_LINK: PPMDBLINK
INFO 2017-05-03 15:45:15,133 [Thread-45] dwh.event dwh_etl_master - Start of job execution
ERROR 2017-05-03 15:45:15,330 [Thread-45] dwh.event dwh_db_check_ - An error occurred executing this job entry :
Couldn't execute SQL: TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE;
EXEC DWH_CFG_PRE_CONFIG_SP 'PPMDBLINK.niku.niku', 'Y'
[CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_CMN_ERROR_MESSAGE" because it does not exist or you do not have permissions.
INFO 2017-05-03 15:45:15,347 [Thread-45] dwh.event dwh_etl_master - Job execution finished
ERROR 2017-05-03 15:45:15,367 [Dispatch Load Data Warehouse : bg@NXPPMLAB (tenant=clarity)] dwh.event ETL Job Failed. Log details below:
2017/05/03 15:45:15 - dwh_db_check_ - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry :
2017/05/03 15:45:15 - dwh_db_check_ - Couldn't execute SQL: TRUNCATE TABLE DWH_CMN_ERROR_MESSAGE;
2017/05/03 15:45:15 - dwh_db_check_ - EXEC DWH_CFG_PRE_CONFIG_SP 'PPMDBLINK.niku.niku', 'Y'
2017/05/03 15:45:15 - dwh_db_check_ -
2017/05/03 15:45:15 - dwh_db_check_ - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_CMN_ERROR_MESSAGE" because it does not exist or you do not have permissions.
null