When we use Azure DevOps pipeline, sometime it doesn’t call the correct connection string and variable values don’t get updated correctly.
and it shows the below warning message:
Resource file haven’t been set, can’t find loc string for key: JSONvariableSubstitution
Issue is basically seen because of recent File transform task v1.108 which is failing to operate properly and throwing the warning message ‘Resource file haven’t been set, can’t find loc string for key: JSONvariableSubstitution’.
There isn’t much you can do as of now except to wait till Azure technical team fix the issue and release the stable version.
Meantime as a temporary fix, downgrade the FileTransform to version 1.206.0 and manually clear FileTransform 1.208.0 files.
To fix the error, downgrade the FileTransform to version 1.206.0 using command ‘FileTransform@1.206.0’, manually delete the _work/_tasks/FileTransform…/1.208.0 folder and files, and clear the XML Transformation rules.
Issue has been filed and tracked on Azure developer community, you can track down the issue here for recent update.