...
Stop CyReport Engine service.
Backup Database ‘CyTrack’
run, against the database:
delete from tblDirExtAcdStationState where id_ext not in (select id from tblDirExt)
Run, against the database:
with RetainedIds as (
select
max(id) as id
from tblDirPeopleACD
group by id_people, id_acd
)
delete from tblDirPeopleAcd where id not in (select id from RetainedIds)
Start CyReport Engine service.
Check that the sql:
select
id_people, id_acd
from tblDirPeopleACD
group by id_people, id_acd
having count(*) > 1
returns 0 rows.
Check that the sql returns 0 rows:
select * from tblDirExtAcdStationState
...