Question
Stratosphere Technical Consulting
US
Last activity: 7 Aug 2023 10:32 EDT
ERROR: column "total_time" does not exist
After upgrading to Postgres 14.6 and enabling pg_stat_statements, it appears in this latest version of Postgres, the column in pg_stat_statements that was named "total_time" is now named "total_exec_time".
All AES queries used to push data to PDC using "total_time" are now failing. There does not appear to be an AES update for this.
How can I update AES to fix the column name in the Connect SQL rules:
PegaAESRemote-Interface-DBStats.PostgreSQL.PopulateStatsInfoWithQueryID
PegaAESRemote-Interface-DBStats.PostgreSQL.PopulateStatsInfo
Accepted Solution
Updated: 31 Jul 2023 4:56 EDT
Pegasystems Inc.
GB
@Glen Caldwell What is the Pega version installed?
Did you check if Postgres 14.6 is a supported stack on the Platform Support Guide? It is only supported from Pega 8.8 onwards according to the Platform Support Guide
:Please see the limitations described here here, and here.
See Pega Autonomic Event Services FAQ
What are the requirements for installing AES?
You install AES 8.3 on a Pega Platform 8.3 system with multitenancy enabled and the required hotfixes installed. For more information, see Installing Pega Autonomic Event Services 8.3 and Pega Autonomic Event Services hotfixes.
@Glen Caldwell What is the Pega version installed?
Did you check if Postgres 14.6 is a supported stack on the Platform Support Guide? It is only supported from Pega 8.8 onwards according to the Platform Support Guide
:Please see the limitations described here here, and here.
See Pega Autonomic Event Services FAQ
What are the requirements for installing AES?
You install AES 8.3 on a Pega Platform 8.3 system with multitenancy enabled and the required hotfixes installed. For more information, see Installing Pega Autonomic Event Services 8.3 and Pega Autonomic Event Services hotfixes.
After AES 8.3 we recommend you migrate to PDC
Updated: 26 Jul 2023 4:17 EDT
Corner SA
IT
@MarijeSchillern I have the same problem with Pega 8.7.5 and Postgres 13.10, how did you solve it?
Pegasystems Inc.
GB
@AleMax225 it sounds like you're on a supported platform.
Please log a support issue (see details here) on the MSP if you believe you are encountering a product problem.