Upgrade from Eikon -> Workspace. Learn about programming differences.

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 1 1 3

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 512.0 KiB each and 1.0 MiB total.

Upvotes
Accepted
14k 30 5 10

hi @carruiz

could you please try, according to an answer from this thread,

I noticed a customer with a similar issue had success with this - please could you try opening firewall access to:
emea1.apps.cp.thomsonreuters.com 159.220.1.19
amers1.apps.cp.thomsonreuters.com 159.220.40.41
apac1.apps.cp.thomsonreuters.com 159.220.16.215


and then try again. I hope this can help.
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.

Upvote
21.8k 57 14 21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 3

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 512.0 KiB each and 1.0 MiB total.

Upvotes
21.8k 57 14 21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 3

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 512.0 KiB each and 1.0 MiB total.

Upvotes
21.8k 57 14 21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 3

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 512.0 KiB each and 1.0 MiB total.

Upvotes
21.8k 57 14 21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 3

Yes, i was

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
21.8k 57 14 21

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 512.0 KiB each and 1.0 MiB total.

Upvotes
1 1 1 3

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 512.0 KiB each and 1.0 MiB total.

Upvotes
14k 30 5 10

hi @carruiz

regarding to an answer from this thread

it seems like it's a networking issue. Please see this thread https://community.developers.refinitiv.com/questions/70304/code-500-internal-server-error.html . From that thread: 'The best way to go about investigating and resolving the problem your client experienced is to open a case with Refinitiv Helpdesk and have a troubleshooting session between your IT and Refinitiv Support. The format of a community forum is not very well suited to investigating networking issues, not to mention that sharing details of your private network configuration on a public forum could be a security concern.

To open a case with Refinitiv Helpdesk, use Contact Us capability in your Eikon application (from the main Eikon menu select Help - Contact Us) or visit MyRefinitiv.

I hope this can help.

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 1 1 3

I also opened case 10699766 and they don't give me an answer, they only ask me to post the question here...

So, what can i do? any help please?


again:

Could you share with me 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 512.0 KiB each and 1.0 MiB total.

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.