DMA Warnings

Unanswered Question
Jan 30th, 2010
User Badges:

Hi Guys,


Anyone seen the following warnings after running DMA. Appreciate if someone can provide me a solution for these warnings.


Warning: The SingleValue Attribute manager of the DN cn=NZZ4532,ou=Users,o=cisco.com contains a user cn=NZZ4163,ou=Users,o=cisco.com that does not exist in the


directory or is tagged invalid
Condition: The value stored in a directory attribute is invalid


Solution: Please verify that the user dn exists in the directory. In addition, please ensure the user is a valid CCM user with profiles
--------------------------------------------------------------


********************************************************************************
Data Validation has detected one or more Business Rule violations in your data.
Please correct your data to ensure proper operation and administration of your system.
Following is/are the rule violation(s) detected and, for each, a copy of the record which, when checked, revealed the violation


Table: Device                              2009-12-09 23:53:08


   Row: 58 SQL error: -746(429)
   Warning message (Business Rule Violation): Security Profile is required for this device
      pkid                          44693025-3169-4c92-90c3-038ba0c3e909     NOT MODIFIABLE
      Name                          AN1E4AB0D874FFF
      Description                   AN1E4AB0D874FFF
      tkModel                       30032     NOT MODIFIABLE
      tkDeviceProtocol              0
      tkProtocolSide                1
      SpecialLoadInformation       
      fkDevicePool                  87fbbf62-67cd-4a11-88a0-e38ff05b8e16
      fkPhoneTemplate              
      fkCallingSearchSpace         
      CtiID                         58     NOT MODIFIABLE
      tkClass                       17
      fkProcessNode                      NOT MODIFIABLE
      DefaultDTMFCapability         0
      fkLocation                    29c5c1c4-8871-4d1e-8394-0b9181e8c54d
      tkProduct                     30071
      DialPlanWizardGenID          
      DeviceLevelTraceFlag          false
      fkEndUser                    
      AllowHotelingFlag             false
      tkDeviceProfile               0
      ikDevice_DefaultProfile      
      fkMediaResourceList          
      UserHoldMOHAudioSourceID     
      NetworkHoldMOHAudioSourceID    
      Unit                          0
      SubUnit                       0     NOT MODIFIABLE
      XML                          
      tkCountry                    
      tkUserLocale                 
      tkProduct_Base               
      fkCallingSearchSpace_AAR     
      fkAARNeighborhood            
      fkSoftkeyTemplate            
      retryVideoCallAsAudio         true
      RouteListEnabled              false
      fkCallManagerGroup           
      tkStatus_MLPPIndicationStatus     0
      tkPreemption                  0
      tkStatus_BuiltInBridge        0
      mTPRequired                   false
      tkQSIG                        4     NOT MODIFIABLE
      tkPacketCaptureMode           0
      PacketCaptureDuration         60
      AuthenticationString         
      tkCertificateStatus           1
      UpgradeFinishTime            
      fkMlppDomain                 
      TransmitUTF8                  false
      ignorePI                      true
      tkNetworkLocation             0
      V150ModemRelayCapable         false
      tkCertificateOperation        1
      fkSecurityProfile            
      fkDialRules                  
      fkCallingSearchspace_reroute    
      fkCallingSearchspace_refer    
      unattended_port               false
      tkDTMFSignaling               1
      requireDTMFReception          false
      publicKey                    
      fkSIPProfile                 
      RFC2833Disabled               false
      AllowCTIControlFlag           true
      DateTimeInserted             
      sshpassword                  
      sshuserID                    
      fkCallingSearchspace_restrict    
      fkMatrix_Presence             ad243d17-98b4-4118-8feb-5ff2e1b781ac
      fkCommonPhoneConfig           ac243d17-98b4-4118-8feb-5ff2e1b781ac
      tkkeyauthority                0
      tkSIPCodec_MTPPreferredOrigCodec     1
      md5hash                      
      SRTPAllowed                   false
      isStandard                    false     NOT MODIFIABLE
      resetToggle                   false
      tkReset                       2
      VersionStamp                  1260373984-8b1fdf88-9a03-438c-a7ce-755db4e7ec1f
      fkCommonDeviceConfig          ce499781-62e8-450c-8fd3-e8e3bfabe3f5
      huntListForVM                 false
      remoteDevice                  false
      tkStatus_DeviceMobilityMode     2
      DNDTimeout                    0
      tkDNDOption                   0
      tkRingSetting_DND            
      IsDualMode                    false     NOT MODIFIABLE
      fkCallingSearchspace_CgPNTransform    
      fkEndUser_Mobility           
      tkOutboundCallRollover        0
      tkPhonePersonalization        3
      tkStatus_joinacrosslines      2
      tkBarge                       3
      tkStatus_UseTrustedRelayPoint     2
      IsTrustedRelayPoint           false
      SRTPFallbackAllowed           false
      IsPAIEnabled                  true
      IsRPIDEnabled                 true
      tkSipPrivacy                  0
      tkSipAssertedType             0
      fkCallingSearchSpace_CdPNTransform    
      useDevicePoolCdpnTransformCSS     true
      NationalPrefix                Default
      InternationalPrefix           Default
      UnknownPrefix                 Default
      SubscriberPrefix              Default
      useDevicePoolCgpnTransformCSS     true
      ikDevice_PrimaryPhone        
      tkStatus_AudibleAlertingIdle     2
      tkStatus_AudibleAlertingBusy     2
      IsActive                      true
      tkPhoneServiceDisplay         3
      IsProtected                   false
      fkMobileSmartClientProfile    
      tkStatus_AlwaysUsePrimeLine     2
      tkStatus_AlwaysUsePrimeLineForVM     2
      fkGeoLocation                
      fkGeoLocationFilter_lp       
      SendGeoLocation               false
      NationalStripDigits          
      InternationalStripDigits     
      UnknownStripDigits           
      SubscriberStripDigits        
      fkCallingSearchSpace_cgpnNational    
      fkCallingSearchSpace_cgpnIntl    
      fkCallingSearchSpace_cgpnUnknown    
      fkCallingSearchSpace_cgpnSubscriber    
      useDevicePoolCgpnTransformCSSNatl     true
      useDevicePoolCgpnTransformCSSIntl     true
      useDevicePoolCgpnTransformCSSUnkn     true
      useDevicePoolCgpnTransformCSSSubs     true


   Row: 97 SQL error: -746(424)
   Warning message (Business Rule Violation): Softkey Template is not valid for this type of device.
      pkid                          178d19f5-22ed-4813-88d9-054a01ae4b64     NOT MODIFIABLE
      Name                          CiscoUM1-VI3
      Description                   SG011 Voice Mail Port Primary
      tkModel                       80     NOT MODIFIABLE
      tkDeviceProtocol              0
      tkProtocolSide                1
      SpecialLoadInformation       
      fkDevicePool                  c30bfc9b-c938-481c-8d78-235e21d4cbaf
      fkPhoneTemplate              
      fkCallingSearchSpace          35a2b8a8-9ef0-4e42-a666-5f4790f0bf98
      CtiID                         97     NOT MODIFIABLE
      tkClass                       8
      fkProcessNode                      NOT MODIFIABLE
      DefaultDTMFCapability         0
      fkLocation                    29c5c1c4-8871-4d1e-8394-0b9181e8c54d
      tkProduct                     27
      DialPlanWizardGenID          
      DeviceLevelTraceFlag          false
      fkEndUser                    
      AllowHotelingFlag             false
      tkDeviceProfile               0
      ikDevice_DefaultProfile      
      fkMediaResourceList          
      UserHoldMOHAudioSourceID     
      NetworkHoldMOHAudioSourceID    
      Unit                          0
      SubUnit                       0     NOT MODIFIABLE
      XML                          
      tkCountry                     64
      tkUserLocale                 
      tkProduct_Base               
      fkCallingSearchSpace_AAR     
      fkAARNeighborhood            
      fkSoftkeyTemplate             22a0fe03-1524-4ce6-8c59-6d63d5b2cbea
      retryVideoCallAsAudio         true
      RouteListEnabled              false
      fkCallManagerGroup           
      tkStatus_MLPPIndicationStatus     0
      tkPreemption                  0
      tkStatus_BuiltInBridge        0
      mTPRequired                   false
      tkQSIG                        4     NOT MODIFIABLE
      tkPacketCaptureMode           0
      PacketCaptureDuration         60
      AuthenticationString         
      tkCertificateStatus           1
      UpgradeFinishTime            
      fkMlppDomain                 
      TransmitUTF8                  false
      ignorePI                      false
      tkNetworkLocation             2
      V150ModemRelayCapable         false
      tkCertificateOperation        1
      fkSecurityProfile             a3fa54bf-c534-4cab-a7b0-43eaceb1d227
      fkDialRules                  
      fkCallingSearchspace_reroute    
      fkCallingSearchspace_refer    
      unattended_port               false
      tkDTMFSignaling               1
      requireDTMFReception          false
      publicKey                    
      fkSIPProfile                 
      RFC2833Disabled               false
      AllowCTIControlFlag           true
      DateTimeInserted             
      sshpassword                  
      sshuserID                    
      fkCallingSearchspace_restrict    
      fkMatrix_Presence             ad243d17-98b4-4118-8feb-5ff2e1b781ac
      fkCommonPhoneConfig           ac243d17-98b4-4118-8feb-5ff2e1b781ac
      tkkeyauthority                0
      tkSIPCodec_MTPPreferredOrigCodec     1
      md5hash                      
      SRTPAllowed                   false
      isStandard                    false     NOT MODIFIABLE
      resetToggle                   false
      tkReset                       2
      VersionStamp                  1260373988-348c7483-2984-4109-9532-ba461a17ddc0
      fkCommonDeviceConfig          94b1d3ed-ba5f-4e89-81a2-d40703a0f890
      huntListForVM                 false
      remoteDevice                  false
      tkStatus_DeviceMobilityMode     2
      DNDTimeout                    0
      tkDNDOption                   0
      tkRingSetting_DND            
      IsDualMode                    false     NOT MODIFIABLE
      fkCallingSearchspace_CgPNTransform    
      fkEndUser_Mobility           
      tkOutboundCallRollover        0
      tkPhonePersonalization        3
      tkStatus_joinacrosslines      2
      tkBarge                       3
      tkStatus_UseTrustedRelayPoint     2
      IsTrustedRelayPoint           false
      SRTPFallbackAllowed           false
      IsPAIEnabled                  true
      IsRPIDEnabled                 true
      tkSipPrivacy                  0
      tkSipAssertedType             0
      fkCallingSearchSpace_CdPNTransform    
      useDevicePoolCdpnTransformCSS     true
      NationalPrefix                Default
      InternationalPrefix           Default
      UnknownPrefix                 Default
      SubscriberPrefix              Default
      useDevicePoolCgpnTransformCSS     true
      ikDevice_PrimaryPhone        
      tkStatus_AudibleAlertingIdle     2
      tkStatus_AudibleAlertingBusy     2
      IsActive                      true
      tkPhoneServiceDisplay         3
      IsProtected                   false
      fkMobileSmartClientProfile    
      tkStatus_AlwaysUsePrimeLine     2
      tkStatus_AlwaysUsePrimeLineForVM     2
      fkGeoLocation                
      fkGeoLocationFilter_lp       
      SendGeoLocation               false
      NationalStripDigits          
      InternationalStripDigits     
      UnknownStripDigits           
      SubscriberStripDigits        
      fkCallingSearchSpace_cgpnNational    
      fkCallingSearchSpace_cgpnIntl    
      fkCallingSearchSpace_cgpnUnknown    
      fkCallingSearchSpace_cgpnSubscriber    
      useDevicePoolCgpnTransformCSSNatl     true
      useDevicePoolCgpnTransformCSSIntl     true
      useDevicePoolCgpnTransformCSSUnkn     true
      useDevicePoolCgpnTransformCSSSubs     true

--------------------------------------------------------------------------------------------------------------------------------------------


Row: 6880 SQL error: -746(35288)
   Error executing "update DeviceNumPlanMap set fkDevice='ecabe4af-7f74-4ce4-8708-9a3ce23f47fd' where pkid='13ec6205-81d5-4df0-b473-ff5e55099ee2'":


[Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(35288)
      pkid                          13ec6205-81d5-4df0-b473-ff5e55099ee2     NOT MODIFIABLE
      fkDevice                      ecabe4af-7f74-4ce4-8708-9a3ce23f47fd
      NumPlanIndex                  1
      Label                         Conf.Rm CR TK TENNOZ DAS RM01- 5601
      fkNumPlan                     da8c6f35-6e47-4212-a0f2-3ff90c582b8c
      Display                       Conf.Rm CR TK TENNOZ DAS RM01
      tkRingSetting                 0
      CtiID                         6880     NOT MODIFIABLE
      E164Mask                      8135460XXXX
      DialPlanWizardGenID          
      tkMWLPolicy                   0
      tkRingSetting_Consecutive     0
      MaxNumCalls                   4
      BusyTrigger                   2
      CallInfoDisplayMask           9
      LabelASCII                    Conf.Rm CR TK TENNOZ DAS RM01-
      DisplayASCII                  Conf.Rm CR TK TENNOZ DAS RM01
      tkRingSetting_ActivePickupAlert     0
      tkRingSetting_IdlePickupAlert     0
      tkPartitionUsage              99     NOT MODIFIABLE
      SpeedDial                    
      fkRecordingProfile           
      fkCallingSearchSpace_Monitoring    
      tkStatus_AudibleMWI           2
      LogMissedCalls                true

--------------------------------------------------------------------------------------------------------------------------


Table: EndUserDeviceMap                    2009-12-10 00:09:51


   Row: 152 SQL error: -746(424)
   Warning message (Business Rule Violation): Softkey Template is not valid for this type of device.
      pkid                          fa2ea80a-defc-44c9-903f-93a0de131bc1     NOT MODIFIABLE
      fkEndUser                     3e35275c-9329-4c88-aa50-54d7a4374e4a
      fkDevice                      f4ccf3f3-b54b-4685-918c-a86a4ae13476
      DefaultProfile                false
      Description                  
      tkUserAssociation             1

--------------------------------------------------------------------------------------------------------------------------

Table: SpeedDial                           2009-12-10 00:20:24


   Row: 23 SQL error: -746(35287)
   Error executing "update SpeedDial set fkDevice='983c5a80-8a2b-438c-b248-19cbce177ba7' where pkid='ee4a1c41-1cc4-4019-a999-009542980504'": [Informix][Informix ODBC


Driver][Informix]Unspecified System Error =  -746. sqlerrm(35287)
      pkid                          ee4a1c41-1cc4-4019-a999-009542980504     NOT MODIFIABLE
      fkDevice                      983c5a80-8a2b-438c-b248-19cbce177ba7
      SpeedDialIndex                93
      SpeedDialNumber               00566530128
      Label                         À¶Ê϶ÝÌÞº³ÊÞ
      LabelASCII                   


   Row: 28 SQL error: -746(35287)
   Error executing "update SpeedDial set fkDevice='6d36ba6c-94b2-406b-8c20-f5662f891098' where pkid='ebe36b29-0c73-4b90-83f3-00a8f4c07d32'": [Informix][Informix ODBC


Driver][Informix]Unspecified System Error =  -746. sqlerrm(35287)
      pkid                          ebe36b29-0c73-4b90-83f3-00a8f4c07d32     NOT MODIFIABLE
      fkDevice                      6d36ba6c-94b2-406b-8c20-f5662f891098
      SpeedDialIndex                11
      SpeedDialNumber               92746531
      Label                         »ï°æ¹°»ê
      LabelASCII

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

Actions

This Discussion