Solved

Dynamics CRM 4.0 error - Reporting Error - Event ID 19969

Posted on 2010-08-31
16
2,989 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:kevtrains
  • 7
  • 6
  • 3
16 Comments
 
LVL 29

Expert Comment

by:feridun
Comment Utility
PLease have a look at my troubleshooting article on this: http://www.experts-exchange.com/Database/Software/CRM/A_3552.html

and let me know at what point things fail.

0
 

Author Comment

by:kevtrains
Comment Utility
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
0
 
LVL 29

Expert Comment

by:feridun
Comment Utility
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.
0
 
LVL 11

Accepted Solution

by:
rakeshAgarwal earned 250 total points
Comment Utility
Error is Execution 'bjfpi345p4qaahjfq24kcqqh' cannot be found.

 just  install reporting services  data connector
 
 and  change the  report source it will work
0
 
LVL 29

Expert Comment

by:feridun
Comment Utility
If all services are on the same computer, the reporting services data connector isn't needed.
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
Comment Utility
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
0
 
LVL 29

Expert Comment

by:feridun
Comment Utility
For IFD I agree.
0
 

Author Comment

by:kevtrains
Comment Utility
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.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 29

Expert Comment

by:feridun
Comment Utility
OK. Would you mind running through my article again to see where the reporting fails please?

0
 

Author Comment

by:kevtrains
Comment Utility
still failing at the same place with the same message, do you think a reinstall of reporting services is worthwhile?
0
 
LVL 29

Expert Comment

by:feridun
Comment Utility
Maybe not yet, did you run the  Reporting Services Configuration Manager on the SQL Server?
0
 

Author Comment

by:kevtrains
Comment Utility
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?
0
 
LVL 29

Assisted Solution

by:feridun
feridun earned 250 total points
Comment Utility
No I don't know why you need it. It does seem to solve various authentication issues though.

However, I have set up many CRM installations on a single server with SQL without the data connector succesfully.

At least you have something working now.
0
 

Author Comment

by:kevtrains
Comment Utility
yes i'm happy about that, thanks for your help! very greatly appreciated.
0
 

Author Closing Comment

by:kevtrains
Comment Utility
thanks
0
 
LVL 11

Expert Comment

by:rakeshAgarwal
Comment Utility
I feel happy that I was able to happy thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now