BUG: GGCE Dataviews
During startup of a migrated legacy GG database I encountered the following issue:
09:13:06.773 [main] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - The DELETE statement conflicted with the REFERENCE constraint "fk_srfl_srf". The conflict occurred in database "ggce-X", table "dbo.sys_dataview_field_lang", column 'sys_dataview_field_id'.
09:13:06,850 main ERROR ApplicationStartup:488 - Could not register sys_user dataview: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
...
at org.gringlobal.service.impl.DataviewServicesImpl$SysDataviewServiceImpl.updateDataviewFromXML(DataviewServicesImpl.java:216)
...
at com.sun.proxy.$Proxy602.updateDataviewFromXML(Unknown Source)
at org.gringlobal.spring.ApplicationStartup.lambda$ensureGGCEDataviews$26(ApplicationStartup.java:480)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "fk_srfl_srf". The conflict occurred in database "ggce-X", table "dbo.sys_dataview_field_lang", column 'sys_dataview_field_id'.