Response[7664] Reason[8126] Error String [Internal Error:Database Operation Failed.]

Products

• CA Risk Authentication

Issue/Introduction

We are frequently observing the said error in riskfort logs. 

Response[7664] Reason[8126] Error String [Internal Error:Database Operation Failed.]

What does said operation means?

 

Environment

Release : 9.1

Resolution

From the log, take the  transaction ID.

Run the below command : 
select * from TFAADmin.ARRFSYSAuditlog where txid="ID". The user name gets displayed here.

Run select * from TFAADmin.ARRFSYSAuditlog where username="". Enter the User ID from the above one. 

Generate the Riskevaluation report for the user and verify if there are two / more transactions  done at the same exact time, 

Run this command in the DB : 

update ARRFCONFIGURATION set value=5 where category='GLOBAL' and name='DEVICELOCKEDTIMEDIFF'; update ARRFCONFIGURATION set value=5 where category='GLOBAL' and name='USERLOCKEDTIMEDIFF';

Below is the information from the update query : 

===============

Example - There is a test user 

First transaction - T1  happened at 10 AM IST.

Same user if second transaction happened  with in 2 min ( 120 sec ) and if it comes under the same user - it is considered as duplicate transaction,

If second transaction is coming in 120 seconds the logs does not get updated.

If the transaction comes post 120 seconds , it will gives a valid response.

So, the update query will not impact the user. 

=================

Here the value is updated as 5 We have kept 5 seconds and below 5 seconds this is not considered as correct. 

So, the  transaction will be abandoned if any comes from the same user under 5 seconds, and that is the reason the error is coming and there is no impact on the error