Cisco Headend System Release 2.7 Installation Guide
Chapter 8 Identify and Correct Database Problems with the checkDB Script
104
4020695 Rev C
16 # There are 0 secure_micro rows with mac_addr not in 'hct_profile'
17 # There are 5 secure_micro MACs with sm_serial_num not in 'hct_profile'
18 # These sm_host_mac_addr rows MUST be deleted from 'secure_micro'!
19 # (They cause 'mismatch' problems with EMM regeneration in camAuditor)
20 # (Use the 'deleteDhct' utility to delete these.)
21 00:01:A6:05:33:70|00:02:DE:FC:50:14|
22 00:01:A6:20:66:1A|00:02:DE:F0:A0:5B|
23 00:01:A6:41:B2:80|00:02:DE:F0:93:8E|
24 00:01:A6:30:A3:A4|00:01:A6:7C:53:F6|
25 00:01:A6:41:35:64|00:01:A6:80:EE:8E|
26 # There are 0 sm_auth_profile rows with no secure_micro parent
27 # There are 0 sm_pkg_auth SMSNs with no secure_micro parent
28 # There are 502 boxes having EMMs with sm_serial_num not in 'hct_profile'
29 # All rows having these sm_serial_num should be deleted from 'emm'
30 00:01:A6:5D:10:92
31 00:01:A6:67:54:24
32 (500 other addresses listed here)
33 # There are 0 pdkeycertificates having no parent 'hct_profile'
34 # There are 0 boxes with no 'pdkeycertificates'
35 # There are 14 boxes with no 'secure_micro', but with very-old EMMs.
36 # These boxes are in the database, but were incompletely staged
37 # over 90 days ago. They should be re-staged or deleted.
38 00:02:DE:1D:4C:5A
39 00:02:DE:1B:6E:6A
40 00:02:DE:53:E4:6A
41 00:02:DE:58:6A:64
42 00:02:DE:1C:13:D6
43 00:02:DE:B2:9F:E6
44 00:02:DE:14:E1:18
45 00:02:DE:14:67:EA
46 00:02:DE:49:BF:3A
47 00:02:DE:14:16:B8
48 00:02:DE:13:21:52
17 # There are 5 secure_micro MACs with sm_serial_num not in 'hct_profile'
18 # These sm_host_mac_addr rows MUST be deleted from 'secure_micro'!
19 # (They cause 'mismatch' problems with EMM regeneration in camAuditor)
20 # (Use the 'deleteDhct' utility to delete these.)
21 00:01:A6:05:33:70|00:02:DE:FC:50:14|
22 00:01:A6:20:66:1A|00:02:DE:F0:A0:5B|
23 00:01:A6:41:B2:80|00:02:DE:F0:93:8E|
24 00:01:A6:30:A3:A4|00:01:A6:7C:53:F6|
25 00:01:A6:41:35:64|00:01:A6:80:EE:8E|
26 # There are 0 sm_auth_profile rows with no secure_micro parent
27 # There are 0 sm_pkg_auth SMSNs with no secure_micro parent
28 # There are 502 boxes having EMMs with sm_serial_num not in 'hct_profile'
29 # All rows having these sm_serial_num should be deleted from 'emm'
30 00:01:A6:5D:10:92
31 00:01:A6:67:54:24
32 (500 other addresses listed here)
33 # There are 0 pdkeycertificates having no parent 'hct_profile'
34 # There are 0 boxes with no 'pdkeycertificates'
35 # There are 14 boxes with no 'secure_micro', but with very-old EMMs.
36 # These boxes are in the database, but were incompletely staged
37 # over 90 days ago. They should be re-staged or deleted.
38 00:02:DE:1D:4C:5A
39 00:02:DE:1B:6E:6A
40 00:02:DE:53:E4:6A
41 00:02:DE:58:6A:64
42 00:02:DE:1C:13:D6
43 00:02:DE:B2:9F:E6
44 00:02:DE:14:E1:18
45 00:02:DE:14:67:EA
46 00:02:DE:49:BF:3A
47 00:02:DE:14:16:B8
48 00:02:DE:13:21:52