Duplicate in DWH_SETTINGS causes Load Data Warehouse to fail

book

Article ID: 208296

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

Issue/Introduction

Load Data Warehouse fails with error:

INFO  2021-02-10 16:19:05,981 [Thread-10] dwh.event dwh_etl_master - Start of job execution
ERROR 2021-02-10 16:19:06,147 [dwh_check_slice_info_pg - Set Slice Information] dwh.event Set Slice Information - Unexpected error
ERROR 2021-02-10 16:19:06,149 [dwh_check_slice_info_pg - Set Slice Information] dwh.event Set Slice Information - org.pentaho.di.core.exception.KettleStepException: 
Only 1 input row was expected to set the variables and at least 2 were received.

 at org.pentaho.di.trans.steps.setvariable.SetVariable.processRow(SetVariable.java:101)
 at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
 at java.base/java.lang.Thread.run(Thread.java:834)

Environment

Release : Any

Component : 

Resolution

This is caused by a duplicate in DWH_SETTINGS table. 

Work with DBA to delete the duplicate.