NEED HELP – Not been able to start Servoy Server 6.1.x

[logicimpresa]

Unfortunately, it did not work.

C:\Servoy\application_server>servoy_server.bat -upgradeRepository
server starting
Exception in thread "main" java.lang.NoClassDefFoundError: com/servoy/j2db/server/main/ApplicationServer-upgradeRepository
Caused by: java.lang.ClassNotFoundException: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository. Program will exit.

The postgres.exe process started, but not Servoy server.

Capture.PNG

And of course, when I run the servoy_server.bat -upgradeRepository again, I get same error but with the warning about another pg_ctl server running.

Code: Select all

C:\Servoy\application_server>servoy_server.bat -upgradeRepository
pg_ctl: another server might be running; trying to start server anyway
server starting
The process cannot access the file because it is being used by another process.
Exception in thread "main" java.lang.NoClassDefFoundError: com/servoy/j2db/server/main/ApplicationServer-upgradeRepository
Caused by: java.lang.ClassNotFoundException: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository
        at java.net.URLClassLoader$1.run(Unknown Source)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
Could not find the main class: com.servoy.j2db.server.main.ApplicationServer-upgradeRepository.  Program will exit.

C:\Servoy\application_server>

Should I add a case for this in support? Could this be a bug?

What about the message in the postgres_log.txt file?

LOG: database system was shut down at 2012-09-11 05:30:48 PDT
FATAL: the database system is starting up
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: role "scac-team" does not exist
LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down

What does the line FATAL: role "scac-team" does not exist mean?

Thanks Johan.

Simply: The "scac-team" role not exist into the postgres database. I suppose scac-team is user of your server.

To solve you can add this role in postgres via pgadmin.

[jcompagner]

there must be a space between that, somehow that got lost in the post.

its just that that %1 is already filled in..

xxxxxx.ApplicationServer -upgradeRepository

[jcarlos]

there must be a space between that, somehow that got lost in the post.

its just that that %1 is already filled in..

xxxxxx.ApplicationServer -upgradeRepository

You won't believe what I just found out... You are going to laugh!

Well, I just realized that the problem was on the '–' ... on the dash!

This is the story. I use this recipe to install Servoy so that I don't forget the steps. It is written in MS Word with images and everything...

So, to make sure that I wasn't typing anything wrong, I copied and pasted most of the text content into a text file (Notepad) in the server, so that I could use command from there into the command line windows. I was using:

Capture1.PNG (2.5 KiB) Viewed 3847 times

Which is different to:

Capture2.PNG (2.21 KiB) Viewed 3847 times

The encoding of the dash wasn't plain text. That was the problem!

I didn’t suspect this could be the issue since I was using a text file. I realized the problem when I copied and pasted side by side the code you asked me to change in the .bat file. Then when I performed a search for -upgradeRepository, the ‘-upgradeRepository’ that I had there wasn’t being selected. I saw then a slightly different dash…


There is nothing wrong with the .bat file, or Servoy. I didn't have to change:

xxxxxx.ApplicationServer %1 %2 %3 %4 %5 %6 %7 %8 %9
to
xxxxxx.ApplicationServer -upgradeRepository[/b]

This whole thing is embarrassing.

But I am making this post for those users of Windows and Notepad…. Don’t trust Notepad!

To conclude: The installation of Servoy with the bundled PostgreSQL database is working fine. I also tried it with MySQL. I changed the servoy.properties file to MySQL, I uncommented the line that starts Postgres in the .bat file, and I added the driver. I started Servoy with MySQL without problem.

Once again, thank you for your help. I am really sorry if I caused you some distress.

Best,
Carlos


BTW, I installed yesterday Servoy Server in a very old XP computer to deploy all solutions in production, since I could not get Servoy working in my Windows 2003 server. The data is actually in the Windows Server, but Servoy is running from the old XP machine. But even so, Servoy is rocking and it is actually performing faster than before. (Before I run Servoy 5.x’s in the Windows 2003 server).

[jcarlos]

Simply: The "scac-team" role not exist into the postgres database. I suppose scac-team is user of your server. 

To solve you can add this role in postgres via pgadmin.

Thank you very much! I guess I don't have to worry about it if I don't get rid if it.

Eventually I'll use MySQL instead of PostgreSQL for the repository.

This -of course wasn't the issue at all.

Best, Carlos