My Oracle Support Banner

MigrateBRMPricing Analyze Phase Of MIGRATE_PRICE_MODEL_SELECTOR Throws Error (Regarding MS_TO_COMBINE Column Size): "ORA-12899: value too large for column" (Doc ID 2026449.1)

Last updated on SEPTEMBER 11, 2018

Applies to:

Oracle Communications Pricing Design Center - Version 11.1.0.6.0 to 11.1.0.6.0 [Release 11.1.0]
Information in this document applies to any platform.

Goal

When executing the below:-

>>MigrateBRMPricing -product -analyze


The following error is raised:-

|Work item MIGRATE_PRICE_MODEL_SELECTOR started (item 8 of 11).
| Processing ANALYZE work action...
|java.sql.BatchUpdateException: ORA-12899: value too large for column "BTO_XREF"."MIGRATE_BRE_MODEL_SELECTOR"."MS_TO_COMBINE" (actual: 738, maximum: 500)


After extending the size of the column below, no error is raised:-

>>ALTER TABLE BTO_XREF.MIGRATE_BRE_MODEL_SELECTOR MODIFY(MS_TO_COMBINE VARCHAR2(2500 BYTE)); --it was 500 bytes


Will this change in column size cause any issues?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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