topic Re: DBSQL_DUPLICATE_KEY_ERROR in Application Development and Automation Discussions

DBSQL_DUPLICATE_KEY_ERROR

Former Member — Fri, 17 Apr 2015 07:17:53 GMT

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

Re: DBSQL_DUPLICATE_KEY_ERROR

Former Member — Fri, 17 Apr 2015 08:08:26 GMT

Hi Florence,

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

regards,

Archer

Re: DBSQL_DUPLICATE_KEY_ERROR

RaymondGiuseppi — Fri, 17 Apr 2015 09:02:30 GMT

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

Regards,

Raymond

Re: DBSQL_DUPLICATE_KEY_ERROR

Former Member — Fri, 17 Apr 2015 10:05:07 GMT

This message was moderated.

Re: DBSQL_DUPLICATE_KEY_ERROR

RaymondGiuseppi — Fri, 17 Apr 2015 11:23:38 GMT

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

Regards,

Raymond

Re: DBSQL_DUPLICATE_KEY_ERROR

matt — Fri, 17 Apr 2015 11:53:14 GMT

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.