25 Troubleshooting PDC Cloud Native

Learn how to troubleshoot issues in Oracle Communications Pricing Design Center (PDC) cloud native.

Topics in this document:

Troubleshooting ImportExportPricing Errors

When running the ImportExportPricing utility in a BRM cloud native environment, it may generate the following error: 

oracle.communications.brm.pdc.server.transformation.Transformer commitChanges

SEVERE: Error while committing transaction

oracle.communications.brm.pdc.server.transformation.TransformationException: Error in database operation for [committing connection]

To resolve the issue:

  1. Verify the connectivity to the database for both the Cross Reference (XREF) schema and the BRM schema.
  2. Redeploy PDC.

Note:

For an XREF schema error, redeploy PDC. For a BRM schema error, redeploy BRM and PDC both.

Unable to Import a Large Number of XML Files

You may encounter issues when importing a large number of XML files into your PDC cloud native environment using the ImportExportPricing utility. This occurs due to insufficient memory allocation for the WebLogic Server. To resolve the issue:

  1. In your override-values.yaml file for oc-cn-op-job-helm-chart, update the ocpdc.configEnv.USER_MEM_ARGS key to a higher value. For example:
    USER_MEM_ARGS: "-Xms10g -Xmx12g -XX:CompileThreshold=8000”
  2. Apply the changes by running the helm upgrade command for oc-cn-op-job-helm-chart:
    helm upgrade OpJobReleaseName oc-cn-op-job-helm-chart --values OverrideValuesFile --namespace BrmNameSpace
  3. In your override-values.yaml file for oc-cn-helm-chart, update the ocpdc.configEnv.transformation.MEM_ARGS key to a higher value. For example:
    MEM_ARGS: "-Xms10g -Xmx12g -XX:CompileThreshold=8000"
  4. Run the helm upgrade command for oc-cn-helm-chart: 
    helm upgrade BrmReleaseName oc-cn-helm-chart --values OverrideValuesFile --namespace BrmNameSpace
  5. Verify if the import issues have been resolved by rerunning the ImportExportPricing utility in your cloud native environment. See “Importing and Exporting Pricing and Setup Components” in PDC Creating Product Offerings.

If the issue persists, you can further increase the Xmx value based on your system's capacity.

SyncPDC Fails After Cloning BRM and PDC Databases

Note:

This applies to:
  • PDC systems with real-time rating engine (RRE) and batch rating engine (BRE) only.
  • PDC systems upgrading from version 12.0 patch set 5 or earlier to later versions (12.0 patch set 6 and after).
When you start SyncPDC after cloning the BRM and PDC databases from one environment to another, you may encounter an error stating that the /event/delayed/session/telco/gprs event is not configured as a rating event in BRM:
SEVERE: Error while running SyncPDC!
oracle.communications.brm.pdc.migration.MigrationException: Unexpected error occurred in migration operation
       at oracle.communications.brm.pdc.syncpdc.SyncPDCJob.execute(SyncPDCJob.java:234)
       at oracle.communications.brm.pdc.syncpdc.SyncPDC.run(SyncPDC.java:143)
       at oracle.communications.brm.pdc.syncpdc.SyncPDC.main(SyncPDC.java:299)
Caused by: oracle.communications.brm.pdc.migration.MigrationException: Error in migration operation
...
Caused by: java.lang.Throwable: There are errors when parsing bcc EventAttributeSpecs. Please fix the issues, then restart syncPDC.
The event, "/event/delayed/session/telco/gprs", was configurated as a rating event in BRM and used for creating a PDC EventAttributeSpec "EventDelayedSessionTelcoGprs", is not configurated as a rating event in BRM currently. It is not allowed to delete a rating event from PDC. Please restore "/event/delayed/session/telco/gprs" as a rating event in BRM.
The event, "/event/delayed/session/telco/gprs", was configurated as a rating event in BRM and used for creating a PDC EventAttributeSpec "EventDelayedSessionTelcoGprs", is not configurated as a rating event in BRM currently. It is not allowed to delete a rating event from PDC. Please restore "/event/delayed/session/telco/gprs" as a rating event in BRM.

This error occurs because the data in the pin_event_map file and IFW_REF_MAP database table are corrupted.

To fix this:
  1. In the BRM database, ensure that /event/delayed/session/telco/gprs is set with the Event_Type set to USAGE_POSTPAID in the DD_Objects_T table. To do so, use SQL*Plus to run the following command on the BRM database:
    select obj_id0, name, event_type from dd_objects_t where name = '/event/delayed/session/telco/gprs;'
  2. In the PDC database, ensure that /event/delayed/session/telco/gprs is set with the Event_Type set to USAGE_POSTPAID in the ABCATTRIBUTESPEC and BCEVENTATTRIBUTESPEC tables. To do so, use SQL*Plus to run the following command on the PDC database:
    SELECT name, eventtype, version FROM abcattributespec aas, bceventattributespec eas
WHERE classname = '/event/delayed/session/telco/gprs' and aas.entityid = eas.entityid 
ORDER BY version DESC;
  3. In BRM_Integration_Pack_home/apps/syncpdc/xml/extract/Event.xml file, ensure /event/delayed/session/telco/gprs is set with EVENT_TYPE is equal to USAGE_POSTPAID.
  4. In the BRM_Integration_Pack_home/apps/syncpdc/SyncPDCConfiguration.xml file, ensure skipBREMigration is set to false:
    <skipBREMigration>false</skipBREMigration>
  5. Ensure /event/delayed/session/telco/gprs is listed in BRM_home/sys/data/config/pin_event_map_telco_gprs file.

    If not, do the following:

    1. Edit the pin_event_map_telco_gprs file and add the following:
      /service/telco/gprs : /event/session/telco/gprs : Real Time Telco GPRS Session
: /event/delayed/session/telco/gprs : Delayed Telco GPRS Session
    2. Load the updated pin_event_map_telco_gprs file into the database using the load_event_map utility. See “load_event_map” in BRM Setting Up Pipeline Pricing.
    3. Verify that /event/delayed/session/telco/gprs appears in the CONFIG_PERMITTED_EVENTS_T table in the database.
    4. Restart SyncPDC.
  6. Ensure that /event/delayed/session/telco/gprs exists in the IFW_REF_MAP table. SyncPDC validates all events, including derived events, against the IFW_REF_MAP table. So, you must manually ensure that each derived event also has a valid mapping in IFW_REF_MAP.
    If not, add it by editing the pin_event_map_telco_gprs file and running the following SQL command:
    INSERT INTO "pre"."ifw_ref_map" (id, ref_obj, ref_param, entryby, entrydate, modified, modifdate, recver) VALUES ('CustomerData', '/service/telco', '/event/delayed/session/telco/gprs', '0', to_date('2023-11-02 05:48:38', 'YYYY-MM-DD HH24:MI:SS'), '1', to_date('2023-11-02 05:48:38', 'YYYY-MM-DD HH24:MI:SS'), '0');

    Note:

    In BRM, each service in the IFW_REF_MAP table can only be mapped to one event.
  7. Restart SyncPDC.