Remedy Smart Reporting Troubleshooting Performance Issues

Version 122
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    Smart Reporting Remedy


    APPLIES TO:

    Smart Reporting - All versions



    PROBLEM:

    Symptom:
    - Navigation is slow in Smart Reporting Console
    - No data while fetching/refreshing the reports.

    Reproducing the Issue:
    - Cross Launch to Smart Reporting from Midtier/Smart IT takes longer time than expected.
    - Smart Reporting navigation is slow.
    - No data while fetching/refreshing the reports.


    CAUSE:

    Smart Reporting DB is full due to cache


    SOLUTION:

     

      Verify which of the following behaviors apply to the issue:

    1) Slowness with the navigation:
      
      A. If Cross-launch from Midtier/Smart IT is taking longer than expected, then go through the following steps:
      
      - The default entry home page might be set to ‘Dashboards’.   To fix this, change the default home page to either ‘Timeline’ or ‘Browse’.
      
      - For a user who has never accessed Smart Reporting, set the entry page as ‘Browse’.
      
      - For a user who has accessed Smart Reporting without making any changes, set the entry page as ‘Browse’.
      
      - For a user who has accessed Smart Reporting and changed the entry page, set the entry page as set in the display settings by user.
      
      - If the user changes the personal display preferences, then the global settings do not apply to the user. To update the default entry page for all the users, use the below query in the smart reporting database:
      
      UPDATE Configuration SET ConfigData ='Browse'  WHERE ConfigCode = 'DEFAULTENTRYPAGE' AND IpOrg = 1
      
     
      Refer to this video:
      
     
      
      Note: IPOrg ='1' is for the default organization, change the iporg value while updating this for client organizations. Each client org will unique Ip Org value.
      
      Restart the Smart Reporting service and Default entry page = ‘Browse’ will be applied globally to all the users.
        
    B. If navigation is slow in the Smart Reporting console, then check the steps below:
      
      - Apply the tomcat tuning following the below:
         
      - For Windows you can follow next video: https://youtu.be/6N4lmEislWw
      
      - For non- windows you can follow next video: https://youtu.be/6N4lmEislWw?t=170
      
        
      
      - Check the size of Event, Event Archive and DocumentData tables in the Smart Reporting repository database.
      
      Event table: This table stores all YellowFin usage data, such as ; User logins, Running reports, Imports/exports. This data is all used for auditing only.
    EventArchive table: This table stores all of the archived event data, so the data here is simply data that was moved from the 'Event' table after a specified period.
      
      There is a possibility that Event and Event Archive tables count might go to some millions of rows. We can straight away truncate both the tables.
      
        
      
     
      Truncate table Event;
    Truncate table Eventarchive;
      
       
      
      Apply the below tuning to keep the number of records in the Event and EventArchive tables under control, this is good practice because these tables can get quite big as they record many different types of Yellowfin events.
    The way to create these 2 jobs and configure the number of days is by running the following 2 queries, keeping in mind that the last value of each INSERT query represents the number of days.
      
       
      
      --. Archive tasks from the EVENT table, the job runs every day, searches for events older than xnumber of days ( eg. 30 days).
      
       
      
      INSERT INTO Configuration
    VALUES (1, ‘SYSTEM’, ‘EVENTMAXDAYS’, 30)
      
       
      
      --. Delete records from the EVENTARCHIVE table older than x number of days ( eg. 60 days).
      
       
      
      INSERT INTO Configuration
    VALUES (1, ‘SYSTEM’, ‘EVENTARCHIVEMAXDAYS’, 60)
      
     
      Again, value 1 is for default org, change the value to Ip org of the tenant.
     
      
       - DB clean up queries.txt (attached)
      
       
      
      - DocumentData table: This table stores a lot of report related data. Not meta-data, actual data. Such as; Cached report result sets. There are a set of delete queries to shrink this table and attached it here.  Do not Truncate Document Data table Directly.  
     
      Once the document data is cleared, set the report folders option “Keep the latest result set”. 
      
      
           User-added image   
      
     
      This has to be done for all the folders manually or with the below SQL we can apply this setting for all the folders:
      
        
      
      - UPDATE ContentManagement SET VersionHistoryRequiredFlag=false; 
      
      
      This setting will make sure the report cache does not grow again. With the above configuration, smart reporting performance should definitely improve.
      
     
      Refer to this video: 
      
      
     
      
       
    2) While fetching/refreshing the reports.
      
      If the Slowness is observed while refreshing the reports, disable the RLS implementation and increase the API timeout following the attached and the below video and documents attached:

      Disable-New-RLS-Implementation.pdf  (attached)
    - Steps to increase AR API timeout.docx  (attached)
     
      
      
     
      
     
      

     


    Article Number:

    000151842


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles