• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1384
  • Last Modified:

Report Scheduled from Central Management Console to FTP Site Delivers File with Zero Bytes - No Data

Hello Experts,

I have scheduled a report to a FTP site destination, and formatted it to arrive in a CSV format, but when it arrives at the destination site, the file has zero bytes and zero data.  I can deliver the same file in CSV format to a local folder (destination: unmanaged disc), with the data, and I can also from the Crystal Enterprise server using a local FTP client, upload a csv file with data.

Do you know what would cause the Crystal Enterprise Server to deliver empty files to a remote FTP site?

Thank you for your help with this.
~Chopp
0
Chopp
Asked:
Chopp
4 Solutions
 
linuxoCommented:
Hi,

Check READ,WRITE permission on both..

Thank you.

0
 
David11NormanCommented:
Also check that CES is using the account you want it to when logging into FTP server. It could be different than the account you used when testing locally (assuming you tested locally)
0
 
ChoppAuthor Commented:
The permissions are correct.  The account is correct.  Here is one more piece of info: the error message with the failure of the scheduled report is:       Error Message: connection error. CrystalEnterprise.Ftp: WSA0

Any other ideas?

Thank you very much for any advice.
~Chopp

Do you know what would cause the Crystal Enterprise Server to deliver empty files to a remote FTP site?

0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
moorhouselondonCommented:
Checking the logs on the FTP server would tell you where the problem lies.  Have you checked the Port is the same when carrying out the substitute tests?
0
 
ChoppAuthor Commented:
Thank you for that idea, unfortunately I don't have access to the FTP logs - it is not my FTP server.  I will send a request to the FTP destination people asking what port number I should use.  If anyone has any additional ideas, I will be interested.

Thanks again.
~Chopp
0
 
moorhouselondonCommented:
The final link in the chain as far as diagnostic tests you could perform is to test FTP end-to-end by setting up a local FTP server using Filezilla and seeing whether that works.  
0
 
ChoppAuthor Commented:
Thank you for your help.
~Chopp
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now