Purpose (problem description)
This page will help you to resolve book mark issues for the rule - Lazy fetching should be used for Hibernate collection
Applicable Platform or <Sub Platform Version>
CAST AIP | Yes/No |
---|---|
8.3 |
Step by Step scenario
- Run analysis+snapshot
- Observe no book mark for rule
Action Plan
If you observe no book mark for the rule mentioned then perform the below actions :
- In this case, please confirm if the violated object for which bookmark is not visible is of type JPA_ENTITY. You can run the below query to confirm this :
Run on local schema:
select * from keys k join Typ t on t.idtyp = k.objtyp where k.idkey in (<violated_object_id>)
Example result is shown below:
259945reperesDocumentExploitant XXXXXX-1113520136022???1970-01-01 00:00:00.0 0 136022JPA_ENTITY_PROPERTYJPA Entity PropertyACTIVE
2. If object is of type JPA_ENTITY then you can set the below query as Tool after analysis followed by a full snapshot( analysis+snapshot).
with JPA_Entity_Properties (JPAEntityPropertyId, JPAEntityId, ParentId, info1, info2, info3, info4, blkno) as ( select kjep.IdKey, kje.IdKey, ope.IdObjRef, ope.info1, ope.info2, ope.info3, ope.info4, ope.blkno from Keys kjep join ObjPos op on op.IdObj = kjep.IdKey and kjep.objTyp = 136022 /* JPA_ENTITY_PROPERTY */ join Keys kje on kje.IdKey = op.IdObjRef and kje.ObjTyp = 136021 /* JPA_ENTITY */ join ObjPos ope on ope.IdObj = kje.IdKey ) update ObjPos set IdObjRef = jep.ParentId, info1 = jep.info1, info2 = jep.info2, info3 = jep.info3, info4 = jep.info4, blkno = jep.blkno from JPA_Entity_Properties jep where ObjPos.IdObj = jep.JPAEntityPropertyId and objPos.IdObjRef = jep.JPAEntityId
3. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input
Relevant input
- CAST Support Tool (CST) - alias Sherlock export with the following options Export CAST Bases with Management Base, Knowledge Base, Central base, Measurement Base
- Dashboard screenshot showing bookmark issue
Notes/comments
Ticket # 30009
Related Pages