Hi Chaps,

I've got a problem with Commerce Server 2002 web reports – and I'd
sure appreciate some help.  I posted this a few weeks ago and received
no response - surely you're better than that!?!?!

I've customised the Directories report to include a URI column which
lists hits for actual pages after level 6, i.e. after level 6 you can
expand to see all pages in that directory, with totals beside them.
This has been working a treat for months (well, years actually).

In one directory (although the problem could be more widespread) only
three out of eight pages are showing in the report (each with hundreds
of hits), even though all eight pages are being visited equally.

I've had a hunt through the logs and database and made these
observations (hopefully useful):

1. The pages are being logged by IIS
2. URIs for all eight pages in this directory are listed in the URI
table
3. All eight pages have multiple entries in the Requests table (I
joined the URIkeys to form a query) and IsRequest=1.
4. All eight pages have multiple entries in the HitsInfo table
4. ONLY three of the eight pages have entries in the RequestsByURI
table, and these are the only pages showing on the report.

In summary then, something here has gone crunch.  The filtering wont
be filtering anything out, as it doesn't match any criteria.

Now then, roll up with your suggestions!

Cheers,

Paul

[ Post a follow-up to this message ]

RequestsByURI is populated by CSDW_MakeAggRequestsByUri which top counts
(default is 1000) entries from each of the entry, exit and most active
pages for a total of up to 2000 pages.

You can edit the CSDW_MakeAggRequestsByUri stored procedure and change the
line:

set @UriMemberCount = convert(nvarchar(32),1000)

to be a higher number.

--------------------
From: groups@pgr.co.uk (Paul Robinson)
Newsgroups: microsoft.public.commerceserver.general
Subject: Page hits lost in bowels of SQL Server - tricky problem
Date: 16 Aug 2004 04:30:01 -0700
Organization: http://groups.google.com
Lines: 35
Message-ID: <95781d99.0408160330.1055c685@posting.google.com>
NNTP-Posting-Host: 194.203.143.83
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1092655802 27998 127.0.0.1 (16 Aug 2004
11:30:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 16 Aug 2004 11:30:02 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!p
ostnews2.google.com!not-for-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14538
X-Tomcat-NG: microsoft.public.commerceserver.general

Hi Chaps,

I've got a problem with Commerce Server 2002 web reports - and I'd
sure appreciate some help.  I posted this a few weeks ago and received
no response - surely you're better than that!?!?!

I've customised the Directories report to include a URI column which
lists hits for actual pages after level 6, i.e. after level 6 you can
expand to see all pages in that directory, with totals beside them.
This has been working a treat for months (well, years actually).

In one directory (although the problem could be more widespread) only
three out of eight pages are showing in the report (each with hundreds
of hits), even though all eight pages are being visited equally.

I've had a hunt through the logs and database and made these
observations (hopefully useful):

1. The pages are being logged by IIS
2. URIs for all eight pages in this directory are listed in the URI
table
3. All eight pages have multiple entries in the Requests table (I
joined the URIkeys to form a query) and IsRequest=1.
4. All eight pages have multiple entries in the HitsInfo table
4. ONLY three of the eight pages have entries in the RequestsByURI
table, and these are the only pages showing on the report.

In summary then, something here has gone crunch.  The filtering wont
be filtering anything out, as it doesn't match any criteria.

Now then, roll up with your suggestions!

Cheers,

Paul


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

EBusiness Server Team

[ Post a follow-up to this message ]