I am using the PRPC v7.1.9 and Oracle database 12c. In my opinion, when I import the jar, it is not able to write to the column pyurgencyadjustment which is present in the pca_work table inside the DATA schema. Actually Administrator should have the complete access, but don't know why its prohibiting to modify that table.
Posted: 6 years ago
Posted: 4 Dec 2015 14:37 EST
Kevin Zheng (KevinZheng_GCS)
Director, Software Solutions Engineering
this does look like a permission setup issue. Getting to this screen does not really guarantee import success. You either configure an Admin datasource as defined here: https://docs.pega.com/pega-719-platform-installation-guide-oracle-apache-tomcat (check similar guides for other app servers), which will let you import automatically (as you have shown here). Or you choose manual and generate the DDL, asking your DBA execute the script before you try import again.