DBSQL_DUPLICATE_KEY_ERROR

[Former Member]

Hi, Experts.

In our ERP production system, we are receiving dumps DBSQL_DUPLICATE_KEY_ERROR. It came from different programs and some are from users and some are from system user. here are the affected programs: SAPLBUPA_TAX_SAVE, SAPLCCCO, SAPLSZA0 and SAPLV45V.

i have checked the following notes 170907 and 175154 but those notes are not applicable in our system.

Any inputs on this dumps?

I attached the sample dump logs.

Thank you in advance.

Regards,

Florence

[Former Member]

Hi Florence,

You should debugging to check what data exactly in gt_crmparnr[]. and why crmparnr dbtable already have the duplicate value.

regards,

Archer

[raymond_giuseppi]

Seems related to some customer developments, check FM Z_TRIGGER_REPLICATION_CRM_CP or other FM of FG ZCRM_REPLICATION_BP.

Regards,

Raymond

[Former Member]

This message was moderated.

[raymond_giuseppi]

Could you search for recent import of modified program (exit, BAdI) or wrong transport/overflow of number range intervals on your system?

Regards,

Raymond

[matt]

This site is not designed as a replacement for technical expertise - some effort (and knowledge) is expected from posters. For that reason I am locking this thread. (And have rejected the earlier post of 3 more dumps for analysis).

The OP has already said that they have an abapper. That resource should be doing the necessary analysis and if he/she gets stuck, then opening one question per issue - together with what was tried and the analysis so far.