Skip to Content
author's profile photo Former Member
Former Member

Maximum Connection reached while using webservices to call the Webi reports- active connections not getting close

Hi All,

I am facing the Maximum connection error in BI 4.0 while the other team is trying to pull the Webi reports throught the help of Websevices. Till date we have tried implementing these changes on BO side (our BO system is currently running on 8 GB ram and 4 Cpus)

1) Increase maximum number of connection option in Web Intelligence server from 50 to 100- error is still coming as the Current number of active connection is increasing rapidally once webservice calls the reports.

2) Created one more node of Web Intelligence server wth Max connection as 100- error is still coming as the Current number of active connection is increasing rapidally once webservice calls the reports.

So now our issue is that the active connections are getting created for each request by user and these connections are not getting close automatically, we cannot set the Connection Idle time less than 20 minutes cause it has been set as standard in our project.

We tried to copy paste the Listner class and logon token class in the Tomcat`s Web. xml but it didn`t work and I think BO4.0 doesn`t supports these clases now, in earlier posts I have found this resolution for BO 3.X- Not sure. Please confirm?😕

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 20, 2013 at 10:06 AM

    Moved to BI Platform space

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 20, 2013 at 10:25 AM

    May i know which version of Bo version your using?

    we have noticed the same issue in Bo 4.0 SP2 patch 14 , Raised a message with SAP for webi sessions are not consistently ending.

    They have suggested to install SBOP BI Platform Servers 4.0 SP04 Patch 1 to solve this issue.

    Later we have gone to SP5 and it is working fine.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Hi Prasad,

      We do have minimum Ram of 8 Gb in our system. As per SAP for BI4.0 Minimum is 8 GB and recommended is 16 GB.

      But are you sure its related to hardware configuration only?? Cause I think some other issue here...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.