Hopefully someone out there will be familiar with the issue I'm having and be able to provide a solution.
We are running Business Objects Enterprise 11.5 on our Windows 2003 server. I've created and scheduled a job on the server that creates an XLS file containing loan portfolio data that is to be transmitted to a third party client on a monthly basis.
The problem centers around the method of transfer, which is via FTP to a secure site hosted by the client. When executed through Crystal, the FTP actually does achieve a successful login using the credentials the client provided (we have verified this repeatedly by looking at the logs), but the client's server "kicks out" when we attempt any operation on it.
A similar result was produced when we attempted to FTP to the site via the Windows command line. The login was successful, but even a simple command to view the directory "dir" resulted in the connection being rejected. To make a long story short, after reviewing the issue extensively with the client's technical department, our conclusion was that the problem was the result of the FTP sending in "active" mode instead of "passive". We confirmed this by installing a freeware FileZilla on the same server, and switching between active and passive modes (active failed, passive did not).
Their tech people recommended that we contact SAP to get answers to two questions, which I'm hoping someone out there may know:
1) How does Business Objects Enterprise 11.5 execute the FTP process? Is it using its own native logic or simply invoking the command line?
2) Is there any setting with the console that would enable us to modify the FTP settings to send force it to send in passive mode?