Server Error in '/' Application.
Keyword not supported: 'flush interval'.
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.ArgumentException: Keyword not supported: 'flush interval'.

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:

[ArgumentException: Keyword not supported: 'flush interval'.]
System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +634
System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +153
System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +65
System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +38
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +217
System.Data.SqlClient.SqlConnection.ConnectionStringSet(DbConnectionPoolKey key) +68
System.Data.SqlClient.SqlConnection.setConnectionString(String value) +167
System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential) +52
Ucommerce.Web.UI.InitializeAppsModule.DatabaseSystemVersion() +171
Ucommerce.Web.UI.InitializeAppsModule.IsUcommerceReady() +44
Ucommerce.Web.UI.InitializeAppsModule.OnBeginRequest(Object sender, EventArgs eventArgs) +112
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94

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

Hi Ucommerce!

I'm going crazy over this error, as I can't seem to correct it. I have an existing umbraco v8 installation I've been working on and I wanted to try out ucommerce. So I installed Ucommerce v9 from nuget and everytime I try to access the interface in backoffice (store etc.) I get the error below. I tried to add some code to the web.config (solutions from previous posts) and it didn't work, in fact it just throws another error. The below error is when the first without me trying to fix it. What to do? What went wrong?

Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Unknown server tag 'commerce:SimpleValidationSummary'.

Source Error:

Line 1: <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ValidationSummaryDisplay.ascx.cs" Inherits="Ucommerce.Web.UI.Controls.ValidationSummaryDisplay" %>
Line 2:

Line 3: <commerce:SimpleValidationSummary meta:resourceKey="Validator" runat="server" ShowMessageBox="false" ShowSummary="true"></commerce:SimpleValidationSummary>

Source File: /umbraco/ucommerce/Controls/ValidationSummaryDisplay.ascx Line: 3

When running RavenProductIndexer (Index everything from scratch) it return NullReferenceException in log file.

It does the following in the RavenProductIndexer:

PrimaryImageUrl = _imageService.GetImage(product.PrimaryImageMediaId).Url

ThumbnailImageUrl = _imageService.GetImage(product.ThumbnailImageMediaId).Url

but it doesn't check for null before requesting Url. If I replace the RavenProductIndexer with my own, where it does the following null check, there are no of these log entries.

PrimaryImageUrl = _imageService.GetImage(product.PrimaryImageMediaId)?.Url

ThumbnailImageUrl = _imageService.GetImage(product.ThumbnailImageMediaId)?.Url

There might be other methods in the API that don't have this null check at GetImage() as well.

Often product images are not set from backoffice image picker, but referencing to external images or images in a local folder.

If developers want a fallback image it is possible to handle this using ImageProcessor or similar tool.

I have downloaded latest ucommerce package "uCommerce-for-Sitecore-8.3.1.19271.zip" and trying to install it on fresh vanilla sitecore 9.0.2 instance. After starting installation i am getting below errors in log file,

WARN Sitecore shutting down
WARN Shutdown message: Change Notification for critical directories.
bin dir change or directory rename
Hosting Environment initiated shutdown

After this msgs new log file is created and Installation screen not showing any progress nor the log file showing any errors. I tried multiple times, observed same pattern of errors.

Sitecore instance is running well and doesn't show any such shutting down msg for any other process or package installation. I am getting this error only when i am trying to install ucommerce package.

I didn't find any compatibility table or older ucommerce version link for particular sitecore version. Can anyone please help me to resolve this issue?

I've just found that we have an enormous ratio of empty baskets to completed orders in our Ucommerce_PurchaseOrder table. Somewhere in the ratio of 1000:1. We now have so many redundant PurchaseOrder Baskets that it is seriously impacting performance across our entire site.

A rough back of the envelope calculation would suggest that every visit to our site automatically generates a new PurchaseOrder with OrderStatusId = 1 (Basket), but these unused baskets never get removed.

Is this expected out of the box behaviour?
Is there a standard uCommerce or Umbraco pattern/pipeline for removing zombie Baskets?
Are there Basket settings we can use to stop this happening, or at least reduce it?