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 44Number of Views Envision: Very Few Windows Events Showing Up In Envision 13Number of Views In RSA Identity Governance & Lifecycle, the change request manual activity assignment link (Assign to Specific Group or Ro… 17Number of Views Few Android users can no longer use SecurID Authenticator for Android due to an incorrect rootedjailbroken detection event 38Number of Views RSA Governance & Lifecycle Data Processors: Manipulating Account Data 34Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process RSA Release Notes for RSA Authentication Manager 8.8 RSA RADIUS Server service failed to start in the RSA Authentication Manager 8.1 Operations Console Microsoft Entra ID External MFA - Relying Party Configuration Using OIDC - RSA Ready Implementation Guide RSA Release Notes: Cloud Access Service and RSA Authenticators