Do you have Callpickup on Hunt Lists enabled?
If yes, then you are hitting CSCsc95859: After implementing CSCsb42763, can't view or delete hunt pilot.
Symptom:
Hunt Pilot can't be viewed or deleted after a delete if feature CSCsb42763 (Call Pickup for hunt lists) is implemented.
Conditions:
Association to hunt list will be deleted, the hunt list will no longer shown in the hunt pilot page or the record will no longer be in the DeviceNumPlanMap table.
Workaround:
To remove pilot points (similar to what we tried last time, but from a different table).
1). Open MS SQL Enterprise Manager
2). Open Databases -> CCM030XX -> Tables -> right click NumPlan -> Open Table
-> Return all rows.
3). Click on the fourth icon (SQL) and it will present a query box.
4). Paste the following and add the hunt pilot DN, SELECT * FROM NumPlan WHERE (DNOrPattern = '') 5). Note the pkid of this record.
6). Remove the select query and paste, delete from PickupGroupLineMap where fkNumPlan_Line =''
7). Remove the delete query and paste, delete from NumPlan where pkid = ''
8). Return to step 4). And continue for other hunt pilots.
This is also fixed in CCM 4.2
HTH
//Jorge
