2 Replies Latest reply on Oct 13, 2008 9:19 AM by msouth

    NTA v3 upgrade failure

      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.