Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do I change the diretory on FTPConnection to AS400

I have an FTP connection to an AS400, when I try to use the tFTPPut component I receive the following error:

The system cannot find the path specified.
Exception in component tFTPPut_1 (Unemployment_File)
com.enterprisedt.net.ftp.FTPException: 501 Specified object name too long, limit is 10 characters:

 

The AS400 adminstrator gave me a couple of suggestions:

cd /xxxx/xxxx/xxxx

or 

use "IFS or File System" as a directory
on DOS you would do this by issuing FTP command NAMEFMT 1
 
How do I do this in Talend 6.4?
Labels (2)
6 Replies
Anonymous
Not applicable
Author

Hi,

 

   As the error suggests the issue is because of the length of the file name is grater than 10 characters. Did you rename your file to AS400 format while transferring the file?

 

   Screenshots of the Job and the tFTPPut component will helpful to identify the root cause quickly.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous
Not applicable
Author

It is not the length of the file name that is causing the issue, it is the directory name per our AS400 DBA. The tFTP out is trying to go to a library - I need it to go to a file directory.

 

0683p000009M5X3.png

 

0683p000009M5er.png0683p000009M5ew.png

Anonymous
Not applicable
Author

Hi,

 

   If its the remote directory problem, you will have to print the output of the context variable NA_PWEB_File_Loc and see whether it is having right value. Could you please check the value in the New name area of the tFTPPut.

0683p000009M5f1.png

 

I have not personally worked in AS400 till now. But my understanding is that it will not take regular file names. So could you please print the value of file name you are trying to give in target area and see whether it is according to AS400 standards.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous
Not applicable
Author

The file directory is correct, the issue is that the ftp connection is not
recognizing it as a directory but as a library (library can only be 10
characters). I need to know how to tell the connection it is a file system
and not a library.
Anonymous
Not applicable
Author

@rhaley 

 

I am not pretty sure about how to manage FTP properties for AS400 systems. Lets check it with @xdshi 

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous
Not applicable
Author

I changed the format of the directory and it is putting the files in the FTP directory now but it throws a 550 access denied error even though it is putting the files in the diretory.