Home › Forum › Allgemeines › Installation › Update mit Installer funktioniert nicht
- Dieses Thema hat 4 Antworten und 2 Teilnehmer, und wurde zuletzt aktualisiert vor 4 Jahren, 4 Monaten von
Thomas Hempel.
-
AutorBeiträge
-
20 Juli 2019 um 10:56 Uhr #20487
Thomas Hempel
TeilnehmerHallo Forum,
heute wollte ich unseren Nuclos-Server von Version 4.13.0 auf 4.21.1 bringen. Ein Zwischenschritt ist auf dem FTP-Server nicht verfügbar. Leider scheitert das Update an internen Auto-Migration-Schritten, siehe unten. Wie soll ich vorgehen bzw. welchen Installer soll ich benutzen und woher bekommen? Ich würde gern auch einen größeren Schritt in Richtung der aktuellen Version gehen. Wer kann helfen?
2019-07-20 12:38:34,948 ERROR [org.nuclos.server.dblayer.impl.StandardPreparedStringExecutor] - executePreparedStatement failed with com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__4I7U5BQXMWME3OYXZIYABCZUAT'. Cannot insert duplicate key in object 'nuclos.T_AD_RELEASE'. The duplicate key value is (40000000).: INSERT INTO T_AD_RELEASE (INTID, STRAPPLICATION, STRRELEASE, STRDESCRIPTION, DATDELIVERED, DATINSTALLED, DATCREATED, STRCREATED, DATCHANGED, STRCHANGED, INTVERSION, BLBDATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [org.nuclos.server.dblayer.expression.DbId[id=40000000, fac=IDFACTORY], NUCLOS, 4.18.0012(mig), Nuclos 4.21.1, Wed Jan 09 14:32:15 CET 2019, org.nuclos.server.dblayer.expression.DbCurrentDate@3e0d027d, org.nuclos.server.dblayer.expression.DbCurrentDateTime@4396902a, AUTOSETUP, org.nuclos.server.dblayer.expression.DbCurrentDateTime@4396902a, AUTOSETUP, 1, [B@62cbce17] 2019-07-20 12:38:34,948 FATAL [org.nuclos.server.autosync.AutoDbSetup] - Error during Auto-Migration init 4.18.0012 #392: Insert into T_AD_RELEASE: org.nuclos.server.dblayer.DbException: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__4I7U5BQXMWME3OYXZIYABCZUAT'. Cannot insert duplicate key in object 'nuclos.T_AD_RELEASE'. The duplicate key value is (40000000). org.nuclos.server.dblayer.DbException: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__4I7U5BQXMWME3OYXZIYABCZUAT'. Cannot insert duplicate key in object 'nuclos.T_AD_RELEASE'. The duplicate key value is (40000000). at org.nuclos.common.dal.DalCallResult.addDbException(DalCallResult.java:78) ~[nuclos-rigid-common-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:62) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.BatchImpl.process(BatchImpl.java:128) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeBatch(StandardSqlDBAccess.java:574) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitInsert(StandardSqlDBAccess.java:1318) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitInsert(StandardSqlDBAccess.java:1) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.statements.DbInsertStatement.accept(DbInsertStatement.java:47) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.execute(StandardSqlDBAccess.java:166) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.DbAccess.execute(DbAccess.java:214) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.PersistentDbAccess.execute_aroundBody2(PersistentDbAccess.java:51) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.PersistentDbAccess$AjcClosure3.run(PersistentDbAccess.java:1) ~[nuclos-rigid-server-4.21.1.jar:?] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:66) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:72) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) ~[spring-tx-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.nuclos.server.dblayer.PersistentDbAccess.execute(PersistentDbAccess.java:50) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.executeSetupStatements(AutoDbSetup.java:718) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.runMigrationInitDDL_aroundBody2(AutoDbSetup.java:440) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup$AjcClosure3.run(AutoDbSetup.java:1) [nuclos-rigid-server-4.21.1.jar:?] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:66) [spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:72) [spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) [spring-tx-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70) [spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.nuclos.server.autosync.AutoDbSetup.runMigrationInitDDL(AutoDbSetup.java:429) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.runMigration(AutoDbSetup.java:235) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.runMigrations(AutoDbSetup.java:208) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.runUpdate(AutoDbSetup.java:193) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.autosync.AutoDbSetup.run(AutoDbSetup.java:181) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.database.SpringDataBaseHelper.autoDbSetup(SpringDataBaseHelper.java:135) [nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.web.NuclosContextLoaderListener$1.run(NuclosContextLoaderListener.java:117) [nuclos-server-4.21.1.jar:?] at java.util.TimerThread.mainLoop(Timer.java:555) [?:1.8.0_221] at java.util.TimerThread.run(Timer.java:505) [?:1.8.0_221] Caused by: java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__4I7U5BQXMWME3OYXZIYABCZUAT'. Cannot insert duplicate key in object 'nuclos.T_AD_RELEASE'. The duplicate key value is (40000000). at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:314) ~[sqljdbc4.jar:?] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.4.jar:1.4] at org.nuclos.server.dblayer.impl.StandardPreparedStringExecutor$4.perform(StandardPreparedStringExecutor.java:203) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.StandardPreparedStringExecutor$4.perform(StandardPreparedStringExecutor.java:1) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:207) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.StandardPreparedStringExecutor.executePreparedStatement(StandardPreparedStringExecutor.java:192) ~[nuclos-rigid-server-4.21.1.jar:?] at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:58) ~[nuclos-rigid-server-4.21.1.jar:?] ... 30 more
22 Juli 2019 um 07:38 Uhr #20491caf
AdministratorHallo Blacksmith,
probieren Sie bitte den Installer ftp://ftp.nuclos.de/nuclos-branch-4.17-ci/
VG
Agni27 Juli 2019 um 10:36 Uhr #20514Thomas Hempel
TeilnehmerHallo Agni,
den Installer habe ich heute probiert. Es scheint wieder das gleiche Problem zu sein.
2019-07-27 12:29:17,424 ERROR [org.nuclos.server.dblayer.impl.DataSourceExecutor] - SQL update failed with com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'XR__ST2TRUAXEAA5R5FF7AJUGDCV77' on table 'T_MD_ENTITY_GENERIC_IMPL' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.: ALTER TABLE nuclos.T_MD_ENTITY_GENERIC_IMPL ADD CONSTRAINT XR__ST2TRUAXEAA5R5FF7AJUGDCV77 FOREIGN KEY (STRUID_IMPLEMENTING_ENTITY) REFERENCES nuclos.T_MD_ENTITY (STRUID) ON DELETE CASCADE 2019-07-27 12:29:17,424 FATAL [org.nuclos.server.autosync.AutoDbSetup] - Error during Auto-Update #33: Create foreign key constraint T_MD_ENTITY_GENERIC_IMPL.XR__ST2TRUAXEAA5R5FF7AJUGDCV77 (STRUID_IMPLEMENTING_ENTITY) references T_MD_ENTITY (STRUID): org.nuclos.server.dblayer.DbException: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'XR__ST2TRUAXEAA5R5FF7AJUGDCV77' on table 'T_MD_ENTITY_GENERIC_IMPL' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. org.nuclos.server.dblayer.DbException: com.microsoft.sqlserver.jdbc.SQLServerException: Introducing FOREIGN KEY constraint 'XR__ST2TRUAXEAA5R5FF7AJUGDCV77' on table 'T_MD_ENTITY_GENERIC_IMPL' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. at org.nuclos.common.dal.DalCallResult.addDbException(DalCallResult.java:77) ~[nuclos-rigid-common-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:62) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.BatchImpl.process(BatchImpl.java:128) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeBatch(StandardSqlDBAccess.java:566) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:1333) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.mssql.MSSQLDBAccess$MSSQLStatementVisitor.visitStructureChange(MSSQLDBAccess.java:520) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:1) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.statements.DbStructureChange.accept(DbStructureChange.java:108) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.execute(StandardSqlDBAccess.java:164) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.DbAccess.execute(DbAccess.java:213) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.PersistentDbAccess.execute_aroundBody2(PersistentDbAccess.java:51) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.PersistentDbAccess$AjcClosure3.run(PersistentDbAccess.java:1) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:66) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractTransactionAspect.aj:72) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) ~[spring-tx-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_AbstractTransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:70) ~[spring-aspects-4.1.9.RELEASE.jar:4.1.9.RELEASE] at org.nuclos.server.dblayer.PersistentDbAccess.execute(PersistentDbAccess.java:50) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.autosync.AutoDbSetup.executeSetupStatements(AutoDbSetup.java:718) [nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.autosync.AutoDbSetup.runUpdate(AutoDbSetup.java:198) [nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.autosync.AutoDbSetup.run(AutoDbSetup.java:181) [nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.database.SpringDataBaseHelper.autoDbSetup(SpringDataBaseHelper.java:135) [nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.web.NuclosContextLoaderListener$1.run(NuclosContextLoaderListener.java:117) [nuclos-server-4.17.6-SNAPSHOT.jar:?] at java.util.TimerThread.mainLoop(Timer.java:555) [?:1.8.0_221] at java.util.TimerThread.run(Timer.java:505) [?:1.8.0_221] Caused by: java.sql.SQLException: Introducing FOREIGN KEY constraint 'XR__ST2TRUAXEAA5R5FF7AJUGDCV77' on table 'T_MD_ENTITY_GENERIC_IMPL' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) ~[sqljdbc4.jar:?] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642) ~[sqljdbc4.jar:?] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.4.jar:1.4] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.4.jar:1.4] at org.nuclos.server.dblayer.impl.DataSourceExecutor$2.perform(DataSourceExecutor.java:232) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.DataSourceExecutor$2.perform(DataSourceExecutor.java:1) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:189) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.DataSourceExecutor.executeUpdate(DataSourceExecutor.java:246) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.StandardPreparedStringExecutor.executePreparedStatement(StandardPreparedStringExecutor.java:190) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] at org.nuclos.server.dblayer.impl.SqlSequentialUnit.process(SqlSequentialUnit.java:58) ~[nuclos-rigid-server-4.17.6-SNAPSHOT.jar:?] ... 22 more
29 Juli 2019 um 22:04 Uhr #20527Thomas Hempel
TeilnehmerHätte evtl. jemand einen Vorschlag, wie ich die fehlerhaften Constraints löschen könnte?
Danke!
blacksmith29 Juli 2019 um 22:32 Uhr #20528Thomas Hempel
Teilnehmerhabe gerade nachgeschaut: nach einem erneut gescheiterten Versuch mit dem Installer 4.17.6 snapshot steht obiger Fehler im Log. Dieser entgleist weil
ALTER TABLE nuclos.T_MD_ENTITY_GENERIC_IMPL ADD CONSTRAINT XR__MLT5J33JD2SVIBTRHCACFF2KB7 FOREIGN KEY (STRUID_GENERIC_ENTITY) REFERENCES nuclos.T_MD_ENTITY (STRUID) ON DELETE CASCADE
scheitert.In der der angesprochenen Tabelle nuclos.T_MD_ENTITY_GENERIC_IMPL ist aber nichts drin! Daran wirds wohl liegen oder?
Weiß hier jemand was zu tun wäre?
-
AutorBeiträge