We have upgraded out BW system from BW3.5 to BI7 EHP1. We have deleted the current STMS config using DICO. Now when we are re-configuring the STMS, we are getting dumps stating SAPSQL_ARRAY_INSERT_DUPREC -- The ABAP/4 Open SQL array insert results in duplicate database records.
We are help up at this point. Tried to dig through various forums. Please help!
I also had the same issue after a system copy. Went to SE06 and performed the post steps "Database Copy or Database Migration" including deleting TMS and all routes. When i attempt to setup TMS from scratch i got the "SAPSQL_ARRAY_INSERT_DUPREC". I referenced SAP note listed above. I went to client 000 and deleted TMSADM and this resolve my issue.
Your simple solution works for me, I was struggling a lot to overcome, on my new system ( prepared by system copy) , SAPOSS was not working also, so I was not able to implment the snote which was mentioned above,
From which client have you deleted the TMS. Please login to 000 client of the domain controller and delete the TMS from STMS tcode and also delete all the transport routes and after that distribute changes. Then create the TMS again and add systems to it, create the transport routes and then activate and distribute the changes to the system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.