JavaScript errors after upgrade
soxfanjim
Posts: 16
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:
My installation went along without a hitch according to the instructions. Ours is a single server install running on a Windows 2008 R2/IIS7 machine with a SQL Server 2008 R2 repository. We are using a domain account as the base monitor connection. The server configuration and authentication is unchanged from our v2.3 installation.
- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> - <System> <Provider Name="SQL Monitor 3" /> <EventID Qualifiers="0">0</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2012-03-28T19:54:43.000000000Z" /> <EventRecordID>237</EventRecordID> <Channel>Red Gate Software</Channel> <Computer>MyServer.MyDomain.com</Computer> <Security /> </System> - <EventData> <Data>2012-03-28 19:54:43,056 [8] ERROR RedGate.Response.UI.Website.Controllers.DisplayErrorsController [(null)] - Client javascript error RedGate.Response.UI.Website.Controllers.ClientJavascriptException: Failed Page Url: / User Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729) at http://localhost:8080/static/3.0.0.1573/Scripts/RedGate.Response.js:line 190</Data> </EventData> </Event>
My installation went along without a hitch according to the instructions. Ours is a single server install running on a Windows 2008 R2/IIS7 machine with a SQL Server 2008 R2 repository. We are using a domain account as the base monitor connection. The server configuration and authentication is unchanged from our v2.3 installation.
Comments
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
Test Engineer
Red Gate
Decide wisely...
http://rcpx-sqlmonitor:8080/static/3.0. ... esponse.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
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.
Failed
Is the error that I am getting, but did not receive in the EAP.
The update can be downloaded from here : http://www.red-gate.com/products/dba/sq ... r/download
(use the 'Returning customer installer download' link on the right)
Regards
Chris
Test Engineer
Red Gate
Thanks,
Stefka
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
Test Engineer
Red Gate
We are unaware of any problems with the upgrade between these two builds and I've just ran a successful upgrade here to test this.
I'm not sure what's happened here but it does sound like the upgrade has failed in some way. If running the installer again doesn't work then it is possible to uninstall / reinstall without losing anything. As long as you specify the existing SQL Monitor database in the "Set up Data Repository" step of the installer then the data will be upgraded.
Regards
Chris
Test Engineer
Red Gate
Regards
Chris
Test Engineer
Red Gate
Apologies for this, we really hoped we'd fixed this in the latest release. I'll reopen the bug.
If you could possibly zip up and email in the SQL Monitor log files on your base monitor machine this might help us find the cause. The location of the log files is explained on this support page: http://www.red-gate.com/supportcenter/c ... LogFilesKB
If you could send them to chris.spencer@red-gate.com that would be great.
Regards
Chris
Test Engineer
Red Gate