Page Comparison

...

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

...

Steps:

1. Connect to the database.

   • I connected 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:

   Code Block
   language sql
   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:
   

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