The DPU is returning error messages (see below) like the one below for all 50 products. I have checked that the Category field (Categories) match the entries I uploaded prior.
I know the import utility is connecting correctly because I tested the program by attempting to import the same file by eliminating the category field and was successful in uploading, however, the products get classified as "orphans" -- thereby requiring manual data manipulation to get them back into the category listings.
Any possible explanation on the error messages and how to correct?.
***************
Below is a sample error message for just one of the 50 entries...
Code: Select all
[Import(Upload) Information]:-
Importing 50 Products
Invalid column name 'Categories'.
ImportOrUpdate unsuccessful for Product
ProductId = 0
Name = Wheat Tortilla filled with Potatoes Eggs and Spanish Beef Chorizo
Error message: Invalid column name 'Categories'.
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.ExecuteReader(CommandBehavior behavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)
at CommerceBuilder.Data.Database.ExecuteReader(DbCommand command)
at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.af.a(Object A_0)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.a(Array A_0, Type A_1, String A_2, String A_3, String A_4, Object A_5, aa A_6, z A_7, ae A_8, c A_9, String A_10)
Base Exception: Invalid column name 'Categories'.
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.ExecuteReader(CommandBehavior behavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command)
at CommerceBuilder.Data.Database.ExecuteReader(DbCommand command)
at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria, Int32 maximumRows, Int32 startRowIndex, String sortExpression)
at CommerceBuilder.Products.ProductDataSource.LoadForCriteria(String sqlCriteria)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.af.a(Object A_0)
at CommerceBuilder.DataClient.Api.ObjectHandlers.ImportHandler.a(Array A_0, Type A_1, String A_2, String A_3, String A_4, Object A_5, aa A_6, z A_7, ae A_8, c A_9, String A_10)