VIP Authentication Hub - data replication errors

Products

• Symantec Identity Security Platform - IDSP (formerly VIP Authentication Hub)

Issue/Introduction

VIP Authentication Hub is deployed  in three different Data Centers (DC). Each DC connects to a single Oracle database instance and Oracle GoldenGate Replication is configured across all three databases for replication. Replication logs show one particular table namely REFRESH_TOKEN receive deletes on the same records from multiple DCs.

No data found
Operation failed at seqno 17 rba 298695
Discarding record on action DISCARD on error 1403
Problem replicating Q03.M01M.T_REFRESH_TOKEN to Q01.M01M.T_REFRESH_TOKEN.
Record not found
Mapping problem with delete record (target format) SCN:618242644.20.3.91881...

Environment

VIP Authentication Hub

Release: 3.2.1

Resolution

VIP Authentication Hub runs a scheduler to delete the expired tokens. To address this issue you need to disable the scheduler on two out of three Data Centers. The scheduler job should only run from a single DC.
You can disable the scheduler by setting the below parameter:

Set the parameter "ssp.featureFlags.scheduler.enabled" to "false".