When upgraded to TDV version 8.5.0, you may encounter an issue where Search functionality in Web UI doesn't return any results.



This article explains how to resolve this issue. 

How to resolve the problem that the search feature does not work on the Web UI after upgrading to TIBCO Data Virtualization version 8.5.0 ?

All supported Operating Systems

To resolve the search functionality issue, we need to execute the below commands on TDV repository.

Following are the steps to be followed:

1)Stop the TDV Server process only. You do not need to stop the TDV repository or TDV cache 
------------------------------
composite.bat monitor stop
------------------------------
2)Open a command prompt and navigate to the TDV Repository installation folder located at [TDV_Install_Dir]\repository\bin.

3)Execute the below commands:
 

 psql.exe -h localhost -p %REPO_PORT% -d template1  -U root -c "create extension fuzzystrmatch" psql.exe -h localhost -p %REPO_PORT% -d cisrepo -U root -c "create extension fuzzystrmatch" psql.exe -h localhost -p  %REPO_PORT% -d template1 -U root -c "CREATE OR REPLACE FUNCTION get_unique_words(text) RETURNS text AS $$ SELECT array_to_string(ARRAY(SELECT DISTINCT trim(x) FROM unnest(string_to_array($1,' ')) x),' ') $$ LANGUAGE sql IMMUTABLE" psql.exe -h localhost -p  %REPO_PORT% -d cisrepo -U root -c "CREATE OR REPLACE FUNCTION get_unique_words(text) RETURNS text AS $$ SELECT array_to_string(ARRAY(SELECT DISTINCT trim(x) FROM unnest(string_to_array($1,' ')) x),' ') $$ LANGUAGE sql IMMUTABLE"

Note: %REPO_PORT% : TDV Base port + 8

Here is an example command for your reference: 
 

 psql.exe -h localhost -p 9408 -d template1  -U root -c "create extension fuzzystrmatch"

Please enter the 'root' password chosen during TDV installation when prompted for a password.

4)Start TDV server process.
------------------------------
composite.bat monitor start
------------------------------
5)Open Web UI and test the search functionality.