Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / Failed to Insert Audit...
Microsoft Dynamics CRM forum
Answered

Failed to Insert Audit Record After Install of 2016 SP1

(0) ShareShare
ReportReport
Posted on by woodtool 35

We just installed SP1 on our CRM 2016 on prem server. I am now receiving the error "Failed to Insert Audit Record" when executing an AddListMembersListRequest. We can add the members manually through the interface but not through code now. We are able to create the marketing list but receive the error when trying to add members via and array of member ids. Error occurs on the Execute line.

AddListMembersListRequest x = new AddListMembersListRequest();
            x.ListId = staticListId;
            x.MemberIds = bidContactList.ToArray();

            AddListMembersListResponse y = (AddListMembersListResponse) orgContext.Execute(x);


Categories:
Development / Customization / SDK
  • woodtool Profile Picture
    woodtool 35 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    This seems to be a different issue now. InnerException: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK__fn_GetGu__3213E83F5DFCB325'. Cannot insert duplicate key in object 'dbo.@tbl'. The duplicate key value is (00000000-0000-0000-0000-000000000000).

    The statement has been terminated. I'll move to a different post.

  • woodtool Profile Picture
    woodtool 35 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    We have upgraded to 365 v1612 and now we're getting a "General SQL Error" in the same spot. I tried adding back in the "= null" to the stored proc but that didn't fix it. I'll try to get a better error message.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    Has anyone installed the Latest update rollup to confirm if it fixes the issues with Marketing Lists?

    support.microsoft.com/.../update-0.1-for-microsoft-dynamics-crm-2016-service-pack-1

  • DigitalFlow Profile Picture
    DigitalFlow 80 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    Hey everyone,

    We're also experiencing issues with this error when adding users to a team using a plugin.

    As it turns out, the association works when executing the plugin asynchronously, although the plugin execution itself will still be flagged as failed due to the same error.

    If only the results count, switching the plugins to asynchronous execution might be a nicer / supported workaround for the time being, although it should definetly get fixed asap.

    Hope I was able to help someone.

    Kind Regards,

    Florian

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    thanks!

    This issue is still outstanding in CRM 2016 sp1.

  • Henrik Gundersen Profile Picture
    Henrik Gundersen 978 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    Thank you. I have this bug when trying to add and remove members to teams. I cannot wait until SP1 UR1 as this is critical for our operations, so I have reported this as a bug to Microsoft. Hopefully to put some pressure on them to get SP1 UR1 out.

  • Suggested answer
    woodtool Profile Picture
    woodtool 35 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    Update from MS was the they are aware of the problem and have fixed it but they will not be releasing a hotfix. The next release (SP1 UR1) will include the fix. I would follow what Chris Teuben has suggested as that has been working for us for a while too.

  • woodtool Profile Picture
    woodtool 35 on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    Thanks. I've already done that as a temp solution. Microsoft is still looking at the underlying issue. I'll keep the post updated if I get a response. Seems to be an issue with the SDK as that is a new field with SP1.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    I created another workaround by altering the Stored Procedure "p_InsertMultipleAuditRows":

    ALTER   PROCEDURE [dbo].[p_InsertMultipleAuditRows](@doc ntext, @transactionid uniqueidentifier, @EntityType int,

    @auditoperation tinyint, @auditaction tinyint, @audituser uniqueidentifier ,

    @callinguser uniqueidentifier, @attributemask nvarchar(max), @changedata nvarchar(max),

    @audituseradditionalinfo nvarchar(350) = NULL)

    ...


    The "= NULL" addition makes the parameter optional.

    USE AT YOUR OWN RISK!

    As far as I know this kind of hacking into the database is not supported by Microsoft (but if you do, take care to document the changes you make).

    Regards, Chris.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Failed to Insert Audit Record After Install of 2016 SP1

    I too am experiencing this when using the UI to add all members in an advanced find to a marketing list. The only way I can get them to add is by turning off auditing.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans