My Oracle Support Banner

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

Last updated on MARCH 18, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 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 <HOSTNAME> ifw IFW CRITICAL [T:1543] 00000 -
(ifw.Pipelines.<NAME>.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.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.