Error downloading Product Variants using 7.7.251

A forum where issues related to the DataPort utility can be discussed.
Post Reply
User avatar
RichWendrock
Commander (CMDR)
Commander (CMDR)
Posts: 134
Joined: Sat Apr 05, 2008 12:55 am
Location: Austin Texas
Contact:

Error downloading Product Variants using 7.7.251

Post by RichWendrock » Sat May 21, 2011 8:35 am

We are using dataport 7.7.251 and ablecommerce 7.06 with Api version 7.6.14430.0. I am running Dataport in Compatibility mode on Windows 7.

When I try to download the product variants as a CSV file, it runs for awhile and then displays the following error

Exception Message: Exception of type 'System.OutOfMemoryException' was thrown.
at CommerceBuilder.DataClient.Api.ACRequestHandler.ProcessRequest(StringrequestXml)
at
CommerceBuilder.DataClient.Api.AuthenticationHandler.System.web.IHttpHandler.ProcessRequest(HttpContest context)

Any idea what is causing this?
Regards,
Richard

http://www.TheHomePageStore.com

AbleCommerce
VERSION: 7.0.7.14588
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.3634

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Error downloading Product Variants using 7.7.251

Post by jmestep » Mon May 23, 2011 6:12 am

When I get that message, it just means there is too much data for the system memory. I haven't got it on a download yet, but I do get it occasionally on an Able 5 to 7 export/import.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
RichWendrock
Commander (CMDR)
Commander (CMDR)
Posts: 134
Joined: Sat Apr 05, 2008 12:55 am
Location: Austin Texas
Contact:

Re: Error downloading Product Variants using 7.7.251

Post by RichWendrock » Mon May 23, 2011 8:28 am

Hi Judy,
This is not a large store. We have perhaps 1,100 products. Are you saying the dataport utility tries to store all variants in memory before writing them to the CSV file?

Thanks for your response by the way...
Regards,
Richard

http://www.TheHomePageStore.com

AbleCommerce
VERSION: 7.0.7.14588
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.3634

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Error downloading Product Variants using 7.7.251

Post by jmestep » Mon May 23, 2011 10:43 am

I'm not sure what all Able does with creating the variants file.
I just ran a variants export on a site with 3367 products, chunk size left at 50, no custom mapping and didn't get a memory problem on my local computer - but I've got 8GM of ram. Resulting file was 2,888 kb.
I am using dataport 7.6, though.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

User avatar
RichWendrock
Commander (CMDR)
Commander (CMDR)
Posts: 134
Joined: Sat Apr 05, 2008 12:55 am
Location: Austin Texas
Contact:

Re: Error downloading Product Variants using 7.7.251

Post by RichWendrock » Mon May 23, 2011 11:52 am

Thanks for the information. I have 12gb memory installed and I am using dataport defaults, i.e. did not change the chunk size. I have been reading the dataport documentation again to see if I missed anything. I will post here if I get by the error.
Regards,
Richard

http://www.TheHomePageStore.com

AbleCommerce
VERSION: 7.0.7.14588
MSSQL v2005
AC SCHEMA v2005
.NET CLR v2.0.50727.3634

Post Reply