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 Incompatibility with Encoding of Private Key causes various issues on an RSA SecurID Access Identity Router running SLES12… 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
Trending Articles
Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory Mandatory Certificate Upgrade Required by 6th October 2025 for RSA MFA Agent for PAM, RSA MFA Agent for Apache, and Third … RSA Authentication Manager 8.9 Release Notes (January 2026)
Don't see what you're looking for?
