Migrating CUCM 4.1(3) to CUCM 7.1 (3b) using DMA

Unanswered Question
Jun 18th, 2010
User Badges:

Hi,

I have a problem to migrate CUCM 4.1 (3) to CUCM 7.1 (3b) using a DMA version 7.1.3.

When I run DMA, I have the error message in attachment.

Do you think that’s problem of version? it’s correct to migrate directly CUCM 4.1(3) to 7.1(3) or I must to use a version intermediate?

Just for your information, I uninstall the integration with AD before running the DMA, it can provide a problem?

Thanks a lot,

Best Regards,

Omar

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Aaron Harrison Fri, 06/18/2010 - 03:42
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


Your output says you have a succesful output with warnings. This means your DMA file will import, but some things may be missing or broken.


Click the 'Warnings Log' button, and search the logs for 'warning'. If you aren't sure what the warnings mean or how to address them, post it back here.


Regards


Aaron


Please rate helpful posts...

omar_youn Fri, 06/18/2010 - 04:05
User Badges:

Hi Aaron,


Thanks too much for your quick answer;


Please, I send you the file Warning in attachement, if you can help me.

I want to know if I run the installation of CUCM 7.1 using this DMA Export file, what conseques would be generated in my New system?

Thanks again,

Best Regards,

Omar

Aaron Harrison Fri, 06/18/2010 - 05:15
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi


I see an LDAP error, presumably due to you having removed LDAP.


Also see errors like this:


Table: CallingSearchSpace                  2010-06-17 19:15:16

   Row: 24 SQL error: -746(35133)
   Error executing "update CallingSearchSpace set Name='SOPHAL_Internat_IPMA_CSS_M_E' where pkid='d2c50042-0008-4804-bac8-29deb4fc1fa5'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(35133)
      pkid                       d2c50042-0008-4804-bac8-29deb4fc1fa5  NOT MODIFIABLE
      Name                       SOPHAL_Internat_IPMA_CSS_M_E
      Description                CDG Manager accès à  l'international
      DialPlanWizardGenID       
      Clause                     Generated_IPMA_Managers:logue:Interne:Interdirecteur:VMPilotNumberPT:VMPilotNumber2  NOT MODIFIABLE
      resetToggle                false
      tkReset                    2
      tkPartitionUsage           99  NOT MODIFIABLE


I suspect these are cuased by the 'description' field having special characters in it. Later, other elements also fail:



   Row: 74 SQL error: -746(35133)
   Error executing "update CallingSearchSpaceMember set fkRoutePartition='6223602d-61df-4aad-a497-a451e0afb8bd' where pkid='4ff5ea2f-b2b5-4463-b7ba-2366a688829e'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(35133)
      pkid                       4ff5ea2f-b2b5-4463-b7ba-2366a688829e  NOT MODIFIABLE
      fkCallingSearchSpace       d2c50042-0008-4804-bac8-29deb4fc1fa5  NOT MODIFIABLE
      fkRoutePartition           6223602d-61df-4aad-a497-a451e0afb8bd
      SortOrder                  4


I believe this is because the earlier CSS was not imported to Informix, so the PKID (d2c50042-0008-4804-bac8-29deb4fc1fa5) is not a valid reference.


What I would do is change the single CSS above to have a simple description, and then re-run DMA. If there is no error logged for this on this attempt, I would then correct the description fields on the other CSSs.


Regards


Aaron


Please rate helpful posts and mark answered questions that you've got a satisfactory response from to help identify useful content in the forums...
https://supportforums.cisco.com/docs/DOC-6212

Roland Marti Fri, 06/18/2010 - 06:47
User Badges:

Hi

You have used special character.

Remove all äöü ' ^and so on and rerun the DMA.


Chers Roland

omar_youn Fri, 06/18/2010 - 08:48
User Badges:

Hi All,

thanks too much for your help and answer.

I change the Description of CSSs with the simple description, and the no error message about CSS display. But I have always the 2 others messages error:

06/18/2010  16:46:52

Warning: LDAP Operation Failed

ErrorCode = 32

ErrorMessage = No such object

ErrorName = LDAP_NO_SUCH_OBJECT

ErrorText = The server cannot find an object specified in the request

LDAP_HOST    = ccmpublisher

LDAP_PORT    = 8404

LDAP_DN                    = cn=Directory Manager, o=cisco.com

LDAP_PWD                 = *****

Condition: LDAP Search failed

Solution: Please note the LDAP error

I want to inform you that I remove the integration with AD before running the DMA, it’s not recommended to do this action?

Row: 356 SQL error: -746(35288)

   Error executing "update DeviceNumPlanMap set fkDevice='c29fa4f3-9d79-4c26-997d-991c939c1ff4' where pkid='5eaf2ac1-dae7-42d3-ae0a-2d7dbe2cda9c'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(35288)

      pkid                       5eaf2ac1-dae7-42d3-ae0a-2d7dbe2cda9c         NOT MODIFIABLE

      fkDevice                            c29fa4f3-9d79-4c26-997d-991c939c1ff4

      NumPlanIndex                  1

      Label                    FILALI JAOUHARI Abdeslam BLOCKED

      fkNumPlan                        2dd6c08e-1f09-450d-8b0e-295fc38a53ce

      Display                              FILALI JAOUHARI Abdeslam

      tkRingSetting                    4

      CtiID                      356      NOT MODIFIABLE

      E164Mask                         

      DialPlanWizardGenID       

      tkMWLPolicy                     0

      tkRingSetting_Consecutive           0

      MaxNumCalls                    4

      BusyTrigger                      4

      CallInfoDisplayMask          9

      LabelASCII                        FILALI JAOUHARI Abdeslam BLOCK

      DisplayASCII                     FILALI JAOUHARI Abdeslam

      tkRingSetting_ActivePickupAlert  

      tkRingSetting_IdlePickupAlert     

      tkPartitionUsage                99       NOT MODIFIABLE

      SpeedDial                        

      fkRecordingProfile           

      fkCallingSearchSpace_Monitoring           

      tkStatus_AudibleMWI        2

      LogMissedCalls                true

there is the second problem, do you have any idea to resolve this problem, please?

In attachement the warning message for more detail.

Thanks a lot,

Best regards,

Omar

Roland Marti Mon, 06/21/2010 - 01:27
User Badges:

Hi Omar

Do not use more than 30 Char in

*      Label                     FILALI JAOUHARI Abdeslam BLOCKED*

*      Display                               FILALI JAOUHARI Abdeslam*

*      LabelASCII                         FILALI JAOUHARI Abdeslam BLOCK*

*      DisplayASCII                      FILALI JAOUHARI Abdeslam*

It should work after them.

Regards

       Roland Marti

omar_youn Mon, 07/05/2010 - 07:48
User Badges:

Hi Roland,

Thanks for your answer,


I correct the error message bellow (I use less than 30 charc);

But, when I run DMA, I have always 2 kind of  warnings messages :


First Message:


Row: 76 SQL error: -746(25040)
   Error executing "update NumPlan set fkRoutePartition=NULL where pkid='6e4e4d45-b233-424e-ba5c-065421c445ee'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(25040)
      pkid                       6e4e4d45-b233-424e-ba5c-065421c445ee  NOT MODIFIABLE
      fkRoutePartition          
      DNOrPattern                7
      tkPatternUsage             4  NOT MODIFIABLE
      CFBDestination            
      CFNADestination           
      fkRouteFilter             
      tkNetworkLocation          0
      fkDigitDiscardInstruction 
      PrefixDigitsOut           
      BlockEnable                false
      tkMixer                   
      CalledPartyTransformationMask 
      fkCallingSearchSpace_SharedLineAppear  61779b5b-6941-4527-88ce-5baf31640078
      fkDialPlan                
      fkCallingSearchSpace_Translation 
      CallingPartyTransformationMask 
      PatternUrgency             false
      tkStatus_useFullyQualCallingPartyNum  2
      fkCallingSearchSpace_CFB  
      fkCallingSearchSpace_CFNA 
      DialPlanWizardGenID       
      UserHoldMOHAudioSourceID  
      NetworkHoldMOHAudioSourceID 
      CallForwardExpansionMask  
      tkAutoAnswer               0
      PersonalRoutingEnabled     false
      DeviceFailureDN           
      fkCallingSearchSpace_DeviceFailure 
      CallingPartyPrefixDigits  
      fkCallingSearchSpace_MWI  
      fkVoiceMessagingProfile   
      CFBVoiceMailEnabled        false
      CFNAVoiceMailEnabled       false
      CFDFVoiceMailEnabled       false
      fkAARNeighborhood         
      withTag                   
      withValueClause           
      Description               
      CFNADuration              
      tkPatternPrecedence        5
      CFAPTVoiceMailEnabled      false
      CFAPTDestination          
      tkReleaseCauseValue        0
      fkCallingSearchSpace_CFAPT 
      tkPresentationBit_ConnectedLine  0
      tkPresentationBit_CallingName  0
      tkPresentationBit_ConnectedName  0
      tkPresentationBit_CallingLine  0
      SupportOverlapSending      false
      CFAPTDuration             
      isCallable                 true
      fkCallManager             
      AlertingName              
      AuthorizationCodeRequired  false
      AuthorizationLevelRequired  0
      CFBIntDestination         
      CFBIntVoiceMailEnabled     false
      CFNAIntDestination        
      CFNAIntVoiceMailEnabled    false
      ClientCodeRequired         false
      CSSForCFA                 
      fkCallingSearchSpace_CFBInt 
      fkCallingSearchSpace_PFF  
      fkCallingSearchSpace_PFFInt 
      PFF_CFB                    false
      PFF_CFNA                   false
      PFFDestination            
      PFFIntDestination         
      PFFIntVoiceMailEnabled     false
      PFFVoiceMailEnabled        false
      fkCallingSearchSpace_Reroute    NOT MODIFIABLE
      fkMatrix_Presence          ad243d17-98b4-4118-8feb-5ff2e1b781ac
      fkCallingSearchSpace_CFNAInt 
      IsMessageWaitingOn         false
      OutsideDialtone            false
      DeviceOverride             false
      AllowCTIControlFlag        true
      AlertingNameASCII         
      resetToggle                false
      tkReset                    2
      AARDestinationMask        
      AARKeepCallHistory         true
      AARVoiceMailEnabled        false
      CFHRDN                    
      CFHRIntDN                 
      CFHRIntVMEnabled           false
      CFHRVMEnabled              false
      CFURDestination           
      CFURIntDestination        
      CFURIntVoiceMailEnabled    false
      CFURVoiceMailEnabled       false
      fkCallingSearchSpace_CFHR 
      fkCallingSearchSpace_CFHRInt 
      fkCallingSearchSpace_CFUR 
      fkCallingSearchSpace_CFURInt 
      fkCallingSearchSpace_revert 
      HRDuration                
      HRInterval                
      ikNumPlan_ParkCode        
      RevertDestination         
      CFHRDuration              
      tkDeviceSecurityMode_MinimumAllowed 
      tkCFACSSActivationPolicy   0
      fkResourcePriorityNamespace 
      tkNumberingPlan_Called     0
      tkPriOfNumber_Called       0
      tkPriOfNumber_Calling      0
      tkNumberingPlan_Calling    0
      fkDevice_IntercomDefault  
      DNOrPatternIPv6           
      tkStatus_PartyEntranceTone  2
      ParkMonForwardNoRetrieveDN 
      ParkMonForwardNoRetrieveIntDN 
      ParkMonForwardNoRetrieveIntVMEnabled  false
      ParkMonForwardNoRetrieveVMEnabled  false
      fkCallingSearchSpace_PkMonFwdNoRet 
      fkCallingSearchSpace_PkMonFwdNoRetInt 
      ParkMonReversionTimer     



Second message:


Row: 1046 SQL error: -746(35259)
   Error executing "update PhoneButton set ButtonNum=22 where pkid='7926e6fd-7c8f-4966-8fa8-5c37c669f738'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error =  -746. sqlerrm(35259)
      pkid                       7926e6fd-7c8f-4966-8fa8-5c37c669f738  NOT MODIFIABLE
      fkPhoneTemplate            b7371212-0ddc-4fa2-9abd-37bd8848ad7c  NOT MODIFIABLE
      ButtonNum                  22
      tkFeature                  255
      Label                      None
      ParamN1                    14
      ParamN2                   
      ParamT1                   
      ParamT2                   
      isFixedFeature             false  NOT MODIFIABLE
      resetToggle                false
      tkReset                    2



if you have any ideas about what could the cause of those messages i'll be really grateful.



Best regards



Omar

Actions

This Discussion