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 bmeng · Oct 15, 2020 at 05:00 PM · eikoneikon-data-apiworkspacepythonworkspace-data-apirefinitiv-dataplatform-eikonssl

Unable to make api calls since Oct. 14, 2020. Working fine previously.

I have lost access to the Eikon data api from Oct. 14, 2020. It was working fine previously.


My error message:

2020-10-15 11:51:07,263 P[24416] [MainThread 37516] Response : 500 - {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}


My log:


2020-10-15 11:51:04,981 P[24416] [MainThread 37516] Reset a Desktop session with new app_key
2020-10-15 11:51:04,983 P[24416] [MainThread 37516] Unlock login_event for streaming session 0 due to stop streaming call
2020-10-15 11:51:04,990 P[24416] [MainThread 37516] Send GET request to http://localhost:9060/api/status to detect API Proxy...
2020-10-15 11:51:04,993 P[24416] [MainThread 37516] Request to http://localhost:9060/api/status
headers = {'x-tr-applicationid': 'key'}
params = None
2020-10-15 11:51:07,064 P[24416] [MainThread 37516] HTTP request response 200: {"statusCode":"ST_PROXY_READY","version":"2.6.3"}
2020-10-15 11:51:07,071 P[24416] [MainThread 37516] Checking port 9060 response : 200 - {"statusCode":"ST_PROXY_READY","version":"2.6.3"}
2020-10-15 11:51:07,072 P[24416] [MainThread 37516] Port 9060 was retrieved from .portInUse file
2020-10-15 11:51:07,073 P[24416] [MainThread 37516] Try to handshake on url http://localhost:9060/api/handshake...
2020-10-15 11:51:07,074 P[24416] [MainThread 37516] Request to http://localhost:9060/api/handshake
headers = {'Content-Type': 'application/json', 'x-tr-applicationid': 'key'}
params = None
2020-10-15 11:51:07,261 P[24416] [MainThread 37516] HTTP request response 500: {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-15 11:51:07,263 P[24416] [MainThread 37516] Response : 500 - {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-15 11:51:07,264 P[24416] [MainThread 37516] Response 500 on handshake port 9060 : {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}
2020-10-15 11:51:07,265 P[24416] [MainThread 37516] Application ID: key
2020-10-15 11:51:07,267 P[24416] [MainThread 37516] Init a Desktop session with new app_key
2020-10-15 11:51:07,268 P[24416] [MainThread 37516] Port 9060 on local proxy was detected


I have been in contact with my corporations network team, but they have stated that there were no changes to the corporate firewall on Oct. 14, 2020. I did not put any changes in to my code.


Were there any changes to Eikon? Appreciate any help you can give.


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.

10 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by pierre.faurel · Oct 19, 2020 at 06:01 PM

Hi,

I was informed that from Eikon 4.0.52, API Proxy no more supports NTLM/Kerberos authenticated proxies.
Could you check with your IT if your corporate firewall is similar ?

That could explain the message {"code":500,"message":"self signed certificate in certificate chain","statusMessage":"Internal Server Error"}

If it's confirmed, there is a solution, and you have to contact the support.

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 pierre.faurel · Oct 15, 2020 at 05:22 PM

Hi,

If you're targeted as pre-released customer, your Eikon Desktop product was updated to 4.0.53

Could clear your Eikon Desktop cache ?

Then restart Eikon Desktop and retry to run your python script ?


1602782470027.png (28.7 KiB)
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 bmeng · Oct 15, 2020 at 05:32 PM

Thanks for responding.

My Eikon Desktop is v4.0.52


I have cleared the cache and reran the query. It is returning the same error message.


1602783059495.png (13.3 KiB)
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 bmeng · Oct 15, 2020 at 05:46 PM

Corporation network team stated that they made no changes to the firewall. In addition, they have asked the following:


The error indicates that the self-signed certificate that is used by the firewall (to decrypt and inspect the traffic) when a computer connects to the Eikon API URL is not supported by the API endpoint. We can exclude that URL from SSL decryption so we need to know where is the server connecting to make these calls?


Are you able to provide a list of URLs that the Eikon data api is connecting to?

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 pierre.faurel · Oct 15, 2020 at 07:40 PM

Hi,

If it worked recently, nothing changed for the python lib since the Sep 25, 2020 (I assume that you're using the 1.1.6post3 version).

On Eikon side, the next version, 4.0.53 startup hits three Refinitiv back-end URLS :

"heartbeat.ciam.refinitiv" , "identity.ciam.refinitiv" and "-gateway.platform.refinitiv"

Could you forward it to your IT to check if these server address are already used ?

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 bmeng · Oct 15, 2020 at 08:06 PM

I have sent your message to IT. Thank you. I'll update this thread when they get back to me.

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 pierre.faurel · Oct 16, 2020 at 01:46 PM

Hi,

eikon 1.1.7 is available on pypi.

I'm not sure this will fix your problem, but it fixes several issues (especially on dependency versions) and better handles some errors on time series requests.

Could you also check in Eikon logs the file APIProxy.yyyymmdd.hhmmss.txt ?
(it should be in C:\ProgramData\Thomson Reuters\Eikon Data\Logs\TRD\Eikon.202010dd.hhmmss.pxxxx directory)

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 bmeng · Oct 16, 2020 at 02:00 PM

Thank you. I have tried installing the updated python eikon package and the error message is the same.


Here are the contents of the APIProxy log file:


start node

Arg: C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon\X\Bin\Eikonbox.exe C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon User\Cache\LibraryCache\Apps\REFINITIVHOLDINGS.EIKON.DATAAPIPROXY\1.1.0.11\index.js -TraceLevel=-1 


There were multiple log files and they had the same contents.

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 pierre.faurel · Oct 16, 2020 at 04:42 PM

Could you activate Eikon log at Debug level ?

You'll find info on Eikon logs here : https://community.developers.refinitiv.com/questions/67495/eikon-form-python.html?childToView=67716#answer-67716

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 bmeng · Oct 16, 2020 at 04:57 PM

Thank you. These are the debugging level logs:


Eikon: -eikonpid=12024 -EikonProcessId=7488 -HwndComInterop=0x1 "-manifest=C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon User\Cache\LibraryCache\9.0.52055_GENTC-45543__EikonContainer.dll.manifest" "-Context=C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon User\Cache\LibraryCache\Apps\REFINITIVHOLDINGS.EIKON.DATAAPIPROXY\1.1.0.11" /prefetch:1

start node

Arg: C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon\Y\Bin\Eikonbox.exe C:\Users\bmeng\AppData\Local\Thomson Reuters\Eikon User\Cache\LibraryCache\Apps\REFINITIVHOLDINGS.EIKON.DATAAPIPROXY\1.1.0.11\index.js -TraceLevel=4 

[2020-10-16 16:55:01.839|1|api-svc|1|INFO] PA: false
[2020-10-16 16:55:01.846|1|api-svc|2|DEBUG] Waiting for FT
[2020-10-16 16:55:13.668|1|api-svc|1|INFO] FT is ready
[2020-10-16 16:55:13.670|1|api-svc|3|DEBUG] set User Agent
[2020-10-16 16:55:13.673|1|api-svc|1|INFO] Initial port: 9060
[2020-10-16 16:55:13.675|1|api-svc|1|INFO] Port range: 20
[2020-10-16 16:55:13.763|1|api-svc|1|INFO] Listening to port=9060
[2020-10-16 16:55:13.792|1|data-api|1|INFO] [ConfigurationManager]Getting configuration ...
[2020-10-16 16:55:13.938|1|data-api|1|INFO] [ConfigurationManager]Configuration successfully retrieved.
[2020-10-16 16:55:13.940|1|data-api|3|DEBUG] [ConfigurationManager]{"backwardCompatibilityBetaEnabled":true,"currentVersion":"2.6.3","currentWebApiVersion":"1.1.0","dataCenter":"","endPointURL":"https://amers1.apps.cp.thomsonreuters.com/Apps/UDF/MSF","handshake":{"enabled":true,"isMandatory":false},"minimalVersion":"0.0.0","minimalVersionRequirementMet":true,"proxyEnabled":true,"rdpAccessEnabled":true,"statusEnabled":true,"streaming":{"enabled":true,"maxConnection":10},"throttling":{"dailyRequestCount":{"enabled":true,"max":10000},"dailyVolume":{"enabled":true,"max":5000000},"queueSize":100,"queueTimeout":120,"requestCount":{"enabled":true,"max":5,"period":1},"volume":{"enabled":true,"max":50000,"period":60}},"udfAccessEnabled":true,"usageTrackingEnabled":true}
[2020-10-16 16:55:13.984|1|data-api|3|DEBUG] [getWsClientOptions]HTTP_PROXY and HTTPS_PROXY environment variables are no set, skipping proxy configuration.
[2020-10-16 16:55:14.045|1|data-api|3|DEBUG] [UdfController][UdfController::create] Creating UDF controller.
[2020-10-16 16:55:14.047|1|data-api|3|DEBUG] [StatusController][StatusController::create] Creating status controller.
[2020-10-16 16:55:14.049|1|data-api|3|DEBUG] [RdpStreamingDiscoveryController][RdpStreamingDiscoveryController::create] Creating RDP Streaming Discovery controller.
[2020-10-16 16:55:14.050|1|data-api|3|DEBUG] [RdpController][RdpController::create] Creating RDP controller.
[2020-10-16 16:55:14.053|1|data-api|3|DEBUG] [HomeController][HomeController::create] Creating index controller.
[2020-10-16 16:55:14.056|1|data-api|3|DEBUG] [HandshakeController][Handshake::create] Creating handshake controller.
[2020-10-16 16:55:14.058|1|data-api|3|DEBUG] [ApiV1StreamingDiscoveryController][ApiV1StreamingDiscoveryController::create] Creating ApiV1StreamingDiscoveryController controller.
[2020-10-16 16:55:14.063|1|data-api|3|DEBUG] [ApiController][ApiController::create] Creating API controller.
[2020-10-16 16:55:14.069|1|data-api|3|DEBUG] [TracingMiddleware]Creating new request tracing middleware.
[2020-10-16 16:55:14.075|1|data-api|3|DEBUG] [SettingsAggregatorService]Getting value for APIPROXY.THROTTLING.STORE from platform setting service
[2020-10-16 16:55:14.094|1|data-api|3|DEBUG] [TracingMiddleware]Creating new request tracing middleware.
[2020-10-16 16:55:14.098|1|data-api|3|DEBUG] [TracingMiddleware]Creating new request tracing middleware.
[2020-10-16 16:55:14.102|1|data-api|3|DEBUG] [TracingMiddleware]Creating new request tracing middleware.
[2020-10-16 16:55:14.112|1|data-api|3|DEBUG] [TracingMiddleware]Creating new request tracing middleware.
[2020-10-16 16:55:14.126|1|data-api|3|DEBUG] [ABFT][ABFT] Applying anti-bruteforce throttling
[2020-10-16 16:55:14.147|1|data-api|1|INFO] [Throttling][RBT] Request-count based throttling has been enabled by configuration.
[2020-10-16 16:55:14.149|1|data-api|3|DEBUG] [Throttling][RBT] Applying request-count limits - 5 request(s) per 1 second(s)
[2020-10-16 16:55:14.153|1|data-api|1|INFO] [Throttling][VBT] Volume-based throttling has been enabled by configuration.
[2020-10-16 16:55:14.154|1|data-api|3|DEBUG] [Throttling][VBT] Applying volume limits - 50000 KB per 60 second(s)
[2020-10-16 16:55:14.171|1|data-api|1|INFO] [WebSocketServer]Creating new WebSocket server instance
[2020-10-16 16:55:14.174|1|data-api|3|DEBUG] [WebSocketServer]WebSocket path is /api/rdp/streaming/pricing/v1/WebSocket. Max simultaneous connections: 10
[2020-10-16 16:55:14.181|1|data-api|1|INFO] [ApiV1WebSocketServerProvider]Creating new WebSocket server instance
[2020-10-16 16:55:14.183|1|data-api|3|DEBUG] [ApiV1WebSocketServerProvider]WebSocket path is /api/v1/data/streaming/pricing/WebSocket. Max simultaneous connections: 10
[2020-10-16 16:55:14.205|1|data-api|3|DEBUG] [SettingsAggregatorService]Got value '{"dailyRequest":"[[\"127.0.0.1\",[[1602820800000,2],[1602734400000,0]]]]","dailyVolume":"[[\"127.0.0.1\",[[1602820800000,1643]]]]"}', trying to parse ...
[2020-10-16 16:55:14.207|1|data-api|3|DEBUG] [SettingsAggregatorService]Parsing succeeded !
[2020-10-16 16:55:14.209|1|data-api|1|INFO] [Throttling][DRBT] Daily request-count based throttling has been enabled by configuration.
[2020-10-16 16:55:14.210|1|data-api|3|DEBUG] [Throttling][DRBT] Applying daily request-count limits - 10000 request(s) per day
[2020-10-16 16:55:14.215|1|data-api|1|INFO] [Throttling][DVBT] Daily volume-based throttling has been enabled by configuration.
[2020-10-16 16:55:14.217|1|data-api|3|DEBUG] [Throttling][DVBT] Applying daily volume-based limits - 5000000 KB per day
[2020-10-16 16:55:14.337|1|api-svc|1|INFO] Write port file
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.

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

Related Questions

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

Trying to fetch Close Bid Price for CMO tranche from Python

Retrieve Commodity Flows data using Python API

Company trees don't match in Eikon online tool and the Eikon Proxy API

Download API Proxy Python for Windows.

  • 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