Solved

MOSS 2007 Usage Report Missing Data

Posted on 2012-03-12
10
868 Views
Last Modified: 2012-05-02
SharePoint Environment:
- MOSS 2007 SP2 Std 32bit
- 12.0.0.6557
- 2 x WFE (both Windows 2003 std SP2)
- SQL 2008 R2 64bit
- Running 2 Web Applications

Not sure if this makes any differences, but we recently upgraded our from 32bit SQL 2005 to 64bit SQL 2008 in January 2012.  

Everything seems fine until 22 February, where a site owner (who regularly checks site usage) noticed there were no data in various section of the Site Usage Reports for their Call Centre site:

"No data is available for this report.  Usage analysis might have been enabled only recently, or there might have been insufficient usage to result in any values for the report."

I noticed both web applications are having the same issues no matter which site I run the usage report on. I also noticed in the Timer Job Status that both SharePoint Services Search Refresh failed.  

Troubleshooting done on 3rd March:
- Clear cache (http://blogs.msdn.com/b/josrod/archive/2007/12/12/clear-the-sharepoint-configuration-cache-for-timer-job-and-psconfig-errors.aspx)
- Reset Crawl Content
- Run Full Crawl

This in effect, has fixed the secondary WFE server, but not the main WFE server.

Timer Job Status
SharePoint Services Search Refresh  (ServerName) Failed  100%  13/03/2012 2:44 AM  
SharePoint Services Search Refresh  (ServerName2) Succeeded  100%  13/03/2012 2:42 AM  

This has sort of fixed the usage report.  I can see the data from 4th March, but all data in February 2012 are missing.  Checking Central Admin shows all data including the missing Feb 2012.

If someone can point me in the right direction to recover missing February 2012 data that would be great.

Cheers, Ezs
0
Comment
Question by:ezskol
  • 5
  • 5
10 Comments
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 37716335
The usage report system in MOSS isn't as good as it should be.  We ended up writing our own solution because of the overhead and lack of consistent quality behaviour with it.  If the data wasn't captured because of a configuration issue it's likely gone forever.

I'd recommend a MS Support call.  My recommendation would have been what you already tried as well as turn off all usage reporting, then reactivate it.
0
 
LVL 6

Author Comment

by:ezskol
ID: 37722826
Thanks Ted.

We had another issue yesterday, which is now resolved, and it seems to fixed the SharePoint Services Search Refresh  for the main server.  Disconnected and reconnected the main SP server and had to clear the database for Search to re-start the service.

However, February data is still missing.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 37723279
Well, if there was a service issue the data might not have been recorded and could be lost.  I generally don't recommend directly accessing the SQL databases for Sharepoint, however, in this case you might want to look into it (Read Only) to see if the data is even there.  Sorry, but it's been a couple of years since I looked into this and don't remember the tables involved.  I do remember they were easy to find.  I think they were in the SSP database.
0
 
LVL 6

Author Comment

by:ezskol
ID: 37723296
Thanks Ted.

The data are there as I can see it in Central Admin, but just not on the web application itself.

Cheers, Ezs.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 37723478
Ah, but the more specific details might be lost.  MOSS does a lot of aggregation of data to speed up the response time.  Are you sure the detailed data sets are available?
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 6

Author Comment

by:ezskol
ID: 37735598
Sorry Ted, where about is the detailed data set?

Thanks, Ezs.
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 37735609
I mean when you are in Central Admin you said the data is there.  Is it detailed data for the site in question or aggregated?  My point is that Central Admin might be fooling you by showing rolled up data but in fact, the detailed data for February is lost.
0
 
LVL 6

Author Comment

by:ezskol
ID: 37826278
Yes, CA did show the data in there, but only the 5 queried reports though and doesn't go in depth as when you are viewing the site usage via site collection/site.
0
 
LVL 51

Accepted Solution

by:
Ted Bouskill earned 500 total points
ID: 37826432
That is what I expected.  I think the detailed data is gone.
0
 
LVL 6

Author Closing Comment

by:ezskol
ID: 37922667
The really the answer I wanted, but at least it confirms that the data is lost for Feb 2012.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now