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)
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: Sean Hoppe on