000038734 - Database backups from the user interface gets stuck 'In Progress', never finish, and prevent future backups in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Apr 15, 2020Last modified by RSA Customer Support Employee on Apr 15, 2020
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000038734
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: 7.0.0, 7.0.1, 7.0.2
IssueWhen scheduling database backups from the RSA Identity Governance & Lifecycle user interface (Admin > System > Backup tab),sometimes a backup gets stuck In Progress and never finishes. No more backups can run until the stuck backup completes.
User-added image

From the command line, the ps command shows a backup job still running:

oracle  29676 36554  0 Mar05 ?    00:00:00 /bin/bash /home/oracle/database/DBA/AVDB/scripts/AVDB_Export_AVUSER.sh -t 2020-03-5

CauseThis is a known issue reported in engineering ticket ACM-58925.
ResolutionThis issue is resolved in the following RSA Identity Governance & Lifecycle versions and patch levels:
  • RSA Identity Governance & Lifecycle 7.0.2 P04
  • RSA Identity Governance & Lifecycle 7.1.0

WorkaroundTo stop the failed backup, restart the application and database server. Login as the oracle user and execute the following commands:

acm stop
acm stopdb
acm startdb
acm start

To clear the In Progress status in the user interface, a good backup should be completed from the command line. For more information on backing up the RSA Identity Governance & Lifecycle database, see RSA Knowledge Base Article 000038174 -- How to perform a database backup (export) and a database restore (import) in RSA Identity Governance & Lifecycle.
Execute the following backup commands as the oracle user.


acm stop
cd /home/oracle/database/DBA/AVDB/scripts
./AVDB_Export_AVUSER.sh -t <optional tag on the filename>


acm stop
avdbexport -t <optional tag on the filename>

For example, the following commands will create a backup file called Export_AVDB_avuser_040120.dmp in the $AVEKSA_HOME/AveksaExportImportDir directory

acm stop
avdbexport -t _040120