upgradeRepository issue

Questions and Answers on installation, deployment, management, locking, tranasactions of Servoy Application Server

upgradeRepository issue

Postby Providence1 » Sun Mar 04, 2012 7:20 am

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.
Attachments
Screen shot 2012-03-04 at 12.02.57 AM.png
Screen shot 2012-03-04 at 12.02.57 AM.png (36.9 KiB) Viewed 4459 times
Providence
Providence1
 
Posts: 456
Joined: Tue Aug 17, 2004 2:36 am
Location: New York, NY

Re: upgradeRepository issue

Postby jcompagner » Tue May 01, 2012 8:46 am

so you moved to a new database, where you just created a fresh new repository? And you did get that error?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: upgradeRepository issue

Postby Providence1 » Tue May 01, 2012 7:50 pm

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

Ever seen this behavior before?
Providence
Providence1
 
Posts: 456
Joined: Tue Aug 17, 2004 2:36 am
Location: New York, NY

Re: upgradeRepository issue

Postby jcompagner » Thu May 03, 2012 12:57 pm

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
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: upgradeRepository issue

Postby gdurniak » Sat May 23, 2020 2:28 pm

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
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA


Return to Servoy Server

Who is online

Users browsing this forum: No registered users and 6 guests