Skip to Content
0
Former Member
Mar 27, 2008 at 01:36 PM

BW - Invalid procedures

110 Views

Hi all,

From production to development instances of BW, I remark that all procedures are in invalid status. Those procedures are started as "/BI0/<number> and the owner is sapr3.

When recompiled those invalid objects, I got only this kind of error : PL/SQL: ORA-00942: table or view does not exist

I did verify 1 procedure, and effectively the table used in the procedure does not exist.

My questions are :

1) Is it normal that those procedures exist but the objects used donot exist ?

2) Can I drop those invalid procedures ? Do I need a consent of SAP support ?

3) In case I cannot drop them, how can I put them in valid status ?

Thanks for your input.

Hai-Thuy.