Page MenuHomePhabricator

Missing Adyen transactions - new
Open, MediumPublic

Description

We got a handful of adyen transactions in the last couple of days that are

  1. missing from CiviCRM
  2. missing from smashpig.pending
  3. not found by the log search BUT
  4. present in the contribution tracking

This is an example

{"gateway":"gravy","gateway_txn_id":"3996d870-0950-4885-937d-ece38e3565f1","backend_processor":"adyen","backend_txn_id":"F5P6NXS9FMR5RM25","audit_file_gateway":"adyen","gateway_account":"WikimediaDonations","invoice_id":"249870029.1","settlement_batch_reference":"1244","exchange_rate":"1.000000000000000","settled_date":1784743199,"contribution_tracking_id":249870029,"email":"y@m.com","payment_method":"apple","payment_submethod":"amex","date":1784592973,"backend_processor_txn_id":"F5P6NXS9FMR5RM25","payment_orchestrator_reconciliation_id":"1kfUwwkSMlM1y7oRPZkX8T","type":"donation","modification_reference":"HQ5M6N5JZXN2TN35","capture_id":"HQ5M6N5JZXN2TN35","auth_id":"F5P6NXS9FMR5RM25","original_currency":"USD","currency":"USD","settled_currency":"USD","gross":"50.00","original_total_amount":50.0,"settled_fee_amount":"-1.52","fee":"1.52","original_fee_amount":-1.52,"original_net_amount":"48.48","settled_gross":"48.48","settled_net_amount":"48.48","settled_total_amount":"50.00"}

And some earlier gravy IDs from 20 Jul

Missing Transaction IDs:
GRAVY a853cd7d-d11d-46f7-8390-219c520ed7e6
GRAVY 8cb83fda-c595-4c04-958c-47d6e10b3bfe
GRAVY 193fb1a3-e246-469a-b67c-32765d507fcd
GRAVY 822f5f4c-f97f-4ecc-afb4-6d3bd01e23d4
GRAVY 36c9cd95-c959-4fc4-8213-b0fb2ff3c343
GRAVY 9dfd6e81-2df5-4f17-bf5a-5b623825766a
GRAVY cbf315e2-1843-499d-9179-83ada386e856
GRAVY eff4ff5c-5f50-4253-addf-b5ec101c525a

Event Timeline

Hi @Eileenmcnaughton, could you confirm if the ones you reported as missing in Civi you manually backfilled? I picked a sample and everything seems fine and I'm trying to understand if this got auto-resolved maybe?

GRAVY 3996d870-0950-4885-937d-ece38e3565f1 --> Civi
GRAVY a853cd7d-d11d-46f7-8390-219c520ed7e6 -> Civi
GRAVY 8cb83fda-c595-4c04-958c-47d6e10b3bfe --> Civi
GRAVY 193fb1a3-e246-469a-b67c-32765d507fcd --> Civi
GRAVY 822f5f4c-f97f-4ecc-afb4-6d3bd01e23d4 --> Civi

Should we maybe monitor if this happens by creating a saved searchkit search that checks for Gravy->Adyen transactions with only Contribution Tracking ID but no contribution?