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

Last updated on NOVEMBER 08, 2023

Applies to:

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

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