es_ebl occupies all db sessions

Document ID : KB000092748
Last Modified Date : 23/04/2018
Show Technical Document Details
Introduction:
Elastic Search consume all database sessions
Question:
After installing Option "xflow_installed" and restarting all servers, we encountered the following:
The Search Deamon (es_ebl) consumes a lot of db connections , obviously without limitation
Our current limitation of concurrent sessions in oracle is set to 500.
this is hit by our servers because of the huge amount of connections per server(> 150 each)
 
Environment:
Service Desk 17.0 on Linux
Answer:
execute at the command line
pdm_options_mgr -s ES_DB_SUPPORT -v off -a pdm_option.inst
pdm_options_mgr -s ES_DB_SUPPORT -v off -a pdm_option.inst -t

These command create @NX_ES_DB_SUPPORT=off in NX.env and tpl

With the variable set as per above, data is directly sent to elastic search instead of dumping it in a table in database and then moving this data from DB to elastic search.