Error Saving Data

Classic Servoy
1

Hi all

I have a strange problem with one of my solutions, an HR solution. Sometimes, only in Servoy Client, when my customer tries to add a record or click out to save data after an edit, there is an error “Error saving data”, no further info is given. The data IS saved and it seems to work otherwise. It is VERY annoying as the error sometimes happens after every edit / add, and sometimes does not happen at all. This error cannot be reproduced in Servoy Developer. The solution has been deployed in two different companies and both of them have the problem. In one of these companies, the server this solution is on also hosts a MUCH bigger servoy solution which does not have this problem. There are no errors in the Servoy log nor is there an exclamation mark down at the bottom indicating any problem. I have not seen this problem with any other of my solutions. There are no onRecordEditStart or onRecordSave methods (the only two form methods are: onNewRecordCommand (forms.master_form.controller.newRecord(true)
elements.title.requestFocus()) and an onLoad foundsetFilterParameter method - which had not been implemented by the time I deployed the solution to the first customer, so the problem is definitely not that)

I’d be grateful for any ideas

Bevil

Picture 45.png
Picture 45.png954×676 72.1 KB

2

Thunder:
I’d be grateful for any ideas

Bevil

Ciao, Bevil

just guessing:
trying to write non-conform data? (eg: a number o int column is receiving text data or stuff like that). I’m asking because it happened to me ;-)

trying to do something before the record is saved? What happens if you add a controller.saveData in your method?

something java-related? Try to activate the java console in the client, to see if you can capture the error.

Last thing: which db are you using?

3

Hi Bevil

Couple of more thoughts:

  • do you have one or more ‘not null’ fields that sometimes are not being populated?

  • is their connection to the DB the problem ie: if the system is remotely hosted are they losing the connection temporarily, or maybe losing a WiFi signal (have a client where the office microwave would kill the WiFi connection - very difficult to isolate that problem!)

Best of luck

Graham Greensalll
Worxinfo Ltd

4

Hi Ric and Graham

I’m not trying to write non conforming data (I am writing a number sequence into a text field called employee_id but this is not illegal)

I haven’t tried adding a controller.saveData into it but I cannot reproduce this problem in Developer, how does developer differ from client in this respect??

How do I activate the java console?? (I have tried watching my OS X console while the problem happens but naturally the problem doesn’t occur while I try to watch for it.)

Using Sybase all the way. One thing about my Sybase is that to speed things up, I duplicated tables and then changed primary keys in Sybase Central but again, I think this was done after deploying the first solution which also has the problem

I have no “not null” fields apart from the pks in any table

There is no problem with the connection to the database for a number of reasons. First is that it is all hosted locally. Second is that one of the two deployments has two different solutions on one server and this other solution does not have this problem (the other solution uses sybase AND a remote MySQL - no problems on this much bigger solution on the same server). Third, it only happens with this particular solution in two separate deployments (but not in Developer on my machine), not with any of my other solutions out there.

The way I see it is that there has to be some error (like one of the ones you suggest) but since I cannot see any info about the error, nor see the log, nor have the problem locally, I find it difficult to determine who has the problem. Servoy Server log has no record of any of this.

Thanks for suggestions, any more :)

Bevil

5

Thunder:
I haven’t tried adding a controller.saveData into it but I cannot reproduce this problem in Developer, how does developer differ from client in this respect??

They shouldn’t differ, but I’d give it a check…

Thunder:
How do I activate the java console?? (I have tried watching my OS X console while the problem happens but naturally the problem doesn’t occur while I try to watch for it.)

Applications/Utility/Java/JSE 5.0/Java Preferences

See what happens: maybe you can get some useful clue…