none
persistence_flushsqlerror when saving issue data in ACM 5.5.6762.1798 RRS feed

  • Question

  • We started getting this error after inventoring nearly 60 machines. All other tasks of the send/receive data are functioning. It is only the "Saving the Issue Data" task that errors out. No corresponding entry exists in the Windows Application Log. 5 of the tasks complete and the "Saving the Issue Data" will error out while the "Uploading Application Information" and Post-processing the data continue on to complete successfully. Once those have completed an Error dialog appears:
    ___________
    ACM encountered the following error while performing synchonizaton:

    Persistence_FlushSqlError
    Violation of PRIMARY KEY constraint 'IssueSolution_PrimaryKey'. Cannont insert duplicate key in object 'dbo.IssueSolution'.
    Stale DAta
    The statement has been terminated.

    Would you like to retry?
    __________________

    Also note that all ACM log files are being processed and none are lagging behind. We would like to solve this error before further deploying the ACM msi.

    Thanks or your help.

    Greg

    Thursday, June 4, 2009 2:26 PM

All replies

  • Hi GregDa,

    It seems that I have found a resolution for the issue.

    You can fix it by removing the constraint:

    ALTER TABLE [dbo].[IssueSolution] DROP CONSTRAINT [IssueSolution_PrimaryKey]

    The above mentioned resolution is extracted from following blog:-

    http://blogs.msdn.com/cjacks/archive/2009/06/09/how-to-fix-the-act-5-5-persistence-flushsqlerror.aspx

    I hope above information helps!


    Thanks,
    Shruti

     

    NOTE - Disclaimer

     

    By using the following materials or sample code you agree to be bound by the license terms below and the Microsoft Partner Program Agreement the terms of which are incorporated herein by this reference. These license terms are an agreement between Microsoft Corporation (or, if applicable based on where you are located, on of its affiliates) and you. Any materials (other than sample code) we provide to you are for your internal use only. Any sample code is provided for the purpose of illustration only and is not intended to be used in a production environment. We grant you a nonexclusive, royalty-free right to use and modify the sample code and to reproduce and distribute the object code form of the sample code, provided that you agree: (i) to not use Microsoft's name, logo, or trademarks to market your software produced in which the sample code is embedded; (ii) to include a valid copyright notice on your software product in which the sample code is embedded; (iii) to provide on behalf of and for the benefit of your subcontractors a disclaimer of warranties, exclusion of liability for indirect and consequential damages and a responsible limitation of liability; and (iv) to indemnify, hold harmless, and defend Microsoft, its affiliates and suppliers from and against any third party claims or lawsuits, including attorney's fees, that arise or result from the use or distribution of the sample code.

     

    Wednesday, August 12, 2009 6:18 PM