Welcome to Mediachase Community Sign in | Join | Help    
in Search   
Mediachase Community » eCommerce Framework 4.x » Technical Questions » Re: Timeout when duplicating Product in Admin

Timeout when duplicating Product in Admin

Last post Mon, Mar 17 2008, 5:01 PM by cblaze22. 13 replies.
Sort Posts: Previous Next

  •  Tue, Feb 05 2008, 9:30 AM 7656

    Timeout when duplicating Product in Admin

    Reply Quote
    I am getting this error when trying to duplicate an item from the product list.

    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace: 

    [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +149
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
       Mediachase.MetaDataPlus.Common.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +106
       Mediachase.MetaDataPlus.MetaObject.AcceptChanges() +10336
       Mediachase.eCF.BusLayer.SiteStructure.Products.Product.internalDuplicate(Boolean newLangauge, Boolean copyCategories) +495
       Mediachase.eCF.BusLayer.SiteStructure.Products.Product.Duplicate() +9
       Mediachase.eCF.BusLayer.SiteStructure.Products.Product.Duplicate(Int32 id) +44
       Mediachase.eCF.CommerceManager.Module.ProductControlMenu.ProductEditMenu_ItemSelected(Object sender, MenuItemEventArgs e) +140
       ComponentArt.Web.UI.Menu.OnItemSelected(MenuItemEventArgs e) +28
       ComponentArt.Web.UI.Menu.HandlePostback(String stringArgument) +330
       ComponentArt.Web.UI.BaseNavigator.RaisePostBackEvent(String eventArgument) +7
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +177
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746

  •  Tue, Feb 05 2008, 11:28 PM 7663 in reply to 7656

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Does this happen with products that have different meta classes or only one specific meta class?

  •  Wed, Feb 06 2008, 8:47 AM 7667 in reply to 7663

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    They all have one meta class.

  •  Thu, Feb 07 2008, 3:52 PM 7685 in reply to 7667

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Anyone on this?

  •  Tue, Feb 12 2008, 3:17 PM 7724 in reply to 7685

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Are you able to debug this method? Since we cannot replicate the issue perhaps you can tell us what part of the code is hanging.
    Gary L Cox Jr

  •  Mon, Feb 18 2008, 10:11 AM 7772 in reply to 7724

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    How can I debug a precompiled website.  This is happening in the commerce manager.  It is still happening and is the same copy off the download off your website.

  •  Tue, Feb 19 2008, 2:38 AM 7775 in reply to 7656

    Re: Timeout when duplicating Product in Admin

    Attachment: sqllockingproblem.zip
    Reply Quote
    Hi

    I am getting similar problems when copying products using the sample and my own installation (SwotShop). The timeout seems to be a red herring as when you look at the sql server activity a lock is in place and thus the code appears to be dead locking until the timeout is thrown (see below), I have also attached a screen shot of sql server  activity whilst the copy is is progress.

    Hope it helps, please shout if you require more info.

    Tim



    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

     
    [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135
       Mediachase.MetaDataPlus.Common.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +106
       Mediachase.MetaDataPlus.MetaObject.AcceptChanges() +10336
       Mediachase.eCF.BusLayer.SiteStructure.Products.Product.internalDuplicate(Boolean newLangauge, Boolean copyCategories) +495
       Mediachase.eCF.BusLayer.SiteStructure.Products.Product.Copy(Int32 ToLanguageId, Int32 ToCategoryId) +99
       Mediachase.eCF.CommerceManager.Module.AdminSiteStructureHome.CopyObject(Object sender, EventArgs e) +383
       System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
       System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
       System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
       System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

     

  •  Wed, Feb 20 2008, 9:37 AM 7791 in reply to 7656

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Have you figured out this problem?

  •  Thu, Feb 21 2008, 2:06 AM 7800 in reply to 7791

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    I havn't figured it out yet, I'm waiting for some feedback from the mediachase guys

    Tim

  •  Thu, Feb 21 2008, 10:41 AM 7806 in reply to 7800

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    We are looking into this and hope to have an answer soon.
    Gary L Cox Jr

  •  Fri, Feb 29 2008, 5:10 PM 7860 in reply to 7806

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Any word on this?  It is not urgent but a fix is needed for this someday.

  •  Mon, Mar 03 2008, 11:15 AM 7863 in reply to 7860

    Re: Timeout when duplicating Product in Admin

    Reply Quote

    We are looking into the matter, and, hopefully, will have an answer by the end of the week.

    Thank you for your patience.

    Mediachase Software

  •  Thu, Mar 06 2008, 10:22 AM 7903 in reply to 7863

    Re: Timeout when duplicating Product in Admin

    Reply Quote

    This is a bug and we are working on resolving it. It will be fixed in out next minor release, which should be coming sometime next week.

    Thanks,
    Sasha.

  •  Mon, Mar 17 2008, 5:01 PM 7951 in reply to 7903

    Re: Timeout when duplicating Product in Admin

    Reply Quote
    Is this fix out yet?
View as RSS news feed in XML
Site Terms | Privacy Policy | About Us | Contact Us
Running on Mediachase eCommerce Framework 4.0.
  Copyright © Mediachase, LTD. 1997-2006. All Rights Reserved
E-commerce, HelpDesk, Service Desk & Project Management Software, alternatives to Microsoft Project Server & Sharepoint Collaboration Server
project management software | microsoft project server | sharepoint collaboration server | issues management, helpdesk & service desk
Powered by Community Server, by Telligent Systems