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 Incompatibility with Encoding of Private Key causes various issues on an RSA SecurID Access Identity Router running SLES12… Number of Views Manually applying the definition files to ClamAV for 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
RSA Authentication Manager 8.9 Release Notes (January 2026) RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA-2026-07: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities Downloading RSA Authentication Manager license files or RSA Software token seed records RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
