My Oracle Support Banner

ReIM ComplexDealUpload Batch Failed With 50000 Max Rows Error (Doc ID 2976891.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Oracle Retail Invoice Matching - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.


Used command: reimcomplexdealupload $UP $Mode.
  Note: $Mode = 5.

Regarding 50K
the actual volume will be a lot more. At this point not all suppliers and items are live in PRODUCTION

No change to the application. More deals (50K+) were processed this time

ReIM Complex deal upload batch failed in PROD. Job failed as the number of deals is more than 50K to process. Please see the batch error below. 

Error message:
Caused By: oracle.retail.apps.framework.jdbc.JdbcTemplate$TooManyRowsException: SQL query returned more than 50000 rows. Use ORJdbcTemplate.setResultSetMax(N) to increase the limit or set it to null to remove the limit. SQL Query : SELECT UNIQUE DEAL_ID FROM (SELECT /*+ FIRST_ROWS(N) */ SFDH.DEAL_ID, ROWNUM RNUM FROM (SELECT DEAL_ID FROM STAGE_COMPLEX_DEAL_HEAD WHERE UPLOAD_IND='N' ORDER BY DEAL_ID ASC) SFDH WHERE ROWNUM <= ? * ? ) WHERE RNUM > (?-1) * ?


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

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