JDE/One World DB2 SQL error: Null Connection Error

JDE/One World DB2 SQL error: Null Connection Error


Scenario:

Inbound EDI x12 856 transmission is received and translated into JDEdwards One World DB2 tables (F47031/F4706/F47032)

Issue:

We are trying to translate the data in F47031/F4706/F47032 however there is an null field error. The JDBC generated error does not indicate the table or field.

EXTOL error message:


SQL exception error while attempting to perform SQL insert -- [SQL0407] Null values are not allowed in column or variable

EXTOL EBI SQL Insert Error Null Value with Execute1111 Adapter

Resolution:

In the EBI Auditor we did a search for '><'. When we performed the search, like the example below, we were able to find where there was a null value being passed.

EXTOL EBI Auditor Search Source Data for Null Data

By: on
A free web counter provided by GoStats.