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

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

CAST AIPYes/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 :

  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