Field Notice: FN - 72377 - Inefficient Creation of TimesTen Connections Might Exceed the Connection Limit - Software Upgrade Recommended

Notice

THIS FIELD NOTICE IS PROVIDED ON AN "AS IS" BASIS AND DOES NOT IMPLY ANY KIND OF GUARANTEE OR WARRANTY, INCLUDING THE WARRANTY OF MERCHANTABILITY. YOUR USE OF THE INFORMATION ON THE FIELD NOTICE OR MATERIALS LINKED FROM THE FIELD NOTICE IS AT YOUR OWN RISK. CISCO RESERVES THE RIGHT TO CHANGE OR UPDATE THIS FIELD NOTICE AT ANY TIME.

Revision History

Revision	Publish Date	Comments
1.0	30-Mar-22	Initial Release

Products Affected

Affected OS Type	Affected Software Product	Affected Release	Affected Release Number	Comments
NON-IOS	Application Patches	22.0	22.0.2021.11, 22.0.2021.12, 22.0.2022.01, 22.0.2022.02	Cisco BroadWorks Release 22
NON-IOS	Application Patches	23.0	23.0.2021.11, 23.0.2021.12, 23.0.2022.01, 23.0.2022.02	Cisco BroadWorks Release 23
NON-IOS	Application Patches	24.0	24.0.2021.11, 24.0.2021.12, 24.0.2022.01, 24.0.2022.02	Cisco BroadWorks Release 24

Defect Information

Defect ID	Headline
CSCwb18843	BAS7 loss of access to TT database

Problem Description

The Application Server (AS) Execution Server (XS) may inefficiently create and use TimesTen connections, causing the number of allowed connections to TimesTen to be exceeded.

Background

After ap381570 is applied, the AS XS inefficiently creates and uses TimesTen connections when voice messaging read/write operations are processed. This might ultimately cause the number of allowed connections to TimesTen to be exceeded.

Problem Symptom

Once the connection limit is exceeded, the XS is not able to create more TimesTen database connections which might prevent normal operation on the XS.

Users will see these exceptions:

• 2022.03.07 15:06:38:218 EST | FieldDebug | CommonPersistency | pool-3-thread-162

Unable to register RTSqlStmt: connection is null [this=com.broadsoft.persistence.timesten.TTRunTimeQueryManager@572f007b, key=read_MailboxFullQuery, GenericRTSqlStmt=com.broadsoft.services.voicemessaging.MailboxSummary$MailboxFullQuery@58985796]

• 2022.03.07 15:05:29:315 EST | Warn       | Generic | pool-3-thread-162

Exception occurred: com.broadsoft.persistence.UnregisteredQueryException: Query is not registered. Never use the following pattern:
   MyQuery query = new Query();
   rtqm.execute(query)
   Use rtqm.getOrRegisterRTSqlStmt(...) instead to create or retrieve a query.
at com.broadsoft.persistence.SQLRunTimeQueryManager.executeRTSqlStmt(SQLRunTimeQueryManager.java:611)
at com.broadsoft.services.voicemessaging.MailboxSummary.restore(MailboxSummary.java:78)
at com.broadsoft.services.voicemessaging.VoiceMessageManager$MailboxSummaryDBAccess.accessDB(VoiceMessageManager.java:328)
at com.broadsoft.services.voicemessaging.VoiceMessageManager$MailboxSummaryDBAccess.accessDB(VoiceMessageManager.java:322)
at com.broadsoft.apm.persistence.DBAccessProcessor.execute(DBAccessProcessor.java:33)
at com.broadsoft.services.voicemessaging.VoiceMessageManager.getMailboxSummary(VoiceMessageManager.java:298)
at com.broadsoft.protocols.voicemail.VoiceMailReader.getMailboxSize(VoiceMailReader.java:118)
at com.broadsoft.sessionmanagers.voicemail.VoicePortalVoiceMailSession.executeEvent(VoicePortalVoiceMailSession.java:231)
at com.broadsoft.sessionmanagers.voicemail.VoicePortalVoiceMailSession.run(VoicePortalVoiceMailSession.java:385)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

Workaround/Solution

Workaround

Remove patch ap381570 or restart the AS in order to restore the service.

Solution

AP382691 addresses this issue and is now available from Cisco Software Download. Apply the corrective patch AP382691 along with patch AP381570.

• Release 22 - AP.as.22.0.1123.ap382691
• Release 23 - AP.as.23.0.1075.ap382691
• Release 24 - AP.as.24.0.944.ap382691

For More Information

If you require further assistance, or if you have any further questions regarding this field notice, please contact the Cisco Systems Technical Assistance Center (TAC) by one of the following methods:

• Open a service request on Cisco.com
• By email or telephone

Receive Email Notification For New Field Notices

My Notifications—Set up a profile to receive email updates about reliability, safety, network security, and end-of-sale issues for the Cisco products you specify.