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

  • 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

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