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?
***Edited by Moderator: Pooja Gadige to add capability tag, update product version***
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';