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 FIM - Null pointer exception -'error encrypting the name id unable to encrypt' Number of Views 'Unable to encrypt data as this certificate is not meant for Encryption' or 'Unable to sign ...' Number of Views Authentication Agent, AAWin v. 7.4.4 on Citrix Windows non-persistent VDI node secret mismatch Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide
