Page MenuHomePhabricator
Create Task
Maniphest T87834

Gateway Reconciliation report times out
Closed, ResolvedPublic1 Estimated Story Points
Actions

Description

The base report at /civicrm/report/contribute/reconciliation is timing out.

We might be able to simply increase webserver timeouts. We should also be able to create Pats a new report instance with more constrained criteria, which will hopefully run a bit faster.

Report criteria:
Whatever we have in the gateway recon is perfect.

I need to able to:

  • choose dates,
  • see amount and
  • number of donations

And filter by:

country
method
gateway
currency
Credit (+) or Debit (-)

Steps to run the report sanely:

Related Objects
Search...

Event Timeline

awight created this task.Jan 29 2015, 1:10 AM
awight raised the priority of this task from to Needs Triage.
awight updated the task description. (Show Details)
awight added projects: Wikimedia-Fundraising, Fundraising-Backlog-Old, Wikimedia-Fundraising-CiviCRM.
awight added subscribers: awight, • Ppena.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 29 2015, 1:10 AM
• Ppena updated the task description. (Show Details)Jan 29 2015, 6:23 PM
• Ppena set Security to None.
awight added a comment.Jan 29 2015, 6:56 PM

The issue seems to be that without specific criteria, we're doing a report on all of history and it's too expensive. This will be fixed by the Giant Rabbit reporting work, but until then, when I'm going to do is create a report instance that does something silly like a one-day window, so it loads fast, then you can start with that and copy it to create new instances with the criteria you want to work with.

• atgo moved this task from Backlog to UserRequests (misc) on the Wikimedia-Fundraising-CiviCRM board.Jan 29 2015, 8:48 PM
• atgo triaged this task as Unbreak Now! priority.Feb 4 2015, 9:08 PM
• atgo added a project: § Fundraising Sprint Devo.
• atgo subscribed.
awight edited a custom field.Feb 4 2015, 9:26 PM
• atgo moved this task from In Analysis to Dev Ready on the § Fundraising Sprint Devo board.Feb 4 2015, 10:54 PM
awight moved this task from Backlog to AWight brooding on on the Fundraising-Backlog-Old board.Feb 5 2015, 7:01 AM
awight moved this task from Dev Ready to Done on the § Fundraising Sprint Devo board.Feb 5 2015, 9:48 PM
awight closed this task as Resolved.Feb 5 2015, 9:51 PM
awight claimed this task.

I've gone ahead with the workaround here. We don't know yet if we're getting the background reports feature, but for now, that's my plan for a long-term solution.

@Ppena, please visit the following report and customize it as you need, using "Save as..." when it's ready to use. The issue here is that the base report pulls too much data, so I've created this instance with stripped down criteria so it can be quickly loaded and edited.

https://civicrm.wikimedia.org/civicrm/report/instance/52?reset=1

awight edited a custom field.Feb 5 2015, 9:51 PM
• atgo reopened this task as Open.Feb 5 2015, 9:53 PM

Hey @awight, I'd like to leave this open until @Ppena confirms that this does what she needs it to and is totally set. Thanks!

awight mentioned this in T88747: Wikibugs bot is skipping many notifications.Feb 5 2015, 9:53 PM
valhallasw subscribed.Feb 5 2015, 10:01 PM

Sorry for the spam; testing wikibugs.

valhallasw added a comment.Feb 5 2015, 10:23 PM

Another test, to make sure this also works.

• Ppena added a comment.Feb 5 2015, 10:26 PM

:(

Screen_Shot_2015-02-05_at_2.08.49_PM.png (256×882 px, 43 KB)

valhallasw added a comment.Feb 5 2015, 10:44 PM

Another test....

valhallasw added a comment.Feb 5 2015, 10:55 PM

And sorry again for spamming your bug, but I think the IRC report should work now :-)

awight added a comment.Feb 5 2015, 11:01 PM

@Ppena, I'm pretty sure this is a ridiculous bug having to do with login. I'm updating the task description with what I believe are the steps to work around the issues.

awight updated the task description. (Show Details)Feb 5 2015, 11:03 PM
awight added a comment.Feb 6 2015, 7:16 PM

@Ppena, can you try again? Jeff doubled the timeout, and I can successfully pull https://civicrm.wikimedia.org/civicrm/report/instance/53?reset=1

You probably still want to limit to one gateway at a time, if that's how you're reconciling anyway!

valhallasw added a comment.Feb 6 2015, 7:46 PM

Sorry, another test to make sure the underlying issue also has been fixed.

Jgreen closed subtask T88759: Set Civi Nginx timeout to something higher as Resolved.Feb 6 2015, 9:12 PM
awight closed this task as Resolved.Feb 6 2015, 9:33 PM
awight moved this task from AWight brooding on to Backlog on the Fundraising-Backlog-Old board.Apr 1 2015, 9:38 PM
• atgo added a project: Fundraising-Backlog.Jun 30 2015, 10:16 PM
• atgo moved this task from Triage to Closed Sprint Work Q3 1415 on the Fundraising-Backlog board.
• atgo unsubscribed.Mar 30 2016, 10:03 PM
• mmodell removed a subscriber: awight.Jun 22 2017, 9:44 PM
Restricted Application added subscribers: Jay8g, TerraCodes. · View Herald TranscriptJun 22 2017, 9:44 PM
• DStrine edited projects, added Fr-tech-archived-from-FY-2014/15; removed Fundraising-Backlog.Jan 11 2018, 9:28 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 · Credits