Maximum number of database connections (40) has been reached

[nagoole]

Hi All,

When User try to run the report getting error with  : RQP-DEF-0370 Maximum number of database connections (40) has been reached

Please let me know the error is realted to Server configuration side or report level side ?


please see details error msg below and provide any steps to resolve this.


RQP-DEF-0149 The query specification is incorrect.RQP-DEF-0457 Referenced Query 'Q_Ins_Forms' is not defined or its query items contain unresolved references.RSV-SRV-0042 Trace back:RSReportService.cpp(725): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(838): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(293): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): promptPagingForward_RequestRSASyncExecutionThread.cpp(894): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(684): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(303): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(397): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(179): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(347): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(303): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSAssembly.cpp(676): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(731): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(514): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(581): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(673): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(275): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(265): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryExecution/RSQueryExecutionManager.cpp(504): QFException: CCL_RETHROW: RSQueryExecutionManager::getQueryResults()RSQueryExecution/RSQueryExecutionManager.cpp(778): QFException: CCL_RETHROW: RSQueryExecutionManager::getQueryResults()RSQueryExecution/RSQueryExecutionJobEntry.cpp(145): QFException: RSQueryExecutionJobEntry::checkException()RSQueryExecution/RSQueryExecutionThread.cpp(153): QFException: CCL_CAUGHT: RSQueryExecutionThread::run(): Q_Ins_Forms.79RSQueryMgrExecutionHandlerImpl.cpp(170): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(162): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(4469): QFException: CCL_THROW: CoordinationPlanner

Thanks,
Naga

[nagoole]

Anyone please help on this issue

[sdf]

You can try to increase the pool size indicated in your CQEConfig.xml file
the default is 20.

<entry name="PoolSize" value="20"/>

the file is under your IBM cognos configuration file.