Event code: 3005 preventing export to Excel from SQL Reporting Services

Posted on 2011-04-21
Last Modified: 2012-05-11
At the end of this post is an error that we are experiencing when exporting to Excel 2007 from SQL Reporting Services 2005.

This event is occurring on the IIS box when we attempt and export to excel from our SQL Reporting Services 2005 instance: The report is an execution snapshot that runs to 4500 pages. The message below will also be thrown if the report is run on demand and then output to excel. It will also be thrown if the report is run as an email subscription with an excel attachment.
What should we look at to begin troubleshooting this?
Does it have anything to do with the metabase.xml file on the IIS box?  We are thinking that perhaps we can change the maximum file size for exporting to Excel.  It seems that this issue has to do with the rendering itself within SQL Reporting Services.

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/21/2011 11:33:32 AM
Event time (UTC): 4/21/2011 3:33:32 PM
Event ID: ebde0e8b193e4e8b811cc9ffa5e5e4e3
Event sequence: 33205
Event occurrence: 130
Event detail code: 0
Application information:
    Application domain: /LM/W3SVC/1/root/Reports-1-129475639238956018
    Trust level: RosettaMgr
    Application Virtual Path: /Reports
    Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportManager\
    Machine name: WEBSERVER
Process information:
    Process ID: 3880
    Process name: w3wp.exe
Exception information:
    Exception type: XmlException
    Exception message: Data at the root level is invalid. Line 1, position 1.
Request information:
    Request URL: http://webserver/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=mue23a2nr1hlrm2ctt1x5e45&ControlID=5ae4a32d27254bd2958c8fa848c37e88&Culture=1033&UICulture=9&ReportStack=1&OpType=Export&FileName=Summer+Planning+Report+SII+SIE+and+SICItemSiteSelectable&ContentDisposition=OnlyHtmlInline&Format=EXCEL
    Request path: /Reports/Reserved.ReportViewerWebControl.axd
Question by:apitech
    LVL 9

    Expert Comment

    LVL 1

    Author Comment

    Hello radcaesar:

    I appreciate the response.  But, when I clicked on that link, it did not discuss the issue.

    I'm unclear.

    LVL 3

    Expert Comment

    LVL 42

    Expert Comment

    check how to insert a page break after a certain amount of records.
    Reporting Services 2005 - Export to Excel



    Scroll down to the 'Page Breaks' section.

    LVL 1

    Author Comment

    It's not a page break issue.  The end user has Excel 2007, which has no 65k row limit.
    LVL 42

    Accepted Solution

    65K was for before office 2007

    Excel specifications and limits

    Worksheet size 1,048,576 rows by 16,384 columns
    LVL 1

    Author Comment

    I already knew that!  LOL!  This user, by virtue of having Excel 2007, does not have to deal with this row limitation.
    LVL 1

    Author Comment

    Thanks for the response, though, EugeneZ!  It is appreciated very much!!!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    746 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

    14 Experts available now in Live!

    Get 1:1 Help Now