09-23-05 01:58 AM
Run this statement
EXEC dbo.ctlg_CreateCatalogClassTypesView 'Adventure Works Catalog', 0
in Query analyzer in the catalog database.
This should create the missing view.
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: Error at Export using PIA catalog interfaces
thread-index: AcW/kerD7m4saRXVQWqxY1d03WcirA==
X-WBNR-Posting-Host: 137.194.26.109
From: examnotes <Daniel
COHEN-ZARDI@discussions.microsoft.com>
Subject: Error at Export using PIA catalog interfaces
Date: Thu, 22 Sep 2005 09:23:07 -0700
Lines: 40
Message-ID: <1C9F5B40-9D51-460E-B830-93B063396A9F@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.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3538
X-Tomcat-NG: microsoft.public.commerceserver.general
I have got the following code on a basic commerce 2002 FP1 site with the
AdvWorks catalogue :
CatalogManagerClass catManager = new CatalogManagerClass();
catManager.Initialize("Commerce0", false);
catManager.DeltaExportXML(xml,
System.DateTime.Now.AddDays(-2),
"Adventure Works Catalog",
true, CatalogXMLFmtEnum.cscFmtAttributeCentric);
The DeltaExport result in the following error.
It looks like something is missing in the database.
Any idea ?
System.Runtime.InteropServices.COMException (0x80040E37): Source:Microsoft
OLE D
B Provider for SQL ServerDescription:'dbo.Adventure Works
Catalog_ClassTypes' :
nom d'objet incorrect.
at
Microsoft.CommerceServer.Interop.Catalog.CatalogManagerClass.DeltaExportXM
L(Object vrXML, Object vrTimeStamp, Object strCatalogsToExport, Boolean
fRunSync
hronously, CatalogXMLFmtEnum eXMLFmt)
at VEL_Deploy.Deploy.Catalog_Export(String site, String xml) in
c:\veldcz\cat
alogmanager.cs:line 130
at VEL_Deploy.Deploy.Catalog_Deploy(String source, String destination,
String
xml) in c:\veldcz\catalogmanager.cs:line 120
at VEL_Deploy.Deploy.SafeMain(String[] args) in
c:\veldcz\catalogmanager.cs:l
ine 64
at VEL_Deploy.Deploy.Main(String[] args) in
c:\veldcz\catalogmanager.cs:line
23
Regards,
Daniel
[ Post a follow-up to this message ]
| 
