Runtime error "SAPSQL_ARRY_INSERT_DUPEREC" in DMS

[ravichandran_r]

Hi Experts,

I am getting an error "SAPSQL_ARRY_INSERT_DUPEREC" while changing the document after 1st save.

The details is below:

I have created a document info record in CV01N transaction and saving the DIR. Then when am trying to change the document through T-Code CV02N for the DIR, which i created, it throughout an error " Update was terminated" and sent out a notification SBWP (SAP Business workplace).

This issue is happening Intermittently and not regularly.

Please help me on this issue.

See the attachment which is in detail

Thanks,

Ravi

[Former Member]

Hi Ravi,

Please check below SAP Notes

Note     656967 - Application log: SAPSQL_ARRAY_INSERT_DUPREC, BALDAT

Note     196113 - SAPSQL_ARRAY_INSERT_DUPREC, BALHDR

Regards,

Dipin

[ravichandran_r]

Hi Dipin,

I had checked and both the notes are "Cannot be Implemented'.

Our system is ECC 6.0, EHP 6 & SP11.

Request to provide other solution.

Thanks,

Ravi

[david_liu1]

Hello,

Please run the report RCCLZUOB for appropriate class type and object

table to delete classification data that no longer are associated with

an object. You should run this report in test mode first (leave the

DELETE field blank) to get a listing of the inconsistent data.

This Report deletes classification entries which have no existing

objects which is often the cause of the update termination you receive.

The report RCCLZUOB is already included in your system.

Please refer to the SAPnote 493414 for more information on RCCLZUOB.

Regards,

David