Commerce Server Catalog - Catalog Manager Does not display catalog properties

This is Interesting: Free IT Magazines  
Home > Archive > Commerce Server Catalog > August 2005 > Catalog Manager Does not display catalog properties





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 Manager Does not display catalog properties
Jonathan Hagerman

2005-07-08, 8:48 pm

I am upgrading to CS2002 FP1, and I am having a problem with the Catalog
Manager displaying the catalog properties. The error message returned is:

Column 'DisplayName_en-US' does not belong to table Catalogs.

I have followed the steps to migrate the catalog, and the log file does not
report any errors.

Please let me know if anyone has any suggestions for tracking down the
problem.

Thanks,

Jonathan
Sudha Raghavan [MSFT]

2005-07-11, 5:51 pm

The error indicates that the displayName property for products and variants
was not migrated correctly. Try to use the CatalogMigrationtool.exe "-N"
command line option to do the correct migration.

You can use an XML file such as:
<?xml version="1.0"?>

<UpgradeInfo>

<Catalog name="CatalogName" productDisplayNameProperty="property name"
variantIdProperty="variantIdProperty"/>

</UpgradeInfo>


For more information check out the help for FP1 at
http://go.microsoft.com/fwlink/?LinkId=24907 and search for "Migrating the
Product Catalog System to Commerce Server 2002 FP1".

Thanks
Sudha
--------------------
Thread-Topic: Catalog Manager Does not display catalog properties
thread-index: AcWEGxvG0cF4P3eFQ0KBPdK+G8LryQ==
X-WBNR-Posting-Host: 67.77.204.87
From: "=?Utf-8?B?Sm9uYXRoYW4gSGFnZXJtYW4=?=" <Jonathan
Hagerman@discussions.microsoft.com>
Subject: Catalog Manager Does not display catalog properties
Date: Fri, 8 Jul 2005 17:14:01 -0700
Lines: 14
Message-ID: <5BFF3404-EBF7-46E8-A5F4-463B7DB77CFC@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.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:1085
X-Tomcat-NG: microsoft.public.commerceserver.catalog

I am upgrading to CS2002 FP1, and I am having a problem with the Catalog
Manager displaying the catalog properties. The error message returned is:

Column 'DisplayName_en-US' does not belong to table Catalogs.

I have followed the steps to migrate the catalog, and the log file does not
report any errors.

Please let me know if anyone has any suggestions for tracking down the
problem.

Thanks,

Jonathan


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
Jonathan Hagerman

2005-07-11, 5:51 pm

Sudha,

Thanks for the response. I was finally able to get the product name
migration to work after I manually updated LanguageSensitive field for the
product name property. However, I still receive the same error message. The
original catalog was not multilingual. Do I need to make the catalog
multilingual before I upgrade to FP1?

Thanks,
Jonathan

"Sudha Raghavan [MSFT]" wrote:

> The error indicates that the displayName property for products and variants
> was not migrated correctly. Try to use the CatalogMigrationtool.exe "-N"
> command line option to do the correct migration.
>
> You can use an XML file such as:
> <?xml version="1.0"?>
>
> <UpgradeInfo>
>
> <Catalog name="CatalogName" productDisplayNameProperty="property name"
> variantIdProperty="variantIdProperty"/>
>
> </UpgradeInfo>
>
>
> For more information check out the help for FP1 at
> http://go.microsoft.com/fwlink/?LinkId=24907 and search for "Migrating the
> Product Catalog System to Commerce Server 2002 FP1".
>
> Thanks
> Sudha
> --------------------
> Thread-Topic: Catalog Manager Does not display catalog properties
> thread-index: AcWEGxvG0cF4P3eFQ0KBPdK+G8LryQ==
> X-WBNR-Posting-Host: 67.77.204.87
> From: "=?Utf-8?B?Sm9uYXRoYW4gSGFnZXJtYW4=?=" <Jonathan
> Hagerman@discussions.microsoft.com>
> Subject: Catalog Manager Does not display catalog properties
> Date: Fri, 8 Jul 2005 17:14:01 -0700
> Lines: 14
> Message-ID: <5BFF3404-EBF7-46E8-A5F4-463B7DB77CFC@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.0
> Newsgroups: microsoft.public.commerceserver.catalog
> NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:1085
> X-Tomcat-NG: microsoft.public.commerceserver.catalog
>
> I am upgrading to CS2002 FP1, and I am having a problem with the Catalog
> Manager displaying the catalog properties. The error message returned is:
>
> Column 'DisplayName_en-US' does not belong to table Catalogs.
>
> I have followed the steps to migrate the catalog, and the log file does not
> report any errors.
>
> Please let me know if anyone has any suggestions for tracking down the
> problem.
>
> Thanks,
>
> Jonathan
>
>
> 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...omm2002/default

Jonathan Hagerman

2005-07-12, 5:55 pm

I was able to find the answer to my problem after I setup the CS2002 Starter
Site on another computer. I discovered that the CatalogGlobal_en-US view for
my catalog was different then for the Starter Site. I updated the view on my
catalog to be the same, and everything started working fine.


"Jonathan Hagerman" wrote:
[vbcol=seagreen]
> Sudha,
>
> Thanks for the response. I was finally able to get the product name
> migration to work after I manually updated LanguageSensitive field for the
> product name property. However, I still receive the same error message. The
> original catalog was not multilingual. Do I need to make the catalog
> multilingual before I upgrade to FP1?
>
> Thanks,
> Jonathan
>
> "Sudha Raghavan [MSFT]" wrote:
>
Cambuston

2005-08-29, 5:57 pm

I'm getting the same error, can you be more specific about the
CatalogGlobal_en-US view ?
Thank you.

"Jonathan Hagerman" wrote:
[vbcol=seagreen]
> I was able to find the answer to my problem after I setup the CS2002 Starter
> Site on another computer. I discovered that the CatalogGlobal_en-US view for
> my catalog was different then for the Starter Site. I updated the view on my
> catalog to be the same, and everything started working fine.
>
>
> "Jonathan Hagerman" wrote:
>
Vinayak Tadas[MSFT]

2005-08-29, 5:57 pm

Can you try adding a language to the catalog and then deleting it. This
will refresh all the catalog views and hopefully the problem should go away.

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 Manager Does not display catalog properties
thread-index: AcWsuHI94auq05oKSVGitqO7t7sJnA==
X-WBNR-Posting-Host: 63.196.154.3
From: =?Utf-8?B?Q2FtYnVzdG9u?= <Cambuston@discussions.microsoft.com>
References: <5BFF3404-EBF7-46E8-A5F4-463B7DB77CFC@microsoft.com>
<TzhjaZkhFHA.3608@TK2MSFTNGXA01.phx.gbl>
<E4B332E9-CFDE-4372-A9FE-53C1E72918B7@microsoft.com>
<B7FA3E53-0278-493F-AC8D-A17AE35B9CAB@microsoft.com>
Subject: RE: Catalog Manager Does not display catalog properties
Date: Mon, 29 Aug 2005 09:41:04 -0700
Lines: 106
Message-ID: <4F58A411-5F1A-435D-96B1-50050202DF1E@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.0
Newsgroups: microsoft.public.commerceserver.catalog
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:1219
X-Tomcat-NG: microsoft.public.commerceserver.catalog

I'm getting the same error, can you be more specific about the
CatalogGlobal_en-US view ?
Thank you.

"Jonathan Hagerman" wrote:

> I was able to find the answer to my problem after I setup the CS2002

Starter
> Site on another computer. I discovered that the CatalogGlobal_en-US view

for
> my catalog was different then for the Starter Site. I updated the view

on my[vbcol=seagreen]
> catalog to be the same, and everything started working fine.
>
>
> "Jonathan Hagerman" wrote:
>
the[vbcol=seagreen]
message. The[vbcol=seagreen]
variants[vbcol=seagreen]
"-N"[vbcol=seagreen]
name"[vbcol=seagreen]
"Migrating the[vbcol=seagreen]
microsoft.public.commerceserver.catalog:1085[vbcol=seagreen]
Catalog[vbcol=seagreen]
returned is:[vbcol=seagreen]
does not[vbcol=seagreen]
the[vbcol=seagreen]
rights.[vbcol=seagreen]
rights[vbcol=seagreen]
our[vbcol=seagreen]
http://www.microsoft.com/technet/co...r/commerce.mspx[vbcol=seagreen]

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com