https://connect.hyland.com/t5/nuxeo-forum/issue-in-deployment-database-foreign-key/m-p/491982#M15851 <P>When we do deployment, we stop nuxeo server then database.</P><P>After this we put JAR and then start database and nuxeo server in sequence.</P><P>&nbsp;</P><P>However we get below error while starting</P><P>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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />2025-08-06 19:24:49,409 INFO [localhost-startStop-1] [org.nuxeo.elasticsearch.ElasticSearchComponent] Elasticsearch service is disabled<BR />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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />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</P> Wed, 06 Aug 2025 17:45:37 GMT SandeepAutade 2025-08-06T17:45:37Z https://connect.hyland.com/t5/nuxeo-forum/issue-in-deployment-database-foreign-key/m-p/491982#M15851 <P>When we do deployment, we stop nuxeo server then database.</P><P>After this we put JAR and then start database and nuxeo server in sequence.</P><P>&nbsp;</P><P>However we get below error while starting</P><P>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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />2025-08-06 19:24:49,409 INFO [localhost-startStop-1] [org.nuxeo.elasticsearch.ElasticSearchComponent] Elasticsearch service is disabled<BR />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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />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<BR />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"<BR />Detail: Key (log_fk)=(69) is not present in table "nxp_logs".<BR />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</P> Wed, 06 Aug 2025 17:45:37 GMT https://connect.hyland.com/t5/nuxeo-forum/issue-in-deployment-database-foreign-key/m-p/491982#M15851 SandeepAutade 2025-08-06T17:45:37Z