Duplicate server warning ???

Hello
Version: 5.2.7 - build 1013
In my working solution i get a lot of warnings:

Relation ‘comag_to_comaguser’ is referring to a duplicate server ‘DBCOM’
Relation … is referring to a duplicate server ‘DBCOM’
In my serverlist there is only one server “dbcom” ???
(MYSQL)
There is no other server definition pointing to the same server ???

What to do ??

Best regards
Albert

Albert,

Servoy did seem to find 2 server definitions with the same content.
If you look in the db servers list in the solution explorer tree, don’t you see an icon of a double db-image?

Rob

Hello

No!
I can’t see anything unusual in the server list!
There is only one “dbcom” server. The icon for all servers is identic.

With this problem i can’t do the urgent “export solution”.

Best regards
Albert

Hi Albert,

Can you check the relationship ‘comag_to_comaguser’?
Perhaps even set the servernames again in this relationship.

Hello

I reentered the relation !
UUUUPPPS !
2 new errors!
Form xy and form xyz(parent form + related detailform) are based one a different server than the relation comag_to_comaguser.

I urgently need help!!

Regards
Albert

Albert,

Could this be a case-sensitivity issue?
If you check the .frm-file or the .rel-file, does it contain the server name in a different casing?

Rob

Hello

YES! It seems to be as casing problem.
My datasource in the forms IS DBCOM.
The reentered relation has dbcom.
The server in the serverlist shows “dbcom”

???
The application was running with DBCOM, but there were these duplicate servers warnings that make it impossible to export the solution.
Could it be, that i have(for any reason) 2 servers(DBCOM and dbcom) but only one is shown in the serverlist??

What to do ??
Search and replace DBCOM with dbcom ???
But then i think there still will be the duplicate server errors when exporting the solution.

How do delete the duplicate server definition(if there are 2?), that i can’t see in the server list.

Regards
Albert

abeermann:
How do delete the duplicate server definition(if there are 2?), that i can’t see in the server list.

Take a look at the servoy.properties file in the application_server folder, that’s the file where the servers are defined. (the lines starting with server.)
You can just remove all the lines from the server with the wrong server.X.serverName.

Make sure to stop the developer first before editing the file, otherwise your changes aren’t saved.

Hello Joas

There is only 1 server dbcom in the properties file ???

Finaly i did a search DBCOM and replace with dbcom !!!
Now everything seems to be OK ?
No more warnings and errors when exporting the solution.
Nevertheless i can’t understand how i ran into this situation.

Regards
Albert