Problem Note 63296: The Load_Live_Data job flow fails when a dimension name or custom field label contains a single or double quotation mark
 |  |  |  |  |
The Load_Live_Data and Load_Historical_Data job flows in the SAS® Risk Governance Framework might fail with a syntax error. The problem occurs when a dimension name or custom field label contains a single or double quotation mark. When the problem occurs, you might see an error similar to one of the following errors in the log file:
ERROR 22-322: Syntax error, expecting one of the following: a quoted string,
',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN,
LENGTH, TRANSCODE.
',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN,
LENGTH, TRANSCODE.
Error: Text contains unmatched quotation
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Risk Governance Framework | Linux for x64 | 7.4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Ultimate 32 bit | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Professional x64 | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Professional 32 bit | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Home Premium x64 | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Home Premium 32 bit | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Enterprise x64 | 7.4 | 9.4 TS1M5 | ||||
| Windows 7 Enterprise 32 bit | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2016 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Std | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 R2 Std | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2012 Datacenter | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 for x64 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 R2 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows Server 2008 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 10 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Pro x64 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Pro x64 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Pro 32-bit | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Enterprise x64 | 7.4 | 9.4 TS1M5 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 7.4 | 9.4 TS1M5 | ||||
| Microsoft® Windows® for x64 | 7.4 | 9.4 TS1M5 | ||||
A fix for this issue for SAS Risk Governance Framework 7.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D4Z.html#63296
The LASR loading jobs fail with syntax error if a label in the customMessages.properties file contains a single or double quotation mark.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2018-12-11 08:37:03 |
| Date Created: | 2018-11-29 08:05:40 |