Servoy Forum

Database: SQLServer2005
OS: windows7

Command Line: servoy_server.bat -upgradeRepository

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

Code: Select all

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

servoy_log.txt

Code: Select all

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.

On which Servoy version does this happen?

6.0.5

please do let me know if you need additional information.

thanks!

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?

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

new

Andrei Costescu wrote: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.

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

Good to hear that you figured it out.