000028218 - AVUSER backup export script fails error ORA-31626 using RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Sep 1, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028218
Applies ToRSA Product Set:  Identity Governance and Lifecycle
RSA Version: All Versions
IssueAfter a failed attempt to backup, a new backup fails with the following errors: 
ORA-31626: job does not exist 
ORA-31633: unable to create master table "AVUSER.AVDB_EXPORT_AVUSER"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 863
ORA-00955: name is already used by an existing object

 
CauseThis error is usually due to a previous failed export, when running the export script.  A successful export deletes the temporary table AVDB_EXPORT_AVUSER.  This temporary table may still exist on a failed export.  If this table exists when the script is executed, this will  result in the Oracle errors noted above.
ResolutionThere are two preferred options to correct this error, by either removing or renaming this temporary table.  Both will work, but removing the table is a better option, as this more closely follows correct successful behavior of the export script.
Login to the AVDB ACM database as AVUSER, using a tool such as SQL*Plus or SQL Developer and run the following SQL command to drop the temporary AVDB_EXPORT_AVUSER table that the export script creates.  After this command is executed, repeat the export.
$ sqlplus avuser/secret
SQL> DROP TABLE AVDB_EXPORT_AVUSER ; 
SQL> exit


 

WorkaroundAlternatively, the error can also be bypassed commenting a line in the export file Export_AVDB_avuser.sh.   Creating a backup of the original file is always recommended before any edits are done. 
Once a successful backup is run, this temporary edit is no longer necessary and the original file can be restored. 
Logged in as the Unix oracle user, execute the steps below:
  1. Change directory to /home/oracle/database/DBA/AVDB/scripts
cd /home/oracle/database/DBA/AVDB/scripts

  1. Create backup of the file to be edited:   
cp Export_AVDB_avuser.sh  Export_AVDB_avuser.org

  1. Edit file named Export_AVDB_avuser.sh and comment out the line shown below by locating and adding a # in column 1.  Change:
echo Job_Name=${EXP_JOB_NAME}        >> ${EXP_PAR_FILE}

to 

 

 

#echo Job_Name=${EXP_JOB_NAME}        >> ${EXP_PAR_FILE}

  1. Repeat the export.
Notes
  • The example shown in the Resolution section of this article makes use of SQL*Plus. 
  • The password shown is the default. If this password is different on the system in question, use the appropriate password for the AVUSER account.

Attachments

    Outcomes