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

5 months ago

Originally Published: 2014-10-27

Article Number

000057052

Applies To

RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition: 7.x, 8.0.0

Issue

An 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
$

Cause

Prior 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.

Resolution

Try the import again. This error only occurs once. Subsequent attempts will succeed without error.

Don't see what you're looking for?

Related Articles

Trending Articles