Error while sending inbound data into OTM

[kaavya]

Hi,

I am trying to read a CSV file from BPEL process and invoke WMservlet to insert data into the OTM.We are successfully reading the file and invoking the servlet and inserting into OTM but,if we check in Business Process Automation->Transmission Manager it shows an error. I am not understanding the error what it is .Could you please help me in this regard. Below is the exception that we are getting.

• TransmissionHeader
  • UserName
  • Password
• TransmissionBody
  • GLogXMLElement
    • TransmissionReport
      • TransmissionNo = 13682
      • ReportStatus = ERROR
      • IntegrationLogMessage
        • ILogSeqNo = 2717
        • ITransactionNo = -1
        • WrittenBy = XML_STAGE
        • IMessageClass = I
        • IMessageCode = TRANSMISSION_RECEIVED
        • IMessageText = Transmission 13682 received
        • TimeStamp = 20080513102721
        • DomainName = WIPRO
      • IntegrationLogMessage
        • ILogSeqNo = 2718
        • ITransactionNo = 13960
        • WrittenBy = TRANSACTION_PROCESSOR
        • IMessageClass = E
        • IMessageCode = TRANSACTION_EXCEPTION
        • IMessageText = CAUGHT THE FOLLOWING EXCEPTION WHILE PROCESSING TRANSACTION: java.lang.IllegalStateException: Failed to parse the specified XML java.lang.IllegalStateException: Failed to parse the specified XML at glog.integration.XSDtoJava.XMLInstanceLoader.parse XML(XMLInstanceLoader.java:215) at glog.integration.XSDtoJava.XMLInstanceLoader.load( XMLInstanceLoader.java:139) at glog.integration.tools.XSDtoJavaWrapper.xmlString2 JavaObject(XSDtoJavaWrapper.java:39) at glog.integration.application.TransactionProcessor. getXMLBase(TransactionProcessor.java:497) at glog.integration.application.TransactionProcessor. processTransaction(TransactionProcessor.java:184) at glog.integration.application.TransactionProcessor. processTransaction(TransactionProcessor.java:349) at glog.server.workflow.transproc.TransProc.execute(T ransProc.java:94) at glog.server.workflow.SimpleWorkflow.execute(Simple Workflow.java:23) at glog.server.workflow.WorkflowSessionBean.execute(W orkflowSessionBean.java:64) at glog.server.workflow.WorkflowSessionNonTransServer SideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessi onNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java: 100) at glog.server.workflow.WorkflowManager.execute(Workf lowManager.java:341) at glog.server.workflow.Trigger.trigger(Trigger.java: 111) at glog.util.event.MemoryEventQueueRunnable.processEv ent(MemoryEventQueueRunnable.java:141) at glog.util.event.MemoryEventQueueRunnable.run(Memor yEventQueueRunnable.java:96) at glog.util.event.EventThread.run(EventThread.java:7 9) at java.lang.Thread.run(Thread.java:534)

Thanks in advance.
Kaavya.

[james_foran]

Re: Error while sending inbound data into OTM

Dont know if this will help, but you might get a better message from the I_LOG table. Try the following SQL Script:

SELECT * FROM I_LOG
WHERE I_TRANSMISSION_NO ='13682'


May give you a better description of the error.

[neoandr]

Re: Error while sending inbound data into OTM

Kaavya,
my understanding is that you are sending xml throu integration. IF so have you granted rights in the integration domain to working domain and as well as in your working domain to access integration

I faced similar kind of error which i dont remember, due to access issue.

[chrisp]

Re: Error while sending inbound data into OTM

Malformed XML by the look of it. Can you post a sample XML?

[radusumalli]

Re: Error while sending inbound data into OTM

Hi Kavya,

Did u get solution for that problem, if so kindly share with me. I am facing the same problem.


Thanks
Radusu

[Anurag_Saini]

Re: Error while sending inbound data into OTM

Hi Radusu,

Please check if your xml is correct and is not malformed. Meaning that you are closing all the tags and validating it against GLogxml.xsd schema.

Attach the sample xml generated by BPEL process so that someone can look at it.

[radusumalli]

Re: Error while sending inbound data into OTM

Hi Anurag,

Thank you for reply,

[Anurag_Saini]

Re: Error while sending inbound data into OTM

Hi Radusumalli,

I have noticed a few things in your xml. Like multiple TransmissionHeader tag placement and also no password tag. Try the following xml by changing the password and username accordingly. Delete the first GLogXMLElement which has TransmissionHeader present.

<Transmission xmlns="http://xmlns.oracle.com/apps/otm">
<TransmissionHeader>
<UserName>xxxx.OTMISOPER</UserName>
<Password>abc</Password>
<AckSpec>
<ComMethodGid>
<Gid>
<Xid>EMAIL</Xid>
</Gid>
</ComMethodGid>
<EmailAddress>[email protected]</EmailAddress>
<AckOption>ERROR</AckOption>
</AckSpec>
<Refnum>
<RefnumQualifierGid>
<Gid>
<DomainName>NWCCORP</DomainName>
<Xid>MESSAGE ID</Xid>
</Gid>
</RefnumQualifierGid>
<RefnumValue>175730</RefnumValue>
</Refnum>
<Refnum>
<RefnumQualifierGid>
<Gid>
<DomainName>NWCCORP</DomainName>
<Xid>REFERENCE ID</Xid>
</Gid>
</RefnumQualifierGid>
<RefnumValue>114339_10048395_X129456-S530</RefnumValue>
</Refnum>
</TransmissionHeader>
<TransmissionBody>
<GLogXMLElement>
<Release>

[radusumalli]

Re: Error while sending inbound data into OTM

Hi Anurag,

Thank you for reply,

So, you thought problem with password tags. I will change it and let you know


Thanks,
Radusu

[Anurag_Saini]

Re: Error while sending inbound data into OTM

The real problem is the second TransmissionHeader tag inside GLogXMLElement.Second Password is missing too.

[radusumalli]

Re: Error while sending inbound data into OTM

Hi Anurag,

I got the solution for that. I just added shiptolocation gid in XML file.


Thanks
Radusumalli