My Oracle Support Banner

REIMFIXEDDEALUPLOAD Batch Fails With an Error When There Are More Than 1000 Fixed Deals to Be Uploaded (Doc ID 2305463.1)

Last updated on OCTOBER 20, 2018

Applies to:

Oracle Retail Invoice Matching - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

REIMFIXEDDEALUPLOAD Batch fails and getting aborted with below error when there are more than 1000 Fixed deals to be uploaded.

Error:

oracle.retail.apps.framework.facetedfilter.model.FacetedFilterRuntimeException : oracle.retail.apps.framework.jdbc.JdbcTemplate$TooManyRowsException: SQL query returned more than 1000 rows. Use ORJdbcTemplate.setResultSetMax(N) to increase the limit or set it to null to remove the limit.

SQL Query : SELECT DISTINCT IMD.SUPPLIER, IMD.SUPPLIER_GROUP FROM IM_MATCH_DOC IMD WHERE IMD.PROCESS_ID = ?

Steps To Recreate:

   1. Create 4000 fixed deals with 10 details each.

   2. Run all batches including vendinvf related to fixed deals. Notice that staging tables are populated.

   3. Run reimfixeddealupload batch, Batch gets aborted and noticed the error.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.