BIOVIA recently discovered that the creation of a BIOVIA Direct chemistry index may fail with a particular type of structures. The problem will manifest as a hang of the underlying extproc process with a high share of CPU time in that process, or as a crash of the index creation process with an Oracle error 'ORA-28579: network error during callback from external procedure agent'. The following image shows a few examples of impacted structures to illustrate the type of structures.
The common denominator of the structure is the two fused rings with a polymer bracket, the failure depends on the substitution scheme of this core.
The problem occurs specifically in the calculation of the FASTSEARCH index data which mainly enhance the search performance in substructure searches. Accordingly, the last line in the log table of the domain index,
SQL> SELECT id,msg FROM my_table_mdlix_log ORDER BY id DESC FETCH FIRST 1 ROW ONLY; ID MSG --- ------------------------------ 9 Merging final FASTSEARCH data
Be aware that the chemistry index exists after the failure, but is invalid and should be dropped:
SQL> SELECT index_name, ityp_owner, table_owner, status, domidx_status,domidx_opstatus FROM user_indexes WHERE index_name = 'MY_TABLE_MDLIX'; INDEX_NAME ITYP_OWNER TABLE_OWNER STATUS DOMIDX_STATUS DOMIDX_OPSTATUS ---------------- ------------- ------------ ------- -------------- ---------------- MY_TABLE_MDLIX C\$DIRECT2023 DIRECT2023 VALID VALID FAILED
BIOVIA is currently investigating this issue. While this type of structure is rare, we do not have a workaround for this issue at this point in time. If you run into this problem, please open a ticket with BIOVIA Support.
