We are trying to export a workflow. We have solidworks epd 2012 sp 2.
We went thru to make sure our notifications were not going to groups that have been deleted.
Any ideas on how to fix it so we can export the workflow?
It could be you transition conditions. If you rename a variable after you've created a condition using it, it won't update the name so it will try to export a variable that doesn't exist. You can verify if that's the case using this query, if it comes back with anything you should check that transition and update the conditions:
SELECT name, VariableName
FROM TransitionCondition tc
inner join Transitions t on t.TransitionID = tc.TransitionID
where CondType = 2
and VariableName not in (select VariableName from Variable)
We went ahead and deleted out all of our notifications. (not the most fun solution) And it seemed to fix the problem.
Just for future reference this query should be able to find any notifications that point at deleted groups, just exclude the where clause if you want to see where all your notifications are assigned:
SELECT t.Name, nu.Username, ng.groupid, ng.Groupname
from Notifications n
left outer join ( select NotificationID, u.Username, u.Enabled from NotificationUsers nu
inner join Users u on nu.UserID = u.UserID) nu on n.NotificationID = nu.NotificationID
left outer join (select NotificationID, ng.groupid, groupname from NotificationGroups ng
left outer join Groups g on g.GroupID = ng.GroupID) ng on n.NotificationID = ng.NotificationID
inner join Transitions t on t.TransitionID = n.TransitionID
where GroupID is not null and Groupname is null
Retrieving data ...