New challenge with calling IoT Service from HanaXS

[andrevan_staden]

Hi, 

After solving the problem with the proxy settings in the .xshttpdest file, I am now getting this error - any ideas ?

The only funnee that I see is that the protocol is http and not https?  Any idea of how to correct this ?

Thanks

Andre

Return code : 502

UTM 9 http://www.sophos.com

An error occurred while handling your request

While trying to retrieve the URL:

http://iotmmsxxxxxxxx.us1.hana.ondemand.com:443/com.sap.iotservices.mms/v1/api/http/push/xxxxxxxxxxx...

The content could not be delivered due to the following condition:

Connection reset by peer

Please open a ITD Ticket at

SRIS_NW_CLOUD_SAAS

Powered by UTM Web Protection

[anton_levin · Accepted solution]

Hi Andre,

there is a note with regard to HTTPS consumption [1] from XS under paragraph 3.

To consume an Internet service via HTTPS, you need to export your HTTPS service certificate into X.509 format, to import it into a trust store and to assign it to your activated destination. You need to do this in the SAP HANA XS Administration Tool (https://<schema><account>.<host>/sap/hana/xs/admin/). For more information, see SAP HANA Developer Guide → section "3.6.2 SAP HANA XS Application Authentication".

After your Trust Store is configured you may also (in the same Admin Tool) tell your xs destination to use that Trust Store. Then, your destination file will look similar to:

description = "IOT Push Service";
host = "iotmmsXXX.hana.ondemand.com";
port = 443;
pathPrefix = "";
proxyType = http;
proxyHost = "proxy";
proxyPort = 8080;
authType = basic;
useSSL = true;
timeout = 30000;
sslHostCheck = true;
sslAuth = client;

Regards,

Anton

[1] SAP HANA Cloud Platform

[andrevan_staden · Accepted solution]

I suppose the old saying of 'If all else fails read the manual' applies. Amazing how lazy modern browsers and tools has made us by taking care of all this behind the scenes.

After importing the certificate from the IOT mms server it all worked.

Thanks again for all the help.

Regards

Andre