I had a default installation of 4 final developer working well, then after a normal application restart (no hard crash or force quit etc.) my database servers disappeared. The installation had been configured with the sample DB connections and one custom MySQL connection. They are all currently missing from Servoy Developer. The database servers node contains no items. How do I get my DB Servers back?
Also, my servoy_properties file now contains no db connections at all!
I see this error in the log
2008-08-18 08:37:48,613 ERROR [Thread-2] com.servoy.j2db.util.Debug - Throwable
com.servoy.j2db.persistence.RepositoryException: Could not find repository server: 'repository_server'
at com.servoy.j2db.persistence.ServerManager.getRepositoryServer(Unknown Source)
at com.servoy.j2db.server.ApplicationServer.initFromSerclipse(Unknown Source)
at com.servoy.eclipse.core.ServoyModel.startAppServer(ServoyModel.java:147)
at com.servoy.eclipse.core.util.SplashHandler$1.run(SplashHandler.java:37)
at java.lang.Thread.run(Thread.java:613)
I’m going through the same thing this morning, but I was attributing my difficulties to lack of sleep.
Even if I click the preference to start the application server upon startup, even if I use a new workspace so i can start over at the Welcome screen, all db connections are x’d out. If I try to use the checkout wizard I simply get an error saying the database server is not accepting connections. In Activity Monitor there is no dbserv process running …
I’m sure the answer is simple, but just to let you know you are not the only one trying to figure out why the dbservers are all unavailable…
Can you have a look at servoy.properties and make sure everything is fine ? So a server( and only one) named repository_server must be present. Otherwise maybe there is an earlier exception in the log that prevents the servers from initializing ?
About invalid servers issue probably the sybase database is not started. You can check sybase log for errors if this is the case …
The issue for me is not X’d out db servers, it is that the db server connection properties were completely wiped out somehow by Servoy after a Developer restart. Sybase is started, and if I r-eadd the connection manually all is well. The bigger issue here I guess is not how I get the connections back (I can add them back manually), but what happened internally that wiped out my servoy_properties file in the first place?!
I can confirm startup problems with Sybase DB as well some time ago. viewtopic.php?p=54517
I did a fresh install and all is fine since.
Cannot say what is the cause but for sure Sybase DB refuses to start now and then.
Just a tip on debugging connections and server startup from the SQL Anywhere side of things.
If you are having trouble getting your server started, try adding “-Z” switch to your command line (case sensitive). This will dump out a bunch of extra information to the server console during startup that may indicate why a server fails to start. You can also use this with the “-o ” to cause all of the database server startup messages to be written to a file which you can inspect later to determine why the server failed to start.
You can also debug from the client side if you are unable to connect by adding “LOG=” to your connection string. This will write a bunch of debug messages related to the connection process to a file, which you can inspect later to determine what went wrong.
Thanks, Jason, but your answer seems to pertain to starting a separate server. All I’m trying to do is run Servoy Developer 4.0 locally on my Mac, using the default/embedded ASA. I am not trying to start an actual server. I’ve done fresh install of Servoy, machine restart, trashed all other versions of Servoy, cannot get 4.0 properly started (i.e., with the example solution servers and repository server available). Since I"m not starting a server (service) via command line, but only trying to start up Servoy Developer and start a new solution, what would your recommendation be?
Please also see the thread at viewtopic.php?f=11&t=11058 with a complete description of what I’ve tried so far.
She renamed the install directory from to Servoy_4-0-0_final afterwards and this caused the connections (and more, like the launcher string ) to disappear.
Renaming the install directory to the old name made them reappear.
So Servoy 4/Eclipse seems to be very sensitive on changing names of your install directory.