Database Analysis in RCA for ABAP

[Former Member]

Dear Expert,

I have performed all managed system configuration steps for my Abap System in solman_setup.

In RCA  I am getting Workload analysis and host analysis properly ,but for Database Analysis it is showing no Application data.

Thanks In Advance

Chander

[Former Member]

hi Chandra,

I am facing same issue now in database analysis under RCA.

i am getting similar error for TOP SQL statements tab.

so, is your error fixed ? if so, how you did it ?

Thanks !!!

[Former Member]

Hi Krishna,

Sorry for late reply,but for my system it started working after entering correct DB parameter for Setup DBACockpit / DB extractors and make sure you can access your DB at  DB02 of Solman.

And check the DB connection at DB02 in solman for your satelite system.

Hope it will work for you.

Thanks

Chander Dubey

[Former Member]

Dear Experts,

As I mentioned in starting of this discussion that I am getting change and workload analysis but

In database analysis no data is coming,So I checked and found that in Extractor Framework DBMS extractor is running but in log is it is showing that zero records has been updated for all DBMS extractor.

Please refer screenshot for understanding.

Thanks In Advance

Chander

[Former Member]

Hello Chander,

Please check at solman_workcenter SAP solution manager configuration from left menu choose managed system conf. databases tab make sure that your DB is correctly configured.

In addition  please check note 1795169 - ABAP Statistical Data is missing from the Workload Analysis

BR,

K.

[Former Member]

Dear Kamil,

Data base configuration has been done successfully in managed system conf step,but still getting "no data" error.

Thanks

Chander

[Former Member]

Hello Chander,

Check pre-requisistes 1483508 - Solution Manager 7.1: Root Cause Analysis pre-requisites

especial LM-SERVICE level of Java stack.

BR,

K.

[Former Member]

Dear Kamil,

I am doing RCA for Abap system not for java and  able to get workload,change and host analysis for the same Abap system but no data for database analysis.

Thanks

Chander

[Former Member]

Hello Chander,

Kindly provide screenshots from Managed system configuration steps 5 enter system parametrs and 8 configure automatically.

BR,

K.

[Former Member]

Dear Kamil,

Please find the attached screen shots.

Thanks

Chander

[Former Member]

ello Chander,

Please provide whats your level of ST-A/PI on Solman and managed system ?

Also check notes:

1858216 - E2E Workload Analysis - No applicable data found for ABAP after successful configuration

1993916 - Missing data in a Bex query based on an InfoSet

1874166 - No host data under Root Cause Analysis for technical systems when the DB is standalone

BR,

K.

[Former Member]

Kamil,

ST-A/PI  version is for-

Managed system

Release -01Q_731  SP Level- 0002 SAPKITAB9L

Solman

Release -01Q_700  SP Level- 0002 SAPKITAB7L

Thanks

Chander

[Former Member]

In the managed system configuration have you performed the Database Extractor Setup in step 8-configure automatically?

[Former Member]

Dear Sunil,

Database Extractor setup step was already completed so that is not a issue.

Thanks

Chander