今天客户在测试环境上打开报表时出现如下错误:
经检查,SQL服务器上已经安装了Microsoft SQL Server Reporting Extensions。
打开系统日志,发现如下错误内容:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2013/6/26 14:28:54
Event time (UTC): 2013/6/26 6:28:54
Event ID: 1abb58208ecf44dbb6d2f563d0298a3e
Event sequence: 5
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-130167016990206413
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: crmserver
Process information:
Process ID: 13596
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: CrmArgumentNullException
Exception message: name
at Microsoft.Crm.ReportObjectModel.ReportServerOrganizationContext.GetItemPath(String name, Boolean isSharedReport)
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)
Value cannot be null.
Parameter name: name
Request information:
Request URL: http://localhost:5555/test/CRMReports/rsviewer/reportviewer.aspx
Request path: /demo/CRMReports/rsviewer/reportviewer.aspx
User host address: ::1
User: test\crmadmin
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 3
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.ReportObjectModel.ReportServerOrganizationContext.GetItemPath(String name, Boolean isSharedReport)
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)
从上面信息中发现处理事件来源于w3wp.exe,于是打开CMD,输入:iisreset
重启完毕后,问题解决!