Size or time limit imposed by the data source was exceeded.

[former_member385171]

Hi Experts,

I have developed a Crystal report using universe on top of IBM DB2 View .

i have set a parameter Receipt Number one of them has approx 46 records in database .

but when i refresh my crystal report and enter the parameter it throws an error and display the blank report.

- i have made the changes in IDT in Blx Query options set the limit to 10000 and time to 100 min still my report throwing the same error.

even i have amend the .cns connection with pool time to 100 minutes, Array fetch size to 100, Array bind size to 500 , login timeout to 1000 sec and maximum parallel query to 14 .(I dont know why we need this but i did- please explain this as well if possible)

i have made some changes in CMC( webi processing server and set limit to 100000) as well but not very sure if there are other please as well where i can change the settings as i have less knowledge on CMC side.

Please advise..

CR Error

//"Query Limits Exceeded

The query did not finish running because a size or time limit imposed by the data source was exceeded.
Please do one of the following:
- Apply additional filters to reduce the size of your result set.
- Apply additional filters to speed up your query.
- Contact your System Administrator."//

//

Webi Error

//

The query did not finish running because a size or time limit imposed by the data source was exceeded. Do one of the following: (1) Apply additional filters to reduce the size of your result set. (2) Apply additional filters to speed up your query. (3) Contact your System Administrator. (CRR 00107, JRC00005414)

//