When upgrading from CCM 4.1(3) to Cisco UCM 7.x we got an error using the Data Migration Assistant (DMA 7.1(3)). The DMA starts and at the same time it stopps the "Informix IDS - ccm" service. After configuring the prerequisits the DMA checks the "Informix IDS - ccm" service and ended with the error "Error connecting to Database". We were not able to start the "Informix IDS - ccm" service manually.
We fixed the problem by stopping the "Informix Server Discovery process for SNMP" after the publisher was restarted. If this service is stopped before starting the DMA the "Informix IDS - ccm" service keeps running and the migration is running succesfull.
When running DMA for migration from CCM 4.2(3) to CUCM 7.1(3) the result is; "Export Successful.Validation Successful with Warnings"
The information from the DMA warnings were collected and following corrective actions are recommended:
Warning: UserID:rdavé: is invalid - User profile not found in LDAP search
Condition: The user profile for the user does not exist Solution: you need to verify that the user is a valid CUCM user. For that you need to access the user through the CUCM Admin page and associate a device to the user. Then disassociate the same device. This procedure will create the requiredprofile for the user
Warning: Numplan (NULL) for User pmorton is invalid. Ignoring the user
Condition: Primary Extension for this user is invalid. It does not exist inthe database Solution: You need to ensure that the user is associated with a valid primary extension/numplan
Regarding these warnings:
Row: 2 SQL error: -746(36071)
Error executing "update VoiceMessagingProfile set Name='VMP - Conted Queue' where pkid='87904580-168b-452c-9a42-32198ca12896'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(36071)
pkid 87904580-168b-452c-9a42-32198ca12896 NOT MODIFIABLE
Error executing "update VoiceMessagingProfile set Name='Health Services Transfer to 6326' where pkid='7ec0d62d-2d3d-486f-9f3a-afe51e9e39b9'": [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -746. sqlerrm(36071)
pkid 7ec0d62d-2d3d-486f-9f3a-afe51e9e39b9 NOT MODIFIABLE
Name Health Services Transfer to 6326
Description Health Services Transfer VM calls to 6326
Solution: You need to make sure that you have the names and description populated withoutany special characters and less than 24 characters in all.
Also, You need to delete if there is any unassigned DNs in your system.
DMA Validation Fails
While trying to perform DMA, you got this error "Export - Successful. Validation - Failed."
Resolution After checking DMA logs found the following error:
***> DATA PROCESSING TESTS REVEALED AN ISSUE WHICH GENERATED THE FOLLOWING EVENT:
The error number is: [-391] The error message is: [-391 Cannot insert a null into column column-name.]
The following additional event information is available:
This record was not processed because it is missing a required value.
This could also be caused by specifying the value NULL in a required field.
Suspected Field/Item Is [enduser.lastname]
This issue was occurred because there are some users in your system without last name/ sure name and this field is
required so it shouldn't be NULL, after adding sure name, the problem is resolved.