Autominc objects stopped updating in AAI - Error - The DELETE statement conflicted with the REFERENCE constraint "XFKUnivResourceJobCondition"

Products

• Automation Analytics & Intelligence

Issue/Introduction

AAI Converter process error which is preventing the Automic objects from being downloaded to AAI.

Caused by: com.termalabs.common.datastore.DataAccessException: Flush failed
    at deployment.aai.war/com.termalabs.common.connection.hibernate.GenericSessionImpl.timedCommit(GenericSessionImpl.java:392) ~[jaws-common-connection-24.3.0.jar:?]
    at deployment.aai.war/com.termalabs.common.connection.hibernate.GenericSessionImpl.commit(GenericSessionImpl.java:254) ~[jaws-common-connection-24.3.0.jar:?]
    at deployment.aai.war/com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.saveObjects(SchedulerUpdateImpl.java:591) ~[jaws-server-base-24.3.0.jar:?]
    at deployment.aai.war/com.termalabs.server.cache.scheduler.SchedulerUpdateImpl.commit(SchedulerUpdateImpl.java:334) ~[jaws-server-base-24.3.0.jar:?]
    ... 88 more
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute batch [The DELETE statement conflicted with the REFERENCE constraint "XFKUnivResourceJobCondition". The conflict occurred in database "<Scheduler Name>", table "dbo.JobCondition", column 'universalResourceId'.] [delete from UniversalResource where universalResourceId=?]

Resolution

A fix for this issue has been released in AAI 24.3HF2.

 

Please upgrade to 24.3HF2 or later to resolve this issue.