Failed to Insert Audit Record After Install of 2016 SP1

(0) Share

Report

Posted on by woodtool

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);

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

woodtool 35 on at

Like (0)

Report

RE: Failed to Insert Audit Record After Install of 2016 SP1

Running a trace shows the following error in CRM. Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #D6ABB7E0: System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'p_InsertMultipleAuditRows' expects parameter '@audituseradditionalinfo', which was not supplied.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (2)

Report

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.

Was this reply helpful? Yes No
woodtool 35 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

woodtool 35 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Henrik Gundersen 978 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Failed to Insert Audit Record After Install of 2016 SP1

thanks!

This issue is still outstanding in CRM 2016 sp1.

Was this reply helpful? Yes No
DigitalFlow 80 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
woodtool 35 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Community site session details

Failed to Insert Audit Record After Install of 2016 SP1

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Failed to Insert Audit Record After Install of 2016 SP1

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Abhilash Warrier – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates