Skip to Content
avatar image
Former Member

Scheduling SAP BI Process Chain

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 18, 2008 at 10:50 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Jul 14, 2008 at 04:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 15, 2008 at 01:37 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded