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

  1. Import the PegaCRM.jar file.
  2. Manually apply the generated SQL.
  3. 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.

Published July 4, 2019 — Updated August 15, 2019

Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.