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:

Open

Steps:

1. Connect to the database.

   • Connect 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:

Tested subscribing using a TC email address. Also created a hotmail account.

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

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