Run Script After Sandbox Creation and Refresh

Question

With the Spring '16 release, there is new functionality where we can set a script to run after refreshing a sandbox. In the documentation it gives an example where it prints the three context variables to a debug log.

Not being sure where that debug log would be stored or how to retrieve it, I created a similar class (api v36.0) that I applied to a developer sandbox (Spring '16, as is prod.):

global class Sandbox_Refresh implements SandboxPostCopy {
  global void runApexClass(SandboxContext context) {
      insert new Account(name = 'Org Id: ' + context.organizationId() + ' Sandbox Id: ' + context.sandboxId() + ' Sandbox Name: ' + context.sandboxName());
    }
}

After creating and also later when refreshing the sandbox, there was no account created, even though running very similar code as anonymous Apex right afterwards worked just fine:

insert new Account(name='test');

I also tried adding a test class, which ran fine in both the sandbox and production. Even when the sandbox post copy code had 100% test coverage, I still wasn't able to see the account created in the sandbox after a refresh.

@isTest
public class Test_Sandbox_Refresh{
    public static @isTest void runTest(){
        Sandbox_Refresh ClassInstance = new Sandbox_Refresh();
        Test.testSandboxPostCopyScript(ClassInstance, UserInfo.getOrganizationId(), '00Dp00000000hjM', 'sandbox2');
    }
}

Now I'm not sure why the Sandbox Refresh script didn't work, or where to find a log to trouble-shoot the issue. Has anyone gotten a Sandbox Refresh script to run successfully, and if so, do you have any tips for trouble-shooting when it doesn't work properly?

Answer 1

I had the same issue and raised a ticket for Salesforce support team.

They came back saying there is a bug at their end and they are working on fixing it. Fix is expected to be available by end of next week (safe harbor).

Here is the response I got from Salesforce Support team.

Hi Arpit,

Hope you are doing good.

I would like to inform you that our R&D team has identified this issue as a bug and are working on it to fix the same. I'll keep you posted of further updates on this one.

Regards
Ayush Sodhi
Success Agent- Tier 2

Answer 2

For my case my script didn't run successfully because of sending an email at the end, where in new sandboxes this option is disabled by default.

Just because of this, my previous DML was not commited, which is quite strange. I replace the send log in email with creating a log via documentcontent and was able to run the script on my new org.

I run the script in my org manually like this :

AP_PostSandboxRefreshActions ap = new AP_PostSandboxRefreshActions();
ap.runApexClass(null);

The code to write the log as a contentDocument is a follows :

ContentVersion cv = new ContentVersion();
cv.Title='Sandbox refresh log'; 
cv.PathOnClient ='log.txt';
cv.VersionData = blob.valueOf(log); //where log is a string 
cv.origin = 'H';
insert cv;