Can't get SQL PI enabled on a new instance of Foglight

I'm getting our 5th instance of Foglight set up and SQL PI is proving to be difficult to get running.  I'm going into detail to hopefully answer questions ahead of time.

My set up: (the specs here are the same on my previous 4 Foglight instances which work fine)

  • Database Server
  • Management Server
  • Agent Management Server

When I add a new server to this instance to be monitored, through the "Monitor -> SQL Server" wizard, this is what my initial screen looks like before I click "Monitor"

When I click "Monitor" things go through with no problems.  I've done this over 50 times so I know the drill.

It then gets to the following screen & this runs for ~10 minutes before throwing an error:

This is the error I get after about 10+ minutes of spinning:

Now I could contact Dell but I don't give up that easily.

I add the server but without SQL PI.  That works with no problems.

I go into the administration section of the server to try to add SQL PI manually but immediately notice that there isn't a repository host attached.

(I apologize for the tiny jpg.  This is actually very easy to see but it appears the editor shrinks it down.  But under "SQL PI Repository Host" it says "No SQL PI repository attached".)

 

So I attach our repository host using step #1.

 

When I click "Apply" it now shows up under the "Repository Host" column.

I select the server to have SQL PI enabled & click the "Enable" button.

It goes through its procedure that I'm familiar with and again, for 10+ minutes it sits and spins at this box:

After the customary 10+ minutes it errors out & says:

(The error says "Failed to enable SQL PI monitoring extension")

I've reconfirmed all rights to the servers & they are the same as they are on the other 4 I set up with no problems.

Now before I contact Quest for this, is there a log I can dig into to find out why this didn't enable?  Or is there something I can look at to find out what needs to be done?  I've used this procedure several times and know it works & I am familiar with it.  It would just be nice if Foglight offered some decent error logs or why something doesn't work.  Instead you are forced to go hunting.

 

Thank you for reading this far.  Hopefully if this gets fixed here, it will help someone else as well.

  • Hi John,

     

    That's frustrating. I would take a look at the PI Repository agent log file. Navigate to Administration -> Agents -> Agent Status, locate the DB_SQL_Server_SPI_Repository agent(s) and click the log file icon to download.

    If you could also confirm the version - there is a new version 5.7.5.35 that was released yesterday (2/8) and available on support.quest.com under the "Foglight" product search.

    Regards,

    -Darren

  • In reply to Darren.Mallette:

    Darren,

    Thanks for the nudge in the direction of that log file. I'm digging into that now.
    As for the 5.7.5.35 version. That's interesting. I have 5.7.5.5 installed & that's what I've been installing since November when we came onboard as a new customer.

    Is 5.7.5.5 actually 5.7.5.05?
  • In reply to john.waclawski:

    I answered my own question about the version number, Darren. I'm on 5.7.5.30 of the SPI_Repository.
    I'm still trying to figure out my issue with connecting up though. Stay tuned!
    Thanks!
  • Hi John , usually this related due to the fact that Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) its not installed on your Windows Agent Manager

    here its the download link:
    www.microsoft.com/.../details.aspx

    As soon as you install it , it should be good to go to start using PI

    Have a nice day
  • In reply to Christian.Broce:

    Hi we are facing the same issues.

    John did you solve the problem? If so could you tell us how?

    Thanks.

    Regards,

    Eneko
  • In reply to john.waclawski:

    Hi John we are facing the same issue.

    Did you solve the problem? If so could you tell us how?

    Thanks.

    Regards,

    Eneko
  • In reply to foglight.admins:

    The most common issue with SQL PI installations are related to insufficient sizing for the Agent Manager where the database agents are located and on the PI repository server. These components may be on the same system or different servers. The Foglight for Databases Deployment guide which is available for download from Supportlink technical documentation area details the most current Sizing requirements for the Foglight database and SQL PI monitoring.

    A message like the "connection attempt failed" could be encountered on an Agent Manager that has not been adjusted with a JVM heap that is higher the default 256mb. At this sizing, the FglAM has will have database agents that are running, but the additional processing required by the PI components exceeds the JVM memory heap available on the FglAM to connect to the PI repository.

    If the environment sizing and requirements (i.e. Antivirus exclusions, CPU & Memory reservations) have been met then I would recommend opening a Service Request for a Support Engineer to assist with this issue.
  • Hi John,

    With regards to your question about logs to check for SQL PI issues.

    For SQL PI installation issues, I would recommend checking the most recent updates to the FMS log and to the SQL Server installer agent log file for the Agent Manager where the database agent is running.

    John
  • In reply to John.Sakalauskas:

    Hi this is a follow up...

    as it seems Windows 2016 OS is not supported as SQL PI or Oracle PI repository as it can be seen in the next KB:

    support.quest.com/.../231071

    Sad but true... ;)

    Hopefully this will be soon supported...

    Best regards,

    Eneko
  • In reply to foglight.admins:

    Hello,

    as I can see here:

    https://support.quest.com/kb/231071

    now is possible to install SQL PI Repository on a Wndows 2016:

    "Windows 2016 is supported as a SQL PI or Oracle PI repository server using Infobright 5.0.4 Please see KB 227950 for more details."

     

    We have contacted support, upgraded the version of Infobright to 5.04 and now we were able to enable SQL PI but only for Agents monitoring SQL Express versions:

    SQL Server version: Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) Jul 7 2017 07:14:24 Express Edition (64-bit)

    SQL Server version: Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (Intel X86) Aug 15 2017 10:26:40 Express Edition

     

    For the other agents monitoring next versions we get same errors as in the original post:

    SQL Server version: Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) Jul 7 2017 07:14:24 Standard Edition (64-bit)

    SQL Server version: Microsoft SQL Server 2012 (SP3-GDR) (KB4019092) - 11.0.6251.0 (X64) Jul 7 2017 07:14:24 Enterprise Edition: Core-based

     

    Any ideas what could be wrong John.Sakalauskas?

  • In reply to foglight.admins:

    Hi foglight.admins,

    Just to confirm, with Infobright 5.0.4 installed you are getting issues where adding the PI installation when creating a new DB agent times out and then states "Failed to establish connection to the PI repository" from the FMS?

    There shouldn't be any difference in behaviour between Express, Standard, and Enterprise editions of SQL Server as hosts. Are all of these using the same PI repository and FglAM servers, to eliminate this as the cause?

    If these are different FglAMs or PI repository, then
    - each FglAM and PI repository server must have the Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) installed. There is an error in the release notes that will be fixed in the next cartridge to correct a note that later versions are compatible. This is incorrect, it specifically must be the 2010 version.
    - The 5029 TCP port must also be open between the FMS and PI repository.
    - The sizing requirements for the FglAM and PI repository must be met or exceeded. Right now about 80% of the SQL PI issues are related to incorrect sizing or missing CPU and memory reservations.

    For logs, I can suggest trying the connection or enabling the PI extension for the agent, and then looking at the tail end (last few hundred lines) of these two files
    - FMS log
    - DB_SQL_Server_Installer log (this is on the FglAM server where the Database Agents are installed, which may not be the PI repository).

    To expedite troubleshooting, I would recommend opening a Service Request for a Support Engineer (SE) to assist with this as it is easier to investigate directly in the environment and the SE is familiar with logs coming from the DB agents.

    John
  • In reply to John.Sakalauskas:

    Hello John,

    thank you for the follow up.

    We get the next error:

    All of the Agents are using same PI repository and FglAM.

    We have a Support Case opened with all the information: SR Number:4166244

    Thank you and regards,