SUPPORT / SAMPLES & SAS NOTES
Problem Note 71008: Data selections on the Tags domain with limits might incorrectly enter an error state in SAS® Quality Analytic Suite 6.31
 |  |  |  |  |
In SAS Quality Analytic Suite 6.31 on SAS® 9.4M8 (TS1M8) with Hot Fix N2R001 applied, an error occurs when you complete steps similar to the following:
- Create a new simple data selection on the Tags domain.
- Configure any valid value for the Measure Date Time filter attribute.
- Select the Tag Id filter attribute. Then, configure some tags from the possible values list and apply limits on some of the selected tags.
- Click Save and then click Submit.
As a result, an error similar to the following might occur:
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install the hot fix, run this code once to complete the fix:
proc sql;
connect to POSTGRES as POSTGRES (SERVER="<<server>>" AUTHDOMAIN='FQAAUTH' DATABASE='mfgapp' INSERTBUFF=1 AUTOCOMMIT=NO PORT=10472 );
EXECUTE( set client_min_messages='warning' ) by POSTGRES;
EXECUTE ( update TABLECOLUMN_ATTRIBUTES set ATTRIBUTE_VALUE=trim(ATTRIBUTE_VALUE) ) BY POSTGRES;
quit;
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Quality Analytic Suite Foundation | Microsoft® Windows® for x64 | 6.31 | 9.4 TS1M8 | ||
| Linux for x64 | 6.31 | 9.4 TS1M8 | ||||