Add integration test stage for DSCv3 #2102

johlju · 2025-05-02T16:44:26Z

Pull Request (PR) description

Add integration test in DSCv3.

This Pull Request (PR) fixes the following issues

Fixes Add integration tests that run using DSCv3 #2094

Task list

Added an entry to the change log under the Unreleased section of the
file CHANGELOG.md. Entry should say what was changed and how that
affects users (if applicable), and reference the issue being resolved
(if applicable).
Resource documentation updated in the resource's README.md.
Resource parameter descriptions updated in schema.mof.
Comment-based help updated, including parameter descriptions.
Localization strings updated.
Examples updated.
Unit tests updated. See DSC Community Testing Guidelines.
Integration tests updated (where possible). See DSC Community Testing Guidelines.
Code changes adheres to DSC Community Style Guidelines.

This change is

johlju · 2025-05-03T12:21:39Z

It runs now, but fails with:

2025-05-03T12:19:19.662240Z ERROR PID 4624: Exception: Cannot validate argument on parameter 'Property'. The argument is null, empty, or an element of the argument collection contains a null value. Supply a collection that does not contain any null values and then try the command again.
2025-05-03T12:19:19.692068Z ERROR Error: Command: Resource 'powershell' [exit code 1] manifest description: Error

johlju · 2025-05-08T15:30:30Z

This is the full trace log from the pipeline.

2025-05-03T13:54:42.841119Z  INFO dsc::util: 419: Trace-level is Trace
2025-05-03T13:54:42.841189Z DEBUG dsc: 42: Running DSC version: 3.0.2
2025-05-03T13:54:42.841224Z DEBUG dsc_lib::discovery::command_discovery: 381: Searching for resources: ["SqlServerDsc/SqlRSSetup"]
2025-05-03T13:54:42.841375Z  INFO dsc_lib::discovery::command_discovery: 173: Discovering resources using filter: *
2025-05-03T13:54:42.841384Z DEBUG dsc_lib::discovery::command_discovery: 176: Using regex ^.*?$ as filter for adapter name
2025-05-03T13:54:42.842138Z DEBUG dsc_lib::util: 90: Found setting 'resourcePath' in C:\Users\VssAdministrator\AppData\Local\dsc\dsc_default.settings.json
2025-05-03T13:54:42.842201Z DEBUG dsc_lib::util: 100: Found setting 'resourcePath' in C:\Users\VssAdministrator\AppData\Local\dsc\dsc.settings.json
2025-05-03T13:54:42.842240Z DEBUG dsc_lib::util: 114: Setting 'resourcePath' not found in C:\ProgramData\dsc\dsc.settings.json
2025-05-03T13:54:42.842272Z DEBUG dsc_lib::discovery::command_discovery: 122: Appending PATH to resourcePath
2025-05-03T13:54:42.842308Z TRACE dsc_lib::discovery::command_discovery: 125: Original PATH: C:\agents\4.254.0\externals\git\cmd;C:\agents\4.254.0\externals\git\mingw64\bin;C:\Program Files\MongoDB\Server\5.0\bin;C:\aliyun-cli;C:\vcpkg;C:\cf-cli;C:\Program Files (x86)\NSIS\;C:\tools\zstd;C:\Program Files\Mercurial\;C:\hostedtoolcache\windows\stack\3.5.1\x64;C:\cabal\bin;C:\\ghcup\bin;C:\mingw64\bin;C:\Program Files\dotnet;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Program Files\R\R-4.4.2\bin\x64;C:\SeleniumWebDrivers\GeckoDriver;C:\SeleniumWebDrivers\EdgeDriver\;C:\SeleniumWebDrivers\ChromeDriver;C:\Program Files (x86)\sbt\bin;C:\Program Files (x86)\GitHub CLI;C:\Program Files\Git\bin;C:\Program Files (x86)\pipx_bin;C:\npm\prefix;C:\hostedtoolcache\windows\go\1.21.13\x64\bin;C:\hostedtoolcache\windows\Python\3.9.13\x64\Scripts;C:\hostedtoolcache\windows\Python\3.9.13\x64;C:\hostedtoolcache\windows\Ruby\3.0.7\x64\bin;C:\Program Files\OpenSSL\bin;C:\tools\kotlinc\bin;C:\hostedtoolcache\windows\Java_Temurin-Hotspot_jdk\8.0.452-9\x64\bin;C:\Program Files\ImageMagick-7.1.1-Q16-HDRI;C:\Program Files\Microsoft SDKs\Azure\CLI2\wbin;C:\ProgramData\kind;C:\Program Files\Eclipse Foundation\jdk-8.0.302.8-hotspot\bin;C:\ProgramData\Chocolatey\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\PowerShell\7\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\WiX Toolset v3.14\bin;C:\Program Files (x86)\Windows Kits\10\Windows Performance Toolkit\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\160\DTS\Binn\;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\ProgramData\chocolatey\lib\pulumi\tools\Pulumi\bin;C:\Program Files\CMake\bin;C:\ProgramData\chocolatey\lib\maven\apache-maven-3.9.9\bin;C:\Program Files\Microsoft Service Fabric\bin\Fabric\Fabric.Code;C:\Program Files\Microsoft SDKs\Service Fabric\Tools\ServiceFabricLocalClusterManager;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Git\mingw64\bin;C:\Program Files\Git\usr\bin;C:\Program Files\GitHub CLI\;c:\tools\php;C:\Program Files (x86)\sbt\bin;C:\Program Files\Amazon\AWSCLIV2\;C:\Program Files\Amazon\SessionManagerPlugin\bin\;C:\Program Files\Amazon\AWSSAMCLI\bin\;C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\bin;C:\Program Files (x86)\Microsoft BizTalk Server\;C:\Program Files\LLVM\bin;C:\Users\VssAdministrator\.dotnet\tools;C:\Users\VssAdministrator\.cargo\bin;C:\Users\VssAdministrator\AppData\Local\Microsoft\WindowsApps;C:\Users\VssAdministrator\AppData\Local\dsc
2025-05-03T13:54:42.842482Z TRACE dsc_lib::discovery::command_discovery: 144: Exe home is already in path: C:\Users\VssAdministrator\AppData\Local\dsc
2025-05-03T13:54:42.842573Z DEBUG dsc_lib::discovery::command_discovery: 157: Using Resource Path: C:\agents\4.254.0\externals\git\cmd;C:\agents\4.254.0\externals\git\mingw64\bin;C:\Program Files\MongoDB\Server\5.0\bin;C:\aliyun-cli;C:\vcpkg;C:\cf-cli;C:\Program Files (x86)\NSIS\;C:\tools\zstd;C:\Program Files\Mercurial\;C:\hostedtoolcache\windows\stack\3.5.1\x64;C:\cabal\bin;C:\\ghcup\bin;C:\mingw64\bin;C:\Program Files\dotnet;C:\Program Files\MySQL\MySQL Server 5.7\bin;C:\Program Files\R\R-4.4.2\bin\x64;C:\SeleniumWebDrivers\GeckoDriver;C:\SeleniumWebDrivers\EdgeDriver\;C:\SeleniumWebDrivers\ChromeDriver;C:\Program Files (x86)\sbt\bin;C:\Program Files (x86)\GitHub CLI;C:\Program Files\Git\bin;C:\Program Files (x86)\pipx_bin;C:\npm\prefix;C:\hostedtoolcache\windows\go\1.21.13\x64\bin;C:\hostedtoolcache\windows\Python\3.9.13\x64\Scripts;C:\hostedtoolcache\windows\Python\3.9.13\x64;C:\hostedtoolcache\windows\Ruby\3.0.7\x64\bin;C:\Program Files\OpenSSL\bin;C:\tools\kotlinc\bin;C:\hostedtoolcache\windows\Java_Temurin-Hotspot_jdk\8.0.452-9\x64\bin;C:\Program Files\ImageMagick-7.1.1-Q16-HDRI;C:\Program Files\Microsoft SDKs\Azure\CLI2\wbin;C:\ProgramData\kind;C:\Program Files\Eclipse Foundation\jdk-8.0.302.8-hotspot\bin;C:\ProgramData\Chocolatey\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files\PowerShell\7\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files (x86)\WiX Toolset v3.14\bin;C:\Program Files (x86)\Windows Kits\10\Windows Performance Toolkit\;C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\160\DTS\Binn\;C:\Strawberry\c\bin;C:\Strawberry\perl\site\bin;C:\Strawberry\perl\bin;C:\ProgramData\chocolatey\lib\pulumi\tools\Pulumi\bin;C:\Program Files\CMake\bin;C:\ProgramData\chocolatey\lib\maven\apache-maven-3.9.9\bin;C:\Program Files\Microsoft Service Fabric\bin\Fabric\Fabric.Code;C:\Program Files\Microsoft SDKs\Service Fabric\Tools\ServiceFabricLocalClusterManager;C:\Program Files\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Git\mingw64\bin;C:\Program Files\Git\usr\bin;C:\Program Files\GitHub CLI\;c:\tools\php;C:\Program Files\Amazon\AWSCLIV2\;C:\Program Files\Amazon\SessionManagerPlugin\bin\;C:\Program Files\Amazon\AWSSAMCLI\bin\;C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\bin;C:\Program Files (x86)\Microsoft BizTalk Server\;C:\Program Files\LLVM\bin;C:\Users\VssAdministrator\.dotnet\tools;C:\Users\VssAdministrator\.cargo\bin;C:\Users\VssAdministrator\AppData\Local\Microsoft\WindowsApps;C:\Users\VssAdministrator\AppData\Local\dsc
2025-05-03T13:54:43.083488Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\assertion.dsc.resource.json
2025-05-03T13:54:43.083776Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.DSC/Assertion' found
2025-05-03T13:54:43.083959Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\echo.dsc.resource.json
2025-05-03T13:54:43.084054Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.DSC.Debug/Echo' found
2025-05-03T13:54:43.084103Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\group.dsc.resource.json
2025-05-03T13:54:43.084213Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.DSC/Group' found
2025-05-03T13:54:43.084281Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\include.dsc.resource.json
2025-05-03T13:54:43.084387Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.DSC/Include' found
2025-05-03T13:54:43.084466Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\osinfo.dsc.resource.json
2025-05-03T13:54:43.084639Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft/OSInfo' found
2025-05-03T13:54:43.084741Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\powershell.dsc.resource.json
2025-05-03T13:54:43.084876Z TRACE dsc_lib::discovery::command_discovery: 226: Resource adapter 'Microsoft.DSC/PowerShell' found
2025-05-03T13:54:43.084973Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\reboot_pending.dsc.resource.json
2025-05-03T13:54:43.085052Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.Windows/RebootPending' found
2025-05-03T13:54:43.085123Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\registry.dsc.resource.json
2025-05-03T13:54:43.085230Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.Windows/Registry' found
2025-05-03T13:54:43.085317Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\RunCommandOnSet.dsc.resource.json
2025-05-03T13:54:43.085406Z TRACE dsc_lib::discovery::command_discovery: 229: Resource 'Microsoft.DSC.Transitional/RunCommandOnSet' found
2025-05-03T13:54:43.085482Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\windowspowershell.dsc.resource.json
2025-05-03T13:54:43.085599Z TRACE dsc_lib::discovery::command_discovery: 226: Resource adapter 'Microsoft.Windows/WindowsPowerShell' found
2025-05-03T13:54:43.085735Z TRACE dsc_lib::discovery::command_discovery: 208: Found resource manifest: C:\Users\VssAdministrator\AppData\Local\dsc\wmi.dsc.resource.json
2025-05-03T13:54:43.085823Z TRACE dsc_lib::discovery::command_discovery: 226: Resource adapter 'Microsoft.Windows/WMI' found
2025-05-03T13:54:43.085892Z DEBUG dsc_lib::discovery::command_discovery: 241: Found 8 matching non-adapter-based resources
2025-05-03T13:54:43.086102Z DEBUG dsc_lib::discovery::command_discovery: 409: Found 0 matching non-adapter-based resources
2025-05-03T13:54:43.086281Z DEBUG dsc_lib::discovery::command_discovery: 656: Read 123 items into lookup table from "C:\\Users\\VssAdministrator\\AppData\\Local\\dsc\\AdaptedResourcesLookupTable.json"
2025-05-03T13:54:43.086315Z DEBUG dsc_lib::discovery::command_discovery: 586: Lookup table found resource 'sqlserverdsc/sqlrssetup' in adapter 'Microsoft.Windows/WindowsPowerShell'
2025-05-03T13:54:43.086402Z DEBUG dsc_lib::discovery::command_discovery: 257: Using regex ^Microsoft\.Windows/WindowsPowerShell$ as filter for adapter name
2025-05-03T13:54:43.086765Z DEBUG dsc_lib::discovery::command_discovery: 265: Using regex ^.*?$ as filter for resource name
2025-05-03T13:54:43.087284Z  INFO dsc_lib::discovery::command_discovery: 287: Enumerating resources for adapter 'Microsoft.Windows/WindowsPowerShell'
2025-05-03T13:54:43.087424Z DEBUG dsc_lib::dscresources::command_resource: 687: Invoking command 'powershell' with args Some(["-NoLogo", "-NonInteractive", "-NoProfile", "-ExecutionPolicy", "Bypass", "-Command", "./psDscAdapter/powershell.resource.ps1 List"])
2025-05-03T13:54:43.454937Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: PSVersion=5.1.17763.7240
2025-05-03T13:54:43.455440Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: PSPath=C:\Windows\System32\WindowsPowerShell\v1.0
2025-05-03T13:54:43.455991Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: PSModulePath=C:\\Modules\az_12.1.0;C:\Program Files\Microsoft SQL Server\130\Tools\PowerShell\Modules\;C:\Program Files\WindowsPowerShell\Modules;C:\Users\packer\Documents\WindowsPowerShell\Modules;C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;D:\a\1\s\output\builtModule;D:\a\1\s\output\RequiredModules
2025-05-03T13:54:43.460054Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: jsonInput=@{}
2025-05-03T13:54:43.806709Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: Reading from Get-DscResource cache file C:\Users\VssAdministrator\AppData\Local\dsc\WindowsPSAdapterCache.json
2025-05-03T13:54:43.918045Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: Checking cache for stale entries
2025-05-03T13:54:44.630957Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: Checking cache for stale PSModulePath
2025-05-03T13:54:44.717223Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: PSModulePath diff 'C:\Users\VssAdministrator\Documents\PowerShell\Modules\PSDSC C:\Users\VssAdministrator\Documents\PowerShell\Modules\PSDSC\1.2.3 C:\Program Files\PowerShell\7\Modules C:\Program Files\PowerShell\7\Modules\PowerShellGet\Modules C:\program files\powershell\7\Modules\CimCmdlets C:\program files\powershell\7\Modules\Microsoft.PowerShell.Archive C:\program files\powershell\7\Modules\Microsoft.PowerShell.Diagnostics C:\program files\powershell\7\Modules\Microsoft.PowerShell.Host C:\program files\powershell\7\Modules\Microsoft.PowerShell.Management C:\program files\powershell\7\Modules\Microsoft.PowerShell.PSResourceGet C:\program files\powershell\7\Modules\Microsoft.PowerShell.Security C:\program files\powershell\7\Modules\Microsoft.PowerShell.Utility C:\program files\powershell\7\Modules\Microsoft.WSMan.Management C:\program files\powershell\7\Modules\PackageManagement C:\program files\powershell\7\Modules\PowerShellGet C:\program files\powershell\7\Modules\PSDiagnostics C:\program files\powershell\7\Modules\PSReadLine C:\program files\powershell\7\Modules\ThreadJob C:\program files\powershell\7\Modules\Microsoft.PowerShell.Archive\en-US C:\program files\powershell\7\Modules\Microsoft.PowerShell.PSResourceGet\dependencies C:\program files\powershell\7\Modules\PackageManagement\coreclr C:\program files\powershell\7\Modules\PackageManagement\DSCResources C:\program files\powershell\7\Modules\PowerShellGet\DscResources C:\program files\powershell\7\Modules\PowerShellGet\en-US C:\program files\powershell\7\Modules\PowerShellGet\Modules C:\program files\powershell\7\Modules\PSReadLine\net462 C:\program files\powershell\7\Modules\PSReadLine\net6plus C:\Program Files\WindowsPowerShell\Modules\SqlServer C:\Program Files\WindowsPowerShell\Modules\SqlServer\22.2.0'
2025-05-03T13:54:44.718993Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: Constructing Get-DscResource cache
2025-05-03T13:55:18.460354Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 3376: Saving Get-DscResource cache to 'C:\Users\VssAdministrator\AppData\Local\dsc\WindowsPSAdapterCache.json'
2025-05-03T13:55:26.401392Z DEBUG dsc_lib::dscresources::command_resource: 648: Process 'powershell' id 3376 exited with code 0
2025-05-03T13:55:26.402252Z  INFO dsc_lib::discovery::command_discovery: 474: Resource 'PackageManagement/PackageManagement' has invalid version: unexpected character '.' after patch version number
2025-05-03T13:55:26.402287Z  INFO dsc_lib::discovery::command_discovery: 474: Resource 'PackageManagement/PackageManagementSource' has invalid version: unexpected character '.' after patch version number
2025-05-03T13:55:26.403016Z DEBUG dsc_lib::discovery::command_discovery: 342: Adapter 'Microsoft.Windows/WindowsPowerShell' listed 125 resources
2025-05-03T13:55:26.403463Z DEBUG dsc_lib::discovery::command_discovery: 656: Read 123 items into lookup table from "C:\\Users\\VssAdministrator\\AppData\\Local\\dsc\\AdaptedResourcesLookupTable.json"
2025-05-03T13:55:26.403882Z TRACE dsc::util: 456: Input: Some("{VersionUpgrade:true,Action:Install,AcceptLicensingTerms:true,InstanceName:PBIRS,LogPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PBIRS.log,InstallFolder:C:\\\\Program Files\\\\Microsoft Power BI Report Server,Edition:Developer,SuppressRestart:true,MediaPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PowerBIReportServer.exe}"), File: None
2025-05-03T13:55:26.403905Z DEBUG dsc::util: 458: Reading input from command line parameter
2025-05-03T13:55:26.404181Z DEBUG dsc::resource_command: 25: SqlServerDsc/SqlRSSetup implemented as Custom("ScriptBased")
2025-05-03T13:55:26.404244Z DEBUG dsc_lib::dscresources::dscresource: 193: Invoking get for 'Microsoft.Windows/WindowsPowerShell'
2025-05-03T13:55:26.404295Z DEBUG dsc_lib::dscresources::command_resource: 29: Invoking get for 'Microsoft.Windows/WindowsPowerShell'
2025-05-03T13:55:26.404316Z DEBUG dsc_lib::dscresources::command_resource: 753: Verify JSON for 'Microsoft.Windows/WindowsPowerShell'
2025-05-03T13:55:26.404323Z TRACE dsc_lib::dscresources::command_resource: 757: Validating against JSON: {"VersionUpgrade:true":null,"Action:Install":null,"AcceptLicensingTerms:true":null,"InstanceName:PBIRS":null,"LogPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PBIRS.log":null,"InstallFolder:C:\\\\Program Files\\\\Microsoft Power BI Report Server":null,"Edition:Developer":null,"SuppressRestart:true":null,"MediaPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PowerBIReportServer.exe":null,"adapted_dsc_type":"SqlServerDsc/SqlRSSetup"}
2025-05-03T13:55:26.404342Z TRACE dsc_lib::dscresources::command_resource: 420: Invoking validate on 'Microsoft.Windows/WindowsPowerShell' using '{"VersionUpgrade:true":null,"Action:Install":null,"AcceptLicensingTerms:true":null,"InstanceName:PBIRS":null,"LogPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PBIRS.log":null,"InstallFolder:C:\\\\Program Files\\\\Microsoft Power BI Report Server":null,"Edition:Developer":null,"SuppressRestart:true":null,"MediaPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PowerBIReportServer.exe":null,"adapted_dsc_type":"SqlServerDsc/SqlRSSetup"}'
2025-05-03T13:55:26.404353Z DEBUG dsc_lib::dscresources::command_resource: 740: No input kind specified
2025-05-03T13:55:26.404360Z  INFO dsc_lib::dscresources::command_resource: 429: Invoking validate on 'Microsoft.Windows/WindowsPowerShell' using 'powershell'
2025-05-03T13:55:26.404372Z DEBUG dsc_lib::dscresources::command_resource: 687: Invoking command 'powershell' with args Some(["-NoLogo", "-NonInteractive", "-NoProfile", "-ExecutionPolicy", "Bypass", "-Command", "$Input | ./psDscAdapter/powershell.resource.ps1 Validate"])
2025-05-03T13:55:26.778782Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 4212: PSVersion=5.1.17763.7240
2025-05-03T13:55:26.779316Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 4212: PSPath=C:\Windows\System32\WindowsPowerShell\v1.0
2025-05-03T13:55:26.779878Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 4212: PSModulePath=C:\\Modules\az_12.1.0;C:\Program Files\Microsoft SQL Server\130\Tools\PowerShell\Modules\;C:\Program Files\WindowsPowerShell\Modules;C:\Users\packer\Documents\WindowsPowerShell\Modules;C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;D:\a\1\s\output\builtModule;D:\a\1\s\output\RequiredModules
2025-05-03T13:55:26.814670Z DEBUG dsc_lib::dscresources::command_resource: 648: Process 'powershell' id 4212 exited with code 0
2025-05-03T13:55:26.815025Z DEBUG dsc_lib::dscresources::command_resource: 736: Parsing input as stdin
2025-05-03T13:55:26.815043Z  INFO dsc_lib::dscresources::command_resource: 40: Invoking get 'Microsoft.Windows/WindowsPowerShell' using 'powershell'
2025-05-03T13:55:26.815056Z DEBUG dsc_lib::dscresources::command_resource: 687: Invoking command 'powershell' with args Some(["-NoLogo", "-NonInteractive", "-NoProfile", "-ExecutionPolicy", "Bypass", "-Command", "$Input | ./psDscAdapter/powershell.resource.ps1 Get"])
2025-05-03T13:55:26.817244Z TRACE dsc_lib::dscresources::command_resource: 604: Writing to command STDIN: {"VersionUpgrade:true":null,"Action:Install":null,"AcceptLicensingTerms:true":null,"InstanceName:PBIRS":null,"LogPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PBIRS.log":null,"InstallFolder:C:\\\\Program Files\\\\Microsoft Power BI Report Server":null,"Edition:Developer":null,"SuppressRestart:true":null,"MediaPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PowerBIReportServer.exe":null,"adapted_dsc_type":"SqlServerDsc/SqlRSSetup"}
2025-05-03T13:55:27.178425Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PSVersion=5.1.17763.7240
2025-05-03T13:55:27.178925Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PSPath=C:\Windows\System32\WindowsPowerShell\v1.0
2025-05-03T13:55:27.179735Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PSModulePath=C:\\Modules\az_12.1.0;C:\Program Files\Microsoft SQL Server\130\Tools\PowerShell\Modules\;C:\Program Files\WindowsPowerShell\Modules;C:\Users\packer\Documents\WindowsPowerShell\Modules;C:\Users\VssAdministrator\Documents\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;D:\a\1\s\output\builtModule;D:\a\1\s\output\RequiredModules
2025-05-03T13:55:27.184053Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: jsonInput={"VersionUpgrade:true":null,"Action:Install":null,"AcceptLicensingTerms:true":null,"InstanceName:PBIRS":null,"LogPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PBIRS.log":null,"InstallFolder:C:\\\\Program Files\\\\Microsoft Power BI Report Server":null,"Edition:Developer":null,"SuppressRestart:true":null,"MediaPath:C:\\\\Users\\\\VssAdministrator\\\\AppData\\\\Local\\\\Temp\\\\PowerBIReportServer.exe":null,"adapted_dsc_type":"SqlServerDsc/SqlRSSetup"}
2025-05-03T13:55:27.569665Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: Reading from Get-DscResource cache file C:\Users\VssAdministrator\AppData\Local\dsc\WindowsPSAdapterCache.json
2025-05-03T13:55:27.680389Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: Checking cache for stale entries
2025-05-03T13:55:28.396807Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: Checking cache for stale PSModulePath
2025-05-03T13:55:28.499054Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PSModulePath diff ''
2025-05-03T13:55:28.523330Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: OS version: Microsoft Windows NT 10.0.17763.0
2025-05-03T13:55:28.525336Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PowerShell version: 5.1.17763.7240
2025-05-03T13:55:28.530189Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: PSDesiredStateConfiguration module version: 1.1
2025-05-03T13:55:28.562583Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: DSC resource implementation: ScriptBased
2025-05-03T13:55:29.613310Z TRACE dsc_lib::dscresources::command_resource: 890: PID 6428: The term 'Get-TargetResource' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.{"debug":"Module: SqlServerDsc, Name: SqlRSSetup, Property: System.Collections.Hashtable"}
2025-05-03T13:55:29.699405Z DEBUG dsc_lib::dscresources::command_resource: 880: PID 6428: 

Message                     : Cannot validate argument on parameter 'Property'. The argument is null, empty, or an 
                              element of the argument collection contains a null value. Supply a collection that does 
                              not contain any null values and then try the command again.
ParameterName               : Property
ParameterType               : System.Collections.Hashtable
TypeSpecified               : System.Collections.Hashtable
ErrorId                     : ParameterArgumentValidationError
Line                        : 371
Offset                      : 165
CommandInvocation           : System.Management.Automation.InvocationInfo
ErrorRecord                 : Cannot validate argument on parameter 'Property'. The argument is null, empty, or an 
                              element of the argument collection contains a null value. Supply a collection that does 
                              not contain any null values and then try the command again.
WasThrownFromThrowStatement : False
Data                        : {System.Management.Automation.Interpreter.InterpretedFrameInfo}
InnerException              : System.Management.Automation.ValidationMetadataException: The argument is null, empty, 
                              or an element of the argument collection contains a null value. Supply a collection that 
                              does not contain any null values and then try the command again.
                                 at System.Management.Automation.ValidateNotNullOrEmptyAttribute.Validate(Object 
                              arguments, EngineIntrinsics engineIntrinsics)
                                 at 
                              System.Management.Automation.ParameterBinderBase.BindParameter(CommandParameterInternal 
                              parameter, CompiledCommandParameter parameterMetadata, ParameterBindingFlags flags)
TargetSite                  : Void CheckActionPreference(System.Management.Automation.Language.FunctionContext, 
                              System.Exception)
StackTrace                  :    at 
                              System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext 
                              funcContext, Exception exception)
                                 at 
                              System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame 
                              frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(Interp
                              retedFrame frame)
                                 at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(Interp
                              retedFrame frame)
HelpLink                    : 
Source                      : System.Management.Automation
HResult                     : -2146233087




2025-05-03T13:55:29.700889Z ERROR dsc_lib::dscresources::command_resource: 874: PID 6428: Exception: Cannot validate argument on parameter 'Property'. The argument is null, empty, or an element of the argument collection contains a null value. Supply a collection that does not contain any null values and then try the command again.
2025-05-03T13:55:29.730645Z DEBUG dsc_lib::dscresources::command_resource: 648: Process 'powershell' id 6428 exited with code 1
2025-05-03T13:55:29.731120Z ERROR dsc::resource_command: 54: Error: Command: Resource 'powershell' [exit code 1] manifest description: Error

codecov · 2025-05-08T19:51:43Z

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 94%. Comparing base (f9eda7b) to head (737fc5b).
Report is 8 commits behind head on main.

Additional details and impacted files

@@         Coverage Diff          @@
##           main   #2102   +/-   ##
====================================
- Coverage    94%     94%   -1%     
====================================
  Files       105     106    +1     
  Lines      8114    8089   -25     
====================================
- Hits       7689    7650   -39     
- Misses      425     439   +14

Flag	Coverage Δ
unit	`94% <ø> (-1%)`	⬇️

🚀 New features to boost your workflow:

❄️ Test Analytics: Detect flaky tests, report on failures, and find test suite problems.

johlju added 13 commits May 2, 2025 18:39

Add integration test stage for DSCv3

321d786

Fix pipeline

3a85370

Test environment scope

38fe9ad

run stage directly

80f3bdf

Run stage after build

7e888c4

Test remembering env variable

7b694d9

set process env from user env

01c3fd6

Fix pipeline

87ba296

Output SqlServerDsc resources

8eb98d7

Add prereq to test

d8ac762

First try running get

5bf1430

try another way

018d4bd

yet another try

c8ed7d5

johlju added the waiting for author response The pull request is waiting for the author to respond to comments in the pull request. label May 3, 2025

johlju added 3 commits May 3, 2025 14:35

fix trace level

cb45e8b

Fix test fails on error

030a61f

change trace level

b006180

johlju added 7 commits May 8, 2025 17:46

Use latest preview

6f266da

Fix running in pwsh

4166d6a

Output json files

761c244

fix more debug output

e42ed6c

fix typo

4e98786

Fix test

d1311c3

Fix test

737fc5b

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Add integration test stage for DSCv3 #2102

Add integration test stage for DSCv3 #2102

johlju commented May 2, 2025 •

edited

Loading

johlju commented May 3, 2025

johlju commented May 8, 2025

codecov bot commented May 8, 2025 •

edited

Loading

Add integration test stage for DSCv3 #2102

Are you sure you want to change the base?

Add integration test stage for DSCv3 #2102

Conversation

johlju commented May 2, 2025 • edited Loading

Pull Request (PR) description

This Pull Request (PR) fixes the following issues

Task list

johlju commented May 3, 2025

johlju commented May 8, 2025

codecov bot commented May 8, 2025 • edited Loading

Codecov Report

johlju commented May 2, 2025 •

edited

Loading

codecov bot commented May 8, 2025 •

edited

Loading