ST03N not showing latest data

[former_member209962]

Dear All,

We have a situation ST03N is not showing latest data rather it is showing old data.

our requirement is we need to provide a report showing in the month of august 2013 which user used which t code

In past we have provided these kind of reports from ST03N many times but this time i am surprised how come data is missing,

Our system is ECC6 EHP4 with Oracle as DB and Win2008 as OS

Thanks

Tabrayz

[IanSegobio · Accepted solution]

Hello,

This seem like a timezone issue indeed. There is another way to ensure whether the timezone settings are (in)correct (other than the standard report TZCUSTHELP). Few simple actions that can be performed in order to check that. These are the following:

- Click (menu) system >> User profile >> My data;

- Click on tab "Defaults";

- In the section "personal time zone", you'll see the system timezone and the user assigned timezone.     Set the user personal timezone to the exact same as the system timezone;

- Save and log out;

- Log in again and click: System >> Status;

- Look at the upper right corner of the new window, at the system time section. If there is one more line other than system time called TIMEZONE and showing a different time than the system time, your timezone settings need to be adjusted.

Cheers!

[Former Member · Accepted solution]

Hello,

Yes, it is correct! The reason:

The background job SAP_COLLECTOR_FOR_PERFMONITOR starts the program

RSCOLL00 and this program checks the TCOLL table for program which needs

to be started.

Workload collector program starting from system release 7.00 the

background job SAP_COLLECTOR_FOR_PERFMONITOR should always be scheduled

in client 000  and the #System Time Zone# which is maintained in the

transaction STZAC in client 000 should be exactly the same as the OS

time zone setting.
Please check Note:

#926290 - SWNCCOLL: SAP workload NW collector collects no data

Is the background job SAP_COLLECTOR_FOR_PERFMONITOR scheduled

in client 000 ?

The #System Time Zone# which is maintained in the transaction

STZAC in client 000 should be exactly the same as the OS time zone

setting.

SAP Notes:

#198411  -  Current data and information about time zones

#481835  -  Analyzing the time zone settings

#741734 - Incorrect times due to the time zone settings

BR

T

[Former Member]

Added...

Did you check the time zone. Did you changed it from any zone...like  CET to IST...

Also the daylight saving stuff.

BR,

Prabhakar

[Former Member]

Hi,

Did you check ST03N->Expert Mode->Load history and distribution?

Secondly make sure your saposcol and other standard jobs are running.

You can check the undo_tretentiontime at init<SID>.ora

that will be in oracle/SID/home/database

BR,

Prabhakar

[Former Member]

HiTabrayz,

Is this issue in a production system ?

or non production system, if it is in non production system, have you refreshed your system  iff so are the post installation tasks completed ?

Thanks,

Sanketh

[former_member182034]

hi Tabrayz.

Please check below thread. It might be helpful

http://scn.sap.com/thread/1946625

Regards,

[Former Member]

Hello ,

About ST03:The workload monitor reads the workload statistics from the
workloadcollector database. Various collectors must run at regular time
intervals so that this database always contains current data.

The background job SAP_COLLECTOR_FOR_PERFMONITOR starts the program
RSCOLL00 and this program checks the TCOLL table for program which needs
to be started.
Workload Monitor:

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/2d/b8be3befaefc75e10000000a114084/frameset.htm

If you want to see the transactions used by all users you can easily see this in the transaction ST03 and select the Transaction Profile view. If this is not what you want, please have a look at SAP note #1053634 which does describe an interface which can be used to read the information,
which can be reported by the transaction ST03, automatically.

BR

I.T.

[hasanajsh]

The reason may be the difference in Time Zone Settings between the SAP system and the Operating system.

Maybe you have changed something.

Could you check?

[jayanth_velugati]

Hi,

What I observer from the screen shot , Data collection was not happening form 18.05.2013 to 07.09.2013. So it makes clear that we don't have data for the month of August.

When did you restart your saposcol ?

Also did the job  SAP_COLLECTOR_Performance  was de-scheduled during this time period ?

If you have DAA agents installed and your system connected to Solman , you have an option to pull it from Root cause analysis from solman system(condition if the saphostagent and DAA were up and running during that period).

Regards

Jayanth

[former_member209962]

Well sap system is not restarted from past 7 months and saposcal is not stopped i was able to get august data only for 2 days when increased the retention time in st03n  .

[former_member183107]

Also,

If the jobs and the saposcol are running then go to ST03N switch to Administrator view -> Workload collector and check the log for errors.

ST03 does not always work properly because one of two batch jobs, SAP_COLLECTOR or SAPC_COLLECTOR_FOR_PERFMONITOR (i think this is the name). this job must be scheduled for every hour and should under DDIC...i think the batch job runs as ABAP program called RSCOLL00 (zero zero OR oo at the end) which basically refers to a table named TCOLL. This table contains number of ABAP programs that collect performance data for ST03....

Try looking into these tables, reports and jobs. Also, you may want to compare TCOLL from other system to this system to make sure everything looks the same.

[former_member209962]

No Errors and i did schedule SAP_COLLECTOR PERFMONITER job in 000 with ddic

but no luck

Thanks

Tabrayz

[former_member183107]

Hi,

Please check that you File system is not full. Thant might be the reason its not generating any logs.

Regards,

Himanshu

[former_member45419]

Dear tabraz,

please check the saposcol is running or not.

performance collector job is running or not.If its not running restart the application server it will work.

[AtulKumarJain]

Hi Tabrayz,

Could you please check the saposcol is running or not.
Check performcance collector job is running or not.

http://help.sap.com/saphelp_erp2004/helpdata/en/bf/0ae73ac6e7ec28e10000000a114084/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/c4/3a6bff505211d189550000e829fbbd/content.htm

Br
Aj

[former_member209962]

Hi Atul,

Both saposcol and SAP_COLLECTOR_Performance are running fine and timezone setting is also fine.

Thanks

Tabaryz

[AtulKumarJain]

Hi Tabrayz,

PLease check below link

http://help.sap.com/saphelp_nw04/helpdata/en/1f/8311e04bc511d189750000e8322d00/frameset.htm

best regards,

Atul

[former_member188883]

Hi Tabrayz,

Please check whether saposcol is running

Secondly check whether SAP_COLLECTOR_Performance jobs are running properly.

Regards,

Deepak Kori

[former_member209962]

Hi Deepak,

Both saposcol and SAP_COLLECTOR_Performance are running fine and timezone setting is also fine.

Thanks

Tabaryz