EPiTrace - Highways yes but no user session details

mats@datra.com

Vote:

Hi everyone using EPiTrace, We have two (possibly related) problems regarding EPiTrace on our site. 1. We do not see any user details on the left hand side list and there are no rotating "balls" showing the n.o. users active on each page. We can see the highways and they update correctly. We use integrated windows authentication so users are automatically identified and authenticated. How does the system decide when to show a user in the list on the left and as a numbered "ball"? 2. In the file "\Util\Temp\epitraceerror.log" we receive an error every 20 seconds (see message sample below) that indicates the variable startIndex contains an invalid value. As far as I can see it should be numeric but the error message suggests it is treated as a string... We have tried resetting the contents of the "EPiTraceLiveData" table as well but the problem remains. We have made no changes to the EPiTrace software and so far only followed the instructions that are part of the V1.20 package. I am aware that no formal support from EPiServer is actually offered on this module but then again it would be very useful to get it up and running since it helps a lot in motivating further investments in the intranet. Any suggestions or ideas would be highly appreciated! Many thanks!!! Best Regards, Mats B. Content of the file "..\Util\Temp\epitraceerror.log":


--- datahandler:handleload --- 2008-01-29 10:30:33 ---
startIndex cannot be larger than length of string.
Parameter name: startIndex
id=450&action=load&seconds=20&random=8689735
--- datahandler:handleload --- 2008-01-29 10:30:53 ---
startIndex cannot be larger than length of string.
Parameter name: startIndex
id=450&action=load&seconds=20&random=187889
--- datahandler:handleload --- 2008-01-29 10:31:13 ---
startIndex cannot be larger than length of string.
Parameter name: startIndex
id=450&action=load&seconds=20&random=4836848
--- datahandler:handleload --- 2008-01-29 10:31:34 ---
startIndex cannot be larger than length of string.
Parameter name: startIndex
id=450&action=load&seconds=20&random=687402
--- datahandler:handleload --- 2008-01-29 10:31:54 ---
startIndex cannot be larger than length of string.
Parameter name: startIndex
id=450&action=load&seconds=20&random=1480334

Sample data from the table "EPiTraceLiveData":


152	2008-01-29 10:25:14	172.24.1.91	wfsdglzy3a5lkkvwm2wvy245		119
153	2008-01-29 10:25:15	172.24.1.160	qoesfvqmaskhpbmfvyxjrg45		119
154	2008-01-29 10:25:24	172.24.1.181	lnynkb55x41pud55xucemdf2		119
155	2008-01-29 10:25:26	172.24.1.146	3ipphcb2dtrouz45zv3qr555		119
156	2008-01-29 10:25:27	172.24.1.69	4btnwz3x0td3h1240ufl3vau		119
157	2008-01-29 10:25:32	172.24.2.9	njkbrdy2bu3011454hlyuwvc		119
158	2008-01-29 10:25:32	172.24.1.137	ojmrmfi2sejalbmacd5movr5		119
159	2008-01-29 10:25:34	172.24.1.235	r0puva3r032uh255ibv2w5qv		119
160	2008-01-29 10:25:34	172.24.1.190	pwaf4x45uzekas2yvtuopy45		119
161	2008-01-29 10:25:37	172.24.1.137	ojmrmfi2sejalbmacd5movr5	http://www.intranet.se/	147
162	2008-01-29 10:25:38	172.24.1.137	ojmrmfi2sejalbmacd5movr5	http://www.intranet.se/Tjanster/	137
163	2008-01-29 10:25:41	172.24.1.228	r43gbo454nxwz1jpqsctpwuu		119
164	2008-01-29 10:25:42	172.24.1.133	dl0hmorpgvgmpz55eahtmhye		119
165	2008-01-29 10:25:43	172.24.1.172	lgh4zh55adla5f55jjc2bq55		119

#11453

Feb 05, 2008 22:29

oskar.melen@logica.com

Vote:

I know this is an old topic, but i just ran into this, and someone else may be interested..

I happened upon the same problem when installing EPiTrace 1.21 on CMS 5R1.

Through some digging with Reflector i found out that the problem occurs when you have users on the site with empty Http_referer fields - the code tries to dig out the referer name, but doesnt handle empty referers well.

So, what i did, in a slightly hackish manner, was to add a trigger to the database, like this:

CREATE TRIGGER trg_CheckReferer
ON EPiTraceLiveData
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @refID INT;
SELECT @refID = (SELECT ID FROM INSERTED)
UPDATE EPiTraceLiveData SET HTTP_REFERER = 'http://none' WHERE ID = @refID AND HTTP_REFERER = '';

END

Not pretty, but it works! :)

#29762

May 12, 2009 15:35