OSHA Sync & Checklist Issues
Multiple ‘active’ profiles assigned (in the database) to the same ‘nProfileNum’ will cause an issue. As a result, the sync data will tell the VACs that they need N checklists for profile P, but then sending out 2N checklists that are assigned to profile P. The VACs would mix/match the checklists they needed and get confused.
by running this query you can confirm if this is the case:
select nprofilenum, Count(*) from tprofile where dtdeleted is null group by nprofilenum having count(*) > 1
If rows are returned, there’s a problem.