Symptoms

PegaAESRemote Push DB Query Stats agent may trigger a “column total_time does not exist” exception status when executing agent activity while Pega Platform is running on Postgres database version PG 13 and later or while upgrading to PG 13 and later. The text for the exception is shown in the table below. This issue is due to a schema change for table pg_stat_statements in PostgreSQL version 13 and later.

2023-06-02 16:49:08,593 [   PegaRULES-Batch-2] [  STANDARD] [                    ] [     PegaAESRemote:8] (emote_Interface_DBStats.Action) ERROR   - Error in RDB-List  

com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 0 SQLState: 42703 Message: ERROR: column "total_time" does not exist  

  Position: 67  

DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: column "total_time" does not exist  

  Position: 67  

 | SQL Code: 0 | SQL State: 42703    

at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:385) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:364) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:618) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:434) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:190) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:126) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:73) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.Lister.listRDB(Lister.java:1064) ~[prprivate-data.jar:?]  

at com.pega.pegarules.data.internal.access.DatabaseImpl.listRDB(DatabaseImpl.java:3142) ~[prprivate-data.jar:?]  

Errors

Class: com.pega.pegarules.pub.database.DatabaseException

Message: There was a problem getting a list: code: 0 SQLState: 42703, ERROR: column "total_time" does not exist

Environments

The problem occurs on Pega Platform versions 8.1 - 8.8

Solution

To resolve this issue, follow either of the below options: 

Option 1: Upgrade to latest Pega Platform version with the fix  

• Pega 8.7.5 

• Pega 8.8.3 

• Pega 9.x  

Option 2: Install the update product

1. Download the product rule component for your Pega Platform version. The versions are listed in the RAP Matrix table below. 

2. Use the Import wizard to install the product rule (Use a secured login URL, for example, https). For more information, see Importing rules and data from a product rule by using the Import wizard. 

3. Login to Designer Studio and add the “PegaAESRemote” access group to your operator. Then,  

4. Switch the application context to “PegaAESRemote.”  

5. Find and open the “CompressEncodeString” function. 

6. Click on the “Generate function” and “Generate library” buttons. 

   

7. After completing steps 1-6 above, restart the “Push DB Query Stats Info” or “Push DB Stats Data Information” agent in the PegaAESRemote ruleset. For more information, see How to restart the agent. 

RAP Matrix 

The enhanced PegaAESRemote “Push DB Query Stats Info” product rule component is available for the following versions of Pega Platform.