cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

EPM Document UML, file store, vault in PDMLink

Highlighted
Newbie

EPM Document UML, file store, vault in PDMLink

Hello,

I am a new user of Windchill PDMLink. I am exploring this topic and have read a couple of User Guide, SQL Queries and lot of discussions on this group.

Currently the below knowledge is scattered with me and I wanted help to understand them

I have come across some basic queries related to PDMLink:

1. FvVault and Vaults Topic:

  • In the Help Topics I have learnt to create a folder, vault, but I am not able to mount or link a folder to the created vault.

  • Is this true: Default, if we do not create the vaults manually, does PDMLink store everything onto "C:\ptc\Windchill_10.2\Windchill\vaults\defaultuploadrootfolder\defaultuploadrootfolder_Folder_1"

  • Do we need to create a vault structure for uploading the creo files from embedded browser (through workspace: upload CAD Documents process is known to me and could successfully do it).

2. I am basically curious to know how PDMLink stores the CAD Document (EPM Document) data. I have also checked EPMDocument, EPMDocumentMaster, EPMMemberLink, EPMReferenceLink tables (and uniqueLinkId, uniqueNDId).

3. I want to extract file path of each CAD Document on disk or know how to build this path.

For eg. In the DemoData of Golf_Cart, I could see some creo related files at

C:\ptc\Windchill_10.2\Windchill\loadFiles\pdmlink\demodata\GolfCart

Whereas, for Drive System, I am unable to get the location for the same.

I am able to extract properties like create date, modify date, file size, cadname, name, documentnumber, authoring application, docType, State, Version

Could you please guide me further on this.

Thank You in advance.

Regards,
Kalyani H


20 REPLIES 20

Re: EPM Document UML, file store, vault in PDMLink

With valuting not set up (e.g forceContentToVault=false), the system actually stores the huge CAD files in the Oracle database on disk as BLOBS.  This is the default condition after Windchill is installed.

When you set the related properties correctly, the system pretty much manages vaulting automatically.  The only reason to get into this further really, is just for understanding, not really needed for Windchill admin work.  There are some interesting query builder reports that can relate what you see on disk in the vault folders with what users see.

Re: EPM Document UML, file store, vault in PDMLink

By the way, I believe the golf cart is supplied with WTParts and viewables of CAD, but no actual CAD files, so no EPM Docs.

Re: EPM Document UML, file store, vault in PDMLink

Hello Mike,

Thank you for the prompt response.

I learnt from your response about how Windchill stores the data in both the cases- Vault and if no Vault created as BLOBS.

Further, I created a Vault, mounted it (using the UserGuide document). In the database query, I could see the Vault details under FvVault and FvMount tables.

As suggested by you, I did set the forceContentToVault=true using xconfManager utility. Further, I created a Part and checked the FvFolder and FvItem tables. However, unfortunately both seem to be empty.

Could you guide me to analyse if I missed any more steps in this process? Any possible reference link or document to insert EPM Document type of files in this newly created Vault would be of great help.

Thank You in advance.

Regards,
Kalyani H

Re: EPM Document UML, file store, vault in PDMLink

Kalyani Homkar wrote:

Hello Mike,

Thank you for the prompt response.

I learnt from your response about how Windchill stores the data in both the cases- Vault and if no Vault created as BLOBS.

Further, I created a Vault, mounted it (using the UserGuide document). In the database query, I could see the Vault details under FvVault and FvMount tables.

As suggested by you, I did set the forceContentToVault=true using xconfManager utility. Further, I created a Part and checked the FvFolder and FvItem tables. However, unfortunately both seem to be empty.

There is no content for a WTPart (Part). Creating a WTPart will only create database entries. You will have to create a document of some type ie checkin a cad prt/asm or create another type of document in which you upload a local file.

Re: EPM Document UML, file store, vault in PDMLink

Hello,

Thank You for your response.

I have tried this above method. It still gives me no record in above mentioned fvItem table.

Summary of my steps:

1. Created a Vault- Cache

2. Folder is created and Mounted.

3. In Windchill install folder, I could see the mount_validation_data file created and attached (db_snapshot_vault created.png) or below snapshot.db_snapshot_vault created.png

4. I am able to query Folders that is fvFolder table.

5. Further, through Creo Parametric, I have uploaded a brick.prt file and checked in the same in the workspace created previously as below:

WC_Workspace.png

In fvItem, I am still not having any entries for above process.

I could see some data file in nsepmcachevaultfolder_Folder_1 snapshot above. If Windchill has stored this file here, I wanted to know its BLOBS details or table that stores this information (applicationdata table gives me the file size).

Or

Feel free to guide me if I have missed some step to get the data in fvItem table which is not happening currently.

Thank You in advance.

Regards,
Kalyani Homkar

Re: EPM Document UML, file store, vault in PDMLink

Kalyani: There are several articles on PTC's web site with queries that deal with finding the filename/folder/vault for particular files. Take a look at these 2 for starters:

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS238721

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS39037

For Creo Parametric files the first 12 lines are text so using a utility like head you can easily see if the 2 files in your fileVault folder are the ones you uploaded and checked in. So if you were on a unix os you could do something like this:

cd /opt/ptc/Windchill_10.2/Windchill/vaults/<rest of path...>

head -12 000000000f95da

Re: EPM Document UML, file store, vault in PDMLink

Hello,

Thank You for the prompt response.

As mentioned earlier, in my 'fvItem' table I see no records. Hence, the queries suggested by you or the ones I could find in discussion groups will not give me any result.

My query is, Why it is not giving any entry for the 'fvItem' Table or How can we have a entry in this step.

For eg, when I upload a document I could see its entry in the 'EPMDocumentMaster' table. But to get its Vault details when I used above query or just try to fetch top 100 records of 'fvItem' table, it displays no records found.

Could you please guide me on this further? I wanted to understand the Vaults and how we can fetch these details for a uploaded document from Creo or any other CAD System.

Regards,
Kalyani Homkar

Re: EPM Document UML, file store, vault in PDMLink

Hi,

Thank You for the response.

I tried the below query:

SELECT

dm.documentNumber DNUMBER,

sys.fn_varbintohexsubstring(0,CAST(fvitem.uniqueSequenceNumber AS VARBINARY(7)),1,0) "FileInFolder",

fm.path IN_PATH,doc.versionIdA2versionInfo,doc.iterationIdA2iterationInfo,

folder.name FOLDER_NAME,fh.hostName IN_SERVER,

fvitem.uniqueSequenceNumber

FROM

    wcadmin.wcadmin.EPMDocumentMaster dm,

    wcadmin.wcadmin.EPMDocument doc,

    wcadmin.wcadmin.HolderToContent h,

    wcadmin.wcadmin.ApplicationData app,

    wcadmin.wcadmin.FvItem fvitem,

   wcadmin.wcadmin.FvFolder folder,

   wcadmin.wcadmin.FvMount fm,

   wcadmin.wcadmin.FvHost fh

WHERE

     doc.idA3masterReference = dm.idA2A2

    AND dm.documentNumber = 'RISER.PRT'

    AND doc.versionIdA2versionInfo ='A'

    AND h.idA3A5 = doc.idA2A2

    AND h.idA3B5 = app.idA2A2

    AND app.idA3A5 = fvitem.idA2A2

    AND fvitem.idA3A4 = folder.idA2A2

    AND fvitem.idA3A4 = fm.idA3A5

    AND fm.idA3B5=fh.idA2A2

    AND doc.iterationIdA2iterationInfo ='1'

     AND app.fileName='{$CAD_NAME}'

But still it fetches no record. I think I am not able to add files in the Vault correctly.

On your machine via SQL Query or SQL Server Management Studio, if we query 'fvItem':

"select top 10 * from fvItem;"

Does this show any records?

Regards,
Kalyani Homkar

Re: EPM Document UML, file store, vault in PDMLink

Yes, It's showing the Records.

FVItem.jpg

Thanks,

Bhagirath