question

Upvotes
Accepted
1 0 0 1

Refinitiv.data in Jupyter lab

Hello,

We are trying to use Refinitiv.data in Jupyter lab but we encounter an error I report below . Can you help on this issue please ?

rd.open_session()
[2023-03-21T16:11:13.495970+01:00] - [DEBUG] - [rd] - [19276] | MainThread
RD version is 1.1.1; Python version is 3.10.9 (tags/v3.10.9:1dd9be6, Dec  6 2022, 20:01:21) [MSC v.1934 64 bit (AMD64)]
[2023-03-21T16:11:13.500970+01:00] - [DEBUG] - [rd] - [19276] | MainThread
Installed packages (593): adodbapi==2.6.1.3,affine==2.3.1,aiofiles==22.1.0,aiohttp==3.8.3,aiosignal==1.2.0,aiosqlite==0.17.0,alabaster==0.7.12,alembic==1.8.0,algopy==0.5.7,altair-data-server==0.4.1,altair-transform==0.2.0,altair-widgets==0.2.2,altair==4.2.0,aniso8601==9.0.1,ansiwrap==0.8.4,anyio==3.6.2,appdirs==1.4.4,argon2-cffi-bindings==21.2.0,argon2-cffi==21.3.0,arrow==1.2.2,asciitree==0.3.3,asgi-csrf==0.9,asgiref==3.5.2,asn1crypto==1.4.0,asteval==0.9.27,astor==0.8.1,astroid==2.12.12,astroml==1.0.2.post1,astropy==5.1.1,asttokens==2.1.0,async-generator==1.10,async-timeout==4.0.2,atomicwrites==1.4.0,attrs==22.1.0,autopep8==1.6.0,babel==2.10.3,backcall==0.2.0,backports-abc==0.5,baresql==0.7.6,base58==2.1.1,bcrypt==3.2.0,beautifulsoup4==4.11.1,binaryornot==0.4.4,black==22.12.0,bleach==5.0.0,blinker==1.4,blis==0.7.9,blosc==1.10.6,bokeh==2.4.3,botorch==0.6.2,bottleneck==1.3.4,bqplot==0.12.36,branca==0.5.0,brewer2mpl==1.4.1,brotli==1.0.9,cachelib==0.9.0,cachetools==5.2.0,cartopy==0.20.2,catalogue==2.0.8,certifi==2022.9.24,cffi==1.15.0,cftime==1.6.0,chardet==5.0.0,charset-normalizer==2.0.12,click-default-group-wheel==1.2.2,click-plugins==1.1.1,click==8.1.3,cligj==0.7.2,cloudpickle==2.1.0,clr-loader==0.2.4,clrmagic==0.0.1a2,colorama==0.4.6,colorcet==3.0.1,commonmark==0.9.1,confection==0.0.3,contourpy==1.0.6,cookiecutter==2.1.1,coverage==6.5.0,cramjam==2.6.2,cryptography==3.4.7,csvs-to-sqlite==1.3.1a0,cvxopt==1.3.0,cvxpy==1.2.1,cycler==0.11.0,cymem==2.0.7,cython==0.29.32,cytoolz==0.12.0,dash-core-components==2.0.0,dash-html-components==2.0.0,dash-table==5.0.0,dash==2.7.0,dask-glm==0.2.0,dask-image==2022.9.0,dask-labextension==6.0.0,dask-ml==2022.5.27,dask-searchcv==0.2.0,dask==2022.12.0,databases==0.5.5,datasette-graphql==2.1.1,datasette==0.63.1,datashader==0.14.2,datashape==0.5.2,dateparser==1.1.0,db.py==0.5.4b1,deap==1.3.1,debugpy==1.6.2,decorator==4.4.2,defusedxml==0.7.1,deprecated==1.2.13,deprecation==2.1.0,diff-match-patch==20200713,dill==0.3.5,distlib==0.3.6,distributed==2022.12.0,django==4.1.2,docopt==0.6.2,docrepr==0.1.1,docstring-to-markdown==0.10,docutils==0.17.1,duckdb==0.6.0,ecos==2.0.10,eikon==1.1.16,emcee==3.1.2,entrypoints==0.4,et-xmlfile==1.1.0,exceptiongroup==1.0.0,executing==1.2.0,fast-histogram==0.11,fastai==2.7.9,fastapi==0.87.0,fastcore==1.5.11,fastdownload==0.0.7,fasteners==0.17.3,fastjsonschema==2.16.2,fastparquet==2022.12.0,fastprogress==1.0.3,feather-format==0.4.1,filelock==3.8.0,filterpy==1.4.5,fiona==1.8.21,flake8==5.0.4,flask-accepts==0.18.4,flask-mail==0.9.1,flask-restx==0.5.1,flask-session==0.4.0,flask-sqlalchemy==2.5.1,flask==2.2.2,flaskerize==0.14.0,flit-core==3.8.0,flit==3.8.0,folium==0.13.0,fonttools==4.37.4,formlayout==1.2.1a1,frozenlist==1.3.0,fs==2.4.15,fsspec==2022.7.1,future==0.18.2,fuzzywuzzy==0.18.0,gast==0.4.0,gdal==3.4.3,geographiclib==1.52,geopandas==0.12.1,geopy==2.2.0,geoviews==1.9.5,gitdb==4.0.9,gitpython==3.1.29,gmpy2==2.1.2,gpytorch==1.9.0,graphene==3.1.1,graphql-core==3.2.3,graphql-relay==3.2.0,great-expectations==0.14.11,greenlet==1.1.2,guidata==2.3.1,guiqwt==4.3.1,h11==0.12.0,h2==4.1.0,h5py==3.7.0,heapdict==1.0.1,holoviews==1.15.3,hpack==4.0.0,html5lib==1.1,httpcore==0.15.0,httpie==3.2.1,httpx==0.23.0,humps==0.2.2,hupper==1.10.3,husl==4.0.3,hvplot==0.8.2,hypercorn==0.14.3,hyperframe==6.0.1,hypothesis==6.56.2,idlex==1.22,idna==3.1,imageio-ffmpeg==0.4.2,imageio==2.22.1,imagesize==1.4.1,imbalanced-learn==0.10.0,importlib-metadata==5.0.0,inflection==0.5.1,iniconfig==1.1.1,intake==0.6.4,intervaltree==3.0.2,ipycanvas==0.13.1,ipydatagrid==1.1.14,ipykernel==6.17.1,ipyleaflet==0.17.2,ipympl==0.9.2,ipython-genutils==0.2.0,ipython-sql==0.4.1b1,ipython==8.7.0,ipywidgets==8.0.4,isort==5.10.1,itsdangerous==2.1.2,janus==1.0.0,jedi==0.18.2,jellyfish==0.9.0,jinja2-time==0.2.0,jinja2==3.1.2,joblib==1.2.0,json5==0.9.8,jsonpatch==1.32,jsonpointer==2.3,jsonschema==4.6.2,julia==0.5.7,jupyter-bokeh==3.0.4,jupyter-client==7.4.9,jupyter-console==6.4.4,jupyter-core==5.1.0,jupyter-lsp==1.5.1,jupyter-packaging==0.12.3,jupyter-server-mathjax==0.2.6,jupyter-server-proxy==3.2.1,jupyter-server==1.23.5,jupyter-sphinx==0.4.0,jupyter==1.0.0,jupyterlab-launcher==0.13.1,jupyterlab-lsp==3.10.2,jupyterlab-pygments==0.2.2,jupyterlab-server==2.16.5,jupyterlab-widgets==3.0.5,jupyterlab==3.5.1,keyring==23.5.0,kiwisolver==1.4.3,langcodes==3.3.0,lazy-object-proxy==1.7.1,linear-operator==0.1.1,llvmlite==0.39.1,lmfit==1.0.3,locket==1.0.0,loky==3.1.0,lxml==4.9.0,lz4==4.0.1,mako==1.2.0,markdown==3.3.7,markupsafe==2.1.1,marshmallow==3.12.1,matplotlib-inline==0.1.6,matplotlib==3.6.2,maturin==0.13.6,mccabe==0.7.0,mercantile==1.2.1,mergedeep==1.3.4,metakernel==0.28.2,missingno==0.5.1,mistune==0.8.4,mizani==0.8.1,mlxtend==0.18.0,moviepy==1.0.3,mpl-scatter-density==0.7,mpld3==0.5.8,mpldatacursor==0.7.1,mpmath==1.2.1,msgpack==1.0.4,msvc-runtime==14.34.31931,multidict==6.0.2,multipledispatch==0.6.0,munch==2.5.0,murmurhash==1.0.7,mypy-extensions==0.4.3,mypy==0.990,mysql-connector-python==8.0.21,nbclassic==0.4.8,nbclient==0.7.0,nbconvert-reportlab==0.2,nbconvert==6.5.0,nbdime==3.1.1,nbformat==5.7.0,nbval==0.9.6,nest-asyncio==1.5.6,netcdf4==1.6.0,networkx==2.8.8,nlopt==2.7.1,nltk==3.7,notebook-shim==0.2.0,notebook==6.5.2,ntlm-auth==1.5.0,numba==0.56.4,numcodecs==0.10.0,numdifftools==0.9.40,numexpr==2.8.3,numpy==1.23.4,numpydoc==1.3,oct2py==5.4.3,octave-kernel==0.34.1,openpyxl==3.0.10,orjson==3.7.3,osqp==0.6.2.post5,outcome==1.2.0,packaging==22.0,palettable==3.3.0,pandas-datareader==0.10.0,pandas==1.5.2,pandocfilters==1.5.0,panel==0.14.2,papermill==2.4.0,param==1.12.3,parambokeh==0.2.3,paramiko==2.8.0,paramnb==2.0.4,parso==0.8.3,partd==1.2.0,pathspec==0.9.0,pathy==0.6.2,patsy==0.5.3,pdfrw==0.4.post2,pdvega==0.2.1.dev0,pep8==1.7.1,pexpect==4.8.0,pg8000==1.23.0,pickleshare==0.7.5,pillow==9.3.0,pims==0.6.1,pint==0.19.2,pip==22.3.1,pkginfo==1.8.3,platformdirs==2.5.4,plotly==5.11.0,plotnine==0.10.1,pluggy==1.0.0,ply==3.11,pmdarima==2.0.2,polars==0.15.6,portpicker==1.5.0,ppci==0.5.8,preshed==3.0.8,prettytable==3.3.0,priority==2.0.0,proglog==0.1.10,prometheus-client==0.15.0,prompt-toolkit==3.0.33,protobuf==4.21.12,psutil==5.9.0,ptpython==3.0.20,ptyprocess==0.7.0,pulp==2.6.0,pure-eval==0.2.2,py-lru-cache==0.1.4,py2vega==0.6.1,py==1.11.0,pyaml==20.4.0,pyarrow==10.0.1,pyaudio==0.2.11,pybars3==0.9.7,pybind11==2.10.0,pycodestyle==2.9.1,pycosat==0.6.3,pycparser==2.21,pyct==0.4.8,pydantic==1.9.1,pydeck==0.8.0,pydocstyle==6.2.3,pyee==9.0.4,pyepsg==0.4.0,pyerfa==2.0.0.1,pyflakes==2.5.0,pyflux==0.4.17,pygad==2.17.0,pygame==2.1.2,pygbm==0.1.0,pygments==2.12.0,pyhdf==0.10.5,pyhumps==3.8.0,pylint-venv==2.3.0,pylint==2.15.4,pyls-spyder==0.4.0,pymc==2.3.8,pymeta3==0.5.1,pymongo==4.1.1,pympler==1.0.1,pynacl==1.5.0,pynndescent==0.5.7,pyodbc==4.0.32,pyopengl==3.1.6,pypandoc==1.5,pyparsing==2.4.7,pyproj==3.3.1,pyqt5-qt5==5.15.2,pyqt5-sip==12.11.0,pyqt5==5.15.6,pyqtgraph==0.13.1,pyqtwebengine-qt5==5.15.2,pyqtwebengine==5.15.5,pyrsistent==0.18.1,pyserial==3.5,pyshp==2.3.0,pysocks==1.7.1,pystache==0.5.4,pytest==7.1.1,python-dateutil==2.8.2,python-dotenv==0.19.2,python-hdf4==0.10.0+dummy,python-levenshtein==0.12.2,python-lsp-black==1.2.1,python-lsp-jsonrpc==1.0.0,python-lsp-server==1.7.1,python-multipart==0.0.5,python-picard==0.7,python-slugify==6.1.2,python-snappy==0.6.1,pythonnet==3.0.0.post1,pythonqwt==0.10.2,pytoolconfig==1.2.4,pytz-deprecation-shim==0.1.0.post0,pytz==2022.4,pyviz-comms==2.2.0,pywavelets==1.4.1,pywin32-ctypes==0.2.0,pywin32==305,pywinpty==2.0.9,pywinusb==0.4.2,pyyaml==6.0,pyzmq==24.0.1,pyzo==4.12.4.dev0,pyzstd==0.15.2,qdarkstyle==3.0.3,qdldl==0.1.5.post2,qpsolvers==1.8.0,qstylizer==0.2.2,qtawesome==1.2.1,qtconsole==5.4.0,qtpy==2.3.0,quadprog==0.1.8,quantecon==0.5.3,quart==0.18.3,rasterio==1.2.10,readme-renderer==35.0,redis==4.3.1,refinitiv-data==1.1.1,regex==2022.9.13,reportlab==3.6.12,requests-ntlm==1.1.0,requests-toolbelt==0.10.1,requests==2.28.1,rfc3986==1.5.0,rich==12.4.4,rise==5.7.1,rope==1.6.0,rtree==1.0.0,ruamel.yaml==0.17.17,rx==3.1.1,scikit-fuzzy==0.4.1,scikit-image==0.19.3,scikit-learn==1.1.3,scikit-optimize==0.9.0,scilab2py==0.6.2,scipy==1.9.3,scramp==1.4.1,scs==3.2.0,seaborn==0.12.2,send2trash==1.8.0,setuptools==65.5.0,shap==0.40.0,shapely==1.8.2,simpervisor==0.4,simplegeneric==0.8.1,simplejson==3.17.6,simpy==4.0.1,six==1.16.0,sklearn-contrib-lightning==0.6.2.post0,slicer==0.0.7,slicerator==1.1.0,smart-open==5.2.1,smmap==5.0.0,snakeviz==2.1.0,sniffio==1.2.0,snowballstemmer==2.2.0,snuggs==1.4.7,sortedcontainers==2.4.0,sounddevice==0.4.4,soupsieve==2.3.2.post1,spacy-legacy==3.0.10,spacy-loggers==1.0.3,spacy==3.4.1,sphinx-rtd-theme==1.0.0,sphinx==5.3.0,sphinxcontrib-applehelp==1.0.2,sphinxcontrib-devhelp==1.0.2,sphinxcontrib-htmlhelp==2.0.0,sphinxcontrib-jsmath==1.0.1,sphinxcontrib-qthelp==1.0.3,sphinxcontrib-serializinghtml==1.1.5,spyder-kernels==2.4.2,spyder==5.4.2,sqlalchemy==1.4.42,sqlite-bro==0.12.2,sqlite-fts4==1.0.3,sqlite-utils==3.30,sqlparse==0.4.3,srsly==2.4.5,sspyrs==0.2,stack-data==0.6.1,starlette==0.21.0,statsmodels==0.13.5,streamlit==1.4.0,streamz==0.6.3,supersmoother==0.4,swifter==1.0.9,sympy==1.11.1,tables==3.7.0,tabulate==0.9.0,tbats==1.1.0,tblib==1.7.0,tenacity==8.2.2,termcolor==1.1.0,terminado==0.17.0,text-unidecode==1.3,textdistance==4.5.0,textwrap3==0.9.2,thinc==8.1.5,threadpoolctl==3.1.0,three-merge==0.1.1,tifffile==2022.5.4,tinycss2==1.1.1,toml==0.10.2,tomli-w==1.0.0,tomli==2.0.1,tomlkit==0.11.6,toolz==0.11.2,torch==1.13.1,torchaudio==0.13.1,torchvision==0.14.1,tornado==6.2,tqdm==4.64.0,traitlets==5.7.1,traittypes==0.2.1,trio-asyncio==0.12.0,trio==0.22.0,twine==4.0.1,twitter==1.19.2,typer==0.4.2,typing-extensions==4.4.0,tzdata==2022.7,tzlocal==4.2,ujson==5.3.0,umap-learn==0.5.1,uncertainties==3.1.6,urllib3==1.26.10,uvicorn==0.20.0,validators==0.18.2,vega-datasets==0.9.0,vega==3.6.0,virtualenv==20.14.1,vitables==3.0.2,waitress==2.1.2,wasabi==0.10.1,wasmer-compiler-cranelift==1.1.0,wasmer-compiler-singlepass==1.1.0,wasmer==1.1.0,watchdog==2.2.0,wcwidth==0.2.5,webencodings==0.5.1,websocket-client==1.4.2,werkzeug==2.2.2,whatthepatch==1.0.2,wheel==0.38.4,widgetsnbextension==4.0.5,winpython==5.3.20221231,wordcloud==1.8.1,wrapt==1.14.1,wsproto==1.2.0,xarray==2022.11.0,xgboost==1.6.1,xlsxwriter==3.0.3,xlwings==0.24.7,xmltodict==0.13.0,xyzservices==2022.6.0,yapf==0.32.0,yarl==1.7.2,zarr==2.11.3,zict==2.2.0,zipp==3.9.0,zstandard==0.19.0
[2023-03-21T16:11:13.502970+01:00] - [DEBUG] - [rd] - [19276] | MainThread
Read configs: C:\ProgramData\espdev\applications\WPy64-31090\settings\refinitiv-data.config.json, C:\ProgramData\espdev\applications\WPy64-31090\notebooks\docs\Louvre\SUIVIPOZ\refinitiv-data.config.json, C:\Users\VEGD791\refinitiv-data.config.json
[2023-03-21T16:11:13.507974+01:00] - [DEBUG] - [session] - [19276] | MainThread
Creating session "sessions.desktop.workspace.0" based on session.desktop.Definition("desktop.workspace")
[2023-03-21T16:11:13.510973+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
DesktopSession created with following parameters: app_key="APP_KEY", name="workspace" base_url="http://localhost:9000" platform_path_rdp="/api/rdp" platform_path_udf="/api/udf" handshake_url="/api/handshake"
[2023-03-21T16:11:13.511974+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
+ Session created: <refinitiv.data.session.Definition object at 0x149fe9b8b50 {name='workspace'}>
[2023-03-21T16:11:13.513974+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Open session
[2023-03-21T16:11:13.544982+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Created session connection SessionCxnType.DESKTOP
[2023-03-21T16:11:13.555982+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
HTTP Request id 0
    url = http://localhost:9060/api/status
    method = GET
    headers = {'x-tr-applicationid': 'APP_KEY'}
    params = None
    cookies = None
    data = None
    json = None
[2023-03-21T16:11:13.564984+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
HTTP Response id 0
    status_code = 200
    text = {"statusCode":"ST_PROXY_READY","version":"3.3.11-eikon4"}
[2023-03-21T16:11:13.566985+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Checking proxy url http://localhost:9060/api/status response : 200 - {"statusCode":"ST_PROXY_READY","version":"3.3.11-eikon4"}
[2023-03-21T16:11:13.567985+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Port 9060 was retrieved from .portInUse file
[2023-03-21T16:11:13.567985+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Try to handshake on url http://localhost:9060/api/handshake...
[2023-03-21T16:11:13.568985+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
HTTP Request id 1
    url = http://localhost:9060/api/handshake
    method = POST
    headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'APP_KEY'}
    params = None
    cookies = None
    data = None
    json = {'AppKey': 'APP_KEY', 'AppScope': 'trapi', 'ApiVersion': '1', 'LibraryName': 'RDP Python Library', 'LibraryVersion': '1.1.1'}
[2023-03-21T16:11:13.588990+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
HTTP Response id 1
    status_code = 500
    text = {"code":500,"message":"getaddrinfo ENOTFOUND emea1.apps.cp.thomsonreuters.com emea1.apps.cp.thomsonreuters.com:443","statusMessage":"Internal Server Error"}
[2023-03-21T16:11:13.590991+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Response : 500 - {"code":500,"message":"getaddrinfo ENOTFOUND emea1.apps.cp.thomsonreuters.com emea1.apps.cp.thomsonreuters.com:443","statusMessage":"Internal Server Error"}
[2023-03-21T16:11:13.591992+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Response 500 on handshake url http://localhost:9060/api/handshake : {"code":500,"message":"getaddrinfo ENOTFOUND emea1.apps.cp.thomsonreuters.com emea1.apps.cp.thomsonreuters.com:443","statusMessage":"Internal Server Error"}
[2023-03-21T16:11:13.593992+01:00] - [DEBUG] - [sessions.desktop.workspace.0] - [19276] | MainThread
Opened session<refinitiv.data.session.D
#productpython api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@julien.lebon-lafond01

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


Upvotes
Accepted
78.8k 250 52 74

@julien.lebon-lafond01

According to the error message "getaddrinfo ENOTFOUND emea1.apps.cp.thomsonreuters.com emea1.apps.cp.thomsonreuters.com:443", the Eikon API proxy is unable to connect to the Eikon servers because of the ENOTFOUND error.

It could be a problem in the Eikon settings or network settings.

You need to contact the Eikon support team directly via MyRefinitiv to verify what the problem is.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
14.2k 30 5 10

Hi @julien.lebon-lafond01 ,

Sorry for the issue that you're facing, can you put the code used here for further investigation, please?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
1 0 0 1

Hello,

what "product" should I select in the site "Product and Content Support" ?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @julien.lebon-lafond01 ,

You can select Refinitiv Eikon as this is related to the Eikon API Proxy of Refinitiv Data Library Desktop session

1679627441370.png

1679627441370.png (18.0 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.