Error during migration: Error: Failed to massage migrated data org.postgresql.util.PSQLException: ERROR: update or delete on table "am_offline_authn_policy"
Originally Published: 2014-10-24
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1
Platform: VMware
Platform (Other): null
O/S Version: ESXi 4.1
Product Name: RSA-0010810
Product Description: RSA-0010810
Issue
Error:
Failed to massage migrated data org.postgresql.util.PSQLException: ERROR: update or delete on table "am_offline_authn_policy" violates foreign key constraint "fk_am_sd_oapol_id_many_oap" on table "am_sec_domain_offln_authn_pol" Detail: Key (id)=(b1204522b40d110a02f0aedad06520ca) is still referenced from table "am_sec_domain_offln_authn_pol".
Cause
Resolution
2. Ensure that the AM8.1 server is able to access the same LDAP Servers as the AM7.1 servers. These need to be the REAL LDAP Servers, not an alias, load-balance name, round-robin, etc.
Related Articles
RSA Authentication Manager 8.1 SP 1 patch 1 backups to a Windows Shared Folder are failing after software upgrade Number of Views Windows Agent failing to authenticate local Group Membership with 30 Secs timeout Number of Views Manually applying the definition files to ClamAV for RSA Authentication Manager 8.x Number of Views Failed to validate remote location error when configuring backups to Windows Shared Folder in RSA Authentication Manager 8.x Number of Views RSA Identity Governance and Lifecycle RESTful web service response: java.lang.IllegalStateException Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
