This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Track-It! 2020 R2
Public Views created in Track-It! 20.xx are missing or not visible to all technicians.
There is/was a problem inserting the quickview into 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 curs_view cursor for
select SEQUENCE from [dbo].[QUERY]
where [SEQUENCE] not in (select [SEQ_QUERY]
from [dbo].[QUERYSINFOLDERS] )
fetch next from curs_view into @qry
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).