Problems with Usage Reports
I am having problems with the usage reports on our farm. I cant get to the site collection usage reports or the usage reports in central admin ssp.I get file not found, so i made the change in the web config for the error and I get:File Not Found. at Microsoft.SharePoint.Portal.Analytics.UI.ReportControl.CreateChildControls() at System.Web.UI.Control.EnsureChildControls() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Everything has been enabled and the files exist in the correct locations on the server. I am scratching my head on this one.All servers are server 2008 x64 enterprise moss 2007 sp2 with august cu.thanks for your help
March 10th, 2010 1:40am

A bit more info, we did change the default url that hosts the ssp site. it was http://mossindexserver:port but now it is a fqdn. http://company.comif i go to the old url i get this errror:File Not Found. at Microsoft.SharePoint.Library.SPRequestInternalClass.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags) at Microsoft.SharePoint.Library.SPRequest.OpenWebInternal(String bstrUrl, Guid& pguidID, String& pbstrRequestAccessEmail, UInt32& pwebVersion, String& pbstrServerRelativeUrl, UInt32& pnLanguage, UInt32& pnLocale, String& pbstrDefaultTheme, String& pbstrDefaultThemeCSSUrl, String& pbstrAlternateCSSUrl, String& pbstrCustomizedCssFileList, String& pbstrCustomJSUrl, String& pbstrAlternateHeaderUrl, String& pbstrMasterUrl, String& pbstrCustomMasterUrl, String& pbstrSiteLogoUrl, String& pbstrSiteLogoDescription, Object& pvarUser, Boolean& pvarIsAuditor, Int32& plSiteFlags) at Microsoft.SharePoint.SPWeb.InitWebPublic() at Microsoft.SharePoint.SPWeb.get_Locale() at Microsoft.SharePoint.WebPartPages.Utility.SetThreadCulture(SPWeb spWeb, Boolean force) at Microsoft.SharePoint.Utilities.SPUtility.SetThreadCulture(SPWeb spWeb) at Microsoft.SharePoint.ApplicationRuntime.BaseApplication.Application_PreRequestHandlerExecute(Object sender, EventArgs e) at Microsoft.SharePoint.ApplicationRuntime.SPRequestModule.PreRequestExecuteAppHandler(Object oSender, EventArgs ea) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2010 1:43am

Hi, One question... Are the alternate access mappings configured correctly after the change? Hope it helps!Enrique Blanco PMP, Consultant www.eblanco.com www.wandau.com
March 10th, 2010 8:22pm

I have checked them and across all web applications they appear to be correct. We extended the web app with the urls we wanted and thus that created the alternate access mappings. As i look back it looks like when i enabled advanced usage analysis in the ssp is what killed it. before i just had search query logging and it worked. let me double check thatthanks for the help
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2010 10:31pm

I had to remove the following line from the web config files to make sharepoint to load... could it be the culprit? we are using ssrs 2008 with the sp1 cu 3 add-in and that all seems to be working just fine.<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
March 10th, 2010 10:39pm

Hi Wvrider, Did you follow the following article to configure usage reporting, if not, please do it again. Configure usage reporting http://technet.microsoft.com/en-us/library/cc262541.aspx In order for usage analysis processing to occur, the following timer jobs must be enabled and must be running successfully: - Usage Analysis (for all applications) - Office SharePoint Usage Analytics Log Import - Office SharePoint Usage Analytics Log Processing Check the issue in new web application: 1. Create a new Web Application from Central Administration>Application Management>Create or Extend Web Application. 2. Create a new site collection in new web application from Administration>Application Management>Create Site Collection. 3. Enable the reporting feature to the new created site. 4. Wait for 24 hours and then check for the Site Usage Report on newly created site. In addition, go to the IIS manager, make a copy of the web.configsent the web.config file from your test environment if you have. Replace the original web.config with it. Then do iisreset, finally try accessing the site usage reports again. Hope this helps. Rock WangRock Wang MSFT
Free Windows Admin Tool Kit Click here and download it now
March 11th, 2010 4:27am

I'll give it a try again ..just ran through the article again. i'll let it run till tomorrow and i'll monitor if logs are generated. and then give the web.configs from the test environment.i'll report back
March 15th, 2010 6:49am

I was able to make a new web application, set it up just like the other web applications and the usage reporting works just fine. however the only thing i didn't have setup was dns entries and the load balancing between the two web servers. I only made host entries on my machine for testing. But i think the load balancing would not cause my problem.I did copy the web config from the new working web application to the problem web applications and still didn't work...same error file not found.So i will start digging deaper tomorrow.
Free Windows Admin Tool Kit Click here and download it now
March 17th, 2010 5:58pm

In my case the solution was to install ReportViewer redistributable (http://go.microsoft.com/fwlink/?LinkId=49981), uncomment this line as mentioned above: <add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> and uncomment this line <add name="Session" type="System.Web.SessionState.SessionStateModule"/>
August 4th, 2010 1:02pm

i'll give it a try thanks!
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2010 4:08pm

mbuetterhoff..........you are awesome that was the problem. i had to fix a problem in one of my web configs and it is all there. should note also i tried the 2008 reportviewer redistributable and didn't work...the 2005 you listed above worked great.
August 26th, 2010 9:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics