Enlighten - DLM - Missing Information - Bookmark

This page will help you to solve problems related to the missing bookmark in the DLM view.   

In the below image, caller object is SP_GET_BILLING_FREQUENCY and the callee object is "GET_BILLING_REQUENCY", but it is not bookmarked / highlighted. 

1. For the given objects (caller and callee objects), follow the steps in SQL Queries - CAST Knowledge Base - Queries on objects - How to retrieve bookmark points and note down the final result.
2. Manually, calculate (MANUAL_START_ROW_POINT, MANUAL_START_COLUMN_POINT) & (MANUAL_END_ROW_POINT, MANUAL_END_COLUMN_POINT) for "Called Object" in the code viewer and note down the final result :
   1. We consider the below image as example, the called name is SWN_CUSTOMER_DETAILS:
      

   2. Looking at the code viewer, we see that "Calling Name" and "Called Name" is in the same line. so MANUAL_START_ROW_POINT and MANUAL_END_ROW_POINT is 2.

   3. Now place your cursor at the starting on Line 2 (MANUAL_START_ROW_POINT) and count number of columns upto starting of bookmark in the code viewer. bookmarking starts at 48 (MANUAL_COLUMN_START_POINT). Continue to count number of columns until the end of bookmark. It ends at 68 (MANUAL_END_COLUMN_POINT).

   4. Hence result of Manual calculation of bookmarking is

      MANUAL_START_ROW_POINT	MANUAL_START_COLUMN_POINT	MANUAL_END_ROW_POINT	MANUAL_END_COLUMN_POINT
      2	48	2	68

3. If the values do not match the result of the SQL Queries result, then, it is an analysis issue since the bookmark are calculated during the analysis.

4. If the values do match the result of the SQL queries, then it is a DLM issue.

5. If the bookmarks are calculated and correct from the above steps and you are using powerbuilder, then, after backing up your KB, use the following query to update the bookmarks for Powerbuilder.

   UPDATE accbook
   SET    blkno = Q1.idobjref
   FROM   (SELECT o.idobjref,
                  a.idacc
          FROM    objpos o
                  JOIN acc a
                  ON      o.idobj = a.idclr
                  JOIN keys k
                  ON      k.idkey = a.idclr
                  JOIN typcat tc
                  ON      tc.idtyp       = k.objtyp
                  AND     tc.idcatparent = 6011
          )
          AS Q1
   WHERE  accbook.blkno = 0
   AND    accbook.idacc = Q1.idacc

6. Once the query is run, restart the DLM view again.
7. If none of the cases matches your problem contact Cast Technical Support with Relevant input in order to reproduce this issue.

Relevant Input

• Screenshot of the issue in Enlighten
• Detailed description of the issue
• CAST Support Tool (CST) - alias Sherlock. Option to select are : Export Cast Bases, Export logs, Export Configuration Files, Export source code.