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

• Question

• 

  

  0

  Sign in to vote

  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