|
Home > Archive > Commerce Server General > September 2006 > ExportCatalog - invalid column name?
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 |
ExportCatalog - invalid column name?
|
|
| Colin Bowern 2006-08-31, 7:36 pm |
|
These have exported fine in the past. Any thoughts on what would make them
invalid? There appears to be no verbose switches for the export catalog tool
either.
ExportCatalog.exe /S:Site MasterCatalog.xml
Connecting to site Site
Exporting to MasterCatalog.xml
0000:00 Exporting 20% complete
Completed: Failed
Error: MasterCatalog.xml(0): Invalid column name 'Region'.
Invalid column name 'EventDate'.
Invalid column name 'Location'.
Invalid column name 'Section'.
Invalid column name 'Tour'.
Invalid column name 'UseEventDateTime'.
Invalid column name 'Venue'.
Invalid column name 'VenueLink'.
Invalid column name 'Section'.
Invalid column name 'EventDate'.
Invalid column name 'Location'.
Invalid column name 'Tour'.
Invalid column name 'UseEventDateTime'.
Invalid column name 'Venue'.
Invalid column name 'VenueLink'.
Invalid column name 'Section'.
Invalid column name 'VariantOption2'.
Invalid column name 'EventDate'.
Invalid column name 'Location'.
Invalid column name 'Tour'.
Invalid column name 'UseEventDateTime'.
Invalid column name 'Venue'.
Invalid column name 'VenueLink'.
Invalid column name 'VariantOption2'.
Thanks,
Colin
| |
| Wendell 2006-09-01, 1:33 am |
| Colin,
Have you made any changes to the catalog schema through the schema
editor since you last exported this catalog?
Colin Bowern wrote:
> These have exported fine in the past. Any thoughts on what would make them
> invalid? There appears to be no verbose switches for the export catalog tool
> either.
>
> ExportCatalog.exe /S:Site MasterCatalog.xml
> Connecting to site Site
> Exporting to MasterCatalog.xml
> 0000:00 Exporting 20% complete
> Completed: Failed
> Error: MasterCatalog.xml(0): Invalid column name 'Region'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Section'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'Section'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'Section'.
> Invalid column name 'VariantOption2'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'VariantOption2'.
>
> Thanks,
> Colin
| |
| Sudha Raghavan [MSFT] 2006-09-01, 7:40 pm |
| Hi Colin,
Also if you have any Virtual Catalogs in the system, try rebuilding them
before doing the export.
Thanks
Sudha
--------------------
From: "Wendell" <joe8t88@hotmail.com>
Newsgroups: microsoft.public.commerceserver.general
Subject: Re: ExportCatalog - invalid column name?
Date: 31 Aug 2006 18:55:07 -0700
Organization: http://groups.google.com
Lines: 43
Message-ID: <1157075707.740268.199890@m79g2000cwm.googlegroups.com>
References: <E5F3EF74-199E-4030-B788-4FCD2082945B@microsoft.com>
NNTP-Posting-Host: 131.107.0.72
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1157075711 1921 127.0.0.1 (1 Sep 2006 01:55:11
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 1 Sep 2006 01:55:11 +0000 (UTC)
In-Reply-To: <E5F3EF74-199E-4030-B788-4FCD2082945B@microsoft.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 RED-PRXY-22
Complaints-To: groups-abuse@google.com
Injection-Info: m79g2000cwm.googlegroups.com; posting-host=131.107.0.72;
posting- account=tlXGNQ0AAADvbMDn4Bx09HliT0f7pgRX
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS02.phx.gbl!msrtrans!n
ews-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!m79g2000c
wm.googlegroups.com!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18300
X-Tomcat-NG: microsoft.public.commerceserver.general
Colin,
Have you made any changes to the catalog schema through the schema
editor since you last exported this catalog?
Colin Bowern wrote:
> These have exported fine in the past. Any thoughts on what would make
them
> invalid? There appears to be no verbose switches for the export catalog
tool
> either.
>
> ExportCatalog.exe /S:Site MasterCatalog.xml
> Connecting to site Site
> Exporting to MasterCatalog.xml
> 0000:00 Exporting 20% complete
> Completed: Failed
> Error: MasterCatalog.xml(0): Invalid column name 'Region'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Section'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'Section'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'Section'.
> Invalid column name 'VariantOption2'.
> Invalid column name 'EventDate'.
> Invalid column name 'Location'.
> Invalid column name 'Tour'.
> Invalid column name 'UseEventDateTime'.
> Invalid column name 'Venue'.
> Invalid column name 'VenueLink'.
> Invalid column name 'VariantOption2'.
>
> Thanks,
> Colin
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
|
|
|
|
|