CRM 2011 MSCRMReporting Error RRS feed

  • Question

  • Hi all,

    I am getting the following error message when creating/running a report on CRM 2011 in event viewer :

    The Web Service plug-in failed in OrganizationId: 7a75cc10-8ebd-408b-86de-f0ce04e9d467; SdkMessageProcessingStepId: 641a2445-0f14-4656-92fb-f44d0d0f426f; EntityName: none; Stage: 30; MessageName: IsReportingDataConnectorInstalled; AssemblyName: Microsoft.Crm.Extensibility.InternalOperationPlugin, Microsoft.Crm.ObjectModel, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35; ClassName: Microsoft.Crm.Extensibility.InternalOperationPlugin; Exception: Unhandled Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
       at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
       at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IServiceProvider serviceProvider)
       at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)
    Inner Exception: System.NullReferenceException: Object reference not set to an instance of an object.
       at Microsoft.Crm.Reporting.ReportServer.CreateCrmReportingException(Exception innerException, String methodName, Int32 errorCode)
       at Microsoft.Crm.Reporting.ReportServer.IsDataExtensionInstalled(String extensionName)
       at Microsoft.Crm.Reporting.RuntimeReportServer.IsDataConnectorInstalled(DataProviderType dataProviderType)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.IsReportingDataConnectorInstalled(Int32 dataProviderType, ExecutionContext context)

    any idea how to get this fixed? highly appreciated !

    Thursday, July 23, 2015 6:15 AM

All replies

  • Hello,

    Could you confirm that Report Connector is installed on your reporting services server?

    Dynamics CRM MVP
    My blog

    Thursday, July 23, 2015 6:26 AM
  • Hi,

    Yes it does

    Even I reinstalled, uninstalled and installed it again

    Monday, July 27, 2015 3:17 AM
  • Hello,

    Have you tried to connect to "http://[Server_Name]/Reports_[Instance]" ?

    Blog: crmandme.blogspot.com Twitter: https://twitter.com/Ju_li3n

    Monday, July 27, 2015 9:25 AM
  • I did, it is prompting for user name and password and looks it is all good.
    Wednesday, July 29, 2015 4:41 AM
  • If it is IFD enabled is there a ecryptionKey entered? Also did you configured SPN for your SQL server FQDN crmapppooluseraccount? It should be missed SPN..

    gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

    Wednesday, July 29, 2015 7:42 AM
  • On your SQL, it will check also if duplicates exists:

    setspn -s HTTP/servername domain\service-crmapppool-account
    setspn -s HTTP/servername.FQDN domain\service-crmapppool-account

    gruss Daniel Ovadia MBSS - Microsoft Dynamics CRM MCNPS

    • Proposed as answer by Daniel Ovadia Tuesday, August 11, 2015 11:38 AM
    Wednesday, July 29, 2015 7:51 AM
  • What do the SRS server logs say for that timestamp? 

    Do any of the reports run, something like User Summary for example?

    Monday, August 10, 2015 1:53 PM