Skip to main content
A
Aden5-Regular Member
5-Regular Member
April 4, 2023
Solved

Windchill's Blobs Tablespace is filling up quickly.

  • April 4, 2023
  • 1 reply
  • 1620 views

I use the Windchill 12.0.2.5 and Oracle Database. 

 

Our Database's Blobs tablespace is filling up quickly.

 

Almost it is filling up 1GB per day. Before 2023, Blobs table isn't filled up like this. 

 

How can I manage or reduce the amount of Blobs table space?

 

 

 

Best answer by HelesicPetr

Hi @Aden 

Someone forget to set the vault rule configuration on new context or you had set preference to force all content to vault

check following article: CS68929

if you do not use vault rules use setting wt.fv.useVaultsForAllContent=true 

hope this can help

 

PetrH

1 reply

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
April 4, 2023

Hi @Aden 

Someone forget to set the vault rule configuration on new context or you had set preference to force all content to vault

check following article: CS68929

if you do not use vault rules use setting wt.fv.useVaultsForAllContent=true 

hope this can help

 

PetrH

    M
    mmeadows-316-Pearl
    16-Pearl
    April 4, 2023

    Expanding on Petr's solution, if this is a legacy system and the BLOBS growth is just over the last few months, then most likely your master file vault and root folder have switched to read only.

    Site > Utilities > File Server Administration > Vault Configuration

    Double click on the vault and associated root folder to confirm they aren't read-only.

     

    Assuming you system is forcing content to vault via CS68929, manually revault to clean recover your BLOBS space.

    After releasing the space on SQL Server, you need to defragment (reorganize/rebuild) the database indexes.  There will be performance issues if you don't.  Ola Hallengren's index maintenance script works great. CS193197

     

      HelesicPetr
      22-Sapphire II
      HelesicPetr22-Sapphire II
      22-Sapphire II
      April 5, 2023

      Hi @mmeadows-3 

      Good point. If the useVaultsForAllContent is not set that the reason could be: the vaults are locked. 

      PetrH

      Terms & ConditionsCookie settingsAccessibility statement