Scheduling SAP BI Process Chain

[Former Member]

Hello All,

I am trying to schedule process chains of SAP BI (BW).

A process chain named "CDE_TEST" has been created in BI in order to test the scheduling via Cronacle.

So we have done the following actions:

- submit successfully the RFC Agent on BI system

- submit successfully (?) the RSI_IMPORT_BW_CHAINS script: it had a completed status with a small output file (that contains only one line: "CDE_TEST /CDE_TEST")

- submit the the RSI_IMPORT_BW_CHAINS_DEFINITION script: it submitted by itself 2 others jobs: the first one was successful (it was the same as the one launched by RSI_IMPORT_BW_CHAINS) but not the second which shows either errors on RFC ("erreur RFCÂ : FAILED" and "Message RFCÂ : FAILED") or systems ("erreur RFCÂ : RFC_ERROR_SYSTEM_FAILURE" and 'Message RFCÂ : Function module "/SCJS/XBP_VERSIONS_GET_INT" not found.")

- submit the RSI_RUN_BW_CHAIN script, with default values, to run the "CDE_TEST" process chain. Then I get differents errors :

=> "erreur RFCÂ : RFC_ERROR_SYSTEM_FAILURE" and "Message RFCÂ : Message type 1 is unknown."

=> "erreur RFCÂ : FAILED" and "Message RFCÂ : FAILED"

=> "Exception : SYSTEM_FAILURE"

So I would like to know the pre requisites for these kind of functionnality. I mean, for example, it is mandatory to load the transport files in the BI systems to make this works ? or does this transport files have any effects on process chains functionnalities ?

Thanks you in advance for your help.

Regards,

Yi Jiang

[Former Member · Accepted solution]

Hi Yi,

You should not need any transport files to use Process Chains in your BI system. The Process Chain API calls however are sensitive to the language the RFC agent is running in, for instance you may get different results for RSI_IMPORT_BW_CHAINS if the RFC agent runs in different languages (if the process chains have been created by users connected to the SAP system using different languages).

Also the client you connect to is important of course.

Have you tried if simpler actions like running the ABAP SHOWCOLO or RSUSR000 are working fine ?

Regards,

Anton Goselink.

[Former Member · Accepted solution]

Hi Yi,

Which version of SAP BI you are using? Does it have XBP 2 or above?

- Bhushan

[Former Member · Accepted solution]

Hi All,

First thanks all for your help and sorry for the delay.

Here are some precisions:

- RFC Agent is correctly connected to SAP BW systems.

- Basic ABAP programs (such as RSUSR000) are successfully executed in BW Systems

- The SAP BI version is 7.0

- XBP 2 is used

I was told to do some user configuration in SAP in order to make the process chain run via SCPS: there is a part in the help of redwood explorer saying some specific instructions must be applied in SAP BI:

The quote :

"To check or set the SAP BW user for background processes:

Go to Administration > Settings > Customizing (transaction SPRO).

Click on SAP Reference Img (German: BIW).

Expand the tree to find BW Customizing Implementation Guide > Business Information Warehouse > Automated Processes > Create User for Background Processes. (German: BIW > Automatisierte Prozesse > Benutzer fuer Hintergrund anlegen.)

Click on the hourglass (Maintain Activity) for that row.

Fill in the new username, for instance: BWALEREMOTE."

Issue is now that these exact mentionned items and menu do not exist (?) or at least were not found in our SAP BW systems by our SAP Administrator. The help file do not mentioned the version of SAP BI. Is there a compatibility issue ? I mean we have for instance a defined user ALEREMOTE but do not know if it has the same authorizations than the mentioned BWALEREMOTE.

Have someone an idea of the problem encountered ?

Regards,

Yi Jiang

[Former Member · Accepted solution]

Hi,

The problem was solved.

The cause was that the RFC user of SCPS does not have enough authorizations (in BI Objects ODS, Cubes, etc.). After granting them in SAP, the "RSI_RUN_BW_CHAIN" runs successfully !

Thanks for your help anyway !

Regards,

Yi Jiang

[Former Member]

Assuming an active RFC connection into the BW system typically all you need to do is import the Process Chains with RSI_IMPORT_BW_CHAINS. And to run a Process Chain following a succesful import you only need to run RSI_RUN_BW_CHAIN. You do not need to run the script to import BW definitions.

You do not mention the version of CPS you are using but the error message concerning '/SCJS/XBP_VERSIONS_GET_INT' is indicative of a call to new Redwood function modules which do not exist e.g. between 7.0.1 and 7.0.3 the function module names were changed and the correct transports for your version will need to be reloaded so the correct function modules exist.

[Former Member]

Hi Yi Jiang,

Just check if the SAP BI system is connected successfully to your Redwood Cronacle scheduler. For this, follow below path in your redwood explorer.

Monitor -> jobs -> SAP agents

Here you will find the jobs connecting your Redwood repository with SAP systems.

Hope this helps.

Best regards,

Vithal