Is your feature request related to a problem? Please describe.
The BIServer loses the MySQL connection to the DB after 8 hours. We need to keep this connection alive of dashboards / reports fail to run
Describe the solution you'd like
A transformation that simply executes a small select against the database. We can then schedule this to run every 6 hours
Describe alternatives you've considered
Restarting the server every 6 hours
Attempt to configure c3p0
Is your feature request related to a problem? Please describe. The BIServer loses the MySQL connection to the DB after 8 hours. We need to keep this connection alive of dashboards / reports fail to run
Describe the solution you'd like A transformation that simply executes a small select against the database. We can then schedule this to run every 6 hours
Describe alternatives you've considered Restarting the server every 6 hours Attempt to configure c3p0