question

Upvotes
Accepted
1 0 1 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.

Upvotes
Accepted
83.1k 281 53 77

@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.9k 32 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 1 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.