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
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
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])
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
SAS System | SAS Visual Analytics | Cloud Foundry | 8.3 | | Viya | |
Linux for x64 | 8.3 | | Viya | |
Microsoft® Windows® for x64 | 8.3 | | Viya | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
If a multiple-value parameter is used in a calculation or filter that uses the In operator, you might see "An error occurred" when a list control is used to set the parameter value but only one value is selected in the control.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-09-27 10:56:16 |
Date Created: | 2019-06-21 13:49:50 |