Large Tax Supplier ID Migration Causes Dm_Oracle Error And Cm Is Not Starting: Error ORA-01455: Converting Column Overflows (Doc ID 1563140.1)

Last updated on SEPTEMBER 26, 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.

Symptoms

Product: BRM 7.5 PS4 (upgrade from 7.2.1 to 7.3 to 7.4 to 7.5)

The following values for Tax Supplier ID exist in the 7.2.1 production environment in CONFIG_TAXS_T:

 
But if this is run (and the entire upgrade is executed all the way to 7.5), the following error occurs in the dm_oracle when starting the cm:

E Tue Jun 4 16:07:43 2013 dvgllpsmsapp10 dm:18419 dm_subr.c(156):8670 1:dvgllpsmsapp10:cm:26533:-146749744:0:1370376463:0
  ORACLE error: do_sql_mr_select: PINStmtExecute: code 1455, op 0
  =ORA-01455: converting column overflows integer datatype 03926
Session ID: 1322 Serial number: 36139

The cm will not start.

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