| Author |
Message |
Daniel COHEN-ZARDI
Guest
|
 Posted:
Thu Sep 22, 2005 4:51 pm Post subject:
Error at Export using PIA catalog interfaces |
|
|
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 |
|
| Back to top |
|
 |
Vinayak Tadas[MSFT]
Guest
|
| Posted:
Thu Sep 22, 2005 8:51 pm Post subject:
RE: Error at Export using PIA catalog interfaces |
|
|
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: =?Utf-8?B?RGFuaWVsIENPSEVOLVpBUkRJ?= <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 |
|
| Back to top |
|
|
Daniel COHEN-ZARDI
Guest
|
| Posted:
Mon Sep 26, 2005 4:51 pm Post subject:
It works |
|
|
without the 0 parameter at the end, but it works
Th
Danie
http://www.softfluent.co |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in