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 Incompatibility with Encoding of Private Key causes various issues on an RSA SecurID Access Identity Router running SLES12… 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
Don't see what you're looking for?
