Support Article
Fetching all records from external table for loading in RD
SA-5140
Summary
User is pulling the data from an external table, since the number of records are large, they were unable to pull data more than 100K. If one tries to pull using RDB-List method, PRPC thread hangs. User queries for solution to pull the data when it is more than 800k and traverse over it and use it with some pagination? Or, do we have to pull data multiple times, like 100K each time?
Resolution
Following steps describe implementation of Pagination using an Activity -
- Create an Activity (chkaPaginationPaterntActivity).
- Set a Property (Integer) as counter and have a for loop in the Pre-Condition step.
- Set the index number in the Property-Set step and call another activity (ChkPagination) where you have configured the Report Definition. (You can call the Report Definition in the same activity).
Step-2: Parameters and Pages & Classes tabs of the Activity:
Step-3: chkPagination Activity:
Step-4: Parameters and Pages & Classes tabs of the Activity:
Step-5: Report Definition : chkRD
On running the chkaPaginationPaterntActivity activity, it calls the Report Definition. User can process each records within the For Loop of this activity by retrieving the pxResults() from the Clipboard.
Some More queries:
User came up with below queries:
When we run the RD, it is going to override the fetched results as per the page records we have specified in the Activity?
Answer: Yes
Does the RD is going to fetch all records at a time or is it going to fetch records of each page and fetch the next set of records?
Answer: It will fetch once, we access the pages as per the defined index.
After the completion of the RD, does the records are going to stay in Clipboard? User need to remove them explicitly?
Answer: Yes. User have to delete it explicitly. And, if we have 38 records, and we are fetching 5 records per page, then in my 8th page of the Report, we would have pxResults(1),(2) and (3) with the actual results. pxResults(4) and (5) would be empty.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.