Error HHH000315 - DELETE statement conflicted with the REFERENCE constraint "FKD2C29CAA8CE8C11" - table dbo.server_flow

Products

• CA Release Automation - Release Operations Center (Nolio)
• CA Release Automation - DataManagement Server (Nolio)

Issue/Introduction

Following error appears in NAC logs nolio_dm_all.log at startup :

2024-07-03T09:12:20.622+03:00 [IdleTestsRemover-1] ERROR (org.hibernate.engine.jdbc.batch.internal.BatchingBatch:134) - HHH000315: Exception executing batch [java.sql.BatchUpdateException: The DELETE statement conflicted with the REFERENCE constraint "FKD2C29CAA8CE8C11". The conflict occurred in database "Nolio", table "dbo.server_flow", column 'server'.], SQL: /* delete com.nolio.platform.server.dataservices.model.GenericType */ delete from server_types where ID=? and version=?
2024-07-03T09:12:20.622+03:00 [IdleTestsRemover-1] WARN  (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:137) - SQL Error: 547, SQLState: 23000
2024-07-03T09:12:20.622+03:00 [IdleTestsRemover-1] ERROR (org.hibernate.engine.jdbc.spi.SqlExceptionHelper:142) - The DELETE statement conflicted with the REFERENCE constraint "FKD2C29CAA8CE8C11". The conflict occurred in database "Nolio", table "dbo.server_flow", column 'server'.

Environment

Release Automation - All Versions.

Cause

Execute following SQL Query :

select * from process_categories where PROCESS_CAT_NAME='___Default Category'

If ARCHITECTURE_ID is NULL and not 1, then it is the cause of problem and solution below should be applied.

Resolution

1. Execute following SQL Query :
   
   UPDATE process_categories
   SET ARCHITECTURE_ID=1
   WHERE PROCESS_CAT_NAME='___Default Category' and ARCHITECTURE_ID IS NULL ;
   
   
2. Restart NAC service