T64-2022 BIOVIA® Foundation Hub 2022 SP1: Task Action buttons takes time to load in Task Plan section

Program

BIOVIA® Foundation Hub

Operating Systems

Operating Systems supported by BIOVIA® Foundation Hub

See the System Requirements documents for details

Background

This technical note is to inform all BIOVIA Foundation Hub (v2022 SP1) customers regarding a known issue where task action buttons takes more time (10–15 seconds) to load under a task plan section.

This is affecting to all BIOVIA Foundation Hub customers with Oracle 19c Database release 7 or higher where the application SQL performance degrade due to a known Oracle bug#33649782 where database Optimizer feature impact query execution time when table access FULL FOR “OR” SQL queries.

Workaround

Oracle suggest changing the Optimizer feature as an workaround like

OPTIMIZER_FEATURES_ENABLE=''12.1.0.2''

“_OPTIMIZER_CBQT_OR_EXPANSION”=OFF

To implement this workaround please follow the steps below.

1. Take a backup of app-config.groovy file (which can be found in Foundation Hub server install directory for example C:\Program Files\BIOVIA\Foundation\Hub\onf)

2. Modify app-config.groovy file to add additional parameters to the datasource properties.

dataSource {

url = 'jdbc:oracle:thin:@//oracle_db:1525/oracle_db'

driverClassName = 'oracle.jdbc.driver.OracleDriver'

username = 'HUB'

password = 'AABQweN6wztTHRueLPQTRx+PbTcWABowZM6xy+7iw6VI0v1PAD8lgVt68diYZ0AGKXUTD5kFGZnYVJGEJzUmOW6W'

passwordEncryptionCodec = 'com.accelrys.platform.utils.DatasourceCodec'

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

                // For non-Oracle database use 's elect 1' and for Oracle use 's elect 1 from dual'

validationQuery = 's elect 1 from dual'

maxActive = 50

}

3. Restart Foundation Hub Service after the config file change.

4. If Foundation Hub is load balanced, please repeat the steps 1-3 each load balanced foundation Hub server.

Solution

BIOVIA R&D team is investigating this issue for a possible solution with DAT-23691.

How to contact BIOVIA Support

If you have any questions, please contact BIOVIA Support.