My Oracle Support Banner

Error For Shipment Agent On Generating Refnum via BNRULE java.lang.NullPointerException at glog.util.jdbc.GC3Hints.<init>(GC3Hints.java:16) (Doc ID 1144727.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Transportation Management - Version 6.0.5 to 6.1.3 [Release 6 to 6.1]
Information in this document applies to any platform.

Symptoms

On OTM version 6.0.5 .

When attempting to Generate shipments refnums via BNRULE (Business Number Rule) using a shipment automation agent that triggers on "Shipment Status - Received" event, the following error occurs.

ERROR
-----------------------

<DATE TIME> <VALUE> Error Exception java.lang.NullPointerException

java.lang.NullPointerException
at glog.util.jdbc.GC3Hints.<init>(GC3Hints.java:16)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:82)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:104)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:117)
at glog.server.agent.utility.GenerateRefnum.execute(GenerateRefnum.java:46)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:52)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionServerSideEJBWrapper.execute(WorkflowSessionServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.execute(WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.java:352)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:347)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:142)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96)
at glog.util.event.EventThread.run(EventThread.java:83)
at java.lang.Thread.run(Thread.java:595)
agentUtility - 4
<DATE TIME> <VALUE> Debug Agent Agent <NAME>.REFNUM-BNRULE (<VALUE>) received error 18497/CLOSE/Process Agent:
java.lang.NullPointerException

java.lang.NullPointerException
at glog.util.jdbc.GC3Hints.<init>(GC3Hints.java:16)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:82)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:104)
at glog.util.jdbc.SqlUpdate.execute(SqlUpdate.java:117)
at glog.server.agent.utility.GenerateRefnum.execute(GenerateRefnum.java:46)
at glog.server.agent.ActionWorkflow.execute(ActionWorkflow.java:52)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionServerSideEJBWrapper.execute(WorkflowSessionServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.execute(WorkflowSessionServerSideEJBWrapper_61kh96_EOImpl.java:352)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:347)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:142)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96)
at glog.util.event.EventThread.run(EventThread.java:83)
at java.lang.Thread.run(Thread.java:595)
agentUtility - 4
<DATE TIME> <VALUE> Error Exception Agent <NAME>.REFNUM-BNRULE failed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create custom of Status Type and Value for Shipment Object
2. Configure Custom Shipment Events Status Codes.
3. Configure Event Group.
4. Configure an Agent to listen for Shipment Status Received to trigger an action for Generating Refnum via BNRULE.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.