Problem Note 47095: The error "ORA-01795: maximum number of expressions in a list is 1000" might occur when adding a plan member
In SAS® High Performance Markdown Optimization, the following error might be encountered when using the "Find by Attributes" filter to add members to a plan:
com.sas.solutions.di.server.db.api.PersistenceException: java.sql.SQLException:
ORA-01795: maximum number of expressions in a list is 1000
at com.sas.solutions.di.server.mdo.PlanMembershipFacade.getParentProduct(PlanMembershipFacade.java:856)
.......
The error is generated because the number of members exceeds the limit enforced by Oracle.
To work around this error, select a smaller product scope.
Operating System and Release Information
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M2 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | high |
| Date Modified: | 2012-08-01 14:23:42 |
| Date Created: | 2012-07-31 09:57:15 |
