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
