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
