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 0

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.


eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apissl
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
4.3k 2 4 5

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.

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
4.3k 2 4 5

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)
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 0

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)
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 0

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?

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
4.3k 2 4 5

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 ?

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 0

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

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
4.3k 2 4 5

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)

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 0

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.

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
4.3k 2 4 5

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

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 0

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
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.