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
TDM 4.5 Portal
TdmWeb-220.127.116.11.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.
Video URL on how to open a Support Case - https://communities.ca.com/videos/5898-demo-how-to-open-a-support-case
You can download the latest version of TDM by following the directions in this document: https://support.ca.com/us/knowledge-base-articles.TEC1903942.html.
To contact support, go to https://www.ca.com/us/services-support/ca-support/contact-support.html.