Error: There has been an issue; please consult your system administrator
We are uploading google sheet and copying those data into pagelist on click of button. We are validating those data after copying into pagelist and displaying only error data's in the screen.
We are validating a pagelist which have more than 5000 pages. Each page have 10 fields. We are validating all the fields in pagelist. Some of the validations checking with external db. These validations taking more than 10 minutes and displaying error- There has been an issue; Please consult your system administrator.
When we have less than 3500 records it is taking 8-9 minutes and returning data without any issue.
Whenever it takes more than 10 minutes this error is coming in screen.
When we refresh the screen all the data were loaded correctly in pagelist as expected. When I inspect the screen, found server responded with status of 500. Nothing in pega logs and I can see Alert PEGA0017 in alert logs.
Coforge DPA
GB
@VinothDont you think the better option would be to keep the validation in the backend. We had a similiar requirement and followed below steps:
1. Upload the data in the sheet.
2. User clicks the validate button. A request is queued
3. Queue processor validates the record
4. Show the errors on UI
With such a large data, i think you should make use of background processing and not do it as soon as you click the button.
Regards
Bhavya