Reporting issue
Incident Report for The Coupon Bureau (Prod)
Resolved
The issue has been successfully resolved, and we have conducted a thorough incident analysis, which you can find at the following link.

https://developer.thecouponbureau.org/data-recovery-process-how-we-recovered-missing-redemption-information-without-downtime-ca78ec7eddce
Posted May 10, 2023 - 18:40 UTC
Monitoring
A fix has been implemented and we are monitoring the results.
Posted May 10, 2023 - 14:12 UTC
Identified
Issue Overview: When a serialized data string is created, a record is created in two databases, a primary, and a secondary database. Seven days after a campaign expires, the primary database record is deleted to maintain optimal performance times for primary database functions. We learned that records from an undetermined number of campaigns with April activity were not recorded in the secondary database, and the primary database record was deleted upon the expiration of those campaigns leaving no records of deposits and redemptions for this time frame.

Resolutions: We are currently working on recovering the missing data. We are also extending the primary deletion parameter from 7 days to 6 months to allow for a longer window of duplicate records. The estimated time for total resolution is 4 days.
Posted May 09, 2023 - 18:11 UTC
This incident affected: Reporting.