• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 32 subscribers
  • Views 361 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Failure to install Application Monitoring plug-in in Orion

alx

Hello everybody,

 

We have upgraded from Orion 8.1 to 8.5 on a Windows 2003 Server box and we are using a remote SQL Server 2005 64-bit on Windows 2003 Server box as well.

 

All is well, but when I try to install the Application Monitoring plug-in, the install completes successfully, but the wizard fails with a generic error pointing me to look in the install log for more details.

 

Thinking that my Solarwinds machine may be suspect, I wiped it out and reinstalled everything from scratch (however pointed the install to the existing Solarwinds database) and I still got the same error...

 

The install log read like this:

 

2007-09-21 14:19:42,923 [1] INFO  Program - Configuration Wizard Starting.
2007-09-21 14:19:43,126 [1] DEBUG IISHelper - Parsed IIS binding string of "172.20.24.105:80:".  Address is "172.20.24.105" and port is "80"
2007-09-21 14:19:43,423 [1] DEBUG SWLicense - Unrecognized configuration string "".  Defaulting to Full.
2007-09-21 14:19:49,438 [1] DEBUG SWLicense - Unrecognized configuration string "".  Defaulting to Full.
2007-09-21 14:19:49,438 [1] DEBUG SWLicense - Unrecognized configuration string "".  Defaulting to Full.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Database Server Name - servername
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Database User - SolarWindsNPM
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Use SQL Security - True
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Database Name - NetPerfMon
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Create New Database - False
2007-09-21 14:19:50,423 [1] INFO  SettingsController - SQL Account - SolarWindsNPM
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Website IP - 172.20.24.105
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Website Port - 80
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Website Folder - C:\InetPub\SolarWinds
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Database' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Website' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Network Performance Monitor' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Alerting Service' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Syslog Service' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Trap Service' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Custom MIB Polling Service' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'SolarWinds Module Engine Service' from 'Orion Network Performance Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'Application Monitor Database' from 'Application Monitor' plugin will be configured.
2007-09-21 14:19:50,423 [1] INFO  SettingsController - Component 'Application Monitor Website' from 'Application Monitor' plugin will be configured.
2007-09-21 14:19:50,438 [1] DEBUG SWLicense - Unrecognized configuration string "".  Defaulting to Full.
2007-09-21 14:19:50,438 [1] DEBUG SWLicense - Unrecognized configuration string "".  Defaulting to Full.
2007-09-21 14:19:50,438 [1] INFO  ConfigurationProgressScene - Shutting down services ...
2007-09-21 14:19:50,438 [1] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsCustomPollingService".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
2007-09-21 14:19:50,454 [1] DEBUG ConfigurationProgressScene - Configuring Plugin "Application Monitor" - Component "Application Monitor Database"
2007-09-21 14:19:50,454 [1] INFO  ConfigurationProgressScene - Updating Orion database. Processing ApplicationMonitor.DBStructure file ...
2007-09-21 14:19:51,126 [1] ERROR ConfigurationProgressScene - Could not Alter DataType of ApplicationStatistics.CPULoad to int(4)[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Length or precision specification 0 is invalid.
2007-09-21 14:19:51,126 [1] ERROR ConfigurationProgressScene - Exeception while configuring plugins.
System.Runtime.InteropServices.COMException (0x800403E9): Exception from HRESULT: 0x800403E9
   at SQLDMO.SQLServerClass.DisConnect()
   at SolarWinds.ConfigurationWizard.Plugin.Common.DBStructureProcessor.CheckDatabaseStructure(String serverName, String databaseName, String user, String password, Boolean useSQLSecurity, String fileName, ConfigurationLogDelegate log)
   at SolarWinds.ConfigurationWizard.Plugin.Common.ModuleHelper.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log, String dbStructureFile, String dbConfigFile, String initialWebConfigFile)
   at SolarWinds.ConfigurationWizard.Plugin.AppMon.AppMonPlugin.ConfigureDatabase(IOrionConfigHost host, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
   at SolarWinds.ConfigurationWizard.Plugin.AppMon.AppMonPlugin.DoConfigure(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
   at SolarWinds.ConfigurationWizard.Plugin.Common.OrionConfigPlugin.SolarWinds.ConfigurationWizard.Common.IOrionConfigPlugin.DoConfig(IOrionConfigHost host, IComponentInfo component, ConfigurationProgressDelegate progress, ConfigurationLogDelegate log)
   at SolarWinds.ConfigurationWizard.Host.ConfigurationProgressScene.DoUpdateConfig()
 

Any ideas?

 

Thank you

Alex

  • 0

    I managed to resolve it. Upon closer inspection the script is trying to change a specific column  (ApplicationStatistics.CPULoad) type to int(4).

     

    I looked into the database and the install had created the column as of type "tinyint". I changed the data type to "int" and reran the install  and wizard successfully.  

     

    I have no idea why in 64-bit SQL 2005  the column was created as a tinyint, but those are the facts..

     

    alex

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.