Question Re: ST03N no data avaliable in Additional Q&A

ST03N no data avaliable

Former Member — Thu, 05 Apr 2012 06:30:20 GMT

Dear Experts,

In my QAS(quality) and PRD(production) the workload data is not getting generated.

however in my DEV(development) its getting generated.

i have checked all the settings in QAS like timezone,TCOLL table,SAP_COLLECTOR_FOR_PERFMONITOR job all the settings are same as DEV.

and in QAS when i click on workload collector data i am getting error as "No directory for QAS available" and i checked the stat file at the OS level and it is getting updated.

in the SAPWLSERV table also the data is showing correct.

Please experts help me on this to resolve.and let me know if any logs or any more information i need to provide.

Thanks,

Veeresh K R

Re: ST03N no data avaliable

Former Member — Thu, 05 Apr 2012 07:28:17 GMT

STEP1 : Go to ST03N

Follow the screen short and selection one by one

STEP2 : output like

STEP 3: If u want Trace like

Thanks and Regards

Periyasamy

Re: ST03N no data avaliable

nelis — Thu, 05 Apr 2012 07:51:49 GMT

Hi Veeresh,

The error "No directory for QAS available" seems to be indicating a problem with your directory parameters. I would execute transaction AL11 in your QAS and PRD systems and compare the directory parameters from your working DEV system. The stat files ST03N make use of are stored in /usr/sap/<SID>/<Instance>/data so check the directory parameters with this and compare them to your working system. It's possible someone may have accidently deleted one of these parameters used by the program.

Another thing I would also check is the stat/file and stat/as_file instance parameters and make sure they are pointing to the correct location. Use RZ10/RZ11 for this.

Regards,

Nelis

Re: ST03N no data avaliable

nicholas_chang — Thu, 05 Apr 2012 15:33:13 GMT

In addition, please ensure your system is in correct timezone for all clients.

Re: ST03N no data avaliable

Former Member — Thu, 05 Apr 2012 16:57:30 GMT

Dear All,

stat/file and stat/as_file parameters are correct and in al11 all the directory structure are correct.

Now i have found one new thing that the table SWNCMONIINDEX contains no data.

Dear experts correct me if i am wrong bcoz i am thinking that this is the reason behind the issue.

and let me know how to make the data to be updated in this table.

Thanks & Regards,

Veeresh K R.

Re: ST03N no data avaliable

Former Member — Thu, 05 Apr 2012 17:46:12 GMT

Veeresh,

I encountered the same problem 2 weeks ago. The problem was caused by invalid time zone date in client 000. As Nicholas, mentioned, check your timezones in client 000.

SA38 - Report name = TZCUSTHELP

SA38 - Report name = TZONECHECK

Note 198411 includes a data file to update the 000 tables. This note did not affect any other client and it fixed the problem that I encountered,

Cheers,

Rick

Re: ST03N no data avaliable

Former Member — Thu, 05 Apr 2012 17:47:44 GMT

Veeresh,

Please consider my response after resolving the "directory" message.

Rick

Re: ST03N no data avaliable

former_member189546 — Fri, 06 Apr 2012 14:35:49 GMT

Hello,

Check note

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

regards,

John Feely

Re: ST03N no data avaliable

Former Member — Sat, 07 Apr 2012 11:34:15 GMT

Dear All,

Thanks for the guiding me ...issue got resolved after deleting the historical data for st03N

ST03N--->collector & performance DB--->Performance database---->monitoring database--->contents

data like days h/2 weeks h/2 month h/2 deleted from moni key as per the note 997535.

executed the report SWNCCOLL from se38 and the data started collecting for today.

i will monitoring and let you know the status if any error again.

Thanks all again.

Veeresh K R