AnsweredAssumed Answered

Data Warehouse Load Failure

Question asked by CMCN1982 on Apr 24, 2015
Latest reply on May 11, 2015 by CMCN1982

Hi guys,

 

our first attempts to load our data warehouse have failed. In the job logs the following is displayed:

 

Job Started 4/20/15 5:34 PM 

 

 

Error 4/20/15 5:37 PM dwh_db_check_ - An error occurred executing this job entry :

Couldn't execute SQL: DECLARE @V_SQL_TEXT nvarchar(max);

 

 

BEGIN

  SET @V_SQL_TEXT = 'select BENEFITPLAN_KEY, BENEFITPLAN_NAME, BILLING_CURRENCY_CODE, CHARGE_CODE_ID_CAPTION, CHARGE_CODE_KEY, CLARITY_CREATED_DATE, CLARITY_PLAN_DETAIL_KEY, CLARITY_PLAN_KEY, CLARITY_UPDATED_DATE, COST_TYPE_KEY, DEPARTMENT_ID_CAPTION, DEPARTMENT_KEY, DESCRIPTION, FIN_PLAN_TYPE_KEY, FINISH_PERIOD_KEY, FISCAL_PERIOD_TYPE_KEY, HOME_CURRENCY_CODE, INPUT_TYPE_CODE_ID_CAPTION, INPUT_TYPE_CODE_KEY, INVESTMENT_KEY, IS_PLAN_OF_RECORD, LOCATION_ID_CAPTION, LOCATION_KEY, PLAN_DETAIL_KEY, PLAN_FINISH_DATE, PLAN_ID, PLAN_KEY, PLAN_NAME, PLAN_START_DATE, RESOURCE_CLASS_ID_CAPTION, RESOURCE_CLASS_KEY, RESOURCE_KEY, RESOURCE_ID_CAPTION, ROLE_KEY, ROLE_ID_CAPTION, START_PERIOD_KEY, TRANSACTION_CLASS_ID_CAPTION, TRANSACTION_CLASS_KEY, USER_VALUE1_KEY, USER_VALUE2_KEY, CONVERT(DATETIME ,''2015-04-20 12:36:51'') as dw_updated_date  from [PPMDBLINK].niku.niku.DWH_COSTPLAN_V where CLAR

 

 

 

Error 4/20/15 5:37 PM User Defined Java Class - Unexpected error

 

 

Error 4/20/15 5:37 PM User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_FIN_PLAN

  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)

 

 

 

Error 4/20/15 5:37 PM dwh_etl_interface_dim - Errors detected!

 

 

Error 4/20/15 5:37 PM dwh_etl_interface_dim - Errors detected!

 

 

Error 4/20/15 5:37 PM ETL Job Failed. Please see log bg-dwh.log for details.

 

 

Job Completed 4/20/15 5:37 PM NJS-0401: Execution of job failed.

 

Has anyone else encountered similar?

Outcomes