Activity Forums Salesforce® Discussions What can cause data loss in Salesforce?

  • shariq

    September 23, 2018 at 6:50 am

    Data loss in Salesforce can be caused by a number of reasons, including:

    Changing data and date-time
    Migrating to percent, number, and currency from other data types
    Changing from multi-select pick list, checkbox, auto number to other types
    Altering to multi-select pick list from any type except pick list
    Changing to auto-number except from text
    Changing from text-area to e-mail, phone, URL, and text.

  • Laveena

    August 8, 2019 at 8:24 am

    Hi Aman,

    5 most common causes for data loss:

    1. Accidental or malicious deletion can occur when a user inadvertently or intentionally deletes one or more records. An individual record can easily be deleted by clicking on the delete button located on an object page. Multiple records can be deleted at one time with the mass delete utility
    2. Bad code can make incorrect changes to many records. Developers plan and test their code to avoid mistakes but program errors still happen. Not every actual scenario is always covered so code can sometimes have unexpected results. These changes can be very difficult to identify and even harder to fix.
    3.  Data import gone wrong will have a far reaching impact. Tools like the data import wizard and data loader allow users to update records in a single operation. Unfortunately an incorrect mapping can yield bad values in a large number of records.
    4. SOQL mistake can happen in an instant. The developer console query editor can be used to execute queries and the wrong syntax can create a serious problem. An update query is designed to potentially impact large number of records so a backup should always be run prior to any mass update.
    5. Problems with an integration could inadvertently update the wrong records. There are some very powerful integration tools for Salesforce that can update hundreds, thousands or even millions of records through automated processing. Without a current backup, an integration error of this magnitude could be impossible to recover from.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos