This is a governor set on your report, not in the module.
Whoever created your report has set the value for the maximum rows retrieved property to be 5000.
You would need to contact him and a decision needs to be reached as to whether the limit is appropriate.
Each report consists of 1 or more queries.
Each query has properties. One property set is query hints. One of the properties of it is maximum rows retrieved. By default, it is not given a value. This means that there are no limits about how many rows are retrieved. If a value is entered then the query engine will attempt to prevent the report from rendering when rows over the limit are retrieved, as you have seen.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Wed July 29, 2020 01:20 AM
From: MONA KEDIA
Subject: Not able to create new report.
Hi All
I am trying to create a report, but getting below error. Please let me know what needs to be done. Out of the same data module I have other reports which are working perfectly fine.
Thanks & Regards
Mona Kedia
GTS-Business Operations
IBM India Pvt Limited,
# 12 , Subramanya Arcade - 1,
Block B, Bannerghatta Main Road,
Bangalore - 560 029
Handphone-+91 9916256765
E-mail ID -
monakedi@in.ibm.com
#CognosAnalyticswithWatson