Support Article

ERROR: PXCHANGECLASS of relation "pr_sys_decchg" does not exist

SA-29803

Summary



An error occurred when executing migrate.sh to move existing Pega database from Oracle to PostgreSQL and Oracle to Oracle.

Error Messages



ERROR: column "PXCHANGECLASS" of relation "pr_sys_decchg" does not exist

Steps to Reproduce



Execute migrate.sh.

Root Cause



PegaBulkMover utility will migrate Rules schema only. This is mentioned in migrateSystem.properties file, with the help of Oracle Data Pump tool we can move from one database to another.

Resolution



Create a logical directory pointing physical directory < create or replace directory <logical dir name> as <physical dir name>;
expdp directory=<logical dir name> dumpfile=<name of the backup file> logfile=<name of the log file name> schema=rules
impdp directory=<logical dir name> dumpfile=<name of the backup file> logfile=<name of the log file name> schema=rules

Published October 31, 2016 - Updated January 16, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.