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 -
_____
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.
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
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 |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-07-10 14:48:27 |
Date Created: | 2018-03-08 15:56:01 |