none
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 from W7 SP1 and WS2K8R2 SP1. However, the log processing service cannot upload data to the ACT-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? ;)

    Thanks, Thomas


    tlukowsk
    • Moved by Peja Tao Friday, December 23, 2011 2:33 AM (From:SQL Server Database Engine)
    Wednesday, December 21, 2011 10:56 AM

Answers

All replies

  • Hi Thomas,

    As this is related with ACT 5.6. other than SQL Server DB engine, I would like to move it to SQL Server Tools General.

    And this question was answered in this similar thread.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Edited by Peja Tao Friday, December 23, 2011 2:46 AM
    • Proposed as answer by Peja Tao Friday, December 23, 2011 2:46 AM
    • Marked as answer by Peja Tao Wednesday, December 28, 2011 7:38 AM
    • Unmarked as answer by Thomas Lukowski Tuesday, January 10, 2012 2:50 PM
    • Unproposed as answer by Kalman TothEditor Saturday, January 21, 2012 8:22 PM
    Friday, December 23, 2011 2:32 AM
  • Hi Peja,

     

    please move this Issue to the SQL Server Tools General section.

    btw.  My Question is not the same problem like this similar thread.

    I have other Event's. like:

    "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."

    I'm sure there is not an permission problem.

    Thomas

     


    tlukowsk
    Tuesday, January 10, 2012 2:48 PM
  • uuupppss...

    ... it's in the right forum already...


    tlukowsk
    Tuesday, January 10, 2012 2:49 PM
  • No progress at this time :(
    tlukowsk
    • Proposed as answer by Rainer P Thursday, May 31, 2012 9:44 AM
    • Unproposed as answer by Rainer P Thursday, May 31, 2012 9:45 AM
    Monday, January 23, 2012 7:43 AM
  • hi folks,

    this is a known (and imho ugly/annoing) bug, solved with kb 2533953.

    took me hours to find it and minutes to fix it writing appropriate sql statements as decribed in the kb ...

    cu rp


    Vista TAP-RD Partner and IT Architect

    • Proposed as answer by Rainer P Thursday, May 31, 2012 9:49 AM
    • Marked as answer by Kalman TothEditor Tuesday, July 03, 2012 12:04 PM
    Thursday, May 31, 2012 9:48 AM
  • Following is the kb URL:

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

    Title: How to Update Application Compatibility Toolkit 5.6 Database to Process Windows 7 or Windows Server 2008 R2 SP1 Logs

    Kalman Toth SQL SERVER 2012 & BI TRAINING
    New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012


    Sunday, June 10, 2012 9:50 PM
  • In my instance I had to place the unprocessed files into the root of the share not the "Uncompressed" folder as the KB states.  Then it processed them correctly.
    Friday, November 30, 2012 2:43 AM