SUPPORT / SAMPLES & SAS NOTES
Problem Note 66197: SAS® Customer Intelligence Studio fails to publish a campaign to the Snowflake database and returns "ERROR: CLI prepare error: SQL compilation error"
 |  |  |  |  |
SAS Customer Intelligence Studio fails to publish campaigns when the Common Data Model is held in the Snowflake code database. A syntax error occurs because the backslash character (\) in the SQL command is interpreted as an escape character and the campaign exits at the next character.
This issue causes the following error in the SASStoredProcessServer_yyy-mm-dd_pid.log file:
INFO [00001365] 4:sasdemo - ERROR: CLI prepare error: SQL compilation error: syntax error line 1 at position 322 unexpected 'xxxxxxx'.
parse error line 1 at position 368 near '<EOF>'. syntax error line 1 at position 367
INFO [00001365] 4:sasdemo - unexpected ')'.
parse error line 1 at position 368 near '<EOF>'. syntax error line 1 at position 367
INFO [00001365] 4:sasdemo - unexpected ')'.
The following query can cause this issue:
update CICDM.CI_CAMPAIGN SET CURRENT_VERSION_FLG ="N" Where UPCASE(CAMPAIGN_CD)
=UPCASE(TRIM(LEFT("CAMP199"))) and UPCASE(CAMPAIGN_NM)
=UPCASE(TRIM(LEFT('camp1'))) and UPCASE(CAMPAIGN_FOLDER_TXT)
=UPCASE(TRIM(LEFT('\'))) and UPCASE(BUSINESS_CONTEXT_NM)
=UPCASE(TRIM(LEFT('CI65'))) and CURRENT_VERSION_FLG="Y" ;
=UPCASE(TRIM(LEFT("CAMP199"))) and UPCASE(CAMPAIGN_NM)
=UPCASE(TRIM(LEFT('camp1'))) and UPCASE(CAMPAIGN_FOLDER_TXT)
=UPCASE(TRIM(LEFT('\'))) and UPCASE(BUSINESS_CONTEXT_NM)
=UPCASE(TRIM(LEFT('CI65'))) and CURRENT_VERSION_FLG="Y" ;
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 Customer Intelligence Studio | Microsoft® Windows® for x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise 32-bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2016 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2019 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| HP-UX IPF | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Linux for x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||
| Solaris for x64 | 6.6 | 6.6 | 9.4 TS1M6 | 9.4 TS1M6 | ||