The Deployment Bunny

OS Deployment, Virtualization, Microsoft based Infrastructure…

  • Archives

  • Meta

Nice to know: ACT 5.6 does not process logs from W2K8R2 SP1/W7 SP1 until…

Posted by Mikael Nystrom on December 29, 2011

Well, it is easy to understand when you know why, but here is the short story.

In ACT we create an MSI file that we then run on clients to inventory applications and device drivers. When we install the MSI an agent runs and collect information which is then send to a file share. It will then be processed by the local ACT logging service and inserted into the DB. So, what is the problem then? Easy, the database does not have fields for the SP1 version of the OS…

The symptoms are:

1. All files are processed but ends up in the Failed folder

2. In the event viewer it gives you:

ACTUPLOAD: Microsoft.ApplicationExperience.Common.ObjectFramework.PersistenceException: Persistence_FlushSqlError —> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "Logical_Machine_OS_ForeignKey". The conflict occurred in database "ACT01", table "dbo.OS", column ‘osID’.

image

3. Your blood pressure is way to high

The Solution is:

http://support.microsoft.com/kb/2533953

/mike

One Response to “Nice to know: ACT 5.6 does not process logs from W2K8R2 SP1/W7 SP1 until…”

  1. Anurag said

    I was battling with this problem till i found a work around to edit the bkt/xml files and change the OS ID to something which is accepted by ACT 5.6.

    However, the solution mentioned is best.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

 
%d bloggers like this: