Nested Runtime Exception Error

Nested Runtime Exception Error :: AddWriter Owner Already Existed

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:


INFO [STDOUT] org.jboss.util.NestedRuntimeException: addWriter(): owner already existed; - nested throwable: (java.lang.IllegalStateException: addWriter(): owner already existed)
INFO [STDOUT] at org.jboss.cache.TreeCache.invokeMethod(TreeCache.java:3107)
INFO [STDOUT] at org.jboss.cache.TreeCache.evict(TreeCache.java:1781)

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.