topic DBSQL_DUPLICATE_KEY_ERROR in Application Development and Automation Discussions

DBSQL_DUPLICATE_KEY_ERROR

former_member647507 — Tue, 25 Feb 2020 10:26:15 GMT

ERROR

Internal session terminated with a runtime error DBSQL_DUPLICATE_KEY_ERROR

Please let me know why this error is coming when I am executing a report in SAP.

Re: DBSQL_DUPLICATE_KEY_ERROR

FredericGirod — Tue, 25 Feb 2020 10:29:02 GMT

There could have several possible error.

Run transaction ST22, find the corresponding dump, and get the description error & the corresponding code.

The basis of this error is, you try to insert a row in a table, but a key for this row already exist. It is a fatal error to protect the database integrity.

If it is a standard program, it could be someone playing with range number (set the range number to a number already used)

Re: DBSQL_DUPLICATE_KEY_ERROR

anmol25 — Sun, 06 Aug 2023 07:28:42 GMT

IF This is occuring while doing a GR or creating a PO, then it means that the doc number which is being generated is used by other for creating PR OR PO. You can create a new group and assign a new number range to it. This solved my problem.

Re: DBSQL_DUPLICATE_KEY_ERROR

Sandra_Rossi — Sun, 06 Aug 2023 08:22:33 GMT

The question was so generic (can happen in thousands of cases) that your answer will be invisible to people looking for an answer, so I recommend that you post your own question AND answer, describing the problem you had in details (the question), and how you solved it (the answer). Thanks!