|
Home > Archive > Commerce Server General > April 2005 > Problem deleting "junk" anonymous records from the UserObject table
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 |
Problem deleting "junk" anonymous records from the UserObject table
|
|
| Ravi Shankar 2004-09-02, 6:21 pm |
| If you've based your solution on the Retail Solution Site
which came out with Commerce Server 2000 then I think
under "App Settings" there is an option called "Profile
Anonymous Users". If this option is set then the
anonymous user profiles are created in the UserObject
Table. If this setting is '0' then these records\are not
created but the site still works fine.
You could have a look at the retail code and see how it
is handled there.
HTH
>-----Original Message-----
>I have a situation with our installation of Commerce
Server 2000
>regarding the UserObject table. I know that every time
a user come to
>the site anonymously, CS2K adds a record to the
UserObject table that
>has blanks in most fields, i.e. the anonymous user
records. These
>records tend to "fill up" the UserObject table quite
quickly. The
>table now has over 100,000 of these anonymous records
for about 4,000
>or so good user records.
>
>We attempted to simply delete these anonymous records in
a scheduled
>stored procedure. The records delete ok, but there is
one side effect
>that we are trying to solve. that is, we are finding
that we have a
>few pages on our site that don't work right, if one of
these anonymous
>users come back to the site. We think it's because of an
association
>to a local cookie.
>
>In other words if user X comes to the site just to
browse and never
>logs in, we still drop a cookie on their local machine.
If in the
>interim we were to delete his anonymous record, when he
comes back to
>the site some pages are showing errors. We think it has
something to
>do with the fact that there was a local cookie, yet it
can no longer
>match up to their anonymous record.
>
>Thanks for any help--
>cjsalzano@hotmail.com
>.
>
| |
| Luiz Tosi 2005-04-14, 2:16 pm |
| i hv the same problem,
but i dont know where i can find the App Settings to turn off this option to insert a annon user on my DB,
iam using commerce server 2000 with ASP (no ASP.NEt),
anyone ? plz! |
|
|
|
|