000028940 - 'Error killing sessions for data import' error importing a database in RSA Identity Governance & Lifecycle

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

Article Content

Article Number000028940
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
 
IssueAn attempt to import a database (restore from a backup) results in the following error:
 

=============================================================================
Starting Import Process
=========================================================================
Step 1
Dropping and ReCreating the avuser user ...
Thu Apr 30 08:59:34 EDT 2020

Dropping User ...
- Error killing sessions for data import
Error killing sessions for data import
$


 
CausePrior to the import, a previous import was attempted and a Ctrl+C (^C) was executed sometime during the import of the database. A Ctrl+C is allowed up to 30 seconds into an import as evidenced by this message seen at the beginning of the import:
 
=========================================================================
***                                                                                                                                                 ***
***                                                                                                                                                 ***
***   WARNING !!!!   Database User avuser will be DELETED !!!                                                ***
***                                                                                                                                                 ***
***   Enter ^C with 30 seconds to cancel ...                                                                                  ***
***                                                                                                                                                 ***
***                                                                                                                                                 ***
***   Also ensure that the server process is not running and that there                                        ***
***   are no outstanding/remote database connections open through user                                  ***
***   avuser                                                                                                                                   ***
***                                                                                                                                                 ***
=========================================================================

 

However, once 30 seconds has passed, aborting the backup could have unexpected results such as the error reported in this RSA Knowledge Base Article.
 
ResolutionTry the import again. This error only occurs once. Subsequent attempts will succeed without error.
 

Attachments

    Outcomes