User records cannot be cleaned using DBClean

 Technote (troubleshooting)
 
Problem(Abstract)
Your Guest users are created in the USERS table with no PREVLASTSESSION value populated. The DBClean utility cannot remove these users from the database because these columns are not populated correctly.

USERS.PREVLASTSESSION is not populated, and Remember Me is enabled in the store.
 
Symptom
The USERS table continues to grow in size, even when regular maintenance for guest users is performed on the database.
 
Cause
On a store with Remember Me enabled for guest shoppers, the problem is reproduced by performing the following:
  1. In a new browser, go to the store where the Remember Me cookie has not yet been issued.
  2. Add an item to the shopping cart, therefore generating a new guest user.
  3. Close the browser.
  4. Re-open the browser, and go back to the store.

At this point, a new userid is created in the USERS table, with no PREVLASTSESSION value populated.
This is due to a programming defect.
 
Diagnosing the problem
Running the following SQL will tell you how many records in the database (if any) have this problem:

SELECT COUNT (*) FROM USERS WHERE PREVLASTSESSION IS NULL AND REGISTERTYPE='G'

This SQL returns the number of problem records in the database. Therefore, you have this problem if the query returns a value greater than zero.

 
Resolving the problem
This problem (APAR IZ17323) is resolved in Fix Pack 6.0.0.5 or newer. You can obtain the Fix Pack from the WebSphere® Commerce Fixes by version page. If you are running version 5.6.1, you will need to contact IBM® WebSphere Commerce support. You can open a service request electronically.
Applying this fix will prevent new records from being generated in the USERS table with PREVLASTSESSION being a null value.

You must manually clean the records that are in the database that do not have the PREVLASTSESSION column populated. To do this, populate the PREVLASTSESSION for these guest users with the current timestamp. By doing so, DBClean will be able to clean up the records when run at its regular interval.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce Enterprise Maintenance AIX, i5/OS, Linux, Solaris, Windows 6.0 Enterprise
Commerce WebSphere Commerce Business Edition Maintenance AIX, i5/OS, Linux, Solaris, Windows 5.6.1 Business Edition
Commerce WebSphere Commerce - Express Runtime i5/OS, Linux, Windows 5.6.1, 6.0 Express
Commerce WebSphere Commerce Developer Enterprise Maintenance Windows 6.0 Enterprise
Commerce WebSphere Commerce Developer Business Edition Maintenance Windows 5.6.1 Developer Business Edition
Commerce WebSphere Commerce Developer Professional Edition Maintenance Windows 5.6.1, 6.0 Developer Professional Edition
Commerce WebSphere Commerce Developer Express Maintenance Windows 5.6.1, 6.0 Developer Express
 
 

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Professional Edition
Maintenance

Software version:

5.6.1, 6.0

Operating system(s):

AIX, Linux, Solaris, Windows, i5/OS

Software edition:

Professional Edition

Reference #:

1299134

Modified date:

2008-07-14

Translate my page

Machine Translation

Content navigation