Update mit Installer funktioniert nicht

[Thomas Hempel]

Hallo 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

[caf]

Hallo Blacksmith,
probieren Sie bitte den Installer ftp://ftp.nuclos.de/nuclos-branch-4.17-ci/
VG
Agni

[Thomas Hempel]

Hallo 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

[Thomas Hempel]

Hätte evtl. jemand einen Vorschlag, wie ich die fehlerhaften Constraints löschen könnte?

Danke!
blacksmith

[Thomas Hempel]

habe 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?

[Autor]

Beiträge