Support Article

Database-NonexistentTable Data_Tag_RelevantRecord_KMContext

SA-83442

Summary

While 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 Messages

Failed 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 Cause

A 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.

Resolution

Perform 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.

Suggest Edit