Windows Server 2025: The property 'Statement' cannot be found on this object. Verify that the property exists.

[PHPirates]

Describe the bug

If we try to upgrade from Windows Server 2022 to 2025, which updates Windows PowerShell from 5.1.20348.3932 to 5.1.26100.4768, then we get the following error:

Starting: Validate ADF files: "Validate all" from ADF
==============================================================================
Task         : Build Azure Data Factory code
Description  : Validates all JSON files of ADF (v2) (adftools)
Version      : 1.35.1778
Author       : Kamil Nowinski (AzurePlayer)
Help         : [More Information](https://github.com/Azure-Player/azure.datafactory.devops)
==============================================================================
PowerShell: 5.1.26100.4768 Desktop
Invoking Test-AdfCode (https://github.com/SQLPlayer/azure.datafactory.tools) with the following parameters:
RootFolder:         D:\a\1\s\data-factory
Action:             Export
ConfigFolder:       D:\a\1\s
=== Preparing package.json file...
=== File 'package.json' created.
=== Check NPM Version...
##[error]The property 'Statement' cannot be found on this object. Verify that the property exists.
Finishing: Validate ADF files: "Validate all" from ADF

To Reproduce
We are using SQLPlayer.DataFactoryTools.BuildADF.BuildADFTask@1 in an Azure DevOps pipeline.

Expected behaviour
Windows Server 2022 works fine.

Version of PowerShell module of:
Windows PowerShell 5.1.26100.4768

[NowinskiK]

Debug-level details of the error

Invoking Test-AdfCode (https://github.com/SQLPlayer/azure.datafactory.tools) with the following parameters:
RootFolder:         D:\a\1\s\adf-repo
Action:             Export
ConfigFolder:       D:\a\1\s
=== Preparing package.json file...
=== File 'package.json' created.
=== Check NPM Version...
##[debug]Agent environment resources - Disk: D:\ Available 74771.03 MB out of 76798.00 MB, Memory: Used 2606.00 MB out of 8191.00 MB, CPU: Usage 8.00%
##[debug]Leaving D:\a\_tasks\BuildADFTask_8a00f62d-c46d-4019-9e11-c05d88821db8\1.35.1778\BuildADF.ps1.
##[debug]Caught exception from task script.
##[debug]Error record:
##[debug]Export-AdfToArmTemplate : The property 'Statement' cannot be found on this object. Verify that the property exists.
##[debug]At D:\a\_tasks\BuildADFTask_8a00f62d-c46d-4019-9e11-c05d88821db8\1.35.1778\BuildADF.ps1:62 char:9
##[debug]+         Export-AdfToArmTemplate -RootFolder $RootFolder `
##[debug]+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
##[debug]    + CategoryInfo          : NotSpecified: (:) [Export-AdfToArmTemplate], PropertyNotFoundException
##[debug]    + FullyQualifiedErrorId : PropertyNotFoundStrict,Export-AdfToArmTemplate
##[debug] 
##[debug]Script stack trace:
##[debug]at <ScriptBlock>, C:\Program Files\nodejs\npm.ps1: line 30
##[debug]at Export-AdfToArmTemplate, D:\a\_tasks\BuildADFTask_8a00f62d-c46d-4019-9e11-c05d88821db8\1.35.1778\ps_modules\azure.datafactory.tools\public\Export-AdfToArmTemplate.ps1: line 33
##[debug]at <ScriptBlock>, D:\a\_tasks\BuildADFTask_8a00f62d-c46d-4019-9e11-c05d88821db8\1.35.1778\BuildADF.ps1: line 62
##[debug]at <ScriptBlock>, <No file>: line 1
##[debug]at <ScriptBlock>, <No file>: line 22
##[debug]at <ScriptBlock>, <No file>: line 18
##[debug]at <ScriptBlock>, <No file>: line 1
##[debug]Exception:
##[debug]System.Management.Automation.PropertyNotFoundException: The property 'Statement' cannot be found on this object. Verify that the property exists.
##[debug]   at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
##[debug]   at System.Management.Automation.Interpreter.ActionCallInstruction`2.Run(InterpretedFrame frame)
##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
##[debug]   at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame)
##[debug]   at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame)
##[debug]   at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0)
##[debug]   at System.Management.Automation.PSScriptCmdlet.RunClause(Action`1 clause, Object dollarUnderbar, Object inputToProcess)
##[debug]   at System.Management.Automation.PSScriptCmdlet.DoEndProcessing()
##[debug]   at System.Management.Automation.CommandProcessorBase.Complete()
##[error]The property 'Statement' cannot be found on this object. Verify that the property exists.
##[debug]Processed: ##vso[task.logissue type=error]The property 'Statement' cannot be found on this object. Verify that the property exists.
##[debug]Processed: ##vso[task.complete result=Failed]

[NowinskiK]

The issue is with PowerShell: 5.1.26100.6899 Desktop also.

NPM Version Differences:

• Windows Server 2022: Uses older NPM version that works with PowerShell 5.1.20348.3932
• Windows Server 2025: Uses newer NPM version that has compatibility issues with PowerShell 5.1.26100.4768