Posted: 26 Dec 2018 17:08 EST Last activity: 20 Jan 2019 23:41 EST
prpcUtils import not working if password has '&' character in it
Our DB password contains a & character (This cannot be updated because the passwords are automatically generated and we have no control over this password setting in production)
When this password is procided to the prpcUtils.sh import utility. We get a SAX parser exception saying that its a malformed xml because this value is substituted by the prpcUtils.sh import utility into the prconfig.xml as <env name="database/databases/PegaRULES/password" value="&%&s#m" />. (I believe this happens because & is a control character in xml)
I tried escaping the & character by replacing & with & but then we receive a database logon failure.