Skip to main content
C
CG_104689821-Visitor
1-Visitor
July 10, 2023
Question

Vault data issue

  • July 10, 2023
  • 1 reply
  • 678 views

I am using Windchill Supplier Management Release 12.0 and Datecode with CPS 12.0.0.0

Could you please share with us the steps for copying the latest iteration of vault data?

1 reply

HelesicPetr
HelesicPetr22-Sapphire II
22-Sapphire II
July 11, 2023

Hello @CG_10468982 

 

What is your issue?

 

You can go to a database find the latest version of your object and find information about vault. 

and then just copy the file from a folder. 

 

select for EPMDocument to get vault information in MS SQL

 

select substring(convert(varchar(100),convert(varbinary(100), FVI.uniqueSequenceNumber, 256),2),3,14) vaultFileName,apData.idA3A5 as FvItem, apData.fileName ,MSTR.documentNumber, EPM.versionIdA2versionInfo,EPM.iterationIdA2iterationInfo, MSTR.CADName from wcuser.EPMDocument EPM 
INNER JOIN wcuser.HolderToContent CONTENT
 ON CONTENT.idA3A5 = EPM.idA2A2
 inner join wcuser.ApplicationData apData
 ON apData.idA2A2 = CONTENT.idA3B5
 inner join wcuser.EPMDocumentMaster MSTR
 on MSTR.idA2A2 = EPM.idA3masterReference
 inner join wcuser.FvItem FVI
 on apData.idA3A5 = FVI.idA2A2

 where MSTR.CADName like 'ASSEMBLY123.asm' and EPM.latestiterationInfo=1

 

then just use CTRL+C , CTRL+V in the correct folder

 

Hope this can help

 

PS> for family table there is little bit different select

PetrH

Terms & ConditionsAccessibility statement