Re: Need in-depth help with usage analysis processing

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kim Ellis (kimellis_at_mengyuan.com.au)
Date: 03/20/04 

Date: Sat, 20 Mar 2004 12:42:22 +1000

Mike, For the FAQ, one other thing I did have to do manually or forgot to
mention in my previous post, was giving the account (network service in my
case) that the WSS timer service runs under, modify permission on the STS
logfiles folder. Regards, Kim.

> Doug, I can sympathize totally.
> In my case, which was an out-of-the box installation of WSS on a Windows
> 2003 AD domain server, which was then demoted to standalone (don't go
> there), WSS reinstalled because AD demotion destroys everything, and all
> content recreated from scratch since stsadm and smigrate just wont hack
it,
> the content databases have a single user, network service, that is dbo.
> Changing the account that the WSS timer service runs under to network
> service seemed to do the trick. The section in the help file on
permissions
> is not helpful. And I am sick to death of this mess, but hope that all of
> the above posts and Mike's etc FAQ can help save some poor soul going
> through what we have just been through. Thanks for your help and
persistence
> too. Regards, Kim.
>
> "Doug" <dougpeterman@hotmail.com> wrote in message
> news:#IX4hZfDEHA.3568@tk2msftngp13.phx.gbl...
> > I will preface this with saying that mine was not a typical install. It
> > involved migrating a content database from a development to production
> > environment and it's safe to say I overlooked the importance of this
piece
> > in the process. It's unfortunate that the documentation of the
> recommended
> > or required security accounts/app pools configuration is very scarce if
it
> > exists at all.
> >
> > In my environment, the SharePoint Timer Service is running under a
domain
> > user account (WSSAdmin) - the same account as the SharePoint Central
> > Administration application pool. I believe the installation process had
> set
> > it to run as Network Service on install, but I'm not sure now and can't
> > easily recreate the scenario...
> >
> > I granted WSSAdmin dbowner access to the content database, which is
> probably
> > in violation of the rule of least privelege, but I was growing tired of
> > guessing...
> >
> > "Kim Ellis" <kimellis@mengyuan.com.au> wrote in message
> > news:eeK$cxTDEHA.3064@tk2msftngp13.phx.gbl...
> > > "Doug" <dougpeterman@hotmail.com> wrote in message
> > > news:ekv0IprCEHA.2592@TK2MSFTNGP12.phx.gbl...
> > > > In my situation the account that the SharePoint Timer Service was
> > running
> > > > under did not have access to the content database. This was causing
> > both
> > > > failure of the usage analysis processing job and the
> alerts/notification
> > > > job. By simply granting access in the content db to the account
both
> > jobs
> > > > ran successfully.
> > >
> > > Doug,
> > >
> > > What account does your WSS Timer Service run under?
> > >
> > > Was that the out-of-the box account, the one applied during
> installation,
> > or
> > > did you change it?
> > >
> > > What database role (or permissions) did you give that account when you
> > added
> > > it as a user to the Content database(s)?
> > >
> > > Mike,
> > >
> > > I think Doug's answers to the above need to be in the FAQ as well.
> > >
> > >
> > > Thanks to both of you.
> > >
> > > regards,
> > > Kim
> > >
> > > >
> > > > "Doug" <dougpeterman@hotmail.com> wrote in message
> > > > news:eC8bVY3BEHA.712@tk2msftngp13.phx.gbl...
> > > > > Kim,
> > > > >
> > > > > Thanks for following up.
> > > > >
> > > > > I haven't had the cycles to dig in to this but suspect my problem
is
> > > with
> > > > > permissions for this service as well. I'll definitely give that a
> > shot
> > > > (as
> > > > > soon as I can come up for air).
> > > > >
> > > > > "Kim Ellis" <kimellis@mengyuan.com.au> wrote in message
> > > > > news:%23t0GuOwBEHA.916@tk2msftngp13.phx.gbl...
> > > > > > Doug,
> > > > > >
> > > > > > After much stuffing around, I got it all to work by changing the
> > > account
> > > > > > that the WSS timer service runs under to local service. I know
all
> > the
> > > > > posts
> > > > > > and bits & pieces from MS say it is supposed to run under the
WSS
> > > > account
> > > > > > and that you might have to manually give the WSS account update
> > access
> > > > to
> > > > > > the STS logs folder, but I just couldn't get that to work. Local
> > > Service
> > > > > > does work for me. What a joke!
> > > > > >
> > > > > > I would really appreciate it, if someone for whom usage analysis
> > > worked
> > > > > 'out
> > > > > > of the box' first time would advise the account details that the
> WSS
> > > > timer
> > > > > > service runs under, and the exact permissions that the WSS
account
> > has
> > > > on
> > > > > > the STS logs folder, both inherited from above and propagated
> below.
> > > > Seems
> > > > > > there is a bug for some 'out of the box' installations whereby
the
> > > > account
> > > > > > the WSS timer service runs under and the permissions it has on
the
> > > logs
> > > > > > folder hierarchy are stuffed, and the existing MS posts on the
> topic
> > > are
> > > > > > less than complete in resolving the problem.
> > > > > >
> > > > > > regards,
> > > > > > Kim
> > > > > >
> > > > > > "Doug" <dougpeterman@hotmail.com> wrote in message
> > > > > > news:#ZlOeuW$DHA.1792@TK2MSFTNGP12.phx.gbl...
> > > > > > > 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,
> > > > I'm
> > > > > > now
> > > > > > > trying to determine what exactly triggered it. Prior to my
> > efforts
> > > > it
> > > > > > did
> > > > > > > not update for approx. 2 weeks. The only changes I made
(fairly
> > > sure)
> > > > > > were
> > > > > > > in the database and creating a new site as noted below - just
> not
> > > sure
> > > > > > which
> > > > > > > did the trick yet.
> > > > > > >
> > > > > > > "Iyaz" <iyaz@invalid.msn.com> wrote in message
> > > > > > > news:ekqwyOW$DHA.624@TK2MSFTNGP11.phx.gbl...
> > > > > > > > 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
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >.
> > > > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > ---
> > > > > > Outgoing mail is certified Virus Free.
> > > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > > Version: 6.0.619 / Virus Database: 398 - Release Date:
10/03/2004
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> > > ---
> > > Outgoing mail is certified Virus Free.
> > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > Version: 6.0.631 / Virus Database: 404 - Release Date: 17/03/2004
> > >
> > >
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004
>
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004

Relevant Pages