-
Bug
-
Resolution: Unresolved
-
Critical
-
None
-
None
-
None
-
True
-
-
False
-
subs-swatch-2
-
-
This bug was identified during the investigation for spike SWATCH-3770. Use status to terminate contract that comes from IT partner gateway UMB contract message.
During the analysis, it was found contracts that have a subscription_number, but no corresponding record exists in the Subscriptions table.
SELECT *,CASE WHEN s.subscription_id IS NULL THEN TRUE ELSE FALSE END AS subscription_missing_contract_present FROM contracts c LEFT JOIN subscription s ON c.subscription_number = s.subscription_numberAND c.start_date = s.start_date WHERE s.subscription_id IS NULL AND c.subscription_number IN('15434824','15279427');
Attached is an example for subscription_number 15279427 are the example response from Subscription search api and also Contract IT Partner gateway.
Contract_subscription_number_15279427.txt
Subscription_searchapi_subscription_number_15279427.txt
"status": "UNSUBSCRIBED" as seen in contract example.
Acceptance Criteria:
- Honor status in contracts message and the contract should terminate if depending on the status.
- Update the test plan according to the discussion with IT partner integration team on end date.
- blocks
-
SWATCH-3768 Migrate contract_metrics data to subscription_measurements
-
- Backlog
-
-
-
- Backlog
-
- is blocked by
-
-
- Refinement
-
-
-
- Release Pending
-
-
SWATCH-3956 Determine the issue with 802 contract missing subscription_number
-
- New
-