1. This forum is read-only and considered to be an Archive. Please utilize the SmarterTools Community for future interaction and posts.

Bug/Issue Referellal Report generation sgets stuck at x% after smarterstats 7.x upgrade

Discussion in 'SmarterStats' started by funky123, Apr 5, 2012.

  1. funky123

    funky123 Member

    After upgrade to Smarterstats Ent 7.x last week,

    one of domain client while trying to generate referral reports for yearly period reported that it gets stuck at 70 or 98 %
    After this smarterstats MRS login logs out.

    We didnt find any errors in event logs.

    SSlog.log shows following for this site id.

    [2012-04-05 04:36:45] (Main) SQL Error: select * from fReferrerHosts(26,'2011-04-01T00:00:00','2012-04-01T00:00:00',100) where (Visits > 0) order by visits desc (212 Used/2800 Free)
    [2012-04-05 04:39:39] (Main)
    System.Threading.ThreadAbortException: Thread was being aborted.
    at SStatSvc.Stats.DailyTotalStatsBase.ReadOne()
    at SStatSvc.Stats.DailyTotalStatsBase.Load()
    at SStatSvc.Stats.DailyTotalStatsBase.Load(DateTime DayIn)
    at SStatSvc.Queries.Referrer.fReferrerHosts(StatsQuery query, QueryDataReturn& ret, Boolean remove0Visits, Boolean remove0Hits, Boolean removeNoReferrer)
    at SStatSvc.Communication.StatsQuery.ExecuteQuery(SQLSelectQuery qiIn, SiteSettings detailsIn, DateTime dateStartIn, DateTime dateEndIn, Int32 topCountIn)
    at SStatSvc.Control.QueryRequest.ExecuteQuery(SQLSelectQuery )
    at SStatSvc.Control.QueryRequest.#AW()
    (242 Used/2766 Free)
    [2012-04-05 04:39:39] (Main) SQL Error: select * from fReferrerHosts(26,'2011-04-01T00:00:00','2012-02-01T00:00:00',100) where (Visits > 0) order by visits desc (243 Used/2765 Free)
  2. funky123

    funky123 Member

    Smarterstats team

    do we have resolve for this?

    We increased QueryTimeoutSeconds in D:\program files\SmarterTools\SmarterStats\MRS\web.config
    increased : add key="SSWeb.QueryTimeoutSeconds" value="1090"

    This doesnt seem to resolve the problem..

  3. funky123

    funky123 Member

    Now we are facing problem even if we generate referral reports for current month. The generation gets stuck at 70% or 80%, 98%