Integration Guide

System Administration Interface
______________________________________________________________________________
WaveWorks PSS, Integration Guide, 1.10 Page 118
© 2000, Symbol Technologies, Inc. February 1, 2000
Tx ID: PST105
Class: PssDbCleanupCOM
Method: PerformDBCleanup
Description: PerformDBCleanup performs a number of operations to reduce the number of
rows in various database tables, thus improving system performance and eliminating obsolete or
unnecessary data. Its operation is configurable based on entries in the system settings with name
“PSSDBCleanup.” The configuration is read when the COM object is initialized, and since this
routine typically runs only once per night, it should happen each time that PerformDBCleanup is
run.
The first step is the cleaning of the PSS_Message_Log table. All records in the table that are
older than the configured number of hours and are not required for system reporting are deleted
from the table. Currently, the only message log entries used for system reporting are those with
facility ‘Unit Management’ and action 'TerminalCount', 'OperationalCount', 'TerminalIssued', or
'TerminalReturned'. Actions required for reporting are kept for 13 months, which is the current
limit for the system reports.
Next, the PSS_POS_Status table is processed. All records with a Start_Time or Detection_Time
older than the configured number of hours for each type is deleted from the table, except for the
records with Item_Name ‘POSControllerName’, for which there is always only one record for
each POS controller in use.
Finally, the shopping trip data is processed. This includes both the current shopping list data
from PSS_Shopping_List, and the historical data from both PSS_Shopping_History_List and
PSS_Shopping_Incomplete_List.
For current shopping lists, any shopping list data with a Time_Started older than the configured
number of hours is deleted. Shopping list data includes all associated items
(PSS_Shopping_Item), activities (PSS_Shopping_Activity), tax data (PSS_Shopping_Tax),
marketing data (PSS_Marketing_Sent), exception items (PSS_Unknown_Item), and quick order
list (PSS_Order_List) and item (PSS_Order_List_Item) data. Exception item data for which
barcode was scanned, terminal used, and time of scan is kept in the PSS_Unknown_Item table,
but the link to the customer shopping list is removed.
Parameters:
Input:
none
Output:
rc long integer indicates whether the call succeeded