JavaScript errors after upgrade

[soxfanjim]

I just upgraded from SQL Monitor 2.3 to version 3.0. I immediately starting getting errors on the Overviews page. I seem to get it there every time. I also got it on the Analysis page after selecting a metric, then changing the Time Range value from "Last 10 mins" to "Last hour". Here's a sample of the error in XML format from the Event Viewer log:

[soxfanjim]

I encountered these errors immediately after the upgrade while testing the app from the server console. I was running Internet Explorer there (not sure which version) but run FireFox 11.0 on my desktop. I do not appear to be having JS issues when hitting SQL Monitor from my desktop via FireFox.

[Chris Spencer]

Hi

We have a known issue with IE7/IE8 browsers that we believe to be intermittent. Have you tried restarting your browser to see if this issue goes away?

Alternatively upgrading to IE9 (or switching to Chrome or Firefox) would very likely prevent this issue from reoccuring with the added benefit of making the web pages run far quicker.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate

[PDinCA]

[Brian Donahue]

I had another one of these reported yesterday. I think it's caused by a security setting that is meant to prevent cross-site scripting.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[wrighla]

I am having the same problem after my upgrade. It comes up correct on the first browser hit, after that it only shows "Loading... 0 " on each server. The top of the page shows: "An error has occurred. Try refreshing the page: the problem may be temporary.Error details
http://rcpx-sqlmonitor:8080/static/3.0.0.1573/Scripts/RedGate.Response.js: 324
Failed".

While I can use those other browsers, we have a company standard to use IE8 and would like to have it work. Is there a setting that can be changed in IE to make it work again or can a fix be put in place?

Lloyd

[Brian Donahue]

I can't replicate the problem, but I would try putting the site into the list of trusted sites.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

Could also be that the web server is closing the connection without sending any data to satisfy the jQuery request, however, I find it odd that suddenly we're having a lot of 324 errors being reported.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

I think it could also be a data-driven error, for instance some data being sent from the website doesn't conform to the JSON specification...
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[pbezanson]

Adding the SQL Monitor site to my "Trusted Sites" zone seems to have resolved the problem for me. (At least for now.)

It seems reasonable to think that if you remove it from your Trusted Sites zone, you may be one step closer to duplicating this problem.

IMHO, this is a serious compatibility issue with the most widely used browser on the internet. (Yes, I know IE is declining rapidly in popularity but, at least for now, it appears to still be in the lead.) Moreover, many companies have business critical web applications that prevent them from moving to other browsers (or even other versions of Internet Explorer). Switching to another browser just isn't an option in many cases and certainly no solution to this problem.

Hopefully, adding the SQL Monitor site to the Trusted Sites zone will be a workable solution for others as it seems to have been for me. Thanks for the suggestion.

[Brian Donahue]

Thanks for following up. I did try to replicate the issue without success, but only by creating a host entry pointing to localhost and then using that hostname in the URL for the SQL Monitor website. I suppose Windows is smart enough to know that the alias is the same computer in that case.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[SQLGator]

http://sqlprod40:81/static/3.0.0.1575/Scripts/RedGate.Response.js: 324
Failed

Is the error that I am getting, but did not receive in the EAP.

[Chris Spencer]

We've just updated the v3.0 release build to 3.0.0.1593. This update includes a few maintenance fixes but notably uses a newer version of JQUERY which could potentially fix any issues with IE7/IE8. As we've been unable to reproduce this particular error internally we can't guarantee however that it will be resolved.

The update can be downloaded from here : http://www.red-gate.com/products/dba/sql-monitor/download
(use the 'Returning customer installer download' link on the right)

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate

[chefi_d]

Hello, I just upgraded to v 3.0.0.1575, but I still have databases showing Offline status in SQL Monitor. Would build 1593 resolve this issue? How can I be sure that my current license key allows me to upgrade to 1593 if I decide to do this? Are there any specific when upgrading to it?
Thanks,
Stefka

[Chris Spencer]

Yes the 'databases offline' issue should be fixed in build 1593. This wasn't a straightforward fix and we'd appreciate it if you could let us know if the new build resolves the issue for you.

If you've got a v3 license key (or current support & upgrades) then it should still work with the new build.

Any issues let us know.

Regards
Chris
_________________
Chris Spencer
Test Engineer
Red Gate