Does anything show up when you right click on the Revision Number or Revision Number Component and select 'Show Usages' in the admin tool?
Hey Jim, Yes the in that dialog they both shoul State that have been deleted from the workflow. I've even now deleted the workflow completely from the Admin tool and the both still display usage, referring to the states in the workflow that no longer exists.
I think some old version of EPDM didn't properly remove revision numbers from states when you deleted them so that can sometimes follow a workflow around. You can run this query to see if there's anything floating around and get you VAR involved since you're almost certainly going to have to do a direct edit to the database to fix this:
SELECT w.name as workflow, s.name as state,
when 0 then 'No'
end as [State Enabled],
rn.name as [Revision Number], rg.name as [Revision Component]
FROM Status s
inner join Workflows w on w.WorkflowID = s.WorkflowID
inner join RevisionNumbers rn on rn.RevNumID = s.RevNumID
inner join RevNumGenerator rng on rn.RevNumID = rng.RevNumID
inner join RevGenerator rg on rng.RevGenID = rg.RevGenID
Charley. I just may have to contact my VAR. i'll also look into your suggestion.