cancel
Showing results for 
Search instead for 
Did you mean: 

Issue in deployment database foreign key

SandeepAutade
Confirmed Champ
Confirmed Champ

When we do deployment, we stop nuxeo server then database.

After this we put JAR and then start database and nuxeo server in sequence.

 

However we get below error while starting

2025-08-06 19:24:49,366 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table NXP_LOGS_MAPEXTINFOS add constraint FKF96F609E7AC49AA foreign key (LOG_FK) references NXP_LOGS
2025-08-06 19:24:49,366 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] ERROR: insert or update on table "nxp_logs_mapextinfos" violates foreign key constraint "fkf96f609e7ac49aa"
Detail: Key (log_fk)=(69) is not present in table "nxp_logs".
2025-08-06 19:24:49,409 INFO [localhost-startStop-1] [org.nuxeo.elasticsearch.ElasticSearchComponent] Elasticsearch service is disabled
2025-08-06 19:24:49,739 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table NXP_LOGS_MAPEXTINFOS add constraint FKF96F609E7AC49AA foreign key (LOG_FK) references NXP_LOGS
2025-08-06 19:24:49,739 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] ERROR: insert or update on table "nxp_logs_mapextinfos" violates foreign key constraint "fkf96f609e7ac49aa"
Detail: Key (log_fk)=(69) is not present in table "nxp_logs".
2025-08-06 19:24:49,862 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table NXP_LOGS_MAPEXTINFOS add constraint FKF96F609E7AC49AA foreign key (LOG_FK) references NXP_LOGS
2025-08-06 19:24:49,862 ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] ERROR: insert or update on table "nxp_logs_mapextinfos" violates foreign key constraint "fkf96f609e7ac49aa"
Detail: Key (log_fk)=(69) is not present in table "nxp_logs".
ERROR [localhost-startStop-1] [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: alter table NXP_LOGS_MAPEXTINFOS add constraint FKF96F609E7AC49AA foreign key (LOG_FK) references NXP_LOGS

0 REPLIES 0
Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.