Loading

Error 'field integrity exception: unknown' on Opportunity record update in a Sandbox

Date de publication: Apr 3, 2026
Description


After you Refresh Your Sandbox, users may report receiving an Internal Server Error upon attempting to update Opportunity records in the user interface. Alternatively, attempting to update the Opportunities via the API using Data Loader for example, will result in:


field integrity exception: unknown


This is commonly caused by a point-in-time copy issue related to performing an action against Roll-Up Summary Fields that either modifies them or triggers recalculation during the sandbox refresh process.

As per the sandbox Setup Tips and Considerations documentation:

"A sandbox is not a point-in-time snapshot of the exact state of your data. Furthermore, we recommend that you limit changes to your production organization while a sandbox is being created or refreshed. Setup and data changes to your production organization during the sandbox creation and refresh operations can result in inconsistencies in your sandbox. You might detect and correct some inconsistencies in your sandbox after it is created or refreshed."
 

Résolution


In order to resolve this error you will need to Contact Salesforce Customer Support via a new case.

To help expedite resolution include the following details when creating the case:

  • Subject: Unable to update Opportunity records in sandbox
  • Description: Include both the production organization ID and sandbox organization ID. See How to locate my Salesforce Organization ID.
  • Grant login access to the affected sandbox and production as an administrator for a month.
Note: A month should not be required however, it is recommended to set it for this amount of time to avoid access unexpectedly expiring during the case's investigation. Kindly keep in mind that access can always be revoked early once the issue is resolved. See How to Grant Login Access to a Salesforce Success Agent. 
 
  • Links to example or affected records.
  • Detailed steps to reproduce the error message.
If you're encountering the error in the user interface be sure to include example records with exact fields and their values that you are attempting to update.

If you're encountering the error via the Data Loader be sure to specify whether you're performing an Update or Upsert, the selections you are making for each step in the Data Loader and most importantly, attach your update and mapping file to the case. Attach the files by accessing your case after it has been submitted in the Help Portal.

You can click 'View Case' directly after submitting a new case or open an existing case as outlined in the "Check existing case" section of the Submit, update or clone a Case with Salesforce Support article.
 
  • Include explicit confirmation that Support has your permission to perform your provided steps above to verify and investigate the issue.
  • If the scenario is confirmed as being caused by an unexpected copy issue we will also require documented permission to run the necessary fix (scrutiny) to correct the data. Including documented permission for Support to run the necessary fix will help prevent potential delays.
Note: This will not have a negative impact in the sandbox. Typically, scrutinies are included as a part of the sandbox copy process however, in unexpected circumstances such as this, it's required to run them manually after the sandbox refresh completes.
 
  • Include this Knowledge Article # 000382663 and ask Support to reference the Internal Information section for next steps.


 

Numéro d’article de la base de connaissances

000382663

 
Chargement
Salesforce Help | Article