Integration

Get Involved. Join the Conversation.

Topic

    KAMAL HOSSEN
    Issue with Reading XML file in Stage File for multiple...
    Topic posted June 24, 2019 by KAMAL HOSSENBronze Medal: 1,250+ Points, last edited June 24, 2019, tagged Cloud, Integration, Orchestration 
    90 Views, 5 Comments
    Title:
    Issue with Reading XML file in Stage File for multiple records
    Summary:
    Issue with Reading XML file in Stage File for multiple records
    Content:

    Hi,

    Using for loop I am filtering some repeated XML element and writing into XML File (With Append Checked). Writing is working fine But issues happening while trying to read that file back-

    -> Reading single record works fine (when I don't include append during Write)

    -> Error reading multiple records (when append is checked during Write): It seems it's breaking the format while appending the XML records

    Fault Details : 
    <summary>The &lt;from> value is invalid.
    Xpath expression associated with &lt;from> in copy assign activity is invalid.
    There is an user error that results in missing element value(s) in the xpath query.
    Please review the payload and modeling to ensure that all elements defined in the &lt;from> xpath query have valid non-null values .
    </summary>

    Sample Payload running in the loop:

    <ReadResponse xmlns="http://xmlns.oracle.com/cloud/adapter/stagefile/ReadXML_REQUEST/types">
       <DATA_DS xmlns="http://xmlns.oracle.com/cloud/adapter/nxsd/surrogate">
          <G_1>
             <ORGANIZATION_CODE>0601</ORGANIZATION_CODE>
             <WORK_ORDER_NUMBER>060110000124</WORK_ORDER_NUMBER>
             <WORK_ORDER_ID>80016</WORK_ORDER_ID>
             <WORK_ORDER_DESCRIPTION>keyed description field</WORK_ORDER_DESCRIPTION>
             <WO_STATUS_CODE>ORA_RELEASED</WO_STATUS_CODE>
             <WORK_ORDER_PRIORITY>2</WORK_ORDER_PRIORITY>
             <PLANNED_START_DATE>2019-06-11T15:59:00.000+00:00</PLANNED_START_DATE>
             <DEL_DATE>2019-07-05T00:00:00.000+00:00</DEL_DATE>
             <FG_ITEM_NUMBER>BCAGHSSG</FG_ITEM_NUMBER>
             <INVENTORY_ITEM_ID>100000000922881</INVENTORY_ITEM_ID>
             <COMPL_SUBINVENTORY_CODE>DESPATCH</COMPL_SUBINVENTORY_CODE>
             <UOM_CODE>m</UOM_CODE>
          </G_1>
          <G_1>
             <ORGANIZATION_CODE>0601</ORGANIZATION_CODE>
             <WORK_ORDER_NUMBER>060110000124</WORK_ORDER_NUMBER>
             <WORK_ORDER_ID>80016</WORK_ORDER_ID>
             <WORK_ORDER_DESCRIPTION>keyed description field</WORK_ORDER_DESCRIPTION>
             <WO_STATUS_CODE>ORA_RELEASED</WO_STATUS_CODE>
             <WORK_ORDER_PRIORITY>2</WORK_ORDER_PRIORITY>
             <PLANNED_START_DATE>2019-06-11T15:59:00.000+00:00</PLANNED_START_DATE>
             <DEL_DATE>2019-07-05T00:00:00.000+00:00</DEL_DATE>
             <FG_ITEM_NUMBER>BCAGHSSG</FG_ITEM_NUMBER>
             <INVENTORY_ITEM_ID>100000000922881</INVENTORY_ITEM_ID>
             <COMPL_SUBINVENTORY_CODE>DESPATCH</COMPL_SUBINVENTORY_CODE>
             <UOM_CODE>m</UOM_CODE>

          </G_1>
          <G_1>
             <ORGANIZATION_CODE>0601</ORGANIZATION_CODE>
             <WORK_ORDER_NUMBER>060110000257</WORK_ORDER_NUMBER>
             <WORK_ORDER_ID>300000097300975</WORK_ORDER_ID>
             <WORK_ORDER_DESCRIPTION/>
             <WO_STATUS_CODE>ORA_UNRELEASED</WO_STATUS_CODE>
             <WORK_ORDER_PRIORITY/>
             <PLANNED_START_DATE>2019-06-13T05:22:00.000+00:00</PLANNED_START_DATE>
             <DEL_DATE/>
             <FG_ITEM_NUMBER>FLA10BL200DR</FG_ITEM_NUMBER>
             <INVENTORY_ITEM_ID>100000000439747</INVENTORY_ITEM_ID>
             <COMPL_SUBINVENTORY_CODE>JOBBING</COMPL_SUBINVENTORY_CODE>
             <UOM_CODE>m</UOM_CODE>
          </G_1>
       </DATA_DS>
    </ReadResponse>

    Thanks.

    Regards,

    Kamal

    Comment