Skip to Content
0
Former Member
Nov 24, 2008 at 03:18 PM

Privileges on script from another partition

59 Views

Hello all,

I currently encounter an error when I try to execute a process chain using indirectly the script RSI.RSI_RUN_BW_CHAIN though a customized script.

Here is the idea: I use a script "P.S", that belongs to a distinct partition P, in which there is a dynamic call to the RSI.RSI_RUN_BW script with the jcs.submit procedure.

The error I get is:

ORA-20800: JCS-02001: object RSI.RSI_RUN_BW_CHAIN does not exist
ORA-06512: at "SYSJCS.SECURITY", line 3128
ORA-06512: at "SYSJCS.VAL", line 5817
ORA-06512: at "SYSJCS.VAL", line 6058
ORA-06512: at "SYSJCS.JCS", line 2890
ORA-06512: at "P.S", line 51
ORA-06512: at "P.S", line 110
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
JCS-00215: in statement RSOJ_EXECUTE_JOB

But works fine with any script in the partition SYSJCS for instance.

I have checked the privileges in my P partition and compared from an environment where the script P.S works; and notice nothing unusual.

Any clue about this error ?

Thanks for your help.

Regards,

Yi Jiang