Report Generator - Generate Reports with UI - Empty lists - Empty Snapshot list

This page is a troubleshooting guide for the problem snapshot list is empty in report generator after selecting an application as shown below :

1. Configure the RestAPI - set the name of the desired Central Base or Measurement Base
2. Launch the Report Generator & select any application
3. Try to select the snapshot & see that the list is empty

1. Check for inconsistencies in the Central Base and fix them.
2. Check if it is a case of Missing technological objects
   

   1. Run the below query on Central Base in order to check if there are some missing technological objects.

      select distinct doi.OBJECT_ID, doi.OBJECT_TYPE_ID, dot.OBJECT_TYPE_NAME as OBJECT_NAME, 
       'Technologic ' || dot.OBJECT_TYPE_NAME || ' object' as OBJECT_DESCRIPTION, dot.OBJECT_TYPE_NAME as OBJECT_FULL_NAME 
       from DSS_LINK_INFO dli 
       join DSS_OBJECT_INFO doi 
       on doi.SNAPSHOT_ID = dli.SNAPSHOT_ID and doi.OBJECT_ID = dli.NEXT_OBJECT_ID 
       join DSS_OBJECT_TYPES dot 
       on dot.OBJECT_TYPE_ID = doi.OBJECT_TYPE_ID 
       left join DSS_OBJECTS dos 
       on dos.OBJECT_ID = dli.NEXT_OBJECT_ID 
       where dli.LINK_TYPE_ID = 2 and dos.OBJECT_ID is null

   2. If the above query returns some rows then this confirms that there there are some missing technological objects. For this case, to repair the CB please run the below query which inserts the technological objects.

      insert into DSS_OBJECTS (OBJECT_ID, OBJECT_TYPE_ID, OBJECT_NAME, OBJECT_DESCRIPTION, OBJECT_FULL_NAME) 
       select distinct doi.OBJECT_ID, doi.OBJECT_TYPE_ID, dot.OBJECT_TYPE_NAME as OBJECT_NAME, 
       'Technologic ' || dot.OBJECT_TYPE_NAME || ' object' as OBJECT_DESCRIPTION, dot.OBJECT_TYPE_NAME as OBJECT_FULL_NAME 
       from DSS_LINK_INFO dli 
       join DSS_OBJECT_INFO doi 
       on doi.SNAPSHOT_ID = dli.SNAPSHOT_ID and doi.OBJECT_ID = dli.NEXT_OBJECT_ID 
       join DSS_OBJECT_TYPES dot 
       on dot.OBJECT_TYPE_ID = doi.OBJECT_TYPE_ID 
       left join DSS_OBJECTS dos 
       on dos.OBJECT_ID = dli.NEXT_OBJECT_ID 
       where dli.LINK_TYPE_ID = 2 and dos.OBJECT_ID is null

3. Check if it is a case of Missing links in DSS_LINKS table
   

   1. To identify if some links are present in a snapshot, but not in DSS_LINKS table you can run the below query .

      select dli.LINK_TYPE_ID,
             count(1)
        from (select distinct dli.LINK_TYPE_ID,
                              dli.PREVIOUS_OBJECT_ID,
                              dli.NEXT_OBJECT_ID
                         from DSS_LINK_INFO dli
                         left join DSS_LINKS dl
                           on dl.PREVIOUS_OBJECT_ID = dli.PREVIOUS_OBJECT_ID
                          and dl.NEXT_OBJECT_ID = dli.NEXT_OBJECT_ID
                          and dl.LINK_TYPE_ID = dli.LINK_TYPE_ID
                        where dl.LINK_TYPE_ID is null
             ) dli
       group by dli.LINK_TYPE_ID
       order by dli.LINK_TYPE_ID

   2. If the above query returns some rows then this confirms that there there are some links present in a snapshot, but not in DSS_LINKS table. For this case, to repair the CB run the below query which inserts the links to DSS_LINKS from DSS_LINK_INFO

      insert into DSS_LINKS
                (
                 LINK_TYPE_ID,
                 PREVIOUS_OBJECT_ID,
                 NEXT_OBJECT_ID
                )
          select dli.LINK_TYPE_ID,
                 dli.PREVIOUS_OBJECT_ID,
                 dli.NEXT_OBJECT_ID
          from (select distinct dli.LINK_TYPE_ID,
                                 dli.PREVIOUS_OBJECT_ID,
                                 dli.NEXT_OBJECT_ID
                            from DSS_LINK_INFO dli
                            left join DSS_LINKS dl
                              on dl.PREVIOUS_OBJECT_ID = dli.PREVIOUS_OBJECT_ID
                             and dl.NEXT_OBJECT_ID = dli.NEXT_OBJECT_ID
                             and dl.LINK_TYPE_ID = dli.LINK_TYPE_ID
                           where dl.LINK_TYPE_ID is null
                ) dli

4. After running the query reset the measurement base.
5. Perform a re-consolidation of CB.
6. Re-start the web service  (tomcat).
7. Launch the Report Generator.
8. If the issue still exists then contact CAST Technical Support. with Relevant Input

 Ticket 29842