Invalid dashboard query ePO with CSR.

[anupt1986]

Started getting Invalid Dashboard query with MWG/CSR now every week one. But this gets resolved after couple of hours automatically.

I have a server task which uses the MWG's Query which was created for Web Summary-Internet Usage. This task is scheduled to run everyday twice at 7:10 am & 7:10 pm. But i get a blank report with error as "Invalid Query". When went to Queries section, noticed that the query is in invalid state with only "Details" link present. Other options of Run,Edit & Schedule were not present. On clicking the Details option , i can see that it shows all csr's- table for a table view column does not exist.

But after 2 hours, the query starts working again.

Am not able to reproduce this issue at the will. Is this a known one?

Mine setup- ePO 532, MWG 762 & MWG 774 with CSR 2.3

[jscholte]

Hi Anupt,

Could there be scheduled tasks running at that time? Things like database maintenance are usually configured to run at night. Otherwise Directory updates are scheduled more frequently. I'd check the status of the two to see when they have run and adjust if you find that they have run during times when the dashboards were unavailable.

Best Regards,

Jon