Value has not been specified for parameter 5.SQL State:07001 error in arcotriskfort.log

Products

• CA Risk Authentication

Issue/Introduction

Customer upgraded the environment to 9.1 from 8.2.1 Advanced Authentication and observing the below error messages in the arcotriskfort.log file

Wed Sep 11 03:44:34.647 2024 INFO:    pid 7424 tid 7999: 2: 15:1457124: ArDBM::Execution with error (not ICV) for Query[ArRFUserContextQuery_UpdateUserContextDetails]
Wed Sep 11 03:44:34.647 2024 INFO:    pid 7424 tid 7999: 2: 15:1457124: Dbm::SQL State:07001, Native Code: 7F5D00000000, ODBC code: [CA AA][ODBC Oracle Wire Protocol driver]Value has not been specified for parameter 5.SQL State:07001, Native Code: 7F5D00000000, ODBC code: [CA AA][ODBC Oracle Wire Protocol driver]Value has not been specified for parameter 6.

Environment

Risk Authentication

Version: 9.1

OS : Linux

Resolution

The issue is identified as a BUG in the product and a fix is already available. Fix is available as a hotfix on top of 9.1SP1 and also ported to later Service Packs available. It is recommended to upgrade the environment to 9.1SP3 and later to address this issue.