Unable to connect to the Data Repository

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Unable to connect to the Data Repository

Postby darryl » Tue Feb 25, 2014 3:27 pm

Hi

I'm having an issue with a new install of SQL Monitor 4. The OS is Windows 2012 server, I am using the Webserver that Redgate installs rather than IIS and the backend is SQL 2012 Enterprise Edition SP1 CU5. All components are on the same server.

The SQL Server backend is in an AvailabilityGroup but not sure if that should make a difference. When I run SQL Profiler I can see lots of calls coming from "SQL Monitor - Repository" so the "SQL Monitor 4 Base Monitor" service seems to be running correctly but when I browse to the webiste I see the message:

Unable to connect to the Data Repository
Value cannot be null. Parameter name: value


I've found a Website.log file but this is empty, are there any other logs I should be looking at to try and narrow this problem down?

Thanks

Darryl
darryl
 
Posts: 2
Joined: Tue Feb 25, 2014 2:34 pm

Postby chriskelly » Wed Feb 26, 2014 5:48 pm

When you navigate to the website do things like the SQL Monitor title bar (with Overviews, Alerts etc) display? Or are you seeing the error message before this point?

Have the user account details changed at all? During installation you would have been asked to supply a user account to connect to the Base Monitor with.

If you navigate to Configuration > About and select Retrieve All Log Files, can you send the .zip to support@red-gate.com and quote the ticket number #13936 in the subject line.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby darryl » Thu Feb 27, 2014 8:40 am

Hi Chris

I literally just get the SQL Monitor graphic in the centre and this;
Unable to connect to the Data Repository
Value cannot be null. Parameter name: value


There is no title bar or anything else on the page to interact with. Since there is no toolbar I'm unsure on how to send you the logs you've requested. None of the accounts have been changed after installation.

What I have noticed are these messages in Event Viewer:

2014-02-26 15:25:04,090 [5] ERROR RedGate.Response.Engine.Alerting.Base.Service.MonitoringAndStorageService [(null)] - Will retry in 5 seconds.

2014-02-26 15:25:04,078 [5] ERROR RedGate.Response.Engine.Alerting.Base.Service.MonitoringAndStorageService [(null)] - Unhandled exception in delayed start.
System.ArgumentNullException: Value cannot be null.
Parameter name: value
at System.BitConverter.ToString(Byte[] value)
at #RVG.#esG.#tQb()
at RedGate.Licensing.Client.LicenceEngineBase.GetLicence(Int32 productCode, String productName, Int32 majorVersion, Int32 minorVersion, String location)
at #RVG.#mNH.#0IH()
at #RVG.#kNH.#3IH(Boolean )
at #eLv.#qNV..ctor(#nNV , NetworkSettingsSection , RepositorySettingsSection , CollectionSettingsSection , AlertSettingsSection , FeatureUsageSettingsSection , #ffZ , #li5c , Option`1 , Option`1 , Option`1 )
at #eLv.#dLv.#ANV()

The server I've installed this on has no internet access, is the product trying to reach your servers for activation and could this be the root of the problem?

Thanks
darryl
 
Posts: 2
Joined: Tue Feb 25, 2014 2:34 pm


Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests