› › Null DatabaseURL - Error Opening Connection to DriverID

Null DatabaseURL - Error Opening Connection to DriverID

Scenario:

An inbound JDE transformation is being performed and the ruleset being used calls a SQL Select Action. During the transformation an error occurs that causes Null DatabaseURL Error

Issue:

Right before the EBI transformation was execute, the EXTOL Business Integrator DataSource was updated to remove the Database Schema value. This value was removed because it was being referenced in the SQL Select statement

EXTOL error message:


Step #4: Execute Transformation - Single Output

Starting Transform
Starting Transformation Engine
Executing "JDE_To_JDE_Ruleset / version 1.0"
AS400_Addr_Book_Get_Div_Action: Error opening connection to DriverID: null DatabaseURL: null Error is: null
AS400_Addr_Book_Get_Div_Action: The connection to DriverID: null DatabaseURL: null is null.
Transformation ended in error, please refer to the information on the Translation Messages Tab.
Ending Transformation Engine
Completed Task.

Resolution:

After re-inserting the JDEdwards Schema/Environment name (CRPDTA) the SQL Action executed without any issues.



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.