Follow-up action from SWATCH-2069.
We have detected a large number of subscriptions that are duplicated by running the following query:

SELECT * FROM (SELECT s.subscription_number, count(*) as count FROM Subscription s GROUP BY s.subscription_number) s WHERE count > 1;

We need to investigate whether this is expected or it's a side-effect of a wrong logic.

Acceptance Criteria

• Come up with a conclusion about why there are duplications
• If there should not be duplications, address the data with a migration script / and also fix the logic that cause the duplications