SAPSQL_ARRAY_INSERT_DUPREC error during release of transport request

[Former Member]

Hello All,

I am getting the below ABAP dump when trying to release the TR in the DEV system.

Category               ABAP Programming Error

Runtime Errors         SAPSQL_ARRAY_INSERT_DUPREC

Except.                CX_SY_OPEN_SQL_DB

ABAP Program           SAPLSTRD

Application Component  BC-CTS-ORG

I found Note 1041098 - duplicate key when appending object to transport request  however this Note talks about appending object to TR but our case is when releasing the TR. What usually causes this duplicate insert error during release of TR?

The above Note talks about counter number in table E071 whereas I couldn't find the same in the table.

What else do I need to check? Please help.

Thanks

[former_member45419]

Hi Rahul,

Pls check the below links

http://scn.sap.com/thread/933996

https://scn.sap.com/thread/2076533

Check the note 1412609

Regards

Nayeem

[Sriram2009]

Hi Rahul

Kindly refer the SAP Note  780441  - Short dump SAPSQL_ARRAY_INSERT_DUPREC with request release

Regards

Sriram

[Former Member]

Thanks Sriram.

This looks to be the issue. I have one question here :

Per the Note 780441, I referred Note 564285 which talks about Project Status Switch.

Project object list	Project intersection	Description
On	On	Standard
On	Off	No intersections
Off	Off	Permanent project
Off	On	Invalid setting

Now the current issue is with appending objects in Project Object List. What is the consequence if I go with option of both Project Object list and Project intersection OFF?

The Note 780441 says that "Close the current project and open a new one. For details, see Note 564285". If I go with OFF option, then there is no need to create a new project, right?

What is the solution?

a. Creating a new project

b. Selection of status OFF for the project status switch

What is the best solution? What are the side effects of each solution?

Thanks in advance.