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 RSA Identity Governance and Lifecycle RESTful web service response: java.lang.IllegalStateException Number of Views Manually applying the definition files to ClamAV for RSA Authentication Manager 8.x Number of Views
Trending Articles
How to manipulate imported RSA SecurID Software Token(s) on an iPhone or iPad device RSA-2026-10: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities RSA Authentication Manager 8.9 Release Notes (January 2026) Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA SecurID Desktop Token 5.0.3 for Windows Administrator's Guide
Don't see what you're looking for?
