SUPPORT / SAMPLES & SAS NOTES
Problem Note 61942: SAS® Customer Intelligence campaigns fail and generate the error "Invalid option name XX_XX" in the stored-process server log
 |  |  |  |  |
SAS Customer Intelligence campaigns might fail. When the failure occurs and the length of the LIBNAME statement (including the bulk-loading options) exceeds 250 characters, the following error is displayed in the stored-process server log:
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - NOTE: Line generated by
the macro variable "DBDSOPTIONS".
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - 142 bulkload=yes
bl_bucket= "Bulkload.bucket" bl_key="ZZZZZZZZZZZZZZZZ"
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - 142 !
bl_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX bl_de
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj -
the macro variable "DBDSOPTIONS".
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - 142 bulkload=yes
bl_bucket= "Bulkload.bucket" bl_key="ZZZZZZZZZZZZZZZZ"
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - 142 !
bl_secret=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX bl_de
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj -
_____
2018-01-25T19:30:30,358 INFO [00205311] 2176:userid -
2018-01-25T19:30:30,358 INFO [00205311] 2176:userid -
22
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj -
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - ERROR 22-7: Invalid option name XX_XX.
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj -
2018-01-25T19:30:30,358 INFO [00205311] 2176:useridj - ERROR 22-7: Invalid option name XX_XX.
This error typically occurs when the underlying database is Amazon Redshift and the bulk-loading options include a very long secret key.
To work around this issue, place the BL_KEY= and BL_SECRET= options into a configuration file that can be referenced by the SAS/ACCESS® engine.
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 Core Mid-Tier | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |
| 64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M6 | |||
| 64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M6 | |||
| HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M6 | |||
| Linux for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |||
| Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M6 | |||