Maximo Open Forum

 View Only
Expand all | Collapse all

Integration message fails in the queue with the message - Index: 4 Size: 4

  • 1.  Integration message fails in the queue with the message - Index: 4 Size: 4

    Posted 04-26-2023 06:58

    Hi All,

    We have an Interface table integration mechanism with Oracle EBS and the contracts are created in Oracle EBS and interfaced to Maximo. We observed that once contracts are closed in Oracle,the same is not getting interfaced to Maximo with a strange error message - Index: 4 Size: 4 and not sure if this is related to ArrayIndexOutOfBounds exception as we queried the contracts table for any attributes with length equal to 4 to see if the inbound message received equals the maximum length of the attribute but that was not found to be the case.

    Any hints on the direction will be appreciated.
    Below is the XML message
    <?xml version="1.0" encoding="UTF-8"?>
    <SyncMXPC xmlns="http://www.ibm.com/maximo" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" creationDateTime="2023-04-24T15:22:24+01:00" baseLanguage="EN" messageID="2849816823461448312393">
      <MXPCSet>
        <PURCHVIEW action="">
          <CANEXCEEDVOLUME>0</CANEXCEEDVOLUME>
          <CHANGEBY></CHANGEBY>
          <CHANGEDATE>2023-04-24T16:21:04+01:00</CHANGEDATE>
          <CONTRACTNUM></CONTRACTNUM>
          <CONTRACTTYPE>BLANKET</CONTRACTTYPE>
          <CURRENCYCODE></CURRENCYCODE>
          <DESCRIPTION></DESCRIPTION>
          <ENDDATE>2023-03-31T23:59:59+01:00</ENDDATE>
          <EXCHANGEDATE>2022-10-10T00:00:00+01:00</EXCHANGEDATE>
          <EXCHANGERATE>1.0</EXCHANGERATE>
          <FOB></FOB>
          <FREIGHTTERMS>N/A</FREIGHTTERMS>
          <MAXVOL></MAXVOL>
          <ORGID></ORGID>
          <PAYMENTTERMS></PAYMENTTERMS>
          <PURCHASEAGENT></PURCHASEAGENT>
          <REVISIONNUM>1</REVISIONNUM>
          <STARTDATE>2022-08-03T00:00:00+01:00</STARTDATE>
          <STATUS>CLOSE</STATUS>
          <STATUSDATE>2023-04-24T16:21:04+01:00</STATUSDATE>
          <STATUSIFACE>1</STATUSIFACE>
          <VENDOR></VENDOR>
          <CONTRACTLINE>
            <CONTRACTLINENUM />
            <ENTERDATE>2022-10-10T08:54:36+01:00</ENTERDATE>
            <OA_IFACESTATUS>DONE</OA_IFACESTATUS>
            <OA_IFACETIMESTAMP>2023-04-24T16:21:04+01:00</OA_IFACETIMESTAMP>
          </CONTRACTLINE>
          <CONTRACTAUTH>
            <AUTHORGID></AUTHORGID>
            <AUTHSITEID></AUTHSITEID>
            <BILLTO></BILLTO>
            <VENDOR />
          </CONTRACTAUTH>
        </PURCHVIEW>
      </MXPCSet>
    </SyncMXPC>


    #EverythingMaximo
    #HSE/OilandGas
    #MaximoUserGroups

    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------


  • 2.  RE: Integration message fails in the queue with the message - Index: 4 Size: 4

    Posted 04-26-2023 08:05

    Hi Mahadevan,

    Your assumption is correct. Do you have any script written on this integration layer (enterprise service) where traversing is happening. Java is 0 indexed... So if a set returns 4 element , it should have [0,1,2,3] . But if there is any script where we actually trying to fetch the sets the based on the count (i.e 4), then java will throw the exception.

    Please check for any script which is getting invoked during this transaction.



    ------------------------------
    Subhransu Sekhar Sahoo
    Tata Consultancy Services
    ------------------------------