Error During PDC Migration (pricing Analyze): Invalid Column Name

(Doc ID 2045067.1)

Last updated on AUGUST 30, 2015

Applies to:

Oracle Communications Pricing Design Center - Version 11.1.0.6.0 and later
Information in this document applies to any platform.

Symptoms

During the migration of the BRM pricing objects to PDC using the MigrateBRMPricing utility, the following error is raised in the ANALYZE phase of Work item TOPDOWN_ANALYSIS_CRP.

Steps :
> MigrateBRMPricing -pricing -analyze
...(omissis)...
Work item TOPDOWN_ANALYSIS_CRP started (item 4 of 11).
 Processing EXTRACT work action...
 Work action EXTRACT completed.
 Processing ANALYZE work action...
Data migration Errors: One or more errors were encountered during data migration!
MigrateBRMPricing: there is an error during migration. Check migration log file for detail.

Error :
The migration log file contains the following exception:
SEVERE: Migration Exception: Data migration Errors: One or more errors were encountered during data migration!
...(omissis)...
Caused by: java.sql.SQLException: Invalid column name
  at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3965)
  at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:299)
  at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:1460)
  at oracle.communications.brm.pdc.migration.pricing.xrefdao.bre.impl.TopDownAnalysisCrpTmDaoImpl.getTimeModelsForChargeRateplanVersion(TopDownAnalysisCrpTmDaoImpl.java:584)

 

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