Chemical Registration users might often try to refresh their DEV/TEST environment from PRODUCTION and likely to use Oracle data pump export/import utility for this activity. Sometimes this process will involve refreshing the BIOVIA Direct schema (owner C\$DIRECTXX) too and care should be taken to modify the configuration files to ensure proper database connection.

One of the issues that they might encounter during export/import is in the processing of domain index, CRS_CHEMISTRYDATA_IDX and it could fail with an error shown below:

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX

ORA-39083: Object type INDEX:"CHEMREG"."CRS_CHEMISTRYDATA_IDX" failed to create with error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-02019: connection description for remote database not found

If they try to drop and recreate the domain index, that could also fail with the same ORA-02019 error.

The error points to a missing Database link or incorrect DBlink name being used. Users should first check and confirm that the database link is present and also valid.

BIOVIA Direct Installation Guide shows the following information under "Modify the Oracle Configuration Files":

To configure a separate EXTPROC listener Oracle, the definition of a public database link and a reference to that link in the library definition of the cartridge is required. Both requirements are already implemented in the installation SQL files provided with Direct.

mkdirect.sql --> SQL used to create the cartridge user and public database link.
mdllibdef.sql --> Contains the path to mdldirect.dll and is used to create the shared object library that uses the public database link.

This issue will most likely be resolved if the correct database link information is used in the configuration files. If not, users are advised to contact BIOVIA Support for further help.