Usually, the validate seems like it only executes/validates the actual path for the @if statement. However, we have a @round which wraps an @execsql that we only want to execute when true because otherwise there should be ~NOVALUE~ and the database returns null for this field when the @if is false. The validate is always executing the SQL and the @round and randomly fails to validate when it shouldn't even be triggering based on the variable in the @if
TdmWeb-22.214.171.124.zip resolves the issue. Please contact CA Support for this version or later. If you are installing a GA version after July 24, please contact CA Support to verify that this fix has been incorporated into that GA version.