Troubleshooting Self-Subscription for CADORS Daily Reports

Overview:

This document outlines steps for troubleshooting issues arising from subscriptions created via
Subscribe to CADORS Daily Reports in CADORS External.

DevOps ticket: 333226: A client is no longer receiving the daily regional Ontario report by email

Key Tables

See also PK_SUBSCRIPTION

Note: to view PK_SUBSCRIPTION when connected as CADORS_DUI, change the name space in the schema browser to CADORS_USER.

Example:

Steps:

1. Connect to the database.

   • I connected to CADORSP.world as CADORS_DUI.
     

2. Obtain the CADORS_REQUEST_NUM(s) for the subscription with a query by the email address(es)
   Example:

   select * from GA004_CADORS_REPORT_REQUEST
   where upper(EMAIL_ADDRESS_TXT) LIKE upper('etingey%@hotmail.com');

   • Verify that DATE_DEACTIVATED_DTE and DATE_DELETED_DTE are NULL.
     

3. Query the relevant table(s) with a query on the
   Example:
   

   select * from GA006_REGIONAL_SUBSCRIPTION
   where CADORS_REPORT_REQUEST_NUM IN ('A2K8G3Y7U6', 'P6N9L6W5D7');

   • Verify that DATE_DELETED_DTE is NULL.
     

Additional notes:

I tested subscribing using my TC email address. I also created a hotmail account.

• For my TC email address, the activation email and subscription emails were sent to my inbox.

• On the hotmail account, the activation email was sent directly to the junk folder.