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

  1. Create a JDBC JNDI for a separate database.
  2. Map some classes to the schema available to the external database.
  3. Try to import the product file containing data instances of the class mapped to the table.
  4. 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 March 29, 2017 - Updated April 27, 2017

Have a question? Get answers now.

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