an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Using DotShoppingCart > V3.1 Bulk Import Bug on Categories
V3.1 Bulk Import Bug on Categories
Last Post 5/14/2009 10:52:18 AM By Bahram. 5 replies.
5/13/2009 10:23:14 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
V3.1 Bulk Import Bug on Categories
 
Hi Luke,
 
This is a very serious bug of V3.1 Import when Importing Categories :
 
 This is DSC_Category after Import :
 
categoryId  parentId  name                                                            imageId                                 description sortOrder showLevels showUsefulLinks PageHeaderId
1                   NULL      Data Loggers SmartReader                   NULL                                      NULL 0 2 1 1
2                    NULL     Data Loggers SmartReader Plus         NULL                                     NULL 0 2 1 16
 
 
The Import data were :
 
Data Loggers:SmartReader
Data Loggers:SmartReader Plus
 
This is the import on Category table, Data Loggers and SmarttReader where : seperated by : represent a category and sub cat.
 
The Import terminated after two Category records.
 
I deleted all data and ran Import again, No results This time
 
Bahram 
5/13/2009 11:14:25 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V3.1 Bulk Import Bug on Categories
Take the fix posted at the bottom of this article. 
DotShoppingCart Staff
5/13/2009 11:24:41 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: V3.1 Bulk Import Bug on Categories

The Import of categories Works but the errors are :
 
1- Import is incomplete , not Performed for all products
2- Error when Openning Website and click on a product
3- OrderPipeLine service is stopped.
 
 
<span>

Server Error in '/' Application.

The transaction log for database 'AcrStore_31' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

</span>
 
<span> 

Server Error in '/' Application.

 

An attempt has been made to Attach or Add an entity that is not new, perhaps having been loaded from another DataContext.  This is not supported.

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.NotSupportedException: An attempt has been made to Attach or Add an entity that is not new, perhaps having been loaded from another DataContext.  This is not supported.

Source Error:

<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td> 
Line 103:        }
Line 104:        if (null == block)
Line 105:            block = Block.GetByName(requestPath + ".aspx", config.DefaultBlock);
Line 106:
Line 107:        PageBlockContainerData containerData = Utils.FromXml<PageBlockContainerData>(block.Data.ToString());
</td> </tr> </tbody> </table>
Source File: d:\AcrStore_3.1\Web\Dynamic.aspx.cs    Line: 105

5/13/2009 3:38:13 PM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: V3.1 Bulk Import Bug on Categories

 

 
I finally make it work, After couple of tries. I increased the Transaction_Log file size and At the end I have to update the subcat counts manually
Do you need to include these commands at the end of your process.

exec

 

<font color="#0000ff" size="2"><font color="#0000ff" size="2">Hi Luke, dbo<font color="#808080" size="2"><font color="#808080" size="2">.DSC_Category_Populate_Manufacture_Count<font color="#0000ff" size="2"><font color="#0000ff" size="2">

exec

dbo<font color="#808080" size="2"><font color="#808080" size="2">.DSC_Category_Populate_PriceRange_Count<font color="#0000ff" size="2"><font color="#0000ff" size="2">

Update

dbo<font color="#808080" size="2"><font color="#808080" size="2">.DSC_Category <font color="#0000ff" size="2"><font color="#0000ff" size="2">set showLevels
 Bahram
5/13/2009 3:55:32 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: V3.1 Bulk Import Bug on Categories
No, I believe these two sprocs are being called by OrderPipeline every two hours. You just need to make sure OrderPipeline is running.
DotShoppingCart Staff
5/14/2009 10:52:18 AM
Bahram
Posts: 878
Joined: 12/8/2008
Location:Vancouver, BC Canada
Re: V3.1 Bulk Import Bug on Categories
 Hi Luke,
 
Any way Bulk Import has bugs, If it is working it does not mean it is Correct. I cleared all Data to do another bulk Import and It fails.
 
There are the problems.
 
1- Bulk Import or OrderPipeLine fill the transaction Log or make it increased so it stops
2- An error Occures and The OrderPipelIne Stops while Keeping Transaction Log in a Status that accepts nothing.
3-The Import if goes well is done very slow,
 
 
 
Bahram
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.