asked on

Dynamics CRM 4.0 error - Reporting Error - Event ID 19969

Hi

I am receiving an error in MS Dynamics CRM 4.0 when generating reports through the reporting services:

"Reporting error. The report cannot be displayed".

The error seems to be happening for all reports. I checked the event viewer - application log and it has the following error:

Event ID 19969

Web service request SetParameters to Report Server http://esolutio-ffeadb/reportserver failed with SoapException. Error: The permissions granted to user 'TIREWEB\IUSR_ESOLUTIO-FFEADB' are insufficient for performing this operation. (rsAccessDenied)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

And a warning:

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 8/31/2010 6:12:24 PM
Event time (UTC): 9/1/2010 1:12:24 AM
Event ID: f5566006485a48bfa63821a69bb88f9b
Event sequence: 13474
Event occurrence: 10
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2/ROOT-1-129277190477656250
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files\Microsoft Dynamics CRM\CRMWeb\
Machine name: ESOLUTIO-FFEADB

Process information:
Process ID: 1080
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: CrmReportingException
Exception message: The permissions granted to user 'TIREWEB\IUSR_ESOLUTIO-FFEADB' are insufficient for performing this operation. (rsAccessDenied)

Request information:
Request URL: http://esp.tireweb.com:5555/CRMReports/rsviewer/reportviewer.aspx
Request path: /CRMReports/rsviewer/reportviewer.aspx
User host address: 124.168.244.109
User: {ab660bc1-1400-df11-bd7d-001321b3b0fe}
Is authenticated: True
Authentication Type: CrmPostAuthentication
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
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)

Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

The server is a Windows Server 2003 machine with MS SQL 2005 and MS CRM 4.0. All services operate from the same machine.

Any ideas?

Thanks for your help

Feridun Kadir

PLease have a look at my troubleshooting article on this: https://www.experts-exchange.com/Database/Software/CRM/A_3552.html

and let me know at what point things fail.

kevtrains

ASKER

Hi feridun, thanks for the comment

I tried out the steps in your article, it failed at step 6 after clicking one of the reports

Error is Execution 'bjfpi345p4qaahjfq24kcqqh' cannot be found.

Thanks

Feridun Kadir

Hmm. I've usually seen that error when CRM and SQL are on different computers but you say that everything is on the same server.

I wonder if there is a deeper problem with Reporting Services. Are you using Reporting Services for anything else? and did it ever work for CRM reports?

If not and no I'd be tempted to reinstall Reporting Services OR double-check the Reporting Services Configuration using Reporting Services Configuration Manager to ensure there are no issues.

Just thought: check whether anonymous access is enabled for the reports virtual directory in IIS. If it is, disable it.

ASKER CERTIFIED SOLUTION

rakeshAgarwal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Feridun Kadir

If all services are on the same computer, the reporting services data connector isn't needed.

rakeshAgarwal

I know that but I have seen this error on same box and was able to resolve by installing dataconnector . For IFD You need it

rakesh

Feridun Kadir

For IFD I agree.

kevtrains

ASKER

Hi - we are not using reporting services for anything else - it is a new CRM installation and it has not worked before for CRM reports.

I tried changing some settings regarding anonymous access and now getting another error:

Web service request SetParameters to Report Server failed with SoapException: Error The path of the item '/ESP_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report is in native mode, the path must start with a slash.

Feridun Kadir

OK. Would you mind running through my article again to see where the reporting fails please?

kevtrains

ASKER

still failing at the same place with the same message, do you think a reinstall of reporting services is worthwhile?

Feridun Kadir

Maybe not yet, did you run the Reporting Services Configuration Manager on the SQL Server?

kevtrains

ASKER

i installed the reporting services data connector and it seems to work now. our install is not IFD though so I am not sure why we need it?

SOLUTION

Feridun Kadir