When I try and click into a hunt pilot I get this error
The following error occurred while attempting to retrieve and display the requested information:
Error No. 1557:
CDBLException Dump: [ActiveX object not initialized via insert or select]
this is only on one hunt pilot
Do you have Callpickup on Hunt Lists enabled?
Hunt Pilot can't be viewed or deleted after a delete if feature CSCsb42763 (Call Pickup for hunt lists) is implemented.
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.
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