Data Is Not Imported When the XML File Uses 'UI' (Doc ID 1073220.1)

Symptoms

On OTM 5.5.06.06 when loading a Location using code of UI the error below occurs, this does not arise when using IU.

However the OTM Integration Guide states that 'UI' works the same as 'IU'.


ERROR
-----------------------
Error Exception java.lang.NullPointerException

java.lang.NullPointerException
at glog.util.persistence.InsertUpdate.dispatchPersistenceService(InsertUpdate.java:255)
at glog.util.persistence.InsertUpdate.iteratePersistence(InsertUpdate.java:170)
at glog.util.persistence.InsertUpdate.iteratePersistence(InsertUpdate.java:188)
at glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:71)


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

1 - Log onto an OTM 5.5.06 system.

2 - Navigate to: Business Process Automation > Integration > Integration Manager > Upload an XML/CSV Transmission

3 - Select file LJS_XML_with_TransactionCode_UI.xml

4 - Note this file is set to use UI.

5 - Load the file.

6 - The transmission fails, the transmission number is 707416 and the log contains:

Log Viewer


Log Search
CurrentAllOther

Time Process Severity ID System Log
2010-03-05 12:32:21.539 266153 Debug RMIConnections Changing user role: null to ADMIN [ExecuteThread: '48' for q]
2010-03-05 12:32:21.617 266153 Debug Workflow Starting workflow New XML Transmission (23045295) in response to NewXmlTopic: transmission=707416 [integration - 1]
2010-03-05 12:32:21.632 266153 Debug Workflow Publishing topic Transaction Processor: transactionNo=730665 [Location ] on queue publishWait, group null [integration - 1]
2010-03-05 12:32:21.633 266153 Debug Workflow Completing workflow New XML Transmission (23045295) [integration - 1]
2010-03-05 12:32:21.636 266153 Debug Workflow Starting workflow Simple Workflow (26300717) in response to Transaction Processor: transactionNo=730665 [Location ] [publishWait - 1]
2010-03-05 12:32:21.644 266153 Debug RMIConnections Changing user role: null to ADMIN [publishWait - 1]
2010-03-05 12:32:21.69 266153 Error Exception java.lang.NullPointerException

java.lang.NullPointerException
at glog.util.persistence.InsertUpdate.dispatchPersistenceService(InsertUpdate.java:255)
at glog.util.persistence.InsertUpdate.iteratePersistence(InsertUpdate.java:170)
at glog.util.persistence.InsertUpdate.iteratePersistence(InsertUpdate.java:188)
at glog.util.persistence.InsertUpdate.persist(InsertUpdate.java:71)
at glog.util.persistence.PersistenceManager.execute(PersistenceManager.java:121)
at glog.server.compareengine.TopicPublisher.persist(TopicPublisher.java:161)
at glog.server.compareengine.TopicPublisher.publish(TopicPublisher.java:64)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:109)
at glog.server.compareengine.CompareEngine.compare(CompareEngine.java:70)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compare(GenericContainerUtilSessionBean.java:139)
at glog.util.genericcontainer.GenericContainerUtilSessionBean.compareAndStore(GenericContainerUtilSessionBean.java:76)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper.java:136)
at glog.util.genericcontainer.GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.compareAndStore(GenericContainerUtilSessionServerSideEJBWrapper_6hrtm7_EOImpl.java:532)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persist(XmlBaseWrapper.java:211)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:294)
at glog.integration.application.location.LocationInterface.persistIndivXML(LocationInterface.java:97)
at glog.integration.application.location.LocationInterface.persistXML(LocationInterface.java:85)
at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:185)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:210)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:349)
at glog.server.workflow.transproc.TransProc.execute(TransProc.java:94)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:100)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:341)
at glog.server.workflow.Trigger.trigger(Trigger.java:123)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:141)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:96)
at glog.util.event.EventThread.run(EventThread.java:82)
at java.lang.Thread.run(Thread.java:534)
[publishWait - 1]
java.lang.NullPointerException
2010-03-05 12:32:21.7 266153 Debug RMIConnections Changing user role: null to ADMIN [publishWait - 1]
2010-03-05 12:32:21.724 266153 Debug Workflow Completing workflow Simple Workflow (26300717) [publishWait - 1]
2010-03-05 12:32:21.725 266153 Debug Workflow Publishing topic PostTransmission: user=LEE.ADMIN, transmissionId=707,416 on queue integrationOutbound, group null [publishWait - 1]
2010-03-05 12:32:21.728 266153 Debug Workflow Starting workflow Simple Workflow (26974951) in response to PostTransmission: user=LEE.ADMIN, transmissionId=707,416 [integrationOutbound - 1]
2010-03-05 12:32:21.732 266153 Debug RMIConnections Changing user role: null to ADMIN [integrationOutbound - 1]
2010-03-05 12:32:21.738 266153 Debug Workflow Completing workflow Simple Workflow (26974951) [integrationOutbound - 1]

Page 1 Previous Next Return


7 - Navigate to: Business Process Automation > Integration > Integration Manager > Upload an XML/CSV Transmission

8 - Selecte file LJS_XML_with_TransactionCode_IU.xml

9 - Note this file is set to use IU.

10 - The transmission number is 707417 and was processed successfully.

Cause

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