Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: maverick_hs on 28 Feb 2006 12:57:02 PM

Title: [Solved] Maximum No of database connections error
Post by: maverick_hs on 28 Feb 2006 12:57:02 PM
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?
Title: Re: Maximum No of database connections error
Post by: mikegreen on 28 Feb 2006 01:53:11 PM
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.
Title: Re: Maximum No of database connections error
Post by: maverick_hs on 01 Mar 2006 08:42:01 AM
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.
Text only | Text with Images