000027866 - Import error: 'ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist' when importing RSA Identity Governance & Lifecycle database schema

Document created by RSA Customer Support Employee on Jun 15, 2016Last modified by RSA Customer Support on Apr 15, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000027866
Applies ToRSA Product Set:  Identity Governance & Lifecycle
RSA Version/Condition: All
 
IssueWhen importing an RSA Identity Governance & Lifecycle database backup, using the RSA Identity Governance & Lifecycle database import script /home/oracle/database/DBA/AVDB/scripts/AVDB_Import_AVUSER.sh, the following errors are seen, yet the import succeeds.
 
"ORA-39083: Object type TABLE:"AVUSER"."STX_RES_27_61996" failed to create with error:
"ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist"


These error messages are seen in the terminal output and in the import log file located in /home/oracle/AveksaExportImportDir/Import_AVDB_avuser.log



 



These same Oracle errors may repeat several times for different tables most of which are prefixed with STX.  For example, 




Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option
Master table "AVUSER"."AVDB_IMPORT_AVUSER" successfully loaded/unloaded
Starting "AVUSER"."AVDB_IMPORT_AVUSER":  avuser/********@AVDB parfile=/home/oracle/database/DBA/AVDB/export/Import_AVDB_avuser.par
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39083: Object type TABLE:"AVUSER"."STX_RES_27_61996" failed to create with error:
ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist

Failing sql is:
CREATE TABLE "AVUSER"."STX_RES_27_61996" ("APPLICATION_REF" VARCHAR2(256 BYTE), "FULLY_QUALIFIED_NAME" VARCHAR2(256 BYTE), "NAME" VARCHAR2(256 BYTE), "OBJECT_REF" VARCHAR2(256 BYTE), "OWNER_NAME" VARCHAR2(256 BYTE), "OWNER_TYPE" VARCHAR2(5 BYTE), "CAD1" VARCHAR2(50 BYTE), "CAD2" VARCHAR2(50 BYTE), "CAD3" VARCHAR2(50 BYTE), "CAD4" VARCHAR2(50 BYTE), "C
ORA-39083: Object type TABLE:"AVUSER"."STX_ENT_27_61996" failed to create with error:
ORA-06564: object AVEKSA_DATA_DIRECTORY does not exist

CauseRSA Identity Governance & Lifecycle 6.5.x and later no longer uses an AVEKSA_DATA_DIRECTORY directory. These errors occur when importing a database schema from a version of RSA Identity Governance&  Lifecycle prior to 6.5.x into a version later than 6.5.x.
Resolution

These are benign errors and may be safely ignored. Install 6.9.1 or above to prevent these errors in the future.

Notes The log may contain other errors that are not benign, so please check the log carefully to make sure the import succeeded.
 
Legacy Article IDa66701

Attachments

    Outcomes