Error 'Invalid object name ARTSTOKENS' in State Manager

Products

• CA Advanced Authentication
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Strong Authentication

Issue/Introduction

The following error is occurring frequently in the State Manager log:

[Token janitor] ERROR server.tsmimpl.iBatisTSMImpl(322) [] -> Unable to delete expired tokens (issued before 20250407141547.810, used before 20250407141547.810:   
--- The error occurred in com/arcot/integrations/toksvr/server/tsmimpl/TsToken.xml.  
--- The error occurred while applying a parameter map.  
--- Check the sqlDeleteTokenOlderThan-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ARTSTOKENS'.

Environment

Symantec Strong Authentication 9.1.x
Symantec Adapter - State Manager

Resolution

The ARTSTOKENS table is missing from the database, and it should be created prior to deploying the State Manager WAR file on the application server using the script arcot-db-config-for-adapter-statemanager.sql. This is causing the error message "Invalid object name 'ARTSTOKENS'" to appear in the arcotsm.log.

 

Additional Information

Refer the section Deploying and Configuring State Manager in the product documentation.