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