ACT 5.6 Database Process Logs

Issue: 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.

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:
1.       Go to Start menu and open SQL Server Management Studio.
2.       Select Databases and select your ACT database.
3.       Click New Query and copy the below code as per the ACT server OS.
4.       Execute the Query.


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

To verify follow the below process:-
1.       Open SQL Server Management Studio.
2.       Select Databases and select your ACT database.
3.       Select Tables and select dbo.os.
4.       Right click and select Top 1000 rows.
5.       Verify on the right hand side if ACT OS is appeared in the list.

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.

3 thoughts on “ACT 5.6 Database Process Logs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s