Remedy Smart Reporting - Missing fields and empty views

Version 1
    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:

    All versions of Smart Reporting



    PROBLEM:

    If Smart Reporting becomes disconnected from the data source during editing/cloning of a view, or while editing a report, an issue may appear in the form of views that present incomplete lists of fields in step 2 of the view builder and in reports. Since Yellowfin did not receive the complete result set, it concluded that the columns were no longer in the tables, and marked them as ‘DISCONNECTED’ in its configuration database. This is the same behavior that we would see if a table’s structure was actually altered, and a column was removed, for example. This issue will also often result in reports and dashboards that are unable to run.


    CAUSE:

    Most common cause are network issues


    SOLUTION:

     

    To fix this, some queries will have to be run directly against Smart Reporting configuration database. This is something that should only be done by your Database Administrator, as running malformed queries can severely damage your Yellowfin instance. 

      

    Step 1:    Shut down Yellowfin

      

    Step 2:    Make sure that there is a recent backup of the Yellowfin configuration database available

      

    Step 3:    Run the following query against the Yellowfin Configuration Database to confirm that there is a count of fields marked as                'DISCONNECTED'


    SELECT a.ViewId,a.ViewDescription, b.ViewDescription, c.statusCode, COUNT(c.columnName)
    FROM ReportView a
    INNER JOIN ReportView b ON (a.viewId = b.parentviewId OR a.viewID = b.viewId)
    LEFT OUTER JOIN ReportFieldTemplate c ON (b.viewId = c.viewId)
    WHERE c.statusCode = 'DISCONNECTED'
    GROUP BY a.ViewId,a.ViewDescription, b.ViewDescription, c.statusCode ORDER BY 1

      

     

      

    Step 4: Cross reference the reportview table to learn what ViewID belongs to the named view that is experiencing issues

      

    Step 5: Run the following query while replacing ***** with the ViewID from Step 4.


    UPDATE ReportFieldTemplate SET StatusCode = 'OPEN'
    WHERE (ViewId = '*****' Or ViewId IN (SELECT ViewId FROM ReportView WHERE ParentViewId = '*****') ) AND StatusCode =            ‘DISCONNECTED’

      

    Step 6: Restart Smart Reporting and verify that the views and reports are behaving as expected.

    Original post from the vendor: https://community.yellowfinbi.com/knowledge-base/article/how-to-fix-fields-missing-from-step-2-of-view-builder-and-reports

     


    Article Number:

    000174146


    Article Type:

    Solutions to a Product Problem



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