nabeel-oz / qlik-py-tools

Data Science algorithms for Qlik implemented as a Python Server Side Extension (SSE).
https://nabeel-oz.github.io/qlik-py-tools/
MIT License
186 stars 87 forks source link

Python service not starting #117

Open gabrielboehme opened 4 years ago

gabrielboehme commented 4 years ago

Describe the bug Qlik-Py-Init runs perfectly with no errors... then when running Qlik-Py-Start with admin rights, with CLI open, it takes a few secs to display "Press any key to continue..." and no other text. It seems that the python it's not executed or totally passed by, and this "Press any key to continue..." comes from the PAUSE in the .bat file.

Screenshots image

Environment:

OS Windows Server 2012 R2 Standard Qlik Sense Enterprise SSE Version: 8.1, 7.1 & 6.2 Python version: 3.6.8

Additional context Checked the firewall for the Qlik Pytools rule, it was created for port 50055; I also manually deleted and added the rule and tried to run Qlik-Py-Start... no luck. I also restarted the engine service, no luck.

gabrielboehme commented 4 years ago

image

nabeel-oz commented 4 years ago

Hi @gabrielboehme , you seem to be navigating to the wrong location for __main__.py in that screenshot. The location should be ..\qlik-py-tools-8.1\qlik-py-env\core. Also, when you use Qlik-Py-Start try to run it without admin rights.

If that doesn't help, can you please delete the qlik-py-env folder and run the initialization script again for v.8.1? Then take screenshots from the Qlik-Py-Init log and post them here. Maybe something is being skipped without producing an obvious error.

Cheers, Nabeel

gabrielboehme commented 4 years ago

Hello @nabeel-oz ! Thanks for the response... Now I executed in the the right path... But still no success... image

The init logs: qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from fbprophet==0.4.post2) (1.1 7.5) Requirement already satisfied: pytz>=2014.10 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from convertdate>=2.1.2->fbprop het==0.4.post2) (2020.4) Processing c:\users\qlik_desenv\appdata\local\pip\cache\wheels\e9\c3\07\d32faf16 682e2cd245be46e4c54053c8c82fa9762f4a4bcc63\pymeeus-0.3.7-py3-none-any.whl Requirement already satisfied: python-dateutil>=2.6.1 in c:\sse python\qlik-py-t ools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from pandas>=0.20.1->f bprophet==0.4.post2) (2.8.1) Collecting pillow>=6.2.0 Using cached Pillow-8.0.1-cp36-cp36m-win_amd64.whl (2.1 MB) Collecting pyparsing!=2.0.4,!=2.1.2,!=2.1.6,>=2.0.3 Using cached pyparsing-2.4.7-py2.py3-none-any.whl (67 kB) Collecting kiwisolver>=1.0.1 Using cached kiwisolver-1.3.1-cp36-cp36m-win_amd64.whl (51 kB) Collecting cycler>=0.10 Using cached cycler-0.10.0-py2.py3-none-any.whl (6.5 kB) Collecting certifi>=2020.06.20 Using cached certifi-2020.6.20-py2.py3-none-any.whl (156 kB) Requirement already satisfied: six in c:\sse python\qlik-py-tools-8.1\qlik-py-to ols-8.1\qlik-py-env\lib\site-packages (from holidays>=0.9.5->fbprophet==0.4.post 2) (1.15.0) Installing collected packages: lunardate, pymeeus, convertdate, pillow, pyparsin g, kiwisolver, cycler, certifi, matplotlib, setuptools-git, fbprophet Successfully installed certifi-2020.6.20 convertdate-2.2.2 cycler-0.10.0 fbproph et-0.4.post2 kiwisolver-1.3.1 lunardate-0.2.0 matplotlib-3.3.2 pillow-8.0.1 pyme eus-0.3.7 pyparsing-2.4.7 setuptools-git-1.2 Collecting scikit-learn==0.23.1 Using cached scikit_learn-0.23.1-cp36-cp36m-win_amd64.whl (6.8 MB) Requirement already satisfied: numpy>=1.13.3 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from scikit-learn==0.23.1) (1.1 7.5) Requirement already satisfied: joblib>=0.11 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from scikit-learn==0.23.1) (0.11 ) Requirement already satisfied: scipy>=0.19.1 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from scikit-learn==0.23.1) (1.4 .1) Collecting threadpoolctl>=2.0.0 Using cached threadpoolctl-2.1.0-py3-none-any.whl (12 kB) Installing collected packages: threadpoolctl, scikit-learn Successfully installed scikit-learn-0.23.1 threadpoolctl-2.1.0 Processing c:\users\qlik_desenv\appdata\local\pip\cache\wheels\36\20\d1\521b2fbf 637de5bc40668b6445944e7e44bfbe68fdaa65157d\hdbscan-0.8.26-cp36-cp36m-win_amd64.w hl Requirement already satisfied: joblib in c:\sse python\qlik-py-tools-8.1\qlik-py -tools-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (0.11) Requirement already satisfied: numpy>=1.16.0 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (1.17.5) Requirement already satisfied: six in c:\sse python\qlik-py-tools-8.1\qlik-py-to ols-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (1.15.0) Requirement already satisfied: scipy>=0.9 in c:\sse python\qlik-py-tools-8.1\qli k-py-tools-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (1.4.1) Requirement already satisfied: scikit-learn>=0.17 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (0.2 3.1) Requirement already satisfied: cython>=0.27 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from hdbscan==0.8.26) (0.29.14) Requirement already satisfied: threadpoolctl>=2.0.0 in c:\sse python\qlik-py-too ls-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from scikit-learn>=0.17-

hdbscan==0.8.26) (2.1.0) Installing collected packages: hdbscan Successfully installed hdbscan-0.8.26 Collecting spacy==2.2.4 Using cached spacy-2.2.4-cp36-cp36m-win_amd64.whl (9.9 MB) Collecting thinc==7.4.0 Using cached thinc-7.4.0-cp36-cp36m-win_amd64.whl (2.1 MB) Collecting blis<0.5.0,>=0.4.0 Using cached blis-0.4.1-cp36-cp36m-win_amd64.whl (5.0 MB) Collecting srsly<1.1.0,>=1.0.2 Using cached srsly-1.0.3-cp36-cp36m-win_amd64.whl (286 kB) Collecting cymem<2.1.0,>=2.0.2 Using cached cymem-2.0.4-cp36-cp36m-win_amd64.whl (35 kB) Requirement already satisfied: setuptools in c:\sse python\qlik-py-tools-8.1\qli k-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy==2.2.4) (50.3.2) Collecting wasabi<1.1.0,>=0.4.0 Using cached wasabi-0.8.0-py3-none-any.whl (23 kB) Collecting murmurhash<1.1.0,>=0.28.0 Using cached murmurhash-1.0.4-cp36-cp36m-win_amd64.whl (20 kB) Collecting catalogue<1.1.0,>=0.0.7 Using cached catalogue-1.0.0-py2.py3-none-any.whl (7.7 kB) Collecting tqdm<5.0.0,>=4.38.0 Using cached tqdm-4.51.0-py2.py3-none-any.whl (70 kB) Requirement already satisfied: numpy>=1.15.0 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy==2.2.4) (1.17.5) Collecting preshed<3.1.0,>=3.0.2 Using cached preshed-3.0.3-cp36-cp36m-win_amd64.whl (109 kB) Collecting plac<1.2.0,>=0.9.6 Using cached plac-1.1.3-py2.py3-none-any.whl (20 kB) Collecting requests<3.0.0,>=2.13.0 Using cached requests-2.24.0-py2.py3-none-any.whl (61 kB) Collecting importlib-metadata>=0.20; python_version < "3.8" Using cached importlib_metadata-2.0.0-py2.py3-none-any.whl (31 kB) Collecting idna<3,>=2.5 Using cached idna-2.10-py2.py3-none-any.whl (58 kB) Requirement already satisfied: certifi>=2017.4.17 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from requests<3.0.0,>=2.13 .0->spacy==2.2.4) (2020.6.20) Collecting urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 Using cached urllib3-1.25.11-py2.py3-none-any.whl (127 kB) Collecting chardet<4,>=3.0.2 Using cached chardet-3.0.4-py2.py3-none-any.whl (133 kB) Collecting zipp>=0.5 Using cached zipp-3.4.0-py3-none-any.whl (5.2 kB) Installing collected packages: blis, wasabi, cymem, murmurhash, srsly, zipp, imp ortlib-metadata, catalogue, preshed, plac, tqdm, thinc, idna, urllib3, chardet, requests, spacy Successfully installed blis-0.4.1 catalogue-1.0.0 chardet-3.0.4 cymem-2.0.4 idna -2.10 importlib-metadata-2.0.0 murmurhash-1.0.4 plac-1.1.3 preshed-3.0.3 request s-2.24.0 spacy-2.2.4 srsly-1.0.3 thinc-7.4.0 tqdm-4.51.0 urllib3-1.25.11 wasabi- 0.8.0 zipp-3.4.0 Collecting efficient_apriori==1.0.0 Using cached efficient_apriori-1.0.0-py3-none-any.whl (13 kB) Installing collected packages: efficient-apriori Successfully installed efficient-apriori-1.0.0 Collecting tensorflow==1.14.0 Using cached tensorflow-1.14.0-cp36-cp36m-win_amd64.whl (68.3 MB) Requirement already satisfied: wheel>=0.26 in c:\sse python\qlik-py-tools-8.1\ql ik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorflow==1.14.0) (0.34.2)

Processing c:\users\qlik_desenv\appdata\local\pip\cache\wheels\93\2a\eb\e58dbcbc 963549ee4f065ff80a59f274cc7210b6eab962acdc\termcolor-1.1.0-py3-none-any.whl Requirement already satisfied: grpcio>=1.8.6 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorflow==1.14.0) (1.26. 0) Requirement already satisfied: six>=1.10.0 in c:\sse python\qlik-py-tools-8.1\ql ik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorflow==1.14.0) (1.15.0)

Collecting tensorboard<1.15.0,>=1.14.0 Using cached tensorboard-1.14.0-py3-none-any.whl (3.1 MB) Processing c:\users\qlik_desenv\appdata\local\pip\cache\wheels\32\42\7f\23cae9ff 6ef66798d00dc5d659088e57dbba01566f6c60db63\wrapt-1.12.1-py3-none-any.whl Collecting gast>=0.2.0 Using cached gast-0.4.0-py3-none-any.whl (9.8 kB) Collecting google-pasta>=0.1.6 Using cached google_pasta-0.2.0-py3-none-any.whl (57 kB) Requirement already satisfied: protobuf>=3.6.1 in c:\sse python\qlik-py-tools-8. 1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorflow==1.14.0) (3.1 3.0) Requirement already satisfied: numpy<2.0,>=1.14.5 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorflow==1.14.0) ( 1.17.5) Collecting keras-preprocessing>=1.0.5 Using cached Keras_Preprocessing-1.1.2-py2.py3-none-any.whl (42 kB) Collecting keras-applications>=1.0.6 Using cached Keras_Applications-1.0.8-py3-none-any.whl (50 kB) Collecting astor>=0.6.0 Using cached astor-0.8.1-py2.py3-none-any.whl (27 kB) Collecting absl-py>=0.7.0 Using cached absl_py-0.11.0-py3-none-any.whl (127 kB) Collecting tensorflow-estimator<1.15.0rc0,>=1.14.0rc0 Using cached tensorflow_estimator-1.14.0-py2.py3-none-any.whl (488 kB) Requirement already satisfied: setuptools>=41.0.0 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from tensorboard<1.15.0,>= 1.14.0->tensorflow==1.14.0) (50.3.2) Collecting markdown>=2.6.8 Using cached Markdown-3.3.3-py3-none-any.whl (96 kB) Collecting werkzeug>=0.11.15 Using cached Werkzeug-1.0.1-py2.py3-none-any.whl (298 kB) Collecting h5py Using cached h5py-3.0.0-cp36-cp36m-win_amd64.whl (2.7 MB) Requirement already satisfied: importlib-metadata; python_version < "3.8" in c:\ sse python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (fr om markdown>=2.6.8->tensorboard<1.15.0,>=1.14.0->tensorflow==1.14.0) (2.0.0) Collecting cached-property Using cached cached_property-1.5.2-py2.py3-none-any.whl (7.6 kB) Requirement already satisfied: zipp>=0.5 in c:\sse python\qlik-py-tools-8.1\qlik -py-tools-8.1\qlik-py-env\lib\site-packages (from importlib-metadata; python_ver sion < "3.8"->markdown>=2.6.8->tensorboard<1.15.0,>=1.14.0->tensorflow==1.14.0) (3.4.0) Installing collected packages: termcolor, markdown, absl-py, werkzeug, tensorboa rd, wrapt, gast, google-pasta, keras-preprocessing, cached-property, h5py, keras -applications, astor, tensorflow-estimator, tensorflow Successfully installed absl-py-0.11.0 astor-0.8.1 cached-property-1.5.2 gast-0.4 .0 google-pasta-0.2.0 h5py-3.0.0 keras-applications-1.0.8 keras-preprocessing-1. 1.2 markdown-3.3.3 tensorboard-1.14.0 tensorflow-1.14.0 tensorflow-estimator-1.1 4.0 termcolor-1.1.0 werkzeug-1.0.1 wrapt-1.12.1 Collecting keras==2.2.5 Using cached Keras-2.2.5-py2.py3-none-any.whl (336 kB) Requirement already satisfied: h5py in c:\sse python\qlik-py-tools-8.1\qlik-py-t ools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (3.0.0) Requirement already satisfied: pyyaml in c:\sse python\qlik-py-tools-8.1\qlik-py -tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (5.3) Requirement already satisfied: scipy>=0.14 in c:\sse python\qlik-py-tools-8.1\ql ik-py-tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (1.4.1) Requirement already satisfied: keras-applications>=1.0.8 in c:\sse python\qlik-p y-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (1.0.8) Requirement already satisfied: keras-preprocessing>=1.1.0 in c:\sse python\qlik- py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (1.1.2) Requirement already satisfied: six>=1.9.0 in c:\sse python\qlik-py-tools-8.1\qli k-py-tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (1.15.0) Requirement already satisfied: numpy>=1.9.1 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from keras==2.2.5) (1.17.5) Requirement already satisfied: cached-property in c:\sse python\qlik-py-tools-8. 1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from h5py->keras==2.2.5) (1.5 .2) Installing collected packages: keras Successfully installed keras-2.2.5 Collecting en_core_web_sm==2.2.5 Downloading https://github.com/explosion/spacy-models/releases/download/en_cor e_web_sm-2.2.5/en_core_web_sm-2.2.5.tar.gz (12.0 MB) |████████████████████████████████| 12.0 MB 1.1 MB/s Requirement already satisfied: spacy>=2.2.2 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from en_core_web_sm==2.2.5) (2.2 .4) Requirement already satisfied: cymem<2.1.0,>=2.0.2 in c:\sse python\qlik-py-tool s-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_cor e_web_sm==2.2.5) (2.0.4) Requirement already satisfied: blis<0.5.0,>=0.4.0 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_core _web_sm==2.2.5) (0.4.1) Requirement already satisfied: plac<1.2.0,>=0.9.6 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_core _web_sm==2.2.5) (1.1.3) Requirement already satisfied: murmurhash<1.1.0,>=0.28.0 in c:\sse python\qlik-p y-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2-> en_core_web_sm==2.2.5) (1.0.4) Requirement already satisfied: srsly<1.1.0,>=1.0.2 in c:\sse python\qlik-py-tool s-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_cor e_web_sm==2.2.5) (1.0.3) Requirement already satisfied: wasabi<1.1.0,>=0.4.0 in c:\sse python\qlik-py-too ls-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_co re_web_sm==2.2.5) (0.8.0) Requirement already satisfied: preshed<3.1.0,>=3.0.2 in c:\sse python\qlik-py-to ols-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_c ore_web_sm==2.2.5) (3.0.3) Requirement already satisfied: catalogue<1.1.0,>=0.0.7 in c:\sse python\qlik-py- tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en _core_web_sm==2.2.5) (1.0.0) Requirement already satisfied: tqdm<5.0.0,>=4.38.0 in c:\sse python\qlik-py-tool s-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_cor e_web_sm==2.2.5) (4.51.0) Requirement already satisfied: setuptools in c:\sse python\qlik-py-tools-8.1\qli k-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_core_web_sm= =2.2.5) (50.3.2) Requirement already satisfied: thinc==7.4.0 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_core_web_s m==2.2.5) (7.4.0) Requirement already satisfied: requests<3.0.0,>=2.13.0 in c:\sse python\qlik-py- tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en _core_web_sm==2.2.5) (2.24.0) Requirement already satisfied: numpy>=1.15.0 in c:\sse python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from spacy>=2.2.2->en_coreweb sm==2.2.5) (1.17.5) Requirement already satisfied: importlib-metadata>=0.20; python_version < "3.8" in c:\sse python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packag es (from catalogue<1.1.0,>=0.0.7->spacy>=2.2.2->en_core_web_sm==2.2.5) (2.0.0) Requirement already satisfied: idna<3,>=2.5 in c:\sse python\qlik-py-tools-8.1\q lik-py-tools-8.1\qlik-py-env\lib\site-packages (from requests<3.0.0,>=2.13.0->sp acy>=2.2.2->en_core_web_sm==2.2.5) (2.10) Requirement already satisfied: chardet<4,>=3.0.2 in c:\sse python\qlik-py-tools- 8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from requests<3.0.0,>=2.13. 0->spacy>=2.2.2->en_core_web_sm==2.2.5) (3.0.4) Requirement already satisfied: certifi>=2017.4.17 in c:\sse python\qlik-py-tools -8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from requests<3.0.0,>=2.13 .0->spacy>=2.2.2->en_core_web_sm==2.2.5) (2020.6.20) Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in c:\sse python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages (from requests<3.0.0,>=2.13.0->spacy>=2.2.2->en_core_web_sm==2.2.5) (1.25.11) Requirement already satisfied: zipp>=0.5 in c:\sse python\qlik-py-tools-8.1\qlik -py-tools-8.1\qlik-py-env\lib\site-packages (from importlib-metadata>=0.20; pyth on_version < "3.8"->catalogue<1.1.0,>=0.0.7->spacy>=2.2.2->en_core_web_sm==2.2.5 ) (3.4.0) Building wheels for collected packages: en-core-web-sm Building wheel for en-core-web-sm (setup.py) ... done Created wheel for en-core-web-sm: filename=en_core_web_sm-2.2.5-py3-none-any.w hl size=12011743 sha256=aa4d06d725100b6200f5166f1ba9b363add4cc1282e13a454153b517 5af48e5a Stored in directory: C:\Users\QLIK_D~1\AppData\Local\Temp\pip-ephem-wheel-cach e-4wmdspp0\wheels\b5\94\56\596daa677d7e91038cbddfcf32b591d0c915a1b3a3e3d3c79d Successfully built en-core-web-sm Installing collected packages: en-core-web-sm Successfully installed en-core-web-sm-2.2.5 ? Download and installation successful You can now load the model via spacy.load('en_core_web_sm') symbolic link created for C:\SSE Python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik -py-env\lib\site-packages\spacy\data\en <<===>> C:\SSE Python\qlik-py-tools-8.1\ qlik-py-tools-8.1\qlik-py-env\lib\site-packages\en_core_web_sm ? Linking successful C:\SSE Python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages\en_core _web_sm --> C:\SSE Python\qlik-py-tools-8.1\qlik-py-tools-8.1\qlik-py-env\lib\site-packages\spacy\d ata\en You can now load the model via spacy.load('en')

Creating a new firewall rule for TCP port 50055...

Ok.

Setup completed. Please check the log above for errors in red text.

Run Qlik-Py-Start.bat to start this Server Side Extension.

Press any key to continue . . .

nabeel-oz commented 4 years ago

Thanks for the logs Gabriel. I don't see any errors in there, but it seems there's a portion of the logs missing at the start. This is where the files are copied to subdirectories under qlik-py-env and certain necessary packages like grpcio and grpcio-tools are installed.

Can you generate a requirements.txt file in the Python virtual environment as shown below? The file will appear under the qlik-py-env directory. Please attach that to this issue. If you want to compare the results you can use this file: requirements.txt

image

Also check that the qlik-py-env\generated directory contains the following files: image

And check that the qlik-py-env\core directory contains the following files: image

If the files are missing, you can just copy the core and generated folders from the parent directory to the qlik-py-env.

hammti commented 3 years ago

Hi @nabeel-oz , I'm having the same issue as Gabriel. I attached the requirements-file you were asking for. requirements.txt

nabeel-oz commented 3 years ago

Hi @hammti, the requirements seem to be ok in your case. Can you try opening a PowerShell window in the ..\qlik-py-tools-8.1\qlik-py-env\ directory and executing the main file manually?

.\Scripts\activate
python core\__main__.py

image

If that doesn't work try changing the port being used by PyTools. You can do this by opening ..\qlik-py-tools-8.1\qlik-py-env\core\__main__.py with a text editor, changing the value of the _DEFAULT_PORT variable, and then saving the file.

hammti commented 3 years ago

Hi @nabeel-oz, thanks for the reply. This seems to work: the logging is enabled. But there seem to be no capabilities added in my case. I still don't have access to the Python libraries in Qlik Sense. Can you help me out with that? Maybe something related to the Analytics Connection chosen in the QMC?

nabeel-oz commented 3 years ago

Hi @hammti, if you changed the port you'll need to update the Analytics Connection in QMC as well. You might also need to update Windows firewall settings by updating the port in the inbound rule called PyTools. Also, you might need to restart the Qlik Engine service.

hammti commented 3 years ago

Hi @nabeel-oz, thanks for you last reply. I was able to continue working on this problem and did what you recommonded in your last post. I still got stuck with actually being able to build the connection but without loading the Python libraries (see screenshot). Is there anything else I can do? screenshot

nabeel-oz commented 3 years ago

Hi @hammti , sorry for the late reply. If restarting the Qlik Sense engine service doesn't help, there is probably something blocking the SSE service on port 50055.

You can try changing the port by opening ..\qlik-py-tools-8.1\qlik-py-env\core\__main__.py with a text editor, changing the value of the _DEFAULT_PORT variable, and then saving the file. You'll also need to update the analytics connection in QMC and then restart the Qlik Sense engine service.

If that doesn't help you'll need to check firewall and VPN settings that may be blocking the communication.

abx-212 commented 2 years ago

Hello @hammti, I'm having the same error, have you reached to solution back then? If so would you kindly share your solution with me? Thanks