cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
483
Views
0
Helpful
2
Replies

CUCM 9.1.2 upgrade to 11.0(1a)SU1 failing

Z W
Level 1
Level 1

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()

2 Replies 2

Suresh Hudda
VIP Alumni
VIP Alumni

You should involve TAC for this as there are error for several DB tables, don't think you will get much & quick help on this from supportforums.

Suresh

Atul Gaba
Cisco Employee
Cisco Employee

The error seems to be related to the DX630 phone template and SIP profile. Removing the two should take care of the errors.

-Atul

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: