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

Question

Question by bmeng · Oct 15 at 05:00 PM · ssl sslerror

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.

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-10-15T17:22:09Z

REFINITIV

Answer by pierre.faurel · Oct 15 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)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2020-10-15T17:32:38Z

Answer by bmeng · Oct 15 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)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2020-10-15T17:46:09Z

Answer by bmeng · Oct 15 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?

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2020-10-15T19:40:31Z

REFINITIV

Answer by pierre.faurel · Oct 15 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 ?

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 5 · 2020-10-15T20:06:09Z

Answer by bmeng · Oct 15 at 08:06 PM

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

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 6 · 2020-10-16T13:46:19Z

REFINITIV

Answer by pierre.faurel · Oct 16 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)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 7 · 2020-10-16T14:00:00Z

Answer by bmeng · Oct 16 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.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 8 · 2020-10-16T16:42:06Z

REFINITIV

Answer by pierre.faurel · Oct 16 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

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 9 · 2020-10-16T16:57:08Z

Answer by bmeng · Oct 16 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

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 10 · 2020-10-19T18:01:19Z

REFINITIV

Answer by pierre.faurel · Oct 19 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.

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

10 Replies

Watch this question