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

Question

question

piotr.arendarski

1 ●0 ●1 ●2

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

rdp-api error connection-error

Jan 21, 2022 at 10:59 AM

10 |1500

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

Shadab Hussain Jan 31, 2022 at 05:13 PM

Hi @piotr.arendarski ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,

AHS

zoya faberov Feb 07, 2022 at 10:13 PM

Hello @piotr.arendarski ,

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

Thanks,

-AHS

Answer 1 · 2022-01-21T14:00:27Z

umer.nalla

25.3k ●87 ●12 ●25

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.

Jan 21, 2022 at 02:00 PM

10 |1500

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

Answer 2 · 2022-01-21T11:40:02Z

umer.nalla

25.3k ●87 ●12 ●25

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

Jan 21, 2022 at 11:40 AM

10 |1500

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

Answer 3 · 2022-01-21T11:59:29Z

piotr.arendarski

1 ●0 ●1 ●2

@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

Jan 21, 2022 at 11:59 AM

10 |1500

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

Answer 4 · 2022-01-21T12:23:51Z

umer.nalla

25.3k ●87 ●12 ●25

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?

Jan 21, 2022 at 12:23 PM

10 |1500

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

Answer 5 · 2022-01-21T12:36:39Z

umer.nalla

25.3k ●87 ●12 ●25

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

Jan 21, 2022 at 12:36 PM

10 |1500

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

Answer 6 · 2022-01-21T14:04:38Z

piotr.arendarski

1 ●0 ●1 ●2

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.

Jan 21, 2022 at 02:04 PM

10 |1500

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

umer.nalla Jan 21, 2022 at 02:11 PM

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

Q&A Forum

question

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

6 Answers

Write an Answer

question

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

6 Answers

Write an Answer

Related Questions