Clarify Scenario:

During an outbound EDI process, we are querying a database to retrieve outbound ASN data.

Clarify Issue:

During the SQL select we incur a Null Pointer Exception Error when the SQL Select Database Adapter is called in the Business Process

Server Error:

Auditor:

Step 4: Execute Adapter: com.abc.core.database.bindings.Ob856DataBindingDBA$Imported_Select
Step Messages:
2017-02-19 13:20:58,848 [PERSISTENT] - Starting com.extol.processtasks.engine2.tasks.CommEngineTask@b74c7e4
2017-02-19 13:20:58,848 [PERSISTENT] - Invoking Interface Adapter.
2017-02-19 13:20:58,848 [PERSISTENT] - Name : com.abc.core.database.bindings.Ob856DataBindingDBA$Imported_Select
2017-02-19 13:20:58,848 [PERSISTENT] - Version : Deployed
2017-02-19 13:20:58,848 [PERSISTENT] - Interaction: Select
2017-02-19 13:21:19,909 [ERROR] - No database connection created at jdbc:oracle:thin:@DB05:1521:USE1PY. Verify that the Data Source settings are correct.
2017-02-19 13:21:19,909 [ERROR] - Error executing adapter : null
2017-02-19 13:21:19,909 [ERROR] - java.lang.NullPointerException
2017-02-19 13:21:19,909 [ERROR] - Error executing adapter - 2
2017-02-19 13:21:19,909 [ERROR] - java.lang.ArrayIndexOutOfBoundsException: 2
2017-02-19 13:21:19,909 [PERSISTENT] - Ending Interface Adapter invocation.
2017-02-19 13:21:19,909 [PERSISTENT] - Completed Task.

Clarify Resolution:

Clarify users will want to contact the DBA (Database Administrator) to confirm the database is active and network connections are active.