How did you update the cryptography package?
Could you provide any workflow sample using the SFTP tools for downloader and uploaded.
Hi,
I installed the tool on Alteryx 2023.1 and I get this error:
Error: SFTP Downloader (1): Traceback (most recent call last):
File "main.py", line 416, in pi_push_all_records
File "main.py", line 226, in build_ayx_output
File "main.py", line 176, in _list_to_recordinfo
RuntimeError: Invalid field size: '12345678'; DateTime field size must be between 19 and 38.
I reinstalled Alteryx and It not worked.
Have you found a solution to this? I also see the same error message.
Thank you!
Hi,
It was the version of Alteryx. I downgraded and it fixed it.
Hello @chrisha ,
Just installed this tool in version 2022.1.1 and got the followinf error in my first use:
SFTP Downloader (2) Traceback (most recent call last):¶ File "main.py", line 5, in <module>¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\pysftp\__init__.py", line 12, in <module>¶ import paramiko¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\paramiko\__init__.py", line 22, in <module>¶ from paramiko.transport import (¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\paramiko\transport.py", line 33, in <module>¶ from cryptography.hazmat.primitives.ciphers import algorithms, Cipher, modes¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\hazmat\primitives\ciphers\__init__.py", line 11, in <module>¶ from cryptography.hazmat.primitives.ciphers.base import (¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\hazmat\primitives\ciphers\base.py", line 10, in <module>¶ from cryptography.exceptions import (¶ File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\exceptions.py", line 9, in <module>¶ from cryptography.hazmat.bindings._rust import exceptions as rust_exceptions¶ImportError: DLL load failed while importing _rust: The specified module could not be found.¶
I don't really know much python, but already pip installed cryptography and paramiko libs.
Is there anything else I should do?
Thanks since now.
Hi Christopher,
Also posted on GitHub under Issues.
After successfully installing the latest Pre-Release version of the tool to my installation of Alteryx Designer (2023.2.1.7) I received the same bug error.
So excited to see your post for the bug fix (below) by adding the PATH variables however, after adding first the System variables, which did not fix the issue, and then the User variables, neither fixed the issue.
I am still receiving the error below:
Error: SFTP Downloader (20): Traceback (most recent call last):
File "main.py", line 5, in <module>
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\pysftp\__init__.py", line 12, in <module>
import paramiko
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\paramiko\__init__.py", line 22, in <module>
from paramiko.transport import (
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\paramiko\transport.py", line 33, in <module>
from cryptography.hazmat.primitives.ciphers import algorithms, Cipher, modes
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\hazmat\primitives\ciphers\__init__.py", line 11, in <module>
from cryptography.hazmat.primitives.ciphers.base import (
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\hazmat\primitives\ciphers\base.py", line 10, in <module>
from cryptography.exceptions import (
File "C:\ProgramData\Alteryx\Tools\SKOPOS_SFTP_venv\Lib\site-packages\cryptography\exceptions.py", line 9, in <module>
from cryptography.hazmat.bindings._rust import exceptions as rust_exceptions
ImportError: DLL load failed while importing _rust: The specified module could not be found.
Please help as I am exhausting options to get my flow to upload to SFTP with SSH Key and was very excited to find your tool.
Look forward to your response.
Thanks.