We have created a mechanism to pick out readings that belong to a particular job (we can create jobs and assign a device and a geofence to it). This mechanism runs after the readings have entered the app database. A background task runs and looks at the readings table (much like the notifier), and decides – based on time and geofence – whether that device is part of a job or not. If it is we create a JobReading record, associating that reading with a job.
So – this mechanism runs completely independently of the readings entering our system. It runs after all triggers etc have been fired.
However – what we have noticed, is that once a device enters a geofence associated with a job, the readings no longer arrive regularly 40 seconds apart. They’re spaced several minutes apart - sometimes up to 30 minutes even.
I want to know why the readings stop coming in regularly into our app database. I cannot see any errors in any log files that might show what is going on. Alternatively, I would like to know how the above setup (with the background task that polls the readings table and writes away job_readings records when applicable) might affect readings from entering our system.
Any help would be greatly appreciated.
Thank you
Joerg
