PEGA0026 Alert message parameters
Hello everybody,
while troubleshooting performance issued I stumbled over many Pega0026 alerts and this descriptive article: https://docs.pega.com/pega0026-alert-time-connect-database-exceeds-limit
It mentions the structure of these messages:
Hello everybody,
while troubleshooting performance issued I stumbled over many Pega0026 alerts and this descriptive article: https://docs.pega.com/pega0026-alert-time-connect-database-exceeds-limit
It mentions the structure of these messages:
Time to acquire a connection has exceeded the alert threshold of 100 ms: 152 ms. DBName [pegarules] Initial [False] Connection [1] Status [New] Type [JDBC URL Common] Conn Mgr [Pega]
Some of the parameters are self explanatory, such as "DBName". I couldn't find an explanation for all of the others:
- Initial
- Connection
- Status
- Type
- Conn Mgr
The log files suggests the message is created in the 'com.pega.pegarules.data.internal.access.ConnectionManagerImpl' class.
Is there some documentation available what these parameters are?
Accepted Solution
Pegasystems Inc.
US
Hi John,
I couldn't find the documentation regarding this class, but after looking into the code got an idea of what these parameters are explained as follows:
- Initial - it says whether the connection is made first time or not i.e. True/False
- Connection - contains the unique connection id value or null value
- Status - this field specifies the status of the connection that can be New/Existing/Reserved
- Type - this field contains the information of JDBC URL/JNDI Name
- Conn Mgr - this field specifies which type of connection mechanism is being followed i.e it can be App Server/Pega
Hope this information might be helpful to you.
Regards
Mahesh
Blue Rose Technologies GmbH
BE
Hello,
Please have a look on the below article:
Thanks.
Infosys
US
Thank you, Akshya.
I was aware of that article. My question is not how to troubleshoot but rather to better understand the alert message.
An explanation of those parameters would help a lot.
Accepted Solution
Pegasystems Inc.
US
Hi John,
I couldn't find the documentation regarding this class, but after looking into the code got an idea of what these parameters are explained as follows:
- Initial - it says whether the connection is made first time or not i.e. True/False
- Connection - contains the unique connection id value or null value
- Status - this field specifies the status of the connection that can be New/Existing/Reserved
- Type - this field contains the information of JDBC URL/JNDI Name
- Conn Mgr - this field specifies which type of connection mechanism is being followed i.e it can be App Server/Pega
Hope this information might be helpful to you.
Regards
Mahesh
Infosys
US
Hello Mahesh,
thank you for the helpful reply. If possible, can you elaborate on the difference between 'Initial' and 'Status'?
In my understanding an 'Initial' value of 'true' will always lead to a 'Status' of 'New' and a an 'Initial' value of false would lead to a 'Status' of 'Existing'.
Is that correct?
JP Morgan Chase
US
For Pega0026 alerts please see your connection pool size. Increasing the connection pool size should fix the issue unless there are some process that are eating up resources. Check for Pega0005 alerts in your log before increasing the pool size.