Data Port Error

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
User avatar
Tomgard
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 108
Joined: Sun Jul 20, 2008 1:00 pm

Data Port Error

Post by Tomgard » Tue Jul 22, 2008 3:19 pm

I have approx 63K items. During the upload and export of my file I get an error message "Error:The Underlying Connection was closed. An unexpected error occured on a receive."

This happens 30-50 times during an upload but does not seem to affect the data - as far as I can tell. It just temporarily stalls out the process until I click "OK". Any ideas as to what may be causing this?
Bryan Bundgaard
AC7 User http://www.SchoolSupplyStore.com

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Data Port Error

Post by Shopping Cart Admin » Tue Jul 22, 2008 5:50 pm

Hello,

Our dataport developer Naveed is out for the day. In the meantime confirm you're running the latest version of the dataport utility and that you've updated the dll's in the stores /bin directory.

Download Data Client Beta .19:
ftp://ftp.ablecommerce.com/evals/DataPort_1.0.0.19.zip
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Data Port Error

Post by Naveed » Wed Jul 23, 2008 7:48 am

I have done some research over it, and found that it is due to some bug in DotNet library. The underlying connection is closed prior to it being finished.

It is discussed at:
http://support.microsoft.com/default.as ... s%3b819450

I think the data will not be affected due to this error. Working over this for more details, and possible fix.

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Data Port Error

Post by Naveed » Wed Jul 23, 2008 8:07 am

This error may occur due to request timeout prior to completion. I think we can try to avoid this error by reducing the chunk size in DataPort settings.

Please try this and let me know if this reproduced:
1. Connect to your store using DataPort.
2. Navigate to settings screen ( Options -> Settings ).
3. Change the Chunk Size value from 50 to 10.
4. Export / Import your data again, and let me know if it commes again...

NOTE: the chunk size setting will only valid for your current session. If you will quit the DataPort once the original settings will be restored, and you have to modify the setting again.

User avatar
Tomgard
Lieutenant Commander (LCDR)
Lieutenant Commander (LCDR)
Posts: 108
Joined: Sun Jul 20, 2008 1:00 pm

Re: Data Port Error

Post by Tomgard » Thu Jul 24, 2008 11:19 pm

Naveed,
Your suggestion worked - thank you.

I ran into another issue today with duplicate items - I have a sequence of about 20K items that were duplicated when I used the data port tool. The only difference between the records were ProductID and CreatedDate. The CreatedDate was the same on both sets but the time was 0:00 on all 20K records. Not sure what went wrong - in the process of cleaning them directly from the server - hope it does not happen again! :)
Bryan Bundgaard
AC7 User http://www.SchoolSupplyStore.com

User avatar
Naveed
Rear Admiral (RADM)
Rear Admiral (RADM)
Posts: 611
Joined: Thu Apr 03, 2008 4:48 am

Re: Data Port Error

Post by Naveed » Fri Jul 25, 2008 1:17 am

Tomgard wrote: I ran into another issue today with duplicate items - I have a sequence of about 20K items that were duplicated when I used the data port tool. The only difference between the records were ProductID and CreatedDate. The CreatedDate was the same on both sets but the time was 0:00 on all 20K records. Not sure what went wrong - in the process of cleaning them directly from the server - hope it does not happen again! :)
There should be no duplicate items. The duplicate items can only be because of following reasons:

1. Your AC55 data contains duplicate item, and importing that data created duplicates...
2. You have imported the same data more then once. Thus causing the duplicate Items...

If you are sure that the above two reasons does not apply in your case, and you are able to reproduce the issue consistantly then it might be due to some bug which is not discoverd yet.

If you are able to reproduce the issue consistantly then please share your sample data with me eith on this thread, or send me in some private message.

Post Reply