Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

cm 4.1-3 error

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

thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: cm 4.1-3 error

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

2 REPLIES

Re: cm 4.1-3 error

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

New Member

Re: cm 4.1-3 error

thanks

392
Views
5
Helpful
2
Replies
CreatePlease to create content