Runtime Error SAPSQL_ARRAY_INSERT_DUPREC CX_SY_OPEN_SQL_DB

[Former Member]

Hello everyone we just competed a production copy and we received this error:

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

CX_SY_OPEN_SQL_DB

How do you check to see if the connection to the mail system is absent from the production copy????

Thank you for your time

[markus_doehr2 · Accepted solution]

Since we don't know when this error occurs in the system it's impossible to give a suggestion.

The error states, that an entry should have been made to a table, that has already an entry with the same key. To assist, we need the table name and the action you were trying to do.

Mail system? Check transaction SCOT

--

Markus

[Former Member · Accepted solution]

Markus,

Thank you for your reply: This problem occurs when payroll runs: on a specific individual who meets certain criteria, the system attempts to send a mail message. The ABAP dump occurs when this happens, but payroll runs successfully against employees who do not meet the criteria for sending the message

From ST22 the error in the program is showing up here:

003650 IF COUNT_ITEMS GT 0.

003660 * Update the array on the database

-

---

> INSERT SOES FROM TABLE SOES_ARRAY.

003680 * Set the return parameters

003690 MOVE: SY-SUBRC TO RCODE,

003700 SY-DBCNT TO DBCNT.

Thank you

[markus_doehr2 · Accepted solution]

Since you didn't state what release and support package you are running I can just assume and give you the following note:

581559 - SAPoffice: Sending ends with SAPSQL_ARRAY_INSERT_DUPREC

--

Markus

[Former Member · Accepted solution]

Markus,

Thank you for your and reply the note you suggested corrected the problem. If you don't mind I am new to SAP you asked what release and support package are we running. Is there a fast way of finding this out....????

By going to system/status I can tell you that we are on Kernel release 640, Patch Level 196. By using transaction SPAM we have many support package components example SAP_BASIS 62O, SAP_ABA 620, SAP_APPL 470, SAP_HR and many more are there other transactions used to tell what release and support package your on..

Once again thanks for your help very much appreciated.

[markus_doehr2 · Accepted solution]

You were right already - this is the correct place to look.

System - Status - and then click on "component versions".

There you will see the component name (e. g. SAP_BASIS 620) and right to that there's a column "Level" which shows you the installed support package.

SCOT is a basis component so the relevant component level to look is SAP_BASIS.

--

Markus

[Former Member · Accepted solution]

Excellent Markus, thanks for your help. Have a great weekend.

Regards

[markus_doehr2 · Accepted solution]

You're welcome.

--

Markus