Support Article
Command line deployment fails for external database
SA-35738
Summary
User is able to deploy a product file using the Designer Studio. However, when using the command line, the user gets the error indicating that the system cannot find the external database schema.
Error Messages
Ratings_2017_ORP_FIG_Insurance_Ratings74_APPFW_Rule_I2._B2.2.3_schema.jar is Schema Archive
[java] 2017-03-23 12:35:49,176 [ your_host] [ STANDARD] [ ] (ternal.util.SchemaImporterTool) ERROR - Unable to determine available schemas for YOUR_TABLE
[java] com.pega.pegarules.pub.database.BadDatabaseDefinitionException: Database-BadDBDef-Missing orp_ratings
[java] From: (AB9DA9468C895D59BFB3DFE8FB42CA906)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getDBConfig(ConnectionManagerImpl.java:2790)
[java] at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.getConnection(ConnectionManagerImpl.java:1199)
Steps to Reproduce
- Create a JDBC JNDI for a separate database.
- Map some classes to the schema available to the external database.
- Try to import the product file containing data instances of the class mapped to the table.
- Observe the error about the missing schema.
Root Cause
A defect or configuration issue in the operating environment The prconfig.xml file is missing details for the external database.
Resolution
Perform the following local-change:
1. Edit the prconfig.xml file to define the external database details.
2. Specify the location of the prconfig.xml and prbootstrap files in prpcutils.properties.
Published April 28, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.