Home Forum Allgemeines Installation Update mit Installer funktioniert nicht

Ansicht von 5 Beiträgen - 1 bis 5 (von insgesamt 5)
  • Autor
    Beiträge
  • #20487
    Thomas Hempel
    Teilnehmer

    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
    
    
    #20491
    caf
    Administrator

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

    #20514
    Thomas Hempel
    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
    
    
    #20527
    Thomas Hempel
    Teilnehmer

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

    Danke!
    blacksmith

    #20528
    Thomas Hempel
    Teilnehmer

    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?

Ansicht von 5 Beiträgen - 1 bis 5 (von insgesamt 5)