Configure Timeout Settings for Database Connection in Yellowfin BI

Configure Timeout Settings for Database Connection in Yellowfin BI

Usually timeout session error occurred when user session open long time & is then application close.

There are 3 timeout configuration options to consider;

1) Connection to Data source
2) Connection to the Yellowfin DB
3) Timeout setting on your Source instance (Out of scope Yellowfin).

Connection to Data Source:

Go to Administration -> Admin Console -> Data Source -> Connection (select data source)

Change Timeout Count: By default it is 180 seconds (3 min) & now changed to 480 seconds (8 min). You can change more than these seconds.

Connection to the Yellowfin DB:

Change the settings of yellowfin application file. The file is found in <Yellowfin directory>/appserver/webapps/ROOT/WEB-INF/web.xml.

Add following code:

<init-param>
<param-name>JDBCTimeout</param-name>
<param-value>1800</param-value>
</init-param>

Example:

Note: Prior to doing this activity please take backup of file.