FTP Destination - @ character in password
As per Reports 11g documentation we are trying to send Reports output to an FTP server
desformat=PDF&destype=FTP&desname=ftp://user:pwd@ftpServer/dir/report.pdf
However, the password for the FTP user contains the @ character (example p@ssword), so Reports complains that it cannot connect to ssword@ftpServer
Error message:
REP:62350 .. failed with error URL java.net. UnknownHostException: ssword@ftpServer is invalid
I have tried replacing the @ with %40 but the result is the same.
For now, I don't want to change the password, as there is an impact analysis to perform - but I realize that is an option.