none
Biztalk Oracle Adapter Insert Message Error RRS feed

  • Question

  • I get this error trying to insert

     "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "Pipeline " Receive Port: "ReceivePort1" URI: "C:\TestLocation\MessageInMisc\*.xml" Reason: An error occurred when parsing the incoming document: "'>' is an unexpected token. The expected token is '='. Line 3, position 42.".  


    this is my insert message..where is the error??i am using the microsoft example...


    <Insert xmlns="http://Microsoft.LobServices.OracleDB/2007/03/INV/Table/MTL_TRANSACTIONS_INTERFACE">
    <RECORDSET>
     <mtl_transactions_interface RECORDINSERT>

      <SOURCE_CODE>Test</SOURCE_CODE>
      <SOURCE_LINE_ID>01</SOURCE_LINE_ID>
      <SOURCE_HEADER_ID>01</SOURCE_HEADER_ID>
      <PROCESS_FLAG>1</PROCESS_FLAG>
      <TRANSACTION_MODE>3</TRANSACTION_MODE>
      <ORGANIZATION_ID>1</ORGANIZATION_ID>
      <SUBINVENTORY_CODE>97-FGI</SUBINVENTORY_CODE>
      <TRANSACTION_QUANTITY>5</TRANSACTION_QUANTITY>
      <TRANSACTION_UOM>EA</TRANSACTION_UOM>
      <TRANSACTION_DATE>Mar-26-2009</TRANSACTION_DATE>
      <TRANSACTION_TYPE_ID>42</TRANSACTION_TYPE_ID>
      <LAST_UPDATE_DATE>Mar-26-2009</LAST_UPDATE_DATE>
      <LAST_UPDATED_BY>1</LAST_UPDATED_BY>
      <CREATION_DATE>Mar-26-2009</CREATION_DATE>
      <CREATED_BY>1</CREATED_BY>


      
     </mtl_transactions_interface RECORDINSERT>
    </RECORDSET>
    </Insert>


    JAT
    Thursday, April 2, 2009 3:18 PM

Answers

  • The node <mtl_transactions_interface RECORDINSERT> does not have a valid name. It should be table_name + RECORDINSERT i.e. for your case, it will be

    ...
    ...
    <MTL_TRANSACTIONS_INTERFACERECORDINSERT>
    ...
    ...
    ...
    </MTL_TRANSACTIONS_INTERFACERECORDINSERT>
    ...
    ...


    When you create schemas in BizTalk project, you have the facility to generate instance XMLs for the schema ( first provide a path for instance in schema properties, then right click on schema, generate intance) similarly, you can also validate if an XML you have complies with a particular schema.

    I hope this helps.

    • Marked as answer by JAT14 Thursday, April 2, 2009 5:11 PM
    Thursday, April 2, 2009 3:29 PM

All replies

  • The node <mtl_transactions_interface RECORDINSERT> does not have a valid name. It should be table_name + RECORDINSERT i.e. for your case, it will be

    ...
    ...
    <MTL_TRANSACTIONS_INTERFACERECORDINSERT>
    ...
    ...
    ...
    </MTL_TRANSACTIONS_INTERFACERECORDINSERT>
    ...
    ...


    When you create schemas in BizTalk project, you have the facility to generate instance XMLs for the schema ( first provide a path for instance in schema properties, then right click on schema, generate intance) similarly, you can also validate if an XML you have complies with a particular schema.

    I hope this helps.

    • Marked as answer by JAT14 Thursday, April 2, 2009 5:11 PM
    Thursday, April 2, 2009 3:29 PM
  • Thank you so much   solved the problem....
    JAT
    Thursday, April 2, 2009 5:12 PM