Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ECC-RFC and HANA-DB connection conflicts

Hi Experts,

I am facing some strange issue when trying to build OData service from ECC and HANA views.

I could successfully configure the service which will fetch data from ECC in Gateway and when tried in the browser, it will show the metadata, if filter is applied, specific data is available in the browser both in json or xml format.

Couple of weeks later, we had a requirement to connect HANA box as trusted relation with GW.

I have configured the model classes and DB connection as described in the following docs.

Get Your HANA Data From Everywhere With Netweaver Gateway

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0b5be6f-afb7-2f10-e68c-dad80774a223?overridelayout=true

Now the catch:

As per the document we need to do BAdi enhancement to update DB connection method.

Once the steps are completed, I am getting HTTP 500 error in the HANA DB service which says something like "syntax error in sql"

This means, Gateway is able to connect HANA as DB and trying to hit the views.

At the same time when you try to access the previously successful ECC service, it is now throwing with error "RFC call ended with "Communication Failure" exception"

As soon as when you try to remove the newly created BAdi enhancement spot, the ECC OData service wil resume and fetch the data via RFC connection through Gateway.

I would like to know, how the connections to ECC and HANA can be resolved.

Any other settings involved in Gateway to handle ECC-RFC  and HANA-DB connection separately in gateway.

Thanks!

Praveen.

replied

Hi,

The issue got resolved by adding a Filter Value for SERVICE_TYPE in BAdi enhancement implementation section through SE19 in Gateway server.

Creating HANA DB based SAP Netweaver Gateway Service

The mentioned doc helped me to get the missing step.

Thanks!

Praveen.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question