Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
ACT 5.6: ACTUPLOAD: Violation of PRIMARY KEY constraint 'Application_Report_PK' - Issues

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

  • Wednesday, December 21, 2011 10:56 AM
     
     
    Sign In to Vote
    0

    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 TaoModerator Friday, December 23, 2011 2:33 AM (From:SQL Server Database Engine)
    •  
     

All Replies