Portal: Failed to Resolve Expression - variable returns list based on DB2 AS400 query

book

Article ID: 7871

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I have a variable of type= string, multi select list where the list definition is: 
@aslist(@sqllist(DB2_AS400,select distinct SSN from 1_1.people )@)@ 


The variable resolves properly in DataPainter in both the Portal and Datamaker, but does not resolve when exposed on a form in the Self Service Catalogue or TDoD.  

In TDoD (Silverlight) we see this error: 
Error while processing list: EditMetaData : wf_validate : Exception at Microsoft.Practices.EnterpriseLibrary.Data.Database.CreationConnection at GT.TDMoD.Services.Database.DatabaseAccessor.Create 

In DataPainter (Portal) we see it validate like this:
@aslist(@sqllist(DB2_AS400,select distinct SSN from 1_1.people )@)@ 
Validate: 048384784 ,229799672 ,011 

In Edit Variable (Portal) we see this error:
@aslist(@sqllist(DB2_AS400,select distinct SSN from 1_1.people )@)@ 
Validate: Invalid List. 

In DataPainter (Datamaker) we see it validate like this:
@aslist(@sqllist(DB2_AS400,select distinct SSN from 1_1.people )@)@ 
Validate: (List of numbers appear) 

In TdmWeb.log we see this error: 
TDoDServiceClient: Error in TDoD service client method 
rg.apache.axis.AxisFault: (500)Internal Server Error 


Sometimes the values resolve if I use Chrome, but never if I am using Internet Explorer. In Chrome the resolution is intermittent, but it may be more of an issue with the internal AS400 system but not sure. 

Environment

CA Test Data Manager (TDM)- Portal & Test Data on Demand (TDoD)

Resolution

This issue is typically resolved by removing white spaces in the query result used in the variable or by restarting the Portal. 

Additional Information

If you experience any further issues, please open a support case by going to https://www.ca.com/us/services-support/ca-support/contact-support.html.