FTP Job failed: Illegal characters in path

[adminvest]

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?

[Derrick Au · Accepted solution]

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

[adminvest]

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

[Derrick Au · Accepted solution]

adminvest,

Right. Percent is an illegal character.

Cheers,

Derrick Au

[adminvest]

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?

[Derrick Au]

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

[adminvest]

Is "*" allow in the file name file?

[Derrick Au]

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

[adminvest]

I have the * as a wildcard for file name. See attached image.

[Derrick Au]

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

[adminvest]

So we can't use "whack" in the local path? I think we have that in other FTP jobs and it works.

[Derrick Au]

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 5^th Avenue, New York, NY 10103

Tel: (212) 708-4671
email: derrick.au@mlp.com

millennium

[adminvest]

"\\networkshare\dfs\groups\XXXXX\1A - Treasury\Test_folder"

[Derrick Au]

Hi adminvest,

Path string looks okay. This time, just try it with a local directory on the agent/server.

BR,

Derrick Au

[adminvest]

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.