Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Troubleshooting: SMA does not display Managed Connections

Suggest edit Updated on October 2, 2015

Summary

In PRPC 7.1.4, you selected Use JDBC Connection Pool for the How to Connect field on the Database tab of a Database form to use a connection pool defined by a Java Naming and Directory Interface (JNDI) facility.

However, when you start the System Management Application (SMA), select Advanced > Database Management, select a database name, then click the Database Details button to monitor the database connection details, there are no connections listed under Managed Connections.

PRPC 7.1.4 SMA Database Connection Details Managed Connections

Explanation

Changes were implemented starting in PRPC 7.1 to support split schema and how database connections are managed. The changes include deprecating some old and unused settings, and having application servers manage database connections, rather than PRPC.

In PRPC 7.1.x, in most cases, SMA’s Managed Connections table only shows connections that are actively being used. Prior to 7.1, if you selected Use JDBC Connection Pool for the How to Connect field on the Database tab of a Database form, SMA showed a pool of database connection wrapper objects, some of which were not tied to active database connections.

Suggested Approach

Starting in PRPC 7.1, SMA only shows database connections under conditions such as the following.

  • If you select Use JDBC Connection Pool for the How to Connect field on the Database tab of the Database form, SMA’s Managed Connections table only shows connections that are actively being used.
  • If you select Use configuration in preferences for the How to Connect field on the Database tab of a Database form, connections are not passivated. As a result, SMA’s Managed Connections table still shows these connections, even if they are no longer being used.

SMA Changes Introduced in PRPC 7.1.5

Starting in PRPC 7.1.5, when you start SMA and select Advanced > Database Management, the label for the second column of the Active Databases table has been updated from Connection Count to PRPC Managed Connections to make it clear that those are the only connections you can expect to see in this table.

PRPC 7.1.5 SMA Active Databases PRPC Managed Connections

In addition, once you select a database name and click the Database Details button, you’ll notice that the label for the table that shows you the database connection details has been updated from Managed Connections to Connections Managed by PRPC.

PRPC 7.1.5 SMA Database Connection Details Showing Connections Managed by PRPC

Additional Information

Database form - Completing the Database tab

Did you find this content helpful? YesNo

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us