Data maintenance

Blue allows administrators the ability to run maintenance on the Blue database. A regular maintenance is performed by Blue itself, and a manual process can also be done.

Manage the Blue database from Connection - SETTINGS. The following information can be added or modified:

• Database time zone - The system time zone is used throughout Blue anywhere a date and time is required. By default, this is set to (UTC-05:00 Eastern Time (US & Canada). Upon installing or upgrading Blue, set the System Time Zone to the local time zone and then Update Configuration.
• API Key - Add the ‘API Key’ that Blue requires to access the Blue Web Services.
• BPI Transactions - Check Immediately Update Pathways to apply the most recent database changes to BPI pathways connected to your organization's portal.
• User Task Cache - Click Update to update the user task cache. You may choose to enable/disable the user task cache.
• Blue Configuration - Click Update Configuration to update XML configuration files stored in the database with those used by the application.
• Blue Data Maintenance - Click Run Maintenance to free up space by clearing out temporary data files, temporary data in database tables, and XML history.

Manual Blue data maintenance

To run data maintenance on the Blue database, log into Blue as an administrator.

1. From Blue Administration Console - Connection
2. Go to SETTINGS
3. Select Run Maintenance

Selecting Run Maintenance will perform the following:

• Clear the error table data if older than 6 months
• Clean the transaction events table
• Clear the session logs
• Rebuild the report version table index
• Clean Blue tokens if older than 6 months
• Clean log table OrgCrunchingTransaction
• Clean log table FailedSmsLog
• Clean the temp tables
• Clean impersonation logs for the last 3 months
• Clean audit log and activity logging older than 3 months

Automated Blue data maintenance

Daily Maintenance

• Clean up temp tables
• Clear the error table data if older than 6 months
• Clean the transaction events table
• Clear the session logs
• Clean Blue tokens if older than 6 months
• Clean log table OrgCrunchingTransaction
• Clean log table FailedSmsLog
• Clean the temp tables
• Clean impersonation logs older than 3 months
• Clean audit log and activity logging older than 3 months

Weekly Maintenance

• Update SQL statistics

Monthly Maintenance

• Rebuild Indexes