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.

Find more posts tagged with

python

eikon

ssl

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

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.

All comments

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 ?

bmeng

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.

bmeng

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?

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 ?

bmeng

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

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)

bmeng

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.

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

bmeng

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

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.

EXPLORE OUR SITES