SAP Knowledge Base Article - Public

2878686 - Crystal Report connected to DB2 does not work correctly for more than 8000 records

Symptom

  • Report of Business View works fine for less that 8000 records
  • For more than 8000 records report of Business View selects records and then continue reading unexisting records
  • For the same SQL Command object report returns the following error:

Database Connector Error: '5U026:[IBM][CLIDriver][DB2/AIX64] SQL4712N The threshold "WLMBP_TRIVIAL_DML_SQLRPWSREAD_TH" has been exceeded. Reason code ="11". SQLSTATE=5U026 [Database Vendor Code: -4712 ]'

Environment

  • SAP Crystal Reports 2016
  • IBM DB2

Reproducing the Issue

  1. Open Report with more than 8000 records in Crystal Reports 2016
  2. Refresh the report
  3. Get the error

Cause

  • There is a limit set in the database - a threshold for rows read

Resolution

  •  Increase or remove the limit
  • Add Indexes to the DataBase

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2016