Only 7 original database servers in Resources ?

Questions and answers for all installation-related topics for Servoy products

Only 7 original database servers in Resources ?

Postby gdurniak » Mon Oct 29, 2012 4:15 pm

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
Last edited by gdurniak on Mon Oct 29, 2012 5:19 pm, edited 1 time in total.
File Shoppe
gdurniak
 
Posts: 232
Joined: Thu Jul 08, 2004 7:25 pm
Location: Bayside, NY, USA

Re: Only 7 original database servers in Resources ?

Postby mboegem » Mon Oct 29, 2012 5:10 pm

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!
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Mon Oct 29, 2012 5:43 pm

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

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Mon Oct 29, 2012 10:30 pm

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

Re: Only 7 original database servers in Resources ?

Postby ptalbot » Mon Oct 29, 2012 10:59 pm

Can we place bets on how many warnings you'll get?
I'd say about 10.000 :)
Patrick Talbot
Freelance - Open Source - Servoy Valued Professional
https://www.servoyforge.net
Velocity rules! If you don't use it, you don't know what you're missing!
User avatar
ptalbot
 
Posts: 1654
Joined: Wed Mar 11, 2009 5:13 am
Location: Montreal, QC

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Mon Oct 29, 2012 11:57 pm

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

Re: Only 7 original database servers in Resources ?

Postby mboegem » Tue Oct 30, 2012 9:57 am

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.

gdurniak wrote:- 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.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Only 7 original database servers in Resources ?

Postby jcompagner » Tue Nov 06, 2012 11:49 pm

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.

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

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Wed Nov 07, 2012 12:13 am

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

Re: Only 7 original database servers in Resources ?

Postby mboegem » Wed Nov 07, 2012 12:17 am

jcompagner wrote: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.
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: Only 7 original database servers in Resources ?

Postby jcompagner » Wed Nov 07, 2012 12:43 am

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

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Wed Nov 07, 2012 1:25 am

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

Re: Only 7 original database servers in Resources ?

Postby jcompagner » Wed Nov 07, 2012 11:33 am

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

Re: Only 7 original database servers in Resources ?

Postby gdurniak » Wed Nov 07, 2012 12:14 pm

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

Re: Only 7 original database servers in Resources ?

Postby jcompagner » Wed Nov 07, 2012 1:34 pm

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

Next

Return to Installation

Who is online

Users browsing this forum: No registered users and 5 guests

cron