We had servoy 3.5 running and we downloaded 4.0, it said the repository needed to be upgraded. We tried to update the database and it said database could not be updated. We tried going back to 3.5 and it says Invalid object name servoy_user_properties.
We are using WIN 2003 Server
Ms SQL 2005
Any help would be nice.
The quickest way to fix your problem is set your backup back.
Or start a new repository and import your solutions.
We did fix a problem in 4.0 that was mostly visible on MS SQL when upgrading the repository.
jcompagner:
The quickest way to fix your problem is set your backup back.
Or start a new repository and import your solutions.We did fix a problem in 4.0 that was mostly visible on MS SQL when upgrading the repository.
I’m having similar problems with 4.0 and MS SQL (viewtopic.php?f=11&t=11023). When was this fix implemented?
I cant import any solutions at all with MS SQL because of problems with the repository.
we will release 4.0.1 soon.
What you now can do is create an empty database in ms sql and let servoy create there an empty new repository
then import your solutions/modules through the admin pages.
jcompagner:
we will release 4.0.1 soon.What you now can do is create an empty database in ms sql and let servoy create there an empty new repository
then import your solutions/modules through the admin pages.
Johan - unfortunately, regardless of what I do I cant get a repository in MSSQL - attempting to load solutions through Admin pages throws an error that there is no repository available. Changing to a different database is not an option unfortunately as we need to prove the tools using our current server and data structures.
Looks like our Servoy review is on hold again!
Any ETA on 4.0.1?
that is weird
if you just have an empty ms sql database in your repository database connection
then when you start eclipse and for example touch the repository database wont you then get an dialog that you can create a new repository tables?
And if you do that can you then check in a new sample solution into the repository (share the solution project)
that should work fine.
jcompagner:
that is weird
if you just have an empty ms sql database in your repository database connection
then when you start eclipse and for example touch the repository database wont you then get an dialog that you can create a new repository tables?And if you do that can you then check in a new sample solution into the repository (share the solution project)
that should work fine.
No Johan (as per the link (viewtopic.php?f=11&t=11023) I cant get Servoy to accept a new repository server.
I have a solution I have been starting to build but I cant get a repository no matter what? I have a repository_server in my servers tree and there are a number of Views showing in there but it simply errors when I try to either synch it (and Ivostinar suggest I don’t need to do that anyway) or but even in admin pages it complains that I don’t have a repository?
In Admins Page selection Solutions I get the message ‘Could not load solution list: No repository was found’ though in the admins page the repository server is correctly defined?
Looking at the repository server in SQL Server Manager there are no tables in it - so there is obviously nothing being created there when the server is defined? Just for completeness here’s what I have done:
1 Created a new database in SQL Server
2. Stopped and restarted SQL Server
3. Opened Developer - Created connection to repository server - no errors.
4. Closed and restarted Developer
5. Opened Admin Page - selected Solutions - ‘Could not load solution list: No repository was found’
What else might I do to generate the repository data Johan?
I think I must be doing something wrong Johan but for the life of me I think I’ve tried every combination of settings to get this repository available?
no going to the admin pages will not trigger a create of the repository in an empty database in de developer
That should be done in the developer you should get a message there if you want to create/upgrade a repository
what you could try is close the developer and start the application server with -upgradeRepository
so the application server will generate the repository
jcompagner:
no going to the admin pages will not trigger a create of the repository in an empty database in de developerThat should be done in the developer you should get a message there if you want to create/upgrade a repository
what you could try is close the developer and start the application server with -upgradeRepository
so the application server will generate the repository
i just tried with a new repository and of course got the ‘Upgrade…’ question about creating tables etc - to which I selected ‘All’ At this point - as usual the entire developer hangs!
How do I start the app server with that switch Johan?
see the application server directory
where we have a servoy_server.bat file
Do start with a clean empty database. dont try to upgrade one or to upgrade an already tried to upgrade one.
jcompagner:
see the application server directory
where we have a servoy_server.bat fileDo start with a clean empty database. dont try to upgrade one or to upgrade an already tried to upgrade one.
Ha - Looks like I have a repository. Thanks Johan!