AbleCommerce Shopping Cart Software

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?

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

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.

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.

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!

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.