How does Alteryx manage its python environment and the installation of python packages? As can be seen in the code below. Alteryx is failing to install the Python 'pandas-datareader' package even when ran with 'administrator' privileges. Is this a bug? What can be done to run this workflow (see attached)?
Start: Designer x64: Started running I:\USER\FOLDER\Python Stock Data Workflow.yxmd at 10/24/2018 03:30:39 Info: Directory (22): 9 records were generated Error: Python (8): [NbConvertApp] Converting notebook C:\ProgramData\Alteryx\Engine\ffd59710-d5de-48aa-8a5b-c60b4398785e\8\workbook.ipynb to html [NbConvertApp] Executing notebook with kernel: python3 [NbConvertApp] ERROR | Error while converting 'C:\ProgramData\Alteryx\Engine\ffd59710-d5de-48aa-8a5b-c60b4398785e\8\workbook.ipynb' Traceback (most recent call last): File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\nbconvertapp.py", line 393, in export_single_notebook output, resources = self.exporter.from_filename(notebook_filename, resources=resources) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\exporter.py", line 174, in from_filename return self.from_file(f, resources=resources, **kw) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\exporter.py", line 192, in from_file return self.from_notebook_node(nbformat.read(file_stream, as_version=4), resources=resources, **kw) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\html.py", line 85, in from_notebook_node return super(HTMLExporter, self).from_notebook_node(nb, resources, **kw) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\templateexporter.py", line 280, in from_notebook_node nb_copy, resources = super(TemplateExporter, self).from_notebook_node(nb, resources, **kw) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\exporter.py", line 134, in from_notebook_node nb_copy, resources = self._preprocess(nb_copy, resources) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\exporters\exporter.py", line 311, in _preprocess nbc, resc = preprocessor(nbc, resc) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\preprocessors\base.py", line 47, in __call__ return self.preprocess(nb, resources) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\preprocessors\execute.py", line 262, in preprocess nb, resources = super(ExecutePreprocessor, self).preprocess(nb, resources) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\preprocessors\base.py", line 69, in preprocess nb.cells[index], resources = self.preprocess_cell(cell, resources, index) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\nbconvert\preprocessors\execute.py", line 286, in preprocess_cell raise CellExecutionError.from_cell_and_msg(cell, out) nbconvert.preprocessors.execute.CellExecutionError: An error occurred while executing the following cell: ------------------ Alteryx.installPackages('pandas-datareader') ------------------ --------------------------------------------------------------------------- CalledProcessError Traceback (most recent call last) <ipython-input-2-f36396f45a97> in <module>() ----> 1 Alteryx.installPackages('pandas-datareader') c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\ayx\export.py in installPackage(package, *args, **kwargs) 33 This function will install a package or list of packages into the virtual environment used by the Python tool. If using an admin installation of Alteryx, you must run Alteryx as administrator in order to use this function and install packages. 34 ''' ---> 35 __installPackages__(package, *args, **kwargs) 36 37 # these are the same function. c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages\ayx\Package.py in installPackages(package, install_type) 64 result = subprocess.check_output( 65 [sys.executable, "-m", "pip"] + pip_args_list, ---> 66 stderr = subprocess.STDOUT 67 ) 68 # print the output C:\Program Files\Alteryx\bin\Miniconda3\lib\subprocess.py in check_output(timeout, *popenargs, **kwargs) 334 335 return run(*popenargs, stdout=PIPE, timeout=timeout, check=True, --> 336 **kwargs).stdout 337 338 C:\Program Files\Alteryx\bin\Miniconda3\lib\subprocess.py in run(input, timeout, check, *popenargs, **kwargs) 416 if check and retcode: 417 raise CalledProcessError(retcode, process.args, --> 418 output=stdout, stderr=stderr) 419 return CompletedProcess(process.args, retcode, stdout, stderr) 420 CalledProcessError: Command '['c:\\program files\\alteryx\\bin\\miniconda3\\pythontool_venv\\scripts\\python.exe', '-m', 'pip', 'install', 'pandas-datareader']' returned non-zero exit status 1. CalledProcessError: Command '['c:\\program files\\alteryx\\bin\\miniconda3\\pythontool_venv\\scripts\\python.exe', '-m', 'pip', 'install', 'pandas-datareader']' returned non-zero exit status 1. End: Designer x64: Finished running Python Stock Data Workflow.yxmd in 8.4 seconds with 1 erro
Solved! Go to Solution.
Hi @pimp_fada - it looks like the package was successfully installed in your %APPDATA% directory, which would make sense if you are running a non-admin version of the Designer. Did it require you to install it again?
From the error messages in your above post, it is trying to now install it in %PROGRAMFILES%, which would suggest it was ran using an Admin version of the Designer, which would require you to run the Designer with Admin privileges.
Hi @SophiaF, I installed the version generated when I downloaded from the official website. If there are two version as you state (Admin and non-admin), why are users not alerted during downloads as nothing of this sort is stated when one tries to download the program? Especially when the choice of version matters.
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |