Hello Experts, @"K.Gan" @"Veera-Oracle" @"Raj.Ogg-Oracle" @"mariam.kupa" @"Vikas Panwar"
I am a beginner and need your experts help on the below issue.
ACTIVE - PASSIVE
ORACLE - ORACLE
Found that a table: PROCESSTASK being updated from both sites.
Ideally it should not happen since we are connected to primary db only.
-> There is a Primary key on ID column for this PROCESSTASK table
-> A unique index is also present on ID column
Noticed some replication errors on this table: PROCESSTASK. It would appear that the table is being updated by the TimedDepositProcessing task of application in some fashion. There were two entries in each table, with this as an example of their contents:
Table Entries on both sites
There were discrepancies in these data rows with respect to time stamps and the like. This would appear that the database is being updated by both sides which is upsetting the replication process.