For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
1 0 0 2

Error 500 ECONNRESET

Estoy tratando de conectarme por API de python desde la red de la empresa y obtengo el siguiente error:


EikonError: Error code 500 | Server Error: {"code":500,"message":"read ECONNRESET","statusMessage":"Internal Server Error"}


Si me conecto desde otra red, no tengo inconvenientes.

Ya radiqué también caso 10699766 y no me dan respuesta, solo que postee la pregunta por acá. En este mismo foro recomiendan que para este tipo de error radique el caso en el HelpDesk (ver https://community.developers.refinitiv.com/questions/70763/error-from-the-python-eikon-api-i-get-an-error-mes.html)


Este el código que utilizo y me arroja error:

ek.set_app_key('xxxx')

RICs = ['COP1YOIS=INFV','COQMIBR2Y=INFV','COQMIBR3Y=INFV','COQMIBR5Y=INFV','COQMIBR10Y=INFV']


ts,e = ek.get_data(RICs,

["TR.MIDPRICE.date","TR.MIDPRICE"],

{'SDate':start_date,'EDate':end_date,'Frq':'D'})

ts



Qué puedo hacer? Alguna ayuda?

eikon-data-api
icon clock
10 |1500

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

10 Answers

Upvote
13k 32 12 18

Hello @carruiz,

Since your setup is working elsewhere and not in this particular network, it is most likely that your company firewall is blocking the request to Eikon servers. What is the status message at: http://localhost:9000/api/status

Check with your network administrators if the firewall is blocking the traffic to Eikon servers.

icon clock
10 |1500

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

Upvotes
1 0 0 2

Hello @Gurpreet, the status message at http://localhost:9000/api/status is {"statusCode":"ST_PROXY_READY","version":"2.9.0"}.

Could you share the Eikon server's urls to check if they are blocked? The desktop version works fine using the company's network.

Thanks in advance


icon clock
10 |1500

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

Upvotes
13k 32 12 18

Can you enable debug logging on the API and see what the output is:

import eikon as ek
import logging.config
ek.set_log_level(logging.DEBUG)
ek.set_app_key(xxxx)
icon clock
10 |1500

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

Upvotes
1 0 0 2

Hello @Gurpreet, this is the output:

2021-11-24 14:10:44,829 P[11720] [MainThread 14456] Send GET request to http://127.0.0.1:9060/api/status to detect API Proxy...

2021-11-24 14:10:44,834 P[11720] [MainThread 14456] Request to http://127.0.0.1:9060/api/status

headers = {'x-tr-applicationid': 'xxx'}

params = None

2021-11-24 14:10:46,848 P[11720] [MainThread 14456] Error on checking port 9060 : ConnectError("[Errno 10061] Connect call failed ('127.0.0.1', 9060)")

2021-11-24 14:10:46,849 P[11720] [MainThread 14456] Warning: file .portInUse was not found. Try to fallback to default port number.

2021-11-24 14:10:46,850 P[11720] [MainThread 14456] Try defaulting to port 9000...

2021-11-24 14:10:46,851 P[11720] [MainThread 14456] Send GET request to http://127.0.0.1:9000/api/status to detect API Proxy...

2021-11-24 14:10:46,852 P[11720] [MainThread 14456] Request to http://127.0.0.1:9000/api/status

headers = {'x-tr-applicationid': 'xxx'}

params = None

2021-11-24 14:10:46,878 P[11720] [MainThread 14456] Checking port 9000 response : 503 - API Proxy is not available

2021-11-24 14:10:46,878 P[11720] [MainThread 14456] Application ID: xxx

2021-11-24 14:10:46,879 P[11720] [MainThread 14456] Init a Desktop session with new app_key

2021-11-24 14:10:46,880 P[11720] [MainThread 14456] Port 9000 on local proxy was detected


Thanks in advance

icon clock
10 |1500

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

Upvotes
13k 32 12 18

Something is wrong in your setup. It could be python modules or eikon setup or proxy. Previously you said you were able to get a response from http://127.0.0.1:9000/api/status, but this log shows that python didn't get a response.

Can you confirm that your setup still works from non-office environment? Maybe check the firewall rules with your network admin, or try reinstalling the Eikon and python in a virtual environment.

icon clock
10 |1500

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

Upvotes
1 0 0 2

I created a virtual environment and installed Eikon in it. However I get this message when I try to get the data:1637944585117.png


1637944585117.png (61.7 KiB)
icon clock
10 |1500

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

Upvotes
13k 32 12 18

Were you able to get past the

ek.set_app_key

line of code without exception?

icon clock
10 |1500

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

Upvotes
1 0 0 2

Yes, i was

icon clock
10 |1500

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

Upvotes
13k 32 12 18

Can you please collect the proxy logs as described in another question:

The error indicates that TCP connection between Eikon API Proxy and Eikon platform backend was abruptly terminated. This could happen for any number of reasons. Eikon API Proxy is a component of Eikon desktop application, which technically is a Node.js server running on your machine and listening for HTTP requests sent by Eikon Data API library to http://localhost:9060/api/...", and passing these requests with additional headers to Eikon platform backend Web services.
If you experience this error intermittently and infrequently, you could catch it in your code and resubmit the request. Otherwise, if you're able to reproduce the issue at will, it would be very helpful to get Eikon API Proxy log files created with logging configured at the max level. Run Eikon Configuration Manager from Windows Start menu, select Logs tab and set Refinitiv Desktop trace level to "4 - Debug". Click Configure and restart Eikon. Then reproduce the error and collect SxS.<datetime>.<pid>.txt and APIProxy.<datetime>.<pid>.txt log files from Eikon logs folder (C:\ProgramData\Thomson Reuters\Eikon Data\Logs\TRD\Eikon.<datetime>.<pid>). Once you've collected the logs, you can put them in a zip file and attach it to your post. Don't forget to reverse logging settings after collecting the logs. You don't want Eikon and Python to keep outputting debug level logging.

icon clock
10 |1500

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

Upvotes
1 0 0 2

Hello @Gurpreet,

I've tried again execute it and get this error after

ek.set_app_key('xxxx') line:

2021-12-09 14:38:19,540 P[19328] [MainThread 17364] Reset a Desktop session with new app_key 2021-12-09 14:38:19,542 P[19328] [MainThread 17364] Unlock login_event for streaming session 0 due to stop streaming call 2021-12-09 14:38:19,549 P[19328] [MainThread 17364] Send GET request to http://127.0.0.1:9060/api/status to detect API Proxy... 2021-12-09 14:38:19,551 P[19328] [MainThread 17364] Request to http://127.0.0.1:9060/api/status
    headers = {'x-tr-applicationid': 'xxxx'}     params = None 2021-12-09 14:38:19,562 P[19328] [MainThread 17364] Checking port 9060 response : 200 - {"statusCode":"ST_PROXY_READY","version":"2.9.0"} 2021-12-09 14:38:19,563 P[19328] [MainThread 17364] Port 9060 was retrieved from .portInUse file 2021-12-09 14:38:19,564 P[19328] [MainThread 17364] Try to handshake on url http://127.0.0.1:9060/api/handshake...
2021-12-09 14:38:19,565 P[19328] [MainThread 17364] Request to http://127.0.0.1:9060/api/handshake
    headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'xxx'}     params = None 2021-12-09 14:38:19,793 P[19328] [MainThread 17364] Response : 500 - {"code":500,"message":"read ECONNRESET","statusMessage":"Internal Server Error"} 2021-12-09 14:38:19,794 P[19328] [MainThread 17364] Response 500 on handshake port 9060 : {"code":500,"message":"read ECONNRESET","statusMessage":"Internal Server Error"} 2021-12-09 14:38:19,795 P[19328] [MainThread 17364] Application ID: xxx 2021-12-09 14:38:19,796 P[19328] [MainThread 17364] Init a Desktop session with new app_key 2021-12-09 14:38:19,797 P[19328] [MainThread 17364] Port 9060 on local proxy was detected


any idea?

Could you share please the Eikon server's urls to check if they are blocked?

icon clock
10 |1500

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

Click below to post an Idea Post Idea