Announcement

Collapse
No announcement yet.

Error while sending inbound data into OTM

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error while sending inbound data into OTM

    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.

  • #2
    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.
    James Foran
    Toll Global Information Services
    http://www.tollgroup.com

    Comment


    • #3
      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.
      Cheers,
      -Neo

      Comment


      • #4
        Re: Error while sending inbound data into OTM

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

        Comment


        • #5
          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

          Comment


          • #6
            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.
            -------
            Thanks and Regards
            Anurag Saini
            MavenWire

            Comment


            • #7
              Re: Error while sending inbound data into OTM

              Hi Anurag,

              Thank you for reply,
              Last edited by radusumalli; August 15, 2013, 01:59.

              Comment


              • #8
                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>
                -------
                Thanks and Regards
                Anurag Saini
                MavenWire

                Comment


                • #9
                  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

                  Comment


                  • #10
                    Re: Error while sending inbound data into OTM

                    The real problem is the second TransmissionHeader tag inside GLogXMLElement.Second Password is missing too.
                    -------
                    Thanks and Regards
                    Anurag Saini
                    MavenWire

                    Comment


                    • #11
                      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

                      Comment

                      Working...
                      X