Commerce Server Analysis - DW Import wizard fails

Author

DW Import wizard fails

Lars

2006-09-18, 1:21 pm

Could it be true, that DW Import Wizard still fails when trying to proces
"Product catalog" and "Profiles" in the newest CS2007_dev version?

--
Regards Lars

Lars

2006-09-18, 1:21 pm

This is the error I picked up in the event log, when trying to import the
product catalog:

Faulting application CSDWImportWizard.exe, version 6.0.0.3724, faulting
module msvcr80.dll, version 8.0.50727.42, fault address 0x00014965.

--
Regards Lars

"Lars" wrote:

> Could it be true, that DW Import Wizard still fails when trying to proces
> "Product catalog" and "Profiles" in the newest CS2007_dev version?
>
>
> --
> Regards Lars

Brian Blum [MSFT]

2006-09-18, 1:21 pm

Lars,

Did the import wizard fail during execution of the package, or before that?

A couple of things that might yield more information would be running a SQL
trace. Also, CS has a tool called CSDWDBGSRV.EXE. This tool gets stored
in the directory "Program Files\Common Files\Microsoft Shared\Enterprise
Servers\Commerce Server" by default. Starting this program with a -f
<filename> option will collect additional information.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Thread-Topic: DW Import wizard fails
thread-index: AcbbMdvbmMt8ZQtQS8qtu7p7O3gk8A==
X-WBNR-Posting-Host: 62.242.39.227
From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
Subject: RE: DW Import wizard fails
Date: Mon, 18 Sep 2006 07:51:01 -0700
Lines: 18
Message-ID: <5CF3CB36-5635-451D-8D75-0804494D2CFA@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.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:146
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis

This is the error I picked up in the event log, when trying to import the
product catalog:

Faulting application CSDWImportWizard.exe, version 6.0.0.3724, faulting
module msvcr80.dll, version 8.0.50727.42, fault address 0x00014965.

--
Regards Lars

"Lars" wrote:

> Could it be true, that DW Import Wizard still fails when trying to proces
> "Product catalog" and "Profiles" in the newest CS2007_dev version?
>
>
> --
> Regards Lars

Lars

2006-09-20, 1:22 pm

Hi,

I cannot save the package, so I "Run the import immediately" and don't know
whether it failed before or after executing the package.

Both the SQL trace and CSDWDBGSRV terminates at this point:

-------

SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
[NC_prod_CATALOGHIERARCHY] A ,
[NC_prod_da-DK] B, [NC_prod_da-DK] C
WHERE A.OID = B.OID
AND A.CHILD_OID = C.OID AND
C.CATEGORYNAME is not null AND A.Child_CatalogName = C.BaseCatalogName

List Size :1 --- ParentID :1

List Size :2 --- ChildId :2

List Size :3 --- ParentID :3

List Size :4 --- ChildId :4

List Size :5 --- ParentID :5

List Size :6 --- ChildId :6

List Size :7 --- ParentID :7

List Size :8 --- ChildId :8

/* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-4, for
proc
ess: DWUtil */

-------

When I execute the SQL-statement in SQL server 2005, I get this result:

CATEGORYNAME CATEGORYNAME

Frontpage(NC_prod) Included - Emhetter(Bosch)
Included - Bosch(Bosch) Included - Emhetter(Bosch)
Bortskaffelse(LogProducts) Included - Emhetter(Bosch)
Forsikringer(InsuranceProducts) Include
d - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
.... ...

The CATEGORYNAME is a custom property, so I suppose a NULL value is okay?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> Lars,
>
> Did the import wizard fail during execution of the package, or before that?
>
> A couple of things that might yield more information would be running a SQL
> trace. Also, CS has a tool called CSDWDBGSRV.EXE. This tool gets stored
> in the directory "Program Files\Common Files\Microsoft Shared\Enterprise
> Servers\Commerce Server" by default. Starting this program with a -f
> <filename> option will collect additional information.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbbMdvbmMt8ZQtQS8qtu7p7O3gk8A==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> Subject: RE: DW Import wizard fails
> Date: Mon, 18 Sep 2006 07:51:01 -0700
> Lines: 18
> Message-ID: <5CF3CB36-5635-451D-8D75-0804494D2CFA@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:146
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> This is the error I picked up in the event log, when trying to import the
> product catalog:
>
> Faulting application CSDWImportWizard.exe, version 6.0.0.3724, faulting
> module msvcr80.dll, version 8.0.50727.42, fault address 0x00014965.
>
> --
> Regards Lars
>
>
> "Lars" wrote:
>
>

Brian Blum [MSFT]

2006-09-20, 1:22 pm

The task is failing while creating a catetegorized catalog structure. Can
you please determine if you have any category cycles in your catalog.
There's a tool in \Program Files\Microsoft Commerce Server 2007\Tools
called CatalogCycleCop.exe. While the catalog system can support circular
references in the catalog structure, the DW cannot.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Thread-Topic: DW Import wizard fails
thread-index: AcbcxMAJuExUlil/R12g1V8X35unKw==
X-WBNR-Posting-Host: 62.242.39.227
From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
<5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
<2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
Subject: RE: DW Import wizard fails
Date: Wed, 20 Sep 2006 07:55:02 -0700
Lines: 118
Message-ID: <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@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.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:148
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis

Hi,

I cannot save the package, so I "Run the import immediately" and don't know
whether it failed before or after executing the package.

Both the SQL trace and CSDWDBGSRV terminates at this point:

-------

SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
[NC_prod_CATALOGHIERARCHY] A ,
[NC_prod_da-DK] B, [NC_prod_da-DK] C
WHERE A.OID = B.OID
AND A.CHILD_OID = C.OID AND
C.CATEGORYNAME is not null AND A.Child_CatalogName = C.BaseCatalogName

List Size :1 --- ParentID :1

List Size :2 --- ChildId :2

List Size :3 --- ParentID :3

List Size :4 --- ChildId :4

List Size :5 --- ParentID :5

List Size :6 --- ChildId :6

List Size :7 --- ParentID :7

List Size :8 --- ChildId :8

/* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-4, for
proc
ess: DWUtil */

-------

When I execute the SQL-statement in SQL server 2005, I get this result:

CATEGORYNAME CATEGORYNAME

Frontpage(NC_prod) Included - Emhetter(Bosch)
Included - Bosch(Bosch) Included - Emhetter(Bosch)
Bortskaffelse(LogProducts) Included - Emhetter(Bosch)
Forsikringer(InsuranceProducts) Include
d - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
NULL Included - Emhetter(Bosch)
... ...

The CATEGORYNAME is a custom property, so I suppose a NULL value is okay?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> Lars,
>
> Did the import wizard fail during execution of the package, or before
that?
>
> A couple of things that might yield more information would be running a
SQL
> trace. Also, CS has a tool called CSDWDBGSRV.EXE. This tool gets stored
> in the directory "Program Files\Common Files\Microsoft Shared\Enterprise
> Servers\Commerce Server" by default. Starting this program with a -f
> <filename> option will collect additional information.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbbMdvbmMt8ZQtQS8qtu7p7O3gk8A==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> Subject: RE: DW Import wizard fails
> Date: Mon, 18 Sep 2006 07:51:01 -0700
> Lines: 18
> Message-ID: <5CF3CB36-5635-451D-8D75-0804494D2CFA@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:146
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> This is the error I picked up in the event log, when trying to import the
> product catalog:
>
> Faulting application CSDWImportWizard.exe, version 6.0.0.3724, faulting
> module msvcr80.dll, version 8.0.50727.42, fault address 0x00014965.
>
> --
> Regards Lars
>
>
> "Lars" wrote:
>
proces[vbcol=seagreen]
>

Lars

2006-09-20, 1:22 pm

Hi Brian,

Nothing happens when I run CatalogCycleCop.exe? Should I call it using any
parameters?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> The task is failing while creating a catetegorized catalog structure. Can
> you please determine if you have any category cycles in your catalog.
> There's a tool in \Program Files\Microsoft Commerce Server 2007\Tools
> called CatalogCycleCop.exe. While the catalog system can support circular
> references in the catalog structure, the DW cannot.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbcxMAJuExUlil/R12g1V8X35unKw==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Wed, 20 Sep 2006 07:55:02 -0700
> Lines: 118
> Message-ID: <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:148
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi,
>
> I cannot save the package, so I "Run the import immediately" and don't know
> whether it failed before or after executing the package.
>
> Both the SQL trace and CSDWDBGSRV terminates at this point:
>
> -------
>
> SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
> [NC_prod_CATALOGHIERARCHY] A ,
> [NC_prod_da-DK] B, [NC_prod_da-DK] C
> WHERE A.OID = B.OID
> AND A.CHILD_OID = C.OID AND
> C.CATEGORYNAME is not null AND A.Child_CatalogName = C.BaseCatalogName
>
> List Size :1 --- ParentID :1
>
> List Size :2 --- ChildId :2
>
> List Size :3 --- ParentID :3
>
> List Size :4 --- ChildId :4
>
> List Size :5 --- ParentID :5
>
> List Size :6 --- ChildId :6
>
> List Size :7 --- ParentID :7
>
> List Size :8 --- ChildId :8
>
> /* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-4, for
> proc
> ess: DWUtil */
>
> -------
>
> When I execute the SQL-statement in SQL server 2005, I get this result:
>
>
> CATEGORYNAME CATEGORYNAME
>
> Frontpage(NC_prod) Included - Emhetter(Bosch)
> Included - Bosch(Bosch) Included - Emhetter(Bosch)
> Bortskaffelse(LogProducts) Included - Emhetter(Bosch)
> Forsikringer(InsuranceProducts) Include
d - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> ... ...
>
> The CATEGORYNAME is a custom property, so I suppose a NULL value is okay?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> that?
> SQL
> rights.
> proces
>

Lars

2006-09-21, 7:25 am

Hi Brian,

I can now execute the CatalogCycleCop.exe using CS2007_dev. But
unfortunately it returns "no catalog cycles were detected" (on both the whole
site and on my primary virtual catalog) - any suggestions?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> The task is failing while creating a catetegorized catalog structure. Can
> you please determine if you have any category cycles in your catalog.
> There's a tool in \Program Files\Microsoft Commerce Server 2007\Tools
> called CatalogCycleCop.exe. While the catalog system can support circular
> references in the catalog structure, the DW cannot.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbcxMAJuExUlil/R12g1V8X35unKw==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Wed, 20 Sep 2006 07:55:02 -0700
> Lines: 118
> Message-ID: <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:148
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi,
>
> I cannot save the package, so I "Run the import immediately" and don't know
> whether it failed before or after executing the package.
>
> Both the SQL trace and CSDWDBGSRV terminates at this point:
>
> -------
>
> SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
> [NC_prod_CATALOGHIERARCHY] A ,
> [NC_prod_da-DK] B, [NC_prod_da-DK] C
> WHERE A.OID = B.OID
> AND A.CHILD_OID = C.OID AND
> C.CATEGORYNAME is not null AND A.Child_CatalogName = C.BaseCatalogName
>
> List Size :1 --- ParentID :1
>
> List Size :2 --- ChildId :2
>
> List Size :3 --- ParentID :3
>
> List Size :4 --- ChildId :4
>
> List Size :5 --- ParentID :5
>
> List Size :6 --- ChildId :6
>
> List Size :7 --- ParentID :7
>
> List Size :8 --- ChildId :8
>
> /* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-4, for
> proc
> ess: DWUtil */
>
> -------
>
> When I execute the SQL-statement in SQL server 2005, I get this result:
>
>
> CATEGORYNAME CATEGORYNAME
>
> Frontpage(NC_prod) Included - Emhetter(Bosch)
> Included - Bosch(Bosch) Included - Emhetter(Bosch)
> Bortskaffelse(LogProducts) Included - Emhetter(Bosch)
> Forsikringer(InsuranceProducts) Include
d - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> ... ...
>
> The CATEGORYNAME is a custom property, so I suppose a NULL value is okay?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> that?
> SQL
> rights.
> proces
>

Brian Blum [MSFT]

2006-09-21, 7:24 pm

CatalogCycleCop takes a Site, and optionally, a catalog name. It outputs a
status message "CSCatalogCycleCop is detecting cycles..." followed by "No
catalog cycles were detected." if no cycles are detected.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Thread-Topic: DW Import wizard fails
thread-index: Acbc24VhWopBh7TdTRmOWk8pB1iRKA==
X-WBNR-Posting-Host: 85.81.84.80
From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
<5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
<2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
<2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
<Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
Subject: RE: DW Import wizard fails
Date: Wed, 20 Sep 2006 10:38:02 -0700
Lines: 170
Message-ID: <6AB09F48-9BFE-43AD-9033-A656C9B8BB96@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.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:150
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis

Hi Brian,

Nothing happens when I run CatalogCycleCop.exe? Should I call it using any
parameters?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> The task is failing while creating a catetegorized catalog structure.
Can
> you please determine if you have any category cycles in your catalog.
> There's a tool in \Program Files\Microsoft Commerce Server 2007\Tools
> called CatalogCycleCop.exe. While the catalog system can support
circular
> references in the catalog structure, the DW cannot.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbcxMAJuExUlil/R12g1V8X35unKw==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Wed, 20 Sep 2006 07:55:02 -0700
> Lines: 118
> Message-ID: <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:148
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi,
>
> I cannot save the package, so I "Run the import immediately" and don't
know
> whether it failed before or after executing the package.
>
> Both the SQL trace and CSDWDBGSRV terminates at this point:
>
> -------
>
> SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
> [NC_prod_CATALOGHIERARCHY] A ,
> [NC_prod_da-DK] B, [NC_prod_da-DK] C
> WHERE A.OID = B.OID
> AND A.CHILD_OID = C.OID AND
> C.CATEGORYNAME is not null AND A.Child_CatalogName = C.BaseCatalogName
>
> List Size :1 --- ParentID :1
>
> List Size :2 --- ChildId :2
>
> List Size :3 --- ParentID :3
>
> List Size :4 --- ChildId :4
>
> List Size :5 --- ParentID :5
>
> List Size :6 --- ChildId :6
>
> List Size :7 --- ParentID :7
>
> List Size :8 --- ChildId :8
>
> /* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-4,
for
> proc
> ess: DWUtil */
>
> -------
>
> When I execute the SQL-statement in SQL server 2005, I get this result:
>
>
> CATEGORYNAME CATEGORYNAME
>
> Frontpage(NC_prod) Included - Emhetter(Bosch)
> Included - Bosch(Bosch) Included - Emhetter(Bosch)
> Bortskaffelse(LogProducts) Included - Emhetter(Bosch)
> Forsikringer(InsuranceProducts) Include
d - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> NULL Included - Emhetter(Bosch)
> ... ...
>
> The CATEGORYNAME is a custom property, so I suppose a NULL value is okay?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> that?
> SQL
stored[vbcol=seagreen]
Shared\Enterprise[vbcol=seagreen]
> rights.
the[vbcol=seagreen]
> proces
>

Lars

2006-09-22, 7:21 am

Brian Blum [MSFT]

2006-09-23, 1:32 am

The CS DW has a trace tool called csdwdbgsrv.exe. This tool can be found
in the directory Program Files\Common Files\Microsoft Shared\Enterprise
Servers\Commerce Server. You invoke this tool by specifying a file to
capture the output: 'csdwdbgsrv -f trace'. This will create a file in the
current directory with trace as the prefix, a time stamp as the rest of the
file name and .txt as the file extension.

Running the DTS task while capturing the trace output may provide more
details about the problem.

You can get more trace information by setting different environment
settings. The easiest way to set the environment variables is go to the
'My Computer' icon on the desktop, right click and select Properties, then
go to the Advanced tab. There's a button at the bottom of this tab marked
'Environment Variables'. When setting a value for an CS DW trace variable,
you can use 'T', 't', 'True', 'true', or 1 to enable the setting.

Unfortuneatly, there is not a lot of custom tracing in the Catalog DTS
task, so the evironment variables I can suggest will dump trace output for
the CSOLEDB provider, which can be pretty verbose.

If the initial trace doesn't point out the problem, try setting the
following variables:
TraceDataConvError=T
TraceCommandCalls=T
TraceFlush=T
TraceRowsetCalls=T
TraceFailedInsertRows=T
TraceSQLStatements=T

As I mentioned above, these environment variables will cause a lot of data
to be collected in the trace file.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Thread-Topic: DW Import wizard fails
thread-index: AcbeGBOHgMiM2cBKREW15Xgge5UTSA==
X-WBNR-Posting-Host: 62.242.39.226
From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
<5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
<2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
<2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
<Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
<6AB09F48-9BFE-43AD-9033-A656C9B8BB96@microsoft.com>
<NwH8Vdc3GHA.400@TK2MSFTNGXA01.phx.gbl>
Subject: RE: DW Import wizard fails
Date: Fri, 22 Sep 2006 00:24:01 -0700
Lines: 227
Message-ID: <BA894AD7-F1BD-41AF-B2DD-7853A2F5B6F4@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.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:155
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis

Hi Brian,

I can now execute the CatalogCycleCop.exe using CS2007_dev. But
unfortunately it returns "no catalog cycles were detected" (on both the
whole
site and on my primary virtual catalog) - any suggestions?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> CatalogCycleCop takes a Site, and optionally, a catalog name. It outputs
a
> status message "CSCatalogCycleCop is detecting cycles..." followed by "No
> catalog cycles were detected." if no cycles are detected.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: Acbc24VhWopBh7TdTRmOWk8pB1iRKA==
> X-WBNR-Posting-Host: 85.81.84.80
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
> <Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Wed, 20 Sep 2006 10:38:02 -0700
> Lines: 170
> Message-ID: <6AB09F48-9BFE-43AD-9033-A656C9B8BB96@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:150
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi Brian,
>
> Nothing happens when I run CatalogCycleCop.exe? Should I call it using
any
> parameters?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> Can
> circular
> rights.
> know
> for
okay?[vbcol=seagreen]
a[vbcol=seagreen]
> stored
> Shared\Enterprise
microsoft.public.commerceserver.analysis:146[vbcol=seagreen]
> the
faulting[vbcol=seagreen]
>

Lars

2006-09-26, 1:19 pm

Hi,

This is the last bunch of lines in the trace file:

----------------------

CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
Warn: Calling SyncFlush
Explicit flush invoked!
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64d8c50
CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool queue
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
CCommand(command-14[Session-32])::SetCommandText(dialect:{C8B522D7-5CF3-11CE-ADE5-00AA0044773D}, cmd:schemamode=0)
CCommand::Execute(riid:{00000000-0000-0000-0000-000000000000}, unkout:0)
Full CmdText: schemamode=0
Processing Command: 'schemamode'
========================================
===
SQL Statement:
SELECT
DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek,Std
Day,StdHour,StdMin,StdSec,StdMs,DltYear,
DltMonth,DltDayWeek,DltDay,DltHour,DltMi
n,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 25

SQL Statement:
SELECT
DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek,Std
Day,StdHour,StdMin,StdSec,StdMs,DltYear,
DltMonth,DltDayWeek,DltDay,DltHour,DltMi
n,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 27

PagesPerObjChngsBuf : 1
ExtraPagesPerObjChngsBuf : 100
ObjChngsPerVector : 16
ObjChngsVectors : 48
ObjChngThreads : 1
MaxUniqDataItemsPerDPS : 61440
MaxClsInstPagesPerDPS : 10000
SaveThreads : 4
ThrdPoolIdleTime : 30000
CallSaveMethod : true
SavePackageLogFile :

Command release (command-14[Session-32]) -- new refcount is 1, tid=0xed0
Command release (command-14[Session-32]) -- new refcount is 0, tid=0xed0
X>CCommand(command-14[Session-32], tid=0xed0) nuked
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64b7f34
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64b7f34
Releasing a job queue, handle: 120
Destroying a job queue, type: InMemory, name: Processing
Releasing a job queue, handle: 121
Destroying a job queue, type: DBSearch, name: Global
Releasing a job queue, handle: 122
Destroying a job queue, type: DBInsert, name: Global
Releasing a job queue, handle: 123
Destroying a job queue, type: DBUpdate, name: Global
Releasing a job queue, handle: 124
Destroying a job queue, type: DelSearch, name: Global
Releasing a job queue, handle: 125
Destroying a job queue, type: DelInsert, name: Global
Releasing a job queue, handle: 126
Destroying a job queue, type: DelUpdate, name: Global
***** Alloc CStVBuf 1*****
***** Alloc CStVBuf 2*****
SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
[Wupti_prod_CATALOGHIERARCHY] A , [Wupti_prod_da-DK] B, [Wupti_prod_da-DK] C
WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is
not null AND A.Child_CatalogName = C.BaseCatalogName
List Size :1 --- ParentID :1

List Size :2 --- ChildId :2

/* MonitorAClientProcess(), Received process terminate */
/* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-3, for
process: DWUtil */

--------------------------

I would happily send the whole trace file to you, if it is useful?

--
Regards Lars

"Brian Blum [MSFT]" wrote:
[vbcol=seagreen]
> The CS DW has a trace tool called csdwdbgsrv.exe. This tool can be found
> in the directory Program Files\Common Files\Microsoft Shared\Enterprise
> Servers\Commerce Server. You invoke this tool by specifying a file to
> capture the output: 'csdwdbgsrv -f trace'. This will create a file in the
> current directory with trace as the prefix, a time stamp as the rest of the
> file name and .txt as the file extension.
>
> Running the DTS task while capturing the trace output may provide more
> details about the problem.
>
> You can get more trace information by setting different environment
> settings. The easiest way to set the environment variables is go to the
> 'My Computer' icon on the desktop, right click and select Properties, then
> go to the Advanced tab. There's a button at the bottom of this tab marked
> 'Environment Variables'. When setting a value for an CS DW trace variable,
> you can use 'T', 't', 'True', 'true', or 1 to enable the setting.
>
> Unfortuneatly, there is not a lot of custom tracing in the Catalog DTS
> task, so the evironment variables I can suggest will dump trace output for
> the CSOLEDB provider, which can be pretty verbose.
>
> If the initial trace doesn't point out the problem, try setting the
> following variables:
> TraceDataConvError=T
> TraceCommandCalls=T
> TraceFlush=T
> TraceRowsetCalls=T
> TraceFailedInsertRows=T
> TraceSQLStatements=T
>
> As I mentioned above, these environment variables will cause a lot of data
> to be collected in the trace file.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbeGBOHgMiM2cBKREW15Xgge5UTSA==
> X-WBNR-Posting-Host: 62.242.39.226
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
> <Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
> <6AB09F48-9BFE-43AD-9033-A656C9B8BB96@microsoft.com>
> <NwH8Vdc3GHA.400@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Fri, 22 Sep 2006 00:24:01 -0700
> Lines: 227
> Message-ID: <BA894AD7-F1BD-41AF-B2DD-7853A2F5B6F4@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:155
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi Brian,
>
> I can now execute the CatalogCycleCop.exe using CS2007_dev. But
> unfortunately it returns "no catalog cycles were detected" (on both the
> whole
> site and on my primary virtual catalog) - any suggestions?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> a
> rights.
> any
> okay?
> a
> microsoft.public.commerceserver.analysis:146
> faulting

Brian Blum [MSFT]

2006-09-26, 7:23 pm

I think the code is failing and exiting because of the null value in the
CategoryName column from product catalog table.

How was this catalog created?

Is it possible to update the Catalog with Category names? One way to find
the rows that you're interested in would be to add some columns to the
query below like:

SELECT B.CATEGORYNAME , C.CATEGORYNAME, A.OID, A.CHILD_OID
FROM [Adventure Works Catalog_CATALOGHIERARCHY] A ,
[Adventure Works Catalog_en-US] B,
[Adventure Works Catalog_en-US] C
WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is not null
AND A.Child_CatalogName = C.BaseCatalogName

This will select the same rows as before, but make it a little easier to
find which child products don't have category names associated with them.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBuisness Server Team
--------------------
Thread-Topic: DW Import wizard fails
thread-index: AcbhhqRaIjVD6VToTnep67xPBojpPA==
X-WBNR-Posting-Host: 62.242.39.227
From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
<5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
<2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
<2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
<Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
<6AB09F48-9BFE-43AD-9033-A656C9B8BB96@microsoft.com>
<NwH8Vdc3GHA.400@TK2MSFTNGXA01.phx.gbl>
<BA894AD7-F1BD-41AF-B2DD-7853A2F5B6F4@microsoft.com>
<$RGme3o3GHA.3440@TK2MSFTNGXA01.phx.gbl>
Subject: RE: DW Import wizard fails
Date: Tue, 26 Sep 2006 09:13:02 -0700
Lines: 391
Message-ID: <820837E0-39AF-4B31-8D2F-2565E0B5891F@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.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:159
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis

Hi,

This is the last bunch of lines in the trace file:

----------------------

CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
Warn: Calling SyncFlush
Explicit flush invoked!
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64d8c50
CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
queue
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
CCommand(command-14[Session-32])::SetCommandText(dialect:{C8B522D7-5CF3-11CE
-ADE5-00AA0044773D}, cmd:schemamode=0)
CCommand::Execute(riid:{00000000-0000-0000-0000-000000000000}, unkout:0)
Full CmdText: schemamode=0
Processing Command: 'schemamode'
========================================
===
SQL Statement:
SELECT
DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek
,StdDay,StdHour,StdMin,StdSec,StdMs,DltY
ear,DltMonth,DltDayWeek,DltDay,DltHo
ur,DltMin,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 25

SQL Statement:
SELECT
DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek
,StdDay,StdHour,StdMin,StdSec,StdMs,DltY
ear,DltMonth,DltDayWeek,DltDay,DltHo
ur,DltMin,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 27

PagesPerObjChngsBuf : 1
ExtraPagesPerObjChngsBuf : 100
ObjChngsPerVector : 16
ObjChngsVectors : 48
ObjChngThreads : 1
MaxUniqDataItemsPerDPS : 61440
MaxClsInstPagesPerDPS : 10000
SaveThreads : 4
ThrdPoolIdleTime : 30000
CallSaveMethod : true
SavePackageLogFile :

Command release (command-14[Session-32]) -- new refcount is 1, tid=0xed0
Command release (command-14[Session-32]) -- new refcount is 0, tid=0xed0
X>CCommand(command-14[Session-32], tid=0xed0) nuked
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
queue
CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64b7f34
CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64b7f34
Releasing a job queue, handle: 120
Destroying a job queue, type: InMemory, name: Processing
Releasing a job queue, handle: 121
Destroying a job queue, type: DBSearch, name: Global
Releasing a job queue, handle: 122
Destroying a job queue, type: DBInsert, name: Global
Releasing a job queue, handle: 123
Destroying a job queue, type: DBUpdate, name: Global
Releasing a job queue, handle: 124
Destroying a job queue, type: DelSearch, name: Global
Releasing a job queue, handle: 125
Destroying a job queue, type: DelInsert, name: Global
Releasing a job queue, handle: 126
Destroying a job queue, type: DelUpdate, name: Global
***** Alloc CStVBuf 1*****
***** Alloc CStVBuf 2*****
SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
[Wupti_prod_CATALOGHIERARCHY] A , [Wupti_prod_da-DK] B, [Wupti_prod_da-DK]
C
WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is
not null AND A.Child_CatalogName = C.BaseCatalogName
List Size :1 --- ParentID :1

List Size :2 --- ChildId :2

/* MonitorAClientProcess(), Received process terminate */
/* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-3, for
process: DWUtil */

--------------------------

I would happily send the whole trace file to you, if it is useful?

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> The CS DW has a trace tool called csdwdbgsrv.exe. This tool can be found
> in the directory Program Files\Common Files\Microsoft Shared\Enterprise
> Servers\Commerce Server. You invoke this tool by specifying a file to
> capture the output: 'csdwdbgsrv -f trace'. This will create a file in
the
> current directory with trace as the prefix, a time stamp as the rest of
the
> file name and .txt as the file extension.
>
> Running the DTS task while capturing the trace output may provide more
> details about the problem.
>
> You can get more trace information by setting different environment
> settings. The easiest way to set the environment variables is go to the
> 'My Computer' icon on the desktop, right click and select Properties,
then
> go to the Advanced tab. There's a button at the bottom of this tab
marked
> 'Environment Variables'. When setting a value for an CS DW trace
variable,
> you can use 'T', 't', 'True', 'true', or 1 to enable the setting.
>
> Unfortuneatly, there is not a lot of custom tracing in the Catalog DTS
> task, so the evironment variables I can suggest will dump trace output
for
> the CSOLEDB provider, which can be pretty verbose.
>
> If the initial trace doesn't point out the problem, try setting the
> following variables:
> TraceDataConvError=T
> TraceCommandCalls=T
> TraceFlush=T
> TraceRowsetCalls=T
> TraceFailedInsertRows=T
> TraceSQLStatements=T
>
> As I mentioned above, these environment variables will cause a lot of
data
> to be collected in the trace file.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbeGBOHgMiM2cBKREW15Xgge5UTSA==
> X-WBNR-Posting-Host: 62.242.39.226
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
> <Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
> <6AB09F48-9BFE-43AD-9033-A656C9B8BB96@microsoft.com>
> <NwH8Vdc3GHA.400@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Fri, 22 Sep 2006 00:24:01 -0700
> Lines: 227
> Message-ID: <BA894AD7-F1BD-41AF-B2DD-7853A2F5B6F4@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:155
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi Brian,
>
> I can now execute the CatalogCycleCop.exe using CS2007_dev. But
> unfortunately it returns "no catalog cycles were detected" (on both the
> whole
> site and on my primary virtual catalog) - any suggestions?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
outputs[vbcol=seagreen]
> a
"No[vbcol=seagreen]
> rights.
> any
[vbcol=seagreen]
[vbcol=seagreen]
microsoft.public.commerceserver.analysis:148[vbcol=seagreen]
don't[vbcol=seagreen]
Trace-4,[vbcol=seagreen]
result:[vbcol=seagreen]
> okay?
before[vbcol=seagreen]
running[vbcol=seagreen]
> a
-f[vbcol=seagreen]
> microsoft.public.commerceserver.analysis:146
[vbcol=seagreen]
import[vbcol=seagreen]
> faulting
to[vbcol=seagreen]

Lars

2006-11-13, 8:42 am

Dear Brian,

We suspect there might be an error in the SQL used by Commerce.

The SQL we saw earlier from Commerce was:

SELECT B.CATEGORYNAME , C.CATEGORYNAME, A.OID, A.CHILD_OID
FROM [Adventure Works Catalog_CATALOGHIERARCHY] A ,
[Adventure Works Catalog_en-US] B,
[Adventure Works Catalog_en-US] C
WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is not null
AND A.Child_CatalogName = C.BaseCatalogName

We've looked into this and it seems the join to B is missing a check on
BaseCatalogName.

If we add
and A.Catalogname = B.BaseCatalogName
to the SQL in addition to A.OID = B.OID then we don't see any nulls in the
first column.

The problem is, that a lot of products and categories share the same OID
from different base catalogues, we see the nulls in the first column for
products that happen to have the same OID, but in other BaseCatalogues. We
are running the query on a virtual catalog that includes a lot of products
from base catalogues who have categories on their own.

--
Regards Lars

"Brian Blum [MSFT]" wrote:

> I think the code is failing and exiting because of the null value in the
> CategoryName column from product catalog table.
>
> How was this catalog created?
>
> Is it possible to update the Catalog with Category names? One way to find
> the rows that you're interested in would be to add some columns to the
> query below like:
>
> SELECT B.CATEGORYNAME , C.CATEGORYNAME, A.OID, A.CHILD_OID
> FROM [Adventure Works Catalog_CATALOGHIERARCHY] A ,
> [Adventure Works Catalog_en-US] B,
> [Adventure Works Catalog_en-US] C
> WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is not null
> AND A.Child_CatalogName = C.BaseCatalogName
>
> This will select the same rows as before, but make it a little easier to
> find which child products don't have category names associated with them.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: DW Import wizard fails
> thread-index: AcbhhqRaIjVD6VToTnep67xPBojpPA==
> X-WBNR-Posting-Host: 62.242.39.227
> From: =?Utf-8?B?TGFycw==?= <Lars@discussions.microsoft.com>
> References: <E8DC6E2B-13FF-45BE-A462-EDBC8E27FA68@microsoft.com>
> <5CF3CB36-5635-451D-8D75-0804494D2CFA@microsoft.com>
> <2d8L9S02GHA.400@TK2MSFTNGXA01.phx.gbl>
> <2052F53C-5E46-4EED-AC11-C5EC1AF37DFE@microsoft.com>
> <Y8nq8bN3GHA.4280@TK2MSFTNGXA01.phx.gbl>
> <6AB09F48-9BFE-43AD-9033-A656C9B8BB96@microsoft.com>
> <NwH8Vdc3GHA.400@TK2MSFTNGXA01.phx.gbl>
> <BA894AD7-F1BD-41AF-B2DD-7853A2F5B6F4@microsoft.com>
> <$RGme3o3GHA.3440@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: DW Import wizard fails
> Date: Tue, 26 Sep 2006 09:13:02 -0700
> Lines: 391
> Message-ID: <820837E0-39AF-4B31-8D2F-2565E0B5891F@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.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:159
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Hi,
>
> This is the last bunch of lines in the trace file:
>
> ----------------------
>
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
> CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
> Warn: Calling SyncFlush
> Explicit flush invoked!
> TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
> CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64d8c50
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
> TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
> queue
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64d8c50
> CCommand(command-14[Session-32])::SetCommandText(dialect:{C8B522D7-5CF3-11CE
> -ADE5-00AA0044773D}, cmd:schemamode=0)
> CCommand::Execute(riid:{00000000-0000-0000-0000-000000000000}, unkout:0)
> Full CmdText: schemamode=0
> Processing Command: 'schemamode'
> ========================================
===
> SQL Statement:
> SELECT
> DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek
> ,StdDay,StdHour,StdMin,StdSec,StdMs,DltY
ear,DltMonth,DltDayWeek,DltDay,DltHo
> ur,DltMin,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 25
>
> SQL Statement:
> SELECT
> DisplayName,StdName,DltName,Bias,StdBias
,DltBias,StdYear,StdMonth,StdDayWeek
> ,StdDay,StdHour,StdMin,StdSec,StdMs,DltY
ear,DltMonth,DltDayWeek,DltDay,DltHo
> ur,DltMin,DltSec,DltMs FROM TblReferenceTimeZone Where TzID = 27
>
>
> PagesPerObjChngsBuf : 1
> ExtraPagesPerObjChngsBuf : 100
> ObjChngsPerVector : 16
> ObjChngsVectors : 48
> ObjChngThreads : 1
> MaxUniqDataItemsPerDPS : 61440
> MaxClsInstPagesPerDPS : 10000
> SaveThreads : 4
> ThrdPoolIdleTime : 30000
> CallSaveMethod : true
> SavePackageLogFile :
>
> Command release (command-14[Session-32]) -- new refcount is 1, tid=0xed0
> Command release (command-14[Session-32]) -- new refcount is 0, tid=0xed0
> X>CCommand(command-14[Session-32], tid=0xed0) nuked
> TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
> TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
> queue
> CObjServices::AsyncFlushFuncStart - enter, tpi: 0x94d4ca0, dps: 0x64d8c24
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0x94d4ca0, dps: 0x64d8c24
> TID: 3792, SynchronousFlush(), Waiting for completion of obj changes queue
> TID: 3792, SynchronousFlush(), Waiting for completion of instance pool
> queue
> CObjServices::AsyncFlushFuncStart - enter, tpi: 0xd86cb60, dps: 0x64b7f34
> CObjServices::AsyncFlushFuncStart - exit, tpi: 0xd86cb60, dps: 0x64b7f34
> Releasing a job queue, handle: 120
> Destroying a job queue, type: InMemory, name: Processing
> Releasing a job queue, handle: 121
> Destroying a job queue, type: DBSearch, name: Global
> Releasing a job queue, handle: 122
> Destroying a job queue, type: DBInsert, name: Global
> Releasing a job queue, handle: 123
> Destroying a job queue, type: DBUpdate, name: Global
> Releasing a job queue, handle: 124
> Destroying a job queue, type: DelSearch, name: Global
> Releasing a job queue, handle: 125
> Destroying a job queue, type: DelInsert, name: Global
> Releasing a job queue, handle: 126
> Destroying a job queue, type: DelUpdate, name: Global
> ***** Alloc CStVBuf 1*****
> ***** Alloc CStVBuf 2*****
> SQL : SELECT B.CATEGORYNAME , C.CATEGORYNAME FROM
> [Wupti_prod_CATALOGHIERARCHY] A , [Wupti_prod_da-DK] B, [Wupti_prod_da-DK]
> C
> WHERE A.OID = B.OID AND A.CHILD_OID = C.OID AND C.CATEGORYNAME is
> not null AND A.Child_CatalogName = C.BaseCatalogName
> List Size :1 --- ParentID :1
>
> List Size :2 --- ChildId :2
>
> /* MonitorAClientProcess(), Received process terminate */
> /* MonitorAClientProcess(), leaving monitoring, shared memory: Trace-3, for
> process: DWUtil */
>
> --------------------------
>
> I would happily send the whole trace file to you, if it is useful?
>
> --
> Regards Lars
>
>
> "Brian Blum [MSFT]" wrote:
>
> the
> the
> then
> marked
> variable,
> for
> data
> rights.
> outputs
> "No
>
>