Skip to Content
Author's profile photo Sven Huberti

SAP Cloud Platfom Integration – Connection to OData API in Hana fails

I am doing a lot of demos to my customers, so that we do a “reality check” in regards to what our actually can do. Once you start playing around with it, it’s pretty simple, but sometimes you get stuck and you don’t really now why. Hence this blog entry…

So this morning I was preparing a quick demo for a customer, where I would show the SAP Cloud Platform Workflow Service, API Management and Integration. However, the integration flow would not start. Thanks to the tracing capability of SAP Cloud Platform Integration, I could quickly narrow down the issue. I simply set the trace level to “Debug” and went to the Monitoring Screen of CPI. There I clicked on the “Debug” link.

From there, I could see that there was an issue with the communication with the OData REST API of Hana.

The message was quite clear:

OData Method : CREATE_ENTRY Request URI : GET https://mytenant.hana.ondemand.com/TicketAgency/data.xsodata/$metadata HTTP/1.1 Request Headers : Authorization : Basic ******** x-csrf-token : fetch , cause: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

So basically the certificate of the target system, Hana, was missing in CPI.

How to get it? Described here!

https://help.sap.com/viewer/7952ef28a6914997abc01745fef1b607/2.0_SPS02/en-US/14114dbefe184930afa8a08387b89cc6.html 

Once I downloaded the certificate, I imported it in SAP Cloud Platform: Monitoring > Manage Security > Keystore > Add > Certificate.

 

All done! And the demo was a success 🙂

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Guillaume COURREGES
      Guillaume COURREGES

      Hello

       

      Very nice post, thank you so much.

      Do i have to do the same for other SAP cloud products (S/4HANA cloud etc...) ?

       

      Best regards

      Guillaume

      Author's profile photo Sven Huberti
      Sven Huberti
      Blog Post Author

      Hello Guillaume,

      I am not sure wether you have to do this for other SAP products. However, to have systems communicate with each other, it is common to establish trust with the use of certificates: this is a standard mechanism that I believe is used in other SAP products as well.

      Cheers,

      Sven