AgileStudio_731_schema.sql Collumn "p1" does not exist
When running AgileStudio_731_schema.sql, we get the following message:
2018-04-11 16:28:23,313 [27.0.0.1-7080-exec-4] [TABTHREAD1] [ ] [ PegaRULES:07.10] (dbms.JdbcConnectionManagerImpl) ERROR devapps.taxonic.com|127.0.0.1 Administrator@pega.com - Not returning connection 5 for database "pegarules" to the pool as it previously encountered the following error
User ID: Administrator@pega.com
Last SQL: SELECT "pxinsname" AS "pxInsName" , "pylabel" AS "pyLabel" , "pyruleset" AS "pyRuleSet" , "pyrulesetversion" AS "pyRuleSetVersion" , "pxupdatedatetime" AS "pxUpdateDateTime", "pzinskey" as "pxInsHandle" FROM rules.pr4_rule_application WHERE "pxobjclass" = ? AND ( ( "pyproductname" = ? ) AND ( "pyproductversion" = ? ) ) AND pyProductName = ? AND pyProductVersion = ? AND p1 = ?
org.postgresql.util.PSQLException: ERROR: column "p1" does not exist
Anyone with a bright idea what's wrong?
Posted: 2 years ago
Have you tried describing the table pr4_rule_application and check if you have the column "p1" exist or not .
Thanks,
Arun