Skip to main content
R
rherscher-21-Visitor
1-Visitor
April 17, 2024
Question

Can not remove Replica folder, it contains Cached items

  • April 17, 2024
  • 1 reply
  • 1024 views

Decommissioning a Replica server. Got to the spot where you delete the cache folder and get the following: "Can not remove Replica folder, it contains Cached items.". Force sync has been run, Utilities show zero files in cache, and the SQL command in article CS53215 produces no rows. The SQL command in article CS56569 looks promising (delete from masteredonreplicaitem where ida3a4 = <IDA2A2_OF_FOLDER>). How would I get the IDA2A2 value for the folder? This is Windchill PDMLink 11.1.

    1 reply

    HelesicPetr
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    April 18, 2024

    Hi @rherscher-2 

    I use MSSQL but it is almost same in oracle.

    you just need to set the name of your folder. 

     

    select idA2A2,name,* from wcuser.wcuser.FvFolder
    where name = 'defaultSystemfolder_folder_1'

     

    to be sure you can use select for the the row you are going to delete

     

    select * from wcuser.wcuser.MasteredOnReplicaItem
    where idA3A4 = <IDA2A2_OF_FOLDER>

     

    PetrH

    R
    rherscher-21-VisitorAuthor
    1-Visitor
    April 18, 2024

    Thanks for that suggestion – that seemed like it would work. Unfortunately, table FvFolder doesn’t have an entry for any of this replica’s cache folders (or any %cache% folders for that matter). We’re retiring our Windchill so it’s not a huge deal to not be able to decommission this replica – it’s just one of those loose ends that I’d like to tie up.

    HelesicPetr
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    April 19, 2024

    Hi @rherscher-2 

    So if you select all the rows from MasteredOnReplicaItem that are not linked to real folder, then I guess you can delete it 😄 

    But I would investigate why the MasteredOnReplicaItem table contains a rows that are not linked to the real folder.

    PetrH

    Terms & ConditionsCookie settingsAccessibility statement