Skip to main content
14-Alexandrite
August 19, 2024
Question

Assistance Needed with Decrypting Encrypted Attachment Files in Windchill Vault Folder

  • August 19, 2024
  • 3 replies
  • 2050 views

Windchill_12.1\Windchill\vaults\defaultsystemrootfolder folder. I want to decrypt these files so that I can check the files within the attachments from this location, but I can't access them because they are encrypted. I can't tell which files are PDFs. Could you help me with this issue?

 

Note: The files appear encrypted with names like 000000000000a8.

3 replies

HelesicPetr
22-Sapphire II
22-Sapphire II
August 19, 2024

Hi @ozclkonur 

They are not really encrypted they are just saved with some database sequence. 

If you rename the file to correct one, you can open it.. 

 

If you need to find correct file name you have to go to the database and find the correct file.

Here is a description how to find the file vault name based on epm number

but you can change some conditions and you will find what you need.

CS322648 - Find vault file path for WTDocument or EPMDocument objects in Windchill PDMLink

 

PetrH

ozclkonur14-AlexandriteAuthor
14-Alexandrite
August 19, 2024

This is the part I mentioned. There are such files inside the vault, and I assume these are the files within the attachment. However, the existing files do not have extensions, and their names are also different.

avillanueva
23-Emerald I
23-Emerald I
August 19, 2024

Yes, the vaults list files (unencrypted) based on a hexadecimal value stored in FVItem table. Your not expected to try and access files with extension from this location. All metadata about this file is stored in the database. A SQL query is needed for you to reverse this and extract the actual filename from the database matching what you see in that image. Any reason the web interface cannot help you in this area?

avillanueva
23-Emerald I
23-Emerald I
August 19, 2024

Agree with @HelesicPetr . Any reason you are at such a low level access the files in the vault?

ozclkonur14-AlexandriteAuthor
14-Alexandrite
August 19, 2024

Honestly, I’m not familiar with the permissions. I logged in directly from the account where Windchill is installed. If this issue is due to unauthorized access, I would appreciate it if you could assist me with this. Where can I obtain the necessary permissions?

avillanueva
23-Emerald I
23-Emerald I
August 19, 2024

Your system should have an administrator account or person who can grant you access. 

23-Emerald III
August 19, 2024

Let's back up a step.

Why do you need to find the file type of the attachments and content files contained in the Windchill file vaults?

What are you doing with the files that you need this information?

Since you are looking in the vault folders directly, you are seeing the hashed filename that is assigned by the Windchill database using a sequence generated number. You can open these files in any simple text editor (Wordpad, Notepad, Notepad ++, etc.) and see some of the data that is in stored as ASCII text. Most of the file contains binary data and is not man readable.

I doubt file permissions within Windchill have anything to do with what you are trying to do, but they are controlled from the information in Site/Utilities/Policy Administration.

avillanueva
23-Emerald I
23-Emerald I
August 19, 2024

Agreed, permissions in Windchill have nothing to do when you are at the server looking at the vault folders.