Thursday, September 19, 2013

Microsoft Dynamics CRM 2011 rsProcessingAborted w3wp

While getting custom reports you may get this error. rsProcessingAborted w3wp

Open EventViewer on Appserver
Error logs on Windows Logs->Application

Log Name:      Application
Source:        MSCRMReporting
Date:          9/19/2013 11:25:41 AM
Event ID:      19970
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      mlnnew.NARTMLN.com
Description:
Report render failure. Error: An error has occurred during report processing. (rsProcessingAborted)
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSCRMReporting" />
    <EventID Qualifiers="49152">19970</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-09-19T08:25:41.000000000Z" />
    <EventRecordID>17098</EventRecordID>
    <Channel>Application</Channel>
    <Computer>mlnnew.NARTMLN.com</Computer>
    <Security />
  </System>
  <EventData>
    <Data>An error has occurred during report processing. (rsProcessingAborted)</Data>
    <Data>w3wp</Data>
    <Data>C:\Program Files\Microsoft Dynamics CRM\CRMWeb\</Data>
  </EventData>
</Event>

SOLUTION

1. Open Command Prompt as Administrator on App Server
2. run command -> setspn -l domainname\username (optional. just view)
3. run command -> setspn -a http/appservername domainname\username
important: http/
4. run command -> setspn -a http/appservername.domainname.com domanname\username

Example
Appserver Name: titan
Domain: olympos
username: zeus

c:\>setspn -a http/titan olympos\zeus
c:\>setspn -a http/titan.olympos.com olympos\zeus

restart appserver machine 2 times. :) dont ask why!

No comments:

Post a Comment