Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Refinitiv Data Platform /
avatar image
REFINITIV
Question by piotr.arendarski · Jan 21 at 10:59 AM · rdp-apierrorconnection-error

session open but queries return None / Empty DF using RDP library

Hello,

Following the question: https://community.developers.refinitiv.com/questions/82358/all-data-platform-session-queries-return-none-pyth.html?childToView=89782

I am able to start a session but any requests to retrieve data I make - rdp.get_snapshot, etc - return Nonetype objects.

The session appears to open fine.

Input:

import refinitiv.dataplatform as rdp
from platform import python_version
print(rdp.__version__)
print(python_version())
rdp.open_desktop_session('xxxx')

x = rdp.get_snapshot(
universe = ['GBP=','JPY='],
fields = ['BID','ASK'])
print(x)
print(rdp.get_last_status())
rdp.close_session()

Output:

1.0.0a7
3.9.0
None
{'http_status_code': -1, 'http_reason': b"[Errno 10061] Connect call failed ('127.0.0.1', 9060)"}


@umer.nalla suggestions from previous post:

Your error message would suggest you are creating a Desktop session, but that the library cannot connect to the Eikon Data API proxy.

Do you have Eikon or Workspace open and running on the same physical PC where you are running the python script?

What response do you get to the following?

http://localhost:9000/ping?all

http://localhost:9060/ping?all

and also:

http://localhost:9060/api/

http://localhost:9000/api/

1. Yes, I have my Workspace open and running on the same physical PC where I'm are running the python script.

2. I checked all the links to open and all the links can not be opened (blank screen, loading) but one the http://localhost:9060/api/ showing message on screen: 'This site can’t be reached'.

Thanks, Piotr

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

6 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by umer.nalla · Jan 21 at 02:00 PM

Hi @piotr.arendarski

Sorry - but I overlooked your responses earlier regards the HTTP requests.

The fact that you don't get a response from the ping or api call suggests the Eikon Data API Proxy is not running or has connectivity issues.

At the most basic, if the Proxy was running, you would get a response on 9000/9060.

Can you check with your internal security team if there are restrictions affecting the running of the proxy?

The requested log output above may also help shed some light.


Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by umer.nalla · Jan 21 at 11:40 AM

Hi @piotr.arendarski

Ok - 1st thing to note is that you have a very old version of RDP Library

a7 version was released in October 2020 - refinitiv-dataplatform · PyPI and there have been multiple versions since then.

Please try installing the latest version

pip install refinitiv-dataplatform==1.0.0a13 





Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by piotr.arendarski · Jan 21 at 11:59 AM

@umer.nalla

Thanks for reply.

After package installation there were some incompatibility errors in my terminal:

      Successfully uninstalled refinitiv-dataplatform-1.0.0a7
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dep
endency conflicts.
http3 0.6.7 requires h11==0.8.*, but you have h11 0.12.0 which is incompatible.
eikon 1.1.14 requires nest-asyncio>=1.5.1, but you have nest-asyncio 1.3.3 which is incompatible.
Successfully installed h11-0.12.0 httpcore-0.14.5 httpx-0.21.3 refinitiv-dataplatform-1.0.0a13

Then when I tried to run the Input again. It stops at the last line of code:

import refinitiv.dataplatform as rdp
from platform import python_version
print(rdp.__version__)
print(python_version())
rdp.open_desktop_session('xxxx')

Output:

1.0.0a13
3.9.0

ERROR!!! An error occurred while requesting URL('http://localhost:9060/api/status').
     ConnectError('All connection attempts failed')
ERROR!!! An error occurred while requesting URL('http://localhost:9000/api/status').
     ReadTimeout('')
ERROR!!! An error occurred while requesting URL('http://localhost:9060/api/status').
     ConnectError('All connection attempts failed')
Error: no proxy address identified.
Check if Desktop is running.
Error on handshake url http://localhost:9000/api/handshake : JSONDecodeError('Expecting value: line 1 column 1 (char 0)')

My Workspace desktop is running.

I had this error earlier, so I reinstalled python and all python libraries, installed a13 of rdp but the error persisted. I received advice to install a7 version of rdp and it partially helped because I was able to open session but could not retrieve data.

Thanks, Piotr

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by umer.nalla · Jan 21 at 12:23 PM

Hi @piotr.arendarski

Can you please provide the output for pip freeze for the python env - so I can share it with the RDP Lib support team?


Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by umer.nalla · Jan 21 at 12:36 PM

Hi @piotr.arendarski

Can you also enable logging and provide the output

import logging
logging.basicConfig(format='%(asctime)s - %(name)s - %(levelname)s - %(message)s', level=logging.DEBUG)

import refinitiv.dataplatform as rdp
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by piotr.arendarski · Jan 21 at 02:04 PM

Hi @umer.nalla

It is also my prediction that this is related to security restrictions.

Thanks for confirming this. I will check first this with out security team.

Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
umer.nalla ♦♦ · Jan 21 at 02:11 PM 0
Share

Hi @piotr.arendarski

The following thread may also help in your discussion with your security team

Error on handshake port 9060 : TimeoutException - Forum | Refinitiv Developer Community

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

discrepancy between RDP API vs Excel RSearch for corporate bonds

RDP Python Type Error

Summaries.Definition("MyRIC").GetData() not working when invoking from WindowsFrom Application

WebException 'Bad Request' randomly, always after data stops streaming

I have a client trying to use Refinitiv API to get surface of volatility and gets this error: {'code': 500, 'message': 'self signed certificate in certificate chain', 'statusMessage': 'Internal Server Error'}

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges