|
I have a function that automatically fetches the ECB exchange rates. In version 17.0.8, the data collection still worked. The data collection no longer works in version 17.0.10. The following error message is displayed: The secure connection to the remote host failed. The connection was closed from the other side. SQLCode=-990, ODBC 3 Stat=“HY000“ create function EZB_WAEHRUNGSKURSE() returns xml url 'https://www.ecb.europa.eu/stats/eurofxref/eurofxref-hist-90d.xml' type 'HTTP:GET' CERTIFICATE 'file=*' Does anyone knows a solution for this problem? |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 16 Jan '20, 02:41
question was seen: 1,172 times
last updated: 16 Jan '20, 08:42
See that yet unanswered FAQ - with v17.0.10 a new basic crypto library has been introduced. What happens when you explicitly provide the root certificate of the according web service instead of using the 'file=*' placeholder?
It doesn't work either. I have tried the Path to the Certificate. I have stored the Certificate in the DB. Always the Same error.
Hm, it fails for me, as well, with 17.0.10.5963, although I added the whole ECB certificate chain to the database... With v16, it works fine.
A very wild guess: Although v17.0.10 does no longer use OpenSSL, you might use its client to check for any issues, or possibly web client request logging (aka CALL sa_server_option('WebClientLogging', 'ON')) might help...
Thank you for your hint. I create for each version a looginng file. I compared both logging files, they are almost the same. The only differnces is that the version 17.0.10 does not contain "socket closed by peer".