Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Process Mining
Unanswered

CoE Starter Kit "A record with matching key values already exists."

(0) ShareShare
ReportReport
Posted on by

Error or OK?

 

I have imported the CoE Starter Kit. It is now that I have problems with two flows. The flows "Admin | Sync Audit Logs" and "[Child] Admin | Sync Logs" ran once successfully and from then on they consistently just ended with "failed". When I look at the details, the error is to be found in the flow "[Child] Admin | Sync Logs". To those who also use the CoE Starter Kit. Should the flow " Admin | Sync Audit Logs" run without errors or is this behavior normal? Thanks in advance!

 

Admin | Sync Audit Logs

MPRHIM_0-1611555291195.png

 

[Child] Admin | Sync Logs“

MPRHIM_1-1611555291202.png

 

MPRHIM_2-1611555291207.png

 

MPRHIM_3-1611555291211.png

 

{

  "error": {

    "code": "0x80040237",

    "message": "A record with matching key values already exists.",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey": "Plugin/Microsoft.Crm.ObjectModel.CustomBusinessEntityService",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey": "e06e9c73-b35b-eb11-bb23-000d3abaa5af",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey": "1",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey": "dc2eb179-196c-466c-ab7c-17267309d8ba",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey": "System",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey": "System",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory": "ClientError",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMesageName": "DuplicateRecord",

    "@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode": "412",

    "@Microsoft.PowerApps.CDS.ErrorDetails.SqlExceptionMessage": "Violation of PRIMARY KEY constraint 'PK_admin_AuditLogBase'. Cannot insert duplicate key in object 'dbo.admin_AuditLogBase'. The duplicate key value is <redacted>.",

    "@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040237&client=platform",

    "@Microsoft.PowerApps.CDS.InnerError.Message": "Cannot insert duplicate key."

  }

}

 

Details  â€žLaunchPowerApp“ from „[Child] Admin | Sync Logs“ flow

MPRHIM_4-1611555291217.png

 

 

Categories:
  • diver7 Profile Picture
    4 on at
    Re: CoE Starter Kit "A record with matching key values already exists."

    Take a look at this. There is a solution to this issue.

    https://github.com/microsoft/powerapps-tools/issues/723

     

  • diver7 Profile Picture
    4 on at
    Re: CoE Starter Kit "A record with matching key values already exists."

    I am seeing the same issue.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Process Mining

Overall leaderboard