# Relation Error **URL:** \ **Category:** Classic Servoy\ **Created:** [March 28, 2006, 2:02pm UTC](https://forum.servoy.com/t/relation-error/5649 "2006-03-28T14:02:44Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\ **Post date:** [March 28, 2006, 2:02pm UTC](https://forum.servoy.com/t/relation-error/5649/1 "2006-03-28T14:02:44Z")
I have a tab panel located on a form built on my accounts table. The tab panel form is also built on the accounts table (Self join tab panel). On the tab panel form I have a portal that displays related records form my Credits table. The relationship from Accounts\_to\_Credits is based on account\_ID. Everything works fine in developer mode. If I flush the the solution and open in client, when I open the form it says “can’t set up form”. If I go back to developer and remove that one tabpanel from my form, flush and open client, everthning works fine. Here is my client trace: Starting Servoy from C:\Documents and Settings\ebrandt\Desktop Servoy R2 2.2.4 build-336 on Windows XP using Java 1.5.0\_06 java.net.SocketException: factory already defined java.net.SocketException: factory already defined at java.rmi.server.RMISocketFactory.setSocketFactory(Unknown Source) at com.servoy.j2db.J2DBClient.bh(Unknown Source) at com.servoy.j2db.J2DBClient.if(Unknown Source) at com.servoy.j2db.J2DBClient.main(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.javaws.Launcher.executeApplication(Unknown Source) at com.sun.javaws.Launcher.executeMainClass(Unknown Source) at com.sun.javaws.Launcher.continueLaunch(Unknown Source) at com.sun.javaws.Launcher.handleApplicationDesc(Unknown Source) at com.sun.javaws.Launcher.handleLaunchFile(Unknown Source) at com.sun.javaws.Launcher.run(Unknown Source) at java.lang.Thread.run(Unknown Source) getWebStartURL [http://10.0.0.12:8080/](http://10.0.0.12:8080/) getWebStartURL [http://10.0.0.12:8080/](http://10.0.0.12:8080/) com.servoy.j2db.persistence.RepositoryException: The table accounts or credits does not exist as defined in the relation accounts\_to\_credits\_by\_acct\_id com.servoy.j2db.persistence.RepositoryException: The table accounts or credits does not exist as defined in the relation accounts\_to\_credits\_by\_acct\_id at com.servoy.j2db.persistence.Relation.int(Unknown Source) at com.servoy.j2db.persistence.Relation.getPrimaryDataProviders(Unknown Source) at com.servoy.j2db.persistence.Relation.isGlobal(Unknown Source) at com.servoy.j2db.persistence.Solution.getRelations(Unknown Source) at com.servoy.j2db.dataprocessing.d.(Unknown Source) at com.servoy.j2db.dataui.l.a(Unknown Source) at com.servoy.j2db.dataui.i.a(Unknown Source) at com.servoy.j2db.dataui.i.a(Unknown Source) at com.servoy.j2db.FormPanel.cL(Unknown Source) at com.servoy.j2db.FormManager.if(Unknown Source) at com.servoy.j2db.FormManager.a(Unknown Source) at com.servoy.j2db.FormManager.for(Unknown Source) at com.servoy.j2db.FormManager.do(Unknown Source) at com.servoy.j2db.FormManager$3.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) java.lang.NullPointerException java.lang.NullPointerException at com.servoy.j2db.persistence.ScriptCalculation.getDependentDataProviderIDs(Unknown Source) at com.servoy.j2db.dataprocessing.h.(Unknown Source) at com.servoy.j2db.dataprocessing.r.a(Unknown Source) at com.servoy.j2db.dataprocessing.r.if(Unknown Source) at com.servoy.j2db.dataprocessing.h.a(Unknown Source) at com.servoy.j2db.dataprocessing.r.a(Unknown Source) at com.servoy.j2db.dataprocessing.r.a(Unknown Source) at com.servoy.j2db.dataprocessing.r.if(Unknown Source) at com.servoy.j2db.dataprocessing.ag.getSharedFoundSet(Unknown Source) at com.servoy.j2db.dataprocessing.ag.do(Unknown Source) at com.servoy.j2db.dataprocessing.ag.if(Unknown Source) at com.servoy.j2db.FormPanel.byte(Unknown Source) at com.servoy.j2db.FormPanel.cL(Unknown Source) at com.servoy.j2db.FormManager.if(Unknown Source) at com.servoy.j2db.FormManager.a(Unknown Source) at com.servoy.j2db.FormManager.for(Unknown Source) at com.servoy.j2db.FormManager.do(Unknown Source) at com.servoy.j2db.FormManager$3.run(Unknown Source) at java.awt.event.InvocationEvent.dispatch(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) Failed to get the scriptcalculations for globals dependcheck java.lang.NullPointerException java.lang.NullPointerException at com.servoy.j2db.persistence.ScriptCalculation.getDependentDataProviderIDs(Unknown Source) at com.servoy.j2db.persistence.ScriptCalculation.getDependentGlobalDataProviderIDs(Unknown Source) at com.servoy.j2db.dataprocessing.ay.(Unknown Source) at com.servoy.j2db.dataprocessing.ag.do(Unknown Source) at com.servoy.j2db.dataprocessing.FoundSet.(Unknown Source) at com.servoy.j2db.dataprocessing.RelatedFoundSet.(Unknown Source) at com.servoy.j2db.dataprocessing.w.(Unknown Source) at com.servoy.j2db.dataprocessing.n.a(Unknown Source) at com.servoy.j2db.dataprocessing.ag.a(Unknown Source) at com.servoy.j2db.dataprocessing.ag.a(Unknown Source) at com.servoy.j2db.dataprocessing.FoundSet.getRelatedFoundSet(Unknown Source) at com.servoy.j2db.dataprocessing.ap.getRelatedFoundSet(Unknown Source) at com.servoy.j2db.dataprocessing.ap.getValue(Unknown Source) at com.servoy.j2db.dataprocessing.ap.get(Unknown Source) at org.mozilla.javascript.ScriptRuntime.name(ScriptRuntime.java:1107) at org.mozilla.javascript.gen.c75.call(contract\_template\_id:4) at com.servoy.j2db.scripting.f.executeFunction(Unknown Source) at com.servoy.j2db.scripting.j.get(Unknown Source) at com.servoy.j2db.dataprocessing.FoundSet.getCalculationValue(Unknown Source) at com.servoy.j2db.dataprocessing.ap.getValue(Unknown Source) at com.servoy.j2db.dataprocessing.ar$1.run(Unknown Source) at com.servoy.j2db.util.ap.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Any help would be appreciated. Thanks, Erich ---
**Author:** ![bcusick](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@bcusick](https://forum.servoy.com/u/bcusick)\ **Post date:** [March 28, 2006, 5:47pm UTC](https://forum.servoy.com/t/relation-error/5649/2 "2006-03-28T17:47:02Z")
Hi Erich, If you look at the log - here’s the problem: ```auto com.servoy.j2db.persistence.RepositoryException: The table accounts or credits does not exist as defined in the relation accounts_to_credits_by_acct_id ``` So - do this: 1. Go back into your solution, check the FORM that the portal is based on. Make sure it’s using a valid ServerName and that it’s pointed to the right TABLE. 2. Go into your relation - and check the relation “accounts\_to\_credits\_by\_acct\_id” - and re-select the connection and table. That should take care of it. Hope this helps. ---
**Author:** ![ebrandt](https://avatars.discourse-cdn.com/v4/letter/e/96bed5/32.png) [@ebrandt](https://forum.servoy.com/u/ebrandt)\ **Post date:** [March 28, 2006, 5:50pm UTC](https://forum.servoy.com/t/relation-error/5649/3 "2006-03-28T17:50:49Z")
Bob, I did go back and check the relation, its a very simple relation, and it works fine when running developer. I will reselet the fields in the relation as you suggested. If that does not work I wil just create a new relation. Thanks, Erich