ECE Does Not Reuse Open Items (Doc ID 2296459.1)

Last updated on MARCH 23, 2019

Applies to:

Symptoms

On :  ECE 11.3.0.2.0 version, Rated request persistence layer

Issue :
-----------------------
 ECE does not reuse open items .
 For each time that ECE is restarted , after rating, it creates new rating items.
 Because of this behavior, for a given account REL cannot load files and throws below error.

ERROR
-----------------------
Rel.pinlog snippet :

As a new item object is created after each restart of ece, the number of item poids in the item_poid_list is going beyond the limit of 4000 varchar and hence REL is throwing the above error.
So the issue to be addressed is , why ece is creating a new item instead of reusing the existing item object.

Note : Below was the item configuration (snippet) from pdc :

       <type>/item/custom/Event</type>
       <default>false</default>
       <aggregationType>CUMULATIVE_NONPRECREATE</aggregationType>  -------------> notice this
       <category>usage</category>

Cause

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