Error Message :
RA FTP jobs do not complete because reports are stuck in a Transferring status.
Within the Agent logs and job reports there are no noticeable errors (a communication to the server is made, there is a message that files transferred, and then there is a disconnection from the server), but the report holds up the job because it gets stuck transferring from the bin/temp directory to the database.
Root Cause: The database that the job report is being transferred to is full, so the jobs get stuck because the report cannot transfer.
If an immediate solution is needed, then the DBA needs to add more space to the database to allow the reports to transfer.
This can be proactively avoided by running maintenance on a regular basis so that the database does not fill up.
Fix Status: No Fix