Error: Value does not fall within the expected range on the sample data Catalog import. How safe
Hello,
I was able to successfully install the Startersite on an XP machine and CS 2007 Developer Edition (With Max Akbar's help ofcourse) But when I tried to load the sample data, I get the following error:
Importing catalog:
Error: Value does not fall within the expected range.
Also, on the starter site home page I am not able to see any products etc (obviously maybe because the sample data could not be loaded)
When I looked the error up, the suggested fix is installing a hotfix from microsoft (Article ID: 920867). Would it be the fix to this problem?
Also, can anyone please advise if it is safe to install this hotfix? When I called up Microsoft for this fix (since it is private one), they warned me saying it is not tested and not to install unless absolutely necessary. Now I am scared to install it. Can anyone please tell me if there is another way to load the sample data or how safe this installation of the hotfix will be?
Will greatly appreciate your help. I really need this data into the system soon.
Thanks,
Nicky
Nicky,
If you're just concerned with getting the Product Catalog / Inventory data imported into the system, both of those XML files are included in the starter site zip folder (as AdvWorksCatalog.xml and AdvWorksInventoryCatalog.xml, respectively). As such, if you've set up the CatalogWebService's authorization manager store correctly, you *should* be able to add the catalogs through the Catalog Manager Application's Import option.
If you need to add the rest of the data from SampleDataImport.exe (Payment Methods, Shipping Methods, etc), you'll probably need to find a way to get that application working.
The hotfix looks like it'll fix your problem, but just remember that any adverse effects caused by the hotfix aren't MSFT's fault (which is why they warn you in the first place). <soapbox>All the more reason for people to virtualize the development environment, I suppose. Then again, if you had virtualized the development environment, you wouldn't be developing on Windows XP to begin with.</soapbox>
Hello Joe,
Thanks for the response.
For the hotfix, are there any known "adverse effects"?
When I use the SampleDataImport.exe, I get the following statements at the command prompt:
Loading data into site: StarterSite
Connecting to Catalog system: Done.
Connecting to Orders system: Done.
Connecting to Marketing system: Done.
Adding the user MY-WORK\NickyD to AzMan policy files:
MarketingAuthorizationStore.xml
MarketingSystem
MarketingAdministrator
OrdersAuthorizationStore.xml
OrderSystem
OrdersAdministrator
ProfilesAuthorizationStore.xml
ProfileSystem
ProfileAdministrator
CatalogAuthorizationStore.xml
CatalogandInventorySystem
Administrator
Creating payment methods:
Visa
Mastercard
Discover
American Express
Creating shipping methods:
Ground (5-7 Days)
Second-Day Air
Next-Day Air
Generating encryption keys: Done.
Adding encryption keys to web.config: Done.
Adding encryption keys to web.config for the ProfilesWebService: Done.
Importing catalog:
Error: Value does not fall within the expected range.
And then it stops. Does this mean I have the shipping methods, payment methods already installed? What else comes with the sample data import? The reason I am asking is: I am trying to see if importing the Product Catalog and Inventory Data suffice.
Thanks a ton for your help. Looking forward to your reply.
Nicky
You'd have to ask the MS product team if there are any known adverse affects to the Hotfix. Chances are, it's just something put together by the QFE team and they don't have the time to thoroughly test it, but it was probably sufficient enough to close the support case.
I haven't run the SampleDataImport through Reflector or anything like that, so I'm not sure if it's running any of that as a transacted process. I'm assuming it's not, so you're probably ok with just importing the catalog. Take a look in your transaction_config database and see if it populated shipping methods and payment methods, that should be enough to tell you if it worked. I don't think it adds anything else into the system, so you should be ready to go once that is done.
Hello Joe,
Thanks for trying to help me out here.
I looked into the transactionConfig database and it is populated. So I tried to import the two catalogs (AdvWorksCatalog and AdvWorksInventoryCatalog) but I get the same error in the event log.
An Exception occured in the 'CatalogWebService' Web service.
Exception details below:
System.ArgumentException: Value does not fall within the expected range.
This is followed by the stack trace.
Can you please tell me what other options do I have now? Is installing the hotfix the only way out?
Please help!!
Thanks,
Nicky