RS03755: EXCEPTION WHEN CREATING A SNAPSHOT OR BASELINE

Operational Decision Manager V8.10.2.2 Interim Fix 11 for Decision Center
IBM Operational Decision Manager V8.10.5.1 Fix Pack
IBM Operational Decision Manager for z/OS 8.10.5.1 Fix Pack

APAR status

• Closed as program error.

Error description

• When creating a snapshot a user may receive an exception
  
  
  ilog.rules.teamserver.model.IlrInvalidElementException:
  parentKeyNotFound
   at ilog.rules.teamserver.ejb.service.dao.IlrE
  lementDAOJDBC.computeLeftAndRight(IlrElementDAOJDBC.java:6198)
  
  at ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.inser
  tAggregatedElement(IlrElementDAOJDBC.java:6007)
   at ilog.rules.t
  eamserver.ejb.service.IlrSessionFacadeImpl.insertAggregatedEleme
  ntDetails(IlrSessionFacadeImpl.java:2409)
   at ilog.rules.teamser
  ver.ejb.service.IlrSessionFacadeImpl.commitBaseline(IlrSessionFa
  cadeImpl.java:8899)
   at ilog.rules.teamserver.ejb.service.IlrClo
  neBaselineSummary.cloneBaseline(IlrCloneBaselineSummary.java:91)
  
   at ilog.rules.teamserver.ejb.service.IlrCopyBaseline.run(IlrCo
  pyBaseline.java:39)
   at ilog.rules.teamserver.ejb.service.IlrSes
  sionFacadeImpl.createBaselineFrom(IlrSessionFacadeImpl.java:8733
  )
   at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.cre
  ateBaselineFrom(IlrSessionFacadeImpl.java:8542)
   at ilog.rules.t
  eamserver.ejb.service.IlrSessionFacadeImpl.createBaselineFromCur
  rentState(IlrSessionFacadeImpl.java:8519)
   at ilog.rules.teamser
  ver.ejb.service.IlrSessionFacadeImpl.createDsDeploymentBaseline(
  IlrSessionFacadeImpl.java:5372)
  

Local fix

• 1) Disconnect all users from DC
  
  2) Manually create missing
  records in BSLNLFTRGT table using the appropriate query
  
  If
  columns CONTAINER, maxversionid, parent and type are exist in
  BSLNLFTRGT:
  
  run:
  INSERT INTO BSLNLFTRGT (ID, LFT, RGT,
  CONTAINER, maxversion, parent, type)
   SELECT ID, 0, 0,
  CONTAINER, maxversionid, parent, type
   FROM BASELINE
   WHERE
  ID != 2147483647
  
  else
  
  run:
   INSERT INTO BSLNLFTRGT (ID, LFT,
  RGT)
   SELECT ID, 0, 0
   FROM BASELINE
   WHERE ID !=
  2147483647
  
  3) Login as administrator.
  This first login might
  take some time as the baseline repair tool will be performing
  the necessary work to restore the database.
  
  4) reopen DC for
  work
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * users creating snapshot or baseline.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When creating a snapshot a user may receive an exception     *
  *                                                              *
  *                                                              *
  * ilog.rules.teamserver.model.IlrInvalidElementException:      *
  * parentKeyNotFound                                            *
  *  at ilog.rules.teamserver.ejb.service.dao.IlrE               *
  * lementDAOJDBC.computeLeftAndRight(IlrElementDAOJDBC.java:619 *
  * 8)                                                           *
  *                                                              *
  * at                                                           *
  * ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC.inse *
  * r                                                            *
  * tAggregatedElement(IlrElementDAOJDBC.java:6007)              *
  *  at ilog.rules.t                                             *
  * eamserver.ejb.service.IlrSessionFacadeImpl.insertAggregatedE *
  * leme                                                         *
  * ntDetails(IlrSessionFacadeImpl.java:2409)                    *
  *  at ilog.rules.teamser                                       *
  * ver.ejb.service.IlrSessionFacadeImpl.commitBaseline(IlrSessi *
  * onFa                                                         *
  * cadeImpl.java:8899)                                          *
  *  at ilog.rules.teamserver.ejb.service.IlrClo                 *
  * neBaselineSummary.cloneBaseline(IlrCloneBaselineSummary.java *
  * :91)                                                         *
  *                                                              *
  *  at                                                          *
  * ilog.rules.teamserver.ejb.service.IlrCopyBaseline.run(IlrCo  *
  * pyBaseline.java:39)                                          *
  *  at ilog.rules.teamserver.ejb.service.IlrSes                 *
  * sionFacadeImpl.createBaselineFrom(IlrSessionFacadeImpl.java: *
  * 8733                                                         *
  * )                                                            *
  *  at                                                          *
  * ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl.cre   *
  * ateBaselineFrom(IlrSessionFacadeImpl.java:8542)              *
  *  at ilog.rules.t                                             *
  * eamserver.ejb.service.IlrSessionFacadeImpl.createBaselineFro *
  * mCur                                                         *
  * rentState(IlrSessionFacadeImpl.java:8519)                    *
  *  at ilog.rules.teamser                                       *
  * ver.ejb.service.IlrSessionFacadeImpl.createDsDeploymentBasel *
  * ine(                                                         *
  * IlrSessionFacadeImpl.java:5372)                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Issue was related to the BSLNLFTRGT table.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R8A0 PSY

     UP