Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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);
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.
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.
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).
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.
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.
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.
This issue is still outstanding in CRM 2016 sp1.
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.
Has anyone installed the Latest update rollup to confirm if it fixes the issues with Marketing Lists?
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.
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.
Business Applications communities