|
Home > Archive > Commerce Server Catalog > July 2006 > Error saving product with variants in Catalog Manager
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error saving product with variants in Catalog Manager
|
|
| Suman Palit 2005-03-11, 8:51 pm |
| Hi,
I get this error when trying to save more than 3 variant combinations for a
product using the catalog manager. This is the error from the event viewer:
anyone seen this before?
Event Type: Error
Event Source: CS Web Services
Event Category: None
Event ID: 1
Date: 3/11/2005
Time: 3:41:11 PM
User: N/A
Description:
An exception occurred in the 'CatalogWebService' Web service. Exception
details follow:
Microsoft.CatalogServer.CatalogDatabaseException: Could not set the
category/product/variant information. --->
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This
is not permitted when the subquery follows =, !=, <, <= , >, >= or when the
subquery is used as an expression.
The statement has been terminated.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at
Microsoft.CatalogServer.Internal.CommonHelpers. SetProductCategoryVariantProperties(Cata
logExecutionContext
executionContext, String catalogName, Boolean isVirtualCatalog, String
language, String productProperty, String variantProperty, DataSet
updatedDataSet)
--- End of inner exception stack trace ---
at
Microsoft.CatalogServer.Internal.CommonHelpers. SetProductCategoryVariantProperties(Cata
logExecutionContext
executionContext, String catalogName, Boolean isVirtualCatalog, String
language, String productProperty, String variantProperty, DataSet
updatedDataSet)
at
Microsoft.CatalogServer.Internal.Product.SetProperties(CatalogItemsDataSet
updatedCatalogItem)
at Microsoft.CatalogServer.Internal.CatalogItem.Save(Boolean forceUpdate,
CatalogItem updatedCatalogItem)
at Microsoft.CatalogServer.Internal.Product.Save(Boolean forceUpdate,
Product updatedProduct)
at
Microsoft.CatalogServer.WebService.CatalogWebService.SaveProduct(Product
updatedProduct, Boolean forceUpdate)
| |
| Ragini Singh [MSFT] 2005-03-21, 5:59 pm |
| What do you mean by "I get this error when trying to save more than 3
variant combinations for a
product using the catalog manager". So the scneario is something like, open
a product for editing, add three variants and hit Save?
Ragini Singh
BPI - Commerce Server
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Thread-Topic: Error saving product with variants in Catalog Manager
thread-index: AcUmqrJapg9BLrkdT7mjwhGsSN+cIA==
X-WBNR-Posting-Host: 216.133.160.216
From: "=?Utf-8?B?U3VtYW4gUGFsaXQ=?=" <SumanPalit@discussions.microsoft.com>
Subject: Error saving product with variants in Catalog Manager
Date: Fri, 11 Mar 2005 18:25:02 -0800
Lines: 49
Message-ID: <C774561A-59A9-4DA4-8D02-AF59E41273D1@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.commerceserver.catalog:5301
X-Tomcat-NG: microsoft.public.commerceserver.catalog
Hi,
I get this error when trying to save more than 3 variant combinations for a
product using the catalog manager. This is the error from the event viewer:
anyone seen this before?
Event Type: Error
Event Source: CS Web Services
Event Category: None
Event ID: 1
Date: 3/11/2005
Time: 3:41:11 PM
User: N/A
Description:
An exception occurred in the 'CatalogWebService' Web service. Exception
details follow:
Microsoft.CatalogServer.CatalogDatabaseException: Could not set the
category/product/variant information. --->
System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
This
is not permitted when the subquery follows =, !=, <, <= , >, >= or when the
subquery is used as an expression.
The statement has been terminated.
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
at
Microsoft.CatalogServer.Internal.CommonHelpers.SetProductCategoryVariantProp
erties(CatalogExecutionContext
executionContext, String catalogName, Boolean isVirtualCatalog, String
language, String productProperty, String variantProperty, DataSet
updatedDataSet)
--- End of inner exception stack trace ---
at
Microsoft.CatalogServer.Internal.CommonHelpers.SetProductCategoryVariantProp
erties(CatalogExecutionContext
executionContext, String catalogName, Boolean isVirtualCatalog, String
language, String productProperty, String variantProperty, DataSet
updatedDataSet)
at
Microsoft.CatalogServer.Internal.Product.SetProperties(CatalogItemsDataSet
updatedCatalogItem)
at Microsoft.CatalogServer.Internal.CatalogItem.Save(Boolean
forceUpdate,
CatalogItem updatedCatalogItem)
at Microsoft.CatalogServer.Internal.Product.Save(Boolean forceUpdate,
Product updatedProduct)
at
Microsoft.CatalogServer.WebService.CatalogWebService.SaveProduct(Product
updatedProduct, Boolean forceUpdate)
Ragini Singh
BPI - Commerce Server
This posting is provided "AS IS" with no warranties, and confers no rights.
| |
| Suman Palit 2005-03-22, 6:03 pm |
| Yes, I open a product, add three variants and I get the error when I hit
save. It appears to be an occasional problem, and is not consistent across
products.
It seems to happen a lot when I use BizDesk to first edit a product
definition by adding a new variant attribute, then if I go into any existing
product under that product definition(through the CS Web Service) and try to
edit the variants by specifying values for the new variant attribute.
"Ragini Singh [MSFT]" wrote:
> What do you mean by "I get this error when trying to save more than 3
> variant combinations for a
> product using the catalog manager". So the scneario is something like, open
> a product for editing, add three variants and hit Save?
>
> Ragini Singh
> BPI - Commerce Server
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --------------------
> Thread-Topic: Error saving product with variants in Catalog Manager
> thread-index: AcUmqrJapg9BLrkdT7mjwhGsSN+cIA==
> X-WBNR-Posting-Host: 216.133.160.216
> From: "=?Utf-8?B?U3VtYW4gUGFsaXQ=?=" <SumanPalit@discussions.microsoft.com>
> Subject: Error saving product with variants in Catalog Manager
> Date: Fri, 11 Mar 2005 18:25:02 -0800
> Lines: 49
> Message-ID: <C774561A-59A9-4DA4-8D02-AF59E41273D1@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.commerceserver.catalog
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
> Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.commerceserver.catalog:5301
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> Hi,
>
> I get this error when trying to save more than 3 variant combinations for a
> product using the catalog manager. This is the error from the event viewer:
> anyone seen this before?
>
> Event Type: Error
> Event Source: CS Web Services
> Event Category: None
> Event ID: 1
> Date: 3/11/2005
> Time: 3:41:11 PM
> User: N/A
>
> Description:
> An exception occurred in the 'CatalogWebService' Web service. Exception
> details follow:
>
> Microsoft.CatalogServer.CatalogDatabaseException: Could not set the
> category/product/variant information. --->
> System.Data.SqlClient.SqlException: Subquery returned more than 1 value.
> This
> is not permitted when the subquery follows =, !=, <, <= , >, >= or when the
> subquery is used as an expression.
> The statement has been terminated.
> at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
> DataTableMapping tableMapping)
> at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
> srcTable)
> at
> Microsoft.CatalogServer.Internal.CommonHelpers.SetProductCategoryVariantProp
> erties(CatalogExecutionContext
> executionContext, String catalogName, Boolean isVirtualCatalog, String
> language, String productProperty, String variantProperty, DataSet
> updatedDataSet)
> --- End of inner exception stack trace ---
> at
> Microsoft.CatalogServer.Internal.CommonHelpers.SetProductCategoryVariantProp
> erties(CatalogExecutionContext
> executionContext, String catalogName, Boolean isVirtualCatalog, String
> language, String productProperty, String variantProperty, DataSet
> updatedDataSet)
> at
> Microsoft.CatalogServer.Internal.Product.SetProperties(CatalogItemsDataSet
> updatedCatalogItem)
> at Microsoft.CatalogServer.Internal.CatalogItem.Save(Boolean
> forceUpdate,
> CatalogItem updatedCatalogItem)
> at Microsoft.CatalogServer.Internal.Product.Save(Boolean forceUpdate,
> Product updatedProduct)
> at
> Microsoft.CatalogServer.WebService.CatalogWebService.SaveProduct(Product
> updatedProduct, Boolean forceUpdate)
>
>
> Ragini Singh
> BPI - Commerce Server
>
> This posting is provided "AS IS" with no warranties, and confers no rights
| |
| prit999 2006-06-07, 5:21 am |
| Hey,
did you ever resolve the issue? getting a similar issue.
Thanks. | |
|
| Hi,
I usually find that after changing definitions that the app usually
needs to be recycled to register these new definition changes otherwise
it usually causes an error. You may be able to get away with just
flushing out the product cache.
If the products that are being changed are in a virtual catalog this
also may need rebuilding.
Rory
prit999 wrote:
> Hey,
>
> did you ever resolve the issue? getting a similar issue.
>
> Thanks.
>
>
>
> --
> prit999
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message952549.html
| |
|
| Hi,
I usually find that after changing definitions that the app usually
needs to be recycled to register these new definition changes otherwise
it usually causes an error. You may be able to get away with just
flushing out the product cache.
If the products that are being changed are in a virtual catalog this
also may need rebuilding.
Rory
prit999 wrote:
> Hey,
>
> did you ever resolve the issue? getting a similar issue.
>
> Thanks.
>
>
>
> --
> prit999
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message952549.html
|
|
|
|
|