Informix upgrade from 9.30 to 11.50FC6 fail

Posted in 2010

Topics: Installation, Setup & Upgrades, Error Codes & Troubleshooting, Data Types & Schema Design

Chin, Paul — Sat, 03 Apr 2010 09:17:12 — source: IIUG Forums & Mailing Lists

Anyone have any idea? I have drop all extended row type, all procedure the deals with complex data type, and still get the same error. 02:57:55 *** SQL 11 11.50xC6 *** 02:57:55 Must drop type with extended_id (2078) before conversion 02:57:55 Must drop type with extended_id (2079) before conversion 02:57:55 Must drop type with extended_id (2118) before conversion 02:57:55 Conv/rev: Failed to convert component SQL to component version 32 02:57:55 Conv/rev: Failed in check phase of conversion for component SQL 02:57:55 Conversion failed. 02:57:55 *** Conversion failed *** CONVERSION_GUARD was on. To go back to the original version of IDS, run onrestorept. 02:57:55 Assert Failed: *** Conversion failed *** CONVERSION_GUARD was on. To go back to the original version of IDS, run onrestorept. paul.

↪ replying to Chin, Paul

Art Kagel — Sun, 04 Apr 2010 02:15:35 — source: IIUG Forums & Mailing Lists

Open a support case with IBM. Conversion guard is a new feature in 11.50xC6 and you may be running into a bug in that. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Apr 3, 2010 at 5:17 AM, Chin, Paul (TSG-OSDO) <pchin@hp.com> wrote: > Anyone have any idea? I have drop all extended row type, all procedure the > deals with complex data type, and still get the same error. > > 02:57:55 *** SQL 11 11.50xC6 *** > 02:57:55 Must drop type with extended_id (2078) before conversion > 02:57:55 Must drop type with extended_id (2079) before conversion > 02:57:55 Must drop type with extended_id (2118) before conversion > 02:57:55 Conv/rev: Failed to convert component SQL to component version 32 > 02:57:55 Conv/rev: Failed in check phase of conversion for component SQL > 02:57:55 Conversion failed. > 02:57:55 *** Conversion failed *** > > CONVERSION_GUARD was on. To go back to the original version > > of IDS, run onrestorept. > 02:57:55 Assert Failed: *** Conversion failed *** > > CONVERSION_GUARD was on. To go back to the original version > > of IDS, run onrestorept. > > paul. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517447c62691d6004835fc9fd

↪ replying to Art Kagel

Chin, Paul — Mon, 05 Apr 2010 21:51:10 — source: IIUG Forums & Mailing Lists

You are right, IBM has identified it to be a defect when a conversion from 32b to 64b where server aborts when recognizing certain collection types, to be fixed in FC7. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Sunday, 4 April 2010 12:16 PM To: ids@iiug.org Subject: Re: Informix upgrade from 9.30 to 11.50FC6 fail [19496] Open a support case with IBM. Conversion guard is a new feature in 11.50xC6 and you may be running into a bug in that. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Apr 3, 2010 at 5:17 AM, Chin, Paul (TSG-OSDO) <pchin@hp.com> wrote: > Anyone have any idea? I have drop all extended row type, all procedure > the deals with complex data type, and still get the same error. > > 02:57:55 *** SQL 11 11.50xC6 *** > 02:57:55 Must drop type with extended_id (2078) before conversion > 02:57:55 Must drop type with extended_id (2079) before conversion > 02:57:55 Must drop type with extended_id (2118) before conversion > 02:57:55 Conv/rev: Failed to convert component SQL to component > version 32 > 02:57:55 Conv/rev: Failed in check phase of conversion for component > SQL > 02:57:55 Conversion failed. > 02:57:55 *** Conversion failed *** > > CONVERSION_GUARD was on. To go back to the original version > > of IDS, run onrestorept. > 02:57:55 Assert Failed: *** Conversion failed *** > > CONVERSION_GUARD was on. To go back to the original version > > of IDS, run onrestorept. > > paul. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517447c62691d6004835fc9fd ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.