000023060 - A few tips for export/import database

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 Number000023060
Applies ToAA On-Prem version 5.7.x
Oracle database
IssueReliable database recovery

Problem 1: After export/import database, received "unique constraint" error in pmw_server.log, and user could not login:

com.passmarksecurity.PassMarkException: ORA-00001: unique constraint
(PMSC.PK_DESKTOPS) violated
ORA-06512: at "PMSC.INSERTDEVICE4", line 43
ORA-06512: at line 1


Problem 2: After export/import database, received following error in pmw_server.log:

2007-04-16 13:26:18,961 ERROR [Servlet.Engine.Transports : 6] [] [] [com.passmarksecurity.dao.sp.GroupsStoredProcBase]
<Caught SQL exception: OrgsStoredProcBase.getOrgAndParentHeirarchy(DiscoverCard
Throwing PassMark DatabaseExceptio
java.sql.SQLException: ORA-06550: line 1, column 1
PLS-00201: identifier 'GETORGANDPARENT' must be declar
ORA-06550: line 1, column
PL/SQL: Statement ignored

CauseProblem 1: The "unique constraint" violation on primary keys is caused by the sequence ID was off during importing of the database

Problem 2: The 'GETORGANDPARENT' must be declared error is caused by permission was not exported when exporting the database
ResolutionProblem 1: Make sure the sequence Id  in new DB was set higher than the old DB.
Problem 2: Check export permissions before exporting database.
Legacy Article IDa35214

Attachments

    Outcomes