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 09, 2014

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
-----------------------
2010-06-16 05:00:53.738 653343 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
2010-06-16 05:00:53.741 653343 Debug Agent Agent IBAHGAT.REFNUM-BNRULE (116668509) 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
2010-06-16 05:00:53.741 653343 Error Exception Agent IBAHGAT.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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms