Servoy Forum

I'm trying to move to Sybase 11 and when I run:

servoy_server.bat -upgradeRepository

in the command line of the application_server folder I get the following issues:

C:\Servoy\application_server>servoy_server.bat -upgradeRepository
Upgrading repository.
Error upgrading repository: com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: A column on table servoy_content_spec/server repository_server with name is_deprecated already exists

Attached is a picture of the servoy_content_spec table showing the is_deprecated culprit.

Many thanks in advance for the proper next step in this adventure.

so you moved to a new database, where you just created a fresh new repository? And you did get that error?

Yes. And I am basically stuck there as my back up of that database produces the same error.

Ever seen this behavior before?

so if you just delete all servoy tables from the repository server and then let servoy create a brand new one it fails?
That sounds like a bug, you should create a case

I think in your current setup something is gone wrong and your repository could now be in a wrong state, if you really need that repository (so you can't start over and import your solutions)
then contact support so that we can look directly in your database and try to fix it there

I realize this post is very, very old, but ...

In the Documentation for the -upgradeRepository option, please add the advice you give above e.g. "delete all servoy tables from the repository server" ( to re-build )

I needed to clean out a 7.4.3 Repository full of junk, and this important step, while obvious to you, was not to me

'Thanks !

greg