IIR Synchronizer Is Processing The Records Slowly From NSA To IDT Table (Doc ID 1956429.1)

Last updated on APRIL 04, 2016

Applies to:

Siebel Data Quality - Version 8.1 [21039] to 8.1.1.14.2 [IP2014] [Release V8]
Siebel CRM - Version 8.1 [21039] to 8.1.1.14.2 [IP2014] [Release V8]
Information in this document applies to any platform.
Customer using Siebel UCM 8.1.1.11 in integration with IIR 9.5.3 base version.

Symptoms

Customer is processing about 200k records everyday through BDM as daily delta batch jobs.
They are  using 60 parallel BDM jobs from 3 Siebel App servers (20 jobs from each server)
BDM is running pretty fast and is writing the data into IDS_UPD_SYNC_NSA table after the match check.
But Synchronizer is picking these records from NSA table and moving to IDT table slower than expected.
It is taking about an additional hour for IIR to move all the records from NSA to IDT table.
Customer is definitely missing duplicates within that delta jobs since synchronizer is moving the records compared to what siebel is writing into NSA table.

Changes

 Note: This happened after IIR upgrade from 2.8.07 to 9.5.3 version in Prod and customer already have about 30 million records in the IDT table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms