Scheduling a BI job chain in Redwood

[Former Member]

The problem I am having is we are trying to schedule a BI job chain via Redwood software and are not getting any response. Within Redwood, I have executed these jobs IMPORT_BW_CHAINS, IMPORT_BW_CHAIN_DEFINITION, IMPORT_BW_INFOPACKAGES using BI job chain 0fcsm_cm_10 which is defined in BI as a job chain. These jobs run to completion but nothing is moved into Redwood to schedule as you would see from a import of a CCMS job. When I run job RUN_BW_CHAIN using the same BI job chain ID I receive the below error. Not sure what I’m missing or doing with the process to get to schedule the BI job chains with Redwood.

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at "RSI.RSIEXEC", line 1638

ORA-06512: at "RSI.RSIEXEC", line 1759

ORA-06512: at "RSI.RSI_RUN_BW_CHAIN", line 21

ORA-06512: at "RSI.RSI_RUN_BW_CHAIN", line 80

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SYS_SQL", line 1200

ORA-06512: at "SYS.DBMS_SQL", line 323

ORA-06512: at "SYSJCS.DDL", line 1085

ORA-06512: at "SYSJCS.DDL", line 1118

ORA-06512: at "SYSJCS.DDL", line 1177

ORA-06512: at line 3

JCS-00215: in statement RSOJ_EXECUTE_JOB

[Former Member]

I am also seeing the same issue

anton the last information you requested

The following products are installed in the Cronacle repository:

Product Version Status

-

---

-

---

-

---

Cronacle for SAP solutions 7.0.3 Production

Cronacle Forecast Module 7.0.3 Production

Cronacle Reports Module 7.0.3 Production

Cronacle &module Module 7.0.2 development

Cronacle Mail Module 7.0.3 Production

Cronacle Audit Module 7.0.2 r2.2 Production

Cronacle Process Manager for Web 7.0.3 Production

Cronacle Module Installer 7.0.3 Production

Cronacle Repository 7.0.3.34 Production

Cronacle Monitor Module 7.0.3 Production

[Former Member]

Hi,

The two most likely causes of this error are:

- the process chain in BI is set to "direct scheduling": it needs to be set to scheduling via API or meta-chain

- the security of the RFC user used by CPS is not sufficient: please verify the security setup as detailed in the CPS documentation

To find out more about the cause, please check the messages in SM21 in the SAP system, you will probably find more information there.

Regards,

Anton

[Former Member]

Hi David,

Can you send me the output of the RW_SHOW_INSTALLED_OBJECTS script ?

I'll have a look if I can find the cause of the error in RSI_RUN_BW_CHAIN.

One answer: BI job chains are only shown when run through Redwood, ie. RSI.RSI_RUN_BW_CHAIN.

Regards,

Anton.

[Former Member]

HI David,

I do not think you are doing something wrong. But if you see the failed job in your system, it will have one more job (usually + sign for expanding). So in that child job, you will be able to find the exact error.

Request you to put that error.

Best regards.

Rajeet

[Former Member]

There wasn't a second job but the second part was had these errors on them.

RFC error: FAILED

RFC Message: FAILED

[Former Member]

Hi David,

Check the child jobs when RSI_IMPORT_BW_CHAINS finishes successfully. If you see any error, please let us know.

Please note that you should import a chain which does not have starttime and periodicity defined in BW Chain. These should be defined in CPS. Make sure the authorizations are sufficient for CPS to start the chain. When you schedule the chain, if you see any error in any of the child jobs please note that and let the forum know about it.

Can you please share those errors?

- Bhushan