Servoy Forum

For several of the tables we're serving we're getting the following warning message come up in the server log

Code: Select all

Could not connect next foundset chunk (218,-1), re-loading entire PK set of datasource: db:/mydb/tablename

Not sure exactly what this means.

this has noting to do with mobile

if you get this that means that when servoy tries to load the next batch of 200 but it sees that the 201 isn't the one that it expects (we remember the pk that should come next)
then we try to search for it a bit, if that doesn't work we reload the entire pk set and you see that warning.

that the 201 pk that we expect to be there isn't the one that we get back if we ask for 201-400 could be because of deletes, updates or inserts on those records so that the pk set is really changed.
for example if you have 1-200 loaded but you insert a bunch of records that if you now would ask for 1-200 those new inserts would fall into that set (somewhere)
then because of those additions 201 is not what we expect it to be if we would ask for 201-400