Showing posts with label appreciated. Show all posts
Showing posts with label appreciated. Show all posts

Monday, March 26, 2012

Pdf Export using WebService- Error

Hi,
I am trying SRS2005 export into pdf using webservices,I got an error msg as below,any suggestions appreciated.

System.Web.Services.Protocols.SoapException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
End of inner exception stack trace
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.Render(String Report, String Format, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle, Byte[]& Result, String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings, String[]& StreamIds)

Thanks,
Prabu

That means that you are trying to authenticate to reportserver with the user 'PPCCWDDC450P81\IUSR_PPCCWDDC450P81, this is an anonymous user that ASPNET uses for executing applications, you only have to add this user to the reportfolder or report item and give permissions of browser.sql

PDF Export Causes 100 % CPU - MS Response appreciated

I have a 100 page report that I render as PDF and then show in an
IFrame from a C# Ascx user control. It takes about 3 minutes to
render if ONE person is rendering the report. The CPU goes to about
50 %. If TWO people attempt to render the report, the CPU goes to
100% and the reports don't render (at least after 11 minutes).
If I render to HTML, it takes about 15 seconds although HTML Rendering
is not an option in this application.
This is running on a server with 1 GIG of memory Xeon 2.38 processor.
I've installed Service Pack 1 (although it blasted through the install
REALLY FAST so I have my doubts).
I had thought that SP1 was supposed to improve PDF rendering. Is
there something I can program to improve performance?
This issue, if not resolvable, makes RS unusable for this application
which is not an option I'm pleased with.
Thanks in Advance for the Reply
Timothy Heuer
heuert@.comcast.netSP1 does contain some improvement for PDF rendering. We are continuing to
improve it for the next release. If you can send the repro (RDL and data),
we will investigate to see what is causing the problem in your particular
scenario.
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"teem60004" <teem60004@.hotmail.com> wrote in message
news:66823058.0407230846.6c7b89c5@.posting.google.com...
> I have a 100 page report that I render as PDF and then show in an
> IFrame from a C# Ascx user control. It takes about 3 minutes to
> render if ONE person is rendering the report. The CPU goes to about
> 50 %. If TWO people attempt to render the report, the CPU goes to
> 100% and the reports don't render (at least after 11 minutes).
> If I render to HTML, it takes about 15 seconds although HTML Rendering
> is not an option in this application.
> This is running on a server with 1 GIG of memory Xeon 2.38 processor.
> I've installed Service Pack 1 (although it blasted through the install
> REALLY FAST so I have my doubts).
> I had thought that SP1 was supposed to improve PDF rendering. Is
> there something I can program to improve performance?
> This issue, if not resolvable, makes RS unusable for this application
> which is not an option I'm pleased with.
> Thanks in Advance for the Reply
>
> Timothy Heuer
> heuert@.comcast.net