Oracle Communications Performance Intelligence Center (PIC) Software
 

PLA-Support>Sun Systems>CommsGBU>Global Signaling Solutions>SN-SND: Tekelec PIC
 

In this Document

Symptoms

Changes

Cause

Solution

Solution 1: Delete whole chain

Solution 2: Fix NSP database

Created from <SR 3-14479633331>

Applies to:

Symptoms

Cannot delete session old nor associate KPI to new session.

Following error is found in application.log:

• While deleting old session:
  
  2017-03-14 12:11:44,845 - ERROR - NSP - Centralized Configuration - tekelec - SYSTEM - Error - com.steleus.nsp.config.system.exception.NSPCentConfException: EJB Exception: ; nested exception is: java.sql.SQLException: Transaction BEA1-6329CCC9D76A1A0243EA not active anymore. tx status = Marked rollback. [Reason=weblogic.transaction.internal.AppSetRollbackOnlyException: setRollbackOnly called on transaction]
  at com.steleus.nsp.config.common.NSPCentConfExceptionUtil.prepareException(NSPCentConfExceptionUtil.java:31)
  at com.steleus.nsp.config.common.NSPCentConfExceptionUtil.logAndPrepareException(NSPCentConfExceptionUtil.java:12)
  at com.steleus.nsp.config.system.ejb.SessionFacadeBean.deleteSession(SessionFacadeBean.java:677)
  at com.steleus.nsp.config.system.ejb.SessionFacade_t5vfow_EOImpl.__WL_invoke(Unknown Source)
  at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
  at com.steleus.nsp.config.system.ejb.SessionFacade_t5vfow_EOImpl.deleteSession(Unknown Source)
  at com.steleus.nsp.config.system.ejb.SessionFacade_t5vfow_EOImpl_WLSkel.invoke(Unknown Source)
• While associating to new session:
  
  2017-03-14 23:42:01,533 - WARN - NSP - KPI - tekelec - SYSTEM - Multiple operate DFP are matching for storage DFP StoreSession. Please update related operate DFP with session ID: 25139
  2017-03-14 23:42:01,534 - ERROR - NSP - KPI - tekelec - SYSTEM - Unable to find the specified Object - com.steleus.nsp.config.system.exception.NSPCentConfException: ERROR #223229/1: Please contact technical support
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.getRelatedDfpId_DEPRECATED(DataflowProcessingFacadeBean.java:4930)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.getOperateDfpId_DEPRECATED(DataflowProcessingFacadeBean.java:4846)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.getOperateDfpId_DEPRECATED(DataflowProcessingFacadeBean.java:4822)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.getOperateDfpIdBySessionId(DataflowProcessingFacadeBean.java:5678)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.setProtraqConfiguration(DataflowProcessingFacadeBean.java:5082)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacadeBean.setProtraqConfiguration(DataflowProcessingFacadeBean.java:5070)
  at com.steleus.nsp.config.system.ejb.ixp.DataflowProcessingFacade_wnufhi_ELOImpl.__WL_invoke(Unknown Source)
  ...
  2017-03-14 23:42:01,542 - ERROR - NSP - KPI - tekelec - BUSINESS - Set config error - com.tekelec.cssg.nsp.gwt.components.client.common.NSPGWTException: ERROR #223229/1: Please contact technical support

Changes

Possible changes:

• A new session was created by editing IxpStore,
• A new store was created and used and existing stream.

Cause

Both issues are linked:

• System is not able to delete session because one operate is attached to old session and
• It cannot find appropriate operate for new session.

Solution

Solution 1: Delete whole chain

Delete Operate, Store and sessions

Solution 2: Fix NSP database

Fix involve NSP database modifications, open a SR and mention this KM to get this fixed.

Procedure:

1. Identify operate id:
   
   SQL> select id, name from cfg_dflowprocessing;
   
   ID         NAME
   ---------- ----------
   ...
   24823      O_Operate
   ...
2. Identify session id:
   
   SQL> select session_id, name from cfg_xdr_session;
   
   SESSION_ID NAME
   ---------- ------------------------------
   ...
     23752    OldSessionName
   ...
     25139    NewSessionName
   ...
3. Fix link operate dfp to session:
   
   update cfg_dfp_operate set SESSION_ID=25139 where DFPID=24823;
4. Commit:
   
   commit;

This solution has no attachment