AnsweredAssumed Answered

Load Data Warehouse job fails with error message

Question asked by Piyush_Agrawal on Nov 3, 2017
Latest reply on Nov 9, 2017 by Piyush_Agrawal

We are running Load Data Warehouse job for the first time in 14.3 environment, but, the job is failing with below errors :

 

User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_FIN_TRANSACTION      at Processor.processRow(Processor.java:64)      at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1181)      at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)      at java.lang.Thread.run(Thread.java:745) User Defined Java Class - Unexpected error
dwh_etl_interface_dim - Errors detected!
dwh_db_check_ - An error occurred executing this job entry :
Couldn't execute SQL: DECLARE
 TYPE DIM_REC IS RECORD (BATCH_NUMBER NUMBER(32), CHARGE_CODE VARCHAR2(96), CHARGE_CODE_KEY INTEGER, CLARITY_CREATED_DATE DATE, CLARITY_TRANSACTION_KEY NUMBER(32), LAST_UPDATED_DATE DATE, COMPANY_KEY INTEGER, COMPANY_NAME VARCHAR2(128), COST_TYPE_KEY VARCHAR2(30), DOCUMENT_TYPE_KEY NUMBER(32), ENTITY VARCHAR2(120), ENTITY_KEY INTEGER, EXTERNAL_BATCH_ID VARCHAR2(20), EXTERNAL_TRANSACTION_ID NUMBER(32), INCURRED_BY VARCHAR2(300), INCURRED_BY_KEY INTEGER, INPUT_TYPE_CODE VARCHAR2(96), INPUT_TYPE_CODE_KEY NUMBER(32), INVESTMENT_CLASS VARCHAR2(90), INVESTMENT_CLASS_KEY INTEGER, INVESTMENT_DEPARTMENT VARCHAR2(360), INVESTMENT_DEPARTMENT_KEY INTEGER, INVESTMENT_ID VARCHAR2(60), INVESTMENT_KEY INTEGER, INVESTMENT_LOCATION VARCHAR2(360), INVESTMENT_LOCATION_KEY INTEGER, INVESTMENT_NAME VARCHAR2(240), INVOICE_NUMBER VARCHAR2(16), NOTES VARCHAR2(255), PO_NUMBER VARCHAR2(30), RESOURCE_CLASS VARCHAR2(360), RESOURCE_CLASS_KEY INT

Cant see any related error in bg-ca logs.

Attachments

Outcomes