If you have the security-admin role, you can schedule jobs performed by the Edge Encryption proxy to repair or recover fields that use order preserving encryption.

Schedule jobs to:
  • Repair order tokens.
  • Recreate the proxy database.
Running these jobs can be a time-consuming operation that might impact the performance of the Edge Encryption proxy. Schedule these jobs at a time when no users or a minimum set of users are using the system, such as midnight on the weekend.

Schedule an order token repair job

You can schedule a job to find and repair fields where the order token is missing.

Before you begin

Role required: security_admin

About this task

Use these jobs to repair individual fields in a table or to repair all fields using order preserving encryption. Run this job when the proxy database has been offline while the instance has been running, which results in order preserving fields that are missing order tokens.

Procedure

  1. Navigate to All > Edge Encryption Configuration > Maintenance > Schedule Order Token Repair.
  2. Fill in the fields on the form, as appropriate.
  3. Click the menu icon in the form header and select Save.
  4. To see an estimated count of records to be updated, click Estimated Record Count.

Schedule a proxy-database recovery job

Run this job when the proxy database has lost data. This job finds all records that have been encrypted with a token (order preserving encryption type) and sends them to the proxy so that the proxy database can be rebuilt.

Before you begin

Role required: security_admin

Procedure

  1. Navigate to All > Edge Encryption Configuration > Maintenance > Schedule Database Recovery.
  2. Fill in the fields on the form, as appropriate.
  3. Click the menu icon in the form header and select Save.
  4. To see an estimated count of records to be updated, click Estimate Record Count.