ExportCatalog - invalid column name?
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Commerce Server > Commerce Server General > ExportCatalog - invalid column name?




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    ExportCatalog - invalid column name?  
Colin Bowern


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
09-01-06 12:36 AM


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






[ Post a follow-up to this message ]



    Re: ExportCatalog - invalid column name?  
Wendell


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
09-01-06 06: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 the
m
> invalid? There appears to be no verbose switches for the export catalog to
ol
> 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






[ Post a follow-up to this message ]



    Re: ExportCatalog - invalid column name?  
Sudha Raghavan [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
09-02-06 12:40 AM

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



Attachment:
This has been downloaded 0 time(s).



[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 06:27 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register