locked
CRM 4.0:Error "Service Activity Volume" Report RRS feed

  • Question

  • Hi,

    I'm using CRM 4.0,SQL 2005.I got the error after running report "Service Activity Volume" as details below; 

    Full Stack:
    [InvalidOperationException: Some parameters or credentials have not been specified]
       at Microsoft.Reporting.WebForms.ServerReport.PerformDrillthrough(String drillthroughId, String& reportPath)
       at Microsoft.Reporting.WebForms.ReportActionHandler.HandleDrillthrough(String drillthroughID)
       at Microsoft.Reporting.WebForms.ReportActionHandler.HandleAction(String actionType, String actionParam, Int32& currentPage, Boolean& pageSetByEvent, String& navigationID, String& searchText, Int32& searchStartPage, String& alertMessage, Report& targetReport)
       at Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)

    [CrmException: An error occurred during report rendering.]
       at Microsoft.Crm.Web.Reporting.SrsReportViewer.ReportErrorHandler(Object sender, ReportErrorEventArgs e)
       at Microsoft.Reporting.WebForms.ReportViewer.OnError(Exception e)
       at Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
       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.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.alphagroupcrm_crmreports_rsviewer_reportviewer_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Plese suggestion. Thanks in advance

    Tuesday, March 1, 2011 2:37 AM

All replies

  • Please look into the SRS logs to identify what was the real problem.

    Thanks


    Abhishek Agarwal MSFT
    Tuesday, March 1, 2011 5:32 AM
  • @OrdinaryGal - Is this happening for all reports or just this one?, I would recommend you to go through this MS KB article and see if that helps in your case,

    http://support.microsoft.com/kb/946289

    Do let us know with the results!!!


    Cheers, Edwin
    Tuesday, March 1, 2011 12:17 PM
  • Hi Edwin,

    Thank you for the link it useful for me,and some problem already solved. Just one thing still error when i selected "Group by : Status Reason"  This field i have added some value, and now already changed back to the original value, but still getting error as details below

    • An error has occurred during report processing.
      • Query execution failed for data set 'DSSnapshotCount'.
        • For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Please suggestion again. Thanks in advance

    Wednesday, March 2, 2011 9:41 AM
  • Please share the SRS logs for us to identify the real problem. Additionally, you can send the SRS logs and the RDL to abhia_at_microsoft_dot_com.

    Thanks


    Abhishek Agarwal MSFT
    Wednesday, March 9, 2011 6:22 AM
  • Hi Abhishek,

    I would like to input this log file here. Plese see as details as following;

    w3wp!processing!7!14/3/2554-10:24:17:: e ERROR: An exception has occurred in data source 'DSSnapshotCount'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DSSnapshotCount'. ---> System.Data.SqlClient.SqlException: Arithmetic overflow error converting expression to data type nvarchar.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
       at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()

    Thanks in advance.

     

    Monday, March 14, 2011 6:21 AM