references to duplicate server error. Cannot export solution

Classic Servoy
1

Hi all,

I’m using Servoy 3.5 final version and is trying to export the solution to a .servoy file. However, i keep getting this error:

com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: Solution contains references to duplicate server ‘ndcusfrapps01’ in form ‘entry_honing_wt’.
com.servoy.j2db.persistence.RepositoryException: Solution contains references to duplicate server ‘ndcusfrapps01’ in form ‘entry_honing_wt’.

I’m not sure why this error comes up. It was exporting fine a few days ago. I restarted the server. I checked in connection settings and there’s only 1 “ndcusfrapps01” server name. I checked my form entry_honing_wt and there doesn’t seem to be anything out of the ordinary.

any ideas where to beging looking?

Thanks,
sammy

Servoy Developer
Version 3.5-build 513
Java version 1.5.0_02-b09 (Windows 2000)

2

Other people having trouble exporting too – Hopefully Servoy will notice this. I have spoken to several people with this same problem. Anyone successfully exporting solutions from Servoy 3.5? Other than valuelists, any ideas what else to try?

http://forum.servoy.com/viewtopic.php?t=8830
http://forum.servoy.com/viewtopic.php?p=44401

3

sammy,

In servoy 3.5 we are checking for duplicate server definitions because they were causing a lot of problems (changes via 1 server clashing with changes from the other server).

To fix the error

Solution contains references to duplicate server ‘ndcusfrapps01’ in form ‘entry_honing_wt’.

You have to go to form entry_honing_wt and change the serverName property to the name of the server that has the same login info.

Best to disable the duplicate server in your preferences.

Rob

4

alright, so i removed the other duplicate server definition, and it returned a bunch of warnings that I fixed. (deleted the log_server server defiintion since it was a duplicate)

However, i still get 2 that i can’t seem to fix:

Aggregate or calculation with name ‘lock_flag_color’ from table ‘log_server.vc_filter_process_locked’ is invalid based in solution VC_Filter_Data_Collection

Aggregate or calculation with name ‘servoy_bg_color_row’ from table ‘log_server.alp_parts_mod’ is invalid based in solution VC_Filter_Data_Collection

How do you switch the database definition from one to another in the field definitions? I would assume it’s automatic. I even tried manaully creating these two fields back in the tables, but still get the same error.

Also, exporting the solution gives me this related error message:

Solution contains references to calculation or aggregate on table ‘vc_filter_process_locked’ in nonexistent server ‘log_server’.
com.servoy.j2db.persistence.RepositoryException: Solution contains references to calculation or aggregate on table ‘vc_filter_process_locked’ in nonexistent server ‘log_server’.

Please help

Thanks,
sammy

5

sammy,

You get these messages just after a dialog that says
"Server with name ‘log_server’ is not found, but is used by calculations and aggregates "
It has a delete option, use that to delete the invalid aggregates/calcs and recreate them manually.

Rob