09-09-2015 11:48 AM - edited 03-01-2019 09:17 AM
I have setup a FTP job in Tidal but it keep failing. The error is "Illegal characters in path" I have double check all the path setting in the FTP job everything seems ok. Any ideas?
Solved! Go to Solution.
09-09-2015 11:59 AM
Hi adminvest,
Have you checked the filename itself to see if it contains any illegal characters?
If you need further assistance, then I suggest posting more details/screenshots of path or filename, but mask the login and server information if necessary.
BR,
Derrick Au
09-09-2015 12:35 PM
09-09-2015 11:59 AM
Hi adminvest,
Have you checked the filename itself to see if it contains any illegal characters?
If you need further assistance, then I suggest posting more details/screenshots of path or filename, but mask the login and server information if necessary.
BR,
Derrick Au
09-09-2015 12:24 PM
Hi Derrick,
I think I know what the problem is, I think there is illegal character on the source server. Is the percent sign allow? The file name is very long also.
File name:
%XXXXXXXXX%XXXXXXXXXXXXXXX%SFTP%POLLABLE%XXXXXXXXXXX
thanks
09-09-2015 12:35 PM
adminvest,
Right. Percent is an illegal character.
Cheers,
Derrick Au
09-14-2015 11:04 AM
Actually I am still having issue, we were able to change the file name in the source server and removed the % sign from the file name. We are still getting the same error message.
The new file name we are trying to get is:
WIRE.XXX20150914093444.csv
is there any problem with this file name?
09-14-2015 12:56 PM
Hi adminvest,
The filename appears to be correct, please check to see if there is no extra space after .csv and also look into the directory path for any illegal characters.
BR,
Derrick Au
09-15-2015 08:31 AM
Is "*" allow in the file name file?
09-15-2015 09:25 AM
adminvest,
* is also an illegal character. So what's actually a legal character, [a-z][A-Z][0-9] _ -
any characters outside of that is illegal in the ACTUAL filename or directory path :-)
But "*" is legal to represent a wild card when performing a search, or directory listing etc.
BR,
Derrick Au
09-15-2015 10:16 AM
09-15-2015 10:30 AM
Hi adminvest,
The filename = "*" should be fine, but instead of specifying local path as whack, whack network share \ server name followed by directory path, try specifying a local directory that of the agent (ie, using "C:\...")
BR,
Derrick Au
09-15-2015 10:33 AM
So we can't use "whack" in the local path? I think we have that in other FTP jobs and it works.
09-15-2015 10:38 AM
Hi adminvest,
It should work if your agent is running under a regular service account and not local system/service. Would you mind sending me the entire local path string? Just send it directly to my email address, derrick.au@mlp.com and I'll take a quick look.
Thanks,
Derrick Au
Millennium Management LLC
666 5th Avenue, New York, NY 10103
Tel: (212) 708-4671
email: derrick.au@mlp.com
millennium
09-15-2015 10:47 AM
"\\networkshare\dfs\groups\XXXXX\1A - Treasury\Test_folder"
09-15-2015 10:50 AM
Hi adminvest,
Path string looks okay. This time, just try it with a local directory on the agent/server.
BR,
Derrick Au
09-15-2015 11:44 AM
I changed to a local path c:\temp. In the audit log I see this error "Problem with spool file for job SFTP Test 1 - Get file." and I still get the error about illegal character.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide