Support Article
prpcUtils.bat expose fails to run
SA-53672
Summary
Unable to expose columns using prpcUtils.bat. The execution is successful; however the columns do not populate in the database.
Error Messages
[java] [main] [ ] [ ] (internal.util.ExposeCols) INFO - Usage: com.pega.pegarules.data.internal.access.ExposeCols
[java] where
[java]
[java] -n <column> The name of the column, if omitted than all columns will be populated.
[java] -c <classes> Comma delimited list of classes to include
[java] -C <classes> Comma delimited list of classes to include with descendants
[java] -x <classes> Comma delimited list of classes to exclude
[java] -X <classes> Comma delimited list of classes to exclude with descendants
[java]
[java] You may specify a range of pzInsKey or pxCreateDateTime properties,
[java] if you provide both, only the pzInsKey range will be used.
[java]
[java] NOTE: if you provide the pzInsKey range
[java] then then you may only provide ONE class with no descendants
[java] (use the -c flag and provide one class).
[java]
[java] -z <start key> Only instances with a pzInsKey equal to or greater than <start key>
[java] -Z <end key> Only instances with a pzInsKey equal to or less than <end key>
[java] -d <start date> Only instances with a pxCreateDateTime equal to or greater than <start date>
[java] -D <end date> Only instances with a pxCreateDateTime equal to or less than <end date>
[java]
[java] You may also indicate how many SQL updates should be batched before issuing a database commit.
[java] The default is 1000 instances (index updates are not included in this count).
[java]
[java] -s <number of updates to batch before commit>
[java]
[java] You may also use multiple threads (this will only work if you specify more than one class)
[java]
[java] -t <number of threads>
[java]
[java] -r Also Rewrite indexes (may update BLOBs, index updates do not count towards your commit interval)
[java] -i <reindex type> Type of reindexing to perform. Valid values are 'full', 'pega', and 'nonpega'
[java] -U <user> Reindex using this Operator's Access Group (defaults to Application Requestor)
[java] -P <password> Users password. Required if -U is provided.
[java]
[java] -v Skip column population and reindexing. Use this flag if you want to simply verify that the BLOBs can be opened.
Steps to Reproduce
Use -z and -Z arguments in prpcUtils.properties and specify the pzInskey values with a space between them.
Root Cause
A software use or operation error.
The pzInskey values were not included in double quotes. Observe this in prpcUtils log.
[pega:propertyparser] expose.startKey=YOUR_CLASS YOUR_ID
[pega:propertyparser] expose.endKey=YOUR_CLASS YOUR_ID
Resolution
Perform the following local-change:
Add double quotes for values of -z and -Z arguments.
Published July 23, 2018 - 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.