Execution of original Python macros on Alteryx Server 2024.2

[T-Ishii]

I tried running a workflow that had been working on Alteryx Server 2023.2 on Alteryx Server 2024.2, but encountered the attached error.

This workflow uses a Python macro to upload files to Amazon S3, and it seems the error is occurring within that macro.

If you happen to know how to resolve this issue, I would greatly appreciate your guidance.

If any additional information is needed, please let me know.

[KGT]

This could be an issue with the tool needing to be re-installed. That depends on what that Python Macro is.

If it's a yxi install, then it will need to be re-installed on the new Alteryx Server, as the Python version changed in 2024.1 I believe. When a yxi tool is installed, it is "paired" to the version of Python in Alteryx, so when that version changes, the yxi tools need to be re-installed so that they "pair" with the new version. You will be able to download the correct version tool for your Alteryx Version.

If it's just a macro with a python tool in it, then looks like an issue with setting data_bytes on line 65...

Is this using Pandas? line_terminator changed to lineterminator (check that before using) in one of the versions I think, and so if Pandas (default install with Alteryx) has changed versions, that may explain it.

[OTrieger]

@T-Ishii 
It might be due to a python version, or the package version.

As per the error TypeError: NDFrame.to_csv() got an unexpected keyword argument 'line_terminator' occurs because the line_terminator parameter is not supported in the version of pandas you are using, or it is being used incorrectly. 

The line_terminator parameter was removed in newer versions of pandas (starting with pandas 2.0.0, released in April 2023). If you're using a version of pandas >= 2.0.0, the to_csv() method no longer accepts line_terminator as a valid argument, leading to this error. 

What might happened that the new server have a newer pandas version that kicking this error. If that is the case you will need to update the python code with the new syntax. Try to change line_terminator (with an underscore), correct it to lineterminator.

[apathetichell]

find out what version of python/pandas/alteryx is running on server. updates/downgrade version to the same locally. test your workflow. troubleshoot. fix. put back on server.

Any time you upgrade Server --- if the internal version of Python is changing -- you should perform migration tests on every single in production workflow which touches Python  prior to the upgrade. This is standard practice.

[dreldrel]

It may be the reason for the version of the Python tool. Try dropping the old Python tool and validating your code on the new Python tool. If this helps, please feel free to like the comment