14 April, 2009

Usage Analysis Processing - Server Out of Memory error

In our company's project, We have Two enviornments Windows SharePoint Services and Microsoft office SharePoint Server 2007. Both are classified into 3 stages as Tes, QA and Production. In WSS 3.0 Test enviornment, when we tried to enable Usage Analysis processing, we got an error message :
"Server Out Of MemoryThere is no memory on the server to run your program. Please contact your administrator with this problem."

I can't find anything in the EVENT LOGS on the server that indicate an issue with this.
After doing lots of troubleshooting for more than 2 days, we found out the resolution.You can't believe it but the resolution is very simple and straightforward.

We found out that the application pool account was running under Network Service. We changed it to Domain admin account and after that did IISRESET.

Issue Resolved.
Cheers !

Note:-
The domain account should have the following rights as follows:-
1. It should be present in the WSS_WPG,WSS_ADMIN_WPG and IIS_WPG and Administrator group.
2.It should be present in the SQL SERVER Logins Section.
3. It should have DBCREATOR & SECURITY ADMIN Permissions in the SQL SERVER.

The application pool identity is essentially what the ASP .Net code of the site will be executing as. The user account used here must have the standard rights in order to run an application pool, and must obviously have rights to read and write to the SQL Server databases for the site.

Thanks...

3 comments:

  1. Mr FBA Specialist .... i dont see any FBA issues discussed in this blog ... that happend ???

    cheers
    VJ

    ReplyDelete
  2. It could be you are a surgeon, airline pilot or
    police person and you think it almost impossible to use your skills and interests to create your own work from home - youtube.com,
    . If you have the above mentioned qualities, then you can be
    part of the growing family of home workers around the globe.
    Life can be dull, void, and boring without children.

    ReplyDelete
  3. Just be persistent and post regular content, this is important
    for those little crawlers too. You can leverage a world wide business with as little as
    a laptop, a cell phone and an internet connection. When you
    provide all this content to your website and it builds up over
    time, let's say a post a week or even a post a day,
    you will have hundreds of posts on your blog that are valuable for people
    to read.

    Take a look at my web site: appreciation marketing

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.