My Oracle Support Banner

Getting Error While Executing "MigrateBRMPricing -pricing -analyze" (Doc ID 2685698.1)

Last updated on JULY 02, 2020

Applies to:

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

Goal

While executing "MigrateBRMPricing -pricing -analyze", there was SEVERE error message as below:

Jun 04, 2020 5:17:48 AM oracle.communications.brm.pdc.migration.Migrator executeJob
SEVERE: Error while run migration!
oracle.communications.brm.pdc.migration.MigrationException: Unexpected error occurred in migration operation
  at oracle.communications.brm.pdc.migration.pricing.xrefdao.rre.impl.MigrateProductDAO.insertProductMessagesData(MigrateProductDAO.java:1071)
  at oracle.communications.brm.pdc.migration.pricing.xrefdao.rre.impl.MigrateProductDAO.insertIntoDB(MigrateProductDAO.java:184)
  at oracle.communications.brm.pdc.migration.Migrator.migrateBRMPricing(Migrator.java:158)
  at oracle.communications.brm.pdc.migration.Migrator.main(Migrator.java:1447)
Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("PDC_MIG_XREF"."MIGRATE_PRODUCT_MESSAGE"."ARGS")
  at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)
  at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java
...


The <Note 2004473.1>, Error After Migrating Configuration Objects when Implementing PDC, did not help in this case.

PDC = Pricing Design Center


The user has dropped the constraint MIGRATE_PRODUCT_MESSAGE_PK and then was able to successfully complete the migration.

Questions:
1. Is there any issue in dropping the primary key and proceed with migration?
2. What is the actual fix to be done?


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.