Resources/Database Servers are missing!

Classic Servoy
1

Where are my database servers? All of the Resources/Database Servers are missing!

This is the capture image:
[attachment=2]no-database-server.GIF[/attachment]

The error message states that the solutions’ references servers are not accessible

For example:

Description: Solution ‘robotlaw’ references server ‘mysql_robotlaw’ which is not accessible (first occurence error).
Resource: robotic_articles.tbl
Path: /robotlaw/datasources/mysql_robotlaw
Location: robotlaw/datasources/mysql_robotlaw/robotic_articles.tbl
Type: Missing Server

This is the capture image:
[attachment=1]error-robotlaw.GIF[/attachment]

I attached the java.lang exception log that’s captioned:
java.lang.RuntimeException: Could not initialize table editor server is not enabled or valid

See the attachment:
[attachment=0]error-servoy-eclipse-message.txt[/attachment]

What did I did wrong? What could have gone wrong? Please help!

JC

error-servoy-eclipse-message.txt (5.92 KB)

error-robotlaw.GIF
error-robotlaw.GIF649×126 29.2 KB

no-database-server.GIF
no-database-server.GIF480×243 17.6 KB

2

BTW, I can’t create database servers either. Please help! Any idea of what it’s going on?

3

what does your servoy.property file look like (in the app server dir)
there the database are defined, are they somehow gone? or is that file corrupt?

4

servoy.properties has:

#servoy
#Wed Sep 15 15:11:51 PDT 2010
ApplicationServer.pingDelay=300
log4j.appender.configservlet=com.servoy.j2db.util.SlidingWindowAppender
log4j.appender.configservlet.layout=com.servoy.j2db.util.Log4JHTMLTableLayout
log4j.appender.configservlet.layout.dateTimeFormat=yyyy-MM-dd HH\:mm
log4j.appender.configservlet.windowSize=1000
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=%%servoy_app_server_dir%%\\servoy_log.txt
log4j.appender.file.MaxBackupIndex=1
log4j.appender.file.MaxFileSize=10MB
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d %p [%t] %c - %m%n
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d %p [%t] %c - %m%n
log4j.debug=false
log4j.logger.com.servoy.j2db.util.Debug=WARN
log4j.logger.org.apache.wicket=WARN
log4j.rootCategory=WARN, file, configservlet
servoy.didFirstTimeInit=true
servoy.objectPoolSize=50000

It looks Ok to me. Is it Ok?
Thanks a lot! JC

5

no thats almost nothing there should be server definitions in it.

6

How can I fix this? Should I just reinstall Servoy? I’d rather not because I did not backup all of the solutions… :-( But still, what I did not backup IS NOT essential. If it’s too hard to fix this, I’d rather to reinstall.

BTW, how could have this happened? I never touch the servoy.properties file directly. How can all database servers be removed?

7

I had a similar problem last year. I would replace the .ini file and the properties file to correct the problem until that did not work any longer. I tried to re-add the database servers back and received an error when attempting to save the database server:

JDBC Driver ‘oracle.jdbc.driver.OracleDriver’ not found in classpath or drivers directory: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

I copied the drivers from another developers Servoy, and it fixed the problem. My problem file seemed to be the oraclelobfix.jar.

8

I just tried similar solution but I copied the properties file from our dedicated server machine. It did not work. I get the following error from one of the database servers:

Description	Resource	Path	Location	Type
Column 'mysql_robotlaw->robotic_products_and_offerings->autonomy_significance_na_bln' appears in the DB table, but it is missing from the DB information file.	robotic_products_and_offerings.dbi	/srms_resources/datasources/mysql_robotlaw	JSON file	Column difference

I’ll try the following:

  1. I’ll install the same version of Servoy Developer in another machine
  2. Create all of the database servers I am using
  3. Copy the proprieties file from this new installation into the directory of the Servoy Developer with the problem

I’ll keep the Forum posted of any progress -or failure

9

I have decided to wipe out my Developer installation (Servoy 5.1.2) and install the new Servoy 5.2.1.

I’ll have to install Servoy Developer again anyway. Unfortunately I will lose 30 minutes of work and some non-essential solutions.

Before removing current installation, I’ll take the necessary precautions (save the workspace directories, backups, old installation directories, etc.)

I have learned a lesson: always make a hard copy backup of your current Servoy’s installation properties file, plug-ins directories, etc.

10

why would you loose your work
that is in the workspace… Those are not gone
You just miss your database connection configurations, you could just create those again (new server etc)
(or get a property file from an other install)

11

Hi Carlos,

Your workspace is usually outside your Servoy directory so installing Servoy from scratch doesn’t touch it. You simply point Developer to it again and you are ready to go.
If you have your workspace(s) inside the Servoy directory I suggest you move them out (and leave them out).

Hope this helps

12

ROCLASI:
Your workspace is usually outside your Servoy directory so installing Servoy from scratch doesn’t touch it. You simply point Developer to it again and you are ready to go.
If you have your workspace(s) inside the Servoy directory I suggest you move them out (and leave them out).

Is this valid even after installing a different (newer) version? Is it safe and a recommended practice?

I always play safe. Every time I install a new version, I first backup all solutions, server configuration, plug-ins, etc. After installation then I get the 3rd parties plug-ins back, create the db server and import the solutions. This is why I don’t know if using the existing workspace works just fine. I play safe because at work I am an “one-man-band.”

I had 5.1.2. I am now installing 5.2.1

13

Hi Carlos,

Yes it’s safe to use your existing workspace with a newer version. Servoy of course might convert some files to a newer format when there were structural changes (like it did when all form objects were moved into the form file). Of course at that point you can’t open it up anymore with an older version of Servoy.

Backing up your workspace is always good practice however. Be it using TimeMachine (on Mac) or any other backup software or by using your teamserver as your backup.

14

ROCLASI:
Hi Carlos,

Yes it’s safe to use your existing workspace with a newer version. Servoy of course might convert some files to a newer format when there were structural changes (like it did when all form objects were moved into the form file). Of course at that point you can’t open it up anymore with an older version of Servoy.

Backing up your workspace is always good practice however. Be it using TimeMachine (on Mac) or any other backup software or by using your teamserver as your backup.

Excellent. Robert thank you very much… Yeah, I learned my lesson. Backup, Backup, Backup!