Relation Error in Server not Developer

Classic Servoy
1

When accessing server version of app my activity_distribution related tab is throwing a “Error in relation” dialog.

The servoy log is as follows:

2009-08-05 18:59:02,421 ERROR [RMI TCP Connection(30)-192.168.0.6] com.servoy.j2db.util.Debug -
java.lang.IllegalStateException: Could not resolve column aec_crm:activity_distributon#activitydistributon1348.1032=?
at com.servoy.j2db.persistence.ServerManager.updateColumnInfo(ServerManager.java:97)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(SQLEngine.java:896)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(SQLEngine.java:630)
at com.servoy.j2db.dataprocessing.SQLEngine.performQuery(SQLEngine.java:1018)
at sun.reflect.GeneratedMethodAccessor320.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at sun.rmi.server.UnicastServerRef.dispatch(Unknown Source)
at sun.rmi.transport.Transport$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport.handleMessages(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(Unknown Source)
at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

I have checked columns, relationships etc on both local & sever instance of mysql and all looks OK. I have pointed developer to run from server instance of mysql with no problems.

Any idea what this is would be appreciated. Thx

2

This issue seems to be on table: activity_distributon, also the column name is null, so I guess there is a relation based on a column that no longer exists ?( this situation also generates an error from the builder)

3

You would think so, this is the first thing I checked. But all columns have been verified and all dataproviders have been checked. Refer PM link

4

Can you check the database with some external tool to make sure the column(s) exist ? Maybe delete and recreate the relation ? Also you can add a case about this if sample/steps to reproduce are available.

5

http://bowtell-harris.com/servoyapptest.wmv is a 4:14 min demo of my problem

I have check “All” of my columns, deleted the relationships, created a new tables and relinked it and it has got me stumped. I have looked at it for so long I am probably blind to the problem which may seem so obvious to everyone else.

I use a 3rd part tool to “sync” database structure from the developer instance of mysql to the testing server instance of mysql all error free. I also sync’d the data also from one to the other.

When I run theapp from developer ther are no errors alerted, run from the server there is.

I have even pointed my developer to the testing servers mysql instance and no errors occur. I only get an error when the app is being accessed from the testing erver when viewing an activity/task and the related distribution table in a tab.

Head in my hands and hairless…

6

What happens if you export from developer and clean import to the test server ? Still have this issue ? If so, you can open a case and attach the sample. What value you have for: startRepositoryAsTeamProvider. Are you sure the server version is the same as developer version (structure and data; tring a clean import will make this clear) ?

7

Clean install on test server has the same problem. startRepositoryAsTeamProvider = true

The dev and server are both 4.13 build 672

8

For the Servoy guys, I logged a case in the support system a couple of weeks ago that looks very similar to this one. Case #229819

9

4xjbh:
Clean install on test server has the same problem. startRepositoryAsTeamProvider = true

The dev and server are both 4.13 build 672

Can you open a case then in our support system ? (with sample attached)

10

Case has been opened: SVA:233058

11

I tried the sample in the case, however I cannot reproduce the issue. I import in a 4.1.3 install (using sybase) and everything works ok. Are you sure it doesn’t work if you import the sample in a “clean” repository ?

12

Ok, I think I figured out this one. Managed to reproduce in Servoy 4.1.3 with Mysql 5.1 . However, is already fixed in latest code, so it should work in next release (4.1.4 - planned for next week).

13

We have exactly this same issue in Servoy 5.01, was is solved in 4.1.4? What can we do to get this running?

Thanks.

14

marcelb:
We have exactly this same issue in Servoy 5.01, was is solved in 4.1.4? What can we do to get this running?

Thanks.

Do you have a sample ? How to reproduce it ?

15

Importing the solution again and clear the client Java-cache solved this issue for me now.

Thanks.