Page MenuHomePhabricator

fail to import recurring donation to civi due to missing recurring token which exist
Closed, ResolvedPublic

Description

Per damage table

recurring donation with order id 201582463.1 failed to import to civi

https://civicrm.wikimedia.org/damaged/605376
INVALID_MESSAGE Recurring donation, but no subscription ID or recurring payment token found. Source: array ( )

while I could find the recurring token for this donation from log

Event Timeline

Adyen is occasionally not sending back the recurring token for valid recurring payments. This donation is one of the 33 affected today. We had 110 such occurrences yesterday. It might be worth emailing them to see why this is happening, as it's much more visible during busy periods.

This was logged during the payment authorization call for that donation:

22 02:57:13 payments1005 adyen_gateway: 201582463:201582463.1 No token found on recurring payment authorization response

Elliott added a patch to log these here. I couldn't find a related ticket.

As you mentioned, we can get the recurring token in the logs from the RECURRING_EVENT IPN body, but it's still annoying.

To get the counts of affected donations, I used:
jgleeson@frlog1002:~$ logdog 'No token found on recurring payment authorization response'

greg triaged this task as Medium priority.Jan 8 2024, 9:26 PM

Here's a list of unique log hits for this scenario from Dec 21st to dig into:

Dec 21 00:06:04 payments1006 adyen_gateway: 201227891:201227891.1 No token found on recurring payment authorization response.
Dec 21 00:54:38 payments1005 adyen_gateway: 201241336:201241336.1 No token found on recurring payment authorization response.
Dec 21 01:27:13 payments1006 adyen_gateway: 201242929:201242929.1 No token found on recurring payment authorization response.
Dec 21 01:27:24 payments1006 adyen_gateway: 201244423:201244423.1 No token found on recurring payment authorization response.
Dec 21 02:06:56 payments1005 adyen_gateway: 201247870:201247870.1 No token found on recurring payment authorization response.
Dec 21 04:00:06 payments1006 adyen_gateway: 201258118:201258118.1 No token found on recurring payment authorization response.
Dec 21 04:31:47 payments1007 adyen_gateway: 201260526:201260526.1 No token found on recurring payment authorization response.
Dec 21 05:25:47 payments1005 adyen_gateway: 201263883:201263883.1 No token found on recurring payment authorization response.
Dec 21 05:47:10 payments1007 adyen_gateway: 201264959:201264959.1 No token found on recurring payment authorization response.
Dec 21 07:02:21 payments1007 adyen_gateway: 201268435:201268435.1 No token found on recurring payment authorization response.
Dec 21 07:50:01 payments1006 adyen_gateway: 201315558:201315558.1 No token found on recurring payment authorization response.
Dec 21 08:52:28 payments1005 adyen_gateway: 201317600:201317600.1 No token found on recurring payment authorization response.
Dec 21 08:59:20 payments1007 adyen_gateway: 201317627:201317627.1 No token found on recurring payment authorization response.
Dec 21 09:53:45 payments1006 adyen_gateway: 201319818:201319818.1 No token found on recurring payment authorization response.
Dec 21 10:56:54 payments1005 adyen_gateway: 201327808:201327808.1 No token found on recurring payment authorization response.
Dec 21 11:37:00 payments1005 adyen_gateway: 201347307:201347307.1 No token found on recurring payment authorization response.
Dec 21 14:12:55 payments1005 adyen_gateway: 201449177:201449177.1 No token found on recurring payment authorization response.
Dec 21 14:01:08 payments1007 adyen_gateway: 201452196:201452196.1 No token found on recurring payment authorization response.
Dec 21 14:41:34 payments1007 adyen_gateway: 201493111:201493111.1 No token found on recurring payment authorization response.
Dec 21 14:58:53 payments1005 adyen_gateway: 201496908:201496908.1 No token found on recurring payment authorization response.
Dec 21 15:27:10 payments1005 adyen_gateway: 201501662:201501662.1 No token found on recurring payment authorization response.
Dec 21 15:32:26 payments1005 adyen_gateway: 201503389:201503389.1 No token found on recurring payment authorization response.
Dec 21 16:29:57 payments1007 adyen_gateway: 201516770:201516770.1 No token found on recurring payment authorization response.
Dec 21 16:49:53 payments1007 adyen_gateway: 201520791:201520791.1 No token found on recurring payment authorization response.
Dec 21 18:36:03 payments1005 adyen_gateway: 201540507:201540507.1 No token found on recurring payment authorization response.
Dec 21 18:51:20 payments1005 adyen_gateway: 201542064:201542064.1 No token found on recurring payment authorization response.
Dec 21 19:06:46 payments1005 adyen_gateway: 201543539:201543539.1 No token found on recurring payment authorization response.
Dec 21 20:08:50 payments1005 adyen_gateway: 201549049:201549049.1 No token found on recurring payment authorization response.
Dec 21 20:32:37 payments1005 adyen_gateway: 201551133:201551133.1 No token found on recurring payment authorization response.
Dec 21 22:46:35 payments1005 adyen_gateway: 201562849:201562849.1 No token found on recurring payment authorization response.

Ah, a lot of those are failed auths. I will narrow the scope of that log line to only log on successful auths.

Change 988741 had a related patch set uploaded (by Ejegg; author: Ejegg):

[mediawiki/extensions/DonationInterface@master] Don't log missing token on failed auth

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

Change 988741 merged by jenkins-bot:

[mediawiki/extensions/DonationInterface@master] Don't log missing token on failed auth

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

This one is a year old and I don't think we have seen this type of failmail in a bit, we can make a new one if it comes back