Please check the installation guide pointed out by Richard Jackson2 . Still if you could not resolve the issue, please follow the below instructions.
Are you using PostgreSQL 9.1 DB ?. If you are using PostgreSQL 9.1, then you have to change the order of the schema names in the search_path variable. Please specify the schema names in the following order.
It is trying to find out the pa_contact table from RULES schema. Ideally it should be fetching from the SAMPLE schema. Could you please check the DADT (Data Admin DB Table) rule for pa_contact class and verify whether the schema field is blank. If blank could you please provide the correct schema name over there.
But when we checked in the database, we discovered that the table such as pa_contact or pa_account were generated under the tablespace SYSTEM and not RULES after the execution of the installCPM.sh script
Could you please confirm the CPM version you have installed. (We have CPM 7.1 ,CPM 7.1 R2 , CPM 7.1 R2 ML1, CPM 7.1 R2 ML2 , CPM 7.1.3 and Pega CS 7.1.4 ). The installed CPM version could help narrow down the issue and we could arrive at a work around.
I suspect you ran the CPM_Sample_Oracle.sql script as one of the system accounts or your current schema was set to system. You should run this script as the owner of the sample schema or prefix the script with ALTER SESSION SET CURRENT_SCHEMA=SAMPLE; On page 7 of the CPM 7.1.3 installation guide it points out that you must set environment variables prior to running the script. See here: