Most of our problem family tables came from migrated data. The ft_version did not exist in Intralink 3.X. When we migrated the system assigned those values.
Find a family table that was migrated and one that was created new in PDM Link then run this query on them.
select
doc.idA2A2 doc_id
, doc.idA3masterReference doc_mas_id
, dm.CADName cadname
, (doc.versionIdA2versionInfo +
(case WHEN doc.oneOffVersionIdA2oneOffVersi is NULL then('.')
else doc.oneOffVersionIdA2oneOffVersi + '-'
end ) + '.' + doc.iterationIdA2iterationInfo ) ver
,doc.updateStampA2 last_mod_date
, doc.latestiterationInfo doc_isLatest
, doc.statecheckoutInfo doc_co_state
, (case doc.familyTableStatus
when 0 then ''
when 1 then 'inst'
when 2 then 'gen(t)'
when 3 then 'gen(m)'
else 'uknown'
end ) ft_status
, ci.idA3B5 ft_id
, (ft.versionIdA2versionInfo +
(case WHEN ft.oneOffVersionIdA2oneOffVersi is NULL then('.')
else ft.oneOffVersionIdA2oneOffVersi + '-'
end ) + '.' + ft.iterationIdA2iterationInfo ) ft_ver
, ft.idA3masterReference ft_mas_id
, ft.statecheckoutInfo ft_co_state
, vl.idA3B5 gen_id
, doc.createStampA2 doc_create_date
, ft.createStampA2 ft_create_date
, doc.idA3C2iterationInfo doc_predecessor
, dm.authoringApplication authoring_app
from
EPMDocument doc
left join EPMContainedIn ci on doc.idA2A2 = ci.idA3A5
left join EPMSepFamilyTable ft on ci.idA3B5 = ft.idA2A2
left join EPMVariantLink vl on doc.idA2A2 = vl.idA3A5
join EPMDocumentMaster dm on dm.idA2A2 = doc.idA3masterReference
left join EPMSepFamilyTableMaster ftm on ftm.idA2A2 = ft.idA3masterReference
where
(ftm.idA2A2 in (
select distinct ftt.idA3masterReference
from EPMDocument d
join EPMDocumentMaster dmm on dmm.idA2A2 = d.idA3masterReference
join EPMContainedIn cii on d.idA2A2 = cii.idA3A5
join EPMSepFamilyTable ftt on cii.idA3B5 = ftt.idA2A2
where dmm.CADName ='lp_bushing_w-step_hasco_metric.prt'
)
)
order
by ft_mas_id, ci.createStampA2, ft_id, cadname;
