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 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.