My Oracle Support Banner

Posting Batch Aborts With an Error "sql query returned more than 1000 rows" (Doc ID 2546995.1)

Last updated on JULY 15, 2020

Applies to:

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

Symptoms

Posting batch aborts with following error:



Steps to Recreate:

  1. Run Posting batch with more than 1000 matched invoices.
  2. Check server log file, ReIMPosting is aborting with an error StuckThreadMaxTime or “oracle.retail.apps.framework.jdbc.JdbcTemplate$TooManyRowsException:SQLquery returned more than 1000”.

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.