Skip to Content
Author's profile photo Rafael Guimbala

Background Risk Analysis throwing “duplicate record in database” dump

When choosing the background option in Risk Analysis, some users are facing a dump, this is relative to duplicates parameters, one example is one risk analysis with two roles or two kinds of risk,

 

This is how the error presents in front end

 

500 Sap Internal Server Error

ERROR: Open SQL  array insert produces duplicate records in the database. (Termination: RABAX_STATE)

 

 

And this is the error in ST22

 

SAPSQL_ARRAY_INSERT_DUPREC

 

CL_GRAC_SOD_RISK_ANALYSIS_BG

 

The error line in >>>>insert gracbrange from table mt_range_table.

 

 

For more information to solve this issue view SAP Note 2183633 – Background Batch Risk Analysis raising
SAPSQL_ARRAY_INSERT_DUPREC dump.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Luciana Ullmann
      Luciana Ullmann

      Very Usefull!
      Thanks for sharing.