Question
TCS
IN
Last activity: 7 Aug 2023 10:33 EDT
8.6.1 upgrade error with IUA
I'm trying to upgrade Pega from version 7.2 to 8.6.1 through IUA. Have created new rules and data schema in db. While giving these in the IUA tool, upgrade fails with "Failed to find current installed version of PRPC"
In order to proceed further, the old schemas were mentioned while rerunning IUA. This time upgrade failed with error - 'org.postgresql.util.PSQLException: ERROR: relation "sqlj.jar_repository" does not exist' while Applying UDF
Already created posts for this error are of conflicting options - some say to place the file in repository, other say to bypass the UDF generation by setting setupDatabase.properties. Need assistance to know which is the better approach given that the upgrade schemas are the old and existing ones?
Pegasystems Inc.
IN
TCS
IN
Hi Pranav,
Can you please explain the significance of the query(what we are trying to find out here). The above query resulted in -
What should be the pysetting=<pzcodesetversion_from_above_query> given that there are multiple records.
Hi @AparnaGopakumar
Have you tried setting the source pega platform version before running the upgrade?
Query to find source codeset version in source system:
SELECT DISTINCT pzcodesetversion, pzcodeset, count(pzcodesetversion) FROM <RULES_SCHEMA>.PR_ENGINECLASSES GROUP BY pzcodesetversion, pzcodeset;
Query to update source pega version before you execute upgrade script:
UPDATE <RULES_SCHEMA>.PR_DATA_ADMIN_PRODUCT SET pysetting=<pzcodesetversion_from_above_query> WHERE PXOBJCLASS = 'Data-Admin-Product' AND PXINSNAME NOT LIKE '%CUSTOMER%' AND PXPRODUCTNAME='PegaRULES Process Commander';
Thanks.