Search the FirstSpirit Knowledge Base
Hallo zusammen,
ich habe hier in einem Schema unter anderen drei Tabellen mit Beziehungen zueinander.
1. locationlist_international
2. location_companytype
3. location_countrycodes
Von Tabelle 2 und 3 besteht eine 1:n Beziehung zu Tabelle 1
Ich habe nun die Beziehung 3 zu 1 gelöscht, dann die Tabelle 3 gelöscht.
Danach eine neue Tabelle angelegt und versucht, von dieser ebenfalls eine 1:n beziehung zu Tabelle 1 zu erstellen.
Nun lässt sich das Schema nicht mehr speichern.
n:n Beziehungen lassen sich weiterhin anlegen und auch speichern.
Fehlermeldung:
FSVersion=FSVersion=4.2.446.45868#2643
550703063741738092 - dewe0125 (Arnold Scheuch), session: 550703063741738092, project: 10160, ip: 10.101.37.118
(de.espirit.firstspirit.client.action.SaveAction): SaveAction.actionPerformed() - de.espirit.or.SchemaException: de.espirit.or.SchemaException: com.ibm.db2.jcc.a.ho: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MASTER.FK_LOCATIONLIST_IN;INDEX, DRIVER=4.3.85
Fehler beim Datenbankzugriff:
de.espirit.or.SchemaException: com.ibm.db2.jcc.a.ho: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MASTER.FK_LOCATIONLIST_IN;INDEX, DRIVER=4.3.85 - 17.08.2011 11:54:21
FSVersion=4.2.446.45868#2643;JDK=1.6.0_24 32bit Sun Microsystems Inc.;OS=Windows 7 6.1 x86;Date=17.08.2011 11:54:21
de.espirit.or.SchemaException: de.espirit.or.SchemaException: com.ibm.db2.jcc.a.ho: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MASTER.FK_LOCATIONLIST_IN;INDEX, DRIVER=4.3.85
at de.espirit.or.impl.generic.GenericSchemaSynchronizer.updateDB(GenericSchemaSynchronizer.java:180)
at de.espirit.or.impl.schema.SchemaImpl.updateDBTables(SchemaImpl.java:390)
at de.espirit.or.impl.AbstractSessionHandler.syncSchemaWithDB(AbstractSessionHandler.java:910)
at de.espirit.or.impl.AbstractSessionHandler.syncSchemaWithDB(AbstractSessionHandler.java:75)
at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.syncSchemaWithDB(ContentManagerImpl.java:1260)
at de.espirit.firstspirit.content.ContentManagerImpl.syncSchema(ContentManagerImpl.java:663)
at sun.reflect.GeneratedMethodAccessor2826.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)
at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:91)
at de.espirit.firstspirit.server.io.handler.CompactCall.handle(CompactCall.java:67)
at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)
at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:553)
at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:520)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
at de.espirit.common.util.SuspendableThread.run(SuspendableThread.java:36)
Caused by: de.espirit.or.SchemaException: com.ibm.db2.jcc.a.ho: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MASTER.FK_LOCATIONLIST_IN;INDEX, DRIVER=4.3.85
at de.espirit.or.impl.generic.GenericForeignKeysSynchronizer.updateDB(GenericForeignKeysSynchronizer.java:141)
at de.espirit.or.impl.generic.GenericSchemaSynchronizer.updateDB(GenericSchemaSynchronizer.java:177)
... 24 more
Caused by: com.ibm.db2.jcc.a.ho: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=MASTER.FK_LOCATIONLIST_IN;INDEX, DRIVER=4.3.85
at com.ibm.db2.jcc.a.dd.a(dd.java:676)
at com.ibm.db2.jcc.a.dd.a(dd.java:60)
at com.ibm.db2.jcc.a.dd.a(dd.java:127)
at com.ibm.db2.jcc.a.im.b(im.java:2141)
at com.ibm.db2.jcc.a.im.c(im.java:2124)
at com.ibm.db2.jcc.t4.db.k(db.java:353)
at com.ibm.db2.jcc.t4.db.a(db.java:59)
at com.ibm.db2.jcc.t4.t.a(t.java:50)
at com.ibm.db2.jcc.t4.tb.b(tb.java:200)
at com.ibm.db2.jcc.a.jm.bc(jm.java:2453)
at com.ibm.db2.jcc.a.jm.e(jm.java:3295)
at com.ibm.db2.jcc.a.jm.Tb(jm.java:633)
at com.ibm.db2.jcc.a.jm.executeUpdate(jm.java:612)
at de.espirit.or.impl.generic.GenericForeignKeysSynchronizer.updateDB(GenericForeignKeysSynchronizer.java:136)
at de.espirit.or.impl.generic.GenericSchemaSynchronizer.updateDB(GenericSchemaSynchronizer.java:177)
at de.espirit.or.impl.schema.SchemaImpl.updateDBTables(SchemaImpl.java:390)
at de.espirit.or.impl.AbstractSessionHandler.syncSchemaWithDB(AbstractSessionHandler.java:910)
at de.espirit.or.impl.AbstractSessionHandler.syncSchemaWithDB(AbstractSessionHandler.java:75)
at de.espirit.firstspirit.content.ContentManagerImpl$TemporalSessionHandler.syncSchemaWithDB(ContentManagerImpl.java:1260)
at de.espirit.firstspirit.content.ContentManagerImpl.syncSchema(ContentManagerImpl.java:663)
at sun.reflect.GeneratedMethodAccessor2826.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at de.espirit.firstspirit.io.DefaultServerHandler.callManager(DefaultServerHandler.java:62)
at de.espirit.firstspirit.server.io.handler.ManagerCall.doCall(ManagerCall.java:91)
at de.espirit.firstspirit.server.io.handler.CompactCall.handle(CompactCall.java:67)
at de.espirit.firstspirit.server.io.ManagerCallWorker.run(ManagerCallWorker.java:108)
at de.espirit.firstspirit.server.ExecutionManagerImpl$RunnableWrapper.call(ExecutionManagerImpl.java:553)
at de.espirit.firstspirit.server.ExecutionManagerImpl$ExtendedCallable.call(ExecutionManagerImpl.java:520)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at de.espirit.common.util.BoundedExecutorService$RunnableWrapper.run(BoundedExecutorService.java:419)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at de.espirit.firstspirit.client.io.ServerCaller.callManager(ServerCaller.java:372)
at de.espirit.firstspirit.io.DefaultClientHandler.callManager(DefaultClientHandler.java:49)
at de.espirit.firstspirit.client.io.RemoteManagerCaller.invoke(RemoteManagerCaller.java:52)
at de.espirit.firstspirit.server.$Proxy41.syncSchema(Unknown Source)
at de.espirit.firstspirit.store.access.templatestore.SessionHandlerImpl.syncSchemaWithDB(SessionHandlerImpl.java:123)
at de.espirit.or.impl.AbstractSession.syncSchemaWithDB(AbstractSession.java:441)
at de.espirit.firstspirit.store.access.templatestore.SchemaImpl.saveExternalAttributes(SchemaImpl.java:312)
at de.espirit.firstspirit.store.access.DefaultStoreElement.save(DefaultStoreElement.java:707)
at de.espirit.firstspirit.store.access.DefaultStoreElement.save(DefaultStoreElement.java:687)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.writeToServer(AbstractGuiStoreElement.java:632)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:584)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:568)
at de.espirit.firstspirit.client.gui.tree.store.AbstractGuiStoreElement.save(AbstractGuiStoreElement.java:555)
at de.espirit.firstspirit.client.action.SaveAction.actionPerformed(SaveAction.java:78)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at de.espirit.firstspirit.common.gui.FsButton.fireActionPerformed(FsButton.java:86)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.awt.EventQueue$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at de.espirit.firstspirit.client.AWTDispatchingEventQueue.defaultDispatchEvent(AWTDispatchingEventQueue.java:130)
at de.espirit.firstspirit.client.AWTDispatchingEventQueue._dispatchEvent(AWTDispatchingEventQueue.java:115)
at de.espirit.firstspirit.client.AWTDispatchingEventQueue.dispatchEvent(AWTDispatchingEventQueue.java:108)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
Problem bekannt?
LG Arnold Scheuch
Bitte wenden Sie sich mit dem Problem an unserem Helpdesk, damit das Problem als Bug aufgenommen werden kann.