Record is failing for 5000 rows giving "An Error occurred while retrieving data"

PGarg over 6 years ago

Hi All,

We have a record mapped to a view which fails frequently giving "An Error Occurred While Retrieving The Data". When we executing Select * from <View> in database we are getting data within .33 seconds, but in Records after waiting for 10-15 seconds it fails.

We are on cloud and our database is on premise oracle database.

I am looking for alternatives to handle this situation like:

1. Can we restrict the data being fetched in record list (E.g. only 10 rows)

2. Search / Filters should work on complete data.

Any suggestions would be appreciated

Thanks

Discussion posts and replies are publicly visible

Parents

0 anshuk611 over 6 years ago

Default filters can be used to minimize the data,If it suffice your requirement.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 PGarg over 6 years ago in reply to anshuk611

Additionally, we want Generic Search to be applicable across all the columns irrespective of any Filter because 99.9% time user use Generic Search to get the relevant record rather than navigating through different pages of Grid.

Is there any way to restrict the number of rows in Record itself? Because anything we try to do at Databse level it will be applicable to Generic Search as well.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PGarg over 6 years ago in reply to anshuk611

Additionally, we want Generic Search to be applicable across all the columns irrespective of any Filter because 99.9% time user use Generic Search to get the relevant record rather than navigating through different pages of Grid.

Is there any way to restrict the number of rows in Record itself? Because anything we try to do at Databse level it will be applicable to Generic Search as well.

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data