PH41552: DB CONNECTION SESSION POOL NOT EXPIRED WHEN RUN NON-INTERACTIVE CQM HTML REPORT USING GOOGLE CHROMIUM V80+ WEB BROWSERS.

APAR status

• Closed as program error.

Error description

• Cognos Analytics 11.1.7.x (LTSR) and 11.2.x release(s) to Run an
  upgraded report i.e. Full Interactivity = No using HTML output
  format on-line using Google Chrome v80+ web browsers as i.e.
  classicviewer, observe within the backend database, the
  connection session pools are not expired and released post
  exceeding the default CQE database connection timeout period of
  900s.
  

Local fix

• Option 1
  ----------
  Use a different web browser e.g. Firefox 96 and Internet
  Explorer 11 web browsers. However Pronto Xi web client is only
  certified to run using Google Chrome web browsers.
  
  Option 2
  ---------
  Decrease the Inactivity timeout in seconds from 3600s (1 hr) to
  lower value e.g. 900s (15 mins) to clean up and expiry the
  ?CAMpassport? web browser cookie which will also clean up the
  expired DB connections. This option however assumes user not
  interacting with the web browser and not performing any
  concurrent reporting tasks for a 900s duration.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.1.7 Interim Fix 8         *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  COG REPORT STUD

• Fixed component ID

  5724W12RS

Applicable component levels