Too much data from report

rishub over 7 years ago

Hi All,

I was trying to capture the process history from process & store it in our Database. But the issue is that some of our processes run 15000 times a day & in that case, report even with the process model ID filter and date filter gives us 15000 processes. When I use, that analytics report in our process model get process instance ID, PV can pick up only 4000 process IDs. Is there any ways, I can handle it without changing configuration?

Discussion posts and replies are publicly visible

0 ChristineH
Certified Lead Developer
over 7 years ago

Are you doing this as a standalone utility or are you doing this as part of each process instance? I would recommend looking at putting the utility into a sub and doing this as each process instance works. My concern with as a utility is not only the limit, but when you implement a loop it would be the impact on the system with the number of active instances, things in memory, etc.
Hope that helps and I understand what you are looking at.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub over 7 years ago

@Christineh, I am trying use it as a standalone utility. I can't add this as a sub to process model as we don't want to touch our existing process models. So we will run this utility at off hours & that can give us the results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 7 years ago

@rishub Would you be able to expand on the implementation - That is, are you using Execute Process Report or Query process Analytics or Get Portal Report Datasubset? I picked up more than 10000 records from PV quite easily and I don't think it requires a change in configuration. I can try assisting provided if you expand on implementation details.

On a side note, I would like to stringly recommend what @christineh has suggested.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 rishub over 7 years ago

Thanks for update Sikhivahans. I am using Portal Report & getting data through execute process report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 7 years ago

@rishub Which version are you on? Can you try executing the a!queryProcessAnalytics() and see what it's returning? I hope that you have checked the default filters on the Report, considered security(in case of a basic user) and context(such as process, process model, assignees.). To the best of my knowledge, there isn't any limit.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel