000011550 - Cannot import database dump: 'Cannot drop nonexistent primary key supplemental logging'

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

Article Content

Article Number000011550
Applies ToRSA Authentication Manager 7.1
Restore
Import
Issue

Operation failed : com.rsa.common.UnexpectedDataStoreException: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [ALTER TABLE RSA_REP.IMS_PRINCIPAL_DATA DROP SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS]; SQL state [99999]; error code [32587];


rsautil manage-backups restore fails
Cannot restore database dump
Importing a database dump with the command "rsautil manage-backups -a import" fails with the following error message:

Reset the IMS console meta data
Operation failed : com.rsa.common.UnexpectedDataStoreException: org.springframew
ork.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLExceptio
n for SQL [ALTER TABLE RSA_REP.IMS_PRINCIPAL_DATA DROP SUPPLEMENTAL LOG DATA (PR
IMARY KEY) COLUMNS]; SQL state [99999]; error code [32587];
; nested exception is Cannot drop nonexistent primary key supplemental logging
Please see log file at c:\2\IMS_DB_IMPORT_<step>_<time_stamp>.log for more detail

CauseIf the database dump was taken after running the "rsautil setup-replication -a remove-primary" the generated database dump file will be incomplete.
ResolutionThe solution would be to generate a fresh database dump after running the command "rsautil setup-replication -a set-primary" on the source RSA Aauthentication Manager 7.1 primary then re-attempt the import process on the target RSA Authentication Manager 7.1 primary.
Legacy Article IDa50286

Attachments

    Outcomes