When you Reapply Changes on an Upgrade Detail on Fuji after reverting a metadata customization back to the out-of-the-box state, you ask the system to change the state of the record to whatever was defined in your recently undone customization. If the following factors are true, the column is dropped and re-created and data loss occurs:

- the record in question is a column definition
- the state defined by the Version record is a shorter column than what is in the current system
- the column contains data longer than the newly defined length

For further information, see KB0594807, "Write Audit landing page."

Steps to Reproduce

  1. Customize an out-of-the-box database column to be shorter than the setting that ships with the product.

    WARNING: Exercise caution. This activity may result in data loss.

  2. Upgrade or reactivate the plugin that contains the column definition.

    In some cases, the upgrade engine will automatically increase the length of the record, which invalidates the next steps.

  3. Find the record in the list of skipped Upgrade Details.

  4. Click the Revert to Out-of-the-box button.

  5. Click the Reapply Changes button.

    Expected result: Column is shorter and still contains data

    Actual result: Column is shorter and data is lost. In some circumstances, the column has been renamed to u_columnname.


We have implemented an Instance Analyzer script for the Fuji family of releases that blocks the most common scenarios that can cause data loss.

For instances on which the Instance Analyzer script has not been run

To prevent data loss, avoid use of the Revert to Out-of-box and Reapply Changes features until you are able to upgrade to a fixed version listed in the Fixed In section below. If you must execute a Revert to Out-of-box or Reapply Changes process before the instance can be upgraded, try the following:

  1. Follow the workaround instructions in KB0594818 on a sub-production instance.
  2. Confirm that reverting to the out-of-the-box state is what is desired, so that Reapply Changes does not need to be run in production.

For instances on which the Instance Analyzer script has been run

To prevent inadvertent data loss, we have limited the following features in all Fuji releases. When a user clicks on either of the following UI actions, we analyze the Update Set:

  • Back Out and Revert are refused for only Dictionary records on the following actions:
    • Local Changes - Back Out (KB0594820)
    • Update Version - Revert to this version (KB0594798)
    • Application Metadata - Revert to store app (KB0594819)
    • Update Comparison - Revert (KB0594817)
    • Upgrade Details - Back Out (KB0594816)
    • Upgrade Details - Revert to Out-of-box (KB0594818)
    • Upgrade Details - Reapply Changes (KB0594822)
    • Push or Pull Version - Use Pulled Version (KB0594812)

If Reapply Changes refuses to run on a Dictionary record, try this alternative approach:

  1. Navigate to System Definition > Dictionary and search for and open the Dictionary record in the list to open its form.
  2. On the form for the column in question, click the context menu ( icon) and choose Show File Properties.
  3. Ensure that the Versions related list is sorted by the Created column, with the most recent version at the top.
  4. In the Versions related list, locate the version you are attempting to back out to.
  5. Right-click on that version and choose Compare to Current.
    • If the comparison window displays changes to max_length, perform the operation on a sub-production instance and validate the results first. Data loss is likely.
    • If the comparison window displays changes to internal_type, perform the operation on a sub-production instance and validate the results first. Data loss is possible.
    • If the comparison window displays no changes to max_length and no changes to internal_type, click the Revert to this Version button to roll back the change.

Warning: If you see a message like the one that is circled, you will lose data. Click the Cancel button to avoid the change.

Confirm - Will lose data

Related Problem: PRB678425

Seen In


Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2016-09-27 14:23:43