+1-888-365-2779
Try Now
More in this section

Forums / Bugs & Issues / News Commnets Error

News Commnets Error

6 posts, 0 answered
  1. Sebastian Menendez
    Sebastian Menendez avatar
    19 posts
    Registered:
    15 Oct 2004
    31 Aug 2009
    Link to this post
    HI,

    We're having a problem with the comments administration when there are thousands of comments. For some reason the comments list doesn't load. Since this is happening on production we arean't able to identify what is the exact error message (custom errors are on).

    Any ideas on what could be happening? Anyone has had experience with a large number of comments?

    Thanks,

    Sebastian
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    01 Sep 2009
    Link to this post
    Hi Sebastian Menendez,

    I suggest that you should take a look at Sitefinity's error log - sitefinity.log. It is located under App_Data folder.9 if you can send a live link we could read the log). Please check whether there are any errors that could help us to determine the problem. Additionally could you tell us how many comments you have? We could try to reproduce the same behavior creating them prohrammatically and see whether the backend view will be opened.

    I look forward to hearing from you.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  3. Sebastian Menendez
    Sebastian Menendez avatar
    19 posts
    Registered:
    15 Oct 2004
    01 Sep 2009
    Link to this post
    Hi Ivan,

    We have a total of 3600 comments. Regarding the error, I was able to retrieve the error message. It's a timeout and the Stacktrace is:

    StackTrace: 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(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row) at Telerik.Cms.Engine.Data.Providers.GCSql2000Builder.EmitReversePriorityQuery(StmtContext context, DataRow queryData, Int32 maxRows, String groupName) at Telerik.Cms.Engine.Data.Providers.GCSql2000Builder.EmitQuery(StmtContext context, DataRow queryData, Int32 maxRows, String groupName) at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteQuery(StmtContext context, DataRow queryData, Int32 maxRows, String group) at Nolics.ORMapper.DataProviders.SQLDataProvider.ExecQuery(DataSet queries) at Nolics.ORMapper.Base.QueryBase`1.LoadQuery(Int32 maxElements, Int32 fromElement) at Nolics.ORMapper.Base.QueryBase`1.LoadAll() at Telerik.Cms.Engine.Data.Providers.DefaultProvider.GetComments(String sortExp, Int32 startRowIndex, Int32 maximumRows, String filterExp) at Telerik.Cms.Engine.ContentManager.GetComments(String sortExp, Int32 startRowIndex, Int32 maximumRows, String filterExp) at Telerik.Cms.Engine.ContentManager.GetComments(String sortExp, String filterExp)


    Thanks,

    Sebastian
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    02 Sep 2009
    Link to this post
    Hello Sebastian Menendez,

    I created 3600 comments and did not face any problems opening them. As I see it from the stack trace you are receiving connection timeout. This means that the operation cannot be processed due to lost connection to your SQL server. By default nolics sets 30 seconds of Timeout.

    The only suggestion that we can make is setting Connection Timeout property in your web.config to 30 seconds( by default it is 15).

    All the best,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
  5. Sebastian Menendez
    Sebastian Menendez avatar
    19 posts
    Registered:
    15 Oct 2004
    02 Sep 2009
    Link to this post
    Ivan,

    Where specifically should I change the timeout? Couldn't find the line where this is done.

    If this doesn't work, is there any way to bring the initial conten already filtered on the administration pane? I think that maybe this could solve the problem.

    Thanks,

    Sebastian
  6. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    02 Sep 2009
    Link to this post
    Hi Sebastian Menendez,

    For changing the Connection Timeout, please take a look at the following article at MSDN - SqlConnection.ConnectionString Property.

    For the second request - currently the only option to filter the items is creating a custom view and overriding the whole InitializeControls method where you should not call the base class.

    Regards,
    Ivan Dimitrov
    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Register for webinar
6 posts, 0 answered