DMA 7.0(2) warning SQL error executing "update DeviceNumPlanMap"

Unanswered Question
Mar 6th, 2009

I have about 20 of these warnings, overall we have about 1500 phones/users on 4.1(3)SR6. Will it mean they won't export/import to CallManager 7.0(2)?

Row: 5738 SQL error: -746(35317)

Error executing "update DeviceNumPlanMap set fkDevice='39fca740-6ee4-4e16-9821-607410de3b90' where pkid='f70a5efb-347d-4699-84e8-fe060ce0ceb1'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(35317)

pkid f70a5efb-347d-4699-84e8-fe060ce0ceb1 NOT MODIFIABLE

fkDevice 39fca740-6ee4-4e16-9821-607410de3b90

NumPlanIndex 1

Label

fkNumPlan fb8d6d98-f8dd-4b85-9ac7-c8a7c7f4ab07

Display Efrain Soto (Ex-Marco Barcenas (Wireless))

tkRingSetting 0

CtiID 5738 NOT MODIFIABLE

E164Mask

DialPlanWizardGenID

tkMWLPolicy 0

tkRingSetting_Consecutive 0

MaxNumCalls 3

BusyTrigger 2

CallInfoDisplayMask 9

LabelASCII

DisplayASCII Efrain Soto (Ex-Marco Barcenas

tkRingSetting_ActivePickupAlert 0

tkRingSetting_IdlePickupAlert 0

tkPartitionUsage 99 NOT MODIFIABLE

SpeedDial

fkRecordingProfile

fkCallingSearchSpace_Monitoring

tkStatus_AudibleMWI 2

********************************************************************************

*

* End of warnings found during CallManager database validation.

* CallManager database validation.

*

* Date/Time : 03-05-09/11:07:46 PM

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Tommer Catlin Sat, 03/07/2009 - 19:38

Probably need to open a tac case. but do i read the log file correct the display name has odd characters in it like Ex-Marco )) () stuff like that I wonder if it's throwing it off.

It could be a warning you *could* ignore, but its a tough call. TAC will better be able to diagnose it. If you have a new server for 7.02, id probably see if it the DMA loads. If it loads, and the device/line all look correct, Id probably ignore it.

Jason Aarons Sun, 03/08/2009 - 19:19

Would this DMA error occur if Display exceeds 30 characters?

I tracked down this 7920G phone, went to the line;

Line Settings for this Device >

Display (Internal Caller ID) >

Efrain Soto (Ex-Marco Barcenas (Wireless))

Is that not a valid Display?

From help;

Display (Internal Caller ID)

Leave this field blank to have the system display the extension.

Use a maximum of 30 alphanumeric characters. Typically, use the user name or the directory number (if using the directory number, the person receiving the call may not see the proper identity of the caller).

Setting applies only to the current device unless you check the check box at right and click the Propagate selected button. (The check box at right displays only if other devices share this directory number.)

Actions

This Discussion