none
how to spilt the EDI messages polled from OracleDBBindingPOLLINGSTMT RRS feed

  • General discussion

  • Hi All,

    Scnario:

    Poll the data's from oracle table [container_events]by using  OracleDBBinding "POLLINGSTMT" [add generated items] and save the polled files as EDI CODECO95B [have to apply some business rules on destination schema]

    source schema is "OracleDBBindingPOLLINGSTMT.xsd"

    Destination Schema is EDI "Codeco95B" and save the destination files in local drive.

    container_events table contains more than 100 records.

    Questions:

    1.in mapping, BGM,EQD & LOC segments only mapped[not all elements].so do I need to map all the segments &elements ?

    2.How to Spilt the incoming messages from POLLINGSTMT? I did [schema--> Envelope ='yes']

    3.how to save EDI message for each record in table?

    I am getting the below errors in admin console

    Errors1:

    The adapter "WCF-Custom" raised an error message. Details "System.Runtime.InteropServices.COMException (0xC0C01623): Exception from HRESULT: 0xC0C01623".

    Error2:

    The Messaging engine failed to process a message submitted by adapter:WCF-Custom Source URL:oracledb://XXXXXXXX/.

     Details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

    Please guide me?


    Thanks, Archana



    Thursday, July 4, 2013 10:04 AM

All replies

  • Hi All,

    I need single file for each record in oracle table. I tried with "Flat File" as destination schema that contains the same elements presented in oracle table.so I did the following changes in "OracleDBBindingPOLLINGSTMT.xsd" [refer http://kiranasokan.wordpress.com/2009/04/15/de-batching-polling-records-wcf-oracle-lob-adpter-in-biztalk/]
    steps:
    1.set the envelope = "yes" in <Schema> [OracleDBBindingPOLLINGSTMT.xsd]
    2.selected the "POLLINGSTMT" Record and set the bodyxpath as "/*[local-name()='POLLINGSTMT' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT']/*[local-name()='POLLINGSTMTRECORD' and namespace-uri()='http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT']"

    note:(selected POLLINGSTMT--> POLLINGSTMTRECORD)
    3.created a "ReceivePipeLIne" that refer to the OracleDBBindingPOLLINGSTMT.xsd
       selected "Xml Disassembler"..in that properties selected "Envelope schemas"  as "GetData_From_OracleDb_To_File_Polling statement.OracleDBBindingPOLLINGSTMT+POLLINGSTMT"
    still I am getting the errors
    Error1:
    The adapter "WCF-Custom" raised an error message. Details "System.Runtime.InteropServices.COMException (0xC0C01627): Exception from HRESULT: 0xC0C01627".
    Error2:
    There was a failure executing the receive pipeline: "GetData_From_OracleDb_To_File_Polling_statement.ReceivePipelineFlat, GetData_From_OracleDb_To_File_Polling statement, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a337d2560d01b037" Source: "XML disassembler" Receive Port: "WcfReceivePort_OracleDBBinding_POLLINGSTMT_OperationGroup_Custom" URI: "oracledb://XXXXX/" Reason: Document type

    "http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT#POLLINGSTMTRECORD"

    does not match any of the given schemas.
    please guide me ?

     


    Thanks, Archana

    Friday, July 5, 2013 7:25 AM
  • Hi All,

    in mapping, source schema was wrongly selected..that was causing the problem. Now I am able to get the proper output.

    for splitting:

    1.schema--> Envelope ='yes'

    2.set the body xpath on repeating records.


    Thanks, Archana

    Wednesday, July 10, 2013 1:26 PM