Re: Need in-depth help with usage analysis processing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Iyaz (iyaz_at_invalid.msn.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 10:58:32 -0800

Maybe your Sharepoint Timer service is not running. MAke sure that this is
running and also running with the same account as the WSS Admin App Pool
account.
-Iyaz
"Doug" <dougpeterman@hotmail.com> wrote in message
news:ekUMmdU$DHA.3852@TK2MSFTNGP10.phx.gbl...
> Kim,
>
> Can you take a look at your database and tell me a couple things:
>
> In your configuration database Sites table what is the value of the
URLPath
> for your site?
>
> In your content database Sites table what is the value of the FullURL for
> your site (the top level site has a ParentWebID of NULL)?
>
> I took a deep dive into the data yesterday and noticed after creating a
new
> site on a new port (i.e. www:81) that the configuration db Sites table had
a
> URLPath of '/' and the FullURL for the site was blank (i.e. empty string).
> In my site which was not updating, the URLPath was blank and so was the
> FullURL. I set the URLPath to '/'. I also found at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/spptsdk/html/tsdbtbWebs.asp?frame=true
> DayLastAccessed field: Sites that have never been used or that have never
> had their usage data processed for some reason will have this field set to
> 0. I went into the content db for my site and set the DayLastAccessed to
0.
> This morning I set the analysis processing to occur between 8 & 9 am. I
> didn't see the stored procedure kick off in that period. At about 10am I
> looked at the site usage report and indeed it updated. Now I'm unsure as
to
> what condition I fixed so that it fires, why it didn't show the update
until
> an hour after I told it to process and if creation of the second site on a
> different port was a factor...
>
> I tried this all in a VM environment, now I need to try and replicate it
> which is no small task. If you can try these steps and report back we
might
> just nail it down. I'd suggest you try looking at the database tables
first
> and NOT create a second site, if your data looks straight and it still
> doesn't update, then try adding a second site on a different port, wait 26
> hours and take a peek...
>
> Thanks. I now have a glimmer of hope, not much mind you, no warm fuzzies,
> but a glimmer...
>
> "Kim" <anonymous@discussions.microsoft.com> wrote in message
> news:31c101c3fd19$11206010$a301280a@phx.gbl...
> > I am having the same problem, cannot see anything wrong
> > with my configuration and cannot find any reference on the
> > web for this problem (save yours). Are we the only two
> > idiots in the world using it :( I sincerely hope there is
> > some intelligent person out there who can help. So
> > frustrating!
> >
> > >-----Original Message-----
> > >Can someone explain the dependencies for proper
> > functionality of usage
> > >analysis processing?
> > >
> > >I've migrated site content from a dev to production
> > environment and
> > >everything looks great but the usage analysis processing
> > is not updating.
> > >
> > >This is not a basics question - I need to understand
> > what's going on under
> > >the hood.
> > >
> > >logging is enabled
> > >usage analysis processing is enabled
> > >everyone has permissions to the log file directory
> > (default)
> > >I see log files that are being updated in the directory
> > >I see in the configuration database virtualservers table
> > that usage
> > >processing is enabled for my vs (<property name="job-
> > usage-analysis"
> > >value="daily between 11:00:00 and 00:00:00" />)
> > >
> > >I'm wondering if there are dependencies as far as the
> > site hostname. For
> > >example, if the server was extended and content created
> > from http://www vs.
> > >http://127.0.0.1 vs. http://www.example.com would
> > browsing activity to any
> > >of these URLs be cumulatively reflected in the site usage
> > or just whatever
> > >url the site was created from?
> > >
> > >I'm also wondering how it works in detail - is it kicked
> > of by the SPTimer
> > >service - and if so are there dependencies on what
> > account that is running
> > >under etc?
> > >
> > >When I create a new virtual server/site, how long does it
> > take before usage
> > >analysis starts on my new site?
> > >
> > >I appreciate any help on this - it's the final piece of
> > the puzzle.
> > >
> > >Thanks.
> > >
> > >-Doug
> > >
> > >
> > >.
> > >
>
>

Relevant Pages

  • Re: Missing space
    ... higher usage than du is that 1) df takes into account the disk ... Subject: Missing space ... Bad Inode Map ...
    (AIX-L)
  • Re: Trending
    ... UsageDate ... populate the data and then run queries and report? ... That's what queries are for. ... I have a table with a list of account numbers. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need in-depth help with usage analysis processing
    ... It is running and under the same account as the WSS Admin App Pool ... In my previous post I stated that the usage report did update today, ... >> In your content database Sites table what is the value of the FullURL ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Barclays Cycle Hire Overcharges £150 for 30 minutes
    ... overheads and management and charging fees, ... usage by a downward taper. ... I became a member of the scheme at the very first day, ... Things got worst when I went to check my bank account and noticed they ...
    (uk.legal)
  • Re: Trending
    ... Part of the learning curve that comes with making good use of Access is ... UsageDate ... the data and then run queries and report? ... I have a table with a list of account numbers. ...
    (microsoft.public.access.tablesdbdesign)