T59-2020 Foundation Display of History Data with Oracle RAC

Program

BIOVIA Foundation when used with Oracle Database Real Application Clusters (RAC)

Description

The BIOVIA Foundation Audit History pages display each object’s audit history events, such as date-time, actor, and old/new values. BIOVIA Foundation customers using Oracle RAC with two or more active nodes may experience one or both of the following issues when viewing audit history content:

Events may not display in chronological order by default.
Some events erroneously include new value entries for values that did not change.

These behaviors can occur when Oracle sequences cache differently on multiple active RAC nodes, which may cause recorded audit history transaction IDs to increment out of numerical order when sorted chronologically.

Operating System

All Operating Systems supported for BIOVIA Foundation

Error Message

None

Resolution

Customers may alter the audit history sequence caching behavior for Oracle RAC environments by connecting to the Hub schema with a SQL client application and executing the following statement:

alter sequence hibernate_sequence order;

After applying this change to the Oracle sequence, Oracle will align the sequence cache across all active RAC nodes, and new audit history events will not exhibit the symptoms outlined in the description section above.