While Group Modify getting error : An unexpected error occurred: org.hibernate.exception.ConstraintViolationException: could not execute statement

Which IIQ version are you inquiring about?

8.2p2

Hi All,

we are trying to modify group owner, description in IIQ and the request is generating and ending up with an error.

An unexpected error occurred: org.hibernate.exception.ConstraintViolationException: could not execute statement

Upon checking in logs we got below logs :

Caused by: Error : 1, Position : 0, Sql = insert into spt_managed_attribute (created, entitlement_approvers, application, type, aggregated, attribute, value, hash, displayable_name, attributes, requestable, uncorrelated, id) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 ), OriginalSql = insert into spt_managed_attribute (created, entitlement_approvers, application, type, aggregated, attribute, value, hash, displayable_name, attributes, requestable, uncorrelated, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-00001: unique constraint (UNIQUE_HASH) violated

Can someone please suggest on this issue.

Appreciate your inputs!!

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.