Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Cannot install NTA 3.1

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.

Find more posts tagged with

Accepted answers

Gustelj

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.

All comments

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

Gustelj

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

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.

Gustelj

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).

PortID	ProtocolId
-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.