Support Article

Extract filters are not used when running from command line

SA-25543

Summary



Extract rules are configured with filter criteria, but the output is not as expected in some environments. The filter criteria was not considered when creating the database query. The settings in use in all environments seems to be the same. Oracle database is used for the source system.

Error Messages



Not Applicable

Steps to Reproduce



Unknown

Root Cause



A defect or configuration issue in the operating environment:
Entries were missing from the prconfig.xml files to communicate, which schema should be used by default, with the source database user. With these entries missing, correct schemas were not used when gathering the Extract rule data.

Resolution



Add the following to the prconfig.xml files used by the BIX command line process:
<env name="database/databases/PegaRULES/defaultSchema" value="RULES_SCHEMA"/>
<env name="database/databases/PegaDATA/defaultSchema" value="DATA_SCHEMA"/>

Published July 12, 2016 - Updated July 28, 2016

Have a question? Get answers now.

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