Client Copy Error

[Former Member]

Hi Gurus,

I got the following error while doing client copy.

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

-

---

-

---

|Short text

| The ABAP/4 Open SQL array insert results in duplicate database records.

-

---

-

---

|What happened?

| Error in the ABAP Application Program

|

| The current ABAP program "SAPLSBAL_DB_INTERNAL" had to be terminated because it

| has

| come across a statement that unfortunately cannot be executed.

-

---

Kindly help me out.

Thanks & Regards

Ajitabh

[Former Member · Accepted solution]

Hi,

Be sure once client copy is running no body should working on the source system.

This error happens only when there is a transaction trying to duplicate some record on the database Check the logs in ST22.

Also see the following SAP note...

Note 196113 - SAPSQL_ARRAY_INSERT_DUPREC,

Regards

Bhuban

RKFL

[Former Member]

Hi,,

In this issue please find the below notes

If suser id

777712 ,62985 ,Please check these notes and apply it .

Then let me know the status it is usefull for you.

Regards,

K.Ramamoorthy

[Former Member]

Hi Guys,

Thanks for your replies.

Thanks & Regards

Ajitabh

[former_member182655]

Could you see which table is under copying?

Also, please, give the option you are using for client copy.

Regards,

Artem Ivashkin

[Former Member]

Hi Ajitabh,

Please check the locked objects in SM12 and SM13 and delete.

Also paste the dump details through ST22.

Regards

Pranay

[Former Member]

Hey Pranay,

Thanks for your reply.

There are no locked objects in SM12 and SM13.

I already have pasted the logs.

Kindly have a look at the top of the forum.

Thanks and Regards

Ajitabh