Purpose (problem description)

This page is a troubleshooting guide for problem - No items to show on FRAME_PORTAL_FAQ_VIEW_EXCLUSION view

Figure 1

Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
Observed on RDBMS
RDBMS
Yes/No
CSS(tick)

Step by Step scenario

  1. Compute snapshot
  2. Open CED
  3. Navigate to the view FRAME_PORTAL_FAQ_VIEW_EXCLUSION view

Action Plan

To troubleshoot this issue

  1. If there is only one snapshot then it's normal to not have any exclusions on the Dashboard. Note that the functional behavior is to exclude a quality rule in the current snapshot in order to get the exclusion for the next snapshot. So in order to get the list violation you should re-snapshot your application. Else go to the next step
  2. Check if there are exclusion:
    1. Get the snapshots from where the exclusions are set

      SELECT DISTINCT 'first', 
                      e.first_snapshot_id 
      FROM   dss_object_exceptions e 
      UNION ALL 
      SELECT DISTINCT 'last', 
                      e.last_snapshot_id 
      FROM   dss_object_exceptions e 

      Result example:

      "first";14
      "last";1000000000

       In this example the exceptions are set only on the snapshot 14

    2. Get the snapshot id from the "RETRIEVER_FAQ_OBJECT_EX_LIST_BODY" after applying the following page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display
       
    If the id retrieved from point b is not present in the result point a, this means that there was no exclusion set on the snapshot, so it is expected to get No items to show on FRAME_PORTAL_FAQ_VIEW_EXCLUSION view, else go to the next step
  3. Check if there are duplicated rows under the table VIEWER_ACTION_PLAN Corruption due to duplicate rows in VIEWER_ACTION_PLANS, if yes then remediate by following the link Corruption due to duplicate rows in VIEWER_ACTION_PLANS, If the issue still persist then go to the next step
  4. Apply the following page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display on the retriever "RETRIEVER_FAQ_OBJECT_EX_LIST_BODY", if the manual execution of the query takes a long time then you are facing a performence issue, refer to CAST Engineering Dashboard - Views - Hangs and performance issues.
    Else go to the next step

  5. If this steps do not help you to resolve/understand your issue then contact CAST Technical Support and provide the following Relevant input

 

Notes/comments

Ticket # 7852

Related Pages