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/
