Expand my Community achievements bar.

SOLVED

blank file getting attach in email delivery

Avatar

Level 2

Hi Team,

 

In one scenario, we are exporting the transition data in the CSV file on the server & attaching the same file in the email delivery for reporting purposes. But sometimes we are getting blank CSV files. the exported file has data present on the server. Can you please help me with this?

 

Below is the screenshot of the workflow.

amits36558199_0-1610703477147.png

 

Also, attaching the path where we are exporting the CSV file.

/user/local/neolane/nl6/var/<instance name>/export/report.csv

 

Regards,

Amit

1 Accepted Solution

Avatar

Correct answer by
Level 2

Yes, we had to fix the file name being generated. Add the path with static file name in the attachment and in the advanced tab select script to rename the file as needed.

View solution in original post

6 Replies

Avatar

Employee Advisor

Hi Amit,

 

Can you check the last modified date on the CSV file and when the email was originally prepared?  It's possible that if the delivery preparation kicked off while the CSV was still being written to that it wasn't able to attach the data.

 

Can you also let us know if there is any consistency with the size of the files that get attached successfully versus those that show up blank?  It might be that the file size is too large.

 

Regards,

Craig

Avatar

Level 2

Hi Craig,

 

Thanks for your reply. I have checked the last modified for CSV on the server & email preparation date. Email preparation date is greater than CSV last modified date by 30 Sec. 

 

Also, the size of the file is below 100KB.

 

Thanks,

Amit

Avatar

Administrator
Hi @Craig_Thonis, Can you look into this further to help @amits36558199? Thanks!


Sukrity Wadhwa

Avatar

Level 2

@Craig_Thonis  @Sukrity_Wadhwa Is this resolved?? We are facing the same issue. 

 

We even added a wait of 5 minutes before preparing the delivery to ensure the files are prepared but even that does not seem to work.

The logs shows the size of the file correctly but the email comes with a blank file.

 

sauravp_0-1644401790921.png

 

Thank you

Saurav

Avatar

Level 1

@sauravp @amits36558199 @Sukrity_Wadhwa 

 

Were you able to find out the solution for this?

 

Thanks!

Avatar

Correct answer by
Level 2

Yes, we had to fix the file name being generated. Add the path with static file name in the attachment and in the advanced tab select script to rename the file as needed.