Troubles with Upgrade from 2.x to 3.x (Oracle)

Classic Servoy
1

I currently have Servoy 2.x and am upgrading to Servoy 3.x. I installed 3.x into its own directory, and copied the .properties file from the 2.x directory into the 3.x directory. Finally, I exported the solutions from the 2.x version and moved them into the solutions folder of the 3.x directory.

Everything uses Oracle 9.

The current repository is obviously the one built with vesion 2.x. That’s fine. I run the 3.x version and the first thing it does is pop up a window saying an old repository verson was found and do I want to upgrade the repository. I say “OK”. It immediately comes back with a “Cannot create repository”. I click Details and it says:

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: ORA-00955: name is already used by an existing object

But of course the table names, etc. already exist - the old repository is there! I can’t figure out what this is trying to tell me and how to fix it. Any help is much appreciated.

Thanks!

2

When you perform a major upgrade you should start with a fresh database and create a new repository in that. Create a new empty database and then edit the servoy.properties of Servoy 3 and change the name of the database used for the Repository, at first boot Servoy will ask you if you want to build a repository on that db, say yes and when done import back all your solutions. This procedure allows you to leave the old Servoy installation untouched so you can revert to it if any problem occurs.

3

The fresh install (without old repository present) worked… I will lose my user data, but will grab that from the old copy.

Thanks!

4

You can include the users as well in a solution export. Check the export dialog in developer.

Anyway you should file a bug report for the error you received, it’s not good practice to update a Repository with a Servoy major release (IMO) but it should work anyway.