Load data warehouse fails after Dev data refresh from Prod
search cancel

Load data warehouse fails after Dev data refresh from Prod

book

Article ID: 272926

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Load Data Warehouse job is failing after refreshing the Development environment from Production. The error noticed in the bg-dwh.log is as follows:

ERROR 1947-08-15 01:25:41,658 [dwh_check_slice_info - DWH Time ] dwh.event (clarity:someUser:someSession:Load Data Warehouse) DWH Time  - org.pentaho.di.core.exception.KettleException: 
Expected to read parameters from step [Write Time Info to Log] but none were found.
 at org.pentaho.di.trans.steps.tableinput.TableInput.readStartDate(TableInput.java:85)
 at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:121)
 at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
 at java.base/java.lang.Thread.run(Thread.java:829)

Environment

Release : 16.0.3

Cause

Inaccessible DB objects.

Resolution

All the objects that were created by the migration should be accessible for the DB user defined in the NSA.

Powered by Wolken Software