SQL Database Insert Error :: Illegal Argument Exception of Type 2 Value 0
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
We are not erroring on each record being translated, just a few of them.
Issue:
Based on the error below, we are finding that the Source field : AXUPMJ is coded as alpha numeric. Because it is alpha numeric, spaces are allowed. The Target field (AXUPMJ) is coded as numberic.
When we try to move data over the data will error because spaces are not allowed and we are trying to transfer "0 " into the Target field (AXUPMJ)
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@47f5c570
JDBC Resource Adapter encountered an Illegal Argument Exception while attempting to set the AXUPMJ column in row 0 to the value "0 " while inserting data into the table "F4780".
Illegal argument of type 2 value 0
JDBC Resource Adapter received a Standard Exception: Error adding row to database. Exiting process. . . .
JDBC Resource Adapter received a Standard Exception while attempting to INSERT: JDBC Resource Adapter received a Standard Exception: Error adding row to database. Exiting process. . . .
Execution of Adapter ended in error.
Ending Interface Adapter invocation.
Completed Task.
Resolution:
To resolve this issues, we will need to make a ruleset update to capture the spaces and remove them. Otherwise we will need to update the Source data.
By: Sean Hoppe on
