Failmail storm, checked multiple damage tables, all picked on their order id is able to find the token, and the received_date is the date of failmail which is initial payment, currency is INR from IN.
used SELECT token FROM civicrm.civicrm_contribution cc left join civicrm.civicrm_contribution_recur ccr on cc.contribution_recur_id = ccr.id join civicrm.civicrm_payment_token cpt on cpt.id = ccr.payment_token_id where cc.invoice_id = xxxxx.1; not null.
A message was removed from the queue due to the following error(s):
Error: INVALID_MESSAGE Recurring donation, but no subscription ID or recurring payment token found. Source: array ( )
---Source---
https://civicrm.wikimedia.org/damaged/535239
---End---