CUCM 10.5.2.12901-1 Upgrade To version 11.0.1.10000-10

[shacharalon7]

Hi All, 

I am trying to upgrade CUCM and IMP servers from version 10.5.2.12901-1 to version 11.0.1.10000-10.

For some reason the installation fails.

The cluster contains single node from each server, i started from the CUCM but it failed.

I exported Installation logs from the inactive partition (attached)

I would appreciate if you experts can take a look at them.

BR

Shachar

[Jaime Valencia]

Did you go thru them to try and find any errors???

[shacharalon7]

I did and i found the following errors:

04/06/2016 11:03:08 component_install|(CAPTURE) installdb Failure [-i] 1|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) -----------------------------------|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) installdb_l2.log.err file contents:|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:19.165 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (1,'71bbbb74-3a3c-5ab8-6802-9b73e7d50b90','T','Line',1,0,'5597c541-817d-4dba-9f3c-d0b10a9ec7e1','F',9,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:19.166 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (2,'71bbbb74-3a3c-5ab8-6802-9b73e7d50b90','F','Line',2,0,'b39e745c-04b6-4531-ac2b-4055fba2accd','F',9,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:19.166 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (3,'71bbbb74-3a3c-5ab8-6802-9b73e7d50b90','F','Speed Dial',1,0,'5e1b2be2-338a-42a6-8cb5-fe0efcf33dec','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:19.167 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (4,'71bbbb74-3a3c-5ab8-6802-9b73e7d50b90','F','Speed Dial',2,0,'e763a0f0-3c99-4cef-9ea8-38281eb953cc','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:19.168 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (5,'71bbbb74-3a3c-5ab8-6802-9b73e7d50b90','F','Speed Dial',3,0,'43546cb6-6c07-4be9-821e-e9b97b19be41','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:40.073 |*ERROR* Error executing "insert into device (allowcfbcontrolofcallsecurityicon,allowcticontrolflag,allowhotelingflag,authenticationstring,calledinternationalprefix,callednationalprefix,calledsubscriberprefix,calledunknownprefix,calreference,defaultdtmfcapability,description,deviceleveltraceflag,dndtimeout,earlyoffersupportforvoicecall,enablebfcp,enablecallroutingtordwhennoneisactive,enablegatewayrecordingqsig,enableixchannel,fkcommonphoneconfig,fkdevicepool,fkenduser,fklocation,fkmatrix_presence,fkmediaresourcelist,fkphonetemplate,fksecurityprofile,fksipprofile,fksoftkeytemplate,hotlinedevice,huntlistforvm,ignorepi,internationalprefix,isactive,isdualmode,ispaienabled,isprotected,isrpidenabled,isstandard,istrustedrelaypoint,md5hash,mtprequired,name,nationalprefix,ndescription,packetcaptureduration,pkid,pstnaccess,remotedevice,requirecerlocation,requiredtmfreception,resettoggle,retryvideocallasaudio,rfc2833disabled,routelistenabled,runonallnodes,sendgeolocation,srtpallowed,srtpfallback|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:40.086 |*ERROR* Error executing "insert into device (allowcfbcontrolofcallsecurityicon,allowcticontrolflag,allowhotelingflag,authenticationstring,calledinternationalprefix,callednationalprefix,calledsubscriberprefix,calledunknownprefix,calreference,defaultdtmfcapability,description,deviceleveltraceflag,dndtimeout,earlyoffersupportforvoicecall,enablebfcp,enablecallroutingtordwhennoneisactive,enablegatewayrecordingqsig,enableixchannel,fkcommonphoneconfig,fkdevicepool,fkenduser,fklocation,fkmatrix_presence,fkmediaresourcelist,fkphonetemplate,fksecurityprofile,fksipprofile,fksoftkeytemplate,hotlinedevice,huntlistforvm,ignorepi,internationalprefix,isactive,isdualmode,ispaienabled,isprotected,isrpidenabled,isstandard,istrustedrelaypoint,md5hash,mtprequired,name,nationalprefix,ndescription,packetcaptureduration,pkid,pstnaccess,remotedevice,requirecerlocation,requiredtmfreception,resettoggle,retryvideocallasaudio,rfc2833disabled,routelistenabled,runonallnodes,sendgeolocation,srtpallowed,srtpfallback|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:40.105 |*ERROR* Error executing "insert into device (allowcfbcontrolofcallsecurityicon,allowcticontrolflag,allowhotelingflag,authenticationstring,calledinternationalprefix,callednationalprefix,calledsubscriberprefix,calledunknownprefix,calreference,defaultdtmfcapability,description,deviceleveltraceflag,dndtimeout,earlyoffersupportforvoicecall,enablebfcp,enablecallroutingtordwhennoneisactive,enablegatewayrecordingqsig,enableixchannel,fkcommonphoneconfig,fkdevicepool,fkenduser,fklocation,fkmatrix_presence,fkmediaresourcelist,fkphonetemplate,fksecurityprofile,fksipprofile,fksoftkeytemplate,hotlinedevice,huntlistforvm,ignorepi,internationalprefix,isactive,isdualmode,ispaienabled,isprotected,isrpidenabled,isstandard,istrustedrelaypoint,md5hash,mtprequired,name,nationalprefix,ndescription,packetcaptureduration,pkid,pstnaccess,remotedevice,requirecerlocation,requiredtmfreception,resettoggle,retryvideocallasaudio,rfc2833disabled,routelistenabled,runonallnodes,sendgeolocation,srtpallowed,srtpfallback|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:41.801 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR devicehlogdynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:41.801 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:41.801 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table devicehlogdynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:42.022 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicehlogdynamic_fkdevice on the devicehlogdynamic table by the record with pkid = 8ab68027-864e-4921-a358-0fc121520fda. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:42.022 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicehlogdynamic_fkdevice on the devicehlogdynamic table by the record with pkid = 6b966b05-5216-4a3b-9470-49669f7ca47d. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:54:42.022 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicehlogdynamic_fkdevice on the devicehlogdynamic table by the record with pkid = cce4d377-e52d-4edc-806f-9c5dc568d4da. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.076 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.180 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (devicehlogdynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.545 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR devicemobilitydynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected.]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.545 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.545 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table devicemobilitydynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.708 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicemobilitydynamic_fkdevice on the devicemobilitydynamic table by the record with pkid = 47d1c8fa-9f5d-4a42-ae03-744a838a740b. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.708 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicemobilitydynamic_fkdevice on the devicemobilitydynamic table by the record with pkid = 7a0c1640-6036-434c-95ae-37f1adc5825f. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:11.708 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicemobilitydynamic_fkdevice on the devicemobilitydynamic table by the record with pkid = aaa1cfdd-a332-45fe-8dcf-1a788a2b7613. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.049 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.117 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (devicemobilitydynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.657 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR deviceprivacydynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected.]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.657 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.668 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table deviceprivacydynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.802 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_deviceprivacydynamic_fkdevice on the deviceprivacydynamic table by the record with pkid = 9d5d3c31-8f46-4dca-b3a8-d95ad785c909. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.802 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_deviceprivacydynamic_fkdevice on the deviceprivacydynamic table by the record with pkid = 616457cc-19cb-43d2-ab1c-f9d04a279e20. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:55:41.802 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_deviceprivacydynamic_fkdevice on the deviceprivacydynamic table by the record with pkid = 70daa123-299a-4979-b7d2-505074d35db3. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.056 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.123 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (deviceprivacydynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.320 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR devicerelatedversionstamp ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected.]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.320 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.320 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table devicerelatedversionstamp failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.364 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicerelatedversionstamp_fkdevice on the devicerelatedversionstamp table by the record with pkid = f4def991-8bf4-48a6-a028-067780a716df. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.364 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicerelatedversionstamp_fkdevice on the devicerelatedversionstamp table by the record with pkid = bb940473-c56e-4c7a-98c0-4e400c65eae5. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:11.364 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicerelatedversionstamp_fkdevice on the devicerelatedversionstamp table by the record with pkid = 6733cda4-6ae0-472e-9ec9-9623f603715e. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.053 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.123 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (devicerelatedversionstamp)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.274 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR devicetftpdynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.274 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.274 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table devicetftpdynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.319 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicetftpdynamic_fkdevice on the devicetftpdynamic table by the record with pkid = c4781f0d-3370-400c-8557-631bd7a43f74. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.319 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicetftpdynamic_fkdevice on the devicetftpdynamic table by the record with pkid = 19dbacb9-70c1-4f01-8486-fce2e247a756. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:56:41.319 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_devicetftpdynamic_fkdevice on the devicetftpdynamic table by the record with pkid = 7691c52f-a465-469e-8a78-9e9087e37c09. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.056 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.140 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (devicetftpdynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.701 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR dnddynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.701 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.701 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table dnddynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.761 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_dnddynamic_fkdevice on the dnddynamic table by the record with pkid = aeb28a18-e418-4f9c-80d1-45209081cfd6. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.761 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_dnddynamic_fkdevice on the dnddynamic table by the record with pkid = 15f4803e-2d8a-4e08-a4dd-3a6aa96ee7a4. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.761 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_dnddynamic_fkdevice on the dnddynamic table by the record with pkid = 5d2322de-02b8-45f2-afa7-b3fbdd3ce275. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.055 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.108 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (dnddynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.438 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR enduserdevicemap ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.438 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.438 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table enduserdevicemap failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.483 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_enduserdevicemap_fkdevice on the enduserdevicemap table by the record with pkid = 03d9f769-3461-eeb0-3132-dd03c5d04aca. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.483 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_enduserdevicemap_fkdevice on the enduserdevicemap table by the record with pkid = ec6639b1-645c-d4f1-269d-66bb79cdef8d. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:41.483 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_enduserdevicemap_fkdevice on the enduserdevicemap table by the record with pkid = d77c95cc-19c5-adac-23a3-770cc7c3b74d. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:11.058 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:11.133 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (enduserdevicemap)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:17.107 |*ERROR* Error executing "insert into DeviceNumplanMap (busytrigger,callinfodisplaymask,display,displayascii,fkdevice,fknumplan,label,labelascii,logmissedcalls,maxnumcalls,numplanindex,pkid,tkmwlpolicy,tkpartitionusage,tkpreferredmediasource,tkringsetting,tkringsetting_activepickupalert,tkringsetting_consecutive,tkringsetting_idlepickupalert,tkstatus_audiblemwi) values (2,9,'Shimon Hacoon','Shimon Hacoon','a2ad0182-aabb-0283-88b0-f2c5036b7264','0174571d-d5e0-f866-9365-7684d4a980a2','Shimon Hacoon','','T',4,1,'76503820-cf75-916c-5a70-2ab3e06c1376',0,99,1,0,0,0,0,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_devicenumplanmap_fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:17.108 |*ERROR* Error executing "insert into DeviceNumplanMap (busytrigger,callinfodisplaymask,display,displayascii,fkdevice,fknumplan,label,labelascii,logmissedcalls,maxnumcalls,numplanindex,pkid,tkmwlpolicy,tkpartitionusage,tkpreferredmediasource,tkringsetting,tkringsetting_activepickupalert,tkringsetting_consecutive,tkringsetting_idlepickupalert,tkstatus_audiblemwi) values (2,9,'Yoram Sadan','Yoram Sadan','32c6f6f2-8de0-e80c-45da-7df5183acf48','0fe1c9b4-5028-abb7-c84a-88802c187751','Yoram Sadan','','T',4,1,'5dac6678-7fe3-873b-406a-25871b191223',0,99,1,0,0,0,0,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_devicenumplanmap_fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:17.109 |*ERROR* Error executing "insert into DeviceNumplanMap (busytrigger,callinfodisplaymask,display,displayascii,fkdevice,fknumplan,label,labelascii,logmissedcalls,maxnumcalls,numplanindex,pkid,tkmwlpolicy,tkpartitionusage,tkpreferredmediasource,tkringsetting,tkringsetting_activepickupalert,tkringsetting_consecutive,tkringsetting_idlepickupalert,tkstatus_audiblemwi) values (2,9,'Igor Vinokur','Igor Vinokur','951c95e0-7d5e-7c68-0b10-2a135c2292d0','3cea7e0a-4d78-9fe9-adad-9659031a8269','Igor Vinokur','','T',4,1,'f6650428-a986-34a7-7f66-cab258745e05',0,99,1,0,0,0,0,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_devicenumplanmap_fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.829 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR recordingdynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected.]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.829 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.829 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table recordingdynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.880 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_recordingdynamic_fkdevicenumplanmap on the recordingdynamic table by the record with pkid = 68e36ae3-8084-45c7-8de7-baba727530a2. Referenced devicenumplanmap record must exist (fkdevicenumplanmap).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.880 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_recordingdynamic_fkdevicenumplanmap on the recordingdynamic table by the record with pkid = 538a66eb-1c38-4b3d-b0e7-c0bf02484a96. Referenced devicenumplanmap record must exist (fkdevicenumplanmap).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:18.880 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_recordingdynamic_fkdevicenumplanmap on the recordingdynamic table by the record with pkid = 12304d03-2d51-41b6-ab8d-c232f4fa28ae. Referenced devicenumplanmap record must exist (fkdevicenumplanmap).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.065 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.126 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (recordingdynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.356 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR registrationdynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected.]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.356 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.356 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table registrationdynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.400 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_registrationdynamic_fkdevice on the registrationdynamic table by the record with pkid = b4cd19b3-82e3-4374-9dcb-2c71522cd3e1. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.400 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_registrationdynamic_fkdevice on the registrationdynamic table by the record with pkid = 0cd3cd5a-d197-4ed9-b300-57eeb204ceb9. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:58:48.400 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_registrationdynamic_fkdevice on the registrationdynamic table by the record with pkid = 3dc1677f-1d09-4066-b692-75282d23f575. Referenced device record must exist (fkdevice).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.067 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.140 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (registrationdynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.289 |*ERROR* Error executing "insert into remoteDestination (fkdevice_sipline,pkid,tktimezone,tkvmavoidancepolicy,tkvmavoidancepolicy_dvor) values ('a2ad0182-aabb-0283-88b0-f2c5036b7264','0694dc70-7e78-447c-b627-c07bd3d25104',22,0,0): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_remotedestination_fkdevice_sipline).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.289 |*ERROR* Error executing "insert into remoteDestination (fkdevice_sipline,pkid,tktimezone,tkvmavoidancepolicy,tkvmavoidancepolicy_dvor) values ('32c6f6f2-8de0-e80c-45da-7df5183acf48','a481a293-a776-467d-9028-2fa93d88463c',22,0,0): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_remotedestination_fkdevice_sipline).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.290 |*ERROR* Error executing "insert into remoteDestination (fkdevice_sipline,pkid,tktimezone,tkvmavoidancepolicy,tkvmavoidancepolicy_dvor) values ('951c95e0-7d5e-7c68-0b10-2a135c2292d0','e58098e9-3228-42e4-bfc4-9ca84222eb84',22,0,0): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_remotedestination_fkdevice_sipline).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.891 | DBUtil::DoSQLCommand ### *ERROR* ###: SQL applicationdialrule.csv|<LVL::Debug>

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

/06/2016 11:03:08 component_install|(CAPTURE) Exception detected while Enabling Target Table Constraints [Error executing "SET CONSTRAINTS FOR remotedestinationdynamic ENABLED": [Informix][Informix ODBC Driver][Informix]Integrity violations detected. sqlerrm(assign)]|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.891 | DBUtil::BlockCopyTable ### *ERROR* ###: SQL Exception Detected: ErrorCode=-971 , SQLState=HY000|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.891 | DBUtil::BlockCopyTable ### *ERROR* ###: (diagnosis): Bulk Data Migration for table remotedestinationdynamic failed due to data constraint issue, (-971).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.941 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_remotedestinationdynamic_fkremotedestination on the remotedestinationdynamic table by the record with pkid = 09fb8cf3-0926-479b-ad24-1b6fbf85c699. Referenced remotedestination record must exist (fkremotedestination).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.941 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_remotedestinationdynamic_fkremotedestination on the remotedestinationdynamic table by the record with pkid = 76b11b7f-807b-45ce-94e4-d91ad7f86f3c. Referenced remotedestination record must exist (fkremotedestination).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:18.941 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_remotedestinationdynamic_fkremotedestination on the remotedestinationdynamic table by the record with pkid = ff4f9465-ebaf-4ec2-8b10-beca1b91ca56. Referenced remotedestination record must exist (fkremotedestination).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:48.070 |*ERROR* Error fetching column information: [Informix][Informix ODBC Driver][Informix]Could not position within a table (informix.systables).|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:48.139 | DataConverter_5to6::CopyTables *ERROR* BlockCopyTable failed to process table (remotedestinationdynamic)|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) 10:59:51.387 | installFull *ERROR* Prior Cancel or Error Processing convert5to6()|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) -----------------------------------|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) ------------------------------|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) psqlx_output.log.err contents:|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) ------------------------------|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) Started onshutdown.sh|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) Setting default timeout to 30 seconds.|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) ********************************************************|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) !!! WARNING !!!|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) |<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) THE onshutdown SCRIPT WILL TRY TO SHUTDOWN AND TERMINATE|<LVL::Debug>
04/06/2016 11:03:08 component_install|(CAPTURE) THIS IDS INSTANCE bycucm_pub_ccm11_0_1_10000_10 UNCONDITIONALLY!|<LVL::Debug>

[shacharalon7]

Im not sure if its related, but i noticed that the hostname of the server is not as it should be, in the log it appears as follow:

04/06/2016 11:03:08 component_install|(CAPTURE) Attempting to shutdown bycucm_pub_ccm11_0_1_10000_10 in 30 seconds...|<LVL::Debug>

the real hostname is: bycucm-pub

[Jaime Valencia]

There seem to be a lot of problems in the DB, in many parts, phone button template, hlog, and maybe even some orphaned entries

04/06/2016 11:03:08 component_install|(CAPTURE) 10:57:11.761 | DBUtil::BlockCopyTable *ERROR* Violation of the REFERENTIAL constraint fk_dnddynamic_fkdevice on the dnddynamic table by the record with pkid = 5d2322de-02b8-45f2-afa7-b3fbdd3ce275. Referenced device record must exist (fkdevice).|<LVL::Debug>

You might want to open a TAC so someone takes a good look at this, and your config to correct this.

[Suresh Hudda]

Try below things once, if no luck then go for tac as Jaime suggested.

Disable Extension Mobility service.

Disable Auto registration.

Remove scheduled backup if any.

Remove backup device if any.

Then try to upgrade.

Suresh