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

 

Not deleting db connections after Timeout has elapsed

Started by ilikebundy, 21 Oct 2021 01:26:33 AM

Previous topic - Next topic

ilikebundy

Context:
Cognos 11.1.7fp1
SQL Content Store
Cognos DB Connection Strings - Informix 12:10
CQM report - Non Interactive
CQEConfig.xml TIMEOUT = 120

In the CQE file
10/21/21 16:52:53   Number of free tagging connections: 1
10/21/21 16:53:53   RQP-DEF-0331 DB Connection Pool Cleaner Thread is removing expired DB connections.
10/21/21 16:53:53   Database Connection Pool status after: cleaning cycle
10/21/21 16:53:53   Number of Database Connections: 5; max: 80; free: 0
10/21/21 16:53:53   SerialNo: 2; Age: 1664; Status: used; Reuse count: 15; Reuseable: true; Logical DB Names: CONN1
10/21/21 16:53:53   SerialNo: 3; Age: 1664; Status: used; Reuse count: 3; Reuseable: true; Logical DB Names: CONN_TWO
10/21/21 16:53:53   SerialNo: 4; Age: 1664; Status: used; Reuse count: 2; Reuseable: true; Logical DB Names: CONN1, CONN_TWO
10/21/21 16:53:53   SerialNo: 5; Age: 1663; Status: used; Reuse count: 2; Reuseable: true; Logical DB Names: CONN1
10/21/21 16:53:53   SerialNo: 7; Age: 1662; Status: used; Reuse count: 0; Reuseable: true; Logical DB Names: CONN1, CONN_TWO


database connection does not get cleared until BIBusTKServerMain expires and gets re spawned

Anyone seen this behaviour before?


Steps are run report
close Report
check db connections


Anyone else seeing this behaviour?
Has been confirmed as being browser related -  Chrome =<v.94 causes the issue.
Not releasing db connections as per timeout.