@UWPVIOLATOR What I would do is run the maintenance commands, and then I would open up notepad and change all the maintenance commands into select statements. I’d then ask the team to start noting what they do, when they do it concerning fog. Then I’d just start running those select statements every 15 minutes to every half hour - and when the bad row pops up, I’d ask around and see what people did during that time. I’d also look into the history table for things there during the same time. I’d look in the apache error log for something during that time. Even if you find no errors in these logs, it’s worthwhile to see what IS in there during that time, those can be clues. Then - I would begin the tedious task of reproducing the problem and identifying the single thing that is causing it. Reproducing the problem is a lot of educated guesswork based on what you think is causing the problem. If at the time the issue happens for example, someone was registering and imaging a new system - You’d have to test registering by itself - then imaging - using the same image they did - and possibly even in debug mode to identify the single thing that is doing it. Just as example. What I’m expecting though is it’s being caused by something being done in the web GUI - you guys just need to figure out what that thing is - and narrow in on it by separating out variables & unknowns and testing individual things. Example - I don’t know if my application isn’t working or if my antivirus is blocking it. Well, uninstall the AV and try. You have to isolate. And to begin isolating, you have to have a general idea of what you’re isolating.
