SAPSQL_ARRAY_INSERT_DUPREC issue repeats after upgrade

[Former Member]

Doing updates from W/dso, I face lot of repeated ST22 dumps like this....

Runtime Error SAPSQL_ARRAY_INSERT_DUPREC

Exception CX_SY_OPEN_SQL_DB

X_SY_TYPE_CREATION===========CP 493 11/18/2005 14:35:29 10240 E 494 Prg CX_DYNAMIC_CHECK==============CP 494 11/18/2005 14:35:29 10240 E 495 Prg CX_SY_STRUCT_ATTRIBUTES=======CP 495 06/30/2007 18:43:02 11264 E 496 Prg CX_SY_STRUCT_SUFFIX_NAME======CP 496 01/23/2006 17:28:56 12288 E 497 Prg

Revently the system was upgraded with BIA add-ons. 7.0 series EHPs

Its not the ususal SQL error, as clearing TRFCs etc is not working. If anyone has encountered this issue and if there is a possible soln. please let me know.

[Former Member · Accepted solution]

Just de-schedule the IPAK. Find it via RSPCM itself, the chain errors if any. This must solve the 1st case. Secondly with regards to BIA, just check the SNRO. If there's a similar values in range/overlaps, this error will occur. For more help, check SAP Note 196113.

[Former Member · Accepted solution]

@ Tanku : No, but this is a BIA related issue only.

@ Arun Bala : Does this mean I have to remove the schedule of the DTPs as well?

Edited by: Sonakshi on Feb 13, 2012 8:56 PM

[Former Member · Accepted solution]

Yes! The overlaps happen due to the wrong assignment groups. Just remove the overlaps after a de-schedule, this must solve the issue. Ensure the change is done at IPAK level and chain also is re-activated & scheduled. Thanks.

[Former Member]

I assume this has nothing to do with BWA, it looks like you are trying to insert a duplicate record with same primary key into an ODS.

Cheers

Tansu