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
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 |
*
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: | alert |
Date Modified: | 2017-01-31 13:17:00 |
Date Created: | 2016-03-02 09:26:29 |