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'.
Release Automation - All Versions.
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.