Track-It 20.xx: Public Views are missing or not visible to all technicians.

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:

    Track-It!


    COMPONENT:

    Track-It! 2020 R2


    APPLIES TO:

    Track-It! 20.xx



    PROBLEM:

    Public Views created in Track-It! 20.xx are missing or not visible to all technicians.


    CAUSE:

    There is/was a problem inserting the quickview into the Track-It! 20.xx database.


    SOLUTION:

     

      1. Open SQL Server Management Studio (SSMS) and connect to the Track-It! 20.xx database.   
    2. Make sure you have a fresh backup    How to backup Track-It! 2020 database.  
    2. Open a new query window and run the below SQL script against the database:  
      
      
      declare @qry int  
    declare curs_view cursor for  
    select  SEQUENCE  from [dbo].[QUERY]  
    where [SEQUENCE] not in (select [SEQ_QUERY]  
    from [dbo].[QUERYSINFOLDERS] ) 
      
      open curs_view  
    fetch next from curs_view into @qry 
      
      while (@@fetch_status = 0)  
    begin 
      
       insert into [dbo].[QUERYSINFOLDERS] values ( 
      
       (select max(sequence)+1 from [dbo].[QUERYSINFOLDERS]),  
     getdate(),1,@qry) 
      
       fetch next from curs_view  
     into @qry  
     end 
      
      close curs_view  
    deallocate curs_view 
      
      update [dbo].[SMSYSRECNUM] set RECNUM = (select max(sequence) from [dbo].[QUERYSINFOLDERS]) where name = 'QUERYSINFOLDERS' 
      
     
    3. Once the above script completes execution, perform an IIS Reset on the Application server to reload the metadata.  
    4. Ask the affected Technician/s to verify by logging out and logging back in if the Public Views are now showing as expected. (Clearing of Browser cache might be required in some cases). 

     


    Article Number:

    000365931


    Article Type:

    Solutions to a Product Problem



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