Risk Authentication server observing error - Device ID generation failed - after upgrade to 9.1SP5

Products

• CA Risk Authentication

Issue/Introduction

The environment is upgraded from 9.1.3 version to 9.1.5 version and after that the below error message is observed in the Risk server logs.

Wed Apr 02 08:16:06.952 2025 INFO:    pid 7880 tid 7992: 8: 27:1920884: Device Id not present in the request message.
Wed Apr 02 08:16:06.958 2025 INFO:    pid 7880 tid 7992: 2: 27:1920884: Dbm::SQL State:42000, Native Code: AFC, ODBC code: [Arcot Systems][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Could not find stored procedure 'nextValBigInt'.
Wed Apr 02 08:16:06.976 2025 INFO:    pid 7880 tid 7992: 2: 27:1920884: ArDBM::Execution with error (not ICV) for Query[ArRFUtilityQuery_FetchNextSeqVal]
Wed Apr 02 08:16:06.976 2025 INFO:    pid 7880 tid 7992: 8: 27:1920884: Response[7664] Reason[8122] Error String [Device ID generation failed.]

Environment

Release : Risk Authentication

Version: 9.1.5

Database - MS SQL server

 

Cause

nextValBigInt  stored procedure is not present in the database. 

Resolution

nextValBigInt is the stored procedure part of the Risk Authentication upgrade script db-config-for-riskauth-9.x-to-9.1.5.sql. Please make sure that the DB admin responsible to run the scripts see the procedures after running the scripts to avoid any issue. In this particular case the CREATE or ALTER statement to create the procedure was missed which caused the issue.