Portal: JSON RR Pair Export Issue

Document ID : KB000072360
Last Modified Date : 28/02/2018
Show Technical Document Details
While exporting a JSON RR Pair which has a column named as rownum, the export fails with below error: The column 'RowNum' was specified multiple times for 'ROOTTABLERESULTS'. The only workaround is to change the name of the column in the JSON, which is not acceptable since our specifications do not allow it to be altered. We are looking to automate the publish of the RR Pair directly onto a virtual service from TDM Portal.
CA Test Data Manager (TDM)- Portal
This is a known defect in TDM 4.4. It is a defect since it conflicts with the internal reserved keyword rownum.
There is a patch available for this issue if you are using TDM 4.4, or you can upgrade to TDM 4.5.

If you need a patch, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html. In the support case, reference this knowledge document and patch TDMWeb-

Once provided by support, you will use these instructions to download and apply the patch: https://comm.support.ca.com/kb/how-to-apply-patches-for-tdm-and-ard-components/kb000010931.
Please make sure that you add an entry in conf\catdmshredder.properities. You need to specify the new internal name other than RowNum that would not conflict with your JSON file entries. 

You can download the latest version of TDM by following the directions in this document: https://comm.support.ca.com/kb/how-to-download-test-data-manager/kb000009671.