Alteryx can't install a python package on some PCs even when run as an administrator?

Question

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 bconvert bconvertapp.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 bconvert\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 bconvert\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 bconvert\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 bconvert\exporters emplateexporter.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 bconvert\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 bconvert\exporters\exporter.py", line 311, in _preprocess nbc, resc = preprocessor(nbc, resc) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages bconvert\preprocessors\base.py", line 47, in __call__ return self.preprocess(nb, resources) File "c:\program files\alteryx\bin\miniconda3\pythontool_venv\lib\site-packages bconvert\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 bconvert\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 bconvert\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) in () ----> 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 dummy_workflow.yxmd

SophiaF · Accepted Answer

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.