BO Data Services 4.0 RFC connection to SAP BW HANA

dataservices administration
1

Dear colleagues,

I’m trying to extract data with DataServices 4.0 (SP2) from BW on HANA through OpenHub Destination and we are facing connection problems.

There’s also a traditional BW and we connected using an RFC and the connection test on SM59 worked fine.
However, we created another RFC for BW-HANA and the connection test on SM59 failed with the following error:

Logon - Connection Error
Error when opening and RFC Connection (CPIC-CALL: ‘ThSAPOCMINIT’ : cmRc=2 thRc=67
ERROR: program DIHASOURCE not registered
LOCATION: SAP-Gateway on host xxxx.xxx.xxx /sapgw30
DETAIL: TP DIHASOURCE not registered
COMPONENT: SAP-Gateway
COUNTER: 39789482
MODULE: gwr3cpic.c
LINE: 1803
RETURN CODE: 679
SUBRC: 0
RELEASE: 720
TIME
VERSION: 2

And the log error files on DS says: “Timeout during allocate of registered program”

We created the RFC at de Administration Console and the connection is “Started” and we can import tables and OpenHub to the local repository in DTS when creating the DataStore.

Did anyone have the same problems?

Is there any known connectivity problem or restriction between BW-HANA and DS 4?

Thank to all of you!

inver5 :es: (BOB member since 2012-05-23)

2

I have the same problem. Have you (or anyone) been able to find the fix?

Also, I’ve seen on SCN that some people suggest just writing directly to the db tables of BW, since they are created in HANA, but I don’t think it’s the right way.

Codehopper (BOB member since 2010-05-14)

3

No, RFC is not the right way when using Open Hub target tables.

When you are using Open Hub to create a target table, you can read that table directly from the database with BODS, using a normal Oracle/SQL Server/DB2 etc connection.

You do not need to use RFC calls to read data. Direct table reads from target Open Hub tables is the only way to read large volumes of data from SAP BW. (Ever tried extracting 30 million records through RFC? It’s not very pretty :slight_smile: )

ErikR :new_zealand: (BOB member since 2007-01-10)