I suggest you ...

Creating a catalogue errors with uCommerce_ProductCatalogDescription duplicate key constraint

Install uCommerce-for-Sitecore-7.4.0.17010 running on Sitecore 8.2 rev 160729. Create a new shop then create a new catalogue inside of it. Creating the catalogue errors with the message below.

Best Regards
Richard

Server Error in '/' Application.

Cannot insert duplicate key row in object 'dbo.uCommerce_ProductCatalogDescription' with unique index 'UX_uCommerce_ProductCatalogDescription_ProductCatalogId_CultureCode'. The duplicate key value is (24, en).
The statement has been terminated.

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: Cannot insert duplicate key row in object 'dbo.uCommerce_ProductCatalogDescription' with unique index 'UX_uCommerce_ProductCatalogDescription_ProductCatalogId_CultureCode'. The duplicate key value is (24, en).
The statement has been terminated.

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): Cannot insert duplicate key row in object 'dbo.uCommerce_ProductCatalogDescription' with unique index 'UX_uCommerce_ProductCatalogDescription_ProductCatalogId_CultureCode'. The duplicate key value is (24, en).
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3277272
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +345
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +5002
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +92
System.Data.SqlClient.SqlDataReader.get_MetaData() +102
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) +602
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3152
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +704
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +121
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +307
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +600
NHibernate.Id.InsertSelectDelegate.ExecuteAndExtract(IDbCommand insert, ISessionImplementor session) +73
NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) +116

[GenericADOException: could not insert: [UCommerce.EntitiesV2.ProductCatalogDescription][SQL: INSERT INTO uCommerce_ProductCatalogDescription (CultureCode, DisplayName, ProductCatalogId) VALUES (?, ?, ?); select SCOPE_IDENTITY()]]
NHibernate.Id.Insert.AbstractReturningDelegate.PerformInsert(SqlCommandInfo insertSQL, ISessionImplementor session, IBinder binder) +361
NHibernate.Persister.Entity.AbstractEntityPersister.Insert(Object[] fields, Object obj, ISessionImplementor session) +271
NHibernate.Action.EntityIdentityInsertAction.Execute() +196
NHibernate.Engine.ActionQueue.Execute(IExecutable executable) +42
NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +948
NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +265
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) +58
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) +127
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) +320
NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) +151
NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj) +148
NHibernate.Engine.Cascade.CascadeToOne(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) +230
NHibernate.Engine.Cascade.CascadeCollectionElements(Object parent, Object child, CollectionType collectionType, CascadeStyle style, IType elemType, Object anything, Boolean isCascadeDeleteEnabled) +542
NHibernate.Engine.Cascade.CascadeCollection(Object parent, Object child, CascadeStyle style, Object anything, CollectionType type) +265
NHibernate.Engine.Cascade.CascadeAssociation(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled) +252
NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything) +603
NHibernate.Event.Default.AbstractSaveEventListener.CascadeAfterSave(IEventSource source, IEntityPersister persister, Object entity, Object anything) +156
NHibernate.Event.Default.AbstractSaveEventListener.PerformSaveOrReplicate(Object entity, EntityKey key, IEntityPersister persister, Boolean useIdentityColumn, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +1481
NHibernate.Event.Default.AbstractSaveEventListener.SaveWithGeneratedId(Object entity, String entityName, Object anything, IEventSource source, Boolean requiresImmediateIdAccess) +265
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.SaveWithGeneratedOrRequestedId(SaveOrUpdateEvent event) +58
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event) +127
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) +320
NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) +151
NHibernate.Impl.SessionImpl.SaveOrUpdate(Object obj) +137
UCommerce.EntitiesV2.Repository`1.Save(T entity) +52
UCommerce.Pipelines.Catalog.Admin.ProductCatalogSave.SaveProductCatalogTask.Execute(ProductCatalog subject) +17
UCommerce.Pipelines.Pipeline`1.Execute(T subject) +387

[PipelineException: Exception occoured while processing pipeline 'UCommerce.Pipelines.Catalog.ProductCatalogPipeline'. See inner exception for details.]
UCommerce.Pipelines.Pipeline`1.Execute(T subject) +1326
UCommerce.Presentation.Presenters.Catalog.EditProductCatalogPresenter.View_Save(Object sender, EntityCommandEventArgs`1 e) +645
UCommerce.Web.UI.Catalog.EditProductCatalog.OnSave(Object sender, EventArgs e) +125
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +144
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +186
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1735

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Richard Brisley shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
declined  ·  Support responded  · 

Please send support requests to http://eureka.ucommerce.net where the support team is actively working to help issues like this. Apologies for the inconvenience.

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base