Problem Note 60520: An error occurs when you update counts in a Response node and the subject key consists of more than one column
 |  |  |  |  |
When you update counts in a SAS® Customer Intelligence Studio Response node, the updated count generates the following error:
2017-05-11T19:54:52,908 INFO [00016932] 176:wang - MPRINT(MARESPEX): create table MATables.TEFBD04ICWZDOTCG5zhwang as select CUST_NUM HOLDER_CUST_NUM from cellpackagesk where response_sk in (select response_sk from filtered_response_sks);
2017-05-11T19:54:52,908 INFO [00016932] 176:wang - ERROR 22-322: ????,??????: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR,
2017-05-11T19:54:52,908 INFO [00016932] 176:wang - ERROR 22-322: ????,??????: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR,
This error occurs because the subject key consists of more than one column (for example, the CUST_NUM and HOLDER_CUST_NUM columns) and because there is a comma that is missing from between the column names.
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 Marketing Automation Server | Microsoft® Windows® for x64 | 6.4 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 6.4 | 9.4 TS1M2 | ||||
| 64-bit Enabled Solaris | 6.4 | 9.4 TS1M2 | ||||
| HP-UX IPF | 6.4 | 9.4 TS1M2 | ||||
| Linux for x64 | 6.4 | 9.4 TS1M2 | ||||
| Solaris for x64 | 6.4 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Marketing Automation 6.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z77.html#60520| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-07-19 11:05:17 |
| Date Created: | 2017-05-24 11:24:15 |