Blank report is getting triggered in delivery | Community
Skip to main content
Level 4
November 3, 2023
Solved

Blank report is getting triggered in delivery

  • November 3, 2023
  • 2 replies
  • 975 views

Hi All,

 

I'm trying to send a CSV report attachment via delivery. It works fine for some days, and some days the report is getting triggered as a blank CSV file, even though my workflow has count. If I trigger it again, I'm getting a proper report. Why is this happening? Any solution to this issue would be appreciated. This is happening in Adobe campaign classic version 7 

 

Regards,

Sujith kumar

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Amine_Abedour

Hello @sujith_02kumar ,

 

If you are operating in a multi-server instance (with two or more wkserver), the issue may arise due to a discrepancy between the server where the file is generated and the server responsible for preparing the delivery. It's apparent that the second server cannot locate your CSV file, which results in the transmission of a blank file. The instances when it does work occur when your CSV file is generated on the same server responsible for preparing your delivery.

 

A viable solution for this situation is to ensure the generation of your CSV file to a shared storage folder, such as a Network Attached Storage (NAS), to ensure accessibility for all servers.

 

Best regards,

Amine

 

 

2 replies

Manoj_Kumar
Community Advisor
Community Advisor
November 4, 2023

Hello @sujith_02kumar 

 

Are you using the same way to share reports from multiple workflows?

 

If that is the case, then I assume you are using the same file name in all workflows, and they are overwriting the data. To fix this, make sure all workflows are using different file names.

Manoj  | https://themartech.pro
Level 4
November 4, 2023

Hi @_manoj_kumar_ ,

 

I'm using different file name but the recurring delivery which I'm using is copied from other workflow. I can't understand sometimes it works fine and sometimes I'm getting blank report even though my workflow has count 

Manoj_Kumar
Community Advisor
Community Advisor
November 4, 2023

Hello @sujith_02kumar 

 

Could you please show the code you are using to attach the file?

Manoj  | https://themartech.pro
Amine_Abedour
Community Advisor
Amine_AbedourCommunity AdvisorAccepted solution
Community Advisor
November 6, 2023

Hello @sujith_02kumar ,

 

If you are operating in a multi-server instance (with two or more wkserver), the issue may arise due to a discrepancy between the server where the file is generated and the server responsible for preparing the delivery. It's apparent that the second server cannot locate your CSV file, which results in the transmission of a blank file. The instances when it does work occur when your CSV file is generated on the same server responsible for preparing your delivery.

 

A viable solution for this situation is to ensure the generation of your CSV file to a shared storage folder, such as a Network Attached Storage (NAS), to ensure accessibility for all servers.

 

Best regards,

Amine

 

 

Amine ABEDOUR