on 06-09-2009 7:28 PM
While executing ST04 -> Performance -> Wait Event Analysis -> Filesystem Requests
The following error comes
Exception CX_DBA_ADBC in function unit C_GET_DB_ORA_FILESYSTEM_REQUES ( function group S_ORA_COCKPIT_5 include line 0 )
The database is Oracle.
I have seen SAP NOTE 1262645 under which the correction is delivered in the support pack SAPKB700018 but we already are on that support pack level.
Please suggest.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, it's a program error, you have to implement the note to fix it:
1465163 - DBA Cockpit: Overflow C_ORA_MM_GET_DATA/Instance Efficiency
Hi, can you check are this error generates dump in St22, any log in sm21 or in Oracle alert log ?
P.S. i'm see errors in ST04 in same navigation line, but error are other -->
Note 159510 - DBIF_DSQL2_OBJ_UNKNOWN: Table does not exist
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sergo
I already checked SM21 & ST22 . There was nothing there.
When i checked alert log there alos i find nothing.
The error description in note 159510 doesnot match our case.
But when i expanded the pop up Exception CX_DBA_ADBC in function unit C_GET_DB_ORA_FILESYSTEM_REQUES and scrolled further, i saw that it is trying to access a table or view that doesnot exist and it gives SQL Message: ORA-00942: table or view does not exist .
The view in question seems to be SAP$KCBFWAIT .
The method to create or replace this table/view is given in the note you mentioned.
I would try to implement it and see if it solves my problem.
Thanks
Anurag
Hi, I had exactly same problem as you. Solution described in Note 159510 - DBIF_DSQL2_OBJ_UNKNOWN: Table does not exist, worked for me. Simply create missing views with SQL statements in note:
create or replace view sap_$ksmsp as select * from x$ksmsp;
drop public synonym sap$ksmsp;
create public synonym sap$ksmsp for sap_$ksmsp;
grant select on sap$ksmsp to public;
create or replace view sap_$kcbfwait as select * from x$kcbfwait;
drop public synonym sap$kcbfwait;
create public synonym sap$kcbfwait for sap_$kcbfwait;
grant select on sap$kcbfwait to public;
create or replace view sap_$bh as select * from x$bh;
drop public synonym sap$bh;
create public synonym sap$bh for sap_$bh;
grant select on sap$bh to public;
That's it
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.