How to Update Application Compatibility Toolkit 5.6 Database to Process Windows 7 or Windows Server 2008 R2 SP1 Logs

Symptoms

The Application Compatibility Toolkit version 5.6 log processing server does not process logs gathered from Windows 7 or Windows Server 2008 R2 machines with Service Pack 1 installed. These logs are moved to the Failed folder on the log share and the data is not entered into the database.

Cause

This is due to the fact that the ACT 5.6 database does not have an entry describing Windows 7 Service Pack 1 or Windows Server 2008 R2 Service Pack 1 and therefore does not recognize the operating system of the computer that created the log.

Resolution

To resolve this problem, an entry describing Windows 7 Service Pack 1 or Windows Server 2008 R2 Service Pack 1 must be added to the ACT database's Dbo.OS table. To do so, run the following SQL statement against the database that the ACT log processing service is using:

To enable the parsing of Windows 7 Service Pack 1 logs:

INSERT INTO.[dbo].[OS]
           ([osID]
           ,[osName]
           ,[majorVersion]
           ,[minorVersion]
           ,[buildNumber]
           ,[servicePackName]
           ,[servicePackMajor]
           ,[servicePackMinor]
           ,[csdVersion]
           ,[productType]
           ,[suite]
           ,[publishedDate])
     VALUES
           (N'6.1.1'
           ,N'Windows 7 SP1'
           ,6
           ,1
           ,0
           ,N'Service Pack 1'
           ,1
           ,0
           ,N'Service Pack 1'
           ,0
           ,0
           ,'2011-02-22')
GO



To enable the parsing of Windows Server 2008 R2 Service Pack 1 logs:

INSERT INTO [dbo].[OS]
([osID]
,[osName]
,[majorVersion]
,[minorVersion]
,[buildNumber]
,[servicePackName]
,[servicePackMajor]
,[servicePackMinor]
,[csdVersion]
,[productType]
,[suite]
,[publishedDate])
VALUES
(N'6.1.1.SRV'
,N'Windows Server 2008 R2 SP1'
,6
,1
,0
,N'Service Pack 1'
,1
,0
,N'Service Pack 1'
,3
,0
,'2011-02-22')
GO

Once the statement is executed successfully, any logs that failed to process can be moved back to the Uncompressed folder and will be processed by the ACT log processing service.


Properties

Article ID: 2533953 - Last Review: Jun 24, 2011 - Revision: 1

Feedback