Error when running RSA Authentication Manager 8.x rsautil restore-admin command
Originally Published: 2018-09-06
Article Number
Applies To
RSA Product/Service Type: Authentication Manager
RSA Version/Condition: 8.1, 8.2, 8.3
Issue
An example command and output would be:
/opt/rsa/am/utils> ./rsautil restore-admin -o ocadmin -w support1 -u newuserid -p mypasswd!
Exception in thread "main" com.rsa.common.UnexpectedDataStoreException: org.postgresql.util.PSQLException:
ERROR: Unexpected column(s) Updated on table rsa_rep.ims_principal_data: administrator_flag,
Where: SQL statement "update rsa_rep_cover.ims_principal_data_dg DG
PL/pgSQL function tfx_redirtodg_update_ims_principal_data() line 69 at SQL statement
at com.rsa.ims.admin.dal.sql.PrincipalAccessSQL.setAdministratorFlag(PrincipalAccessSQL.java:2143)
at com.rsa.admin.tools.AdminRestorationCLUCommand.addPrincipalData(AdminRestorationCLUCommand.java:395)
at com.rsa.admin.tools.AdminRestorationCLUCommand.execute(AdminRestorationCLUCommand.java:194)
at com.rsa.admin.tools.AdminRestorationCLU.main(AdminRestorationCLU.java:65)
Caused by: org.postgresql.util.PSQLException: ERROR: Unexpected column(s) Updated on table rsa_rep.ims_principal_data: administrator_flag,
PL/pgSQL function tfx_redirtodg_update_ims_principal_data() line 69 at SQL statement
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at com.rsa.ims.admin.dal.sql.PrincipalAccessSQL.setAdministratorFlag(PrincipalAccessSQL.java:2137)
Exception in thread "main" com.rsa.common.SystemException: SQL error occurred while updating records :-ERROR: permission denied for relation ims_principal_admin_role at
com.rsa.admin.tools.AdminRestorationCLUCommand.execute(AdminRestorationCLUCommand.java:216) at com.rsa.admin.tools.AdminRestorationCLU.main(AdminRestorationCLU.java:65)Cause
Resolution
Related Articles
RSA Governance & Lifecycle Recipes: Dashboard - Review Results "Outstanding Applications" 9Number of Views RSA MFA Agent 2.0.1 for Microsoft Windows Release Notes 15Number of Views Error 2004: Unable to communicate with server Access Denied when running RSA Authentication Manager Bulk Admin (AMBA) script 222Number of Views RSA Governance & Lifecycle Recipes: System Health Check Dashboard 89Number of Views Authentication Dashboard 92Number of Views
Trending Articles
RSA Authentication Manager Upgrade Process Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager 8.9 Release Notes (January 2026) AFX Server Fails to Start with 'Could Not Build a Validated Path' and 'Timed Out Waiting for AFX Applications to Start' in… AFX Server stuck in 'Not running' State, with error 'timed out waiting for AFX applications to start'
Don't see what you're looking for?