Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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 August 15, 2019 - Updated December 2, 2021

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us