CM Is Not Up When Config_taxs_t.rec_id With Migrated Big Tax_supplier_id_id0 (Doc ID 1957055.1)

Last updated on JANUARY 04, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

There has been an BRM upgrade from 7.0 to 7.5. During upgrade, config_taxs_t.rec_id is set with the original 7.0 tax_supplier_id_id0 which is a big value(13756915559).

When starting cm, cm start failed.

cm.pinlog:
E Wed Feb 13 17:14:17 2019 brinrc01l cm:6692 fm_bill_utils_init.c:1817 1:brinrc01l:cm:6692:-143210784:0:1415579256:0
  fm_utils_init_tax_supplier_objects error
  
 
dm.pinlog:
E Wed Feb 13 17:14:17 2019 brinrc01l dm:6566 dm_subr.c(162):8981 1:brinrc01l:cm:6692:-143210784:0:1415579256:0
  ORACLE error: do_sql_mr_select: PINStmtExecute: code 1455, op 0
  =ORA-01455: converting column overflows integer datatype

Also expecting, since event_t.tax_supplier also references config_taxs_t.rec_id, robj - DB /event xxxxxx could also fail.

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