Login

Willkommen, Gast

Passwort vergessen?

Home Foren Allgemeines Installation Update mit Installer funktioniert nicht Antwort auf: Update mit Installer funktioniert nicht

#20514

Blacksmith
Teilnehmer

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