iApplicationStat / dApplicationStat

[monkeybarfan]

We have CC6 and we do not use the standard historical reports. Instead we connect to the database and write our own queries against it.

We have 2 days - 10th and 12th June - where there is no data in the dApplicatonStat view, but there is data in the iApplicationStat view.

Anyone got any ideas? I have spoken to a couple of engineers, who are not really understanding the problem - they keep referring to standard reports "Which report are you trying to run?" etc

The fact that the 11th June was ok, makes it a bit more awkward. It seems as though one of their routines to summarise the interval data into daily summaries has failed a couple of times for some reason. We can use the interval tables to extract the data we need as a workaround, but obviously there are a lot more records so it takes far longer to run.

 

[pronei]

Your Daily's for 10th and 12th are not there, interesting. I've not seen nor heard that before. What does the windows event log say happened around midnite of those 2 days?

 

[monkeybarfan]

I'm not sure, pronei, I don't have access to the server itself, only to the database.

The engineer has finally accepted there is a problem, when these 2 days were also found to be missing on the standard Historical reports (Others > Application Performance > Check All Applications > Data Range - Daily).

He reckons he has seen it before so is going to make a few calls to ascertain what the resolution was.