Errors while starting Pipeline (Batch and Realtime ) (Doc ID 2139639.1)

Last updated on JUNE 23, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Goal

Qn1: Tried to start Batch rating pipeline, it is throwing following error :

/app/billing/brm/brm_integrate/ifw/bin/ifw: An error occurred during creation.

Originator : ifw.DataPool.CustomerData.Module
Destination :
Message : ERR_MULTI_THREAD_INIT
Arguments : Fail to Load Data Successfully in DAT_InitCustomerThread

State : false
Severity : CRITICAL
Thread : 2454082528


In process log following error is coming:

17.05.2016 07:59:37 xxxx ifw IFW CRITICAL [T:2927982912] 00217 - (ifw.DataPool.CustomerData.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-00936: missing expression --- SELECT tag_au_serv_alias_list.name, tag_au_service.account_obj_id0, tag_au_service.effective_t, tag_au_service.au_parent_obj_type, tag_au_service.au_parent_obj_id0, tag_au_service.au_parent_obj_rev, tag_au_service.account_obj_db FROM au_service_alias_list_t tag_au_serv_alias_list, au_service_t tag_au_service WHERE tag_au_service.poid_id0 = tag_au_serv_alias_list.obj_id0 (+) AND tag_au_service.au_parent_obj_type IN () AND tag_au_service.poid_db != 0 AND tag_au_service.account_obj_id0 >= :ph12 AND tag_au_service.account_obj_id0 <= :ph13 ORDER BY tag_au_service.au_parent_obj_id0 ASC, tag_au_service.au_parent_obj_rev ASC'.
17.05.2016 07:59:38 xxxx ifw IFW CRITICAL [T:2948962624] 00217 - (ifw.DataPool.CustomerData.Module) ERR_DATABASE | Database error '[SERVERERROR] ORA-00936: missing expression --- SELECT tag_au_serv_alias_list.name, tag_au_service.account_obj_id0, tag_au_service.effective_t, tag_au_service.au_parent_obj_type, tag_au_service.au_parent_obj_id0, tag_au_service.au_parent_obj_rev, tag_au_service.account_obj_db FROM au_service_alias_list_t tag_au_serv_alias_list, au_service_t tag_au_service WHERE tag_au_service.poid_id0 = tag_au_serv_alias_list.obj_id0 (+) AND tag_au_service.au_parent_obj_type IN () AND tag_au_service.poid_db != 0 AND tag_au_service.account_obj_id0 >= :ph12 AND tag_au_service.account_obj_id0 <= :ph13 ORDER BY tag_au_service.au_parent_obj_id0 ASC, tag_au_service.au_parent_obj_rev ASC'.
17.05.2016 07:59:39 xxxx ifw IFW NORMAL [T:2948962624] 00054 - (ifw.DiagnosticDataHandler) INF_FILE_MOVED | File '/app/billing/brm/brm_integrate/ifw/HOBLogs/log/diagnostic/diagnostic.dat.45478' moved to '/app/billing/brm/brm_integrate/ifw/HOBLogs/log/diagnostic/diagnostic.dat.45478.20160517_075938'.
17.05.2016 07:59:39 xxxx ifw IFW CRITICAL [T:2948962624] 30019 - (ifw.DataPool.CustomerData.Module) ERR_INIT_THREAD_DIED | Thread-3 has died with an expection in DAT_InitCustomerThread::run() -
 
Qn2: Wireless Registry not starting. Throwing 'EDR index creation failed' error.

We are trying to test some scenarios which includes monthly cycle discounts. But when trying to create account with a discount, we are getting below error in cm log:

E Fri May 13 14:06:11 2016 xxxx cm:4520 cm_em.c(25):336 1:ald-star-hob-st01:testnap:30064:-136345904:64:1463141170:8
  CMAP ERROR: bad IP connect to EM ald-star-hob-st01:24001, errno 111
D Fri May 13 14:06:11 2016 xxxx cm:4520 fm_rate_and_discount_event.c:1004 1:ald-star-hob-st01:testnap:30064:-136345904:64:1463141170:8
  Re-direction PCM_OP_RATE_DISCOUNT_EVENT output flist:
NULL flist ptr
E Fri May 13 14:06:11 2016 xxxx cm:4520 fm_rate_and_discount_event.c:1063 1:ald-star-hob-st01:testnap:30064:-136345904:64:1463141170:8

On checking we found that wireless registry is down which is causing this issue.

When we tried to start wireless registry we got following error in console:

Originator : ifw.Pipelines.DiscountPipeline0.Functions.Standard.FunctionPool.DiscountAnalysisModule.Module
Destination :
Message : ERR_CREATE_INDEX
Arguments : All or some field names could not be resolved.

State : false
Severity : MAJOR
Thread : 796972000

In process log we got below error:

13.05.2016 14:11:01 xxxx ifw IFW NORMAL [T:3058451424] 00000 - (ifw.DataPool.ModelSelectorDataModule.Module) One or more indices are not set
13.05.2016 14:11:01 xxxx ifw IFW MAJOR [T:3058451424] 00427 - (ifw.Pipelines.DiscountPipeline0.Functions.Standard.FunctionPool.DiscountAnalysisModule.Module) EDR index creation failed: All or some field names could not be resolved.

How to fix the above error?
 

Solution

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