Database Select with Select Criteria Causes Illegal Argument

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: on
A free web counter provided by GoStats.