I have a weird occurence at one of my Perspective projects. We are using Perspective pages on IPCs to reason respective machine downtimes.
The logic is essentially going through the last 24h of the transaction group table and looking where the productive state has gone to 0, taking the following row_id and binding it to a downtime_assigned table which binds it to one of multiple selectable reasons.
The weird thing about this is that the logic works fine for some amount of time, but as the page has been idle for a period of time (30 minutes is definitely enough) the insertion of a new row to the downtime_assigned group stops working although the downtimes binding is being polled every 15 seconds.
Could someone give me some sort of explanation as to why this is happening? or a lead to look for?