Unable to delete calling search spaces

[Steve Baker]

I have been trying to remove all the data relating to one of our closed offices. I have managed to get rid of almost all of it except for 2 calling search spaces. When I try to remove them I get the following message:

	Error  occurred. One or more record did not get deleted. The  pkid column in  the callingsearchspace table in the database is being referenced from  another table.  Please check the dependency records, remove the  reference, and then try the delete again.
	27 records found

I have checked the dependency records for both and despite the indication of there being 27 records, they are both empty.

Is there any other way to search for where these may be referencing?

Running call manager 6.1.4

Thanks

Steve

[Aman Soi]

Hi Steve,

Just refer this URL .

https://supportforums.cisco.com/docs/DOC-28450

regds,

aman

[Chris Deren]

Another area you may find the CSS being referenced which does not show in dependency records is the BAT templates.

HTH,

Chris

[Anthony O'Reilly]

Hi,

I have this issue too.

I ran the sql query against the two options below and it returns nothing.

fkCallingSearchSpace_CFA (Forward All)
fkCallingSearchSpace_SCFA (Secondary Calling Search Space for Forward All)

I suspect that there is a phone with the calling search space that I am trying to deleted set on the unregistered call forward option on the device profile.

Is there any other option I can run this command against.

This is on Call Manager 7.1.5b

Thanks

Anthony.

[Aman Soi]

Hi Anthony,

Can u refer this URL and then, run the SQL query.

http://www.ucguerrilla.com/2012/04/cucm-sql-queries-listing-call-forward.html

regds,

aman

[Anthony O'Reilly]

Hi Aman,

Thanks for this url. The command below worked for two of my CSS but I still have one CSS left. I am almost sure that this CSS is referenced in one of these settings:

Forward Busy Internal

Forward Busy External

Forward No Answer Internal

Forward No Answer External

Forward No Coverage Internal

Forward No Coverage External

Forward on CTI Failure

Forward No Unregistered Internal

Forward No Unregistered External

run sql select n.dnorpattern, css1.name as primaryCSS, css2.name as secondaryCSS from numplan as n inner join callforwarddynamic as cdn on cdn.fknumplan=n.pkid left join callingsearchspace as css1 on cdn.fkcallingsearchspace_cfa=css1.pkid left join callingsearchspace as css2 on cdn.fkcallingsearchspace_scfa=css2.pkid where n.tkcfacssactivationpolicy = 1 or n.tkcfacssactivationpolicy = 0 order by n.dnorpattern

Thanks

Anthony.

[Aman Soi]

Hi Anthony,

I was just thinking if u could use the below query to list all CSS .from there, u can get partitions

http://www.ucguerrilla.com/2012/04/cucm-sql-query-series-installment-6.html

Now use this query to list all DNs assoociated with Partition.

http://www.ucguerrilla.com/2012/03/cucm-sql-queries-installment-3.html

redgs,

aman

[Anthony O'Reilly]

Hi Aman,

When I run the first query, I cannot see the CSS I am trying to delete in the output.

Is there a SQL query against the other forwarding types "Forward No Coverage" like there is for call forward all "fkCallingSearchSpace_CFA"

Thanks
Anthony.

[Aman Soi]

Hi Anthony,

No idea beyond this.

regds,

aman