Invalid column name 'ToS'

Don331

 We're seing the error

2007-10-31 12:27:28,438 [Scheduler] ERROR SolarWinds.Orion.NetFlow.ScheduledTask - CollapseLevel1 threw an exception.
System.Data.SqlClient.SqlException: Invalid column name 'ToS'.
Invalid column name 'ToS'.

 

All over the swdebug log.  Got all the hotfixes installed.

Anyone else? 

floyd.may

I just ran into this with another customer.  Please do the following:

1. Shut down your NetFlow collector service.
2. Run the following in SQL enterprise manager on your NTA database.  Let me know if it encounters any errors.

   declare @mycount int
   declare @query nvarchar(2000)
   DECLARE @ParmDefinition nvarchar(500)
   SET @ParmDefinition = N'@mycountout int OUTPUT'
   set @query = N'select @mycountout =count(*) from nodes'
   execute sp_executesql @query, @ParmDefinition, @mycountout = @mycount output
   create table #tmpNodes (tmpid int identity, nodeID int)
   insert into #tmpNodes select NodeID from Nodes
   declare @row int
   set @row = 1
   WHILE(@row <= @mycount)
   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 +
    ''') and not exists ( select * from INFORMATION_SCHEMA.COLUMNS
    where TABLE_NAME = ''' + @tablename + ''' and COLUMN_NAME = ''ToS'' )
    begin
    alter table ' + @tablename + ' add ToS int
    end'
    exec sp_executesql @query
   END
   drop table #tmpNodes
   
   GO

   This is an excerpt from the database upgrade script that should have run when you ran the configuration wizard after upgrading to 2.2.  You should expect this to take quite a while (minutes, maybe hours), so you should probably plan this for off-hours.
   
3. Restart your collector service.  Once restarted, the collector service should groom out the data over a period of a few hours.

Also, can you please open a Support ticket with the title "Thwack - Failed Upgrade to NetFlow 2.2" and attach your Diagnostics?  I'd like to examine why the upgrade failed.