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 |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
CSS |
Step by Step scenario
- Compute snapshot
- Open CED
- Navigate to the view FRAME_PORTAL_FAQ_VIEW_EXCLUSION view
Action Plan
To troubleshoot this issue
- 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
- Check if there are exclusion:
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
- 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
- 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
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- 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