NetIQ Identity Governance

IG 3.6.1 DB Cleanup gives org.hibernate.exception.ConstraintViolationException: could not execute statement

NJensen 2 months ago

Hi,

IG 3.6.1 using a postgresql database

I'f like to clean up the data (since the disk will be running full eventually).

I have disabled achiving

When I choose to cleanup, the result is a failure with statement like:

org.hibernate.exception.ConstraintViolationException: could not execute statement

The catalina log says:

[ERROR] 2022-11-03 12:31:28 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions - ERROR: update or delete on table "change_request_item" violates foreign key constraint "fk_ciav_item_id" on table "change_item_attr_value"
Detail: Key (id)=(13) is still referenced from table "change_item_attr_value".
[INFO] 2022-11-03 12:31:28 com.netiq.iac.common.config.IacConfigurationUtil getExceptionLogLevel - [IG-SERVER] Exception log level: DEBUG
[SEVERE] 2022-11-03 12:31:28 com.netiq.iac.persistence.service.CleanupRunner run - [IG-SERVER] Encountered unexpected error: org.hibernate.exception.ConstraintViolationException: could not execute statement

Any ideas to what I can do about this?

Tags:

cleanup

purging data

0 Jimbot
2 months ago

I'd recommend opening a ticket. Support may be able to provide some SQL queries that will help identify the offending rows, and even how to remove those offenders.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 NJensen
2 months ago in reply to Jimbot

You could be right.
Sometimes forum posts give enough information (and interresting discussions as well) to solve issues (and enrich the hivemind with further insight), and sometimes not.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 stevewdj
2 months ago in reply to NJensen

Greetings,
The issue you are experiencing is a defect in 3.6.1, which has been resolved in 3.6.2 and later releases. You will need to upgrade to receive the fix since 3.6.1 is no longer supported. I would suggest that you upgrade to 3.7.0 which was released in March of this year.

Note: There is an upcoming 3.7.3 release for on-prem customers. Please be aware to upgrade to 3.7.3 one must be on either 3.6.2 (released in March 2021) or 3.7.0 (released in March 2022)

Sincerely,
Steven Williams
Principal Enterprise Architect
Micro Focus
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 NJensen
2 months ago in reply to stevewdj

Thanks.
I am trying 3.6.2.
It seems to fail a bit... I'll look some more into it, and perhaps start another thread If I cannot figure out what is wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

NetIQ Identity Governance

IG 3.6.1 DB Cleanup gives org.hibernate.exception.ConstraintViolationException: could not execute statement

Tags:

Resources