SummaryWhile importing PegaCRM.jar, the application generates an SQL file that is reviewed and applied to the database. However, the import fails with an error.
Database server: Oracle 11g
Application server: WebLogic 12c
For more information, refer to: https://community.pega.com/system/files/media/pdf/customer-service-sales-automation-82-install-guide_0.pdf
Error MessagesFailed to save page: Database-NonexistentTable PSPDATDVA12C1C.Data_Tag_RelevantRecord_KMContext PegaDAT
Steps to Reproduce
- Import the PegaCRM.jar file.
- Manually apply the generated SQL.
- Resume the import.
Root CauseA defect or configuration issue in the operating environment.
The table was not created successfuly or the neccessary permissions were missing. During the second import attempt, constraint violations exception occurred because the initial attempt was stopped mid-way without a rollback. Therefore, the second attempt also failed.
ResolutionPerform either of the following local-changes:
- Identify the entries used in the previous attempt. Remove these entries and reimport the JAR file.
- Rollback the database to the state before the JAR (using the prpcServiceUtils.sh rollback option) is imported. Reimport the JAR file.
Published July 4, 2019 — Updated August 15, 2019