OpenHUB - BODS Issues

dataservices administration
1

Hello Everybody,

We have set up the connection between BODS and SAP BW via OpenHub.

The RFC server seems to be ok side BW and BODS.

But when I launch my BODS Job, my process chain in BW doesn’t start.
I have this trace from BODS:

At the end, I must abort the BODS Job.

Do you have any hint?

Regards

Etienne (BOB member since 2014-01-16)

2

When you created the open Hub table, did you check the box to “execute Process chain before reading data”?

We had such jobs, and prior to let DS fetch the data, the open hub must be filled with data, which you usually do by executing a SAP Process chain.

This can be checked when looking at the OH table in a DF:
Ticke the box “execute process chain before reading” and specifiy the processchainname
OHTABLESETTING_2014-01-16_16-12-40.jpg

Bajiman :switzerland: (BOB member since 2011-05-19)

3

Thanks for your reply.
My parameter are in this attachment.

I already checked this box and I selected my Process Chain.
But I have the same issue.
Param.JPG

Etienne (BOB member since 2014-01-16)

4

How did you define the process chain in BW?
Will it be schduled/triggered by “Start Using Meta-Chain or API”?
Is the chain activated?

Bajiman :switzerland: (BOB member since 2011-05-19)

5

Hi,

Yes I have created a process chain with a Start Variant with option “Start Using Meta Chain or API”. It runs just the DTP of the Openhub.

The chain is activated. I have checked the BW RFC trace when I run the job in Data Services and I see my CPIC user connecting and giving RFC commands:

But in sm37 no job runs. In sm50 no process. The Process chain doesn’t start …

Best Regards
Etienne

Etienne (BOB member since 2014-01-16)

6

ohhh…I’m running out of ideas.

Now…
the chain runs, when you start it from BW side?
Have you checked wether there are shortdumps in BI?
Does the DS user have enough privileges to execute a process chain in BI?

Now, back on DS side:
Can you view data in the open hub?

Have you installed the necessary function groups?(Z_AW*)

furthermore:
BO Data service uses in SAP BW an open hub (type 3rd party) to retrieve data. Thereby data services uses the function module RSB_API_OHS_REQUEST_SETSTATUS to confirm the request and set the overall status of the DTP to green. It may happen that data service can’t set the overall status. E.g. the system connection is broken. So the overall status stays in status yellow and no further DTP’s on the open hub can be executed.
The status of a DTP transferred to a 3rd party tool can not be changed in the display button in the DTP monitor, because SAP BW setup expects, that the status is set exclusively by the 3rd party tool.
Thus the status has to be set to ‘red’ manually with the function module ‘RSB_API_OHS_ RE-QUEST_SETSTATUS’. The function module changes the status solely for DTP’s of open hubs of type 3rd party tool. This procedure is described as a solution in SAP Note 1180294.

Hope this will help you finding a solution… :nopity:
Function Builder Initial Screen_2014-01-17_13-04-54.jpg

Bajiman :switzerland: (BOB member since 2011-05-19)

7

Hi Bajiman, thanks for your help.

I can start the Process Chain directly in BW. There are no short dumps. The DS has SAP ALL (we checked also by adding S_RS_OHDST )

From BODS we can see the Openhub’s data.

The function group ZAW0 with the Z_AW* function modules exist in BW.

The DTP doesn’t have status yellow because it never starts. The Process chain doesn’t start :frowning:

Best Regards
Etienne

Etienne (BOB member since 2014-01-16)

8

Hi Again,

in Data services management console → SAP Connections I have checked the RFC Server log and I got the next messages:

Any Idea of what the problem could be?

Best Regards,
Etienne

Etienne (BOB member since 2014-01-16)

9

Salut Etienne,

I have googled a little bit.
It points to something that I think might be the reason for your error.
Check the following thread:
http://scn.sap.com/thread/1646452

Hope this will help you.

Bajiman :switzerland: (BOB member since 2011-05-19)