gilta03

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

Discussion created by gilta03 Champion on Jan 16, 2018

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. 

 

To view the cause and resolution of this issue, please go here- https://support.ca.com/us/knowledge-base-articles.TEC1635887.html 

Outcomes