DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 2533953 - Last Review: June 24, 2011 - Revision: 1.3

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.


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.

APPLIES TO
  • Windows 7 Enterprise
  • Windows 7 Professional
  • Windows 7 Service Pack 1
  • Windows 7 Ultimate
  • Microsoft Application Compatibility Toolkit 5.0
  • Windows Server 2008 R2 Datacenter
  • Windows Server 2008 R2 Enterprise
  • Windows Server 2008 R2 Foundation
  • Windows Server 2008 R2 Service Pack 1
  • Windows Server 2008 R2 Standard
Keywords: 
KB2533953
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support