License file deleted BUT Counts are still showing

[Live2 Bicycle]

I have used the command line command "file delete license" to delete a bac license file tac issued me.  After deleting the file I restarted the Cisco CallManager service.

The counts are still showing up though when I go to System / Licensing / License Unit Report

I have even got in and deleted all the license files, restarted the Publisher and tried uploading the correct files again.  The system tells me the file has already been uploaded.

System version: 8.5.1.10000-26

Any one have any idea how to reset the license counts to default?

If I can reset to the defaults then I can upload the correct files again.

[Carlo Poggiarelli]

Hi.

Try to restart Cisco License Manager  service.

Cisco Unified Serviceability -->> Tools --->> Control Center - Network Services

Hope this helps

Regards

Carlo

[Live2 Bicycle]

Yes I tried restarting Cisco License Manager  service on the Publisher and both subscribers.  I even went so far as to reboot all 3 servers.

Still showing the incorrect numbers :-(

I'm looking through the bug tool kit now to see if I am hitting a bug.

Thanks for your responce Carlo!

[Carlo Poggiarelli]

Hi.

Please post the output of the following commnads.

file list license *

run sql select * from licenseinfo

Let me know

Regards

Carlo

[Live2 Bicycle]

admin:file list license *
dir count = 0, file count = 0
admin:

admin:run sql select * from licenseinfo

pkid                                 fklicenseserver                      tklicensefeature licenseunits overdraftunits macaddress   version origmacid    licfileid         licfileversion isdemo licenselineid upgradefromwindows isvalid

==================================== ==================================== ================ ============ ============== ============ ======= ============ ================= ============== ====== ============= ================== =======

dd12353c-ae2d-482a-b6eb-5e300abe1789 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118114424536 2.0            f      1             f                  t

6460a79d-017a-4f86-955d-dd6f76e808b0 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 2                51333        0              4e7a5409ea15 5.0     4e7a5409ea15 20111125154708298 2.0            f      1             f                  t

e24b925e-06c5-406c-a1c8-c0e8fa044f76 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111116025756415 2.0            f      1             f                  t

50df7f1e-e65d-48ed-b278-d82b694fcf60 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118114424536 2.0            f      2             f                  t

5d587fb1-5209-4dac-b768-4615ac7bee25 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118115115392 2.0            f      1             f                  t

10c5ed1a-cd85-41ba-8363-0fcafe8035ff f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118115115392 2.0            f      2             f                  t

cd2264e5-93f1-4c94-a0d8-8123a0b72b50 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120338569 2.0            f      1             f                  t

77f5da58-7bfd-468e-843e-13bbb583f97e f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120338569 2.0            f      2             f                  t

5c7cd78d-2050-496c-b4c2-115243e7fabe f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120446818 2.0            f      1             f                  t

eeb16cba-3288-4f32-a443-b3aef7567569 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120446818 2.0            f      2             f                  t

32d6aa18-f851-467b-b372-60b5dd9f832f f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120654326 2.0            f      1             f                  t

9f61f673-5f17-4fe7-96a7-fddd2d31d311 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120654326 2.0            f      2             f                  t

2d397bfc-4422-4335-b84c-fa033a7234b5 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120753899 2.0            f      1             f                  t

c284
admin:run sql select * from licenseinfo
pkid                                 fklicenseserver                      tklicensefeature licenseunits overdraftunits macaddress   version origmacid    licfileid         licfileversion isdemo licenselineid upgradefromwindows isvalid
==================================== ==================================== ================ ============ ============== ============ ======= ============ ================= ============== ====== ============= ================== =======
dd12353c-ae2d-482a-b6eb-5e300abe1789 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118114424536 2.0            f      1             f                  t
6460a79d-017a-4f86-955d-dd6f76e808b0 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 2                51333        0              4e7a5409ea15 5.0     4e7a5409ea15 20111125154708298 2.0            f      1             f                  t
e24b925e-06c5-406c-a1c8-c0e8fa044f76 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111116025756415 2.0            f      1             f                  t
50df7f1e-e65d-48ed-b278-d82b694fcf60 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118114424536 2.0            f      2             f                  t
5d587fb1-5209-4dac-b768-4615ac7bee25 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118115115392 2.0            f      1             f                  t
10c5ed1a-cd85-41ba-8363-0fcafe8035ff f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118115115392 2.0            f      2             f                  t
cd2264e5-93f1-4c94-a0d8-8123a0b72b50 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120338569 2.0            f      1             f                  t
77f5da58-7bfd-468e-843e-13bbb583f97e f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120338569 2.0            f      2             f                  t
5c7cd78d-2050-496c-b4c2-115243e7fabe f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120446818 2.0            f      1             f                  t
eeb16cba-3288-4f32-a443-b3aef7567569 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120446818 2.0            f      2             f                  t
32d6aa18-f851-467b-b372-60b5dd9f832f f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120654326 2.0            f      1             f                  t
9f61f673-5f17-4fe7-96a7-fddd2d31d311 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 3                1            0              4e7a5409ea15 8.0     4e7a5409ea15 20111118120654326 2.0            f      2             f                  t
2d397bfc-4422-4335-b84c-fa033a7234b5 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                1            0              4e7a5409ea15 5.0     4e7a5409ea15 20111118120753899 2.0            f      1             f                  t
c284

[Live2 Bicycle]

pkid                                 fklicenseserver                      tklicensefeature licenseunits overdraftunits macaddress   version origmacid    licfileid         licfileversion isdemo licenselineid upgradefromwindows isvalid

d99491ad-4036-4c57-a6db-8630be65f3b4 f8fe34ec-d537-4c39-b87b-edc36d09d6b7 1                51333        0              4e7a5409ea15 5.0     4e7a5409ea15 20111125154403413 2.0            f      1             f                  t

THis is the bad license file -- 20111125154403413

[Carlo Poggiarelli]

Hi.

I think you should open a TAC to obtain root access to delete wrong licenseinfo entries from the CUCM DB.

Hope this helps.

Regards

Carlo

[Live2 Bicycle]

Yea, I did that last night shortly after I posted to the community.  The engineer accepted the ticket then took a P2 case and could not assist me.  I went ahead and requeued just now.  When I try to run the delete command I get denied.

admin:run sql delete from licenseinfo where licfileid = '20111125154403413'

No DELETE permission for licenseinfo.

I'll update this thread with the resolution when i get one.  Thanks again Carlo for your input!

Del

[Rob Huffman]

Hi Del,

Looks like it may be this bug;

CSCtc59039 - CLI file delete licensing doesn't remove DB entries in licenseinfo

Description

Symptoms:
The DB entries are not removed after removing the license file via cli command
file delete license
Conditions:
This problem happens when there is only a license file uploaded in the server
and user removes the license file
Workaround:
user will need to remove the corresponding DB entries in licenseinfo table.
For performing this, TAC will need to be contacted.
Note CUP will also document this issue and declare CUP doesn't support valid
license removal through the CLI command. The only time that user needs to
remove the license file is a publisher rehost is performed and the original
license file becomes invalid. users will need to upload a new license file,
use this cli command to remove the invalid license file, then restart license
manager.
Further Problem Description:

Details

1st Found-in:                          (5)

8.5(1), 8.6(1), 8.6, 8.0(1)

7.1(3.10000.11)

More

Less

Status:

Open

Last Modified:

Oct 28,2011

Known Affected Versions:

More

Less

Fixed-in:                          (7)

8.6(2.98000.56), 8.6(2.98000.24), 8.6(2.10000.4)

8.6(2.10000.30), 8.6(2.10000.27), 8.5(1.13900.4)

8.5(1.13039.1)

More

Less

Product:

Cisco Unified Communications Manager (CallManager)

Platform:

Dependent

Severity:

3 - moderate

Customer Reported:                          (23)

It seems that your TAC case is your best bet here.

Cheers!

Rob

[Live2 Bicycle]

Thanks Rob,  Not sure how I missed this one last night when I was searching through the bug tool kit myself.  I'll blame it on the left over Turkey dinner sleepy eyes!

Del

[Rob Huffman]

Hey Del,

You are most welcome my friend!

Even without the leftover Turkey the Bug Toolkit can make your eyes

glaze over ....hahahahaha

Cheers!

Rob

[Live2 Bicycle]

Final Resoltion by TAC:

**** TAC had to get root access and delete the license entrys in the database. ****

Thank you to Carlo for your suggestion to lookup the license files and compare that with what the database listed.

file list license *

run sql select * from licenseinfo

Thank you Rob for finding the bug ID CSCtc59039

[yuweifeng]

hello,

We have CUCM 8.0.3 and we are running into the same situation. But, when we contact TAC, the engineer told us that as soon as he deletes all the entries from licenseinfo, the whole phone system will be down (all devices become 'unregistered'). And, there will be an major service interruption. He couldn't tell us how long the interruption will be 30 minutes, 1hr, ....

Could somebody provide me some information according to your experience? if there will be an service interruption, how long will it be?

Thanks in advance!

-------------------------------------------------------

Aug 5, 2013

The license issue has been fix by TAC engineer, and the service interruption was less than 3 minutes (we have ~5000 phone devices).