AnsweredAssumed Answered

Operations Dashboard making improperly formatted SQL date calls

Question asked by DownerNewZealand on Nov 24, 2015
Latest reply on Nov 25, 2015 by jfpeagle-co-nz-esridist

We have an operations Dashboard that displays water maintenance jobs and their priorities/statuses for our clients. We would like the ability to create filters to show only jobs that are becoming due (i.e. within the next 24 hours).

Our featureclass contains the targeted date information and I can create the filter (TargetDate Is Within the Next 24 Hours) but this causes our server logs to light up with Severe level error messages as per the tech article here.

AGSError1.JPG

What is even more strange is that the error is reporting on a different date field we are not even using for our filter. It would also seem that our instance dislikes the errors to the point of becoming unresponsive with our portal and servers hanging for about 15 minutes or so. When everything eventually comes back up, this is all the server logs give us to go on.

AGSError2.JPG

Has anyone had to deal with this issue before? Is this potentially a Operations Dashboard bug? Has anyone had success creating filters based on date fields for their own dashboards?

Outcomes