Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Hi Lee,
What version are you using? 
When you look at the history are their any messages? Like "Failed to deliver...."
You can turn on SDS (Schedule and Delivery Service) logging to get more details. (Manage -> Configuration -> Diagnostic Logging)

------------------------------
TREVOR COMEAU
------------------------------

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Hi Trevor,

Thanks for your reply. 

The version is IBM Cognos Analytics 11.0.11. I've had a look in 'my schedule's and subscriptions' and every attempt shows as as success despite the emails not going out. Is that the history you are referring to?

Also I don't seem to have a 'manage' button is that something reserved for system administrators?




------------------------------
Lee Griffiths
------------------------------

Original Message:
Sent: Mon February 03, 2020 09:26 AM
From: TREVOR COMEAU
Subject: Cognos report not emailing

Hi Lee,
What version are you using? 
When you look at the history are their any messages? Like "Failed to deliver...."
You can turn on SDS (Schedule and Delivery Service) logging to get more details. (Manage -> Configuration -> Diagnostic Logging)

------------------------------
TREVOR COMEAU

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Hi Lee,
Those advanced logging settings are administrator functions. 

When we send an email to a mail server that can't deliver the message the email server sends us back a failure and Cognos will post it. Depending on how the email server is configured the email address doesn't have to go to a valid endpoint. In this case neither the email server or Cognos would know anything is wrong. 

For example, if I disable Relay on my mail server any bad address with get sent back to Cognos and we will see a message like this.
CNC-SDS-0379 Unable to send a message to an email address. Please check the value: trahf@fhagd.com

If I enable Relay no errors will be seen by the email server so it will look to us that the email was sent successfully.

------------------------------
TREVOR COMEAU
------------------------------

Original Message:
Sent: Mon February 03, 2020 09:38 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hi Trevor,

Thanks for your reply. 

The version is IBM Cognos Analytics 11.0.11. I've had a look in 'my schedule's and subscriptions' and every attempt shows as as success despite the emails not going out. Is that the history you are referring to?

Also I don't seem to have a 'manage' button is that something reserved for system administrators?




------------------------------
Lee Griffiths

Original Message:
Sent: Mon February 03, 2020 09:26 AM
From: TREVOR COMEAU
Subject: Cognos report not emailing

Hi Lee,
What version are you using? 
When you look at the history are their any messages? Like "Failed to deliver...."
You can turn on SDS (Schedule and Delivery Service) logging to get more details. (Manage -> Configuration -> Diagnostic Logging)

------------------------------
TREVOR COMEAU

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Lee,

I have seen this when the report output is too large for you email system.  Our Outlook admins have set a maximum attachment size.  Any email with an attachment larger than that will not be accepted by the Exchange server.  Our solution is to send a link to the report instead of sending an actual copy of the report.

------------------------------
Kevin Bersch
------------------------------

Original Message:
Sent: Mon February 03, 2020 10:15 AM
From: TREVOR COMEAU
Subject: Cognos report not emailing

Hi Lee,
Those advanced logging settings are administrator functions. 

When we send an email to a mail server that can't deliver the message the email server sends us back a failure and Cognos will post it. Depending on how the email server is configured the email address doesn't have to go to a valid endpoint. In this case neither the email server or Cognos would know anything is wrong. 

For example, if I disable Relay on my mail server any bad address with get sent back to Cognos and we will see a message like this.
CNC-SDS-0379 Unable to send a message to an email address. Please check the value: trahf@fhagd.com

If I enable Relay no errors will be seen by the email server so it will look to us that the email was sent successfully.

------------------------------
TREVOR COMEAU

Original Message:
Sent: Mon February 03, 2020 09:38 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hi Trevor,

Thanks for your reply. 

The version is IBM Cognos Analytics 11.0.11. I've had a look in 'my schedule's and subscriptions' and every attempt shows as as success despite the emails not going out. Is that the history you are referring to?

Also I don't seem to have a 'manage' button is that something reserved for system administrators?




------------------------------
Lee Griffiths

Original Message:
Sent: Mon February 03, 2020 09:26 AM
From: TREVOR COMEAU
Subject: Cognos report not emailing

Hi Lee,
What version are you using? 
When you look at the history are their any messages? Like "Failed to deliver...."
You can turn on SDS (Schedule and Delivery Service) logging to get more details. (Manage -> Configuration -> Diagnostic Logging)

------------------------------
TREVOR COMEAU

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Did you try testing your email server in Cognos Configuration -> Action -> Test

​

------------------------------
brenda grossnickle
BI Programmer Analyst
FIS
------------------------------

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson

Lee,

I have seen this happen when the report is too large for your email system.  If the size of the report is larger than the maximum attachment size allowed by your email server the email will not show up, but Cognos will believe it has sent the email.  At least that is what happens with out Exchange server.  Our solution is to send a link to the report instead of the report itself.  I suppose you could also talk to your email admins and see if they will increase the maximum allowed size of attachments.

------------------------------
Kevin Bersch
------------------------------

Original Message:
Sent: Fri January 31, 2020 09:55 AM
From: Lee Griffiths
Subject: Cognos report not emailing

Hello,

I have a report created in cognos analytics that appears to be running when scheduled, but the email version of the report is not being sent.

The report runs, saves the output as set up to, but no email comes through. I have tried setting it to email user groups in cognos, and manually entering email addresses for it to go to with the same issue.

Any advice on how to troubleshoot this appreciated.

Thanks,


------------------------------
Lee Griffiths
------------------------------

#CognosAnalyticswithWatson