Fixes are available
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 number
RS03755
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
8A0
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-02-26
Closed date
2021-03-01
Last modified date
2021-03-01
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8A0","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
06 December 2021