Can't export solution after 2.2rc5

Classic Servoy
1

After upgrading to 2.2rc5, I get an error while trying to export a solution to a file.

com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘user_access’ in server ‘user_access’.

I am reasonable certain that I never created a table named ‘user_access’ nor have I made use of any of Servoy’s built-in security features. I have some other solutions that I use to test bugs and those seem to export fine, but this is on my main solution which is quite large. I did a fresh installation from R2 2.1.2, upgraded up to 2.2rc4 and do not get this error when I export under 2.2rc4. Only problem is that I have already implemented new features in 2.2rc5.

Here is my software info:
OS: Windows 2000 Server
Servoy: 2.2rc5
DB: Microsoft SQL 2000 SP3
JDK: build 1.5.0_02-b09

Here is the log file:

Loading servoy.properties from C:\Documents and Settings\Steven Portnoy\servoy.propertiesLoading - DoneUsing RMI registry on port 1099java.net.UnknownHostException: downloads.servoy.comjava.net.UnknownHostException: downloads.servoy.com
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at java.net.URL.openStream(Unknown Source)
at com.servoy.j2db.develop.c.g.a(Unknown Source)
at com.servoy.j2db.develop.c.g$2.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘user_access’ in server ‘user_access’.com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘user_access’ in server ‘user_access’.
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.persistence.ae.for(Unknown Source)
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.develop.j$9.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘user_access’ in server ‘user_access’.com.servoy.j2db.persistence.RepositoryException: com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘user_access’ in server ‘user_access’.
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.persistence.ae.a(Unknown Source)
at com.servoy.j2db.develop.j$9.run(Unknown Source)
at com.servoy.j2db.util.ap.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Steve in LA

2

I’m having the same problem -

com.servoy.j2db.persistence.RepositoryException: Solutions contains references to calculation or aggregate variable on nonexistent table ‘ref_author’ in server ‘ref_author’.

I also have not created or referred to any such table or server, and the soution exported perfectly well before I upgraded to rc5.

Version R2 2.2rc5-build 323
Java version 1.4.2_06-b03 (Windows XP)

3

The server is reported wrong (the same as the table), as far as I understood. So the error is actually

Solutions contains references to calculation or aggregate variable on nonexistent table ‘ref_author’ in server ‘???’.

4

When you get the name of the table in the error message,close out the repository, open solution and recreate the table in dataproviders. It will fill with the offending calcs and aggregations. Delete them and then the table.

5

That worked for me. When I created ‘user_access’, it came in with a calculation that had the same name as a calc in a different table. Strange. I deleted the calc and the table and made sure the other table’s calc was still there and it was. Then I got the same error, but this time it wanted a table named ‘fax_covers’, a table I did delete, but in SQL rather than in Servoy. I recreated that one and it came in with the original calculations that I had prior to deleting the table. I again deleted the calcs and the table, then was able to export with no error. I guess the moral is to always use Servoy to delete tables. Why did this error start with 2.2rc5 and is this really a bug or was the bug that I wasn’t getting an error before?
Thanks for the quick response,
Steve in LA

6

NP mon

HJK said ‘In Rc5 there is indeed a new check for this kind of errors.’

Whether the check should have been there is the past, who knows… but at least the repository is now cleaner.