cancel
Showing results for 
Search instead for 
Did you mean: 

EWA Report errors - Collector

Former Member
0 Kudos

Dear all,

on my Dev SolMan I get the folllowing errors:

Performance of ABAP System DSM The hourly time profile of response times in the Workload Monitor (ST03) is missing for all application servers of the system. Chec 144864

Workload of ABAP System DSM No activity was measured in the workload monitor (ST03). Check the configuration for the monitor and job SAP_COLLECTOR_FOR_PERFMONI 144864

Performance of Database DSM This report does not contain the section 'Database server load from expensive SQL statements' because of incomplete data. SDCCN fu 1564508

I checked ST03N according to 144864 , and everything seems to be fine.

Also job SAP_COLLECTOR_FOR_PERFMONI is running and finishing OK.

Also as 1564508 says< I ve just updated the plugins ST-PI and ST-A/PI to the latest versions.

What do you advise ? What can i check more ?

Thanks in advance,

Daniel,

Edited by: Daniel_Bul on Feb 6, 2012 9:00 AM

Accepted Solutions (1)

Accepted Solutions (1)

jayanth_velugati
Active Participant
0 Kudos

Hi,

Check if your SAP Service content is updated. Run T-code AGS_UPDATE , click apply updates.

Rerun the service preparation tool in the Managed system where the data is missing.

Thank You

Jayanth

Former Member
0 Kudos

Hi Velugati,

I am trying to apply updates and I get a dump:

Runtime Errors SAPSQL_ARRAY_INSERT_DUPREC

Except. CX_SY_OPEN_SQL_DB

Date and Time 06.02.2012 10:40:11

Short text

The ABAP/4 Open SQL array insert results in duplicate database records.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLAGS_DSWP_GENERAL" had to be terminated because it

has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "AGS_DSWP_APPLY_SERVICE_UPDATE" "(FUNCTION)", nor was it propagated

by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

If you use an ABAP/4 Open SQL array insert to insert a record in

the database and that record already exists with the same key,

this results in a termination.

(With an ABAP/4 Open SQL single record insert in the same error

situation, processing does not terminate, but SY-SUBRC is set to 4.)

Can you please advise ?

Thanks

Edited by: Daniel_Bul on Feb 6, 2012 11:46 AM

TomCenens
Active Contributor
0 Kudos

Hello Daniel

You get a shortdump on procedure "AGS_DSWP_APPLY_SERVICE_UPDATE" so when you search on https://service.sap.com/notes for relevant SAP notes you find the following:

1. 0.390 SV-SMG-OP [1317901 Service content update |https://service.sap.com/sap/support/notes/1317901]09.12.2010

2. 0.230 SV-SMG-SER 1491227 Adjustments to service content update from ST 700 SP 23 17.01.2012

I'm pretty much convinced that one of these two search results (most likely the first) will solve your issue.

Just check which error message you have and which solution you have to use to resolve the issue.

Kind regards

Tom

Former Member
0 Kudos

Hi Tom,

I ve tried that also, now AGS is OK. but still EWA Report gray colour.

I am trying to followe note:

Solution

Implement the program corrections.

Important:

As long as the incorrect download is included in the session and has not been deleted, a dump occurs.

After you implement the corrections in the managed system,

you must collect the download again and send it to the Solution Manager.

Alternatively, you can create a new session after you implement the corrections and collect and send the download for this session.

How to collect the download again ? Maybe I am doing it wrongly.

Thanks in advance,

TomCenens
Active Contributor
0 Kudos

Hi Daniel

So you deleted the contents using RAGS_DSWP_SERV_CONTENT_RESET with the option "Remove content completely" and afterwards you went back to transaction AGS_UPDATE, you checked for updates, downloaded the updates and applied the updates and now all is green?

If not, please do so.

If done, then please check if the dump reoccurs. You can schedule a manual EWA run if needed to test.

Kind regards

Tom

Answers (0)