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

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

book

Article ID: 375060

calendar_today

Updated On:

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