Data Source error "Remove file failed: PERMISSION_DENIED"

[sieusaopolo15]

Hi,

This morning, I received some log message like in the subject title. My data source is using SFTP for retrieving files and my properties in the data source is like this in the below image. I don't know what causes this error "java.io.IOException: Remove file failed: PERMISSION_DENIED: Permission denied ( scheduled import job: Data Load Daily Schedule )". When i removed the "remove_file=true" the data source runs perfectly, How can I fix this error without removing "remove_file=true" because I need it for the importation.

[Niklas Peterson]

Hi,

Start by ensuring that the SFTP user that you use to fetch the file from the source have access rights to remove the file.

Regards,
Niklas

[sieusaopolo15]

Hi @Niklas Peterson , I've checked the SFTP with the current account I set in Data Source. The permissions which I retrieved are like in the below attachments, the current file i need to remove only has read and write permissions. But in the parent folder I have execute, write, read, delete permissions. Is there any thing wrong here ?

Parent folder permission:

File permission:

[Niklas Peterson]

Hi,

Seems you only have permission set for the owner. Is the user owning the folder?

Can you make a test in a SFTP client to see if you are able to remove the file manually?

Regards,
Niklas

[sieusaopolo15 · Accepted solution]

Hi @Niklas Peterson , sorry for the late response. I just received some messages that the account SFTP which I am using does not have permissions on the file. When the account has been granted the delete permission everything has worked normally. I will mark this answer as solution also.
Thanks !