locked
CRM 4 Add report error RRS feed

  • Question

  • Hi all,

    I have a add report error. I am trying to add a report to CRM 4 via  adding a RDL.
    I know I can direct deploy this report to the report server and get the like.
    But I need to do this as I want the report to per-filtering.

    I am sure the SSRS is running and SQL is good.(I have other reports on same server have no problem )

    Error comes when I try to upload the RDL file and following is platform trace log. it have 3 errors as follow:
     
    at MessageProcessor.Execute(PipelineExecutionContext context)
    at InternalMessageDispatcher.Execute(PipelineExecutionContext context)
    at ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at InProcessCrmService.Execute(Object request)
    at PlatformCommand.ExecuteInternal()
    at CreateCommand.Execute()
    at Report.Create(Boolean performDuplicateCheck)
    at EntityProxy.CreateAndRetrieve(String columnSet, Boolean performDuplicateCheck)
    at AppForm.RaiseDataEvent(FormEventId eventId)
    at EndUserForm.Initialize(Entity entity)
    at EndUserForm.Execute(Entity entity)
    at ReportPropertyPage.ConfigureForm()
    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 crmstaging_crmreports_reportproperty_aspx.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 HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >MessageProcessor fail to process message 'Create' for 'report'.


    at InProcessCrmService.Execute(Object request)
    at PlatformCommand.ExecuteInternal()
    at CreateCommand.Execute()
    at Report.Create(Boolean performDuplicateCheck)
    at EntityProxy.CreateAndRetrieve(String columnSet, Boolean performDuplicateCheck)
    at AppForm.RaiseDataEvent(FormEventId eventId)
    at EndUserForm.Initialize(Entity entity)
    at EndUserForm.Execute(Entity entity)
    at ReportPropertyPage.ConfigureForm()
    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 crmstaging_crmreports_reportproperty_aspx.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 HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >non-plugin non- CrmException detected - report will be sent to Watson:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.Crm.Reporting.SRSReport.convertDataSource()
    at Microsoft.Crm.Reporting.SRSReport.convertToCRMReport(String origFilter, ExecutionContext context)
    at Microsoft.Crm.ObjectModel.ReportService.CreateInternal(IBusinessEntity entity, Boolean isScheduledReport, ExecutionContext context)
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    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(IPluginExecutionContext context)
    at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)


    at ErrorInformation.LogError()
    at AppForm.HandleSaveEntityException(Exception exception, FormEventId eventType, String url)
    at AppForm.RaiseDataEvent(FormEventId eventId)
    at EndUserForm.Initialize(Entity entity)
    at EndUserForm.Execute(Entity entity)
    at ReportPropertyPage.ConfigureForm()
    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 crmstaging_crmreports_reportproperty_aspx.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 HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
    at ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
    >MSCRM Error Report:
    --------------------------------------------------------------------------------------------------------
    Error: Exception has been thrown by the target of an invocation.
    Error Message: Exception has been thrown by the target of an invocation.
    Source File: Not available
    Line Number: Not available
    Request URL: http://crmdev.tsacorporation.com/CRMStaging/crmreports/reportproperty.aspx
    Stack Trace Info: [NullReferenceException: Object reference not set to an instance of an object.]
    at Microsoft.Crm.Reporting.SRSReport.convertDataSource()
    at Microsoft.Crm.Reporting.SRSReport.convertToCRMReport(String origFilter, ExecutionContext context)
    at Microsoft.Crm.ObjectModel.ReportService.CreateInternal(IBusinessEntity entity, Boolean isScheduledReport, ExecutionContext context)
    [TargetInvocationException: Exception has been thrown by the target of an invocation.]
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    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(IPluginExecutionContext context)
    at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
    at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
    at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)
    at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.ExecuteInternal()
    at Microsoft.Crm.Application.Platform.ServiceCommands.CreateCommand.Execute()
    at Microsoft.Crm.Application.Platform.Report.Create(Boolean performDuplicateCheck)
    at Microsoft.Crm.Application.Platform.EntityProxy.CreateAndRetrieve(String columnSet, Boolean performDuplicateCheck)
    at Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId)


    If any of you have come across this issues please show some light.

    Best Regard Vincent L
    Friday, June 26, 2009 8:24 AM

Answers

All replies

  • Vincent - are you able to add other custom reports through CRM? - 
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Friday, June 26, 2009 11:38 AM
    Moderator
  • Yes, I have successfully add Linked report and report wizard report.
    Best Regard Vincent L
    Monday, June 29, 2009 8:14 AM
  • Is the report's Data Source defined within the report, or is it a shared data source ? It has to be defined within the report

    For reference, the error is a null reference in the Microsoft.Crm.Reporting.SRSReport.convertDataSource method, which is why I think the data source is the problem


    Microsoft CRM MVP - http://mscrmuk.blogspot.com http://www.excitation.co.uk
    Monday, June 29, 2009 8:30 AM
    Moderator
  • Is the report's Data Source defined within the report, or is it a shared data source ? It has to be defined within the report

    For reference, the error is a null reference in the Microsoft.Crm.Reporting.SRSReport.convertDataSource method, which is why I think the data source is the problem


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Yes, the data source is not with in the report.
    I will try your apporach tomorrow.
    by the way, I haven't save the data source inside the report. how can I do this?
    Best Regard Vincent L
    Monday, June 29, 2009 8:51 AM
  • you can do so by following

    3. Double Click on the report to open it. (in SSRS Visual Studio solution - rdl file)

    4. Click on the Data (top tab) above the open report file.

    5. Click the "..." button just to the right of Dataset to open Dataset Properties.

    6. Click on the "..." button to the right of the Data Source drop down list.

    7. Clear the "Use shared data source reference" option.

    8. Click on the "Edit..." button to the right of Connection string.

    9. Enter the correct SRS Server Name, enter the authentication method, and choose the correct database name.

    10. Click OK, this will change the source for the entire report.

    11. Click OK to the Visual Studio window again.

    12. Choose, File, Save <Report>.

    13. Try to upload it again. This time it should load.


    http://faisalmb.com/blog/post/2009/08/18/CRM-Exception-MicrosoftCrmReportingSRSReportconvertDataSource().aspx


    Regards,...
    • Proposed as answer by toughcanny Tuesday, October 27, 2009 7:41 PM
    Tuesday, August 18, 2009 6:05 AM