cancel
Showing results for 
Search instead for 
Did you mean: 

Getting exception CX_DBA_ADBC while executing ST04

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

when I excute st04, the error "Exception CX_DBA_ADBC in function unit C_ORA_MM_GET_DATA ( function group S_ORA_COCKPIT_2 include  line 0  )"happen,anyone could give me some advice?

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

It work's in my case. I hope it can help you. Regards.

Former Member
0 Kudos

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

Former Member
0 Kudos

Awesome Michael Skrobak, it worked for me.

Thanks

SM