8 Replies Latest reply on Feb 19, 2009 7:01 AM by tdvojmoc

    Cannot install NTA 3.1

    tdvojmoc

      The Configuration Wizard says that my database is not v3.0 and cannot continue, stating that the database should be upgraded to v3.0 first.

      Once, I had a v2.2.1 installed on the same machine, but I don't want to do the upgrade. I want fresh install. I thought that I've already completely uninstalled v2.2.1 months ago. I don't have any Flow*.* or Netflow*.* tables in the database and I don't have the access to older version (v3.0) of Netflow Analyzer. Please help.

        • Re: Cannot install NTA 3.1
          Yann

          Could you post the ConfigurationWizard.log file to see if there are any additional information about the error inside it?

          don't have any Flow*.* or Netflow*.* tables

          Can you list the tables you currently have in the database?

          Thanks,

          Yann

            • Re: Cannot install NTA 3.1
              tdvojmoc

              Could you post the ConfigurationWizard.log file to see if there are any additional information about the error inside it?

              I installed NPM 9.1 SP4 immediately before I've tried to install NTA 3.1. Following is my yesterday's ConfigurationWizard.log file

              -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

              2009-02-16 14:34:46,667 [1] INFO  Program - Configuration Wizard Starting.
              2009-02-16 14:34:46,792 [1] DEBUG IISHelper - Parsed IIS binding string of ":80:".  Address is "" and port is "80"
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Database Server Name - DB-SERVER
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Database User - SolarWindsNPM
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Use SQL Security - True
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Database Name - NetPerfMon
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Create New Database - False
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - SQL Account - SolarWindsNPM
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Website IP - (All Unassigned)
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Website Port - 80
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Website Folder - d:\www\Solarwinds
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Database' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'Orion Network Performance Monitor Website' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Network Performance Monitor' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Alerting Service' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Syslog Service' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Trap Service' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Universal Device Poller' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds Module Engine Service' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'Orion Information Service' from 'Orion Network Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'APM Database' from 'Application Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'APM Website' from 'Application Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'APM Job Engine Plugin' from 'Application Performance Monitor' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'NetFlow Database' from 'NetFlow Traffic Analyzer' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'NetFlow Website' from 'NetFlow Traffic Analyzer' plugin will be configured.
              2009-02-16 14:35:08,526 [1] INFO  SettingsController - Component 'SolarWinds NetFlow Traffic Analyzer Service' from 'NetFlow Traffic Analyzer' plugin will be configured.
              2009-02-16 14:35:08,542 [1] INFO  ConfigurationProgressScene - Shutting down services ...
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "OrionAppPoller".
              2009-02-16 14:35:08,542 [6] INFO  ServiceProcessor - Service OrionAppPoller probably doesn't exist on this machine: Service OrionAppPoller was not found on computer '.'.
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "NetFlowService".
              2009-02-16 14:35:08,542 [6] INFO  ServiceProcessor - Service NetFlowService probably doesn't exist on this machine: Service NetFlowService was not found on computer '.'.
              2009-02-16 14:35:08,542 [6] DEBUG ConfigurationProgressScene - Stopping service "SWOrionInformationService".
              2009-02-16 14:35:08,807 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobSchedulerSvc".
              2009-02-16 14:35:09,057 [6] DEBUG ConfigurationProgressScene - Stopping service "SWJobEngineSvc".
              2009-02-16 14:35:09,307 [6] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
              2009-02-16 14:35:09,307 [6] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "NetFlow Database"
              2009-02-16 14:35:09,307 [6] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "NetFlow Website"
              2009-02-16 14:35:09,307 [6] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "SolarWinds NetFlow Traffic Analyzer Service"
              2009-02-16 14:35:09,307 [1] INFO  ConfigurationProgressScene - Restarting Services ...
              2009-02-16 14:35:09,323 [6] DEBUG DatabaseHelper - SQL Server on "DB-SERVER" reports its ProductVersion as "9.00.1399.06".
              2009-02-16 14:35:09,323 [6] DEBUG ConfigurationProgressScene - addServiceDependencies - False
              2009-02-16 14:35:09,323 [6] DEBUG ConfigurationProgressScene - version - SQL2005
              2009-02-16 14:35:09,323 [6] DEBUG ConfigurationProgressScene - dependencies -
              2009-02-16 14:35:10,682 [6] INFO  ServiceProcessor - Service NetFlowService probably doesn't exist on this machine: Service NetFlowService was not found on computer '.'.
              2009-02-16 14:35:10,682 [6] ERROR ConfigurationProgressScene - Can not change dependencies of 'NetFlowService'
              2009-02-16 14:35:10,682 [6] WARN  ServiceHelper - Exception starting service NetFlowService. System.InvalidOperationException: Service NetFlowService was not found on computer '.'. ---> System.ComponentModel.Win32Exception: The specified service does not exist as an installed service
                 --- End of inner exception stack trace ---
                 at System.ServiceProcess.ServiceController.GenerateNames()
                 at System.ServiceProcess.ServiceController.get_ServiceName()
                 at System.ServiceProcess.ServiceController.GenerateStatus()
                 at System.ServiceProcess.ServiceController.get_Status()
                 at SolarWinds.ConfigurationWizard.Common.ServiceHelper.StartService(String serviceName, TimeSpan startTimeout, String& errorMessage)
              2009-02-16 14:35:10,682 [6] ERROR ConfigurationProgressScene - Error starting Service (NetFlowService), Service NetFlowService was not found on computer '.'.
              2009-02-16 14:35:12,026 [1] INFO  ConfigurationProgressScene - Restarting ASP.Net Application ...
              2009-02-16 14:35:12,026 [6] DEBUG IISHelper - Restarting ASP.Net Application by updating "d:\www\Solarwinds\web.config".
              2009-02-16 14:35:12,026 [1] INFO  ConfigurationProgressScene - Restarting Website ...
              2009-02-16 14:35:12,635 [1] INFO  ConfigurationProgressScene - Updating website configuration file ...
              2009-02-16 14:35:12,635 [6] DEBUG IISHelper - Updating website configuration stored in "d:\www\Solarwinds\web.config".
              2009-02-16 14:35:14,526 [6] DEBUG IISHelper - Website configuration file update complete.
              2009-02-16 14:35:14,526 [1] INFO  ConfigurationProgressScene - Validating website ...
              2009-02-16 14:35:14,557 [1] INFO  ConfigurationProgressScene - Web Request for /Orion/Login.aspx failed - The remote server returned an error: (401) Unauthorized.
              2009-02-16 14:35:14,557 [1] INFO  ConfigurationProgressScene - Validating NetPerfMon Service ...
              2009-02-16 14:35:14,557 [6] DEBUG ConfigurationProgressScene - Ensuring that NetPerfMon service is available.
              2009-02-16 14:35:14,573 [1] INFO  ConfigurationProgressScene - Checking access permissions ...
              2009-02-16 14:35:14,589 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes
              2009-02-16 14:35:18,042 [1] DEBUG SqlHelper - SQL: SELECT TOP 1 NodeID FROM Nodes


              -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

              Can you list the tables you currently have in the database?

              Sorry, it took me a while to produce this, but I managed to restore NPM and APM functionality (without NTA) yesterday. The tables in my OrionNPM database currently are :

              Accounts
              ActionDefinitions
              ActiveAlerts
              AlertActions
              AlertDefinitions
              AlertLog
              Alerts
              AlertStatus
              AlertSuppression
              AlertTestLog
              AlertTests
              AlertTriggerMap
              AlertValueChanges
              APM_AlertsAndReportsData
              APM_AlertsData
              APM_Application
              APM_ApplicationAlertsData
              APM_ApplicationAvailability
              APM_ApplicationStatus
              APM_ApplicationStatus_Daily
              APM_ApplicationStatus_Detail
              APM_ApplicationStatus_Hourly
              APM_ApplicationsToDelete
              APM_ApplicationTemplate
              APM_BusinessLayer
              APM_Component
              APM_ComponentAvailability
              APM_ComponentDataToDelete
              APM_ComponentDefinition
              APM_ComponentDefinitionCategory
              APM_ComponentDefinitionCategoryMembership
              APM_ComponentDefinitionSetting
              APM_ComponentDetails
              APM_ComponentSetting
              APM_ComponentStatus
              APM_ComponentStatus_Daily
              APM_ComponentStatus_Detail
              APM_ComponentStatus_Hourly
              APM_ComponentTemplate
              APM_ComponentTemplateSetting
              APM_Config
              APM_CPUAndMemoryUsage
              APM_Credentials
              APM_CurrentApplicationStatus
              APM_CurrentComponentStatus
              APM_CurrentStatistics
              APM_CurrentStatusOfApplication
              APM_DailyApplicationAvailability
              APM_DailyComponentAvailability
              APM_EventType
              APM_ExternalSetting
              APM_PortEvidence
              APM_PortEvidence_Daily
              APM_PortEvidence_Detail
              APM_PortEvidence_Hourly
              APM_ProcessEvidence
              APM_ProcessEvidence_Daily
              APM_ProcessEvidence_Detail
              APM_ProcessEvidence_Hourly
              APM_ResourceEvidence
              APM_ResourceEvidence_Daily
              APM_ResourceEvidence_Detail
              APM_ResourceEvidence_Hourly
              APM_ResponseTime
              APM_Threshold
              APM_ThresholdsByComponent
              Applications
              ApplicationStatistics
              CiscoBuffers
              CiscoBuffers_Daily
              CiscoBuffers_Detail
              CiscoBuffers_Hourly
              CPULoad
              CPULoad_Daily
              CPULoad_Detail
              CPULoad_Hourly
              CustomPollerAssignment
              CustomPollerEnums
              CustomPollerLabels
              CustomPollerParsers
              CustomPollers
              CustomPollerScratchStatistics
              CustomPollerStatistics
              CustomPollerStatistics_Daily
              CustomPollerStatistics_Detail
              CustomPollerStatistics_Hourly
              CustomPollerStatus
              DailyNodeAvailability
              DeletedCustomPollers
              DeletedInterfaces
              DeletedNodes
              DeletedVolumes
              Engines
              Events
              EventTypes
              ExternalWebsites
              InterfaceCustomPollerJobs
              InterfaceErrors
              InterfaceErrors_Daily
              InterfaceErrors_Detail
              InterfaceErrors_Hourly
              Interfaces
              InterfaceSignalNoise
              InterfaceSignalNoise_Daily
              InterfaceSignalNoise_Detail
              InterfaceSignalNoise_Hourly
              InterfaceTraffic
              InterfaceTraffic_Daily
              InterfaceTraffic_Detail
              InterfaceTraffic_Hourly
              IPAddressGroups
              Limitations
              LimitationTypes
              MenuBars
              MenuItems
              NodeCustomPollerJobs
              Nodes
              Pollers
              PortsProtocols
              ResourceProperties
              Resources
              ResponseTime
              ResponseTime_Daily
              ResponseTime_Detail
              ResponseTime_Hourly
              ServicePorts
              Settings
              SNMPV3Credentials
              SysLog
              SysLogActions
              SysLogFacilities
              SysLogRules
              SysLogSeverities
              TimeUnits
              TransportProtocols
              TrapActions
              TrapRules
              TrapRulesDetail
              Traps
              TrapVarbinds
              TypesOfService
              Views
              ViewsByDeviceType
              VirtualMachines
              VirtualMachinesView
              VMHostNodes
              VMHostScratch
              VMInterfaces
              VMScratch
              VMStatistics
              VMStatistics_Daily
              VMStatistics_Detail
              VMStatistics_Hourly
              Volumes
              VolumeUsage
              VolumeUsage_Daily
              VolumeUsage_Detail
              VolumeUsage_Hourly
              WebCommunityStrings
              WebSettings
              Websites
              WebUserSettings

                • Re: Cannot install NTA 3.1
                  Yann

                  The following tables are from an old NTA installation:

                  IPAddressGroups, ServicePorts, TransportProtocols, TypesOfService

                  You can delete these tables and try to re-run the configuration wizard.

                  I am not sure for the table PortsProtocol...I could not find it in any database here.

                  Could you check what is inside it?

                  Before to modify anything please ensure you backed up your database.

                    • Re: Cannot install NTA 3.1
                      tdvojmoc

                      IPAddressGroups, ServicePorts, TransportProtocols, TypesOfService

                      You can delete these tables and try to re-run the configuration wizard.

                      Deleting these tables didn't help. The message of Configuration Wizard is the same

                       

                      I am not sure for the table PortsProtocol...I could not find it in any database here.

                      Could you check what is inside it?

                      The PortsProtocols table has only two columns: PortID (int4) and ProtocolID (int4).

                      PortIDProtocolId
                      -1-1
                      0-1
                      1-1
                      2-1
                      3-1
                      5-1
                      7-1
                      9-1
                      11-1
                      13-1
                      17-1
                      18-1
                      19-1
                      20-1
                      21-1
                      22-1
                      23-1
                      25-1
                      27-1
                      ......
                      3389-1
                      81-1

                      Total number of rows is 5036. I remember last two ports configuring in NTA 2.2.1, so the table could be from there.

                        • Re: Cannot install NTA 3.1
                          Yann

                          Assuming you backed up your database, it seems safe for me to delete the PortsProtocols table.

                          If that still does not help, the problem could be caused by the registry.

                          Check if the below registry keys trying to find something related to an old NTA:

                          \HKEY_LOCAL_MACHINE\SOFTWARE\SolarWinds\Orion\NetFlow Traffic Analyzer

                          HKEY_LOCAL_MACHINE\SOFTWARE\SolarWinds.net\NetFlow Traffic Analysis

                           

                          If you see something defining NTA 2.2.1 , backup your registry and delete the key. try to reinstall then NTA 3.1.

                          I do not know for the moment, based on which registry key, database setting  this warning message is triggered.

                          I would advise you to open support ticket if the above suggestions did not help.

                          Thanks,

                          Yann

                            • Re: Cannot install NTA 3.1
                              tdvojmoc

                              I do not know for the moment, based on which registry key, database setting this warning message is triggered.

                              I would advise you to open support ticket if the above suggestions did not help.

                              I've deleted the DB table and both registry keys (in one of them were the traces of v 2.2.1.), but no luck. Our registry is quite populated with "netflow" from Toolsets, which are also installed on the same server. I've opened support ticket #81603.

                              Thanks for your help so far.

                                • Re: Cannot install NTA 3.1
                                  davidmaltby

                                  Just based on what I'm reading in this thread, I believe that all you need to do to the database is drop the dbo.GetNetFlowDbVersion function.  You can do that by running the following T-SQL:

                                  DROP FUNCTION [dbo].[GetNetflowDbVersion]

                                  Or you can delete it in the SQL Server Management Studio UI in the left pane under the database in the Programmability\Functions\Scaled-valued Functions.  Right click on it and click "Delete"

                                   

                                  Thanks,

                                  David

                                   

                                    • Re: Cannot install NTA 3.1
                                      tdvojmoc

                                      Just based on what I'm reading in this thread, I believe that all you need to do to the database is drop the dbo.GetNetFlowDbVersion function.  You can do that by running the following T-SQL

                                      Support helped me with the link to version 3.0 and the two-step installation was successful. I would rather not try dropping SQL function now, although it sounds intriguing. ;-)

                                      Thanks anyway.