|
Group: Awaiting Activation
Last Active: Thu 25 Oct 2012
Posts: 15,
Visits: 210
|
Hello there,
I've been having a bit of trouble adding products into my Kartris install, and I was wondering if anyone could help. I keep getting a 'general database error' when attempting to add single version products (though not when adding multiple version or options products). I tried it on a separate fresh install as well and seemed to have the same problem. The error log entry is below:
-----------------------------------------------------------------------------
>> VersionsBLL._AddNewVersionAsSingle
-----------------------------------------------------------------------------
>> System.Data.SqlClient.SqlException
>> 10/08/2010 09:05:30
>> 81.149.11.65
>> 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.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.ExecuteScalar()
at kartrisVersionsDataTableAdapters.VersionsTblAdptr._TotalVersions()
at VersionsBLL._ExceedLimit(Int32 intToBeAdded)
at VersionsBLL._AddNewVersionAsSingle(DataTable tblElements, String strCodeNumber, Int32 intProductID, Int16 intCustomerGrp, SqlConnection sqlConn, SqlTransaction savePoint, String& strMsg)
==================================================
-----------------------------------------------------------------------------
>> ProductsBLL._AddProduct
-----------------------------------------------------------------------------
>> System.ApplicationException
>> 10/08/2010 09:05:30
>> 81.149.11.65
>> CUSTOM MESSAGE:
Database Error: A general error has occurred.Error occurred while processing the operation.
>> MESSAGE:
Error occurred while processing the operation.
>> STACK:
at ProductsBLL._AddProduct(DataTable ptblElements, String pParentsList, Int32& pProductID, Boolean pLive, Byte pFeatured, String pOrderVersionsBy, Char pVersionsSortDirection, Char pReviews, Char pVersionDisplayType, Int32 pSupplier, Char pProductType, Int32 pCustomerGroupID, String& strMsg)
==================================================
The point of failure appears to be 'AddNewVersionAsSingle', which makes sense given the problem I'm having.
Many thanks in advance,
Mike
|