Duplicate Check (Storelimit) Doesn'T Work With Values With Length >255 (Doc ID 869924.1)

Last updated on AUGUST 19, 2011

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.1.0.0 and later   [Release: 7.3.1 and later ]
Information in this document applies to any platform.
Checked for relevance on 19-Aug-2011

Symptoms

Testing a cdr with more no. of fields which crosses 255 characters in DuplicateCheck module of the registry. There is a duplicate file created in the IFW_HOME/data/dup directory as the DuplicateCheck module is enabled.
This is made possible by having a cdr dated with doesn't fall between the storelimit and
bufferlimit values of the module. Then a semaphore is passed to change the StoreLimit and
BufferLimit values such that the CDR date falls between these values in order to load the file
into the DB. During this stage there is an error thrown in the process log as below.

processlog:
=========
07.04.2009 17:21:35 xhkars33 ifw IFW CRITICAL [T:1543] 00000 -
(ifw.Pipelines.PCCW_MEDIATION_VOICE.Functions.Standard.FunctionPool.DuplicateCheck.Module)
ERR_BULKINSERTION_FAILED | Bulk Inserion Failed in the table IFW_DUPLICATECHECK from file
calls.duplicate_113264.dat . Error : Vendor Error: 1480

-- Steps To Reproduce:
1. Enable the DulicateCheck module in the registry.
2. Create an account.
3. Process a cdr, a duplicate file is created in the data/Dup folder.
4. Now pass a semaphore with the values for BufferLimit and StoreLimit such that cdr date falls
between these values.
5. Observe the error in the process log.


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