# 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''

or

“\_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.

![Dassault Système BIOVIA Foundation Hub V2022V1](https://www.3ds.com/assets/invest/inline-images/image_116.png)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](https://www.3ds.com/support/).

Need Assistance?

Our support team is here to help you make the most of our software. Whether you have a question, encounter an issue, or need guidance, we've got your back.

[Contact support](/support/contact-your-support-center)

[Submit a request via 3DSupport App](https://dspart004-eu1-partners-ifwe.3dexperience.3ds.com/#dashboard:0b021cdc-9e58-47c3-8527-3d2314c48683/tab:3DSupport)