Load data warehouse Full load failing at DWH_CMN_PERIOD table.
search cancel

Load data warehouse Full load failing at DWH_CMN_PERIOD table.

book

Article ID: 248901

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

After copy of Production data to Dev, DWH Full load and incremental loads are failing.

 

Environment

Release : 16.0.0

Component : PPMDWH

Cause

INFO  [dwh_mssql_error_handling UUID: e50ba692-bbcb-4c1c-a48a-f7d43c49b5ab] dwh.event Error for table 'DWH_CMN_PERIOD' - Error Number 102 'Incorrect syntax near '$.s'.' 

dwh.event DWH_DIM_LOAD - Job execution finished
ERROR [dwh_etl_interface_dim - User Defined Java Class] dwh.event User Defined Java Class - Unexpected error
ERROR [dwh_etl_interface_dim - User Defined Java Class] dwh.event User Defined Java Class - java.lang.RuntimeException: ERROR: THERE WERE ERRORS DURING DIMENSION JOB EXECUTION FOR THE TABLE - DWH_CMN_PERIOD
 at Processor.processRow(Unknown Source)
 at org.pentaho.di.trans.steps.userdefinedjavaclass.UserDefinedJavaClass.processRow(UserDefinedJavaClass.java:1019)
 at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
 at java.base/java.lang.Thread.run(Thread.java:829)

Resolution

  1. This issue is caused by incorrect compatibility level on the Database.
  2. Ensure that the compatibility level is set to 140 on MSSQL Server 2017 and 150 on MSSQL Server 2019.
Powered by Wolken Software