Foundset had editted [sic] records but couldn't save it

Classic Servoy
1

Hi all,

we are having some serious problems with Servoy 5.5.2.
We have a person screen with a tab panel containing telephone numbers, emails and the like.
This panel is loaded using a custom SQL query run on on_record_select.
Intermittently the panel fails to load and we get messages like these in the log:

INFO  - Debug - couldn't load dataset because foundset had editted records but couldn't save it
couldn't load dataset because foundset had editted records but couldn't save it
Couldn't do a sort because there where edited records on this foundset
INFO  - Debug - couldn't load dataset because foundset had editted records but couldn't save it
couldn't load dataset because foundset had editted records but couldn't save it
Couldn't do a sort because there where edited records on this foundset
INFO  - Debug - couldn't load dataset because foundset had editted records but couldn't save it
couldn't load dataset because foundset had editted records but couldn't save it
Couldn't do a sort because there where edited records on this foundset

How can we get to the bottom of this problem?
What do I need to look for?
How can I find out what is not saving?

I have an on_error handler, but it is not triggered by this problem.

C.

2

You could try to use databaseManager.getEditedRecords() in an application output to start figuring out which data is not saved.

3

Yes, I have done that now. I have inserted some code to send me an email and alert the users if it happens. Now they notice when the phone up the wrong people…

4

do you have autosave disabled?

that could be a cause that the foundset still has not saved records and autosave is false and because of that the records will not be saved until saveData() is called.

5

It should not be. I rarely switch autosave off. I added a save just before that load and Servoy has stopped sending my the emails, so I guess the problem is solved.