November Happy Hour will be moved to Thursday December 5th.

EPiTrace - Highways yes but no user session details

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
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
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.