First smartclient start leads to RepositoryException

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

First smartclient start leads to RepositoryException

Postby deezzub » Wed Jan 15, 2014 9:39 am

I get the following exception after starting Servoy and then the Smart Client the first time today.:

Code: Select all
Exception Object: com.servoy.j2db.persistence.RepositoryException: Es muss mindestens eine Schlüsselspalte exisitieren  'parameterstamm'
MSG: Es muss mindestens eine Schlüsselspalte exisitieren  'parameterstamm'
is a ServoyException
Errorcode: 221
com.servoy.j2db.persistence.RepositoryException: Es muss mindestens eine Schlüsselspalte exisitieren  'parameterstamm'
   at com.servoy.j2db.dataprocessing.SQLGenerator.createTableSQL(SQLGenerator.java:1071)
   at com.servoy.j2db.dataprocessing.SQLGenerator.getCachedTableSQLSheet(SQLGenerator.java:1009)
   at com.servoy.j2db.dataprocessing.FoundSetManager.getNewFoundSet(FoundSetManager.java:1412)
   at com.servoy.j2db.dataprocessing.FoundSetManager.getFoundSet(FoundSetManager.java:2574)
   at com.servoy.j2db.dataprocessing.JSDatabaseManager.js_getFoundSet(JSDatabaseManager.java:2611)
   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 org.mozilla.javascript.MemberBox.invoke(MemberBox.java:158)
   at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:312)
   at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1774)
   at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:837)
   at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:158)
   at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:406)
   at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3204)
   at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:156)
   at com.servoy.j2db.scripting.ScriptEngine.executeFunction(ScriptEngine.java:624)
   at com.servoy.j2db.debug.RemoteDebugScriptEngine.executeFunction(RemoteDebugScriptEngine.java:393)
   at com.servoy.j2db.scripting.ScopesScope.executeGlobalFunction(ScopesScope.java:164)
   at com.servoy.j2db.FormManager.makeSolutionSettings(FormManager.java:339)
   at com.servoy.j2db.smart.SwingFormManager.makeSolutionSettings(SwingFormManager.java:179)
   at com.servoy.j2db.debug.DebugJ2DBClient$DebugSwingFormMananger.makeSolutionSettings(DebugJ2DBClient.java:226)
   at com.servoy.j2db.FormManager$1.run(FormManager.java:168)
   at java.awt.event.InvocationEvent.dispatch(Unknown Source)
   at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
   at java.awt.EventQueue.access$200(Unknown Source)
   at java.awt.EventQueue$3.run(Unknown Source)
   at java.awt.EventQueue$3.run(Unknown Source)
   at java.security.AccessController.doPrivileged(Native Method)
   at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
   at java.awt.EventQueue.dispatchEvent(Unknown Source)
   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)
   at java.awt.EventDispatchThread.run(Unknown Source)

Es muss mindestens eine Schlüsselspalte exisitieren  'parameterstamm'
Wrapped java.lang.RuntimeException: Can't get new foundset for: QBSelect(SELECT FROM parameterstamm<db:/boss_db/parameterstamm>#parameterstamm247) (H:\servoy_workspace_git\boss\BOSS\boss$initialization.js#79)
   at H:\servoy_workspace_git\boss\BOSS\boss$initialization.js:79 (getServerPaths)
   at H:\servoy_workspace_git\boss\BOSS\boss$initialization.js:113 (onSolutionStart)


Then I tried to close the Smart Client, but I can't close the window, it shows only a gray background. I tried to start the Smart Client again from Servoy Developer. The Smart Client then shows as normal. I closed the Smart Client, started it again and then I got no exception again.

parameterstamm is a FoxPro DBF table. Why I got the above exception for the first start?
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany

Re: First smartclient start leads to RepositoryException

Postby jcompagner » Thu Jan 23, 2014 4:50 pm

some how servoy at first didn't find a primary key (or row_ident) column..
i guess that table does have a pk/row_ident?

You get this always the first time you restart a developer completely?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8833
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: First smartclient start leads to RepositoryException

Postby deezzub » Fri Jan 24, 2014 11:57 am

jcompagner wrote:some how servoy at first didn't find a primary key (or row_ident) column..
i guess that table does have a pk/row_ident?


It is a FoxPro DBF table, so in DBF is no pk, but in Servoy the is a row_ident on that table.

jcompagner wrote:You get this always the first time you restart a developer completely?


No, that was the only time.

Maybe is relates to issue SVY-5217: Error says table has no primary key, but primary key exists?
deezzub
 
Posts: 328
Joined: Tue May 28, 2013 3:02 pm
Location: Oldenburg, Germany


Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: No registered users and 19 guests