Skip to Content
author's profile photo Former Member
Former Member

IDOC_AAE Error - (104) JCO_ERROR_SYSTEM_FAILURE: Open SQL array insert produces duplicate records in the database. (Remote shortdump: SAPSQL_ARRAY_INSERT_DUPREC in system XXX|xxxx)

Hi Experts,

Good day!

Currently, I have a File to IDOC scenario on out single stack 7.4 PI system.

During the testing, it is woking smoothly up until the point where PI is trying to transmit the into the ECC system that error below came up:

(104) JCO_ERROR_SYSTEM_FAILURE: Open SQL array insert introduces duplicate records in the database. (Remote shortdump: SAPSQL_ARRAY_INSERT_DUPREC in system XXX|xxxxxx)

Can you please advise which tables and keys to check for duplicate?

Thank you so much,

Eljus Bryan

error.jpg (149.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2015 at 07:47 AM

    Thanks Raghuraman and Souvik,

    This issue is now resolved. Based on the initial finding, It seems that there have been inconsitencies between the EDI* Tables in ECC causing it to tag any idoc generated as duplicate. As a workaround, the functional team just updated the IDOC sequence on SNRO and jumped a few IDocs forward.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 20, 2015 at 05:16 AM

    Hello Cabigon,

    Check this note-Note 196113

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2015 at 05:24 AM

    Hello Eljus,

    Can you please show how you have configured the first tab of Receiver AAE.

    Regards,

    Souvik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.