Problem Note 41792: Plan update cannot handle more than 1000 plans
 |  |  |  |  |
When you import plan data into SAS® High-Performance Markdown Optimization, the load_stg2dm_mdo_import_plan ETL job might fail with a database error.
ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000
This error occurs when you attempt to update more than 1000 plans during the import.
The work around for this issue is to split the import file into pieces, such that each piece contains less than 1000 update records.
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 High-Performance Markdown Optimization | Linux for x64 | 4.3 | 4.3_M1 | 9.2 TS2M3 | 9.2 TS2M3 |
A fix for this issue for SAS High-Performance Markdown Optimization 4.3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/D34.html#41792| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-02-10 12:53:08 |
| Date Created: | 2010-12-08 15:26:54 |