Issues while upgrading from Pega 5.4 to Pega 7.4
Invalid Identifier exception occurs while upgrading PRPC 5.4 to Pega 7.4.
[java] User ID: (unknown)
[java] Last SQL: SELECT pxInsName as "product", pySetting as "pySetting" FROM PEGARULE_LSP_OWNER.pr_data_admin WHERE pxObjClass = 'Data-Admin-Product' AND pxProductName = 'PegaRULES Process Commander' ORDER BY pxCreateDateTime DESC
[java] java.sql.SQLSyntaxErrorException: ORA-00904: "PYSETTING": invalid identifier
Steps to Reproduce
- Set up the database user with appropriate roles and privileges.
- Execute the migration.sh script for rules only. The execution fails with an error.
While processing the upgrade step, in the setupdatabase.properties, both the rules.schema and the data.schema must be set to the new rules schema.
The rules.schema was set to the new rules schema, while the data.schema was set to the old_single_schema.
Perform the following local-change:
Setup setdatabase.properties as below
Perform either of the following to move the entire data to a new database server (both schemas):
- Migrate the entire data to the new database and then perform the upgrade.
- Upgrade the current environment and then use the migrate.bat or migrate.sh to migrate to the new database server.
0% found this useful