After upgrading Portal v4.6.56 to v4.8.21, database 'datasource' parameters for both Integrated Security and SQL Authentication existed in the application.properties conf file. This caused fields with functions using execsql to fail validations in the Portal.
As a work around, the issue can be fixed by commenting out the SQL Authentication database 'datasource' parameters in the application.properties conf file.
Release : 4.8
Component : CA Test Data Manager - TDM Web Portal
This is resolved by TDMWeb-4.8.27.0.zip. Both the Validation and Publishing issues are resolved. Verified the 2017 and 2018 Generators. Publishing data is much faster than with v4.6.
Please contact BC Support to get this version or later. Please note that if you are installing a GA Version after June 24, 2019, please contact BC Support to verify this version made it into the GA Version you are going to install.