Pipeline Cannot Start Due To More Than 1000 Expressions In Bal_grp_t

(Doc ID 746892.1)

Last updated on SEPTEMBER 10, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.3.1]
Information in this document applies to any platform.
This problem can occur on any platform.
Checked for relevance on 10-Sep-2015.


Unable to start the Pipeline.

Below is the error message from process log :

15.09.2008 18:54:59 machine1 ifw IFW CRITICAL [T:1] 31233 -
(ifw.DataPool.BalanceDataModule.Module) ERR_BALANCE_DATABASE | Database operation failed inDAT_BalanceBatch: 'SELECT tag_bal_grp_t.poid_db, tag_bal_grp_t.poid_id0, tag_bal_grp_t.poid_rev, tag_bal_grp_t.account_obj_id0, tag_bal_grp_t.batch_cntr, tag_bal_grp_t.object_cache_type FROM bal_grp_t tag_bal_grp_t WHERE tag_bal_grp_t.poid_id0 > 1 AND (tag_bal_grp_t.object_cache_type = 0 OR tag_bal_grp_t.object_cache_type = 2) AND tag_bal_grp_t.poid_type = '/balance_group'
[SERVERERROR] ORA-01795: maximum number of expressions in a list is 1000'

There were 1017 distinct drum_expression in IFW_DISCOUNTRULE table when this problem occurred.

SQL query to find the same is:
 select distinct drum_expression from IFW_DISCOUNTRULE;

-- Steps To Reproduce:

Start the Pipeline with this command: ifw -r conf/rating.reg


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