I have a Cognos report view that is scheduled to run and email out daily at 6:30 AM. We'll call this "Report A." Twice now, the email has started going out to the usual recipients, and with the correct subject line, but with the wrong report attached, which we'll call "Report B." Report B is a completely unrelated report: different owner, different email recipients, different schedule (daily at 3:00 PM), and entirely different subject matter. So, the email recipients for Report A will receive an email with a subject line indicating Report A, but with Report B attached. By looking at the Versions info for the two reports, when the mix-up starts happening, Report A no longer runs, and Report B runs at the time that Report A is scheduled. The email mix-up will continue I manually change the scheduled time for *both* reports, after which they both go back to normal. If I change only the scheduled run-time of Report A, it will run at the new time, and Report B will continue going out at the original time Report A went out, with the email recipients and subject line for Report A.

This seems to be a bug in the Cognos scheduling system. This issue has now occurred twice; starting on 11/19/2021, and starting again on 12/19/2021. It appears to happen spontaneously; no recent changes had been made to either report. And as stated above, the issue will continue until both report schedules are manually updated, meaning neither the recipients of Report A, nor the recipients of Report B, will have the information they need to do their job until I or someone else knowledgeable about this bug is able to take manual action. I'm using Cognos Analytics version 11.1.7. Any experience with this kind of problem or suggestions for resolving it would be very appreciated.

------------------------------
Scott Meyer
------------------------------

#CognosAnalyticswithWatson

Hi Scott

I had the same issue a while ago, and cannot remember exactly how I fixed this.  I would try the following.
First and easiest is to run a consistency check.  (Find and Fix) as per below document:
https://www.ibm.com/docs/en/cognos-analytics/10.2.2?topic=administration-creating-running-content-store-consistency-check

If above does not work try cleaning up the Notification DB...  Below is the document for this,
(To delete tables from the notification database, go to c10_location/configuration/schemas/delivery directory)

https://www.ibm.com/docs/en/cognos-analytics/10.2.2?topic=resources-running-database-index-cleanup-scripts

It works in Cognos 11 even if above states Cognos 10.

Good luck, I hope this fixes your problem.

Regards

------------------------------
Braam Malherbe
------------------------------

Original Message:
Sent: Tue December 28, 2021 10:05 AM
From: Scott Meyer
Subject: Scheduled reports getting mixed up

I have a Cognos report view that is scheduled to run and email out daily at 6:30 AM. We'll call this "Report A." Twice now, the email has started going out to the usual recipients, and with the correct subject line, but with the wrong report attached, which we'll call "Report B." Report B is a completely unrelated report: different owner, different email recipients, different schedule (daily at 3:00 PM), and entirely different subject matter. So, the email recipients for Report A will receive an email with a subject line indicating Report A, but with Report B attached. By looking at the Versions info for the two reports, when the mix-up starts happening, Report A no longer runs, and Report B runs at the time that Report A is scheduled. The email mix-up will continue I manually change the scheduled time for *both* reports, after which they both go back to normal. If I change only the scheduled run-time of Report A, it will run at the new time, and Report B will continue going out at the original time Report A went out, with the email recipients and subject line for Report A.

This seems to be a bug in the Cognos scheduling system. This issue has now occurred twice; starting on 11/19/2021, and starting again on 12/19/2021. It appears to happen spontaneously; no recent changes had been made to either report. And as stated above, the issue will continue until both report schedules are manually updated, meaning neither the recipients of Report A, nor the recipients of Report B, will have the information they need to do their job until I or someone else knowledgeable about this bug is able to take manual action. I'm using Cognos Analytics version 11.1.7. Any experience with this kind of problem or suggestions for resolving it would be very appreciated.

------------------------------
Scott Meyer
------------------------------

#CognosAnalyticswithWatson

I have not seen that particular scenario but we have jobs with steps that need to run in sequence but they intermittently run in a random order. This is an issue for us because we have an execution log at the end of the job to pick up any report failures. Therefore if the job doesn't consistently run in the specified order then we end up missing failures and manually need to check. We are using v11.2.1. Sorry cant offer a solution to your issue but sharing our experience to highlight that there are defiantly issues around scheduling which we didn't experience in v10.2.

------------------------------
Eric Mueller
------------------------------

Original Message:
Sent: Tue December 28, 2021 10:05 AM
From: Scott Meyer
Subject: Scheduled reports getting mixed up

I have a Cognos report view that is scheduled to run and email out daily at 6:30 AM. We'll call this "Report A." Twice now, the email has started going out to the usual recipients, and with the correct subject line, but with the wrong report attached, which we'll call "Report B." Report B is a completely unrelated report: different owner, different email recipients, different schedule (daily at 3:00 PM), and entirely different subject matter. So, the email recipients for Report A will receive an email with a subject line indicating Report A, but with Report B attached. By looking at the Versions info for the two reports, when the mix-up starts happening, Report A no longer runs, and Report B runs at the time that Report A is scheduled. The email mix-up will continue I manually change the scheduled time for *both* reports, after which they both go back to normal. If I change only the scheduled run-time of Report A, it will run at the new time, and Report B will continue going out at the original time Report A went out, with the email recipients and subject line for Report A.

This seems to be a bug in the Cognos scheduling system. This issue has now occurred twice; starting on 11/19/2021, and starting again on 12/19/2021. It appears to happen spontaneously; no recent changes had been made to either report. And as stated above, the issue will continue until both report schedules are manually updated, meaning neither the recipients of Report A, nor the recipients of Report B, will have the information they need to do their job until I or someone else knowledgeable about this bug is able to take manual action. I'm using Cognos Analytics version 11.1.7. Any experience with this kind of problem or suggestions for resolving it would be very appreciated.

------------------------------
Scott Meyer
------------------------------

#CognosAnalyticswithWatson