Error retrieving dashboard views. Could not initialize Dashboard component

Version 1
    Share:|

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


    PRODUCT:

    Track-It!


    APPLIES TO:

    BMC Track-It!



    PROBLEM:

    While attempting to login to Technician Client, the following error may appear: Error Retrieving Dashboard Views. Could Not Initialize Dashboard Component Additional Information: Business.Dashboard.002 -- Invalid column name 'AttributeName_LOCAL'. [System.Data.SqlClient.SqlException] The error usually appears twice and may be followed by other errors if an attempt is made to login again without closing the login screen first. For example, a message indicating that your current login is already in use may appear, followed by: Unknown error Additional Information: AOM.AddIn.008 -- An item with the same key has already been added. [System.ArgumentException]


    SOLUTION:

    This occurs when the TrackitApp server login is associated with the Sysadmin server role. For Track-It! to function normally, this user should not be associated with any server roles. Instructions:

      SQL 2005
         
      1. Launch the SQL Server Management Studio.
      2.  
      3. Connect to the Track-It! SQL Server and login with an SA or equivalent account.
      4.  
      5. Expand the Databases folder.
      6.  
      7. Expand the current Track-It! 8 database, expand the Security folder, and then click on "Users".
      8.  
      9. Take note of the exact name of the "TrackItApp" user shown on the right (may be TrackitApp, TrackitApp_1, _2, _3, etc.)
      10.  
      11. Collapse the Databases folder under the server name and expand the Security folder.
      12.  
      13. Click on Logins.
      14.  
      15. On the right side, right-click the "TrackItApp" user that was noted above and then select Properties.
      16.  
      17. In the upper left, click on Server Roles and then disable all Server Roles that the user is a member of.
      18.  
      19. Click Ok to save the changes.
         SQL 2000
         
      1. Launch the Enterprise Manager for SQL server (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager).
      2.  
      3. Expand the name of the SQL Server and then expand the Databases folder.
      4.  
      5. Expand the current Track-It! 8 database and click on "Users".
      6.  
      7. Take note of the exact name of the "TrackItApp" user shown here (may be TrackitApp, TrackitApp_1, _2, _3, etc.)
      8.  
      9. Collapse the Databases folder and expand the Security folder.
      10.  
      11. Click on Logins.
      12.  
      13. Right-click the "TrackItApp" user that was noted above and then select Properties.
      14.  
      15. Under the Server Roles tab, disable all Server Roles that the user is a member of.
      16.  
      17. Click Ok to save the changes.
      The error should no longer appear when logging into Technician Client. 

        

       


      Article Number:

      000009017


      Article Type:

      Solutions to a Product Problem



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