IDOC Status Code 51 error inserting record into custom table

ankeshjindal — Sat, 18 Feb 2023 12:24:18 GMT

Hi.

In one scenario, records in Inbound IDOC are coming at the same time(even the same second) and there can be multiple line items in that one IDOC. Data is dumped into the Custom table and then process further.

Now suppose one IDOC has 3 line items, 1st line item is pushed to the custom table successfully, next one is giving an error in some instances - 'Error inserting a record into custom table Z*'.

It is only happening in that instance when 2 or more records come at the same item then one of the items in IDOC result in below error

Please suggest how to resolve or any workaround so that all record will save in custom table.

Re: IDOC Status Code 51 error inserting record into custom table

RaymondGiuseppi — Sun, 19 Feb 2023 09:25:59 GMT

How were unique keys defined in the intermediate Z-table, can you consider

updating records when they already exist
using a lock process (on the table for example, lock table with ENQUEUE_E_TABLE, do it some limited times with wait if already locked, insert records and COMMIT WORK to relase lock and validate database)

topic IDOC Status Code 51 error inserting record into custom table in Application Development and Automation Discussions

IDOC Status Code 51 error inserting record into custom table

Re: IDOC Status Code 51 error inserting record into custom table