Dataport 7.0.2 - Authentication Error! - Password is null

[ZLA]

I'm trying to use Dataport for the first time and it isn't working. I'm trying to upload categories via CSV (Import New and Update Existing). I'm running this on my local development machine against a DEMO version of AC7.0.2.

Attached is the first error dialog. It also gives an error message about no response from server. After doing that 2 or three times in a row, I get the summary which states:

Categories Import(Upload) Log Dated:5/11/2009 9:12:51 PM
User Name:- me@whatever.com
Store:- Stork Gifts DEV
Service URL:- http://localhost/StorkGifts/ClientApi/C ... rvice.ashx
Start Time:- 5/11/2009 9:12:15 PM End Time:- 5/11/2009 9:12:51 PM
Total Categories:- 86 Chunk Size:- 50
Imported File:- D:\My Documents\My Clients\Stork Gifts\Catalog\Stork Categories Org1.csv
************************************************************

[Import(Upload) Information]:-

************************************************************

[Error Information] :-
No Error
************************************************************

CommerceBuilder.DataClient.Api.dll is version 7.0.2.1 while CommerceBuilder.DataClient.Csv.dll is version 7.0.34.0. Both were downloaded today. Please help!

[Naveed]

You have posted the complete information about the DataPort version and api version. Can you please also post the store version and build number?

You can get this information from:
Admin -> Help -> About AbleCommerce page of your store administration.

[ZLA]

PLATFORM: ASP.NET
VERSION: 7.0.2
BUILD: 11659

AjaxControlToolkit: 1.0.10301.0
CommerceBuilder: 7.2.11602.0
CommerceBuilder.AbleCommerceTax: 7.2.11310.0
CommerceBuilder.AcTestProvider: 1.0.0.0
CommerceBuilder.AustraliaPost: 7.1.0.0
CommerceBuilder.AuthorizeNet: 7.0.9764.0
CommerceBuilder.CanadaPost: 7.0.0.0
CommerceBuilder.CCH: 7.0.0.0
CommerceBuilder.Configuration: 7.2.11602.0
CommerceBuilder.CyberSource: 7.0.9310.0
CommerceBuilder.Data: 7.2.11602.0
CommerceBuilder.DataClient.Api: 7.0.2.1
CommerceBuilder.DataClient.Csv: 7.0.34.0
CommerceBuilder.DHL: 7.2.11307.0
CommerceBuilder.DHLInternational: 7.2.11307.0
CommerceBuilder.ECB: 7.0.0.0
CommerceBuilder.FedEx: 7.0.9725.0
CommerceBuilder.FRBNY: 7.0.0.0
CommerceBuilder.GoogleCheckout: 7.0.10052.0
CommerceBuilder.InternetSecure: 7.0.9764.0
CommerceBuilder.LinkPoint: 7.0.9764.0
CommerceBuilder.Paradata: 7.0.9764.0
CommerceBuilder.PayFlowPro: 7.0.10061.0
CommerceBuilder.PayJunction: 7.2.11284.0
CommerceBuilder.PayPal: 7.2.10840.0
CommerceBuilder.Protx: 7.1.10124.0
CommerceBuilder.Services: 7.2.11602.0
CommerceBuilder.SkipJack: 7.0.9764.0
CommerceBuilder.UPS: 7.0.10041.0
CommerceBuilder.USPS: 7.0.9728.0
CommerceBuilder.Web: 7.2.11602.0
ComponentArt.Web.UI: 2008.2.1175.3
CyberSource.Base: 2.0.0.0
CyberSource.Clients: 5.0.2.0
CyberSource.Clients.XmlSerializers: 5.0.2.0
CyberSource.WSSecurity: 2.0.0.0
CybsWSSecurityIOP: 1.0.0.0
FredCK.FCKeditorV2: 2.5.2912.21007
ICSharpCode.SharpZipLib: 0.85.5.452
LinkPointTransaction: 1.0.1797.29766
log4net: 1.2.10.0
Microsoft.Practices.EnterpriseLibrary.Common: 2.0.0.0
Microsoft.Practices.EnterpriseLibrary.Data: 2.0.0.0
Microsoft.Practices.ObjectBuilder: 1.0.51205.0
Microsoft.Web.Preview: 1.2.61025.0
NVelocity: 7.2.0.0
PaygatewayNET: 3.0.0.0
paypal_base: 4.2.1.0
PFProCOMLib: 1.0.0.0
PFProdotNET: 0.0.0.0
Validators: 1.0.0.0
WebChart: 1.1.1.6
wwHoverPanel: 1.85.0.0

[Naveed]

You must be using DataPort version 7.0.2.1 and all the reported version information seems to be correct. However the reported error is quite strange...

Now the only possibility I can guess that something is wrong with the categories CSV format... Can you please share one or two records of your categories csv file?

Another thing: can you export your existing categories data in csv format without any problems?

[ZLA]

Attached is the csv file (I changed extension to TXT so it would upload) I'm trying to use. It was given to me by my client and may have been generated last year using an earlier version of the Dataport. But when I try to download categories as CSV, I get the following error:

There is an error in XML document (2, 2).
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle, XmlDeserializationEvents events)
at System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader, String encodingStyle)
at System.Xml.Serialization.XmlSerializer.Deserialize(TextReader textReader)
at CommerceBuilder.DataClient.Api.EncodeHelper.Deserialize(String Xml, Type ThisType, Boolean defaultNull)
at CommerceBuilder.DataClient.Api.EncodeHelper.Deserialize(String Xml, Type ThisType)
at e.e()

One other note -- the csv file has image asset references but those images do not exist on this computer yet.

-- ZLA

[Naveed]

I was able to successfully import your provided data on my local install for 7.0.2 store and also manually reviewed your provided data and seems to very much OK.

Can you please re-start your web server or better your PC and try again?

[ZLA]

I restarted my computer and it gave the same error. I tried it with just the extract file I sent you, not the original file that had the problems. My current AC7 database has the original demo categories and about a dozen test ones I added.

Here's some more info about my configuration:

Dataport installed on C: drive.
IIS on C: Drive
website in virtual directory on D: drive.
uploaded file resides on D: drive but is not in web site folders

Any ideas, suggestions?

[Naveed]

Still unable to figure out the problem you are facing...

Lets confirm this check list:

1. You are using DataPort 7.0.2.1 and uploaded the correct api dll files to your store bin directory.

2. You can successfully connect the DataPort to the store without any errors or warning messages.

3. You can download other store data like products or users in csv or xml format.

4. You have problems while downloading categories and also when uploading categories.

Can you please play a little more with DataPort like downloading users or products data and let see if it reveals any other hints. Also if there are any entries in server log then please quote those as well.

[ZLA]

1. You are using DataPort 7.0.2.1 and uploaded the correct api dll files to your store bin directory.

2. You can successfully connect the DataPort to the store without any errors or warning messages.

Yes and Yes

3. You can download other store data like products or users in csv or xml format.

No.

a) Under Customized Download, as soon as I click on the Selected Categories, Selected Products, Selected Users, or Selected Orders radio button, I get the same authentication failed error message about a null password. If I then proceed with the XML download, I get the same popup error. Closing the error dialogs shows the download page in action but i'm sure that's just a started animation, not real progress occurring. For my local store, there are only the original users plus one. It should be less than a minute to generate.

b) If I try to download all users via XML, I get the same error dialog about null password.

4. You have problems while downloading categories and also when uploading categories.

Yes. Also problems uploading / downloading users and probably the other entities.

Can you please play a little more with DataPort like downloading users or products data and let see if it reveals any other hints. Also if there are any entries in server log then please quote those as well.

c) I also tried to upload the attached user CSV and got the same error.
d) I didn't see anything in the event logs.
e) When I copied in the new DLLS, I did the following:
- rename old bins as .dll_OLD
- copy in new dlls
- got an error when running the store website
- deleted .dll_OLD files
- Rebuilt web application? [don't know if I did not not but I have rebuilt it for other reasons since then]
- web site working normally
- try out dataport and get errors.

I'm going to try to create a new super user and see if that makes a difference. I can also try to uninstall / reinstall the dataport.

-- ZLA

[ZLA]

I'm going to try to create a new super user and see if that makes a difference. I can also try to uninstall / reinstall the dataport.

Tried both; no luck.

I ran the web site from Visual Studio and set a break point in the ashx page but when I ran the Data Port, it did not make use of the VS web server and step into the breakpoint. But let me know if that's a good idea and I just did something wrong with it.

-- ZLA

[ZLA]

PROGRESS!!!

This time, when I logged in to Dataport, I clicked Save Password. I don't usually have applications remember my password for me. And no more errors! Apparently, the password doesn't get stored properly if you don't select that option. Hopefully, you'll be able to track the bug down now.

Regards,

ZLA

[Naveed]

Thanks for tracking it down. I am now able to reproduce the issue... And going to report a new bug for it.

[ZLA]

Please post an update to this thread when an update is available for download so I can fix my copy. Thanks.

[Naveed]

Ok I will try to update the thread. Alternately you can subscribe the following announcement thread for an update.
viewtopic.php?f=61&t=10053

[ZLA]

Will do.