cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Failure to install Application Monitoring plug-in in Orion

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 Kudos
1 Reply
Level 7

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

0 Kudos