Page MenuHomePhabricator
Create Task
Maniphest T292370

Unable to download the query data - Rakhi Fraud Scan
Closed, ResolvedPublic
Actions

Description

I am unable to download the query data that I run on daily basis for fraud scanning.

Go to Search Kit > Rakhi Fraud Scan > Change the date parameter to "09/30/2021 to 10/03/2021" > Search.

Once the query result shows up, go to Action > Download Spreadsheet.

Until 30th September, the query would get downloaded in less than a minute or so but now it is not getting downloaded even after waiting for 30 mins.

Could you please assist urgently since we need this query to do fraud scanning on daily basis?

Event Timeline

RKumar_WMF created this task.Oct 3 2021, 5:58 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 3 2021, 5:58 PM
RKumar_WMF added a comment.Oct 4 2021, 4:40 AM

To add - We are unable to sort the data as well before downloading that we were able to do before 30th September.

XenoRyet added a project: fundraising sprint Screaming Goats Yelling Zoo.Oct 4 2021, 7:43 PM
XenoRyet moved this task from Triage to Current Sprint on the Fundraising-Backlog board.
Eileenmcnaughton moved this task from Backlog to Doing on the fundraising sprint Screaming Goats Yelling Zoo board.Oct 4 2021, 10:43 PM
Eileenmcnaughton subscribed.Oct 5 2021, 4:13 AM

Thanks @RKumar_WMF - unfortunately this regression was in the release we put out last week but I should have a fix in the next few days

RKumar_WMF added a comment.Oct 5 2021, 5:03 AM

Thank you.

Eileenmcnaughton moved this task from Doing to Review on the fundraising sprint Screaming Goats Yelling Zoo board.Oct 5 2021, 7:26 PM

OK - I have a patch for review https://gerrit.wikimedia.org/r/c/wikimedia/fundraising/crm/civicrm/+/726113

Eileenmcnaughton moved this task from Review to Done on the fundraising sprint Screaming Goats Yelling Zoo board.Oct 6 2021, 3:24 AM

@RKumar_WMF should be all good now

RKumar_WMF added a comment.Oct 6 2021, 3:39 PM

I am able to download the spreadsheet but unable to sort the query result in within Civi before downloading.

XenoRyet added a project: Fundraising Sprint Technical debt house of horrors.Oct 12 2021, 8:17 PM
RKumar_WMF added a comment.Oct 13 2021, 8:40 AM

I am unable to download if the number of rows are higher . I tried with ~30k lines, it took forever and did not download. After 10 mins of waiting, I canceled the download and split the query to download lesser data. I was able to download ~15k lines.

Eileenmcnaughton added a subscriber: Dwisehaupt.Oct 13 2021, 7:29 PM

@Dwisehaupt I think this latest comment duplicates another ticket around that server setting?

Eileenmcnaughton added a comment.Oct 19 2021, 4:54 AM

@RKumar_WMF - @Dwisehaupt has upped the url length the server permits again - hopefully it will be enough although at some point it might be necessary to split the file

Eileenmcnaughton moved this task from Backlog to Done on the Fundraising Sprint Technical debt house of horrors board.Oct 19 2021, 7:11 PM
XenoRyet closed this task as Resolved.Oct 26 2021, 7:10 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL