SUPPORT / SAMPLES & SAS NOTES
Problem Note 48892: On-Demand dippr_extract and dippr_update macros might generate the message "ERROR: Subquery evaluated to more than one row"
 |  |  |  |  |
When using the On-Demand dippr_extract or dippr_update macros in SAS® Promotion Optimization to extract or update information for an alternate promotion, the following error might be generated in the log:
ERROR: Subquery evaluated to more than one row.
This error is generated because the plan ID is not unique for alternate promotions.
There is no workaround for this issue.
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 Promotion Optimization | Microsoft® Windows® for x64 | 5.2_M1 | 5.2_M2 | 9.3 TS1M2 | 9.3 TS1M2 |
| Linux for x64 | 5.2_M1 | 5.2_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||