CAST Engineering Dashboard - Bookmarks - Bookmark not showing for rule - Lazy fetching should be used for Hibernate collection

Created by user-d7a7b on Feb 12, 2022
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(tick)
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 :

  1. 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