Start a Process Chain to run Data Service Job

[Former Member]

Hi,

I have a requirement to trigger Data Service Jobs from SAP BW.I have created a SAP BW Process chain and included 'general Services->Start Job in SAP BO DS' option to start the DS Job.However I am getting an error messgae 'Error in remote call of destination DS_BID' and displays the following:

'

The following error occurred during the remote function call for destination DS_BID:

handler for RSBOBJDS_JOB_GET_LOG was not installed'

Can someone provide some input to resolve this issue.

Thanks,

Purbali

[Former Member · Accepted solution]

Hi Purbali,

If your intension is to load BW by pulling data from DS, below link should give you an idea what are the pre-requisites and how to trigger the job in DS throu BW.

http://wiki.sdn.sap.com/wiki/display/EIM/Loading+BW

If you still face an issue, let the forum know. We will sort it out.

Thanks, Arun J.

[Former Member · Accepted solution]

Hi Arun,

Thanks for the reply .We are trying to extract data out from BW to DS and hence we need to trigger DS jobs once BW jobs are complete.Do you know of any function module that can help us to trigger DS jobs.

Thanks,

Purbali

[Former Member]

http://service.sap.com/sap/support/notes/1781660

[Former Member]

Hi Purbali,

It seems this issue is an connectivity issue. The RFC connection is missing beweeen BW and BODS. Check with the BAsis and get it resoolved

[Former Member]

Hi Saimukesh,

There is no RFC Connection issue becasue I am usng Open Hub/BW Process Chain to start DS Jobs.The DS Jobs get executed sucessfully.Now I want to trigger DS Jobs automatically after the daily BW Process Chain Jobs are complete.

We tried using the 'Execute DS Job' optiion available - however SAP has come back saying it is not yet functional now (maybe in future it will be OK).

Hence we need to know if there arr any other method to execute DS Jobs from BW.

Thanks,

Purbali

[Former Member]

Hi,

there are plenty of ways to call a DS job, which one is best for you I do not know, for example;

1) you could call the DS job via a batch file (on windows/script file on Linux)

2) you could surface the DS job as a webservice and call that

3) if you are waiting for the BW process chain to finish, is there a table somewhere which has a status field updated once complete?  If so have a DS job running and polling that table for the updated status

lots of options but difiicult to say which is best for your situation without more detail of the requirement.

regards,

Adrian

[Former Member]

Hi,

We are trying out all the possible options.Our scenario is to start the DS Jobs (about 10 in number) daily after our daily BW Process chain completes.DS jobs extract data from BW - Open Hub to other external location.We are trying the following option:

1. Using the .bat file - this executable file gets generated at a path and doesn' t get executed on double click at the server side.If this was working then we could call an external command option to call this .bat file. Can you provide us details of this process (incase we are missing any information/step)

2.We are trying to use a Function Module 'BAPI_ISOURCE_DP_REQUEST' but not getting the correct parameters.

3. We are trying to use  a trigger based approach - but the process of capturing the trigger on DS side involves quite a few steps.

Did anyone actually do this - can you please share us the steps involved in any one of the methods above.

Thanks,

Purbali

[Former Member]

Hi,

the bat file needs to be generated using the "export execution command" from the DS Mgmt Console and it needs to be run from the DS Job Server machine.  You should be able to use a UNC share to call it remotely.

The trigger based approch is easy, DS job scheduled to run about the right time every day, simple loop which tests a value in a column in a table (or other handshake mechanism), maybe errors after 20 attempts, if ok then proceeds with the job. 10 minutes coding in DS maximum.

I have not used the function module you mentioned so cannot comment on that.

regards,

Adrian

[Former Member]

Hi,

Do you have a sample code to run the .bat file from BW server side?

We tried using the trigger base approach and it is working but I would preffer using the .bat option.

Thanks,

Purbali

[Former Member]

Hi Purbali

I dont know about code to call .bat file from the SAP BW side but

just a thought..... Create a datasource in SAP BW as BODS as source system with a single field may be flag and create this datasource as an output of your DS job. Create an infopackage

and you can schedule your DS job via this infopackage once your BW process chain is complete.

[Former Member]

Hi Purbali,

We have a simmilar situation , I have tried using the function module  but unable to trace the parameters which needs to be passed , Can you let me know wht parameters you have passed and also any other better way of doing it , Thank you !

vishu