Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline AdamW  
#1 Posted : Friday, November 8, 2019 1:21:39 AM(UTC)
AdamW

Rank: Paid support

Joined: 8/6/2019(UTC)
Posts: 5
Australia
Location: Australian Capital Territory, Canberra

I am trying to send xlsx attachments through an exchange server and whenever I receive the message the exchange server has stripped out the xlsx file and replaced it with a txt file with contents "This attachment was removed.". I have tried both SMTP and OWA connection methods.

One would blame the exchange server for doing this, however I can send the exact same xlsx file through Outlook and through a competitors automation software without the file being stripped out like this. Therefore I think it has to do with VisualCron not formatting the email correctly, perhaps with correct MIME types on the email attachment.

Has anyone seen this issue before?
Offline Support  
#2 Posted : Friday, November 8, 2019 1:55:35 PM(UTC)
Support

Rank: Official support

Joined: 12/1/2015(UTC)
Posts: 217

Thanks: 24 times
Was thanked: 12 time(s) in 11 post(s)
Originally Posted by: AdamW Go to Quoted Post
I am trying to send xlsx attachments through an exchange server and whenever I receive the message the exchange server has stripped out the xlsx file and replaced it with a txt file with contents "This attachment was removed.". I have tried both SMTP and OWA connection methods.

One would blame the exchange server for doing this, however I can send the exact same xlsx file through Outlook and through a competitors automation software without the file being stripped out like this. Therefore I think it has to do with VisualCron not formatting the email correctly, perhaps with correct MIME types on the email attachment.

Has anyone seen this issue before?


Hi Adam,

Which version is this on? I can not seem to reproduce this issue.
Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!
Offline Joey S  
#3 Posted : Friday, November 8, 2019 5:30:08 PM(UTC)
Joey S

Rank: Paid support

Joined: 3/26/2018(UTC)
Posts: 27
United States
Location: North Dakota, Grand Forks

Was thanked: 9 time(s) in 8 post(s)
Can you send any attachments in this job? I would try to attach a sample text message that is blank. If that gets removed too then it has to be exchange or maybe some security device or software that looks for attachments. Where the server is or how it interacts with exchange may be different than your other software you tried
thanks 1 user thanked Joey S for this useful post.
Support on 11/11/2019(UTC)
Offline Support  
#4 Posted : Monday, November 11, 2019 11:59:01 AM(UTC)
Support

Rank: Official support

Joined: 12/1/2015(UTC)
Posts: 217

Thanks: 24 times
Was thanked: 12 time(s) in 11 post(s)
I second Joey S's suggestion. Please try that, and let us know the result.
Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!
Offline AdamW  
#5 Posted : Monday, November 11, 2019 10:18:22 PM(UTC)
AdamW

Rank: Paid support

Joined: 8/6/2019(UTC)
Posts: 5
Australia
Location: Australian Capital Territory, Canberra

Hi,
I am using VisualCron 8.5.5

I have done some further troubleshooting and have worked out that it does not seem to be an email send issue, it seems to be an issue with the way VisualCron generates Excel files.

The job which has the issue runs a query from a database and populates an excel file with a number of worksheets. It then sends this excel file as an attachment.

I set up a test job which sends both a VisualCron generated excel file and a file saved from Excel 2016. The VisualCron Excel file gets removed whilst the other Excel saved from Excel stays intact. So it seems the issue is related to how VisualCron is generating the Excel files which is leading to Exchange thinking they are corrupt somehow.

Attached is both Excel files for your reference.

VisualCronExcel.xlsx (3kb) downloaded 2 time(s). ExcelFromExcel2016.xlsx (8kb) downloaded 1 time(s).

Thanks
Adam.

Edited by user Monday, November 11, 2019 10:19:58 PM(UTC)  | Reason: Not specified

Offline Joey S  
#6 Posted : Monday, November 11, 2019 10:36:26 PM(UTC)
Joey S

Rank: Paid support

Joined: 3/26/2018(UTC)
Posts: 27
United States
Location: North Dakota, Grand Forks

Was thanked: 9 time(s) in 8 post(s)
Your file seemed to open fine for me so I am not sure what your system is seeing to disallow.

I had a few SQL jobs setup already so I added an "Excel - Create" task and and an email task and tested a scenario on my own end.

I used the default settings for "Column" and you can see, in my attachments the other settings I have. I did not do anything out of the ordinary and the excel and email tasks worked as expected. I bet your IT department has a way to see what, in that file, is causing the error when it hits your exchange server.

vc.support1.jpgvc.support3.jpgvc.support2.jpg
Offline AdamW  
#7 Posted : Monday, November 11, 2019 10:57:17 PM(UTC)
AdamW

Rank: Paid support

Joined: 8/6/2019(UTC)
Posts: 5
Australia
Location: Australian Capital Territory, Canberra

Hi Joey,
Thanks for checking this. Yes, thats exactly how I am generating the excel file too.

Our Exchange server team have looked at the issue and the only suggestion from Microsoft is to switch off the "Attachment filtering agent" which blocks invalid attachments, but they arent willing to do this for obvious reasons.

Thanks
Adam.
Offline Joey S  
#8 Posted : Monday, November 11, 2019 11:04:56 PM(UTC)
Joey S

Rank: Paid support

Joined: 3/26/2018(UTC)
Posts: 27
United States
Location: North Dakota, Grand Forks

Was thanked: 9 time(s) in 8 post(s)
I wonder if this would help...https://support.microsoft.com/en-us/help/2855809/email-message-attachments-are-removed-incorrectly-on-an-exchange-serve

Also, If I was you I would just send the file without an extension (or maybe substitute 'xlsx' with 'csv') . If that passes then you have some ammunition, so to speak, when going back to the exchange administrator.
Offline AdamW  
#9 Posted : Monday, November 11, 2019 11:14:53 PM(UTC)
AdamW

Rank: Paid support

Joined: 8/6/2019(UTC)
Posts: 5
Australia
Location: Australian Capital Territory, Canberra

Hi Joey,
If you read the suggestion on this URL, it is suggesting to disable the attachment filtering completely. This means potentially dangerous attachments will not be blocked anymore. We cannot disable this as suggested.

There is no point checking other file extensions when an xlsx file saved from Excel passes through fine, but a VisualCron generated xlsx file get blocked. Also, this Excel has to be sent as a proper excel file attachment as we have customers who receive these emails. We cannot ask them to change file extensions etc - that is unprofessional.

Theres only 2 solutions to this problem - either VisualCron find and fix the issue or I use another app to generate the Excel file with my data so Exchange server doesnt think the excel attachment is corrupt. I will have to use the latter for the time being in any case.

Thanks
Adam.
Offline Support  
#10 Posted : Tuesday, November 12, 2019 4:24:35 PM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,203

Thanks: 871 times
Was thanked: 446 time(s) in 424 post(s)
Originally Posted by: AdamW Go to Quoted Post
Hi Joey,
If you read the suggestion on this URL, it is suggesting to disable the attachment filtering completely. This means potentially dangerous attachments will not be blocked anymore. We cannot disable this as suggested.

There is no point checking other file extensions when an xlsx file saved from Excel passes through fine, but a VisualCron generated xlsx file get blocked. Also, this Excel has to be sent as a proper excel file attachment as we have customers who receive these emails. We cannot ask them to change file extensions etc - that is unprofessional.

Theres only 2 solutions to this problem - either VisualCron find and fix the issue or I use another app to generate the Excel file with my data so Exchange server doesnt think the excel attachment is corrupt. I will have to use the latter for the time being in any case.

Thanks
Adam.


I am not sure what you mean there is to fix. The Excel file is not corrupt. This is the Email server rules blocking in this case.
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Offline AdamW  
#11 Posted : Tuesday, November 12, 2019 11:28:39 PM(UTC)
AdamW

Rank: Paid support

Joined: 8/6/2019(UTC)
Posts: 5
Australia
Location: Australian Capital Territory, Canberra

Hi Henrik,
If its the email server rules, then why is it possible that an xlsx file saved from Excel or SSRS is able to be sent and received successfully, but a VisualCron generated xlsx file is treated as "invalid"?

What I have now done to work around the issue is generate a xls file from VisualCron and add a command line step which executes excelcnv.exe which will convert the xls file to xlsx format before its sent via email.

Thanks
Adam.
Offline Support  
#12 Posted : Wednesday, November 13, 2019 10:40:35 AM(UTC)
Support

Rank: Official support

Joined: 2/23/2008(UTC)
Posts: 11,203

Thanks: 871 times
Was thanked: 446 time(s) in 424 post(s)
Originally Posted by: AdamW Go to Quoted Post
Hi Henrik,
If its the email server rules, then why is it possible that an xlsx file saved from Excel or SSRS is able to be sent and received successfully, but a VisualCron generated xlsx file is treated as "invalid"?

What I have now done to work around the issue is generate a xls file from VisualCron and add a command line step which executes excelcnv.exe which will convert the xls file to xlsx format before its sent via email.

Thanks
Adam.


I guess it could be a number of values that finally decides it is spam - maybe it is a combined score with sender ip, sender email, recipient email, subject and actual content in the file. We have not created our own Excel engine for creating but are using a well known engine so I doubt there is anything wrong with that.
Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!
Users browsing this topic
Guest (2)
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top