In SAS^® Pack Optimization, the following error might occur in the client and mid-tier server log files after opening the Pack Optimization Products view when using custom attributes:

         FATAL Worker-6 java.lang.StackTraceElement - ORA-00913: too many values
         Processing of HttpInvokerServiceExporter remote call resulted in fatal exception: com.sas.solutions.di.server.pko.purchaseorder.api.PKOPurchaseOrderService.getStandardSizes
         com.sas.solutions.di.server.db.api.PersistenceException: ORA-00913: too many values
         at com.sas.solutions.di.server.dm.AttributeServiceBase.getCustomAttributeValues(AttributeServiceBase.java:548)

This error is likely to occur when you have high volume custom attributes or size sets in your system.

The workaround for this issue is to reduce the number of custom attributes or 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

A fix for this issue for SAS Size Optimization 3.41 is available at:

A fix for this issue for SAS Revenue Optimization 5.4 is available at:

A fix for this issue for SAS Size Optimization 3.4 is available at: