Description

This page troubleshoots the issues where you have missing "no items to show" under FRAME PORTAL TRANSACTION 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

  • Compute snapshot
  • Open CED
  • Navigate to the view "FRAME PORTAL TRANSACTION VIEW"

Action Plan

  1. If you are in version 8.0.0 and you are using a license key without EFP, then please upgrade to the latest Cast AIP 8.0.x, this issue was fixed in 8.0.3. For internal purposes refer to CAST Engineering Dashboard - Risk Indicators - Transaction Level - No items to show in TWRI Risk Indicators - Transaction Level view - License without EFP- CAST Internal
  2. Apply the following page CAST Engineering Dashboard - Information - How to identify and execute SQL query involved in data display on the retreiver "RETRIEVER_TRANSACTION_LIST", if the manual execution of the query takes a long time then you are facing a performence issue:
    1. If you are using an AIP version lower then 8.2.6 and the aplication contain a big number of valid Transactions (you get the number of valid Transaction by refering to the section Summary of right hand panel options ofthe following official documentation: TCC - CAST Transaction Configuration Center - Right hand panel, then this is a known bug in CED. This is fixed in AIP 8.2.8. As a WA perform the following
      1. Install the proc FIXED_DSS_TRI_COMPUTE.sql on Central schema
      2. Create the table dss_tri_transaction on the central schema

         CREATE TABLE dss_tri_transaction
        (
          transaction_id integer NOT NULL,
          bc_id integer NOT NULL,
          snapshot_id integer NOT NULL,
          tri integer NOT NULL
        )
        WITH (
          OIDS=FALSE
        );
        ALTER TABLE dss_tri_transaction
          OWNER TO operator;
      3. Get the snapshot Id :

        SELECT Max(snapshot_id) 
        FROM   dss_snapshots 
        WHERE  application_id = <Application_ID> 

        You can get the application Id by refering to SQL Queries - CAST Central Base - Queries on applications - How to get the ID of the application
        Query result sample:

        2
      4. Execute the Fixed procedure on the snapshot Id retreived from the previous step:

        select DSS_TRI_COMPUTE (Snapshot_id);
      5. Run the following queries on the central schema:

        UPDATE viewer_parameters 
        SET    value = 
        ' SELECT   o.OBJECT_FULL_NAME           ,          o.OBJECT_ID AS TRANSACTION_ID,          l.TRI                    ,          CASE %dbtime_enabled%              WHEN 0              THEN -1              ELSE                (SELECT dbtime.METRIC_NUM_VALUE                FROM    %PREFIX%DSS_METRIC_RESULTS dbtime,                        %PREFIX%DSS_LINK_INFO dli                WHERE   dbtime.METRIC_ID       = 69018                AND     dbtime.OBJECT_ID       = dli.NEXT_OBJECT_ID                AND     dli.PREVIOUS_OBJECT_ID = o.OBJECT_ID                AND     dli.SNAPSHOT_ID        = dbtime.SNAPSHOT_ID                AND     dli.LINK_TYPE_ID       = 11002                AND     dbtime.SNAPSHOT_ID     = %snapshot%                )          END AS DBTIME,          CASE %cputime_enabled%              WHEN 0              THEN -1              ELSE                 (SELECT cputime.METRIC_NUM_VALUE                 FROM    %PREFIX%DSS_METRIC_RESULTS cputime,                         %PREFIX%DSS_LINK_INFO dli                 WHERE   cputime.METRIC_ID      = 69017                 AND     cputime.OBJECT_ID      = dli.NEXT_OBJECT_ID                 AND     dli.PREVIOUS_OBJECT_ID = o.OBJECT_ID                 AND     dli.SNAPSHOT_ID        = cputime.SNAPSHOT_ID                 AND     dli.LINK_TYPE_ID       = 11002                 AND     cputime.SNAPSHOT_ID    = %snapshot%                 )          END AS CPUTIME FROM  (SELECT o.OBJECT_ID,               o.OBJECT_FULL_NAME       FROM    %PREFIX%DSS_OBJECTS o       WHERE   o.OBJECT_TYPE_ID = 30002       )       AS o       JOIN  DSS_TRI_TRANSACTION            AS l         ON  l.TRANSACTION_ID = o.OBJECT_ID        AND  l.SNAPSHOT_ID =  %snapshot%        AND  l.BC_ID = %metric% ORDER BY %~ORDER_BY%     '
        WHERE  component_id = 'RETRIEVER_TRANSACTION_LIST' 
               AND id = 'SELECT_QUERY' 
        DELETE FROM viewer_parameters 
        WHERE  component_id = 'RETRIEVER_TRANSACTION_LIST' 
               AND id IN ( 'TEMP_TABLE_NAME', 'TEMP_COLUMNS', 'TEMP_INDEX', 
                           'TEMP_INSERT' ); 
      6. Restart the application web server
      7. Open CED and Examine TWRI view on the dashboard.
    2. Else If you are not using an AIP version lower then 8.2.6 or If you are using an AIP version lower then 8.2.6 but the aplication don't contain a big number of Transactions (you get the number of valid Transaction by refering to the section Summary of right hand panel options ofthe following official documentation: TCC - CAST Transaction Configuration Center - Right hand panel then refer to CAST Engineering Dashboard - Views - Hangs and performance issues - Archived.
  3. Check if transactions are available from TCC - Enhancement node - Right hand panel.
    1. If there are transactions, check if at least one object of the transacton is violating a Robusteness, Security or efficiency quality rule. You can get the list of objects composing the transaction from TCC - Enhancement node - Right hand panel section Upper right panel (Data Functions or Transactional Functions)).
      1. If no object of the transaction is violating the QRs, then there is no data, it's expected to get "No items to show" under FRAME PORTAL TRANSACTION VIEW.
      2. If objects of the transaction are violating the QRs, then contact CAST Technical Support and provide the Relevant input.
    2. If there is no transaction:
      1. If you are able to trace at least one Transaction end-to- end under Enlighten, then you are facing an issue of missing Transaction. Navigate to Transaction Configuration Center - AFP Calibration - Transactional Functions - Missing Links
      2. If you are not able to trace at least one Transaction end-to-end under Enlighten, there is no data, then it's expected to get "No items to show" under "FRAME PORTAL TRANSACTION VIEW".
  4. If the above steps do not resolve your issue, contact CAST Technical Support and provide the Relevant input.
Notes/comments
Ticket # 3086, 7167, 9677, 10929
Related Pages