CRM 2013 : Sporadic SSRS Error - The remote procedure call failed and did not execute

(0) Share

Report

Posted on by Community Member

Our CRM 2013 Reports are sporadically failing with below error.

System.Runtime.InteropServices.COMException: The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF) ---> Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF)

Actions Taken:

- This issue happening for all users in CRM 2013 SP1 UR2 (CRM version is 6.1.2.112)

- It is intermittent and does not always occur

-Able to run the report a few times and the error will eventually not occur and the report will display

- Received the error "Reporting Error - The report cannot be displayed. [rsProcessingAborted] in CRM

-This issue is happening for all reports – those created with the report wizard in CRM using FetchXML and those created in Visual Studio with SQL.

-Repaired SRS Data Connector.

-Uninstalled and Reinstalled Data Connectors & SP1 and UR2. Issue is still occurring.

- SSRS Service Account is admin on SSRS machine.

>Retrieving SID from AD for the GUID e9862fc0-fdb8-443a-bafb-ca274203fe03 (Which is PrivUserGroup {2f9c1389-45e3-496b-9938-4e474986dbc2})

at SecurityUtils.GetSidFromAD(Guid objectGuid) ilOffset = 0x45

at DataExtensionConnectionBase.IsPrivilegeUserGroupMember(SecurityIdentifier user) ilOffset = 0x0

at DataExtensionConnectionBase.ValidateCaller(SecurityIdentifier user) ilOffset = 0x60

at <>c__DisplayClass1.<Open>b__0() ilOffset = 0x23

at ExceptionManager.HandleUnsafeException(Action body) ilOffset = 0x0

>Error while retrieving SID from GUID e9862fc0-fdb8-443a-bafb-ca274203fe03. Exception: System.Runtime.InteropServices.COMException (0x800706BF): The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF)

at Microsoft.Crm.Tools.ActiveDsWrapper.NameTranslateClass.Init(Int32 lnSetType, String bstrADsPath)

at Microsoft.Crm.ADNameUtility.Rfc1779NameFromGuid(Guid guid)

at Microsoft.Crm.SecurityUtils.GetSidFromAD(Guid objectGuid)

at SandboxSdkClientCache`1.CleanupThread() ilOffset = 0xA2

at ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) ilOffset = 0x70

at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) ilOffset = 0x4

at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) ilOffset = 0x2F

at ThreadHelper.ThreadStart() ilOffset = 0x25

-R-

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

NatrajY 3,040 on at

Like (0)

Report

Could be network/firewall related, if it is sporadic. Please have a look at

social.microsoft.com/.../crm-exceptions-by-creating-a-new-organization

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Firewalls are already turned off for servers on our domain via GPO. So firewalls are not causing this issue.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We are also seeing this error in workflows and solution import.

Below error in workflow process:

Failed to get priv user group information. k = 7339b916-fbf5-e411-975a-005056a35a87 privUserGroupId: e9862fc0-fdb8-443a-bafb-ca274203fe03, localSystemAdGuid: 43254648-6b3b-42be-b5b7-0211d1d6ee92, Exception: System.Runtime.InteropServices.COMException (0x800706BF): The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF) at Microsoft.Crm.Tools.ActiveDsWrapper.NameTranslateClass.Init(Int32 lnSetType, String bstrADsPath) at Microsoft.Crm.ADNameUtility.Rfc1779NameFromGuid(Guid guid) at Microsoft.Crm.SecurityUtils.CheckMembership(Guid principalId, Guid groupId) at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context).

Below error while importing CRM customizations:

<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">

<ErrorCode>-2147214025</ErrorCode>

<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

<Message>Failed to get priv user group information. k = cdd598bb-3e58-de11-8a0d-0022640fa630 privUserGroupId: 356121da-8f07-49a2-9d18-536319bcc312, localSystemAdGuid: b999895b-89be-4040-9131-ab5e3bedd8cd, Exception: System.Runtime.InteropServices.COMException (0x800706BF): The remote procedure call failed and did not execute. (Exception from HRESULT: 0x800706BF)

   at Microsoft.Crm.Tools.ActiveDsWrapper.NameTranslateClass.Init(Int32 lnSetType, String bstrADsPath)

   at Microsoft.Crm.ADNameUtility.Rfc1779NameFromGuid(Guid guid)

   at Microsoft.Crm.SecurityUtils.CheckMembership(Guid principalId, Guid groupId)

   at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context).</Message>

<Timestamp>2015-05-14T23:33:53.5096178Z</Timestamp>

<InnerFault>

   <ErrorCode>-2147220970</ErrorCode>

   <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />

   <Message>System.Runtime.InteropServices.COMException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #E79231B5</Message>

   <Timestamp>2015-05-14T23:33:53.5096178Z</Timestamp>

Was this reply helpful? Yes No
NatrajY 3,040 on at

Like (0)

Report

This might be a domain controller issue. Try setting the PreferredDc key in the registry on the CRM Application server.

blog.customereffective.com/.../crm-performance-and-setting-preferreddc-registry-key.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Senthil,

Is the issue with all reports or just with OOB or custom reports?

Are you able to run reports from SSRS or do you get the error message even there?

Also is this user specific or for all the users?

Thanks!

Vijay| Microsoft Dynamics CRM Support engineer

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Vijay, We are seeing this error in workflows and solution import. This error is sporadic.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello Senthil,

Thank you for your query,

I am sure you might have resolved this issue by now, however I am just giving you a heads up to you in case you encounter the similar issue in future.

You may try adding the user (obtained from the GUID) into the priv user group and the priv reporting group of the active directory.

There might be a possibility that the user lacks permission.

I hope this helps.

Please do inform me if you have any update about the same. Feel free to reply here and I'll be glad to assist you.

Thanks & Regards,

Sharon Mhatre

Support Engineer

Microsoft Dynamics CRM

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Senthil,

Were you able to find out what the issue is? We are getting the exact same issue and I was just wondering what is the resolution.

Thank you.

Was this reply helpful? Yes No
Senth on at

Like (0)

Report

We tried this PreferredDC Setting. Still it's not working.

support.microsoft.com/.../954811

Was this reply helpful? Yes No
Senth on at

Like (0)

Report

Hi Sharon, Our service accounts are in Priv User and Priv Reporting groups already. Still it's failing.

Was this reply helpful? Yes No