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
com.extol.logging.framework.storage.LogStorageNode@e68e77fa
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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.