Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

7914 Installation problem

Hi,

I try to install a 7914 on a CCM3.2.2a.

what are the configurations steps on the CCM ?

in the 7960 conf. menu. I tell that I use a 7914 moule using the default firmware. Apply the changes.

As soon as I do the apply, the direcory numbers zone in theconfiguration page prompt the following error message :

One or more errors occured while trying to get the Directory number information for this phone's lines. Try deleting and re-creating this device. If errors continue, it may be necessary to restore an earlier version of the configuration database.

(-2147467259)

And I only see horizontal lines on the 7914 module.

Help would be appreciated .... because I really don't see where to configure this beest ;-)

Regards

Frederic

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: 7914 Installation problem

Hi Frederic,

Symptom:

When trying to add an expansion module to an existing phone,

the following error occurs:

Directory Numbers

One or more errors occured while trying to get

the Directory number information for this

phone's lines. Try deleting and re-creating this

device. If errors continue, it may be necessary to

restore an earlier version of the configuration

database. (-2147467259)

Condition:

Add a 7914 expansion module (and possibly, a VG248).

Workaround:

Create and execute the batch file on the Publisher.

Please copy the below lines into a batch file and execute on the publisher:

@echo off

@if "%4x" == "x" goto Usage

echo USE %2 >temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{53F89BAA-FF0A-4D3A-A885-B3006990D609}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 1, 2, 'Speed Dial 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{93A6820A-191F-4A81-A033-10F2CA7C1596}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 2, 2, 'Speed Dial 2', 2, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{D24ABA1C-956C-412C-93AE-8EFFE4E19C14}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 3, 2, 'Speed Dial 3', 3, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{7EBBC1FD-31A8-4985-A30D-959D83C5C989}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 4, 2, 'Speed Dial 4', 4, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{B282E898-6305-413D-8F73-BA4604267856}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 5, 2, 'Speed Dial 5', 5, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{34D1104A-0EFE-4F18-87FD-6D301F5D7EB6}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 6, 2, 'Speed Dial 6', 6, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{AE52BBE9-833F-407D-BFE0-7052FFFDEF88}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 7, 2, 'Speed Dial 7', 7, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{194202DD-74C5-4C4A-92FC-65C1F19E0867}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 8, 2, 'Speed Dial 8', 8, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{93AFA4B1-C225-4593-B3EF-9D120E050508}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 9, 2, 'Speed Dial 9', 9, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{EB2F394B-B922-48DC-BAAE-ABCBA2595961}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 10, 2, 'Speed Dial 10', 10, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{141E5C5A-1F8A-4301-846C-668BB4FAE1BF}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 11, 2, 'Speed Dial 11', 11, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{E90346CB-0C23-49E5-B952-D2BFF871AAE5}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 12, 2, 'Speed Dial 12', 12, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{0941E1E0-9653-4A7E-AA1F-7A543A2D3A88}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 13, 2, 'Speed Dial 13', 13, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{81AAC2F3-18CE-4622-92E5-663242B6B924}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 14, 2, 'Speed Dial 14', 14, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{C9B88892-D177-4C52-8EC8-D59AA7AB2322}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 1, 9, 'Line 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{24758024-3052-4FB0-A0A6-9DA9D0FDBC6F}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 2, 2, 'Speed Dial 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{F2633698-3D21-4ADB-B66E-80724D14F924}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 3, 2, 'Speed Dial 2', 2, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{413D829F-1C1A-4817-8705-130C3580F368}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 4, 2, 'Speed Dial 3', 3, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{E6AE95C7-ADEC-43D1-887C-8ADBD1E466CF}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 5, 2, 'Speed Dial 4', 4, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{8A7AD365-8267-4C4E-A3DD-B1D516DFA82A}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 6, 2, 'Speed Dial 5', 5, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{0253B6FC-6BD0-4DA8-8786-9CF03B06F728}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 7, 2, 'Speed Dial 6', 6, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{52878407-A7FD-4A2C-A681-F368A6000FAB}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 8, 2, 'Speed Dial 7', 7, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{896BB2BF-46F9-4531-A06D-9E223365D1AD}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 9, 2, 'Speed Dial 8', 8, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{1A4875C4-8513-44EB-9374-88AC2F03C20C}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 10, 2, 'Speed Dial 9', 9, 0, NULL, NULL) >>temp.sql

osql -S %1 -U %3 -P %4 -i temp.sql

del temp.sql

goto endd

:Usage

@echo Usage: InsertSidecarButtons "server" "database" "adminuser" "adminpw"

@echo Example: InsertSidecarButtons . CCM0300 sa ""

:endd

HTH,

Kev

6 REPLIES
New Member

Re: 7914 Installation problem

you should probably upgrade to 3.2.2c and the latest ES patch..

-Gordon

Cisco Employee

Re: 7914 Installation problem

Hi Frederic,

Symptom:

When trying to add an expansion module to an existing phone,

the following error occurs:

Directory Numbers

One or more errors occured while trying to get

the Directory number information for this

phone's lines. Try deleting and re-creating this

device. If errors continue, it may be necessary to

restore an earlier version of the configuration

database. (-2147467259)

Condition:

Add a 7914 expansion module (and possibly, a VG248).

Workaround:

Create and execute the batch file on the Publisher.

Please copy the below lines into a batch file and execute on the publisher:

@echo off

@if "%4x" == "x" goto Usage

echo USE %2 >temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{53F89BAA-FF0A-4D3A-A885-B3006990D609}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 1, 2, 'Speed Dial 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{93A6820A-191F-4A81-A033-10F2CA7C1596}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 2, 2, 'Speed Dial 2', 2, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{D24ABA1C-956C-412C-93AE-8EFFE4E19C14}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 3, 2, 'Speed Dial 3', 3, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{7EBBC1FD-31A8-4985-A30D-959D83C5C989}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 4, 2, 'Speed Dial 4', 4, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{B282E898-6305-413D-8F73-BA4604267856}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 5, 2, 'Speed Dial 5', 5, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{34D1104A-0EFE-4F18-87FD-6D301F5D7EB6}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 6, 2, 'Speed Dial 6', 6, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{AE52BBE9-833F-407D-BFE0-7052FFFDEF88}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 7, 2, 'Speed Dial 7', 7, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{194202DD-74C5-4C4A-92FC-65C1F19E0867}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 8, 2, 'Speed Dial 8', 8, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{93AFA4B1-C225-4593-B3EF-9D120E050508}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 9, 2, 'Speed Dial 9', 9, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{EB2F394B-B922-48DC-BAAE-ABCBA2595961}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 10, 2, 'Speed Dial 10', 10, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{141E5C5A-1F8A-4301-846C-668BB4FAE1BF}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 11, 2, 'Speed Dial 11', 11, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{E90346CB-0C23-49E5-B952-D2BFF871AAE5}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 12, 2, 'Speed Dial 12', 12, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{0941E1E0-9653-4A7E-AA1F-7A543A2D3A88}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 13, 2, 'Speed Dial 13', 13, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{81AAC2F3-18CE-4622-92E5-663242B6B924}', '{17E0D7EE-EF1B-4D0D-BBDB-91B7552A7A0E}', 14, 2, 'Speed Dial 14', 14, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{C9B88892-D177-4C52-8EC8-D59AA7AB2322}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 1, 9, 'Line 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{24758024-3052-4FB0-A0A6-9DA9D0FDBC6F}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 2, 2, 'Speed Dial 1', 1, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{F2633698-3D21-4ADB-B66E-80724D14F924}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 3, 2, 'Speed Dial 2', 2, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{413D829F-1C1A-4817-8705-130C3580F368}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 4, 2, 'Speed Dial 3', 3, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{E6AE95C7-ADEC-43D1-887C-8ADBD1E466CF}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 5, 2, 'Speed Dial 4', 4, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{8A7AD365-8267-4C4E-A3DD-B1D516DFA82A}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 6, 2, 'Speed Dial 5', 5, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{0253B6FC-6BD0-4DA8-8786-9CF03B06F728}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 7, 2, 'Speed Dial 6', 6, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{52878407-A7FD-4A2C-A681-F368A6000FAB}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 8, 2, 'Speed Dial 7', 7, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{896BB2BF-46F9-4531-A06D-9E223365D1AD}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 9, 2, 'Speed Dial 8', 8, 0, NULL, NULL) >>temp.sql

echo INSERT INTO PhoneButton (pkid, fkPhoneTemplate, buttonNum, tkFeature, label, paramN1, paramN2, paramT1, paramT2) VALUES ('{1A4875C4-8513-44EB-9374-88AC2F03C20C}', '{DA9FDD74-4BA1-4213-A740-9AF2526E640A}', 10, 2, 'Speed Dial 9', 9, 0, NULL, NULL) >>temp.sql

osql -S %1 -U %3 -P %4 -i temp.sql

del temp.sql

goto endd

:Usage

@echo Usage: InsertSidecarButtons "server" "database" "adminuser" "adminpw"

@echo Example: InsertSidecarButtons . CCM0300 sa ""

:endd

HTH,

Kev

New Member

Re: 7914 Installation problem

Thanks for your quick reply,

I did the insertion but nothing new in the button template and it still doesn't work.

Other info, I try do do it on a CCM 3.1.3a, and I get the same error.

And when I try to insert a new phone button template based on the 14-button extension-module, I always get an error

do you see other things I have done wrong ?

Regards

Frederic

Cisco Employee

Re: 7914 Installation problem

Frederic,

Maybe the 7914 template is corrupt. You can try this procedure to see if it fixes your problem, but you will need to make a change in SQL.

1 - From Device > Phone Button Template copy the 7960 template to a new template. Rename this to something like "New 7914"

2 - Use SQL Enterprise Manager to open the PhoneTemplate Table within the CCM30x database that is being used

3 - Find the record for "New 7914" and set the numOfButtons field to 14 and the tkPhoneTemplateUsage to 1

4 - Go back to the Phone Button Template Configuration screen, reload that template and configure as needed

5 - Select the "New 7914" for the Expansion Module

Let me know if this helps.

Kev

New Member

Re: 7914 Installation problem

Thanks a lot Kev, your previuous post resolves in fact my problem. But updated the wrong database ( CCM0301) and apparently I had to update CCM0302 one.

Other question .... wahta is teh difference between those two databases ?

Regards

Frederic

Cisco Employee

Re: 7914 Installation problem

Sorry, should have been more clear. For Each CallManager upgrade the ccm030x database is updated as well. CCM0300 is the database installed on a clean server. The x is incremented by one for the new database. So, it looks like you have upgraded twice.

Glad you were able to fix your problem.

Kev

105
Views
0
Helpful
6
Replies
CreatePlease to create content