Insite Analytics

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
7/19/2011 9:27:03 AM
David Allen
Gravatar
Total Posts 110
View Posts

Insite Analytics

Hi There,

I have Insite Analytics installed and it all works fine except when I try to view data from the database.  When I select the database option, rather than API, I receive the following error:

System.Data.SqlClient.SqlException (0x80131904): Divide by zero error encountered. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.HasMoreRows() at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at sts.Analytics.Business.MediumAnalytics.GetMonthReport(Boolean tracking1ProfileOnly, Guid siteGuid, String profileId, DateTime beginDate, DateTime endDate) at sts.Analytics.UI.Charts.TrafficByMediumBarChart.GetData() at sts.Analytics.UI.Charts.TrafficByMediumBarChart.zgStats_RenderGraph(ZedGraphWeb webObject, Graphics g, MasterPane pane) at ZedGraph.Web.ZedGraphWeb.OnDrawPane(Graphics g, MasterPane mp) at ZedGraph.Web.ZedGraphWeb.CreateGraph(Stream OutputStream, ImageFormat Format, Boolean bShowTransparency) at ZedGraph.Web.ZedGraphWeb.Render(HtmlTextWriter output)

 

I never used to get this error and the only changes I have made have been site upgrades.

Any help to resolve this would be great!

Thanks,

David

7/19/2011 10:59:18 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Insite Analytics

Hi David,

It seems the divide by zero error must happen by rows in the sts_ga_MediumData that have 0 for the Visits column. I "thought" I had coded the API query that populates that table so that it would not add rows with 0 in that column, ie they should have been filtered out.

I'd run a query to see how many rows are like that

SELECT Count(*) FROM sts_ga_MediumData WHERE Visits = 0

Then I guess you could either delete those rows

DELETE FROM sts_ga_MediumData WHERE Visits = 0

or update them to 1 to avoid the error.

UPDATE sts_ga_MediumData

SET Visits = 1

WHERE Visits = 0

Haven't seen this error before so not sure how those 0 rows got in there.

Hope that helps,

Joe

7/19/2011 12:15:41 PM
David Allen
Gravatar
Total Posts 110
View Posts

Re: Insite Analytics

Hi Joe,

There were 48 rows where visits were 0.  Updated them to 1 and that has solved the problem.

Before running this though, I have noticed that I have no API data.  I have checked Google Analytics and all the data is still there, but when I try to view it in Analytics there is nothing.

When I first started this thread, I could view the API data, so something has changed very recently.

Any thoughts?

Thanks,

David

7/19/2011 12:54:39 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Insite Analytics

Unless your settings have changed it was probably just a temporary outage for the api. I'd look in the mojoPortal log for any related errors and see if recycling the app pool fixes it, as it might have cached empty data, so recycling should clear the cache.

Hope that helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.