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’.
3. Your blood pressure is way to high
The Solution is: