Site Analytics Pro - Error Page

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.

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

11/2/2010 2:49:32 PM

David Allen

Total Posts 110

View Posts

Site Analytics Pro - Error Page

Hi,

I have installed Site Analytics Pro successfully but I am unable to access a number of pages.

Dashboard
Visitor Analysis
Visitor Map
Content Analysis
API Queries

When trying to access these pages, I just receive the Error.htm page. After first installation, the Dashboard and Visitor Analysis pages did work but stopped working after I changed the option to use database data instead of API data.

Any thoughts?

Thanks.

11/2/2010 3:12:13 PM

Joe Audette

Total Posts 18439

View Posts

Re: Site Analytics Pro - Error Page

Hi David,

Please check the mojoPortal log for error information and post it here.

Best,

Joe

11/2/2010 3:18:18 PM

David Allen

Total Posts 110

View Posts

Re: Site Analytics Pro - Error Page

There are errors like this in the log.

2010-11-02 15:00:09,918 ERROR mojoPortal.Web.Global - 86.166.42.157-en-GB - /Analytics/ContentAnalysis.aspx
System.InvalidOperationException: The stored procedure 'sts_ga_PageData_SelectTopReportByDate' doesn't exist.
at System.Data.SqlClient.SqlCommand.DeriveParameters()
at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command)
at sts.Analytics.Data.SqlParameterHelper.DiscoverParameters(String connectionString, String procName)
at sts.Analytics.Data.SqlParameterHelper.GetParameters(String connectionString, String procName)
at sts.Analytics.Data.SqlParameterHelper.InitializeArray()
at sts.Analytics.Data.SqlParameterHelper.Initialize(String pConnectionInfo, String pCommandText, CommandType pCmdType, Int32 pParamCnt)
at sts.Analytics.Data.DBPageAnalytics.GetTopContentReport(Boolean tracking1ProfileOnly, Guid siteGuid, String profileId, DateTime beginDate, DateTime endDate)
at sts.Analytics.Business.PageAnalytics.GetTopContentReport(Boolean tracking1ProfileOnly, Guid siteGuid, String profileId, DateTime beginDate, DateTime endDate)
at sts.Analytics.Components.DataCache.GetTopContentReport(Boolean tracking1ProfileOnly, Guid siteGuid, String profileId, DateTime beginDate, DateTime endDate)
at sts.Analytics.UI.TopContentControl.GetData()
at sts.Analytics.UI.TopContentControl.PopulateControls()
at sts.Analytics.UI.TopContentControl.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I'm presuming from this error that if using a SQL database that stored procedures will be set up on the DB. I am using shared hosting from Arvixe and I'm not sure if they support stored procedures on SQL 2008 databases.

Do you think I would be better using a MySQL database and is it easy to change the analytics DB?

Thanks.

11/2/2010 3:30:37 PM

Joe Audette

Total Posts 18439

View Posts

Re: Site Analytics Pro - Error Page

If your site is using MySql but you want to use MS SQL for the Analytics data, you can do that but you have to run the sql script manually and use a different connection string than the site. This is documented on the System Requirements/Installation tab on the In Site Analytics Pro product page, but let me know if any steps are unclear.

I think the report performance is a little bit better when using MS SQL vs MySql, but I am using MySql on this site both for the site and for In Site Analytics and it works well enough.

Best,

Joe

11/2/2010 3:39:05 PM

Joe Audette

Total Posts 18439

View Posts

Re: Site Analytics Pro - Error Page

I forgot to mention also that when you change the dropdown from API Data to Database Data it sets a cookie, so you could get back to the working API reports by clearing your cookies and logging in again.

Best,

Joe

11/2/2010 4:32:36 PM

David Allen

Total Posts 110

View Posts

Re: Site Analytics Pro - Error Page

I ran the SQL script manually and it is all now working! Thank you.

The instructions are very clear, the only thing I would mention is the heading for the section that provides the instructions for running the SQL script manually is "If you are not using a supported database for the Site Data but have a supported database for Analytics Data". I missed reading this as I am using a supported DB (MySQL) for Site Data and using a different supported DB (MSSQL) for Analytics Data.

All the instructions were very clear though, as usual.

Cheers.

11/2/2010 5:02:34 PM

Joe Audette

Total Posts 18439

View Posts

Re: Site Analytics Pro - Error Page

Hi David,

Glad it is working, and excellent feedback about that heading, it bothered me too but I couldn't put my finger on it until you pointed it out. I thought about changing it to "Using a Different Database Platform Than The Site" but then that still seemed too long winded so I settled on "Mixing Database Platforms" and I edited the paragraph a little to make it clearer as well.

Best,

Joe

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