Reporting Services rendering error 1

[SQLScholar]

Hey all,

I have a problem with one server.

We have two reports that work fine in BIS. Once deployed the first page (a header to the report) and the second page (start of data) work fine.

However - after that we then get

An error occurred during client rendering.
The remote server returned an error: (401) Unauthorized.
To rule it out - the datasource username is one that has full sysadmin rights and in the DBO group for the database.

If i look in the logs i get:



rshost!rshost!de0!02/18/2011-15:03:39:: e ERROR: HttpPipelineCallback::SendResponse(): failed writing response.
rshost!rshost!de0!02/18/2011-15:03:39:: e ERROR: Failed with win32 error 0x0057, pipeline=0x0350FF00.
httpruntime!ReportServer_0-2!de0!02/18/2011-15:03:39:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.ArgumentException: Value does not fall within the expected range.
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
library!ReportServer_0-2!de0!02/18/2011-15:03:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-2-129425143554335858. , RsWorkerRequest::FlushResponse.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-2-129425143554335858. ---> System.ArgumentException: Value does not fall within the expected range.
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
--- End of inner exception stack trace ---
chunks!ReportServer_0-2!de0!02/18/2011-15:03:39:: w WARN: Rolling back shared chunk transaction for snapshot '41f4601f-7baa-496c-b758-521dd0203383', Permanent=False.
library!ReportServer_0-2!de0!02/18/2011-15:03:39:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-2-129425143554335858. ---> System.ArgumentException: Value does not fall within the expected range.
bufferedresponse!ReportServer_0-2!de0!02/18/2011-15:03:39:: w WARN: Cannot write headers to the client. Server cannot append header after HTTP headers have been sent.
webserver!ReportServer_0-2!de0!02/18/2011-15:03:39:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-2-129425143554335858. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: An internal or system error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-2-129425143554335858. ---> System.ArgumentException: Value does not fall within the expected range.

I have deployed this to a different server - and that seems to work fine.

SQL 2008 SP2 running on windows server 2003.

The datasource is the same SQL box that RS is running on.

Any ideas - i am stumped to even what this error means or where i should look?

TIA

Dan



----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[xlbo]

I'd guess a config file issue

Find the SSRS config file on the different server and copy it to the one on the server that doesn't work (take a backup 1st just in case) - see if that makes a difference

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SQLScholar]

You were spot on. I was tried a while ago to get the subscriptions to have

Servername.domain

instead of just servername in the link.

It worked - however it seemed to screw RS up. Would have noticed but because its a non prod server i did one thing one week and then a few weeks parsed before the error came up.

Thanks

D

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------