My Oracle Support Banner

SyncPDC is Throwing Constraint BRM_PDC.UNQ_NM_ABCATTRIBUTESPEC Errors After IP2 & MPS1 Upgrade (Doc ID 2076498.1)

Last updated on FEBRUARY 28, 2019

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/<>, 2015-10-15 09:53:50.133, BRM_PDC, Telco<service name>, true, BCProductAttributeSpecDAO, 1, 6730d76d-7aef-437d-af28-145862591710, 2015-10-15 09:53:50.133, BRM_PDC, Telco<service name>, null, DRAFT, Telco<service name>, 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/<service name> virtualColumn=false name=Telco<service name> uniqueName=Telco<service name> description=Telco<service name> 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:
...
  
  Telco<service name>
  Telco<service name>
  850240e4-e2e4-430d-9726-370ab7c13554
  Default
  false
  
  Billing
  Pricing
  Realtime Charging
  Convergent Charging
  
  ENABLED
  /service/telco/<service name>
  Telco
...
  
  Telco<SERVICE NAME>
  Telco<SERVICE NAME>
  d45fa541-e0d6-4374-b95c-3b0745ee26a7
  Default
  false
  
  Billing
  Pricing
  Realtime Charging
  Convergent Charging
  
  ENABLED
  /service/telco/<SERVICE NAME>
  Telco
  
...

 

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.