|
Home > Archive > Commerce Server General > September 2006 > Catalog import error - I cant figure what it means
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Catalog import error - I cant figure what it means
|
|
| CodeDigger 2006-09-16, 7:28 pm |
| I am trying to send catalog data to Commerce Server from Biztalk. I have set
the Pipelines to be XmlReceive and XmlTransmit.
When I drop in a Catalog import xml file, I get this -
"<CommerceServerCatalogImportResponse><CatalogImportError LineNumber="13"
Message="Invalid column name 'NewCallout'. Invalid column name
'PromoCallout'." /></CommerceServerCatalogImportResponse>"
For the life of me I cannot figure out what this message means. NewCallout
and PromoCallout are 2 optional custom properties defined, but with or
without them the import fails.
Here is a sample of the Product data I send in. If you want the complete
Catalog schema and the Import XML, they are here -
http://www.percepsys.com/marketing/CatalogXML.zip
(the default schema has been modified by adding some custom properties and
deployed to the Biztalk application)
<Product Definition="Appliance Product" ProductId="A8461"
UseCategoryPricing="0" listprice="99.9500" lastmodified="2006-09-12T17:48:07"
BrandCode="1" BrandName="Solano" FolicaWarrantyAvailable="0" FreeShipping="1"
IsAvailable="1" IsDiscontinued="0" IsHazardous="0"
ManufacturerSKU="SO-1875-747" NewCallout="Great Hairdryer"
PackageWeight="3.0" ProductName="Solano Platinum Professional Hair Dryer"
ProfessionalOnly="0" PromoCallout="Best Hair Dryer" ShowAvailableQuantity="0"
SuggestedRetailPrice="115.0000" TriggerAmazon="0" TriggerYahoo="0"
Visible="1" id="Id_8461">
<DisplayName Value="Solano Platinum Professional Hair Dryer"
language="en-US" />
<ImageURL Value="2973-A8461.gif" language="en-US" />
<LongDescription Value="Made in Italy. The most powerful professional
hair dryer that features stunning metal design with maximum turbo power."
language="en-US" />
<Power Value="1875 watts" language="en-US" />
<SellingFeatures Value="1875 watts provides powerful airflow for fast
drying" language="en-US" />
<ParentCategory rank="0">hairdryers</ParentCategory>
</Product>
(I am reposting this because I need a answer and I mistakenly maked a
previous post as having solved my problem)
| |
| Sudha Raghavan [MSFT] 2006-09-16, 7:28 pm |
| Hi
Have you tried importing the XML files using the Catalog Manager UI? Do you
get the same errors?
Also are you doing a FULL or Incremental import?
If you have virtual catalogs in the system, can you try rebuilding them and
then doing the import?
Thanks
Sudha
--------------------
Thread-Topic: Catalog import error - I cant figure what it means
thread-index: AcbXcFDaz8DLK0H6Qw683PESi7r4Ew==
X-WBNR-Posting-Host: 70.26.112.25
From: =?Utf-8?B?Q29kZURpZ2dlcg==?= <CodeDigger@discussions.microsoft.com>
Subject: Catalog import error - I cant figure what it means
Date: Wed, 13 Sep 2006 13:08:01 -0700
Lines: 43
Message-ID: <120F6E0C-FB66-4829-B9CB-63713FFC084E@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18414
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
I am trying to send catalog data to Commerce Server from Biztalk. I have
set
the Pipelines to be XmlReceive and XmlTransmit.
When I drop in a Catalog import xml file, I get this -
"<CommerceServerCatalogImportResponse><CatalogImportError LineNumber="13"
Message="Invalid column name 'NewCallout'. Invalid column name
'PromoCallout'." /></CommerceServerCatalogImportResponse>"
For the life of me I cannot figure out what this message means. NewCallout
and PromoCallout are 2 optional custom properties defined, but with or
without them the import fails.
Here is a sample of the Product data I send in. If you want the complete
Catalog schema and the Import XML, they are here -
http://www.percepsys.com/marketing/CatalogXML.zip
(the default schema has been modified by adding some custom properties and
deployed to the Biztalk application)
<Product Definition="Appliance Product" ProductId="A8461"
UseCategoryPricing="0" listprice="99.9500"
lastmodified="2006-09-12T17:48:07"
BrandCode="1" BrandName="Solano" FolicaWarrantyAvailable="0"
FreeShipping="1"
IsAvailable="1" IsDiscontinued="0" IsHazardous="0"
ManufacturerSKU="SO-1875-747" NewCallout="Great Hairdryer"
PackageWeight="3.0" ProductName="Solano Platinum Professional Hair Dryer"
ProfessionalOnly="0" PromoCallout="Best Hair Dryer"
ShowAvailableQuantity="0"
SuggestedRetailPrice="115.0000" TriggerAmazon="0" TriggerYahoo="0"
Visible="1" id="Id_8461">
<DisplayName Value="Solano Platinum Professional Hair Dryer"
language="en-US" />
<ImageURL Value="2973-A8461.gif" language="en-US" />
<LongDescription Value="Made in Italy. The most powerful professional
hair dryer that features stunning metal design with maximum turbo power."
language="en-US" />
<Power Value="1875 watts" language="en-US" />
<SellingFeatures Value="1875 watts provides powerful airflow for fast
drying" language="en-US" />
<ParentCategory rank="0">hairdryers</ParentCategory>
</Product>
(I am reposting this because I need a answer and I mistakenly maked a
previous post as having solved my problem)
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs
Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
| |
| CodeDigger 2006-09-16, 7:28 pm |
| Good idea, tried that and getting the exact same errors -
Line 13: Invalid column name 'NewCallout'. Invalid column name 'PromoCallout'.
Note that Both properties shows up (multiple times) in the
CatalogDefinitionProperties table in “Product catalog” database as well as
in the Edit Catalog properties from the Catalog Manager (user application).
So I think its safe to say these properties are there in the database.
Note - even if I do take out NewCallout and PromoCallout I stll get this
error. I am a Biztalk developer, not Commerce Server specialist and I really
need to understand the source of this error
"Sudha Raghavan [MSFT]" wrote:
> Hi
>
> Have you tried importing the XML files using the Catalog Manager UI? Do you
> get the same errors?
>
> Also are you doing a FULL or Incremental import?
> If you have virtual catalogs in the system, can you try rebuilding them and
> then doing the import?
>
> Thanks
> Sudha
> --------------------
| |
| Sudha Raghavan [MSFT] 2006-09-16, 7:28 pm |
| Which one did you try?
If you tried the import using the Catalog Manager UI, can you tell me what
options you set in the Import Wizard. Also before doing the import, can you
use the "Edit" Menu and try "Rebuild All". Then go to the "Status" View and
wait for the rebuild to complete.
Thanks
Sudha
--------------------
Thread-Topic: Catalog import error - I cant figure what it means
thread-index: AcbXmES2v5H2XEqgRZ2xpwrRz+JqdQ==
X-WBNR-Posting-Host: 70.26.112.25
From: =?Utf-8?B?Q29kZURpZ2dlcg==?= <CodeDigger@discussions.microsoft.com>
References: <120F6E0C-FB66-4829-B9CB-63713FFC084E@microsoft.com>
<4K724y31GHA.4916@TK2MSFTNGXA01.phx.gbl>
Subject: RE: Catalog import error - I cant figure what it means
Date: Wed, 13 Sep 2006 17:54:01 -0700
Lines: 31
Message-ID: <6AE9DD79-B41B-43FB-9570-F97C38DCF77E@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18417
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Good idea, tried that and getting the exact same errors -
Line 13: Invalid column name 'NewCallout'. Invalid column name
'PromoCallout'.
Note that Both properties shows up (multiple times) in the
CatalogDefinitionProperties table in “Product catalog” database as
well as
in the Edit Catalog properties from the Catalog Manager (user application).
So I think its safe to say these properties are there in the database.
Note - even if I do take out NewCallout and PromoCallout I stll get this
error. I am a Biztalk developer, not Commerce Server specialist and I
really
need to understand the source of this error
"Sudha Raghavan [MSFT]" wrote:
> Hi
>
> Have you tried importing the XML files using the Catalog Manager UI? Do
you
> get the same errors?
>
> Also are you doing a FULL or Incremental import?
> If you have virtual catalogs in the system, can you try rebuilding them
and
> then doing the import?
>
> Thanks
> Sudha
> --------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Have a Commerce Server “How To” question? Help is a click away at our
Chats, Newsgroups and Web logs
Chats (2nd Wednesday of the month from 11 to Noon):
http://www.msdn.microsoft.com/chats/
Public newsgroups:
http://www.microsoft.com/technet/co...r/commerce.mspx
Web logs and community:
http://www.microsoft.com/commercese...ty/default.mspx
Other resources:
http://www.microsoft.com/technet/pr...02/default.mspx
| |
| Vinayak Tadas[MSFT] 2006-09-18, 7:36 pm |
| Does the PromoCallout property exist in the product's definition?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
Thread-Topic: Catalog import error - I cant figure what it means
thread-index: AcbXcFDaz8DLK0H6Qw683PESi7r4Ew==
X-WBNR-Posting-Host: 70.26.112.25
From: =?Utf-8?B?Q29kZURpZ2dlcg==?= <CodeDigger@discussions.microsoft.com>
Subject: Catalog import error - I cant figure what it means
Date: Wed, 13 Sep 2006 13:08:01 -0700
Lines: 43
Message-ID: <120F6E0C-FB66-4829-B9CB-63713FFC084E@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18414
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
I am trying to send catalog data to Commerce Server from Biztalk. I have
set
the Pipelines to be XmlReceive and XmlTransmit.
When I drop in a Catalog import xml file, I get this -
"<CommerceServerCatalogImportResponse><CatalogImportError LineNumber="13"
Message="Invalid column name 'NewCallout'. Invalid column name
'PromoCallout'." /></CommerceServerCatalogImportResponse>"
For the life of me I cannot figure out what this message means. NewCallout
and PromoCallout are 2 optional custom properties defined, but with or
without them the import fails.
Here is a sample of the Product data I send in. If you want the complete
Catalog schema and the Import XML, they are here -
http://www.percepsys.com/marketing/CatalogXML.zip
(the default schema has been modified by adding some custom properties and
deployed to the Biztalk application)
<Product Definition="Appliance Product" ProductId="A8461"
UseCategoryPricing="0" listprice="99.9500"
lastmodified="2006-09-12T17:48:07"
BrandCode="1" BrandName="Solano" FolicaWarrantyAvailable="0"
FreeShipping="1"
IsAvailable="1" IsDiscontinued="0" IsHazardous="0"
ManufacturerSKU="SO-1875-747" NewCallout="Great Hairdryer"
PackageWeight="3.0" ProductName="Solano Platinum Professional Hair Dryer"
ProfessionalOnly="0" PromoCallout="Best Hair Dryer"
ShowAvailableQuantity="0"
SuggestedRetailPrice="115.0000" TriggerAmazon="0" TriggerYahoo="0"
Visible="1" id="Id_8461">
<DisplayName Value="Solano Platinum Professional Hair Dryer"
language="en-US" />
<ImageURL Value="2973-A8461.gif" language="en-US" />
<LongDescription Value="Made in Italy. The most powerful professional
hair dryer that features stunning metal design with maximum turbo power."
language="en-US" />
<Power Value="1875 watts" language="en-US" />
<SellingFeatures Value="1875 watts provides powerful airflow for fast
drying" language="en-US" />
<ParentCategory rank="0">hairdryers</ParentCategory>
</Product>
(I am reposting this because I need a answer and I mistakenly maked a
previous post as having solved my problem)
|
|
|
|
|