SUPPORT / SAMPLES & SAS NOTES
Problem Note 64367: SAS® Visual Analytics displays "An error occurred" when list controls are used to populate multiple-value parameters
 |  |  |  |  |
In SAS Visual Analytics, parameters with multiple values can be used with the In, NotIn, and isSet operators in calculations and filters. Here is an example of a calculation that uses the In operator:
IF ( 'Name' In 'Name Parameter'p )
RETURN 10
ELSE 0
RETURN 10
ELSE 0
You can also use list controls to populate values for multiple-value parameters.
However, if the calculation or filter uses the In operator, you might encounter the following problem when only one value is selected from the list control:
In addition, you see the following errors in the Report Data service log:
2019-06-13 15:17:24.544 WARN 23058 --- [SASExecutor3065] c.s.reportdata.service.utils.DataUtils : sasdemo(dfd5c89e) [3165097539fec17b] Error retrieving data results for DataDefinition 'ddxprimary' in Report -
query:f153c149-6af9-4604-aa76-cac0a622fef7_f153c149-6af9-4604-aa76-cac0a622fef7_Diagnostics_c37
query:f153c149-6af9-4604-aa76-cac0a622fef7_f153c149-6af9-4604-aa76-cac0a622fef7_Diagnostics_c37
com.sas.reportdata.service.utils.DataQueryException: Error executing query - (Status: failure, ResultCacheLifetime: longLifetime, Errors: [Error:Level(Severe)Type(invalidInternalState)Parameters()java.lang.Exception:
Incorrect operand count for operand:or])
Incorrect operand count for operand:or])
If possible, you can work around this issue by using the NotIn operator.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Cloud Foundry | 8.3 | Viya | ||
| Linux for x64 | 8.3 | Viya | ||||
| Microsoft® Windows® for x64 | 8.3 | Viya | ||||