Unable to delete Administrator error observed while changing the Admin role to user role

Products

• CA Strong Authentication
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

An error is observed when the role of an Administrator is changed to User role. This is the error message observed -

2025-01-03 17:24:04,324 CET : [http-nio2-10.118.182.62-10001-exec-5] : ERROR : framework.adminmgmt.AdminManagerImpl : [<Adminname>] : [<Orgname>] : [] : [Arcot Admin Console] : [Admin Console] : [] : Unable to delete Administrator '<Adminname>(Organization: <Orgname>)'
org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "ARCOT.ARADMIN_DELETE_SP", line 29
ORA-06512: at line 1

### The error may exist in framework-ibatis/framework-adminmgmt-ibatis.xml
### The error may involve adminmgmt.deleteAdmin-Inline
### The error occurred while setting parameters
### SQL: {call ARADMIN_DELETE_SP(?,?)}
### Cause: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "ARCOT.ARADMIN_DELETE_SP", line 29
ORA-06512: at line 1

 

Environment

Strong Authentication

Release : 9.1.5

Cause

There was a schema difference between the ARADMINUSER and ARADMINUSER_ARCHIVE, ADMINREFID column was out of order in ARADMINUSER_ARCHIVE table.

Resolution

Recreating the table “ARADMINUSER_ARCHIVE” with the columns in the same order “ARADMINUSER” should resolve the issue.