2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 -  STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_TRD_INV_APPLICATION
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 - DWH_TRD_INV_APPLICATION - Job Log: 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - null
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 -  STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_TRD_INV_APPLICATION_LN
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 - DWH_TRD_INV_APPLICATION_LN - Job Log: 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - null
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 -  STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_TRD_INV_ASSET
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 - DWH_TRD_INV_ASSET - Job Log: 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - null
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 -  STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_TRD_INV_ASSET_LN
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 - DWH_TRD_INV_ASSET_LN - Job Log: 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - null
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 -  STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_TRD_INV_FISCAL_FACTS
2020/04/07 10:48:01 - User Defined Java Class.0 -  
2020/04/07 10:48:01 - User Defined Java Class.0 - *****************************************************************
2020/04/07 10:48:01 - User Defined Java Class.0 - DWH_TRD_INV_FISCAL_FACTS - Job Log: 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : An error occurred executing this job entry : 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - Couldn't execute SQL: CMN_DISABLE_CONSTRAINTS_SP 'DWH_TRD_INV_FISCAL_FACTS'
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - 
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - ClarityDB - isOracle? - [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot find the object "DWH_TRD_INV_FISCAL_FACTS" because it does not exist or you do not have permissions.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:41:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [0]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail(MSSQL) - Loading transformation from XML file [file:///I:/CAPPM/META-INF/datamart/etl_scripts/dwh_trending/dwh_trd_cmn_jobs/dwh_trd_pre_detail_mssql.ktr]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - dwh_trd_pre_detail_mssql - Dispatching started for transformation [dwh_trd_pre_detail_mssql]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Get Trend Start Date.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Setting environment variables...
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Set variable NEEDS_TRENDED to value [1]
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Verify Table Needs Trended.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished after 1 rows.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Needs Trended Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished reading query, closing connection.
2020/04/07 10:48:01 - User Defined Java Class.0 - 2020/04/07 10:48:01 - Update Trend Detail(MSSQL).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2020/04/07 10:48:01 - User Defined Java Class.0 - null
2020/04/07 10:48:01 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Unexpected error
2020/04/07 10:48:01 - User Defined Java Class.0 - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_TRD_INV_FISCAL_FACTS
2020/04/07 10:48:01 - User Defined Java Class.0 - 	at Processor.processRow(Processor.java:64)
2020/04/07 10:48:01 - User Defined Java Class.0 - 	at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)
2020/04/07 10:48:01 - User Defined Java Class.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
2020/04/07 10:48:01 - User Defined Java Class.0 - 	at java.base/java.lang.Thread.run(Thread.java:834)
2020/04/07 10:48:01 - dwh_trd_populate_tables - dwh_trd_populate_tables
2020/04/07 10:48:01 - dwh_trd_populate_tables - dwh_trd_populate_tables
2020/04/07 10:48:01 - dwh_trd_populate_tables - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : Errors detected!
null