COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => COGNOS Connection => Topic started by: bhaskara on 11 Jul 2016 05:12:49 AM

Title: Scheduled Excel2007 Report (as an attachment) not delivered to the recipients
Post by: bhaskara on 11 Jul 2016 05:12:49 AM
Hi,
I have scheduled a report (in COGNOS Connection)  to delivery the user with excel 2002,PDF, CSV output formats and it is working fine without any issue.the same report i have scheduled for Excel 2007 output format for same recipients. the report is running and it is showing report delivered.but it is not delivered the report to recipient's mail box.


Note:   This option last week working this week only we are facing issue.
I have also added RSVP.FILE.EXTENSION.XLS and set the value to TRUE.under Server Administration for Report and Batchreprot services too.
Title: Re: Scheduled Excel2007 Report (as an attachment) not delivered to the recipients
Post by: bdbits on 11 Jul 2016 02:47:03 PM
Have you checked with those who manage your email to see if it is being blocked at the email server?
Title: Re: Scheduled Excel2007 Report (as an attachment) not delivered to the recipients
Post by: bhaskara on 12 Jul 2016 07:11:01 AM
Hi,

Thanks for the reply.
I have cross check with email (SMTP ) managers. They mentioned it appears that the .XLSX files are being flagged as .jar files, which is included as a common malware extension by Microsoft. We believe some part of the process that Cognos uses to generate these excel files is causing these files to be read as .jar files by Microsoft, and thus are flagged as malware.

They are asking us to further investigate Cognos  excel file generation process to see why these files are being flagged as malware to uncover a potential application-side fix.

Please advise is there any alternative method.
Title: Re: Scheduled Excel2007 Report (as an attachment) not delivered to the recipients
Post by: nblank on 12 Jul 2016 07:35:27 AM
Please check this link: https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014876198

Perhaps you can find some solution.
Title: Re: Scheduled Excel2007 Report (as an attachment) not delivered to the recipients
Post by: bdbits on 12 Jul 2016 10:33:25 AM
That sounds... odd. It seems to me the problem is not with Cognos, but the malware detection generating a false positive. You are probably going to have to contact whoever makes their scanning software to see why it would be flagged as malware, then contact IBM to see what if anything you can do about it.

Since they are obviously not malware, the admins should be able to configure their servers such that these files would be allowed to pass when they are being sent by the Cognos server.