Problem Note 53137: SAS® Scalable Performance Data Server does not create the &SYSDBRC and &SQLRC macro variables when you publish to the common data model
The macro to publish to the common data model in SAS® Marketing Automation uses the macro variables &SYSDBRC and &SQLRC.
Problems do not occur when you use these macro variables to publish to a database. However, when you use SAS Scalable Performance Data Server, these macro variables do not work. This problem occurs because SAS Scalable Performance Data Server does not create the &SYSDBRC and &SQLRC macro variables.
You might see the following error in the SASCustIntelCore6.1 log:
WARNING: Apparent symbolic reference SQLRC not resolved.
ERROR: A character operand was found in the %EVAL function or %IF condition
where a numeric operand is required. The condition was: &SQLRC > 4
ERROR: The macro MACPTPUB will stop executing.
The error does not have any effect on the campaign publishing and can be ignored.
Operating System and Release Information
| SAS System | SAS Marketing Automation | Solaris for x64 | 6.1 | 6.3 | | 9.4 TS1M1 |
| HP-UX IPF | 6.1 | 6.3 | | 9.4 TS1M1 |
| Linux for x64 | 6.1 | 6.3 | | 9.4 TS1M1 |
| 64-bit Enabled Solaris | 6.1 | 6.3 | | 9.4 TS1M1 |
| 64-bit Enabled HP-UX | 6.1 | 6.3 | | 9.4 TS1M1 |
| 64-bit Enabled AIX | 6.1 | 6.3 | | 9.4 TS1M1 |
| Microsoft® Windows® for x64 | 6.1 | 6.3 | | 9.4 TS1M1 |
*
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.
The warning "Apparent symbolic reference SQLRC not resolved" occurs. This does not have an effect on the campaign publishing and can be ignored.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-07-01 09:46:03 |
| Date Created: | 2014-06-04 10:57:05 |
