Page MenuHomePhabricator

Adyen discrepancy - batch 1154 (caused by Gr4vy bugs)
Closed, ResolvedPublic

Description

There are 5 missing EUR transactions
2 from T419593: Donor donated 3 times in 7 seconds with gravy google pay and had a duplicate invoice id (donation & refund)
2 that have a donation value of 3.10 EUR and a fee of .18 and were processed through gravy -
One of which is
WikimediaDonations R7SZ4HK2D2PMWL69 2UxXBxCWhZRlvhGTIY2xLv mc 2026-03-05 11:48:13 PST Settled ZF32XG2TQQZDN969 EUR 0.18 34

This appears to be a double charge of a recurring with jL6NxlUMIVqgx8rI5uWf7 being in Civi
https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=70094212
https://civicrm.wikimedia.org/civicrm/contact/view/contribution?reset=1&id=140122397&cid=70094212&action=view&context=contribution&selectedChild=contribute

Missing - Same order IDs....
{"gr4vy_intent":"authorize","gr4vy_buy_ref":"xxx@gmail.com","gr4vy_tx_sid":"2UxXBxCWhZRlvhGTIY2xLv","gr4vy_pm_sid":"1zK1wV3wBVWiWY089KOlkP","gr4vy_tx_ref":"245232778.1","gr4vy_ps_sid":"3Tj7KgdfvF8ZNlccmtERbc"}

IN Civi

{"gr4vy_buy_ref":"xxx@gmail.com","gr4vy_tx_sid":"jL6NxlUMIVqgx8rI5uWf7","gr4vy_ps_sid":"3Tj7KgdfvF8ZNlccmtERbc","gr4vy_intent":"authorize","gr4vy_pm_sid":"3Ui2KjXOmb7hvO5oTFLrjE","gr4vy_tx_ref":"245232778.1"}

? the last one is > 3.10

order idamountmethodAdyen IdGravy IdTime of donation
245232778.13.10MCPR66HL5SWVL397B9jL6NxlUMIVqgx8rI5uWf7Mar 5, 2026, 19:47:09
245232778.13.10R7SZ4HK2D2PMWL692UxXBxCWhZRlvhGTIY2xLvMar 5, 2026, 19:47:11
245240435.13.10SLQGR89TQ8Z2XP693yA18wohtCJ0p6ZfWmrxSJ
245240435.13.10NSG5GQPVMXPRZM693E0rOrcQzIT2f5t7EpDpnW
245246263.115.60G9BR7ZHCDVVCC83556t3LvIIz35vwP8odvVMlV
245246263.115.60LKPG854CFSMZ3F3551j1QNFdQX1wa7ItlueOAd

Event Timeline

Eileenmcnaughton renamed this task from Adyen discrepancy - batch 1154 to Adyen discrepancy - batch 1154 (caused by Gr4vy bugs).Mar 18 2026, 11:56 PM

OK - I got a script & found the discrepancies

Gr4vy DOUBLE-CHARGED ORDER IDS

Order ID: 245232778.1
Occurrences: 2
Amounts: 3.10

  • File: incoming/settlement_detail_report_batch_1154.csv, line 19514, status=Settled, amount=3.10, psp_reference=PR66HL5SWVL397B9, tx_sid=jL6NxlUMIVqgx8rI5uWf7
  • File: incoming/settlement_detail_report_batch_1154.csv, line 19516, status=Settled, amount=3.10, psp_reference=R7SZ4HK2D2PMWL69, tx_sid=2UxXBxCWhZRlvhGTIY2xLv

Order ID: 245240435.1
Occurrences: 2
Amounts: 3.10

  • File: incoming/settlement_detail_report_batch_1154.csv, line 21455, status=Settled, amount=3.10, psp_reference=SLQGR89TQ8Z2XP69, tx_sid=3yA18wohtCJ0p6ZfWmrxSJ
  • File: incoming/settlement_detail_report_batch_1154.csv, line 21458, status=Settled, amount=3.10, psp_reference=NSG5GQPVMXPRZM69, tx_sid=3E0rOrcQzIT2f5t7EpDpnW

Order ID: 245246263.1
Occurrences: 2
Amounts: 15.60

  • File: incoming/settlement_detail_report_batch_1154.csv, line 22744, status=Settled, amount=15.60, psp_reference=G9BR7ZHCDVVCC835, tx_sid=56t3LvIIz35vwP8odvVMlV
  • File: incoming/settlement_detail_report_batch_1154.csv, line 22745, status=Settled, amount=15.60, psp_reference=LKPG854CFSMZ3F35, tx_sid=51j1QNFdQX1wa7ItlueOAd

Order ID: 245260402.2
Occurrences: 2
Amounts: 10.40 - already logged as T419593

  • File: incoming/settlement_detail_report_batch_1154.csv, line 40742, status=Settled, amount=10.40, psp_reference=JQQ78WK6R47RCC35, tx_sid=wJdc95XYcVhnwSRdzb0QC
  • File: incoming/settlement_detail_report_batch_1154.csv, line 40743, status=Settled, amount=10.40, psp_reference=VLB7ZZGKZ5LLLK35, tx_sid=5x2poFrkhT7dd666ML1IeZ

For 245232778

payments-gravy-20260306.gz:Mar 5 19:47:11 payments1006 gravy_gateway: 245232778:245232778.1 Calling approvePayment on PSP reference 18073161-5793-4d9d-a5e9-5f25ff388705
payments-gravy-20260306.gz:Mar 5 19:47:13 payments1005 gravy_gateway: 245232778:245232778.1 Calling approvePayment on PSP reference 521efe9b-b8c4-4b13-b49d-487e05af554b

fundraising-misc-20260306.gz
Mar 5 19:50:12 SPCID-0981121393 | (corr_id-gravy-245232778.1) Could not find donor details for authorization Reference '521efe9b-b8c4-4b13-b49d-487e05af554b' and order ID '245232778.1'. | |
Mar 5 19:50:12 SPCID-0981121393 | (corr_id-gravy-245232778.1) Processing captured Gravy payment with authorization reference '18073161-5793-4d9d-a5e9-5f25ff388705' and order ID '245232778.1'. | |
Mar 5 19:50:12 SPCID-0981121393 | (corr_id-gravy-245232778.1) Processing captured Gravy payment with authorization reference '521efe9b-b8c4-4b13-b49d-487e05af554b' and order ID '245232778.1'. | |

I refunded the non-Civi duplicates from Order ID: 245232778.1, Order ID: 245240435.1 & Order ID: 245246263.1

Change #1259241 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Bubble up Adyen Reversal Txn ID

https://gerrit.wikimedia.org/r/1259241

Change #1259253 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Declare our new reversal_id fields as AuditMessage fields

https://gerrit.wikimedia.org/r/1259253

Change #1259287 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Start saving our backend_processor_reversal_id

https://gerrit.wikimedia.org/r/1259287

Change #1259253 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Declare our new reversal_id fields as AuditMessage fields

https://gerrit.wikimedia.org/r/1259253

Change #1259241 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Bubble up Adyen Reversal Txn ID

https://gerrit.wikimedia.org/r/1259241

Change #1259381 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Start to bubble up auth_id and capture_id

https://gerrit.wikimedia.org/r/1259381

Change #1259383 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/crm@master] Declare auth_id & capture_id as legit fields

https://gerrit.wikimedia.org/r/1259383

Change #1259381 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Start to bubble up auth_id and capture_id

https://gerrit.wikimedia.org/r/1259381

Change #1259383 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Declare auth_id & capture_id as legit fields

https://gerrit.wikimedia.org/r/1259383

Change #1260932 had a related patch set uploaded (by Eileen; author: Eileen):

[wikimedia/fundraising/SmashPig@master] Stop bubbling up backend_processor_refund_id from AdyenAudit

https://gerrit.wikimedia.org/r/1260932

Change #1260932 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Stop bubbling up backend_processor_refund_id from AdyenAudit

https://gerrit.wikimedia.org/r/1260932

Change #1259287 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Start saving our backend_processor_reversal_id

https://gerrit.wikimedia.org/r/1259287