IdStory Identity Manager

• project has automatic role for contract EAV,
• project twice saved EAV contract value for same owner,
• saving creates two events,
• each event recalculate automatic roles and decides that new automatic role must be assigned,
• recalculation creates role request,
• role request doesn't check or recalculate again automatic role so result is that identity will has two same automatic roles.

LRT ProcessAllAutomaticRoleByAttributeTaskExecutor end with error:

org.springframework.dao.DataIntegrityViolationException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.DataException: could not extract ResultSet

Caused by: org.postgresql.util.PSQLException: ERROR: more than one row returned by a subquery used as an expression

Workaround: not exists