Unable to delete expired tokens and Unable to create token

book

Article ID: 223212

calendar_today

Updated On:

Products

CA Risk Authentication

Issue/Introduction

The following errors frequently occur in the State Manager log.

<arcotsm.log>----------------------------------------------------------------------
2021-09-01 09:03:50,058 [Token janitor] ERROR server.tsmimpl.iBatisTSMImpl(322) [] -> Unable to delete expired tokens (issued before 20210831234849.831, used before 20210831234849.831:   
--- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.  
--- The error occurred while executing mapped statement.  
--- Check the sqlDeleteTokenOlderThan.  
--- Check the statement or the result map.  
--- Cause: java.sql.SQLException: ORA-00257: アーカイブ・エラーです。解除されるまでAS SYSDBAにのみ接続してください。

2021-09-01 09:05:08,592 [WebContainer : 10] ERROR server.tsmimpl.iBatisTSMImpl(142) [] -> Unable to create token 9ad4a9d7758fbc34ec1e0dc5b86a6d56d590b748 | 20210901000508.443.9ad4a9d7: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.  
--- The error occurred while executing mapped statement.  
--- Check the sqlInsertTokenNoRisk.  
--- Check the statement or the result map.  
--- Cause: java.sql.SQLException: ORA-00257: アーカイブ・エラーです。解除されるまでAS SYSDBAにのみ接続してください。

---------------------------------------------------------------------------------------------

At the same time, the following error messages frequently occur in the alert log file of Oracle DB.

<alert_arcotdb.log>----------------------------------------------------------------------
Linux-x86_64 Error: 12: Cannot allocate memory
Additional information: 2673
Additional information: 884737
Additional information: 1627389952
Wed Sep 01 09:02:29 2021
Suspending MMON slave action qosdflushslv_ for 82800 seconds

ORA-01034: ORACLE not available
ORA-27102: out of memory
---------------------------------------------------------------------------------------------

We have stopped & started afm/uds/webfort/riskfort/casemgmt and are recovering.
The two systems use different AAs, the other one is not getting similar errors.

 

Cause

Database server is not accessible from State Manager and when it tries to look in DB table ARTSTOKENS, DB server having issues so data can not be fetched from that table.

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Resolution

You will see Create Token or Delete Token failing in case where the Database is not working fine and having some issues, State Manager uses the DB connectivity parameters from the arcotcommon.ini file and if for some reason DB is not accessible then all token operations will fail. To address the issue please look at the database and make sure it is not having issues, you can refer the DB connectivity parameters from arcotcommon.ini file. This issue may also happen if there is connectivity issues from the State Manager machine to the DB machine so ensure that the State Manager is able to connect with the Database specified in arcotcommon.ini file.