Problem Note 46753: A data process in a SAS® Real-Time Decision Manager campaign returns the error "invalid column name"
SAS Real-Time Decision Manager enables you to enter parameters to customize a data process for your campaign. If you enter a string constant as the value of one of these parameters, you might get the following error when you execute the campaign:
Invalid column name
When this problem occurs, the generated WHERE clause incorrectly identifies the value of the string constant as a column name.
To work around this problem, create a global variable to hold the string value that you want to use for the comparison. Use the global variable in place of the string.
Operating System and Release Information
SAS System | SAS Real-Time Decision Manager | Linux for x64 | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
HP-UX IPF | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
64-bit Enabled Solaris | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
64-bit Enabled AIX | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
Microsoft® Windows® for x64 | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
Solaris for x64 | 5.4_M1 | 6.1 | | 9.2 TS2M0 |
*
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: | 2012-08-10 15:26:41 |
Date Created: | 2012-06-07 00:19:51 |