RFC open Hub error at BW/BODS

[former_member198401]

Hi All,

While running the BODS job we extract data via OHD(Open Hub Destination 3rd Party Tool) which calls a BW process chain, during the execution we found that BW process chain loads the data at BW end and then while communicating with DS via RFC it throws error. This used to work previously without any error message.

Data Services Version: 14.0.2.462 (DS 4.0)

RFC server interface details retrieved from Management console. There are 2 active RFC interface configured at BODS and BW is using multiple application servers via Open HUB Destination.

Logs:

log from

RFC Server Interface name: DI_BODS@arlpapp05.global.centralorg.net

11/14/2014 09:23:21 [ FINE ] (OHSP-DB) BW System

arlpapp05_PB9_03:Open

Hub ZTORDX01:Database Operation -

MICROSOFT_SQL_SERVER.ARLSQLDK007\I01.ETL_REPO_DSPROD.DSPROD-Lock

Information is written to AL_RUNTIME_PARAMETER/AL_SAP_JOB.

11/14/2014 09:23:21 [ FINE ] (OHSP) Lock for open hub ZTORDX01 was

obtained by job 0DAYSREPORT at repository

MICROSOFT_SQL_SERVER.ARLSQLDK007\I01.ETL_REPO_DSPROD.DSPROD

11/14/2014 09:23:31 [ FINE ] (OHSP-DB) BW System

arlpapp05_PB9_03:Open

Hub ZTORDX01:Database Operation -

MICROSOFT_SQL_SERVER.ARLSQLDK007\I01.ETL_REPO_DSPROD.DSPROD-Process

Chain

Log Id 7TRVO8LLWP7VP305C13H8T0Z9 with status Ais written to

AL_RUNTIME_PARAM.

11/14/2014 09:23:33 [ FINE ] (OHSP) Process chain

ZBW_BO_0DAYS@ZTORDX01 has failed status R which was delivered to |Data

flow DF_ODaysReport_Extract|Reader

ZTORDX01@MICROSOFT_SQL_SERVER.ARLSQLDK007\I01.ETL_REPO_DSPROD.DSPROD

andlock was released

We logged a ticket with SAP Support Team and they provided the following update::

Data Services does not support extracting via Open Hub from a load balanced BW environment before Data Services 4.2 SP1.

So you will need to upgrade to make use of this functionality.

For more details I attach an additional KBA 1747494 - Data Services

and load balanced ECC and BW environment

We are yet to upgrade to 4.2 SP2 which will require some time. Is there any workaround for the issue or has anyone come across such kind of issue.

Regards

Arun Sasi

[former_member198401 · Accepted solution]

Hi

Does anyone has any ideas about this issue.

Any help would be appreciated

Regards

Arun Sasi

[former_member198401 · Accepted solution]

Our SAP BW basis had done some changes on the server due to which this error was occurring. However the SAP BW Application to which the RFC destination was pointing to had a load balanced configuration. Now it pointed to a application server which is a clustered one.

We are not yet clear what changes were done by SAP BW Basis team so I dont have the steps which resolved the issue.

Regards

Arun Sasi