Ich habe das Projekt jetzt noch einmal komplett neu in logi.CAD importiert. Dabei bekomme ich folgende Fehlermeldungen:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcBatchUpdateException: Eindeutiger Index oder Primärschlüssel verletzt: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"
Unique index or primary key violation: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"; SQL statement:
INSERT INTO ProgramOrganizationUnitVariable (IDENTIFIER, COMMENT, CUSTOMDATAJSON, DESCRIPTION, DMA, HWADDRESS, INITIALIZATION, INSTANCEPARAM, ISCONSTANTFLAG, KEY, NAME, NOCODEGENERATION, PERSISTENCETYPE, RELATETOINSTANCEVAR, VARIABLESECTION, VARIABLEUSAGEMODE, CONCRETEDATATYPE_IDENTIFIER, DATATYPE, PROGRAMORGANIZATIONUNIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197]
Error Code: 23505
Query: UpdateObjectQuery(TcpChannel: ID: 2031, Name: RevolutionPiChannel, FileURI: platform:/resource/SISStuetze_upgrade/RevolutionPi.iecplc
Port: 1534, IP Address: 192.168.179.20
)
eclipse.buildId=unknown
java.version=11.0.1
java.vendor=AdoptOpenJDK
BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=de_DE
Command-line arguments: -os win32 -ws win32 -arch x86_64 -data @noDefault
com.logicals.projectindex
Fehler
Thu Dec 03 16:12:37 CET 2020
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcBatchUpdateException: Eindeutiger Index oder Primärschlüssel verletzt: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"
Unique index or primary key violation: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"; SQL statement:
INSERT INTO ProgramOrganizationUnitVariable (IDENTIFIER, COMMENT, CUSTOMDATAJSON, DESCRIPTION, DMA, HWADDRESS, INITIALIZATION, INSTANCEPARAM, ISCONSTANTFLAG, KEY, NAME, NOCODEGENERATION, PERSISTENCETYPE, RELATETOINSTANCEVAR, VARIABLESECTION, VARIABLEUSAGEMODE, CONCRETEDATATYPE_IDENTIFIER, DATATYPE, PROGRAMORGANIZATIONUNIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197]
Error Code: 23505
Query: UpdateObjectQuery(TcpChannel: ID: 2031, Name: RevolutionPiChannel, FileURI: platform:/resource/SISStuetze_upgrade/RevolutionPi.iecplc
Port: 1534, IP Address: 192.168.179.20
)
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcBatchUpdateException: Eindeutiger Index oder Primärschlüssel verletzt: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"
Unique index or primary key violation: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"; SQL statement:
INSERT INTO ProgramOrganizationUnitVariable (IDENTIFIER, COMMENT, CUSTOMDATAJSON, DESCRIPTION, DMA, HWADDRESS, INITIALIZATION, INSTANCEPARAM, ISCONSTANTFLAG, KEY, NAME, NOCODEGENERATION, PERSISTENCETYPE, RELATETOINSTANCEVAR, VARIABLESECTION, VARIABLEUSAGEMODE, CONCRETEDATATYPE_IDENTIFIER, DATATYPE, PROGRAMORGANIZATIONUNIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197]
Error Code: 23505
Query: UpdateObjectQuery(TcpChannel: ID: 2031, Name: RevolutionPiChannel, FileURI: platform:/resource/SISStuetze_upgrade/RevolutionPi.iecplc
Port: 1534, IP Address: 192.168.179.20
)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:161)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.lambda$2(UpdateModelAndFingerPrintsJob.java:123)
at com.logicals.common.performance.MeasuringInstrument.measureRunnable(MeasuringInstrument.java:44)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.commitModelChangesIntoDatabase(UpdateModelAndFingerPrintsJob.java:123)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.internalRun(UpdateModelAndFingerPrintsJob.java:83)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.lambda$0(UpdateModelAndFingerPrintsJob.java:52)
at com.logicals.common.performance.MeasuringInstrument.measureSupplier(MeasuringInstrument.java:106)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.run(UpdateModelAndFingerPrintsJob.java:52)
at com.logicals.projectindex.db.internal.synchronizer.UpdateModelAndFingerPrintsJob.syncRun(UpdateModelAndFingerPrintsJob.java:57)
at com.logicals.projectindex.internal.Lc3ProjectImpl.updateModel(Lc3ProjectImpl.java:101)
at com.logicals.projectindex.ProjectIndex.update(ProjectIndex.java:81)
at com.logicals.iec.st.ui.internal.StBuilderParticipant.build(StBuilderParticipant.java:53)
at org.eclipse.xtext.builder.impl.RegistryBuilderParticipant$DeferredBuilderParticipant.build(RegistryBuilderParticipant.java:161)
at org.eclipse.xtext.builder.impl.RegistryBuilderParticipant.build(RegistryBuilderParticipant.java:69)
at org.eclipse.xtext.builder.impl.XtextBuilder.doBuild(XtextBuilder.java:361)
at org.eclipse.xtext.builder.impl.XtextBuilder.fullBuild(XtextBuilder.java:392)
at org.eclipse.xtext.builder.impl.XtextBuilder.build(XtextBuilder.java:225)
at org.eclipse.core.internal.events.BuildManager$2.run(BuildManager.java:833)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:45)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:220)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:263)
at org.eclipse.core.internal.events.BuildManager$1.run(BuildManager.java:316)
at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:45)
at org.eclipse.core.internal.events.BuildManager.basicBuild(BuildManager.java:319)
at org.eclipse.core.internal.events.BuildManager.basicBuildLoop(BuildManager.java:371)
at org.eclipse.core.internal.events.BuildManager.build(BuildManager.java:392)
at org.eclipse.core.internal.events.AutoBuildJob.doBuild(AutoBuildJob.java:154)
at org.eclipse.core.internal.events.AutoBuildJob.run(AutoBuildJob.java:244)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.3.v20180807-4be1041): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.h2.jdbc.JdbcBatchUpdateException: Eindeutiger Index oder Primärschlüssel verletzt: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"
Unique index or primary key violation: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"; SQL statement:
INSERT INTO ProgramOrganizationUnitVariable (IDENTIFIER, COMMENT, CUSTOMDATAJSON, DESCRIPTION, DMA, HWADDRESS, INITIALIZATION, INSTANCEPARAM, ISCONSTANTFLAG, KEY, NAME, NOCODEGENERATION, PERSISTENCETYPE, RELATETOINSTANCEVAR, VARIABLESECTION, VARIABLEUSAGEMODE, CONCRETEDATATYPE_IDENTIFIER, DATATYPE, PROGRAMORGANIZATIONUNIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197]
Error Code: 23505
Query: UpdateObjectQuery(TcpChannel: ID: 2031, Name: RevolutionPiChannel, FileURI: platform:/resource/SISStuetze_upgrade/RevolutionPi.iecplc
Port: 1534, IP Address: 192.168.179.20
)
at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:939)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatch(ParameterizedSQLBatchWritingMechanism.java:181)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.executeBatchedStatements(ParameterizedSQLBatchWritingMechanism.java:136)
at org.eclipse.persistence.internal.databaseaccess.ParameterizedSQLBatchWritingMechanism.appendCall(ParameterizedSQLBatchWritingMechanism.java:84)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:612)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:567)
at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2096)
at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:311)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:275)
at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.updateObject(DatasourceCallQueryMechanism.java:814)
at org.eclipse.persistence.internal.queries.StatementQueryMechanism.updateObject(StatementQueryMechanism.java:437)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.updateObjectForWriteWithChangeSet(DatabaseQueryMechanism.java:1093)
at org.eclipse.persistence.queries.UpdateObjectQuery.executeCommitWithChangeSet(UpdateObjectQuery.java:86)
at org.eclipse.persistence.internal.queries.DatabaseQueryMechanism.executeWriteWithChangeSet(DatabaseQueryMechanism.java:316)
at org.eclipse.persistence.queries.WriteObjectQuery.executeDatabaseQuery(WriteObjectQuery.java:60)
at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:914)
at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:813)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWorkObjectLevelModifyQuery(ObjectLevelModifyQuery.java:110)
at org.eclipse.persistence.queries.ObjectLevelModifyQuery.executeInUnitOfWork(ObjectLevelModifyQuery.java:87)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2981)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1895)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1877)
at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1827)
at org.eclipse.persistence.internal.sessions.CommitManager.commitChangedObjectsForClassWithChangeSet(CommitManager.java:275)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsForClassWithChangeSet(CommitManager.java:195)
at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:141)
at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:4387)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1493)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1583)
at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitRootUnitOfWork(RepeatableWriteUnitOfWork.java:280)
at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitAndResume(UnitOfWorkImpl.java:1220)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:136)
... 28 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Eindeutiger Index oder Primärschlüssel verletzt: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"
Unique index or primary key violation: "PRIMARY_KEY_63D ON PUBLIC.PROGRAMORGANIZATIONUNITVARIABLE(IDENTIFIER) VALUES (2006, 1684)"; SQL statement:
INSERT INTO ProgramOrganizationUnitVariable (IDENTIFIER, COMMENT, CUSTOMDATAJSON, DESCRIPTION, DMA, HWADDRESS, INITIALIZATION, INSTANCEPARAM, ISCONSTANTFLAG, KEY, NAME, NOCODEGENERATION, PERSISTENCETYPE, RELATETOINSTANCEVAR, VARIABLESECTION, VARIABLEUSAGEMODE, CONCRETEDATATYPE_IDENTIFIER, DATATYPE, PROGRAMORGANIZATIONUNIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [23505-197]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1295)
at org.eclipse.persistence.internal.databaseaccess.DatabasePlatform.executeBatch(DatabasePlatform.java:2360)
at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeJDK12BatchStatement(DatabaseAccessor.java:928)
... 59 more