Skip to Content
avatar image
Former Member

Serailization-Update not possible; event handler is locked

We generate serial numbers in OER pass them to Aii and the outside partner will request the numbers from Aii. Once they apply the numbers to our product, they will send an association PML file back. We are receiving the serial association file from the external partner through PI. THe file comes into Aii correctly (SSCC pallet and two GTIN (case and bottle), we can see the pallet linked to case linked to the bottle. When the file gets passed to OER we get error Update not possible; event handler is locked in SXMB_MONI and not all the numbers will be in OER.

This does not happen with every file, one will work but the next will get the Update not possible; event handler is locked error. The data is the same, the number ranges are the same. The number range being used was uploaded from Aii into OER and is blocked in OER, could this be causing the issue?

We have looked at OSS note 1968226 but we are on service pack SCEMSRV 900 and the note applies to lower version service packs. We have increased the size of the lock table but are still getting the error.

Any suggestions how to fix?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 30, 2016 at 07:53 AM

    Hi,

    Is the error number is /saptrx/app_log017? Do you have any other errors in the application log?

    Regards,
    Claire

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 03, 2016 at 11:36 PM

    Hello Rose,

    As mentioned by Claire, please check application log (t-code SLG1 or /SAPTRX/ASAPLOG) if enabled.

    When posting Rule proc from AII -> OER, do you use standard activity EPCIS_EVENT_SEND_TO_XI ? What customization/ custom objects do you have on AII & OER side ? Please provide more details about this.

    looks like two processes are trying to update EH at the same time, causing the issue. You can take ABAPer help to debug the issue.

    Also Check for locked EHs in table /SAPTRX/LOCKEDEH. Run the locked EH job (/SAPTRX/PROCESS_LOCKED_EH) to ensure that all events have been posted.

    • /SAPTRX/LOCKED_PROC - Process Event Messages for Locked Event Handler
    • /SAPTRX/LOCKED_PSET - Process Locked Event Handler Sets

    For more details check Kevin's blog - SAP EM Blog Series #11 - Troubleshooting tips

    Hope this helps.

    Regards,

    NRS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 07, 2016 at 03:29 PM

    Thank you for everyone's response, the webservice in PI had been disconnected.

    Add comment
    10|10000 characters needed characters exceeded