TDM Portal - The search tables does not work in the Generator Publish screen when gtrep repository is running on an Oracle schema

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

In the publish screen of the TDM portal, when I enter a table name in the search field "Search Table Names" and click on the magnifying glass, nothing happens. No action is done.

Tested on the portal with version 4.9.361 and 4.9.383

Environment

Release : 4.9.1

Component : Web Portal - Publishing

Cause

Looking at the TDMGeneratorService.log, the following error is seen:

[ERROR] [https-openssl-nio-8443-exec-9] --- [U:dwk5989][M:GET][P:/api/ca/v1/generators/xxxx/publishInfo]              c.c.t.c.e.h.GlobalExceptionConvertor:  HTTP Error - INTERNAL SERVER ERROR: Exception: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
oracle.jdbc.OracleDatabaseException: ORA-00923: FROM keyword not found where expected

 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)

Resolution

Resolved in TDMWeb-4.9.401.0 available at below location:

https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649