|
Home > Archive > Commerce Server General > August 2004 > Hits for selected pages lost in bowels of SQL Server
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 |
Hits for selected pages lost in bowels of SQL Server
|
|
| Paul Robinson 2004-08-02, 5:51 pm |
| Hi Chaps,
I've got a problem with Commerce Server 2002 web reports – and I'd
sure appreciate some help.
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
| |
| Brian Blum [MSFT] 2004-08-17, 8:47 pm |
| 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: Hits for selected pages lost in bowels of SQL Server
Date: 2 Aug 2004 10:11:09 -0700
Organization: http://groups.google.com
Lines: 34
Message-ID: <95781d99.0408020911.4b76e241@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 1091466670 11095 127.0.0.1 (2 Aug 2004 17:11:10
GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Aug 2004 17:11:10 +0000 (UTC)
Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!postnews2.google.com!not-fo
r-mail
Xref: cpmsftngxa06.phx.gbl microsoft.public.commerceserver.general:14402
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'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
|
|
|
|
|