Desperately seeking answer re: access log

[stephiesmith1]

Does anyone know if there is a difference between what the access log says below in these 2 instances? Why does the 2nd one say "cleansession" but the first one doesn't? This user wants my database taken down because he got an error that said another user was in the record (no one else had access to the record he was in) and he lost his input. I think maybe he logged in twice without logging out the first time, which would make HIM the other user. HE says the database is worthless because he has one problem after another but no one else has had any problem (I checked the application log for errors.) His "other user" error (#301) came up after the 2nd login below.

Please give any advice. The entire management team is now involved (he is a director) and I need to give them an answer. Is there anything I can look for in either log that will explain? Is there any way to tell if someone logs out? If not, i s there a script that I can write for future that will tell when someone logs out?

FIRST ONE:

68.38.46.9:1566 - thollister [09/Jan/2007:23:22:40 -0500] "/fmi/iwp/cgi?-db=FY_2006_Performance_Reviews&-startsession"

SECOND ONE:

68.38.46.9:1573 - thollister [09/Jan/2007:23:23:46 -0500] "/fmi/iwp/cgi?-db=FY_2006_Performance_Reviews&-startsession"

68.38.46.9:1572 - thollister [09/Jan/2007:23:23:46 -0500] "/fmi/iwp/cgi?-db=FY_2006_Performance_Reviews&-cleansession"

[stephiesmith1]

Uh, oh. Looking carefully at the "authdb" which shows that he logged in as the authorized user, I see that he was in the database for longer than an hour and then he logged in again. If you are timed out, does that record get locked as though the user is still in there? He logged in again and it was after that 2nd login that he got the 301. I still find it strange if that is the reason. Other people have been in much longer than an hour which means they probably got timed out, too, but no one else out of 40 people who have used this database for the past 2 months has gotten that 301 error.

So, still looking for something to tell them if anyone has any ideas.

Thanks,

[stephiesmith1]

Does anyone know what shows up on an access log when someone times out? I thought it would be a 404 because when I timed out once I got a "page not found" which I thought was a 404. There are no errors on the application log until the 301 error shows up. (There IS a 404 this morning because the CFO who hosts this database accidentally closed it while someone was in it online.)

I've attached the access and application files for the period of time that thollister was online. If anyone sees anything of interest, please let me know. His user name shows up a lot but it might be because of scripts I have that check the user name in order to show the right set of records. (Not sure if that type of thing shows up on the logs.)

Thanks,Stephie

applicationJan9.zip