DSC waitforall Nod Roles and dependencies

DSC
1

Hi
Using Server 2012R2 with WMF 5

I have created a multi-node confguration that filters on roles SQL,Appserver (SharePoint),Master (SharePoint to create farm), and WebFrontEnd (SharePoint),.

It is crucial that the SQL server is installed before the node with the master role creates the SharePoint farm.

So I have filtered the SharePoint servers to install all binaries while the SQL installs.
All SharePoint servers are supposed to wait for SQL to finish installing before creating/joining the SharePoint farm.

-Master role waits for the SQL installation to finish before creating the SharePoint Farm.
-AppServer and WebFrontEnd roles wait until the Sharepoint farm is created before joining farm.

My issue is that my MOf for my master role server starts with waitforall pointing to the SQL server. My Appserver and WebfrontEnd roles Mofs also start with WaitForall pointing to the create farm resource.

When using waitforall, it is at the beginning of the filter, like so:

#Installing SQL
Node $AllNodes.Where({$_.Role -eq "SQL"}).NodeName
    {
....
....
....
TempDBGrowth TempFileGrowth
{
...
...
...
}
    }

#Installing all binaries on the SharePoint Servers
Node $AllNodes.Where({$_.Role -eq "WebFrontEnd" -and $_.Role -eq "AppServer"}).NodeName
    {
.....
[Install binary]
...
InstallCUApril2016 AprilCU2016
{
...
...
}

    }
    #Here I want the node that has the master role (is also an appserver role) to wait until SQL is done before continuing;
    Node $AllNodes.Where({$_.Master -eq $True -and $_.Role -eq "AppServer"}).NodeName
    {
        
        WaitforAll SQL
        {
           #Last config in the SQL configuration:
            ResourceName = "[TempDBGrowth]TempFileGrowth"
            NodeName          = $AllNodes.Where({$_.Role -eq "SQL"}).NodeName
            RetryIntervalSec  = 15
            RetryCount        = 30 
            #DependsOn = "[InstallCUApril2016]AprilCU2016"     
        } 
    }

If I uncomment the DependsOn = “[InstallCUApril2016]AprilCU2016” and compile configuration, I get the error:

ValidateNodeResources : Resource '[InstallCUApril2016]AprilCU2016' required by '[WaitForAll]SQL' does not exist. Please ensure that the required resource exists and the name is properly formed.
At C:\windows\system32\windowspowershell\v1.0\Modules\PSDesiredStateConfiguration\PSDesiredStateConfiguration.psm1:1001 char:17
+                 ValidateNodeResources
+                 ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (:) [Write-Error], InvalidOperationException
    + FullyQualifiedErrorId : RequiredResourceNotFound,ValidateNodeResources
Errors occurred while processing configuration 'SQLSharePointInstall'.
At C:\windows\system32\windowspowershell\v1.0\Modules\PSDesiredStateConfiguration\PSDesiredStateConfiguration.psm1:3705 char:5
+     throw $ErrorRecord
+     ~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (SQLSharePointInstall:String) [], InvalidOperationException
    + FullyQualifiedErrorId : FailToProcessConfiguration

Any tips on how to proceed so that I am able to “pause” SharePoint configuration (Farm create/join) until the SQL installation is complete?

Brgs

Bjørn

2

For now I have just divided the roles into different .ps1 files and dot-source into roles. Maybe this is the best approach as the configurations are quiet long.

brgs

Bjørn

3

Next stop Composite Configurations. Here we go.