Vault Numbering
‎Oct 09, 2014
10:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Oct 09, 2014
10:48 AM
Vault Numbering
Windchill Admins,
I have a sql script that runs during our backup that documents the Vault name to the actual file name. I was reviewing it the other day and I found duplicate vault names to different file names. I am pretty sure that I should NOT have duplicate vault names. I have been waiting for 2 days for PTC Tech Support to respond back.
Does anyone know why there could be duplicate vault names?
*****SQL Script*********
spool report_object_name.txt;
column vaultname format a35
column filename format a35
select to_char(fvi.uniquesequencenumber, '0000000000000x') as VaultName, ad.filename
from fvitem fvi, applicationData ad
where fvi.ida2a2=ad.ida3a5
and ad.filename like '%%'
and ad.filename!='{$CAD_NAME}'
UNION
select to_char(fvi.uniquesequencenumber, '0000000000000x') as VaultName, m.CadName as Filename
from EPMDocumentMaster m, EPMDocument d, HolderToContent htc, ApplicationData ad, FVItem fvi
where d.ida3MasterReference=m.ida2a2 and htc.ida3a5=d.ida2a2
and htc.ida3b5=ad.ida2a2 and ad.ida3a5=fvi.ida2a2
and m.cadName like '%%'
;
spool off;
exit;
*****Sample of report with duplicates******
VAULTNAME FILENAME
I have a sql script that runs during our backup that documents the Vault name to the actual file name. I was reviewing it the other day and I found duplicate vault names to different file names. I am pretty sure that I should NOT have duplicate vault names. I have been waiting for 2 days for PTC Tech Support to respond back.
Does anyone know why there could be duplicate vault names?
*****SQL Script*********
spool report_object_name.txt;
column vaultname format a35
column filename format a35
select to_char(fvi.uniquesequencenumber, '0000000000000x') as VaultName, ad.filename
from fvitem fvi, applicationData ad
where fvi.ida2a2=ad.ida3a5
and ad.filename like '%%'
and ad.filename!='{$CAD_NAME}'
UNION
select to_char(fvi.uniquesequencenumber, '0000000000000x') as VaultName, m.CadName as Filename
from EPMDocumentMaster m, EPMDocument d, HolderToContent htc, ApplicationData ad, FVItem fvi
where d.ida3MasterReference=m.ida2a2 and htc.ida3a5=d.ida2a2
and htc.ida3b5=ad.ida2a2 and ad.ida3a5=fvi.ida2a2
and m.cadName like '%%'
;
spool off;
exit;
*****Sample of report with duplicates******
VAULTNAME FILENAME
Labels:
- Labels:
-
Other
2 REPLIES 2
‎Oct 09, 2014
01:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Oct 09, 2014
01:24 PM
When a Save-As is done Windchill doesn't create a new vault file. Same goes for revisions.
Mike Foster
ATK
Mike Foster
ATK
‎Oct 09, 2014
03:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎Oct 09, 2014
03:28 PM
Duplication likely has to do with duplication of content for replication or caching purposes. The same file grabbing a different sequence number and thus different vault file name.
Sent from XFINITY Connect Mobile App
Sent from XFINITY Connect Mobile App