Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Repair or recover order-preserving encrypted data

Repair or recover order-preserving encrypted data

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.

You can schedule jobs to:
  • Repair order tokens.
  • Recreate the proxy database.
Running these jobs can be a time-consuming operation which 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 Edge Encryption Configuration > Maintenance > Schedule Order Token Repair.
  2. Fill in the fields on the form, as appropriate.
    Field Value
    Name Enter a descriptive name.
    Job Type Select Order Token Repair.
    All fields Select this check box to repair all tables.
    Table Select a table.
    Column Select a column.
    Active Clear this check box if you want to deactivate this job.
    Run Select the period between job executions.
    Starting Enter the date and time to run the job for the first time.
  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 Edge Encryption Configuration > Maintenance > Schedule Database Recovery.
  2. Fill in the fields on the form, as appropriate.
    Field Value
    Name Enter a descriptive name for this job.
    Job Type Select Database Recovery.
    Active Clear this check box if you want to deactivate this job.
    Run Select the period between job executions.
    Starting Enter the date and time to run this job for the first time.
  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.

This site is scheduled for a small content update on Tuesday, December 18th, between the hours of 4:00pm and 8:00pm Pacific Time (Dec 19 00:00 – Dec 19 4:00 UTC). Access to this site may be slightly delayed during that time.