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.
Symptoms
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) * ?
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 |