locked
Report Server RRS feed

  • Question

  • Upgraded a client for 4.0 by importing the organization.  Have a virtual crm, virtual sql that holds the config and a sql that is my report server.  I installed the Report Extensions on the Report Server with (I have tracing enabled):

     >Crm Exception: Message: Error occurred while getting the data source contents., ErrorCode: -2147187942, InnerException: Microsoft.Crm.CrmReportingException: Error occurred while getting the data source contents. ---> System.Web.Services.Protocols.SoapException: The permissions granted to user 'INFOINTERNAL\CRM4VIRT$' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'INFOINTERNAL\CRM4VIRT$' are insufficient for performing this operation.
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at Microsoft.Crm.ReportingServices2005.ReportingService2005.GetDataSourceContents(String DataSource)
       at Microsoft.Crm.Reporting.ReportServer.GetDataSourceDefinition(String dataSourcePath)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.ReportServer.GetDataSourceDefinition(String dataSourcePath)
       at Microsoft.Crm.Reporting.ReportServer.IsDataConnectorConfigured(String dataSourcePath, String extensionName)
       at Microsoft.Crm.Reporting.RuntimeReportServer.IsDataConnectorConfigured(ReportServerOrganizationContext organizationContext, DataProviderType dataProviderType)
       at Microsoft.Crm.Reporting.ReportServer.ConfigureDataConnector(ReportServerOrganizationContext organizationContext, DataProviderType dataProviderType)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.ConfigureReportingDataConnector(Int32 dataProviderType, ExecutionContext context)
    [2011-06-22 12:27:35.151] Process: w3wp |Organization:432bea97-1891-e011-958e-00155d3c1f09 |Thread:   19 |Category: Platform |User: a8ddfec0-1891-e011-958e-00155d3c1f09 |Level: Error | MessageProcessor.Execute
     at MessageProcessor.Execute(PipelineExecutionContext context)
     at InternalMessageDispatcher.Execute(PipelineExecutionContext context)
     at ExternalMessageDispatcher.ExecuteInternal(IInProcessOrganizationServiceFactory serviceFactory, IPlatformMessageDispatcherFactory dispatcherFactory, String messageName, String requestName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, ParameterCollection fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId, Guid transactionContextId, Int32 invocationSource, Nullable`1 requestId, Version endpointVersion)
     at OrganizationSdkServiceInternal.ExecuteRequest(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
     at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
     at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
     at PlatformCommand.XrmExecuteInternal()
     at RemoteSrsReportViewer.LoadReportAndSetParameters()
     at AppUIPage.OnPreRender(EventArgs e)
     at Control.PreRenderRecursiveInternal()
     at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest()
     at Page.ProcessRequest(HttpContext context)
     at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     at ApplicationStepManager.ResumeSteps(Exception error)
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >MessageProcessor fail to process message 'ConfigureReportingDataConnector' for 'none'.
    [2011-06-22 12:27:35.183] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   19 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ExceptionConverter.ConvertMessageAndErrorCode
     at ExceptionConverter.ConvertMessageAndErrorCode(Exception exception, Int32& errorCode)
     at ExceptionConverter.ToSingleFaultOther(Exception exception)
     at ExceptionConverter.ToSingleFaultUntyped(Exception exception)
     at ExceptionConverter.ConvertToFault(Exception exception)
     at ExceptionConverter.TryConvertToFaultExceptionInternal(Exception exception, Boolean createNewFaultException, FaultException`1& faultException)
     at FaultHelper.ConvertToFault(Exception exception)
     at OrganizationSdkServiceInternal.Execute(OrganizationRequest request, CorrelationToken correlationToken, CallerOriginToken callerOriginToken, WebServiceType serviceType)
     at InprocessServiceProxy.ExecuteCore(OrganizationRequest request)
     at PlatformCommand.XrmExecuteInternal()
     at RemoteSrsReportViewer.LoadReportAndSetParameters()
     at AppUIPage.OnPreRender(EventArgs e)
     at Control.PreRenderRecursiveInternal()
     at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest()
     at Page.ProcessRequest(HttpContext context)
     at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     at ApplicationStepManager.ResumeSteps(Exception error)
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >System.Web.Services.Protocols.SoapException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #745795BF: System.Web.Services.Protocols.SoapException: The permissions granted to user 'INFOINTERNAL\CRM4VIRT$' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'INFOINTERNAL\CRM4VIRT$' are insufficient for performing this operation.
    >   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
    >   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
    >   at Microsoft.Crm.ReportingServices2005.ReportingService2005.GetDataSourceContents(String DataSource)
    >   at Microsoft.Crm.Reporting.ReportServer.GetDataSourceDefinition(String dataSourcePath)
    [2011-06-22 12:27:35.198] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   19 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error | CrmException..ctor
     at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException)
     at CrmException..ctor(String message, Int32 errorCode)
     at PlatformCommand.CreateCrmExceptionFromServiceFault(FaultException`1 fe)
     at PlatformCommand.XrmExecuteInternal()
     at RemoteSrsReportViewer.LoadReportAndSetParameters()
     at AppUIPage.OnPreRender(EventArgs e)
     at Control.PreRenderRecursiveInternal()
     at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
     at Page.ProcessRequest()
     at Page.ProcessRequest(HttpContext context)
     at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
     at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     at ApplicationStepManager.ResumeSteps(Exception error)
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >Crm Exception: Message: Error occurred while getting the data source contents., ErrorCode: -2147187942
    [2011-06-22 12:27:35.339] Process: w3wp |Organization:432bea97-1891-e011-958e-00155d3c1f09 |Thread:   19 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
     at ErrorInformation.LogError()
     at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError)
     at MainApplication.Application_Error(Object sender, EventArgs eventArguments)
     at EventHandler.Invoke(Object sender, EventArgs e)
     at HttpApplication.RaiseOnError()
     at ApplicationStepManager.ResumeSteps(Exception error)
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

    Error Number: 0x8004831A

    Error Message: Error occurred while getting the data source contents.

    Error Details: Error occurred while getting the data source contents.

    Source File: Not available

    Line Number: Not available

    Request URL: http://crm4virt/BrokerageGrowthBuilder/CRMReports/rsviewer/reportviewer.aspx

    Stack Trace Info: [CrmException: Error occurred while getting the data source contents.]
       at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()
       at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters()
       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


    [2011-06-22 12:27:35.339] Process: w3wp |Organization:00000000-0000-0000-0000-000000000000 |Thread:   19 |Category: Platform |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ExceptionConverter.ConvertMessageAndErrorCode
     at ExceptionConverter.ConvertMessageAndErrorCode(Exception exception, Int32& errorCode)
     at ExceptionConverter.ToSingleFaultOther(Exception exception)
     at ExceptionConverter.ToSingleFaultUntyped(Exception exception)
     at ExceptionConverter.ConvertToFault(Exception exception)
     at ExceptionConverter.TryConvertToFaultExceptionInternal(Exception exception, Boolean createNewFaultException, FaultException`1& faultException)
     at FaultHelper.ConvertToFault(Exception exception)
     at ErrorInformation..ctor(Exception exception, Uri requestUrl, Boolean logError)
     at MainApplication.Application_Error(Object sender, EventArgs eventArguments)
     at EventHandler.Invoke(Object sender, EventArgs e)
     at HttpApplication.RaiseOnError()
     at ApplicationStepManager.ResumeSteps(Exception error)
     at HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
     at HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
     at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #4DD5E5F1: System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: Error occurred while getting the data source contents.
    >   at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()
    >   at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters()
    >   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
    >   at System.Web.UI.Control.PreRenderRecursiveInternal()
    >   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.HandleError(Exception e)
    >   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    >   at System.Web.UI.Page.ProcessRequest()
    >   at System.Web.UI.Page.ProcessRequest(HttpContext context)
    >   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
    >   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Help, I have lost an entire day trouble shooting this!

    Thanks in advance.

     


    WeDoMapping
    Wednesday, June 22, 2011 7:36 PM

All replies

  • Hi.
    Try to insert 'INFOINTERNAL\CRM4VIRT$' in administrator  group of your report server.

    Vahag


    Vahagn Nahapetyan Blogs : http://vh4u.blogspot.com/ http://3dkinect.blogspot.com/
    Tuesday, June 28, 2011 2:50 PM
  • Thanks for your suggestion, the solution was to do the old version 4.0 trick, go into the tools folder and republish the reports then it worked!

     


    WeDoMapping
    • Proposed as answer by Khaja Mohiddin Thursday, July 7, 2011 11:38 AM
    Tuesday, June 28, 2011 2:59 PM
  • Thanks for your suggestion, the solution was to do the old version 4.0 trick, go into the tools folder and republish the reports then it worked!

     


    WeDoMapping

    Hi WeDoMapping.

    I get a similar error and I probably think that your solution might work for me too, so can you please explain in more details what you did to solve the problem ?

    My error is the following :

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #EB41EF9EDetail: 
    <OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
     <ErrorCode>-2147220970</ErrorCode>
     <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
     <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #EB41EF9E</Message>
     <Timestamp>2011-07-07T03:36:09.8564452Z</Timestamp>
     <InnerFault>
      <ErrorCode>-2147187942</ErrorCode>
      <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
      <Message>Error occurred while getting the data source contents.</Message>
      <Timestamp>2011-07-07T03:36:09.8564452Z</Timestamp>
      <InnerFault i:nil="true" />
      <TraceText i:nil="true" />
     </InnerFault>
     <TraceText i:nil="true" />
    </OrganizationServiceFault>
    


    Can you please provide me the steps you did to solve this ?

    Thanks

    Thursday, July 7, 2011 3:42 AM
  • Sure, just went into C:\Program Files\Microsoft Dynamics CRM\Tools and ran the PublishReports application.

     


    WeDoMapping
    Thursday, July 7, 2011 11:20 AM
  • Thanks,

    That didn't solved my problem. I keep getting the message : "Error occurred while getting the data source contents."

    Anyways, thank you for your reply.

    Thursday, July 7, 2011 1:19 PM