Troubleshooting
Problem
Running IAAdmin.sh command using xml file that has name parameter value in xml using patten like "THIS_IS_&YOUR_DQ_RULES_TEST"
For example:
IAAdmin.sh -user isadmin -password isadm_password -url [] [https://yourservername.doman.com:yourport][] -runTasks -content /home/dsadm/test.xml
Generates error similar to below:
[Fatal Error] The reference to entity "YOUR_DQ_RULES_TEST" must end with the ';' delimiter.
Error: Invalid Request: The XML request passed as parameter could not be parsed for the following reason: The referenced to entity "YOUR_DQ_RULES_TEST" must end with the ';' delimiter.
Cause
The problem is with ampersand('&') in the Information Analyzer project , column or other name specified. The '&' (ampersand) is a special character in XML, which needs to be escaped to work correctly. The XML parser is trying to resolve "THIS_IS_&YOUR_DQ_RULES_TEST" since it is followed by the ampersand causing the syntax error.
Resolving The Problem
To resolve the issue, wherever an ampersand character appears in the xml file add "amp;" (without quotes) , save the xml and then run IAAdmin command. So the xml should be changed as follows as an example before running the IAAdmin.sh command--add "amp" and semicolon ";" then rest of name.
<?xml version="1.0" encoding="UTF-8"?>
<iaapi:Project xmlns:iaapi="http://www.ibm.com/investigate/api/iaapi";
name="THIS_IS_&YOUR_DQ_RULES_TEST">
<Tasks>
<RunColumnAnalysis>
<Column
name="CHACTT3DSHN01.adihub20.FIF_INVACC_STG.ACCESS_SECMASTR_STG_MTD.ACCO
UNT"/>
</RunColumnAnalysis>
</Tasks>
</iaapi:Project>
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21987169