|
By gsfviper - Mon 13 May 2013
|
hi
> I tryed to call http://localhost:1289/kartris2/?af=2
> but?!!!!!!!!!!!!
> -----------------------------------------------------------------------------
>>> OrdersBLL.Add
> -----------------------------------------------------------------------------
>>> System.Data.SqlClient.SqlException
>>> 12/05/2013 21:56:53
>>> Version:2.0002
>>> URL:http://localhost:1289/kartris2/Checkout.aspx
>>> 127.0.0.1
>>> CUSTOM MESSAGE:
> Database Error: A general error has occurred.
>>> NUMBER:-2
>>> MESSAGE:
> Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
>>> STACK:
> 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.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(CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
> at kartrisBasketDataTableAdapters.CustomersTblAdptr.GetCustomer(Nullable`1 UserID, String Email, String Password) in C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\kartris2\127ff0a5\c4948734\App_Code.--f6upzn.79.vb:line 4145
> at BasketBLL.GetCustomerData(Int64 numUserID) in G:\Kartris2\App_Code\BLL\BasketBLL.vb:line 1497
> at BasketBLL.GetCustomerAffiliateID(Int64 numUserID) in G:\Kartris2\App_Code\BLL\BasketBLL.vb:line 3076
> at OrdersBLL.Add(Int32 C_ID, String strUserEmailAddress, String strUserPassword, Address BillingAddress, Address ShippingAddress, Boolean blnSameShippingAsBilling, BasketBLL BasketObject, ArrayList BasketArray, String strOrderDetails, String strGatewayName, Int32 intLanguageID, Int32 intCurrencyID, Int32 intGatewayCurrencyID, Boolean blnOrderEmails, String strShippingMethod, Double numGatewayTotalPrice, String strEUVATNumber, String strPromotionDescription, String strPurchaseOrderNo, String strComments) in G:\Kartris2\App_Code\BLL\OrdersBLL.vb:line 661
|
|
By Mart - Mon 13 May 2013
|
|
Do other pages still work fine? IE is it this specific page only that times out?
|
|
By gsfviper - Mon 13 May 2013
|
yes,other pages still work fine.
in all browser the error was happend.
|
|
By UKcentric - Wed 15 May 2013
|
It's a database timeout error.
It sounds like your SQL Server database is running without enough memory/CPU power.
|
|
By Medz - Thu 16 May 2013
|
I've just checked in a related fix to the Kartris codeplex repository. Its seems processing affiliate data sometimes causes timeouts during checkout. Can you check if downloading patch ID 14492 fixes the issue for you?
https://kartris.codeplex.com/SourceControl/list/patches
|
|