Error In Graph After Endeca Upgrade ORA-01722 (Doc ID 2187856.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Endeca Information Discovery Integrator - Version 3.2.0 and later
Information in this document applies to any platform.

Symptoms

An error occurs in a graph following an upgrade/migration to version 3.2. Specifically, the error appears when the component DBINPUT_TABLE is invoked:

ERROR
-----------------------
2016-09-19 14:10:34,438 ERROR 1409036 [JobFinalizer_1409036]
---------------------------------- Error details ------------------------------------
  Component [Automan:AUTOMAN] finished with status ERROR.
  Execution of graph './graph/load_data/Automan.grf' failed!
  Component [DBInputTable:DBINPUT_TABLE] finished with status ERROR. (Out0: 0 recs)
  ORA-01722: número inválido
-------------------------------------------------------------------------------------
2016-09-19 14:10:34,438 INFO 1409036 [JobFinalizer_1409036] Finished Status: ERROR

STEPS
-----------------------
Post migration to version 3.2
1. Edit graph containing DBINPUT_TABLE component
2. Confirm SQL is in it
3. Run the graph

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