Tool Mastery | Python

[pmish23]

Hello, I am trying to use Python tool. I am on a free trial and my Alteryx version is 2019.1.4.57073

When i click on the Python tool, i get the below error

Is there something i am missing? Any leads would be really helpful.

Thanks,

Paresh

[afv2688]

Hi @pmish23 ,

Did you have already a jupyter version installed on your machine? It may be the problem.

Sometimes also the path gets to jupyter is messed up. You can either re-install manually the jupyter server application or check the pathing manually.

Cheers

[LarryR · Accepted solution]

That is an interesting error message..... it means CreateProcessW failed to spawn the JupyterSever but the WindowsAPI getLastError() returned 0 which means "Everything is ok".

I have a theory...Go to your temp directory. If you don't know where that is, start alteryx go Options->UserSettings->Edit User Settings. you should see this:

You can see I've changed mine to c:\Bugs\temp. Go to that directory and look for jupyter_server.log. If there is any text in there, post it here so we can see it. (Hopefully its got a really obvious "I died because of X" message in it) If that logfile is empty, or useless.... you will have to do the next step.

Since I'm not sure where you installed Alteryx I'm going to give you a command to run:

Open a command prompt.

cd  $(AlteryxDir)\bin\Plugins

jupyter.exe notebook --NotebookApp.port="8888" --config="..\Miniconda3\etyc\jupyter\jupyter_otebook_config.py" --notebook-dir="$(YourTempDir)""

for me on my test install $AlteryxDir = D:\Program Files\Alteryx  and $YourTempDir is the temp dir from the screen shot above
obviously things will be different for you.

You SHOULD see a jupyter notebook server start up. If it succeeds, please let us know. If it fails... cut and paste the entire contents of the command prompt to us so we can figure out what is going on. I have a feeling the process is spawning correctly, the command line above is attempting to run, it is erroring out, and the CreateProcess is reporting "I did my job.... the command line is finished running" and reports success. (Which, as a user, isn't great feedback)

I'll keep watching this thread and hopefully we can get you up and running.

[pmish23]

Hello there...it did work...I had to run your command script...Thanks a lot for the help!

[pmish23]

Hello,

while i was able to configure the python tool, i encountered the below error while running a workflow. I am basically trying to put the casv data from Alteryx to MicroStrategy

what may be wrong in here?

[LarryR]

I didn't give you a fix, I gave you the command to start the JupyterServer.

I wanted to understand why Alteryx couldn't seem to start it.

So now I don't know what is going on with your machine. It looks like you have some sort of path pollution.

I need you to post the contents of jupyter_sever.log and the results of the command I asked you to run in the cmd shell if I am going to be of any use.

[gunesmutlu]

Hi @LarryR,

I tried your solution. 

It's been sorted.

Many thanks.

[mmuni]

Hi Larry, I was also unsuccessful in attempting to post the data to MSTR from Alteryx. I couldnt make the command to work. Any info you need me to provide I can post