Only 7 original database servers in Resources ?

We are finally upgrading from Servoy 3.1 to 6.1.

We have 46 database servers defined. Some are disabled

I installed Servoy 6 Developer, and edited the servoy.properties, to add the 46 databases

Servoy Server now shows all 46, but Servoy Deveoper still only shows the original 7 ( server0 to server6 )

I tried “synchronize” but nothing changed

Is there a “properties” file for Developer that I need to edit ?

Do the database servers need to be running to synchronize ? ( most are currently off for maintenance )

thanks!
greg

Hi Greg,

if you look closely in de properties file, you will find a property ‘ServerManager.numberOfServers’
Set this to the nr. of servers you have and you’re all set!

I did edit numberOfServers !

That fixed the server, but not Developer

greg

PS
I just tried changing the Server Preferences to TeamProvider. Now when I expand Databases in Developer, it seems to get stuck

Is there a “log” for Developer, like Server, to see what it is doing ?

in de properties file, you will find a property ‘ServerManager.numberOfServers’
Set this to the nr. of servers you have and you’re all set!

ok, false alarm, after two or three restarts of both client and server ( and turning TeamProvider on and off ) it somehow works now

however, expanding the Resource Databases now takes forever, as it apparently needs to check each of the 43 connections

yikes !

I will now hold my breath, and import our 3.1 Solution …

thanks
greg

Can we place bets on how many warnings you’ll get?
I’d say about 10.000 :)

ok, not too bad. 33 Errors, and 1,685 Warnings

Fortunately, this is not a big solution

Note to Servoy: Your upgrade process is a LOT harder than necessary

  • when the import starts, it warns that keywords are used, but does not TELL YOU WHAT THEY ARE until the end. Why is that ?

  • I had a few “test” layouts using servers no longer online, so the import stops. I had to create a dummy db to point it to, then ALLOW db changes. Why not just let me SKIP a server ?

  • if a server is offline, and I turn it ON, Developer does not see it without a Restart. “Refresh” View does not seem to work for Resources

  • the Servoy 6 Installer asks if you want to install Developer, or Server. There is no hint that selecting “Developer” installs BOTH

there are many more ( and thank GOD for Google, or I would have been lost )

greg

Can we place bets on how many warnings you’ll get?
I’d say about 10.000

gdurniak:

  • I had a few “test” layouts using servers no longer online, so the import stops. I had to create a dummy db to point it to, then ALLOW db changes. Why not just let me SKIP a server ?

Agree with you… it would be easier to have it import in 1 go and then fix the missing servers.

gdurniak:

  • the Servoy 6 Installer asks if you want to install Developer, or Server. There is no hint that selecting “Developer” installs BOTH

This is not completely true, the “developer installer” won’t install the windows service.

mboegem:

gdurniak:

  • I had a few “test” layouts using servers no longer online, so the import stops. I had to create a dummy db to point it to, then ALLOW db changes. Why not just let me SKIP a server ?

Agree with you… it would be easier to have it import in 1 go and then fix the missing servers.

But how can we then test and update columns/columninfo stuff?
If the server is not there, the solution is completely broken.
Then you can add a server but then we still don’t know if that is right, because then everything default is generated. Default pk’s , default default column values you name it
A server just needs to have all the database servers when importing.

mboegem:

gdurniak:

  • the Servoy 6 Installer asks if you want to install Developer, or Server. There is no hint that selecting “Developer” installs BOTH

This is not completely true, the “developer installer” won’t install the windows service.

And the “server” portion i guess the application_server dir, is needed for a developer.

My other option would have been to go back into Servoy 3, and delete any reference to the servers no longer used

Again, these servers no longer exist, so I don’t mind if this small part of the solution is “broken”.

My Work-Around did work. Servoy 6 created a new table in my “dummy” db, and continued with the import

Note to Servoy: The column types of this generated table somehow did not “match” ( perhaps to the dbi ), so I still ended up with a bunch of errors. This was a surprise, since Servoy created the columns, not me

Not a big deal. It’s just that a “skip” option, if possible, might come in handy sometimes

greg

If the server is not there, the solution is completely broken.

jcompagner:
mboegem wrote:
gdurniak wrote:

  • I had a few “test” layouts using servers no longer online, so the import stops. I had to create a dummy db to point it to, then ALLOW db changes. Why not just let me SKIP a server ?

Agree with you… it would be easier to have it import in 1 go and then fix the missing servers.

But how can we then test and update columns/columninfo stuff?
If the server is not there, the solution is completely broken.
Then you can add a server but then we still don’t know if that is right, because then everything default is generated. Default pk’s , default default column values you name it
A server just needs to have all the database servers when importing.

Johan, am I not right saying that you already have that info contained in the *.dbi files?
So whenever I had the possibility to skip the server I will end up with a long long list of build markers.

In that list I can see that the solution is missing db server xxxx
When I create this server I’d be able to ‘quickfix’ all the missing tables and column info.

as far as i know
we are talking about server import here…
not developer import, because developer import doesn’t stop… it just ask what server you want to use then…

I was importing my solution, using Developer

when it found a server was missing, it asked me to pick an alternate ( or cancel )

so I cancelled, and the whole import stopped. This is where a “skip” option would be nice

did I possibly miss an option ?

greg

But if it was just a test server, why not pick an alternate that you had?

For skip to be an option we have to generate the datasource directories of a datasource that is not there. (could even contain calculations and so on)
and then later on you have to be forced to define or create a db server and then we have to sync everything. but until then its in a very fuzzy state.

The server is missing dialog is one that comes up quite early i think, so it is not really in the middle of anything, i think it didn’t do much yet.

Normally I would just let this go, but I’m not sure you understand my predicament

I could not pick an alternate, because ALL our remaining datasources are managed elsewhere. I can not allow Servoy to modify them

and rather than being “forced to define or create a db server” afterwards, couldn’t I later delete the entire form ( and valuelist ) that is no longer used ?

Re-read my post above. Would it have been better to go back to Servoy 3 and delete anything not used ?

greg

But if it was just a test server, why not pick an alternate that you had?

and then later on you have to be forced to define or create a db server and then we have to sync everything

so you are developing against a database where you as a developer can’t do anything with?
Normally i would just have most stuff locally if possible so that you can play with it

So yes go to Servoy 3 and make sure that all references to that database is deleted and then do an export is a solution…

I personally would just always have a test/dump database locally on my developer where i can play with

OK, so my feature request is denied

I’m surprised that my situation is unique, and not “normal”

fortunately, I don’t plan on importing any more solutions

please add this advice to your Wiki “make sure that all references to a datasource that no longer exists is deleted and then do an export”

greg

so you are developing against a database where you as a developer can’t do anything with?

Normally i would just have most stuff locally if possible so that you can play with it

So yes go to Servoy 3 and make sure that all references to that database is deleted and then do an export is a solution