SqlAGDatabase: Unit tests fails intermittent

[johlju]

This test failed on a recent build. Tracking if this happens again.

  Describing SqlAGDatabase\Set-TargetResource

    Context When Ensure is Present
      .... # Some tests remove for readability

      [+] Should throw the correct error when it fails to add the database to the primary replica 19.9s
      [+] Should throw the correct error when it fails to add the database to the primary replica 25.73s

    Context When Ensure is Absent
      [+] Should remove the specified databases to the availability group(s) 8.83s
      [+] Should remove the specified databases to the availability group(s) when the primary replica is on another server 8.46s
      [-] Should throw the correct error when it fails to remove the database from the availability group 2.72s
        Expected an exception, with message 'The operation on the database 'DB2' failed with the following errors: Failed to remove the database from the availability group.' to be thrown, but the message was 'The operation on the database '3rdTypeOfDatabase' failed with the following errors: Failed to remove the database from the availability group..'. from D:\a\1\s\output\SqlServerDsc\14.0.0\DSCResources\DSC_SqlAGDatabase\DSC_SqlAGDatabase.psm1:604 char:9
            +         throw ($script:localizedData.AlterAvailabilityGroupDatabaseMe …
            +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        1092:                     { Set-TargetResource @mockSetTargetResourceParameters } | Should -Throw 'The operation on the database ''DB2'' failed with the following errors: Failed to remove the database from the availability group.'
        at <ScriptBlock>, D:\a\1\s\tests\Unit\DSC_SqlAGDatabase.Tests.ps1: line 1092

[johlju]

I think the unit tests need to be refactored. They are to complicated to read as they are now, and that might be the reason that it fails intermittently in PowerShell 7.