File Iterator failure

Matillion ETL
,
1

I am trying to create a ETL to iterate the XML file using file_iterator. But I am getting this error

**Could not retrieve File Metadata: Algorithm negotiation fail: algorithmName=“server_host_key” jschProposal=“ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256” serverProposal=“ssh-rsa” after 0 iterations generated.
**
Can any one help to fix this?

2

Hi @jeberson

Welcome to the Matillion Forum, let me take this away and look into it for you, I will pop a answer as soon as I have one.

In the meantime, if you need anything else, please let me know.

Kind regards, Joe

3

Hello @jeberson

I spoke with our team, and it turns out that recent updates to Java have removed all the deprecated security algorithms.

We would recommend speaking with your security team at your end and looking into updating your remote machine to use stronger cryptography.

Please let me know if you need anything else.

Kind regards, Joe

4

@Joe-Community-Manager When I try to load single file in data transfer component it ran successfully. But when I try to iterate the same file through file iterator I am facing this issue. In data transfer component I will be using SFTP config as server_host_key=ssh-rsa.

5

Hello @jeberson

Data Transfer works because it has Source SFTP Config a property where you can set server_host_key=ssh-rsa.

The File Iterator doesn’t have that property, so there’s no way to override the deprecated algorithm.

File Iterator is missing the SFTP Configuration property that Data Transfer has, so that the algorithm override won’t work there. Options are:

  1. Best: Update SFTP server to modern algorithms (rsa-sha2-256, ecdsa-sha2-nistp256, ed25519)

  2. Workaround: Bash Script with sftp -o HostKeyAlgorithms=+ssh-rsa to list files → output to grid → Grid Iterator + Data Transfer (with SFTP Config set)

  3. Workaround: If filenames are predictable, skip File Iterator - use Fixed/Grid Iterator → Data Transfer

Here are some docs to support with this:

You could also raise as an idea for this to be added as standard here: https://roadmap.matillion.com

I hope that helps!

Joe