servoy_server.bat -upgradeRepository exception

Classic Servoy
1

Database: SQLServer2005
OS: windows7

Command Line: servoy_server.bat -upgradeRepository

The tables were created but it still it returned an exception. :(

Error upgrading repository: com.servoy.j2db.persistence.RepositoryException: jav
a.lang.NullPointerException

servoy_log.txt

2012-02-23 16:51:30,304 ERROR [main] com.servoy.j2db.util.Debug - Error upgrading repository  [ ]
com.servoy.j2db.persistence.RepositoryException: java.lang.NullPointerException
	at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:357)
	at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1237)
	at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:418)
	at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:527)
Caused by: java.lang.NullPointerException
	at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:252)
	... 3 more
2012-02-23 16:53:34,925 ERROR [main] com.servoy.j2db.util.Debug - Error upgrading repository  [ ]
com.servoy.j2db.persistence.RepositoryException: java.lang.NullPointerException
	at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:357)
	at com.servoy.j2db.server.Za.Zo.Zc(Zo.java:1237)
	at com.servoy.j2db.server.Za.Zo.Zb(Zo.java:418)
	at com.servoy.j2db.server.main.ApplicationServer.main(ApplicationServer.java:527)
Caused by: java.lang.NullPointerException
	at com.servoy.j2db.server.Za.Zn.createRepositoryTables(Zn.java:252)
	... 3 more

please help.

2

On which Servoy version does this happen?

3

6.0.5

4

please do let me know if you need additional information.

thanks!

5

If fails to create the Admin group.
Do you have a “servoy_groups” table with column “group_id” in your “servoy_repository” server?

Were you upgrading an old existing repository or creating a new one?

6

Andrei Costescu:
Were you upgrading an old existing repository or creating a new one?

new

7

Andrei Costescu:
Were you upgrading an old existing repository or creating a new one?

Hi Andrei,

We just migrated to SqlServer2008 and I was successful in -upgradeRepository using a new database.

Thanks for your time.

8

The cause was in my servoy.properties the catalog was blank instead of .

9

Good to hear that you figured it out.