ST03N no data available

[Former Member]

Hello all,

No data is displayed under Total in ST03. The background job SAP_COLLECTOR_FOR_PERFMONITOR is running fine every hour. SAPOSCOL is running as well. Can anyone please advise on this ?

SAP_BASIS - 702 - SP13

Thanks,

Sandeep S

[Former Member · Accepted solution]

Hello all,

Everything seems to be normal in the system, but ST03 is not displaying data.

Regards,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

ST03 does not have any data at all or only TOTAL data are missing? Could you please check statistics in STAD if you see data there?

Regards,
Alwina

[Sriram2009 · Accepted solution]

Hi Sandeep

Could you refer the SAP note compare the time zone

2006897 - How to compare timezone settings between OS and application server with report TZCUSTHELP

Regards

Sriram

[alwina_enns · Accepted solution]

Hello Sriram,

the easiest way to check if the time zone in the SAP system matches time zone on OS level is to check time stamp in "System --> Status". If the time zone settings do not match in SAP system and OS level you will see 2 lines here for "System time" and for "Time zone". "System time" comes from OS and "Time zone" comes from SAP system, and one should set the same time zone in the transaction STZAC in all clients (000 and productive clients) and on OS level.

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

Only TOTAL data is missing. Well I can see data in STAD.

Thanks,

Sandeep S

[Former Member · Accepted solution]

Hello Sriram,

The timezone between the application server and os looks great.

Thanks,

Sandeep s

[alwina_enns · Accepted solution]

Hello Sandeep,

is it a big system? Could you please check ST22 for memory dumps for user DDIC? TOTAL statistics is calculated by the report SWNCTOTAL, is this report scheduled in TCOLL?

Regards,
Alwina

[Sriram2009 · Accepted solution]

Hello Alwina

What you said is correct, In NW 7.00 version you may not see the Time Zone. So in this case you can execute the report to find the time zone.

Regards

Sriram

[Sriram2009 · Accepted solution]

Hi Sandeep

After that just execute the program RSCOLL00 , then try for transaction code  ST03 /ST03n

BR

SS

[alwina_enns · Accepted solution]

Hello Sriram,

if you do not see "Time zone" it means, that time zone setting on OS level and in SAP system matches. You can try it out, you can set a wrong time zone in STZAC, restart the system and check "System --> Status", you will see the line with "Time Zone".

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I don't see any memory dumps in the system and the report SWNCTOTAL is available in the table TCOLL.

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

could you please try to execute SWNCTOTAL report manually in the transaction SE38 in client 000, does it run without problems?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Sriram,

As you said I ran the report TZCUSTHELP and the message was "System time zone seems to be correct" and "UTC timer seems to be OK.".

Thanks,

Sandeep S

[Sriram2009 · Accepted solution]

Hi Sandeep

We have solved the same issue in our new test system.

1. Could you share the SAP system version details? once again you can execute the same report TZCUSTHELP in working client (not on 000 client)

2. After that have you schedule the background job in working client(Not on client 000)

"SAP_COLLECTOR_FOR_PERFMONITOR" execute once,

3. check the ST03

Regards

Sriram

[Former Member · Accepted solution]

Hello Alwina,

Thanks a lot. I executed the report SWNCTOTAL in client 000 and it was able to pull in some data. Now few data is available in ST03N under TOTAL. Do I need to schedule the report every one hour in order for the report to pull in all the data ?

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

this report should be started by the job SAP_COLLECTOR_FOR_PERFMONITOR according to the entries in table TCOLL. As I see in our systems it should be started every 3 hours and TCOLL looks like this:

If TCOLL in your system does contain these entries and you can execute SWNCTOTAL without problems, then you should find out, if SAP_COLLECTOR_FOR_PERFMONITOR starts this report or not. Under

ST03 --> Collector and Performance DB --> Performance Monitor Collector --> Log

and then double click on an entry you see, which reports are started at each workload collector run. Do you see SWNCTOTAL under the started reports?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I can see only the following reports are executing.

RSAMON40

RSDBPREV

RSDB_HRLY

RSHOSTDB

RSHOSTDC

RSHOSTPH

RSICFDLT

RSICFDMN

RSICFJOB

RSLDQREORG

RSN3CRAWLR

RSORACOL

RSORAVSH

RSRFCDMN

RSSTAT61

RSSTATPH

SWNCCOLL

Can I schedule the report SWNCTOTAL every three hours ?

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

no, it will not be the correct way to start the report, in case of troubles it will not be supported. Could you please check all logs from today, since it should be executed only once per 3 hours you will not see it in each log. Please check in TCOLL at which hour it should be started and please check job log of SAP_COLLECTOR_FOR_PERFMONITOR at this time if an error is reported for SWNCTOTAL. Could you please check also SM12 for client 000 if you see a lock for user DDIC?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I checked today's log and I don't see the report SWNCTOTAL being executed. And there isn't any lock for the user DDIC. Why is the job SAP_COLLECTOR_FOR_PERFMONITOR isn't triggering the report SWNCTOTAL even though that report is available in the table TCOLL ?

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

could you please paste a screenshot about TCOLL, I would like to have a look, how SWNCTOTAL is scheduled?

Could you please check also workload collector log under ST03 --> Collector and Performance DB --> Workload Collector --> TOTAL collector --> Log, do you see any errors here? Please check also "Control" section in this path, is collection of the TOTAL data configured here?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I have pasted the screencap of TCOLL in ST03.

Please advise on this. And ST03 is not displaying last few months data. Is there any report that I should run ?

Thanks,

Sandeep S

[Former Member · Accepted solution]

For SWNCTOTAL change number to 1. In general you can check settings according to SAP Note 966309 - Content of table TCOLL in SAP_BASIS 700 - 7.02 and 7.31+.

[alwina_enns · Accepted solution]

yes, this is the reason, why SWNCTOTAL is not started, the number should be 1

[alwina_enns · Accepted solution]

Hello Sandeep,

for the month data - since which time the workload collector job is running? It will collect the data from its first run. And what are the retention times? Could you please check retention times according to KBA:

1843151 - ST03 Data Retention Time Settings

http://service.sap.com/sap/support/notes/1843151

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

Thanks a lot. I have just changed the report SWNCTOTAL value to 1. And I have checked the retention period and it is 3. But the data for last 3 months are not displayed.

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

is the monthly data not collected at all or is the data available for last month? Since which time the workload collector job SAP_COLLECTOR_FOR_PERFMONITOR is running? If you do not have daily and weekly data for the last 3 month it will not be possible to calculate these data, these data is lost.

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I can see only this month data. The SAP_COLLECTOR_FOR_PERFMONITOR is running without any issues for months, yet I don't see the data for last 3 months.

Thanks,

Sandeep S

[divyanshu_srivastava3 · Accepted solution]

Hi Sandeep,

Did you check the retention period and other parameters I asked you to look into ?

Regards,

Divyanshu

[alwina_enns · Accepted solution]

Hello Sandeep,

could you please attach a screenshot about retention times and could you please let me know the time stamps for the data for "This month"? Please open the workload overview for the "This month" data and what do you see in this sections for time stamps:

Had the system an issue with time zone settings in the past?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

Below is the retention period for "this month". Sorry, I have no idea whether the system had issues on time zone or not in the past.

Thanks,

Sandeep S

[Former Member · Accepted solution]

Hello Divyanshu,

The retention period for month is 3.

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

the data start on 07.08.2014, do you have job logs in SM37 for workload collector on this day, why it started collect monthly data only on 07.08.2014?

And I would like still to have a look at retention times for monthly data.

If you do not have daily and weekly data for the time before 07.08.2014 you will not be able to retrieve the monthly data anymore and you have to wait until September, if the monthly data will be collected for August and September.

Regards,
Alwina

[alwina_enns · Accepted solution]

Hello Sandeep,

and what about weekly data, what are the oldest weekly data, do the data start also on 07.08.2014?

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

I couldn't see the job log as sm37 is displaying only last 10 days data. I am sure that the job ran even before 7th. And I checked for weekly data and it doesn't have data before 7th, it has data only from 7th.

Thanks,

Sandeep S

[alwina_enns · Accepted solution]

Hello Sandeep,

something has changed on 07.08.2014 so that workload collector has started to collect data. The SAP kernel writes statistics into stat* files in DIR_DATA directory, these data are available for 48 hours, workload collector reads these files and aggregates data in ST03. So if you do not have any data in ST03 before 07.08.2014 these data is not available anymore in the system.

You have to keep an eye on ST03 now, if the data will be collected according to retention times starting from 07.08.2014.

Regards,
Alwina

[Former Member · Accepted solution]

Hello Alwina,

Thanks for helping me to fix this issue and understand more about ST03.

Thanks all. I am closing this thread.

Thanks,

Sandeep S

[divyanshu_srivastava3]

Hi Sandeep,

Please reschedule this standard jobs if everything is correct from your side.

Also,

check before part of ST03.

[Former Member]

Hello Divyanshu,

I already have rescheduled the job "SAP_COLLECTOR_FOR_PERFMONITOR" in 000 client..No luck

Thanks,

Sandeep S

[divyanshu_srivastava3]

Hi Sandeep,

Can you check the value of there parameters

stat/level

stat/bufsize

stat/file

stat/max_files

And your MONI table ?

Check you check the error message in that screen ?

Schedule from you main client and copy of DDIC.

Regards,

Divyanshu

[Former Member]

Hello Sandeep,

Did you try to notice the error mesaage at the bottom of the gui screen ???..if yes, what does it say..

****************************************************************

For Example:

Try to access the function "Collector & Performance DB -> Workload Collector Databse -> Contents" from ST03N:

At the bottom of the gui screen, what is the error code......

Error codes: 

     1 Only one selection is possible

     2 No data available

     3 Internal error

     4 RFC problems

     5 Function module not available in remote system

     6 Other error

******************************************************************

Please let us know further..

Regards,

Deepa.

[Former Member]

Hi Sandeep,

Go to st06 ->click on operating system collector and start it.

After doing so restart your your instance.

Regards

Dharmendra

[alwina_enns]

Hello Dharmendra,

but operating system collector does not collect total workload data for ST03. This is done by the report SWNCTOTAL, which is scheduled in the table TCOLL and is started by the workload collector job SAP_COLLECTOR_FOR_PERFMONITOR. If only TOTAL statistics is missing, then very often this is because of huge amount of data and one should find memory dumps in ST22 for SWNCTOTAL report in this case.

Regards,
Alwina

[Former Member]

Dear

Check you scheduled job properly and check no cancelled job displayed named as RSSTAT83

and job scheduled with super user who has all right for all modules like sap_all and sap_new

some we scheduled job with user who don't have full right see what error it shows in st22 dumps

and sm21 u will get some logs  and u can make trace on for one hour to find what went wrong

better u schedule job with DDIC user also check timezone of your server

Regards

[alwina_enns]

Hello Rajendra,

the report RSSTAT83 is no more used, in the new releases the report SWNCCOLL is used instead.

Regards,
Alwina

[former_member186228]

Hi,

Check SAP Note:  966309

Regards,

Jithin M

[Former Member]

Hello Jithin,

Thanks for the note. All the reports listed in the SAP note are available in TCOLL table.

Thanks,

Sandeep S

[former_member186228]

Hi,

Ensure the report RSSTAT83 is scheduled hourly.

Regards,

Jithin M

[Former Member]

Hello Jithin,

The report RSSTAT83 isn't scheduled in the system and well I tried running it in SA38, but it threw a dump "LOGDB_SSCR_NOT_FOUND". Is it necessary to be scheduled ? In one of the systems with the same component level, the report isn't scheduled and the data is available in ST03.

Thanks,

Sandeep S

[former_member186228]

Hi,

Try to update kernel and check it is working or not.

Regards,

Jithin M

[Former Member]

Hello Jithin,

The Kernel is in the latest level. 720/600

Thanks,

Sandeep S

[alwina_enns]

Hello Jithin,

This report is obsolete as of release 7.00.

Regards,
Alwina

[Former Member]

Hello Haseena,

The system is not popping up the message "No system load data available" in ST03 and the time zone seems to be fine.

Thanks,

Sandeep S

[former_member225142]

Hi Sandeep,

Could you please provide the job log of SAP_COLLECTOR_FOR_PERFMONITOR job?

Regards,

Meenu Hans

[Former Member]

Hello Meenu,

I have pasted the job log for SAP_COLLECTOR_FOR_PERFMONITOR below

Job started

Step 001 started (program RSCOLL00, variant , user ID DDIC)

Retrieving history data for system SID

Hist_Perf:Collection of DB Performance History

Hist_Perf:started by RSDBPREV                      

Hist_Perf:finished

Hist_Config:Collection of DB/DBM Config. History

Hist_Config:started by RSDB_PAR                     

Hist_Config:finished

History_BP:Collection of Buffer Pool History

History_BP:started by RSDBPREV                  

History_BP:finished

Clean_Plan:Cleanup of DB13 Plannings

Clean_Plan:started by RSDBPREV                     

Clean_Plan:Cleaning up jobs of system

Clean_Plan:Cleaning up jobs of system

Clean_Plan:Cleaning up jobs of system

Clean_Plan:Cleaning up jobs of system

Clean_Plan:finished

Job finished

----------------------------------------------

Job started

Step 001 started (program RSCOLL00, variant , user ID DDIC)

Retrieving history data for system SID

Job finished

Thanks,

Sandeep S

[Former Member]

Hello Divyanshu / Jithin,

Thanks. The time zone looks good and the job is running in client 000 DDIC user.

Thanks,

Sandeep S

[former_member186228]

Hi,

Have you checked the timezone consistency by running report TZONECHECK.

Regards,

Jithin M

[Former Member]

Hello Jithin,

Yes. I just ran the report TZONECHECK and there is no issues.

Thanks,

Sandeep S

[Former Member]

Hello Sandeep,

Please have a look at note:  1888095 - ST03/ST03N gets popup "No system load data available".

[former_member186228]

Dear Sandeep,

Please cross check time zone of your server.

Regards,

Jithin M

[divyanshu_srivastava3]

Hi Sandeep.

Please check:

Check job is scheduled with correct user and client.

Regards,

Divyanshu