Developer forum

Forum » Ecommerce - Standard features » Error creating Ecom Product Category on 8.2.2.2

Error creating Ecom Product Category on 8.2.2.2

Diogo Lino
Reply

Hello,

I'm using version 8.2.2.2 and after trying to create a new group of products on a Store I get the error "Invalid object name 'EcomProductCategory'" and if I try to save the first product that comes with the database, I get the error "Invalid object name 'EcomProductCategoryFieldValue'".

Is this a known bug from this version?

 

Thanks,

Diogo

 

 

Invalid object name 'EcomProductCategory'.
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: Invalid object name 'EcomProductCategory'.

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): Invalid object name 'EcomProductCategory'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062238
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050268
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
   Dynamicweb.Database.CreateDataReader(String sql, String database, IDbConnection connection, Int32 commandTimeout) +666
   Dynamicweb.eCommerce.Products.Categories.Category.get_CachedCategories() +199
   Dynamicweb.eCommerce.Products.Categories.Category.GetCategories(String languageID) +85
   Dynamicweb.Admin.eComBackend.EcomGroupEdit.LoadProductCategories(Group grp) +89
   Dynamicweb.Admin.eComBackend.EcomGroupEdit.LoadProductDefaults(Group grp) +20
   Dynamicweb.Admin.eComBackend.EcomGroupEdit.Page_Load(Object sender, EventArgs e) +1457
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207


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

 

 Invalid object name 'EcomProductCategoryFieldValue'.
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: Invalid object name 'EcomProductCategoryFieldValue'.

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): Invalid object name 'EcomProductCategoryFieldValue'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2062238
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050268
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +228
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +326
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   Dynamicweb.eCommerce.Products.Product.SaveAndConfirm(String ProductID, String ProductVariantID, String ProductLanguageID, Boolean skipExtendedSave) +5637
   Dynamicweb.Admin.eComBackend.ProductEdit.SaveProduct(Product prod, String prodId, String groupId, String variantId, Boolean VariantProduct, Boolean WizardProduct, String redirUrl, Boolean closeAfterSave) +2842
   Dynamicweb.Admin.eComBackend.ProductEdit.SaveAndCloseProduct_Click(Object sender, EventArgs e) +206
   Dynamicweb.Controls.RibbonBarButton.RaisePostBackEvent(String eventArgument) +33
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563


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

 

 


Replies

 
Nicolai Høeg Pedersen
Reply
This post has been marked as an answer

Hi Diego

 

It sounds like the update of the database to 8.2 has something missing. The switch updates the database structure for product categories and that is the thing that have gone wrong.

See the release document on product categories here:

http://developer.dynamicweb-cms.com/releases/dynamicweb-8.2/release-notes-8.2.aspx

 

This might fix your issue - otherwise contact service desk and they can help you force the update.

 

BR Nicolai

Votes for this answer: 1
 
Diogo Lino
Reply

Hi

I forced the updates and it worked.

Thanks,

Diogo

 

You must be logged in to post in the forum