Hi,
I am having issue upgrading from cucm 9.1.2 to 11.0(1a)SU1.
I have collected the installdb_ru.log.err (output below) and it is pointing to an issue database issue with the DX630 (phonetemplate, phonebutton,Security Profile, Defaults)
Has anyone had a similar issue while upgrading?
Is removing the DX630 from the db an option as i do not have any deployed?
Any advice on correcting this issue?
17:31:01.423 |*ERROR* Error executing "insert into PhoneTemplate (name,numofbuttons,pkid,privatetemplate,resettoggle,tkdeviceprotocol,tkmodel,tkreset,usermodifiable,versionstamp) values ('Cisco DX630 SIP',15,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','F',11,654,2,'F','1415335262-5967a075-142b-4e28-8a2e-668527c6a44a'): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.tk_phonetemplate_tkmodel).
17:31:31.236 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (3,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Redial',1,0,'097f19f8-0bb5-4b87-ada1-c8486dcf5141','F',1,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:31.533 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (4,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial2',1,0,'19d8ff84-6743-4fa1-a19d-f11e45a3a9f5','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:32.019 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (13,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial11',10,0,'2d769575-2b1e-4c00-ac9f-4bdfe37f7f20','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:33.513 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (14,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial12',11,0,'6be454ab-cf7b-40e6-b075-afd6e4efbf36','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:33.644 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (8,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial6',5,0,'71d60924-1515-4c72-8da3-b75c4ef6a0bd','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:34.054 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (9,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial7',6,0,'839e08ee-cb91-41a5-aa13-823174beb825','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:34.237 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (6,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial4',3,0,'8e88e5ce-151a-4c63-93b4-415868280422','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:34.316 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (15,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial13',12,0,'943dd3ac-1678-45ba-ae53-a06ef64ccd9f','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:34.486 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (5,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial3',2,0,'9a84e034-b5e4-43bf-8cac-cbfa8bc267b0','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:35.030 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (1,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','T','Line1',1,0,'b5113315-2af8-45b7-a810-8de7f1596f88','F',9,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:35.131 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (11,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial9',8,0,'bca86eb0-357e-4bb9-a98e-5d47659e9534','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:35.138 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (7,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial5',4,0,'bd7816fe-8764-49fb-a238-dd0ae7ec92c7','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:35.198 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (10,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial8',7,0,'c10048ea-c863-473f-8140-932551003b3f','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:35.954 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (12,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Speed Dial10',9,0,'e25099a9-08ef-4f75-85ee-0bcd8d5db859','F',2,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:36.308 |*ERROR* Error executing "insert into phonebutton (buttonnum,fkphonetemplate,isfixedfeature,label,paramn1,paramn2,pkid,resettoggle,tkfeature,tkreset) values (2,'26f2ae5d-fea3-4715-8ae6-2a76b98cb804','F','Line2',2,0,'f8aeb8b9-df4f-499b-865f-4ad72f1ce795','F',9,2): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.fk_phonebutton_fkphonetemplate).
17:31:37.712 |*ERROR* Error executing "insert into SecurityProfile (aclallowreplace,acloobsubscription,acloodrefer,aclpresencesubscription,aclunsolicitednotification,allowchargingheader,applevelauth,description,digestauthall,excludedigestcredflag,incomingport,isstandard,name,noncepolicytime,pkid,resettoggle,serveriphostname,tftpencryptedflag,tkauthenticationmode,tkdeviceprotocol,tkdevicesecuritymode,tkkeysize,tkmodel,tkreset,tksecuritypolicy,tktransport,tktransport_out,tkv150sdpfilter,transmitsecuritystatus,versionstamp,x509subjectname) values ('F','F','F','F','F','F','F','Cisco DX630 - Standard SIP Non-Secure Profile','F','F',5060,'T','Cisco DX630 - Standard SIP Non-Secure Profile',600,'92c06f7e-f927-48cb-95ab-7711bfbc9b9a','F','','F',2,11,1,2,654,2,4,4,4,3,'F','1415335262-4862a7e9-eaff-47e4-9f89-76c3351aabf0',''): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.tk_securityprofile_tkmodel).
17:32:06.416 |*ERROR* Error executing "insert into Defaults (fkdevicepool,fkphonetemplate,inactiveloadinformation,loadinformation,pkid,resettoggle,tkdeviceprotocol,tkmodel,tkreset,versionstamp) values ('1b1b9eb6-7803-11d3-bdf0-00108302ead1','26f2ae5d-fea3-4715-8ae6-2a76b98cb804','','','b95a7e05-a0b5-4c25-a629-284fd902be50','F',11,654,2,'0000000000-c7a6c673-7479-46b0-839e-014d3d093963'): [Informix][Informix ODBC Driver][Informix]Missing key in referenced table for referential constraint (informix.tk_defaults_tkmodel).
17:32:56.265 | installFull *ERROR* Prior Cancel or Error Processing convert5to6()
