This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Nicee. Just a word of warning, the python tool (read: this macro) has failure potential when used in macros.
This error occurs when the macro is called simultaneously by separate workflows. If there are 10 workflows with the macro that are scheduled to run at the same time, some may fail.
This is because Alteryx runs everything python through jupyter (even in production mode... yeah they kind of stretched the truth a little on that one) and jupyter locks certain files when it runs the code.
I haven't actually seen this error in my logs for a while but that may be because I moved most of my error reporting to airflow :/
I was looking for a solution to separate data based on user name and then send Excel files out to those users. The Excel file needed to be based on a template and the email need to be HTML. I was able to get that working by leveraging WillBowman's macro. I have attached it here in case someone is trying to do the same thing.
As far as i remember from my previous life as a developer this could be down to an application occupying that process. Focus on that last line of the error code and try to google some posts on stackoverflow. They are basically suggesting a few things to check.