[Solved] Maximum No of database connections error

[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.