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
SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3 | 4.3_M1 | 9.2 TS2M3 | 9.2 TS2M3 |
*
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: | 2020-02-10 12:53:08 |
Date Created: | 2010-12-08 15:26:54 |