Run CRM 4 Report Error (SQL 2008) - Event ID 19969

All replies

• 

  

  0

  Sign in to vote

  First thing to understand is can you access and run the reports directly from the Report Server http://SQLServerName/reports.  When you go to the folder you should see your Org name.  When you click on the Org name you should see a folder named 4.0 and when you select the 4.0 directory you should see your list of reports.  Try running one of the reports and see if it works.

  ---

  Best Regards, Donna

  Friday, August 14, 2009 12:38 PM
• 

  

  0

  Sign in to vote

  Hi Edwards,

  
  

  We Check with the Report Server, it’s can run the reports directly from the Report Server https://SQLServerName/reports & https://SQLServerName/ReportServer, but only cannot run Report through CRM UI.

  
  

  the CRM Server Event Log below information:

  
  

  1:Event 1309

  - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  - <System>
    <Provider Name="ASP.NET 2.0.50727.0" /> 
    <EventID Qualifiers="32768">1309</EventID> 
    <Level>3</Level> 
    <Task>3</Task> 
    <Keywords>0x80000000000000</Keywords> 
    <TimeCreated SystemTime="2009-08-17T03:34:01.000Z" /> 
    <EventRecordID>22495</EventRecordID> 
    <Channel>Application</Channel> 
    <Computer>CRM.DomainName.net</Computer> 
    <Security /> 
    </System>
  - <EventData>
    <Data>3005</Data> 
    <Data>An unhandled exception has occurred.</Data> 
    <Data>8/17/2009 11:34:01 AM</Data> 
    <Data>8/17/2009 3:34:01 AM</Data> 
    <Data>e384ffb5f4a048118a6e5d9642b4d347</Data> 
    <Data>597</Data> 
    <Data>8</Data> 
    <Data>0</Data> 
    <Data>/LM/W3SVC/1/ROOT</Data> 
    <Data>Full</Data> 
    <Data>/</Data> 
    <Data>C:\inetpub\wwwroot\</Data> 
    <Data>CRM</Data> 
    <Data /> 
    <Data>2160</Data> 
    <Data>w3wp.exe</Data> 
    <Data>Domain\crmservice</Data> 
    <Data>CrmReportingException</Data> 
    <Data>An error has occurred during report processing. (rsProcessingAborted)</Data> 
    <Data>https://localhost:443/Orgname/CRMReports/rsviewer/reportviewer.aspx</Data> 
    <Data>/OrgName/CRMReports/rsviewer/reportviewer.aspx</Data> 
    <Data>::1</Data> 
    <Data>Domain\Administrator</Data> 
    <Data>True</Data> 
    <Data>Negotiate</Data> 
    <Data>Domain\crmservice</Data> 
    <Data>11</Data> 
    <Data>Domain\crmservice</Data> 
    <Data>False</Data> 
    <Data>at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report) 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)</Data> 
    </EventData>
    </Event>

  2 .Event ID:19969

  - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  - <System>
    <Provider Name="MSCRMReporting" /> 
    <EventID Qualifiers="49152">19969</EventID> 
    <Level>2</Level> 
    <Task>0</Task> 
    <Keywords>0x80000000000000</Keywords> 
    <TimeCreated SystemTime="2009-08-17T03:34:01.000Z" /> 
    <EventRecordID>22494</EventRecordID> 
    <Channel>Application</Channel> 
    <Computer>CRM.DomainName.net</Computer> 
    <Security /> 
    </System>
  - <EventData>
    <Data>SetDataSourceCredentials</Data> 
    <Data>https://CRM.DomainName.net/reportserver</Data> 
    <Data>An error has occurred during report processing. (rsProcessingAborted)</Data> 
    <Data>w3wp</Data> 
    <Data>C:\inetpub\wwwroot\</Data> 
    </EventData>
    </Event>

  3. Event ID : 19969

  - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  - <System>
    <Provider Name="MSCRMReporting" /> 
    <EventID Qualifiers="49152">19969</EventID> 
    <Level>2</Level> 
    <Task>0</Task> 
    <Keywords>0x80000000000000</Keywords> 
    <TimeCreated SystemTime="2009-08-17T03:34:03.000Z" /> 
    <EventRecordID>22496</EventRecordID> 
    <Channel>Application</Channel> 
    <Computer>CRM.DomainName.net</Computer> 
    <Security /> 
    </System>
  - <EventData>
    <Data>GetDataSources</Data> 
    <Data>https://CRM.DomainName.net/reportserver</Data> 
    <Data>The path of the item '/OrgName_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)</Data> 
    <Data>w3wp</Data> 
    <Data>C:\inetpub\wwwroot\</Data> 
    </EventData>
    </Event>

  
  

  
  

  Need help, Thanks!

  
  

  • Edited by twJack Monday, August 17, 2009 5:57 AM

  Monday, August 17, 2009 5:55 AM
• 

  

  0

  Sign in to vote

  From everything I have seen, re-installing the SRSS Connector solved this type of issue.  What happens when you try to browse to reports from IIS.  Open IIS and expand the directory for the Web site associated with Reports.  Select the Reports folder, right-click the file home.aspx and select browse.  Does the reports directory open as expected?  If so, ensure that you have a good copy of the SRSS Data Connector and try the repair again.   If the repair or re-install works without error, reboot both your CRM and CRM SQL server and see if it works.

  ---

  Best Regards, Donna

  • Marked as answer by Jim Glass Jr Thursday, August 20, 2009 4:21 PM

  Tuesday, August 18, 2009 3:50 PM