Unique Key violation detected by database ORA-00001

[giriprasad9]

Hi,

Getting below error "Unique Key violation detected by database ORA-00001" on occasionally while doing mass updates of attributes in 'cmdb_ci' table from list view. Changes are not saving to DB.

I am not able trace from where and why I am getting this error. Please let me know how can I fix this issue.

- Giri

[srinivasthelu]

Hi Giri,

Check for any before insert BR's that have current.update();

Mostly that should be cause.

Thanks

Sriniavs

[Ahmed Drar]

Hi Giri , avoid using current.update() onBefore business rules
Thanks ,
Ahmed

[giriprasad9]

Hi Srinivas & Ahmed,

Thanks for your reply.

Found a BR written on cmdb_ci table using current.update(), trying to modify the BR script.

- Giri

[narendravarma]

Hi,

I've also got the same issue, it is causing not because mass updates.

It is happening because current.update();

Note : it is showing the error as unique key.... But it is inserting the record in table