Cannot delete CSS from cucm 9.1

[maqsood ahmed]

Hi !

I need to delete several  CSS from cucm 9.1 , but cannot ,, it throws an error  as written below.  

Even though i followed some post from ucgurella.com  and support forum ,,,i could not do so ,, they suggest to go thru CLI ,, but  every time i end wtih some errors or  the info  displayed is not relevant  to delete.   i could find the dependency of CSS thru gui  or  CLI . 

any body having the correct way to delete

error  "The pkid column in the callingsearchspace table in the database is being referenced from another table. Please check the dependency records, remove the reference"

[Manish Gogna]

Hi Maqsood,

If you have already tried the steps given in the following links and the issue persists then you shoulf engage TAC

https://supportforums.cisco.com/document/119616/unable-delete-couple-calling-search-space-form-cucm-page

http://www.ucguerrilla.com/2013/07/cucm-sql-queries-finding-that-css.html

HTH

Manish

[maqsood ahmed]

thank u manish !  appreciate u r response !

[maqsood ahmed]

Below are  SQL  query  to identify the problematic CSS !

run sql select * from callingsearchspace where name ="CSS-internal"

cli result:

pkid                   name description dialplanwizardgenid clause resettoggle tkreset tkpartitionusage
d1257ca3-e53a-f83b-5e8a-dabf97f2c0df CSS-internal REF NULL DAM_BRN_F2C3_R29:PT-Phones f 2 99

take the  PKID from the previous result:

run sql select pkid, dnorpattern from numplan where  fkcallingsearchspace_sharedlineappear = "d1257ca3-e53a-f83b-5e8a-dabf97f2c0df"

cli result:

pkid                                                             dnorpattern
==================================== ===========
6d84722f-b7e2-81cc-e76c-24b7f88a2349 3466578

then search for  dnorpattern  in cucm gui  : ex: 3466578  ,, from  phone template ... delete the template or change the css to different css...  

then delete the  problematic css:   CSS-internal

i got those query from TAC engineer !

[Chris Deren]

Common thing folks miss is an entity being assigned to BAT templates which does not show on the dependency records. Make sure there are no BAT templates referencing this CSS.