Re: Need in-depth help with usage analysis processing

From: Doug (dougpeterman_at_hotmail.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 10:35:37 -0500

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
> >
> >
> >.
> >

Loading