Hub Performance Fix: Task Plan button takes awhile to load

There is currently a known issue with hub when opening the Tasks tab in Foundation Task Plan. The issue is when clicking on the tab it can take several seconds for the buttons to load in. This cause the rest of the page to load in slowly.

This can be fixed by adding oracle optimizer settings in the Hub app-config.groovy file. Open it in note pad and add the following after the line  "dbCreate = '' // Do not want standard Hibernate schema population"

properties {

                jmxEnabled = true

                initialSize = 5

                initSQL = 'alter session set OPTIMIZER_FEATURES_ENABLE="12.1.0.2"'

                minIdle = 5

                maxIdle = 25

                maxWait = 10000

                maxAge = 10 * 60000

                timeBetweenEvictionRunsMillis = 5000

                minEvictableIdleTimeMillis = 60000

                validationQueryTimeout = 3

                validationInterval = 15000

                testOnBorrow = true

                testWhileIdle = true

                testOnReturn = false

                jdbcInterceptors = 'ConnectionState'

                defaultTransactionIsolation = java.sql.Connection.TRANSACTION_READ_COMMITTED

                validationQuery = 's elect 1 from dual'

                maxActive = 50

            }

}

Once this has been added save the file and restart Hub services. More detailed notes can be found here https://www.3ds.com/support/news/single/t64-2022-bioviaR-foundation-hub-2022-sp1-task-action-buttons-takes-time-to-load-in-task-plan-section/