Skip to content
February 5, 2016 / kiranpatils

Executive Dashboard : Report not found

Challenge:

Last week we were triggering some Sitecore Goals using API (http://blog.horizontalintegration.com/2013/11/19/sitecore-dms-trigger-goals-programatically/) and somehow while accessing Executive Analytics report it was not showing report data. And log was throwing following error (Solution is on Sitecore 7.2):

6660 09:18:06 ERROR Unhandled Application Error: Report not found
Current URL: http://sandbox.www.hostname.com/sitecore/shell/~/analytics/reports/reports.ashx?fff=0&report=TrafficGoalConversions&trafficType=&cacheId=59c4e0c5-0f20-4ff7-8823-ce792aab19c5&languages=en&sites=Site_en&startDate=20080101&endDate=20160125&addLastModified=true
URL Referrer: http://sandbox.www.hostname.com/sitecore/shell/applications/analytics/executive-dashboard
User Host Address: 192.168.12.20

Exception: System.InvalidOperationException
Message: Report not found
Source: mscorlib

Server stack trace:
at Sitecore.Analytics.Reports.Data.ReportsData.LoadDefinition(ReportContext context)
at Sitecore.Analytics.Reports.Data.ReportsData.GetData(String reportName, ReportQuery reportQuery, Boolean skipCacheCheck)
at Sitecore.Analytics.Reports.ReportDataHandler.RunReport(HttpContext context, String reportId, Boolean cacheDisabled, Nullable`1 clientTimestamp)
at Sitecore.Analytics.Reports.ReportDataHandler.ProcessRequest(HttpContext context)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
at Sitecore.Analytics.Reports.ReportDataHandler.RequestProcessor.EndInvoke(IAsyncResult result)
at System.Web.HttpApplication.CallHandlerExecutionStep.OnAsyncHandlerCompletion(IAsyncResult ar)

6660 09:18:06 ERROR Error in Application_Error().
Exception: System.ArgumentNullException
Message: Value cannot be null.
Parameter name: url
Source: System.Web
at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent)
at ASP.global_asax.Application_Error(Object sender, EventArgs args)

Solution:

We spent sometime to look at it. At one point of time. I came across one blog which said Programmatically triggered Goal will not be appearing in report. To be honest that blog confused us. And we went in wrong direction. Then after sometime. We thought to take a step back and took basic step — Check what happens with Plain Sitecore. And it was working there! So, one thing was final. Something was wrong with particular solution.

Then we talked to our DMS Guru – Sheetal Jain Then we started an investigation. Verified few Sitecore analytics related configurations – Everything looked fine. Then Sheetal tried to find that error in log file. And from there we found that Report Name field was empty for few of the reports at this /sitecore/system/Settings/Analytics/Dashboard Reports

We copied it from Plain Sitecore and It fixed the issue! – Again, We haven’t been able to find out why it was not there. But thanks for whatever reason it was not there. Else we would have not understood this internal architecture of DMS Reporting! 🙂

Happy Reporting!

Thanks Bhavesh for working with us on this!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: