Relation Error

Questions, answers, tips and ideas on Servoy Client

Relation Error

Postby ebrandt » Tue Mar 28, 2006 4:02 pm

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.<init>(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.<init>(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.<init>(Unknown Source)
at com.servoy.j2db.dataprocessing.ag.do(Unknown Source)
at com.servoy.j2db.dataprocessing.FoundSet.<init>(Unknown Source)
at com.servoy.j2db.dataprocessing.RelatedFoundSet.<init>(Unknown Source)
at com.servoy.j2db.dataprocessing.w.<init>(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
ebrandt
 
Posts: 590
Joined: Tue Mar 30, 2004 6:54 pm
Location: largo, fl

Postby bcusick » Tue Mar 28, 2006 7:47 pm

Hi Erich,

If you look at the log - here's the problem:
Code: Select all
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.
Bob Cusick
bcusick
 
Posts: 1255
Joined: Wed Apr 23, 2003 11:27 pm
Location: Thousand Oaks, CA USA

Postby ebrandt » Tue Mar 28, 2006 7:50 pm

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
ebrandt
 
Posts: 590
Joined: Tue Mar 30, 2004 6:54 pm
Location: largo, fl


Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 3 guests

cron