Dbacockpit overview pane does not get populated

[Former Member]

Hi guys,

I have already gone through the several other threads on sdn which repeat the same issue here but I am not able to find a solution via them. Can any one give me some leads into this...

-- CHANGES DONE --

We applied all relevant support packs which were part of Support stack 13. This involved also patching SAP BASIS from 10 to 13. Also NW04S 700 kernel was upgraded to patch 114 (SAPEXE and SAPEXEDB SAR packages)

STATEMENT OF PROBLEM(S)

Tcode dbacockpit does not refresh data in the overview pane.

note: db02old still works and we are able to refresh stats from there but dbacockpit overiew pane does not get populated.

Also post support packs: “sap_collector_for_performance” runs successfully but reports in job log “database system is not supported”

When we do a refresh via dbacockpit, the job “refresh space statistics” ends with a “compute bcd overflow” dump.

CHECKS ALREADY MADE

--Note 1066044 – for the BCD overflow dump – does not help. We are already at BASIS pack 13 and the correction contained in the note is already in place. As

per the note since are already at BASIS SP13 we should not be facing this. Why are we facing this then ?

--Note 868063

Call report rsoracup; put in con_name=DEFAULT; operatio=CREATE;F8 – did this.

--Note 1002840.(checks done as per note)

a) Check if SAP_Collector_for_perfmonitor is scheduled hourly

It completes successfully but gives job log below

1/16/2007 12:06:14 Job started

1/16/2007 12:06:14 Step 001 started (program RSCOLL00, variant , user ID DDIC)

1/16/2007 12:06:14 Clean_Plan:Cleanup of DB13 Plannings

1/16/2007 12:06:14 Clean_Plan:started by RSDBPREV on server

1/16/2007 12:06:14 Clean_Plan:Cleaning up jobs of system xxx

1/16/2007 12:06:14 Clean_Plan:finished

1/16/2007 12:06:15 Database system not supported

1/16/2007 12:06:17 Job finished

Why ?? (we got oracle 10.2.0.2)

b) se16 -> table TCOLL. Check if entery RSORACOL exists.

It does exist as below

RNAME RSORACOL

RENUM 1

SYTYP S

ALTSY

DAYOW XXXXXXX

TIMOD XXXXXXXXXXXXXXXXXXXXXXXX

c)SE16 -> table ORA_MON_DBCON. Check for enrry con name: DEFAULT.

It does exist as below

CON NAME DEFAULT

STATUS A

MAX RUNTIME 1,800

MAX UPLOAD 1,000,000

LOG LIFE 100

DESCRIPTION Local database. R/3 system available.

d)se16 -> table db02_coll_plan. Check if all the entries have status A and there are 64 entries. This is ok

--Note 1042725

SE16-> PROGDIR for Name= 'LSDBORA3F03'; Set field EDTX to blank

All entries have EDTX blank but there is no entry 'LSDBORA3F03’

Despite all the above checks I am unable to get the dbacockpit to refresh. Does anyone have any ideas. Will putting in the latest DBSL shared library patch for oracle solve this... I did SAPEXE and EXEDB.SAR latest. Any ideas...?

Cheers, Vikram

vikramr2k@gmail.com

[Former Member · Accepted solution]

did you execute the oracle scripts according to the following sap note?

<b><i>706927</i></b> - Oracle DB-Mon: Installation script for ST04N/DBA Cockpit

see please following thread:

best regards

Baran

[Former Member · Accepted solution]

Hi Baran, thanks for the input.

I checked out that sdn thread. I have done all the checks as per that thread . Did not help.

My RSCOLL0 job gives a log "the database system is not supported"

And the refresh job via dbacockpits ends in a bcd overflow dump.

Also note Note 706927 - Oracle DB-Mon: Installation script for ST04N/DBA Cockpit says it relates to using the database monitors ST04N or DBACockpit as of Oracle 9i/RAC.

We are running oracle 10.2.0.2 not 9i. Also i get values in ST04 but not DBACOCKPIT.

Note is interesting, I need to check with SAP before I run scripts at oracle level as the note is not exactly meant for 10g.

regards, Vikram

[Former Member · Accepted solution]

Hello Vikram,

you should implement the sap note <u><b>706927</b></u> -<i> Oracle DB-Mon: Installation script for ST04N/DBA Cockpit</i> also for Oracle 10.2.0.2 databases.

Best regards

Baran

[Former Member · Accepted solution]

Yes Baran thanks, I am working on getting that note in. I shall let you know after I do this. If it works I will reward you generously )

Thanks !! , Vikram

[Former Member · Accepted solution]

Hi i am having the same issue after support pack 12 did yuo ever find a fix for the issue?

[Former Member · Accepted solution]

For this issue it's still not working for me in Sanbox BI. I got a SAP message open for this. But I got it to work on Dev and TST systems. There was one mistake I was making. This may not be the cause though but just for your info. When we go to dbacockpit, click on collector setup icon. And there when we give connection name = "default" and then action as "create connection", I was not saving the variant. Click save and give a name to the variant like "refresh stats" or something. Then click refresh icon so that the "Refresh space statistics" will run in background. When I saved the variant on dev and test BI I did not end with a BCD overflow dump for the "refresh space statistics" job.The refresh space stat job needs to find the variant name.And this then populated the dbacockpit -> space -> overview pane. Although the "perf for monitor" job still has log entries "db system not supported" that doesn't matter. It's probably a message we can ignore.

Also if you are still facing prob, check these.

• You say you are on SP12 which SP component are you referring to (stack number ?. BASIS ? BW ?). Make note I have done the support stack 13 which contains upto the BW patch upto 15 and upto BASIS patch 13. Note 1066044 says if you have BASIS 13 you won't face this problem .

• Is your "perf for collector" job running without issues. That is a prereq to the "Refresh space stats" job. Try to troubleshoot that as well. I think the refresh stats job has to find the data in table MONI which gets populated via "perf for collector" (RSCOLL00).

regards, Vikram