Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /

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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

avatar image
Question by alexander.yermolayev · Dec 07, 2020 at 05:14 PM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonscreening-apierror-500

Code 500 Internal Server Error

Hello! I am experiencing the same issue Internal Server Error 500 after I run the query that used to run perfectly fine before. Please see the detailed log. And yes, I can set the app key without any errors. and the 9000/api/status message is as expected. version 2.6.4. and the eikon version is the last.
  
                
  1. 2020-12-07 15:02:25,941 P[12944] [MainThread 17968] entity: DataGrid_StandardAsync
  2.  
  3. 2020-12-07 15:02:25,942 P[12944] [MainThread 17968] payload: {'requests': [{'instruments': ['SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.BusinessSummary,"islami") OR Contains(TR.BusinessSummary,"takaful") OR Contains(TR.CommonName,"takaful") OR Contains(TR.CommonName,"islami") OR Contains(TR.BusinessSummary,"sharia"), IN(TR.TRBCIndustryCode,55301050,55301030,55301020,55301010), CURN=USD)'], 'fields': [{'name': 'TR.TRBCIndustry'}]}]}
  4.  
  5. 2020-12-07 15:02:25,943 P[12944] [MainThread 17968] Request:{'Entity': {'E': 'DataGrid_StandardAsync', 'W': {'requests': [{'instruments': ['SCREEN(U(IN(Equity(active,public,private,primary))), Contains(TR.BusinessSummary,"islami") OR Contains(TR.BusinessSummary,"takaful") OR Contains(TR.CommonName,"takaful") OR Contains(TR.CommonName,"islami") OR Contains(TR.BusinessSummary,"sharia"), IN(TR.TRBCIndustryCode,55301050,55301030,55301020,55301010), CURN=USD)'], 'fields': [{'name': 'TR.TRBCIndustry'}]}]}}}
  6.  
  7. 2020-12-07 15:02:25,944 P[12944] [MainThread 17968] Request to http://127.0.0.1:9060/api/v1/data    headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'xxxxxxxxxxxx'}     params = None
  8.  
  9. 2020-12-07 15:02:26,101 P[12944] [MainThread 17968] HTTP request response 500: {"code":500,"message":"read ECONNRESET","statusMessage":"Internal Server Error"}
  10.  
  11. 2020-12-07 15:02:26,102 P[12944] [MainThread 17968] HTTP Response code: 500
  12.  
  13. 2020-12-07 15:02:26,102 P[12944] [MainThread 17968] HTTP Response: {"code":500,"message":"read ECONNRESET","statusMessage":"Internal Server Error"}
  14.  
  15. 2020-12-07 15:02:26,103 P[12944] [MainThread 17968] Headers: x_ratelimit_limit=None / x_ratelimit_remaining=None
  16.  
  17. 2020-12-07 15:02:26,104 P[12944] [MainThread 17968] x_volumelimit_limit=None / x_volumelimit_remaining=None
  18.  
  19. 2020-12-07 15:02:26,112 P[12944] [MainThread 17968] retry_after 0



People who like this

0 Show 1
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.

avatar image
REFINITIV
moragodkrit.chumsri_1 ♦♦ · Dec 23, 2020 at 05:22 AM 0
Share

@alexander.yermolayev

Can you try the solution provided by Jason and confirm if it helps?

If it does not help, please post again, offering further insight into your question.

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jason.ramchandani01 · Dec 16, 2020 at 11:15 AM

@alexander.yermolayev 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.

Comment
alexander.yermolayev

People who like this

1 Show 2 · 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
alexander.yermolayev · Dec 23, 2020 at 02:26 PM 1
Share

Hello, Jason @jason.ramchandani


Many thanks for the advice, this helped to solve the issue.

I am not sure what changed in the last two-three weeks on Refinitiv side or our side that these requests were now blocked by the firewall. Maybe there was a change in policies on both sides.

We managed to resolve the issue after two weeks of prodding in different directions.

avatar image
REFINITIV
jason.ramchandani01 ♦♦ alexander.yermolayev · Dec 23, 2020 at 02:44 PM 0
Share

@alexander.yermolayev OK great news - just wanted to wish you happy holidays!

avatar image
REFINITIV
Answer by Alex Putkov.1 · Dec 07, 2020 at 08:43 PM

@alexander.yermolayev

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.

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
alexander.yermolayev · Dec 11, 2020 at 10:08 PM 0
Share

@Alex Putkov. Hello Alex, many thanks for the detailed reply.

The issue is not intermittent, it occurs with ALL queries I am trying to run.

i.e. I cannot use Eikon Data API at all, no requests are being sent successfully.

I attach the logs I created by running as requested.

I made sure that my proxy is not an issue, the IT team set exceptions for 159.220.40.41:443 and :80, as well as HTTPS Tunneling.

avatar image
REFINITIV
Answer by Alex Putkov.1 · Dec 11, 2020 at 11:34 PM

@alexander.yermolayev

I'm afraid what you've shared are the logs produced by Eikon Data APIs library for Python. Eikon API Proxy logs collected following the instructions in my previous response would have been much more useful for the problem you're experiencing.
From the logs produced by Eikon Data APIs library for Python that you shared it appears that between Dec 7 and Dec 10 you were consistently getting "read ECONNRESET" error in response to data requests. I cannot say what caused this error, but it most certainly is related to network connectivity. If you were able to retrieve data from Eikon using Eikon Data APIs earlier, and then starting Dec 7 all data requests started returning "read ECONNRESET" error, this suggests that some changes were implemented on your network on or before Dec 7th.
The logs you shared reveal that starting on Dec 11 data requests consistently return a different error message: "unable to get local issuer certificate". This suggests that changes were implemented to your Internet proxy overnight between Dec 10 and 11. I'm not privy to your network configuration details and cannot be sure what exact changes happened on your network recently. The error message "unable to get local issuer certificate" suggests you're probably using SSL decrypting proxy, which blocks HTTPS traffic between Eikon API Proxy running on your machine and Web services on Eikon platform backend. It's hard to say exactly why the proxy is blocking this traffic. One reason may be that it expects a local certificate from your machine to be attached to the requests. If this is indeed the case, then you may be affected by a known deficiency in recent versions of Eikon API Proxy, which don't allow client certificate to be picked up from Windows Certificate Store. If this is indeed the case, there's a couple of immediate workarounds we can suggest while the underlying problem with Eikon API Proxy is being fixed. This said, it's all pure speculation. The best way to go about investigating and resolving the problem you 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.

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
Answer by kenna178015.crook · Dec 24, 2020 at 04:50 AM

The 500 Internal Server Error is a very general HTTP status code that means something has gone wrong on the website's server but the server could not be more specific on what the exact problem is. mcdvoice

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 Huiru.Huang · Dec 08, 2021 at 06:38 AM

A client met the same issue with

  • Python version is 3.8.8
  • Eikon library version is 1.1.14
  • Httpx library version is 0.21.1
  • Nest-asyncio version is 1.5.1


And below is code, does proxy setting in python allowed?

code.png


code.png (57.9 KiB)
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
chavalit-jintamalit ♦♦ · Dec 09, 2021 at 05:17 AM 0
Share
Hi @Huiru.Huang

Please do not ask a new question in the question with an accepted answer.

Moderator or Advocate may miss it.

The code you show here looks valid to set up the proxy environment.

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 >
13 People are following this question.

Related Questions

Error code 500 | Backend error. 500 Internal Server Error

Backend error. 500 Internal Server Error

How to get all investors for a list of stocks, historically with the python API

python Eikon api response 500

EikonError: Error code 500 | Backend error. 500 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