CAST Engineering Dashboard - Views - Empty or blank view - FRAME_PORTAL_DEVELOPMENT_VIEW

Description

When connecting to the Investigation-Application Drilldown page in the dashboard, the view does not show any values

Observed in CAST AIP

Observed on RDBMS

Step by Step Scenario

1. Run a snapshot
2. Connect to the Dashboard
3. Go to Investigation-Application Drilldown page and observe the issue

Action plan

1. The issue can occur if there was an access to the dashboard when generating the snapshot leading to incorrect content in the CB due to parallel access to some tables. to solve the issue run a re-consolidation on the last snapshot. If this do not solve the issue then go to the next step
2. Check if the central base contain one of the following inconsistencies:

   1. DSS_OBJECT_DIAG_DETAILS does not contain any violation for the current snapshot:

SELECT Count(1) FROM dss_object_diag_details WHERE snapshot_id IN (SELECT Max(snapshot_id) FROM dss_snapshots)

      Query result example:

      ```sql
--164824

  If the above query returns 0 then DSS\_OBJECT\_DIAG\_DETAILS does not contain any violation for the current snapshot:

2. Previous snapshot id is the same for all snapshots:

SELECT prev_snapshot_id FROM adg_delta_snapshots ORDER BY prev_snapshot_id

       Query result example:

      ```sql
-- 1
-- 2

  If the query above returns duplicated rows then the previous snapshot id is the same for several snapshots:If one of the above checks are verified then as a workaround execute the content of [fix.sql](https://doc-data.castsoftware.com/TG/attachments/566539076/566539075.sql) on your central base then restart tomcat application, note that this issue was fixed since Cast AIP 7.3.6. If the workaround donot solve your issue then contact  [CAST Technical Support](https://help.castsoftware.com/hc/en-us/requests/new) with [Relevant input](/export-v2/tg/technical-guides/technical-guides-by-cast-aip-component/cast-engineering-dashboard-component-ced/cast-engineering-dashboard-views/).

Notes/comments

Webcall 27340, Ticket # 9397

Related Pages