SyncPDC is Throwing Constraint BRM_PDC.UNQ_NM_ABCATTRIBUTESPEC Errors After IP2 & MPS1 Upgrade

(Doc ID 2076498.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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

Goal

Provide the root cause for constraint BRM_PDC.UNQ_NM_ABCATTRIBUTESPEC.

 

The unique constraint error when running startSyncPDC:

/app/billing/brm/brm_pin/PDC/PDC_INT_HOME/apps/bin>./startSyncPDC
Creating PID file ..
Starting SyncPDC with JAVA Memory arguments: -Xms256m -Xmx512m -XX:CompileThreshold=8000 -XX:PermSize=128m -XX:MaxPermSize=512m
PLEASE ENTER KEY PASSWORD TO DECRYPT THE PASSWORD(S) :
Clean up work item SYNC_EVENT...
Work item SYNC_EVENT started (item 1 of 8).
 Processing EXTRACT work action...
 Processing ANALYZE work action...
 Processing TRANSFORM work action...
 Processing LOAD work action...
Work item SYNC_EVENT completed.
Clean up work item SYNC_SERVICE...
Work item SYNC_SERVICE started (item 2 of 8).
 Processing EXTRACT work action...
 Processing ANALYZE work action...
 Processing TRANSFORM work action...
 Processing LOAD work action...
Data migration Errors: One or more errors were encountered during data migration
SyncPDC: there is an error during SyncPDC. Check SyncPDC log file for detail.
Removing /app/billing/brm/brm_pin/PDC/PDC_INT_HOME/apps/syncpdc/syncpdc.pid


In WebLogic log_Adminserver:

Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BRM_PDC.UNQ_NM_ABCATTRIBUTESPEC) violated

Error Code: 1
Call: INSERT INTO ABCAttributeSpec (ENTITYID, CLASSNAME, CREATEDDATE, CREATEDUSER, DESCRIPTION, ENABLED, ENTITYCLASS, ENTITYVERSION, INTERNALID, LASTMODIFIEDDATE, LASTMODIFIEDUSER, NAME, PERSISTEDNAME, STATUS, UNIQUENAME, VERSION, VIRTUALCOLUMN, CHANGESET, PRICELIST, PUBLISHHISTORY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
bind => [676973, /service/telco/bbt, 2015-10-15 09:53:50.133, BRM_PDC, TelcoBbt, true, BCProductAttributeSpecDAO, 1, 6730d76d-7aef-437d-af28-145862591710, 2015-10-15 09:53:50.133, BRM_PDC, TelcoBbt, null, DRAFT, TelcoBbt, 0.0, false, 676415, 51, null]
Query: InsertObjectQuery([ BCProductAttributeSpecDAO oid=oracle.communications.platform.entity.impl.BCProductAttributeSpecDAO-676973 !PTDND!=TTFTF entityVersion=1 enabled=true persistedName=null className=/service/telco/bbt virtualColumn=false name=TelcoBbt uniqueName=TelcoBbt description=TelcoBbt dirtyFlag=false internalId=6730d76d-7aef-437d-af28-145862591710 version=0.0 status=DRAFT obsolete=false createdDate=Thu Oct 15 09:53:50 CEST 2015 createdUser=BRM_PDC targetAppSpecIDs=null baseProductSpecIID=ba06d198-5a85-4a0e-87fe-2599edd167a1 ])>


In BccService.xml:
...
  
  TelcoBbt
  TelcoBbt
  850240e4-e2e4-430d-9726-370ab7c13554
  Default
  false
  
  Billing
  Pricing
  Realtime Charging
  Convergent Charging
  
  ENABLED
  /service/telco/bbt
  Telco
...
  
  TelcoBBT
  TelcoBBT
  d45fa541-e0d6-4374-b95c-3b0745ee26a7
  Default
  false
  
  Billing
  Pricing
  Realtime Charging
  Convergent Charging
  
  ENABLED
  /service/telco/BBT
  Telco
  
...

 

Solution

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