60640 - SAS® Size Optimization fails when publishing profiles with "ERROR: ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000"

SUPPORT / SAMPLES & SAS NOTES

Problem Note 60640: SAS® Size Optimization fails when publishing profiles with "ERROR: ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000"

In SAS^® Size Optimization, publishing profiles for a project might fail with the following error:

ERROR: ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000.

This error occurs when you publish profiles for a project that contains more than 1000 sizesets.

The workaround for this issue is to split the project into projects with fewer than 1000 sizesets.

Click the Hot Fix tab in this note to access the hot fix for this issue.

* 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:	medium

Date Modified:	2017-08-08 09:23:42
Date Created:	2017-06-15 14:31:54