In SAS^® Size Profiling, the following error might be encountered when trying to generate store groups:

 
ERROR: ORACLE prepare error: ORA-01795: maximum number of expressions in a list is 1000. 
SQL statement: select a.* from di_dm.prf_sizeset A where A.PROFILING_PROJECT_SK IN (xxxxx)
AND A.SIZESET_ID IN (<comma separated list of SIZESET_ID values>).

This error is generated when a profiling project contains more than 1000 size sets.

There are two possible workarounds for this issue:

• Delete some of the size sets.
• Break up the project into multiple projects with smaller scope.

Operating System and Release Information