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

Document ID : KB000007871
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.