The DDR reports SQL queries using invalid XML
When you have a file that uses a calculation for the Execute SQL script step, and then run a DDR, the report has inaccuracies with the way it reports the calculation. It generates two Calculation nodes, one generic one, and one "QueryCalc" one.
Also the QueryCalc one is contained within a CDATA section, but the actual text is encoded, so you end up with inaccurate data for what the calc contains. Plus the QueryCalc section contains no DisplayData nodes, whereas the generic calc does.
Create a new file, and a new script. Add a Execute SQL step to the script and change the option for QueryType to calculation. Enter some details like function calls in the calc.
Save the script, close Script Editor and generate an XML DDR for the file.
There should only be one Calculation node in the output. The step contains two.
The QueryCalc/Calculation node has the CDATA sections wrong, they shouldn't be encoded as "<![CDATA[" they should be the same as the other calculation section.
There is no DisplayCalculation nodes for the QueryCalc node. So there are no references generated for this calculation.
There should only be one Calculation generated, it makes it difficult to interpret when there is more than one, and the included information should be accurate ( valid CDATA sections, included references ) for every Calculation node.
Thank you for your post.
Our Development and Software Quality Assurance (Testing) departments are aware of this issue. I have attached your post to the original issue. When more information becomes available, I will let you know.