This hot fix corrects a bug where products with choices that also track inventory are not displayed corrected on category pages when their out of stock mode is set to "Display on Store (Do Not Allow Orders)"

The bug fix is a SQL update to the bvc_ProductAvailableAndActive function in the data. The correction was an update to line 45

Before:



After



Run the Attached SQL Script on your database to update.

Change the first line in the script to use your database instead of CommerceMain. For example,

USE [Brendon]

I'm glad that helped. Though I feel bad for aiding an abetting changes to a live store...it is so easy to setup a staging site.

Marcus,

One of our clients is now getting this error in their event log after applying this hot fix. it doesn't seem to causing any issue on the front side but has filled up their event log with the same error.

Object reference not set to an instance of an object.[ at BVSoftware.Bvc5.Core.BusinessRules.ProductTasks.ApplySales.Execute(ProductTaskContext context) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\ProductTasks\ApplySales.vb:line 49 at BVSoftware.Bvc5.Core.BusinessRules.ProductTask.Execute(TaskContext context) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\ProductTask.vb:line 7 at BVSoftware.Bvc5.Core.BusinessRules.Workflow.Run(TaskContext c) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\BusinessRules\Workflow.vb:line 59 ]

We ran the script with the store DB name in there but it looks like it keeps referencing CommerceMain. Any idea how to fix or correct this?

Hi Marcus,

Since posting this I have cleared the error log and I don't see that this issue has come back yet. So I am not sure yet what may be triggering it. I will continue to monitor this situation and see what I can find. I am seeing a whole new issue with this error though:

Exception: System.Data.SqlClient.SqlException: 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(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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteDataSet(DataRequest request, Int32 startRowIndex, Int32 maximumRows, Int32& rowCount) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 127