Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Scheduling a BI job chain in Redwood

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
Not what you were looking for? View more on this topic or Ask a question