Domain indexes created with BIOVIA Direct 2021 require an upgrade after you upgraded to BIOVIA Direct 2021 SP1

When you have created a BIOVIA Direct domain index with Direct version 2021, and you have upgraded your Direct version to 2021 SP1, you need to upgrade the domain index to the newer Direct version. Otherwise, Oracle will consider the existing index as invalid and will not use it in Direct chemistry searches. To upgrade the indexes please follow the steps below.

1) Confirm that the index version is 21.1.0.513 ( = build version of Direct 2021). To do so run the following command on each domain index you want to check:

SELECT mdlaux.indexparameters('my_domain_index_name') FROM DUAL;

The output should at least include the following:

Molecule index MY_DOMAIN_INDEX_NAME version 21.1.0.513


2) Make sure that your Oracle account is enabled for Direct 2021 SP1:

SELECT mdlaux.version FROM DUAL;

This command should return version 21.1.100.9 ( = build number of Direct 2021 SP1). If the command returns an older version of Direct, or if the command does not run at all, the Oracle account is not enabled for Direct 2021 SP1. In this case run the following command to enable the Oracle account for Direct 2021 SP1:

EXECUTE c\$direct2021.mdlauxop.setup;


3) Update the Direct 2021 domain indexes in the Oracle schema to version 2021 SP1 by running the following two commands:

SELECT mdlaux.upgradeindexes_prepare FROM DUAL;
SELECT mdlaux.upgradeindexes_upgrade FROM DUAL;

These commands typically execute in less than a minute.


4) Confirm that the index is now at version Direct 2021 SP1:

SELECT mdlaux.indexparameters('my_domain_index_name') FROM DUAL;

The output should at least include the following:

Molecule index MY_DOMAIN_INDEX_NAME version 21.1.100.9 (created with 21.1.0.513)


Please note again that this post is specifically on the upgrade of domain indexes from BIOVIA Direct 2021 to 2021 SP1. Upgrades from other versions of BIOVIA Direct might require additional modifications as outlined in the BIOVIA Direct 2021 SP1 Administration Guide.