SQL Reporting 2005 Calendar Control Issue/Symantec Endpoint File Protect
I have an issue with all SQL Server Reporting Services reports that use date/time parameters that has only recently started 8-21-2012 in fact, and it seems to affect all versions of IE 7-9 and XP and Windows 7. Other browsers don't have this problem, chrome and fire fox are fine.
When loading a report that uses these parameters, it is running the processor up to 100% on the client machine and takes forever to load, on under powered boxes it can literally takes minutes to load, these reports ran before in seconds.
The date/time parameters have default values like =DateAdd("d", -1, Today()) and are usually representing a range of dates From: and To:.
After the report finishes loading, changing either date field whether with the calendar control or manually typing the date causes this delay again. The page freezes and becomes unresponsive, the client machines processor is maxed out.
Even after the report refreshes or reloads, for a period of another 20 to 45 seconds the page is still unresponsive.
Changing the date/time parameter to a string, while maintaining the above default values, thus ridding the calendar control and the reports load and behave just like prior to last Tuesday.
I have no updates on my machine from Microsoft, the other client machines do not either, the server that houses reporting services has not received any updates either during the time frame that this issue started. These reports have been on the server and have not been updated in a while, so there was not a change to those.
Both the server and client machines have been re-booted to no affect.
I also have a report where I monitor rendering time of all reports, including data retrieval etc..
I can leave the parameters as Date/Time with default parameters set and so long as I set the parameters to hidden the reports run fine, fast as usual.
This leads me to believe it is related to the date picker control loading, I'm specualting but with the above testing that's the only difference.
Also tested 2 laptops that were not on the network when the problems started last week, one XP and the other Windows 7.
Both ran reports with date parameters and the date picker control flawlessly.
I've asked the network admin about any updates that might have been pushed, again looking at the client machines I can not see that any updates have been pushed in quite a while, he's checking into it, and beleives none have been.
It runs fine in BIDS.
I have also examined the execution logs, everything there is fine, it is the same from before and after this problem started.
Stored Procedure Execution Time, and Report Rendering are all very fast normally.
I have did some additional testing of this issue.
The problem causing this delay on the client machines appears to Symantec Endpoint Protection, this was the only thing that was updated on these machines.
If this is disabled, the reports run fine.
In addition, I also discovered that adding an exception for .htm file extensions in Symantec allowed me to leave the program enabled and still allowed the reports with Date/Time Pickers to run fine.
A step further in testing revealed that the hangup is occurring on the Reserved.ReportViewerWebControl.axd? (etc...) .htm that is downloaded to the Temporary Internet Files in the user folder when a date time parameter is changed or loaded and the report is ran or re-ran.
So I could also add a File exception to Symantec for a particular users Temp Internet Folder and that returned reports to normal operations as well.
So where I'm stumped now, is what is in that file that Symantec protests but then allows to download and run anyways albeit very slowly?
Adding an exception for .js or ReportServer.js does not resolve this issue.
You can't add an exception for a file in this case because Symantec doesn't allow the use of wildcards for File Names and the name of this files changes with each report and parameter change.
Uninstalling and Reinstalling Endpoint does not correct this issue. It returns as soon as end point is reinstalled and definitions are downloaded.