TDM Portal Publish to CSV Fails - Invalid subscript in column reference

book

Article ID: 7863

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Trying to create large quantities of health records via the TDM Portal quickly.  However, we are getting "Invalid subscript in column reference for table RESULTS, column CONTEXTID, expression ^PATIENT.CONTEXTID(1)^".  There is a known workaround that uses Datamaker (DM) to publish.  However, this method is very slow due to the restrictions (32 bit architecture) and the methods needed to process in DM.  Therefore, this type of a work around is not acceptable.  We need a fix for this please.

Cause

In order to isolate this issue to the TDM Portal, this publish was configured and executed without error from DataMaker (DM). 

The three CSV's were registered into DM.  Their names are PATIENT, ORDER, and RESULTS. In the generation rules for ORDER and RESULTS, there are references to resolved columns from PATIENT. 

In an attempt to mitigate the error, I have deleted and recreated the rule that caused the error in the Portal generator's dialogue, but the error persists.  The publish job to CSV fails from TDM Portal with the following error:

"Invalid subscript in column reference for table RESULTS, column CONTEXTID, expression ^PATIENT.CONTEXTID(1)^" 

Environment

TDM Portal 4.2

Resolution

This issue has been resolved by the fix found in TDMWeb-4.2.11.0.zip.  Please check with Support to obtain this version or later.  If you are installing the next GA release after August 16, 2017, please have Support verify that this fix is in that GA version.

Additional Information

You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.   

To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.