Skip to Content
Former Member
Feb 25, 2009 at 07:59 PM

RAR 5.3 - "ORA-00001" error in Batch Risk Analysis


Hi everyone,

We have RAR 5.3 installed. As for SP5, when running a Batch Risk Analysis you can see the job progress by clicking on result field. Once there, you can see which objects are currently being analyzed, which are complete, etc. When the job is done, you can go and see if all objects where correctly analyzed.

But almost every time we run Batch Risk Analysis, we found that some objects have the "Error" status. When we looked at the "Job History" details, the following error appears for each one of this objects:

"Error while executing the Job for Object(s) : XXX :Batch rolled back. Caused by java.sql.BatchUpdateException: ORA-00001: unique constraint (SAPSR3DB.SYS_C00XXXX) violated..."

This error occurs sometimes for some roles and users, but not always on the same roles and users. The problem is that those roles and users that have the "Error" status are consider on the Management View graphics as if they have no conflicts, when they actually have violations.

Anyne of you have experienced the same problem?

Any ideas of why this "ORA-00001" error happens on the Batch Risk Analysis?