Upgraded Orion NPM 8.1.3 to v9 and APM to v2. All went fine.
Upgraded NTA v2 to v3.
Below is the log for the Configuration Wizard for NTA service: Any ideas?
2008-10-12 11:19:24,638 [1] INFO Program - Configuration Wizard Starting.
2008-10-12 11:19:24,857 [1] DEBUG IISHelper - Parsed IIS binding string of "172.30.1.4:80:". Address is "172.30.1.4" and port is "80"
2008-10-12 11:20:58,965 [1] INFO SettingsController - Database Server Name - LAUSS1101\LAUSS1101SQL2005
2008-10-12 11:20:58,965 [1] INFO SettingsController - Database User - SolarWindsNPM
2008-10-12 11:20:58,965 [1] INFO SettingsController - Use SQL Security - True
2008-10-12 11:20:58,965 [1] INFO SettingsController - Database Name - NetPerfMon
2008-10-12 11:20:58,965 [1] INFO SettingsController - Create New Database - False
2008-10-12 11:20:58,965 [1] INFO SettingsController - SQL Account - SolarWindsNPM
2008-10-12 11:20:58,965 [1] INFO SettingsController - Website IP - 172.30.1.4
2008-10-12 11:20:58,965 [1] INFO SettingsController - Website Port - 80
2008-10-12 11:20:58,965 [1] INFO SettingsController - Website Folder - C:\InetPub\SolarWinds
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'Orion Network Performance Monitor Database' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'Orion Network Performance Monitor Website' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Network Performance Monitor' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Alerting Service' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Syslog Service' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Trap Service' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Universal Device Poller' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds Module Engine Service' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'Orion Information Service' from 'Orion Network Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'APM Database' from 'Application Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'APM Website' from 'Application Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'APM Job Engine Plugin' from 'Application Performance Monitor' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'NetFlow Database' from 'NetFlow Traffic Analyzer' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'NetFlow Website' from 'NetFlow Traffic Analyzer' plugin will be configured.
2008-10-12 11:20:58,965 [1] INFO SettingsController - Component 'SolarWinds NetFlow Traffic Analyzer Service' from 'NetFlow Traffic Analyzer' plugin will be configured.
2008-10-12 11:20:58,981 [1] INFO ConfigurationProgressScene - Shutting down services ...
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "SWOrionInformationService".
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "NetPerfMonService".
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsAlertingEngine".
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsSyslogService".
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "SolarWindsTrapService".
2008-10-12 11:20:58,981 [5] DEBUG ConfigurationProgressScene - Stopping service "SWJobSchedulerSvc".
2008-10-12 11:20:58,997 [5] DEBUG ConfigurationProgressScene - Stopping service "SWJobEngineSvc".
2008-10-12 11:20:58,997 [5] DEBUG ConfigurationProgressScene - Stopping service "OrionModuleEngine".
2008-10-12 11:20:58,997 [5] DEBUG ConfigurationProgressScene - Configuring Plugin "NetFlow Traffic Analyzer" - Component "NetFlow Database"
2008-10-12 11:20:58,997 [1] INFO ConfigurationProgressScene - Updating Orion database. Processing NetFlowTrafficAnalysis.DBStructure file ...
2008-10-12 11:22:05,465 [1] INFO ConfigurationProgressScene - Updating Orion database. Processing NetFlowDatabaseScheme.dbConfig file ...
2008-10-12 11:25:37,323 [5] ERROR DBConfigProcessor - Error while executing script - The statistics 'SourcePortOriginal' is dependent on column 'SourcePortOriginal'.
ALTER TABLE ALTER COLUMN SourcePortOriginal failed because one or more objects access this column..
2008-10-12 11:25:37,323 [5] ERROR DBConfigProcessor - Failing Sql command:
--
-- C:\Build\SourceCode\Dev\Main\Orion\Netflow\Src\Config\SQL Scripts\Migrate\UpgradeOriginalPortsType.sql
--
--
-- Change SourcePortOriginal and DestPortOriginal columns type
--
if(dbo.GetNetflowDbVersion() < 12)
begin
declare @nodeCount int
declare @query nvarchar(2000)
declare @parmDefinition nvarchar(500)
set @parmDefinition = N'@nodeCountOut int OUTPUT'
set @query = N'select @nodeCountOut = count(*) from nodes'
execute sp_executesql @query, @parmDefinition, @nodeCountOut = @nodeCount output
create table #tmpNodes (tmpid int identity, nodeID int)
insert into #tmpNodes select NodeID from Nodes
declare @row int
set @row = 1
while(@row <= @nodeCount)
begin
declare @tableName nvarchar(100)
declare @node nvarchar(100)
set @parmDefinition = N'@rowIn int, @nodeIdOut int output'
set @query = N'select @nodeIdOut = NodeID from #tmpNodes Where tmpId = @rowIn';
execute sp_executesql @query, @parmDefinition, @rowIn = @row, @nodeIdOut = @node output
set @row = @row + 1
set @tableName = 'NetFlowDetail_' + @node
set @query = N'if exists (select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ''' + @tableName + ''')
begin
alter table ' + @tableName + ' alter column SourcePortOriginal int NOT NULL
alter table ' + @tableName + ' alter column DestPortOriginal int NOT NULL
end'
exec sp_executesql @query
end
drop table #tmpNodes
end
2008-10-12 11:25:37,323 [5] ERROR ConfigurationProgressScene - Error while executing script- The statistics 'SourcePortOriginal' is dependent on column 'SourcePortOriginal'.
ALTER TABLE ALTER COLUMN SourcePortOriginal failed because one or more objects access this column.
