When scrolling down through recently viewed Projects, the tabs Pending and History appear occasionally and reappear occasionally

Version 1

    [SYMPTOM]

    When scrolling down through recently viewed Projects, the tabs Pending and History appear occasionally and reappear occasionally

     

     

    [REASON]

    A potential reason might be that the HISTORY_ITEM (the recently viewed Projects) does have a corrupt entry for one of the recently viewed items (Projects), which should be also visible as 2 entries for the same project. As soon as getting to this 2nd Project the field contents should shift and company shows now instead of a company name a GoldMine USERNAME (which would be usually the manager) etc. When now the next Project will be opened the Pending and History tab may vanish or vice versa then also re-appear

     

     

    [RESOLUTION]

    While it is always recommended to make sure to have a full running backup of the GoldMine database and also, in this case, deleting items from the HISTORY_ITEMS table will not delete any contact record data from GoldMine and will only remove recently viewed items

     

    1. In SQL Server Management Studio

    2. New Query on the GoldMine database

    3. Adjust/Enter the following query and execute it against the GoldMine database

     

     

    Delete from History_item where userid ='impacted username' and type_code ='3'

     

    Type_Code 3 relates to Projects -  see also What is the purpose of the HISTORY_ITEM table?

    4. Retest behavior and now it should not be replicable anymore