The Depot Repair Endeca Incremental Graph Fails With Error: CSD_EID_REPAIRS_V contains less fields than source JDBC record

(Doc ID 2385202.1)

Last updated on APRIL 11, 2018

Applies to:

Oracle Depot Repair - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 Endeca Integration (v5 and lower)

When attempting to run the Incremental load for Endeca, the following error occurs.

ERROR
-----------------------
2018-02-28 06:40:34,572 ERROR 2087665  Graph execution finished with error
2018-02-28 06:40:34,573 ERROR 2087665 Node CSD_EID_REPAIRS_V_INCREMENTAL1 finished with status: ERROR caused by: CloverETL data record CSD_EID_REPAIRS_V contains less fields than source JDBC record !
2018-02-28 06:40:34,573 ERROR 2087665  Node CSD_EID_REPAIRS_V_INCREMENTAL1 error details:
java.lang.RuntimeException: CloverETL data record CSD_EID_REPAIRS_V contains less fields than source JDBC record !
  at org.jetel.connection.jdbc.CopySQLData.sql2JetelTransMap(CopySQLData.java:269)
  at org.jetel.connection.jdbc.SQLDataParser.initSQLMap(SQLDataParser.java:263)
  at org.jetel.connection.jdbc.SQLDataParser.parseNext(SQLDataParser.java:178)
  at org.jetel.connection.jdbc.SQLDataParser.getNext(SQLDataParser.java:114)
  at org.jetel.component.DBInputTable.processSqlQuery(DBInputTable.java:343)
  at org.jetel.component.DBInputTable.execute(DBInputTable.java:292)
  at org.jetel.graph.Node.run(Node.java:453)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
  at java.lang.Thread.run(Thread.java:722)
2018-02-28 06:40:34,585 ERROR 2087665  !!! Phase finished with error - stopping graph run !!!


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. submit the incremental load program.


Changes

 The problem started after applying 23149012:R12.CSD.B

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms