Page MenuHomePhabricator

Missing adyen gateway in pending record - audit unable to find the row
Closed, ResolvedPublic1 Estimated Story Points

Description

Adyen audit message failing to be created as the pending row can't be found. As a recurring it could probably do something more clever in AuditMessage when getting transaction details

civicrm.wmf.INFO: contribution not found using contribution_extra.gateway adyen and gateway_txn_id T2RF82QJ4CVMRCB9
 {"gateway":"adyen","gateway_txn_id":"T2RF82QJ4CVMRCB9","backend_processor":null,"backend_txn_id":null,"audit_file_gateway":"adyen","gateway_account":"WikimediaDonations","invoice_id":"244748050.1","settlement_batch_reference":"1150","exchange_rate":"1.000000000000000","settled_date":1770360766,"contribution_tracking_id":244748050,"payment_method":"rtbt","payment_submethod":"rtbt_ideal","date":1770360766,"modification_reference":"T2RF82QJ4CVMRCB9","original_currency":"EUR","currency":"EUR","gross":"3.00","original_total_amount":"3.00","settled_fee_amount":-0.22,"fee":"0.22","original_fee_amount":"0.22","settled_gross":"2.78","settled_net_amount":"2.78","settled_currency":"EUR","original_net_amount":"2.78","settled_total_amount":"3.00"}
select * FROM smashpig.pending WHERE order_id LIKE '244748050%'\G
*************************** 1. row ***************************
             id: 140660034
           date: 2026-02-05 18:14:59
        gateway: adyen
gateway_account: WikimediaDonations
       order_id: 244748050.1
 gateway_txn_id: 
        message: {"gateway_txn_id":false,"response":false,"gateway_account":"WikimediaDonations","fee":0,"gross":"3.00","contribution_tracking_id":"244748050","country":"NL","currency":"EUR",

select date,gateway FROM smashpig.pending WHERE gateway_txn_id = '' OR gateway_txn_id IS NULL ORDER BY date DESC LIMIT 50;
+---------------------+-----------+

dategateway

+---------------------+-----------+

2026-02-07 02:07:39paypal_ec
2026-02-07 01:53:49paypal_ec
2026-02-07 01:29:55paypal_ec
2026-02-07 01:28:22paypal_ec
2026-02-06 23:31:42paypal_ec
2026-02-06 23:30:20paypal_ec
2026-02-06 22:48:27paypal_ec
2026-02-06 22:13:51paypal_ec
2026-02-06 22:04:56paypal_ec
2026-02-06 21:12:59paypal_ec
2026-02-06 21:12:48paypal_ec
2026-02-06 20:59:41paypal_ec
2026-02-06 20:59:38paypal_ec
2026-02-06 20:54:10paypal_ec
2026-02-06 19:50:59paypal_ec
2026-02-06 19:21:15adyen
2026-02-06 17:41:58paypal_ec
2026-02-06 17:29:08paypal_ec
2026-02-06 16:45:04paypal_ec
2026-02-06 16:45:01paypal_ec

Related Objects

Event Timeline

Ejegg set the point value for this task to 1.Wed, Feb 11, 5:22 PM

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

[wikimedia/fundraising/crm@master] Fix for donation not coming in from Adyen Audit

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

Change #1238865 merged by jenkins-bot:

[wikimedia/fundraising/crm@master] Fix for donation not coming in from Adyen Audit

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