SQL Error :: Invalid Object Name

SQL Database Exception Error :: Invalid Object Name

Scenario:

In The scenario below, we are using EXTOL Business Integrator (EBI) 2.x to move database data to another database -- Source: iSeries DB2. Target: Oracle 11g

Issue:

When we attempt to insert data into the Oracle 11g database, we receive an error: Invalid object name

EXTOL error message:


Step #4: Execute Adapter: insert using F4780 Prod Schema

Starting Comm
Invoking Interface Adapter.
Name : insert using F4780 Prod Schema
Version : 1.0
Interaction : Insert
[email protected]
JDBC Resource Adapter is executing a batch with 3158 rows.
SQLException:
Message : Invalid object name 'F4780'.
State : S0002
Error Code : 208
Stack trace: java.sql.BatchUpdateException: Invalid object name 'F4780'.

EXTOL Business Integrator (EBI) SQL Database Exception Error Invalid Object Name

Resolution:

In the EBI Data Source we need to identify the SCHEMA. Once we updated the schema value in the data source, the SQL insert performed without any issues.



By: on
A free web counter provided by GoStats.