Activity Forums Salesforce® Discussions What are the reasons for data loss in Salesforce?

  • Satya

    Member
    April 29, 2016 at 7:28 am

    Data loss may cause due to following reasons:

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

    Member
    April 29, 2016 at 7:28 am

    Hello Amit,

    Changing the data type of an existing custom field can cause data loss. For more information go to this link:-

    https://help.salesforce.com/apex/HTViewHelpDoc?id=notes_on_changing_custom_field_types.htm&language=en

  • Naman

    Member
    April 29, 2016 at 7:51 am

    Changing field type could cause the data loss. So we need to take backup of data first before doing so.

  • Parul

    Member
    September 28, 2018 at 5:32 pm

    Data loss may cause due to following reasons:

    Changing data and date-timeAltering to percent,number and currency from other data typesChanging from multi-select picklist, checkbox, auto number to other typesAltering to multi-select picklist from any type except picklistChanging to auto-number except from textChanging from text-area to e-mail, phone, URL and text

  • Parul

    Member
    September 28, 2018 at 5:35 pm

    Adding some points:

    There are 5 main causes of data loss in Salesforce:

    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.

    Thanks

Log In to reply.

Popular Salesforce Blogs