[cisco-voip] DMA warnings

[Ed Leatherman]

Gotcha, thanks for the advice

On Wed, Jul 14, 2010 at 10:51 AM, Wes Sisk <wsisk at cisco.com> wrote:
> -746 is a 'user generated message' in this case, it should come from Cisco.
> Most of the time it is accompanied with descriptive text such as:
> Row: 5510 SQL error: -746(424)
> Warning message (Business Rule Violation): Softkey Template is not valid for
> this type of device.
>
> Most ignore these warnings.
> If you want to dig into it I'd recommend using the fkdevice and fknumplan to
> identify the device/line in question. Are they important?  Can they be
> deleted and recreated? That would fix any data constraint violation.
>
> Most likely the 2 rows violate some constraint.  Constraints are documented
> in the data dictionary.  In your case (7.1):
> http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/7_1_3/datadictionary_713.pdf
>
> On casual glance I don't see the exception but it could come from the one of
> the data contstraints imposed on the combination of
> (devicenumplanmap+device) or ((devicenumplanmap+numplan).
>
> Delete and recreate is most likely shortest path to resolution.
>
> /Wes
>
> On Wednesday, July 14, 2010 10:25:07 AM, Ed Leatherman
> <ealeatherman at gmail.com> wrote:
>>
>> Hello DMA gurus..
>>
>> Working on cleaning up a DMA export for an upgrade here in a few
>> weeks.. going from 4.2 to 7.1.5. I've got everything cleaned up except
>> for 2 warnings. I will likely proceed with the upgrade anyway, the dma
>> file works as-is in the lab.. but wouldn't mind fixing them if its
>> reasonable to do so. nothing is jumping out at me as an error though..
>> any thoughts? The error msg isn't helpful.
>>
>> both look like this just the other one is a different device/numplan:
>>
>>   Row: 622 SQL error: -746(35317)
>>   Error executing "update DeviceNumPlanMap set
>> fkDevice='be79732c-0990-4bad-91a0-d5cee504fa80' where
>> pkid='4fbfa66a-0daa-4e15-86b8-72629aa32ae2'": [Informix][Informix ODBC
>> Driver][Informix]Unspecified System Error =  -746. sqlerrm(35317)
>>      pkid                       4fbfa66a-0daa-4e15-86b8-72629aa32ae2
>> NOT MODIFIABLE
>>      fkDevice                   be79732c-0990-4bad-91a0-d5cee504fa80
>>      NumPlanIndex               1
>>      Label
>>      fkNumPlan                  21dd4ac6-78b6-46e5-a742-6cc7811acca7
>>      Display                    Hall Conference Room Phone Science
>>      tkRingSetting              0
>>      CtiID                      622     NOT MODIFIABLE
>>      E164Mask                   3047886801
>>      DialPlanWizardGenID
>>      tkMWLPolicy                0
>>      tkRingSetting_Consecutive  0
>>      MaxNumCalls                4
>>      BusyTrigger                2
>>      CallInfoDisplayMask        9
>>      LabelASCII
>>      DisplayASCII               Hall Conference Room Phone Sci
>>      tkRingSetting_ActivePickupAlert    0
>>      tkRingSetting_IdlePickupAlert      0
>>      tkPartitionUsage           99      NOT MODIFIABLE
>>      SpeedDial
>>      fkRecordingProfile
>>      fkCallingSearchSpace_Monitoring
>>      tkStatus_AudibleMWI        2
>>      LogMissedCalls             true
>>
>>
>>
>
>



-- 
Ed Leatherman