Server Error in '/' Application.

Error converting data type varchar to numeric.

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: Error converting data type varchar to numeric.

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): Error converting data type varchar to numeric.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2585494
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +6038654
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +297
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4477
   System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +242
   System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +275
   System.Data.SqlClient.SqlDataReader.Read() +35
   System.Data.Common.Internal.Materialization.Shaper`1.StoreRead() +36

[EntityCommandExecutionException: An error occurred while reading from the store provider's data reader. See the inner exception for details.]
   System.Data.Common.Internal.Materialization.Shaper`1.StoreRead() +187
   System.Data.Common.Internal.Materialization.SimpleEnumerator.MoveNext() +49
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +186
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +61
   AW.Business.Managers.Custom.Repository.SprocUsingProductRepository.GetProductOverviewItemsFromDb(ColorQueryOptions colorQueryOptions) in c:\SVN\Projekte\AWE\carpetyourlife\AW.Business\Managers\Custom\Repository\SprocUsingProductRepository.cs:19
   AW.Business.Managers.Custom.ProductManager.GetProductOverviewItems(ColorQueryOptions colorQueryOptions, List`1 userFavorites) in c:\SVN\Projekte\AWE\carpetyourlife\AW.Business\Managers\Custom\ProductManager.cs:65
   AW.Business.Managers.Custom.ProductManager.GetColorQueryResults(ColorQueryOptions query, List`1 userFavorites) in c:\SVN\Projekte\AWE\carpetyourlife\AW.Business\Managers\Custom\ProductManager.cs:543
   AW.Web.SubLayouts.Product.ProductOverview.OnLoad(EventArgs e) in C:\Qite\Projects\Associated Weavers\Associated Weavers Legacy\AW.Web\SubLayouts\Product\ProductOverview.ascx.cs:27
   System.Web.UI.Control.LoadRecursive() +61
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Control.LoadRecursive() +134
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +693


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4494.0