LOAD DATAWAREHOUSE JOB FAILS

[Wilson Cardenas]

Hello everyone, I currently restored a productive server to start the migration process but I am having problems with the loading of the job load datawarehouse I get the following error.

2021/12/02 08:04:03 - User Defined Java Class.0 - STARTING EXECUTION FOR THE DIMENSION TABLE - DWH_ODF_HIEV_VIEWS
2021/12/02 08:04:03 - User Defined Java Class.0 -
2021/12/02 08:04:03 - User Defined Java Class.0 - *****************************************************************
2021/12/02 08:04:04 - User Defined Java Class.0 - DWH_ODF_HIEV_VIEWS - Job Log: 2021/12/02 08:03:31 - dwh_mssql_error_handling - Starting entry [MSSQL?]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Starting entry [Get Error Variables]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Get Error Variables - Loading transformation from XML file [file:///E:/APPS/ppm/META-INF/datamart/etl_scripts/dwh_cmn_etl_jobs/dwh_mssql_error_occurred.ktr]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_occurred - Dispatching started for transformation [dwh_mssql_error_occurred]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count.0 - Finished reading query, closing connection.
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count Variable.0 - Setting environment variables...
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Message.0 - Finished reading query, closing connection.
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count Variable.0 - Set variable ERROR_COUNT to value [0]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count Value.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count Variable.0 - Finished after 1 rows.
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Message Variables.0 - We didn't receive a row while setting the default values.
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Count Variable.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Message Variables.0 - Set variable ERROR_NUMBER to value [0]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - Error Message Variables.0 - Finished after 0 rows.
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Starting entry [No Errors?]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Starting entry [Success 2]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Finished job entry [Success 2] (result=[true])
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Finished job entry [No Errors?] (result=[true])
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Finished job entry [Get Error Variables] (result=[true])
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:31 - dwh_mssql_error_handling - Finished job entry [MSSQL?] (result=[true])
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:33 - dwh_mssql_error_handling - Starting entry [MSSQL?]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:33 - dwh_mssql_error_handling - Starting entry [Get Error Variables]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:03:33 - Get Error Variables - Loading transformation from XML file

Attachment(s)

bg-dwh.log   9.34 MB 1 version

[Nika Hadzhikidi]

Hi Wilson

This is the error:

2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:04:04 - Error Message Variables.0 - Set variable TABLE_NAME to value [DWH_ODF_HIEV_VIEWS]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:04:04 - Error Message Variables.0 - Set variable ERROR_MESSAGE to value [In_valid  column name 'CLARITY_CREATED_DATE'.]
2021/12/02 08:04:04 - User Defined Java Class.0 - 2021/12/02 08:04:04 - Error Message Variables.0 - Set variable ERROR_NUMBER to value [207]

Is your Clarity database and the DWH database the same version? You can check by running:
on Clarity
select * from cmn_install_history order by installed_date desc
on DWH
select * from cmn_dwh_install_history order by installed_date desc 
The versions must match. If a column is missing, consider creating a blank DWH database from backup in $clarity/database/backups, recreating the link and trying again.

Hope this helps -Nika 


------------------------------
Nika Hadzhikidi
Sr Principal Support Engineer
Broadcom
------------------------------