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.
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.
Feel free to ask any questions..
ReplyDeleteVery good solution to the problem described, podeznaya information, I liked. I would also draw your attention to this resource virtual data room review
ReplyDeleteSuper online casino is waiting for you my friend, come in and play. perfect casino blackjack Play as your intuition tells you, win as much as you can.
ReplyDelete