SUPPORT / SAMPLES & SAS NOTES
Problem Note 57778: An "ORA-00913: too many values.." error might occur after opening the Pack Optimization Products view
 |  |  |  |  |
In SAS® Pack Optimization, the following error might occur in the client and middle-tier server log files after opening the Pack Optimization Products view:
FATAL Worker-1 java.lang.StackTraceElement - could not execute query...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00913: too many values
This error is likely to occur when you have a high volume of size sets in your system.
The workaround for this issue is to reduce the number of size sets in your system. Refer to the SAS Pack Optimization Reference Guide for information about size sets methods and purging.
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 Pack Optimization | Microsoft® Windows® for x64 | 3.2 | 3.4 | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 3.2 | 3.4 | 9.4 TS1M3 | |||
| Linux for x64 | 3.2 | 3.4 | 9.4 TS1M3 | |||