Answered by:
ACT 5.6: ACTUPLOAD: Violation of PRIMARY KEY constraint 'Application_Report_PK' - Issues

Question
-
Hi,
I'm using ACT 5.6 for Data Collecion. My ACT-DB is running on SQL Server 2005. I've already updated the table dbo.OS for collecting compatibility data of W7 SP1 and WS2K8R2 SP1. However, the log processing service cannot upload data to the ACB-DB for several Clients (W7 & WXP) anymore (?!?).
I get the following events:
Event Type: Warning
Event Source: ACT-LPS
Event Category: None
Event ID: 1017
Date: 12/20/2011
Time: 10:41:43 AM
User: N/A
Computer: MUCS0161
Description:
[queuer.exe] [Queuer] Cannot insert log file \\MUCS0161\ACT$\Uncompressed\BKT-MUCW402636-000-{DE212383-9771-418F-9D03-04C52FCC8BF9}.xml to the database! Details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.and:
Event Type: Error
Event Source: ACTUpload
Event Category: None
Event ID: 0
Date: 12/20/2011
Time: 10:41:43 AM
User: N/A
Computer: MUCS0161
Description:
ACTUPLOAD: System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'Application_Report_PK'. Cannot insert duplicate key in object 'dbo.Application_Report'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlCommandBatch.ExecuteBatch()
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlCommandBatch.AddToBatch(SqlCommand aCommand, ObjectInfo relatedObjectInfo)
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlPersistenceService.InsertObject(SqlConnection aConnection, SqlTransaction trans, ObjectInfo objectToInsert, ISqlCommandHandler commandBatch, IAudit auditor)
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlPersistenceService.FlushAllAdded(SqlConnection aConnection, SqlTransaction trans, ObjectInfoCollection insertedObjects, IAudit auditor)
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlPersistenceService.Flush(IdentityMap theCache, AssociationCache anAssociationCache, IAudit auditor, Role currentRole, SqlConnection myConnection, SqlTransaction trans, PostEnumerationCallback snapshot)
at Microsoft.ApplicationExperience.Common.ObjectFramework.SqlPersistenceService.FlushCache(IdentityMap theCache, AssociationCache anAssociationCache, IAudit auditor, Boolean useSeparateConnection, PostEnumerationCallback callback)
at Microsoft.ApplicationExperience.Common.ObjectFramework.ObjectContext.Flush(Boolean useSeparateConnection, PostEnumerationCallback snapshot)
at Microsoft.ApplicationExperience.Common.DataManipulation.XmlDataProcessor.FlushXmlDocument(PostEnumerationCallback snapshot, Boolean& requiresPostProc)For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Any ideas/solutions? ;)Thans, Thomas
Tuesday, December 20, 2011 10:24 AM
Answers
-
Hi Thomas,
I notice the issue is not only occurs on Windows 7 clients. It is recommended to post in SQL Server for help.
http://social.msdn.microsoft.com/forums/en-US/category/sqlserver/
Niki
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
Niki Han
TechNet Community Support
- Marked as answer by Niki Han Friday, December 30, 2011 8:30 AM
Wednesday, December 21, 2011 10:42 AM
All replies
-
Hi Thomas,
I notice the issue is not only occurs on Windows 7 clients. It is recommended to post in SQL Server for help.
http://social.msdn.microsoft.com/forums/en-US/category/sqlserver/
Niki
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
Niki Han
TechNet Community Support
- Marked as answer by Niki Han Friday, December 30, 2011 8:30 AM
Wednesday, December 21, 2011 10:42 AM -
Hi,
I am currently standing by for an update from you and would like to know how things are going. If you have any feedback, please let us know.
Niki
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
Niki Han
TechNet Community Support
Monday, December 26, 2011 9:44 AM -
Hi,
As this thread has been quiet for a while, I assume the issue has been resolved. At this time, we will mark it as "Answered" as the previous steps should be helpful for many similar scenarios. If the issue still persists, please feel free to reply this post directly so we will be notified to follow it up. You can also choose to unmark the answer as you wish.
BTW, we'd love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems. Thanks for your understanding and efforts.
Niki
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
Niki Han
TechNet Community Support
Friday, December 30, 2011 8:30 AM