I am getting an intermittent error on 2 installations of my solution ‘cannot show form data’ on the opening screen. This does not appear again only on initial show of first from.
These errors occur on startup of the client and are not always reproducible. My solution is vertical market and i have over 20 installations the same and am careful to install each with the same versions.
I have restored the customers data on my own server and cannot reproduce the error. There does not seem to be an issue with the software, seems to be working fine just an annoying error on startup (sometimes on some computers!).
table sequences have been updated for the solution database holding the data. (do i also need to do this to the repository server?)
using Servoy 2.27
MySQL 5.0.27 (repository & data)
JDBC driver 5.03
Java 1.5.06
Is there some method you perform on load of that first form, related to data possibly?
Also, did you sync the correct server?
Maybe a stupid question but to make sure that you did not, accidentally, sync your developer repository against your clients db’s?
opening Method is very simple, but will check again. But all solutions use the same startup method only 2 have errors.
I am not sure what you mean about sync developer repository against client db?
Solution was originally loaded through web admin tool using standard defaults. Data was loaded using 3rd party backend tool and then updated using servoy admin tool.
You are talking about customers so I assume it is not -your- client-server setup but a configuration at your customers location. Correct?
If so they have their own repository and their own databases.
If so you should perform the sync on the client configuration and not yours.
That is what I was referring to.
The way to do this:
bring server down;
bring developer up;
sync sequences through developer;
bring developer down;
bring server up;
Or, much easier through the webadmin pages obviously
Both installation have had their table sequences updated via web admin tool.
I do not use developer to update sequences.
On next startup the error message did not appear and believed the problem was resolved but on subsequent startups of client error has returned (sometimes not all the time! )
Only solution data sequences were updated, repository_server was not. should this be updated too?
I am using MySQL for the db. If you use MySQL you should always use query validation for the connection otherwise after a certain period you will get this error opening the client. Something to do with the driver.
This seems a intermittent issue as other sites don’t see this. Have changed all installations now using query validation for the connections.
I have the same issue and I use MySQL for the database.
In the db connection I can change the Validation Type to “query validation”.
But what should I use in the “Validation Query” box? Should I leave it empty?