Daily Maintenance Process
This process performs daily maintenance processing. This is a several step process, and the Input Xml contains an element for each maintenance step as follows:
Daily Process Input Xml Elements
- ProcessAffiliateDailyTraffic
- True/False. This step consolidates of all of the daily traffic data stored in the AffiliateRawTraffic table and into the AffiliateDailyTraffic table, removing the previous day's data from the AffiliateRawTraffic table. Also adds any traffic from trial downloads (the DLDemoLog table) that are associated with affiliates to the AffilliateDailyTraffic table.
- ConvertHoldingInvoicesToShipping
- True/False. This step will find invoices with a status of Holding and a Hold Date of the current date, set the status to Shipping, and clear the Hold Date.
- DeleteLicensesAndinvoices
- True/False. This step deletes all Invoice and License records which are marked for deletion. This will also delete any dependencies these licenses and invoices have (including refunds, unlock history, and store credits).
- PurgeOrphanedCarts
- True/False. This step deletes all cart records that have not been accessed in the last 30 days that do not have a customer associated with them, as well as all carts older than 6 months.
- UpdateTrialDownloadLogWithCustomerID
- True/False. This step updates the trial download log with CustomerIDs based on email matches with the customer table. This allows downloaded trials to be tied to customers who have made a purchase (thereby creating a customer record in SOLO Server), and also allows SOLO Server to calculate the conversion rate from trials to purchases.
- ResetLoginViewCCNumbers
- True/False. This step updates all user records to no longer have view credit card number permission for security reasons.
- MaskDeclinedOrdersDaysBack
- Numeric (default 1). This step permanently masks all credit card numbers stored in the DeclinedOrders table entered prior to the specified number of days back from the current date for security reasons. Use a value of 0 to disable this.
- MaskInvoicesDaysBack
- Numeric (default 180) This step permanently masks all credit card numbers stored in the Invoices table entered prior to the specified number of days back from the current date for security reasons. Use a value of 0 to disable this.
- MaskDisabledStoredPaymentsDaysBack
- Numeric (default 30). This step permanently masks all credit card numbers stored on the StoredPaymentInfo table and associated with a payment plan instance marked inactive prior to the specified number of days back from the current date (and not also associated with an active payment plan instance) for security reasons.
- PurgeAuthorLoginAudit
- True/False. This step will permanently delete all author LoginAudit records which are no longer within the scope of the author login velocity check.