September 29, 2011 at 3:45 am
SQL-2005.
A user is able to render a report via RS. However when he attempts to export the report to excel (scheduled or from the report view) export fails.
SQL Application log records:
SourceASP.NET 2.0.50727.0
CategoryWeb Event
Event2147484957
ComputerS1
Message
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 29/09/2011 09:56:43
Event time (UTC): 29/09/2011 08:56:43
Event ID: 4a2837c05cda4341bf8ac530a52125f1
Event sequence: 2461
Event occurrence: 8
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-2-129616748876417112
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: S1
Process information:
Process ID: 9164
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: Exception
Exception message: For more information about this error navigate to the report server on the local server machine, or enable remote errors
Request information:
Request path: /Reports/Reserved.ReportViewerWebControl.axd
User host address: x.x.x.x
User: Domain\User
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace:
Custom event details:
Does anyone have any advise regards issues exporting to excel?
I have attched IIS error returned to the user.
Is this issue down to RS or IIS?
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
September 30, 2011 at 6:31 am
We often see this error when the export exceeds the 56k rows; unfortunately, the export still uses the Excel 2003 limits and the error is never clear that the row count is the problem.
Try to export to csv and then load into Excel that way.
September 30, 2011 at 7:23 am
Scott Murray-240410 (9/30/2011)
We often see this error when the export exceeds the 56k rows; unfortunately, the export still uses the Excel 2003 limits and the error is never clear that the row count is the problem.Try to export to csv and then load into Excel that way.
That would be 65k 😛 Good info though.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
September 30, 2011 at 7:45 am
Phil Parkin (9/30/2011)
Scott Murray-240410 (9/30/2011)
We often see this error when the export exceeds the 56k rows; unfortunately, the export still uses the Excel 2003 limits and the error is never clear that the row count is the problem.Try to export to csv and then load into Excel that way.
That would be 65k 😛 Good info though.
Yes sir.... transposed those numbers!
September 30, 2011 at 9:20 am
Thanks guys. I enabled remote logging and indeed it was due to the row limitation in excel 2003. Are you suggesting as a work around I can export to .csv, import into Excel 2007 and then save as xlsx or is a bit more faffing involved 🙂
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
September 30, 2011 at 9:21 am
correct, you can export to csv and then import into Excel 2007 or 2010. However, you lose your formatting and any grouping / show / hide functionality
September 30, 2011 at 9:53 am
Thanks.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply