Hi
I am getting an error like An internal error occurred on the report
server.(rsInternalError) The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use max pool size was reached
Could anyone please solve this problem.
Help is strongly appreciated.
Thanks & Best Regards
MukeshThis link might help,
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=290788
daw
"mukesh" wrote:
> Hi
> I am getting an error like An internal error occurred on the report
> server.(rsInternalError) The timeout period elapsed prior to obtaining a
> connection from the pool. This may have occurred because all pooled
> connections were in use max pool size was reached
> Could anyone please solve this problem.
> Help is strongly appreciated.
> Thanks & Best Regards
> Mukesh
>
>sql
Showing posts with label timeout. Show all posts
Showing posts with label timeout. Show all posts
Friday, March 30, 2012
Monday, March 12, 2012
RS Web Service Reference File
Where do I go to add a constractor of "this.Timeout=..." to a the Web Service
reference file?
Challenge: Long running reports are timing out
Thank you for your assistance.Find ReportingService() class in a reference file.
it looks like :
public class ReportingService :
System.Web.Services.Protocols.SoapHttpClientProtocol
{
.....
}
replace "public ReportingService() {...}" with
public ReportingService()
{
this.Timeout=1200000;
}
or you can even overload that constructor by adding the following
public ReportingService(string url)
{
this.Url = url;
this.Timeout=1200000;
}
do not regenerate it, otherwise you'll loose your changes.
another way is to extend ReportingService class.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> Where do I go to add a constractor of "this.Timeout=..." to a the Web
> Service
> reference file?
> Challenge: Long running reports are timing out
> Thank you for your assistance.
>
>|||Thank you very much!
"Oleg Yevteyev" wrote:
> Find ReportingService() class in a reference file.
> it looks like :
> public class ReportingService :
> System.Web.Services.Protocols.SoapHttpClientProtocol
> {
> ......
> }
> replace "public ReportingService() {...}" with
> public ReportingService()
> {
> this.Timeout=1200000;
> }
> or you can even overload that constructor by adding the following
> public ReportingService(string url)
> {
> this.Url = url;
> this.Timeout=1200000;
> }
> do not regenerate it, otherwise you'll loose your changes.
> another way is to extend ReportingService class.
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> > Where do I go to add a constractor of "this.Timeout=..." to a the Web
> > Service
> > reference file?
> >
> > Challenge: Long running reports are timing out
> >
> > Thank you for your assistance.
> >
> >
> >
>
>
reference file?
Challenge: Long running reports are timing out
Thank you for your assistance.Find ReportingService() class in a reference file.
it looks like :
public class ReportingService :
System.Web.Services.Protocols.SoapHttpClientProtocol
{
.....
}
replace "public ReportingService() {...}" with
public ReportingService()
{
this.Timeout=1200000;
}
or you can even overload that constructor by adding the following
public ReportingService(string url)
{
this.Url = url;
this.Timeout=1200000;
}
do not regenerate it, otherwise you'll loose your changes.
another way is to extend ReportingService class.
"Terry" <Terry@.discussions.microsoft.com> wrote in message
news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> Where do I go to add a constractor of "this.Timeout=..." to a the Web
> Service
> reference file?
> Challenge: Long running reports are timing out
> Thank you for your assistance.
>
>|||Thank you very much!
"Oleg Yevteyev" wrote:
> Find ReportingService() class in a reference file.
> it looks like :
> public class ReportingService :
> System.Web.Services.Protocols.SoapHttpClientProtocol
> {
> ......
> }
> replace "public ReportingService() {...}" with
> public ReportingService()
> {
> this.Timeout=1200000;
> }
> or you can even overload that constructor by adding the following
> public ReportingService(string url)
> {
> this.Url = url;
> this.Timeout=1200000;
> }
> do not regenerate it, otherwise you'll loose your changes.
> another way is to extend ReportingService class.
>
> "Terry" <Terry@.discussions.microsoft.com> wrote in message
> news:76DCAFF8-F66B-4666-8C96-4A1817D13CD6@.microsoft.com...
> > Where do I go to add a constractor of "this.Timeout=..." to a the Web
> > Service
> > reference file?
> >
> > Challenge: Long running reports are timing out
> >
> > Thank you for your assistance.
> >
> >
> >
>
>
Subscribe to:
Posts (Atom)