7914 Installation problem

[f-vanryckeghem]

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

[gordon.hawkins]

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

-Gordon

[kthorngr · Accepted solution]

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

[f-vanryckeghem]

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

[kthorngr]

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

[f-vanryckeghem]

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

[kthorngr]

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