Defect HC-5182

Oracle SQL Error when a Product has more than 1000 SKUs

Software

Customer case Applies to Corrected in
CS0145240 V9.0.1.12 9.0.1.14

Observed behavior

When a product contains more than 1000 skus, the product display page will show an exception similar to the following when using an Oracle database.

Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

Expected behavior

Oracle database queries are limited to 1000 entries in their "in" clause.

Resolution

The code was restructured to split up the queries so that all entries can be retrieved without exceeding the 1000 entry limit.