Oracle database
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
Problem 2: The 'GETORGANDPARENT' must be declared error is caused by permission was not exported when exporting the database
Problem 2: Check export permissions before exporting database.
Related Articles
A few questions on generating weekly and monthly reports Number of Views [XrcXUDADUNABLE]: unable to contact directory server Number of Views In RSA Identity Governance & Lifecycle, the change request manual activity assignment link (Assign to Specific Group or Ro… Number of Views Mapping Accounts to Deleted Users in RSA Identity Lifecycle and Goverance Number of Views Few Android users can no longer use SecurID Authenticator for Android due to an incorrect rootedjailbroken detection event Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory RSA Authentication Manager 8.8 Setup and Configuration Guide
