1

I'm getting DML errors when trying to test some triggers:

This error occurred: MIXED_DML_OPERATION: DML operation on setup object is not permitted after you have updated a non-setup object (or vice versa).

I'm running my test case on a dev sandbox, and am inserting users before I insert a custom object. From my understanding, this is what is causing these MIXED_DML_OPERATION errors, as I'm updating configuration and standard objects in the same transaction.

That being said, is a single APEX test considered a transaction? Other than making changes to my code to account for testing, is there a way around inserting users in a test other than having seeAllData=true?

2
  • You can get around the mixed DML using system.runAs() Use SOQL to query for the Id of a single user with the System Administrator profile (you can do this without seeAllData=true). Using that User.Id you can then leverage a block of code preceded by the system.runAs(<user.Id>) method to insert your test Users. Feb 19, 2018 at 22:36
  • don't even think about seeAllData=true
    – cropredy
    Feb 20, 2018 at 1:08

1 Answer 1

4

First of all, you do not need to set SeeAllData=true if you want to see User records in a test. You always see them. Second of all, as outlined here the standard workaround to create a separate transaction inside your test method is to use system.runAs(user).

system.runAs(new User(Id=UserInfo.getUserId())
{
    // separate transaction
}

In an actual test, that would look something like:

@IsTest
static void testSomeStuff()
{
    User admin = [
        SELECT Id FROM User
        WHERE Profile.Name = 'System Administrator'
        LIMIT 1
    ];
    // it is a good idea to query for a privileged user
    // so the test will work no matter who runs it

    system.runAs(admin)
    {
        // insert users here
        // along with any other setup data
    }

    // insert non setup objects

    Test.startTest();
        // do stuff
    Test.stopTest();

    // verify behavior using assertions
}

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .