Venio Console: Unable to connect to the search server

The Problem

When ever I try to add a new project. I get the following error: "Could not load default search server for this project. This may be due to registered search server entry was deleted from Administration>Configure Server>Search Server. Please contact administrator."

Resolution

This issue is occurs when the Search Server is not set in the project or the project template. This can also be checked by running the following queries in VenioPCD:

select * from search serverinfo
select SSID, * from tbl_pj_projectsetup 
where projectid = <project id for that project>

The SSID should match.

In order to fix the template, please navigate to 

Process>>New>>Edit Project template>>Select your template and load it

Then on step 24 please set your search server and update the template.

In order to fix the project, run the following query in VenioPCD

update tbl_pj_projectsetup
set SSID=<SSID> --obtained from tbl_pj_Searchserverinfo
where projectid= <projectid>