Relation Error

Classic Servoy
1

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/
getWebStartURL 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

2

Hi Erich,

If you look at the log - here’s the problem:

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.

3

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