Open Hub Error RSBO211

[Former Member]

!Hello Gurus!

We're having som troubles using OpenHub services.

We're on

SAP_BW           7.31 SP8

SAP_BASIS       7.31 SP8

SAP_ABA          7.31 SP8

What We are trying to accomplish is exporting some data to a CSV file in a LocalNetwork directory.

SAPServiceSID user has full control to that directory

We designed the process as follows:

SAP Generic Extractor > Tx > ODS > [APD- BEx Query > Join > Write to ODS ]> Direct Write ODS > Tx > InfoSource > Tx > OpenHub

When I execute the DTP that throws data to the OpenHub it works perfectly fine and we get what we wanted.

If we add that same DTP to a process chain and schedule it. The result is a red process over the DTP with the following Messages:

Error 6 when writing to the local workstation

Message no. RSBO211

Error while updating to target ZMM_OHPR (type Destino open hub)

Message no. RSBK241

Operation  could not be carried out for

Message no. RS_EXCEPTION120

Exception CX_RS_FAILED logged

Message no. RSBK228

Exception CX_RS_FAILED logged

Message no. RSBK228

We have already tried what is suggested in :

And nothing has helped.

We suspect it has something to with

• SAP Conditional security or something like that or
• User permissions (We detected that whan I execute the proccess mannualy the target file gets modified by my Windows AD user)

But yet have not found any answer.

I beg of you dear Guru's please help us!

[former_member186053 · Accepted solution]

Hi Federico,

Also please take a look at the below sap notes might be helpful to you.

1585460 - Error when running DTP to 3rd party Open Hub Destination

1963318 - DTP does not run in process chain (RSPC057 & RS_EXCEPTION120) but does run

Regards,

Vengal.

[Former Member · Accepted solution]

Hello I did try as son you posted it, unfortunately it was not helpful as all the transformations related to this were active (ACT) and in active version (A).

[Former Member · Accepted solution]

Hello Vengal B

After we Upgraded SAP BW to SP 14 the second note you added and by doing as suggested by one of the other forum posts, the solution to this is:

• SAPService<SID> user must have permissions on the target file path
• You should create a logical file name in order to write using a Process Chain
• NOTE: it only worked with aoutomatically generated Transformation and DTP.
  

[Former Member · Accepted solution]

Hi Federico

Create new DTP and then trigger, it will work fine.

[Former Member]

Hi,

Please try to execute the process chain with execution server as the central instance (process chain ->attribute->background server?

Thanks.

[Former Member]

I'm not sure about how to acheive this what you say.

You mind being a bit more especiffic on what to do?

[Former Member]

Hi,

Please try the following:

* Process chain ->Attribute->execution user is specified with a BW background user.

* Process chain ->Attribute->Background server (select the server name same that you see in your task bar when you expand). This step is applicable if you have more server.

Thanks

[Former Member]

Hi Guys,

We are facing a problem while running the process chain in dev system.

We have created the process chain on open hubs destination as our local work station.

Can anyone please let me know whether we can include in the process chain.

Info cube-->OHD--->Local Work Station, this process should run in process chain.

Please suggest whether its feasible.

Many Thanks

Ravi

[Former Member]

Hello Ravi,

The user SAPSERVICE must have persmissions to write. please, read the nothes above, they will really help you out.

[Former Member]

Hi Federico,

Can you please let me know which is the relevant notes.

Thanks

Ravi

[Former Member]

Ravi,

My suggestion is for you to have a clear understanding on how does Open Hub works.

If you are trying to get info in a CSV format from BW, then you are using the wrong tools, BEx is more suitable.

If what you want to do is export information to another database, then you needn't to use a CSV, because OpenHub can write on database tables directly.

[Former Member]

Hi Ravi,

The background process is not allowed to write to local workstation. To write a file to local work station it will need GUI services and GUI services are not allowed in back ground work process.

Instead if you use AL11 directory (file system from application server) (directly or via logical file name) it should work.

If you want to write the file to a network file server, that server can be mounted in SAP ( by basis team) and after that you can access the same via AL11 using process chain.

Thanks.

-J

[sander_vanwilligen]

Hi Frederico,

The error message "Error 6 when writing to the local workstation Message no. RSBO211" (i.e. the first message) is the crucial one. It indicates a problem with writing the file.

I expect that it has to do with either permissions of the SAP system user for the respective directory/file destination or authorization of the background user.

For the permissions of the SAP system user, please check together with SAP Basis colleagues what could be the issue. Try perhaps another shared directory which is used for other purposes.

For the authorization of the background user I suggest to do an authorization trace using t/code ST01.

Best regards,

Sander

[Former Member]

Sounds like a bit of a fair answer

We do not have a BASIS team to help us, so this has become our issue

I have never used this tcode, if you could direct me to basic steps, manual or tutorial about this tcode it'd be very much apreciated.

For the note, we've given "Full Control" to SAPServiceSID user and also the other users existing inside our server

[sander_vanwilligen]

Hi Frederico,

Please review the following documentation re. the Authorization Trace using t/code ST01:

• Authorization Trace in transaction ST01;
• SAP Help.

Best regards,

Sander