If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Solved] Maximum No of database connections error

Started by maverick_hs, 28 Feb 2006 12:57:02 PM

Previous topic - Next topic

maverick_hs

Hi,

When I am running a report or validating it, I get this error "maximum number of databse connections (20) has been reached".

I went ahead and modified the cqeconfig.xml.sample file and changed the pool size to 40. Saved it as cqeconfig.xml and restarted the service. After a few hours and several iterations of the above process, I am still getting this error (the error message still says 20 even after I changed the value to 40). I don't think we even have 20 connections to the database... (can't be 100% sure though)

Any ideas what's going on?

mikegreen

Get you or your DBA to look at the open connections from the database side..

is the error from Cognos or your DB system? Some databases will have a max connection setting, mainly SQL Server MSDE versions.

maverick_hs

Turns out I had to bounce the server for the new settings to take place. We are in touch the DBAs, it seems like there were a lot of idle connections...

Thanks.