blank file getting attach in email delivery

[amits36558199]

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.

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

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

Regards,

Amit

[Craig_Thonis]

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

[amits36558199]

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

[Sukrity_Wadhwa]

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

[sauravp]

@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.

Thank you

Saurav

[Garg_121]

@sauravp @amits36558199 @Sukrity_Wadhwa 

Were you able to find out the solution for this?

Thanks!

[sauravp · Accepted solution]

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.