Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

DBSQL_DUPLICATE_KEY_ERROR

former_member647507
Explorer

‎2020 Feb 25 10:26 AM

0 Kudos
5,649

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.

3 REPLIES 3

FredericGirod
Active Contributor

‎2020 Feb 25 10:29 AM

3,550

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)

anmol25
Explorer

‎2023 Aug 06 8:28 AM

0 Kudos
3,550

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.

Sandra_Rossi
Active Contributor
In response to anmol25

‎2023 Aug 06 9:22 AM

0 Kudos
3,550

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!