› › 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
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.