Database Select with Select Criteria Causes Illegal Argument of type -2 value
Scenario: Outbound EDI x12 850
Source:JDE World tables F47016/F47017/F4714/F4706
Target:x12 850
Issue:
Initally we were able to create outbound 850 x12 data however when we applied the Selection Criteria to the Binding -- F47016.EDSP = ' ', errors occurred.
EXTOL error message:
Server log in WARNING mode
ERROR [com.extol.adapters.jdbc.JDBCInteraction] Standard Exception occurred: Exception occurred: Illegal argument of type -2 value 25181
Exception detail:
com.extol.util.message.StandardException: Exception occurred: Illegal argument of type -2 value 25181
at java.lang.Thread.run(Thread.java:738)
Caused by: java.lang.IllegalArgumentException: Illegal argument of type -2 value 25181
at com.extol.adapters.jdbc.JDBCTypeMap.getSqlTypeByStringValue(JDBCTypeMap.java:638)
at com.extol.adapters.jdbc.JDBCInteraction.a(JDBCInteraction.java:1802)
... 39 more
Caused by: java.lang.Exception: The value "25181" is not a valid UTF-8 hexadecimal value.
at com.extol.util.ByteArrayToHexString.cvHexStrToByteArr(ByteArrayToHexString.java:51)
at com.extol.adapters.jdbc.JDBCTypeMap.getSqlTypeByStringValue(JDBCTypeMap.java:513)
... 40 more
Server log in DEBUG mode
<<---------------------------------------->>
<<---- BEGIN PROCESS DATABASE RECORDS ---->>
<<---------------------------------------->>
Invocation level: 2
Parent record:F4714<--
Current file:F4714<--
Current record:F4714<--
SQL Statement: SELECT "ZTEDTY","ZTEDSQ","ZTEKCO","ZTEDOC","ZTEDCT","ZTEDLN","ZTEDSP","ZTEDBT","ZTFILE","ZTKCOO","ZTDOCO","ZTDCTO","ZTLNID","ZTPNTC","ZTLINS","ZTTXLN","ZTTORG","ZTUSER","ZTPID","ZTJOBN","ZTUPMJ","ZTTDAY" FROM "CRPDATA"."F4714" WHERE "ZTEKCO"=? AND "ZTEDOC"=? AND "ZTEDCT"=? ORDER BY "ZTEDLN" ASC , "ZTFILE" ASC , "ZTLINS" ASC <--
ERROR [com.extol.adapters.jdbc.JDBCInteraction] Illegal argument of type -2 value 25181
Exception detail:
java.lang.IllegalArgumentException: Illegal argument of type -2 value 25181
Resolution:
Based on the logs and assistance from EXTOL Support/Development, we determined that the Source Schema alpha fields needed to be updated to 'Char'. When we initally tested the alpha fields were 'Binary'.
By: Sean Hoppe on
