Re: 7.31.UD8 migration to 10.00.UC4 failed with :Con/rev: Failed to convert for Component SQL

I see it isn't going that well on your convertion sir. I was wondering how you where doing... The following is a database? ... processing tsecure ... It looks like the upgrade processed a few database before this one. I would suggest (just for fun) dropping this database and doing the upgrade. This will limit your search for what maybe "off". It could be SPL, Trigger, or a table that has something "custom" in it that cannot be converted. I read online someone one suggesting it was the way the databases where shut down and to follow the folloing before the upgrade. onmode -kuy oninit -s onmode -c onmode -kuy; I don't think this is your issue... Maybe staging this upgrade as two parts? 7 -> 9 -> 10? Eric B. Rowell On 9/19/06, jpierrot@chubb.com <jpierrot@chubb.com> wrote: > > > > > Hi Gang, > > During a migration from 7.31.UD8 to 10.00.UC4 I ran into the following > error during the conversion : Con/rev: Failed to convert for Component SQL. > Then the engine crashed and had not been able to bring it backup due to > corruption in sysmaster. Since it was a test env, I restored the > environment and restarted. For a second time it failed for the same reason > and same place. Any help or thoughts would be greatly appreciated. > > AIX 5.2 > IDS 7.31.UD8 > > > 09:25:25 > 09:25:25 IBM Informix Dynamic Server Version 10.00.UC4 Software Serial> Number AAA#B000000 > > 09:25:25 Assert Failed: Conv/rev: Failed to convert for component SQL > 09:25:25 Who: Session(16, informix@chbuxd08, 0, 7163d018) > Thread(151, convert, 71614018, 3) > File: framework.c Line: 668 > 09:25:25 Results: Dynamic Server must abort > 09:25:25 Action: Restart conversion after fixing the problem. > 09:25:25 Stack for thread: 151 convert> > base: 0x7165b000 > > ===========------------- - - - - - - > tail -100 /chbuxd08/opt/app/informix/log/toltp/msg.toltp: > > > 09:25:07 Onconfig parameter JVPHOME modified from <blank> to > /usr/informix/extend/krakatoa. > 09:25:07 Onconfig parameter JVPJAVAHOME modified from <blank> to > /usr/informix/extend/krakatoa/jre. > 09:25:07 Onconfig parameter JVPJAVAVM modified from libjava.so to > hpi:jvm:java:net:zip:jpeg. > 09:25:07 Onconfig parameter JVPLOGFILE modified from jvp.log to > /usr/informix/extend/krakatoa/jvp.log. > 09:25:07 Onconfig parameter JVPPROPFILE modified from .jvpprops to > /usr/informix/extend/krakatoa/.jvpprops. > 09:25:07 Onconfig parameter JVPJAVALIB modified from <blank> to /bin. > 09:25:07 Onconfig parameter JDKVERSION modified from <blank> to 1.3. > 09:25:07 Onconfig parameter JVPCLASSPATH modified from <blank> to > /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar. > > 09:25:07 Onconfig parameter LOGFILES modified from 129 to 258. > 09:25:07 Onconfig parameter LTAPEDEV modified from > /chbuxd08/opt/app/informix/log/mylog to /dev/null. > 09:25:07 Onconfig parameter LTXHWM modified from 50 to 70. > 09:25:07 Onconfig parameter LTXEHWM modified from 60 to 80. > 09:25:07 Onconfig parameter ALARMPROGRAM modified from > /chbuxd08/opt/app/informix/etc/log_full.sh to > /chbuxd08/opt/app/informix/etc/no_log.sh. > 09:25:07 Onconfig parameter BAR_DEBUG modified from 4 to 0. > 09:25:07 Onconfig parameter BAR_NB_XPORT_COUNT modified from 10 to 20. > 09:25:07 Onconfig parameter BAR_XFER_BUF_SIZE modified from 15 to 31. > 09:25:07 Onconfig parameter CDR_NIFRETRY modified from 300 to 0. > 09:25:07 Dataskip is now OFF for all dbspaces > 09:25:07 Checkpoint Completed: duration was 0 seconds. > 09:25:07 Checkpoint loguniq 59731, logpos 0x1130, timestamp: 0x833cf432 > > 09:25:07 Maximum server connections 0 > 09:25:08 Physical recovery completed, continuing Conversion > 09:25:08 Conv/rev: Started check phase of conversion for component RSAM > 09:25:08 Conv/rev: Finished check phase of conversion for component RSAM> to component version 13 > 09:25:08 Conv/rev: Finished check phase of conversion for component RSAM> to component version 14 > 09:25:08 Conv/rev: Finished check phase of conversion for component RSAM > 09:25:08 Conv/rev: Started check phase of conversion for component SQL > 09:25:08 Conv/rev: Finished check phase of conversion for component SQL > 09:25:08 Conv/rev: Started check phase of conversion for component SMI > 09:25:08 Conv/rev: Finished check phase of conversion for component SMI > 09:25:08 Conv/rev: Started check phase of conversion for component BAR > 09:25:08 Conv/rev: Finished check phase of conversion for component BAR to> component version 1 > 09:25:08 Conv/rev: Finished check phase of conversion for component BAR to> component version 2 > 09:25:08 Conv/rev: Finished check phase of conversion for component BAR > 09:25:08 Conv/rev: Started check phase of conversion for component PLOAD > 09:25:08 Conv/rev: Finished check phase of conversion for component PLOAD > 09:25:08 Conv/rev: Started check phase of conversion for component RTREE > 09:25:08 Conv/rev: Finished check phase of conversion for component RTREE > 09:25:08 Conv/rev: Started check phase of conversion for component PAM > 09:25:08 Conv/rev: Finished check phase of conversion for component PAM to> component version 2 > 09:25:08 Conv/rev: Finished check phase of conversion for component PAM > 09:25:08 Conv/rev: Started conversion for component RSAM > 09:25:08 Conversion of pre 9.2 Database Tablespaces Started > 09:25:09 Started the Conversion of the Database Tablespace > 09:25:09 Alter Descriptor for database structure > 09:25:09 Succeeded > 09:25:09 The Conversion of the Database Tablespace is Finished > 09:25:09 Conversion of pre 9.2 Database Tablespaces Succeeded > 09:25:09 Conversion of bfrmap Started > 09:25:09 Conversion of bfrmap Succeeded > 09:25:09 Conv/rev: Finished conversion for component RSAM to component> version 13 > 09:25:09 Converting Secondary Partition Header Pages Started > 09:25:09 Converting Secondary Partition Header Pages Succeeded > 09:25:09 Conv/rev: Finished conversion for component RSAM to component> version 14 > 09:25:09 Update reserved page status of conversion > 09:25:09 Succeeded > 09:25:10 Checkpoint Completed: duration was 0 seconds. > 09:25:10 Checkpoint loguniq 59731, logpos 0x2018, timestamp: 0x833cf4fa > > 09:25:10 Maximum server connections 0 > 09:25:10 Quiescent Mode > 09:25:10 Internal Conversion Completed Successfuly > 09:25:10 Conversion Enabling Client Connections > 09:25:10 Conv/rev: Finished conversion for component RSAM > 09:25:10 Conv/rev: Started conversion for component SQL > 09:25:10 processing tcis > 09:25:10 Converting database tcis ... > 09:25:11 Single-User Mode. > 09:25:12 Logical Log 59731 Complete, timestamp: 0x833ea6e3. > 09:25:15 Conv/rev: Finished conversion for component SQL to component> version 26 > 09:25:15 Converting database tcis ... > 09:25:16 The database tcis has been converted successfully. > 09:25:16 Conv/rev: Finished conversion for component SQL to component> version 28 > 09:25:16 Conv/rev: Finished conversion for component