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.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Size Profiling | Microsoft® Windows® for x64 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 |
| Linux for x64 | 3.4 | 3.41 | 9.4 TS1M3 | 9.4 TS1M4 | ||
A fix for this issue for SAS Size Optimization 3.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D3R.html#60640A fix for this issue for SAS Revenue Optimization 5.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3R.html#60640A fix for this issue for SAS Size Optimization 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W19.html#60640
SAS® Size Optimization fails when publishing profiles with "ERROR: ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000."
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2017-08-08 09:23:42 |
| Date Created: | 2017-06-15 14:31:54 |