|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version: All Versions
|Issue||After a failed attempt to backup, a new backup fails with the following errors: |
Alternatively, the errors below may display.
|Cause||This error is usually due to a previous failed export, when running the export script either from the UI or from the command line. A successful export deletes the temporary tables AVDB_EXPORT_AVUSER and/or AVDB_EXPORT_AVUSER.job. These temporary tables may still exist on a failed export. If either of these tables exist when the script is executed, this will result in the Oracle errors or stack trace noted above.|
|Resolution||There 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. In some versions you may also have an AVDB_EXPORT_AVUSER.job table that will also need to be dropped. After these commands are executed, repeat the export.
|Workaround||Alternatively, prior to version 7.0.0, 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.
Execute the steps below while logged in as the Unix oracle user.