Data Services - Open hub read - No Open Hub DTP error

[former_member192142]

Hi,

I have created a open hub destination in BW (7.0 SP21), created transformation, DTP and process chain. In Data Services (3.2) I have created flow, job etc. and every thing seems to be as expected. However when I start the job in DS it terminates with an error:

1136 5624 BIW-230334 13-11-2009 12:28:22 Process Chain <ZTEST2> of Open Hub destination <ZTEST> at SAP system <.......> no more contains Open Hub DTP. Please reimport the Open Hub destination to execute the appropriate Process Chain.

I've tried re-activating everything in BW and also re-importing the OHD in BW, but nothing works. I've even tried to re-create everything from scratch. The process chain I've created do indeed contain an Open Hub DTP.

One addtional question: I've activated the process chain, but do I also need to schedule it in BW (like you do with e.g. process chains for time points to be used in Broadcasting)? Note, I've tried both scheduling/no scheduling and does not work either way.

Any ideas/suggestions?

Thanks in advance,

Jacob

[sundeep_chalasani]

Test your Open Hub conenctivity to the third party system using the available API

Go to SE37 and execute the below

RSB_API_OHS_DEST_SETPARAMS

Input the required parameters on how you named your BW objects and the RFC conifgured to conenct from BW to the DS

[ajit_dash]

You must implement following SAP Notes in SAP systems in order to make Data Services Open Hub functionality work correctly:

SAP Note 1270828 : (Open Hub Process chain is not imported into Data Services repository).

SAP Note 1294774: (Open Hub import failed - when you call the module RSB_API_OHS_DEST_SETPARAMS, th system tries to open a GUI)

SAP Note 1330568 version 3: (This note has fixed "Process Chain <ZTEST2> of Open Hub destination <ZTEST> at SAP system <.......> no more contains Open Hub DTP. Please reimport the Open Hub destination to execute the appropriate Process Chain").

SAP Note 1079698 - 70SP16 (Enable check box "Automatically Repeat Red Requests in Process Chain" in the DTP Execute)

SAP Note 1346049: (Error 028(OSOH): Request <n> cannot be locked.)

SAP Note 1338465 #with 1293589 as pre-requisite: (The ABAP/4 Open SQL array insert results in duplicate database records.)

SAP Note 1342955: (0 data records transferred)

Edited by: Ajit Dash on Nov 13, 2009 10:37 PM

Edited by: Ajit Dash on Nov 13, 2009 10:39 PM

Edited by: Ajit Dash on Nov 13, 2009 10:39 PM

[former_member192142]

Thank you very much for your answer - I will try to implement the notes and return with the result.

Thanks,

Jacob

[Former Member]

with all the SAP notes it works. To be honest not perfectly because it seems that there is a restriction of the qunatity of decimals?

The work around was do schange decimals to character and change it back to decimal in Bodi

Thanks

Birgit

[former_member194378]

Hi Jacob,

We are exactly facing the same error while triggering the process chain from BODS Job. and it is giving the same message for DTP. May i know how did you resolve this issue