cm 4.1-3 error

Answered Question
Nov 14th, 2006
User Badges:

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

Correct Answer by jbarcena about 10 years 9 months ago

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

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Correct Answer
jbarcena Tue, 11/14/2006 - 05:56
User Badges:
  • Red, 2250 points or more

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

Actions

This Discussion