Error moving from ids 9.40fc9 to 11.50fc3

Hi All, I'm trying to migrate from IDS 9.40FC9 to 11.50FC3 on SOLARIS 10. Error below comes out when proceses reach my main database. I've checked full integrity with oncheck -cDI oncheck -cr oncheck -ce. Everything is OK. I checked basic topics mentioned at migration guide and certain parameters. I Think it's related to some datablade funcions. Any help? 13:52:12 processing dbmatrix 13:52:12 Converting database dbmatrix ... 13:52:18 Logical Log 40493 Complete, timestamp: 0x57fbb656. 13:52:22 Performance Advisory: Logical log file size might be too small for a checkpoint to complete. 13:52:22 Results: The size of individual logical log files is too small for the current workload, resulting in each log file filling very quickly. If log files fill in less than 30 seconds, the checkpoint might remain blocked because the last log file fills during the time needed to perform the checkpoint. 13:52:22 Action: Increase the size of the individual logical log files so that it takes at least 30 seconds to fill each one. Look at the online log to determine how quickly the log files are filling, and then increase the size of the files proportionately. 13:52:22 Logical Log 40494 Complete, timestamp: 0x57fca554. 13:52:25 Logical Log 40495 Complete, timestamp: 0x57fdb38a. 13:52:28 Logical Log 40496 Complete, timestamp: 0x57fed912. 13:52:30 Logical Log 40497 Complete, timestamp: 0x57ffa263. 13:52:31 The database dbmatrix has been converted successfully. 13:52:31 Conv/rev: Finished conversion for component SQL to component version 28 13:52:31 Converting database dbmatrix ... 13:52:36 Logical Log 40498 Complete, timestamp: 0x5800c56b. 13:53:36 Assert Failed: Exception Caught. Type: MT_EX_OS, Context: mem 13:53:36 IBM Informix Dynamic Server Version 11.50.FC3 13:53:36 Who: Session(9, informix@srvdesifx, 0, 1364d2998) Thread(38, convert, 136497f30, 4) File: mtex.c Line: 412 13:53:36 Action: Please notify IBM Informix Technical Support. 13:53:36 stack trace for pid 1778 written to /opt/ids11_50fc3/tmp/af.40ee575 13:53:36 See Also: /opt/ids11_50fc3/tmp/af.40ee575, shmem.40ee575.0 13:53:57 Exception Caught. Type: MT_EX_OS, Context: mem 13:53:57 (-9791): ERROR: Routine execution trap -- procname=<collectioninput> procid=20 reason: mem 13:54:01 Conversion failed with SQLCODE = -591 ISAMCODE = 0 13:54:01 The conversion of the database dbmatrix has failed. 13:54:01 Conv/rev: Failed to convert component SQL to component version 29 13:54:01 Conversion failed for component SQL : entity_ver 29 != target version 31 13:54:01 Assert Failed: Conv/rev: Failed to convert for component SQL 13:54:01 IBM Informix Dynamic Server Version 11.50.FC3 13:54:01 Who: Session(9, informix@srvdesifx, 0, 1364d2998) Thread(38, convert, 136497f30, 4) File: framework.c Line: 673 13:54:01 Results: Dynamic Server must abort 13:54:02 Action: Restart conversion after fixing the problem. 13:54:02 stack trace for pid 1778 written to /opt/ids11_50fc3/tmp/af.40ee575 13:54:02 See Also: /opt/ids11_50fc3/tmp/af.40ee575 13:54:08 framework.c, line 673, thread 38, proc id 1778, Conv/rev: Failed to convert for component SQL. 13:54:09 Fatal error in ADM VP at mt.c:13418 13:54:09 Unexpected virtual processor termination, pid = 1778, exit = 0x100 13:54:09 PANIC: Attempting to bring system down

I have been working with IBM IDS Support during almost 3 weeks. Together we can reproduce crash with only loading my database structure in 9.40 and then migranting it to 11.5 They haven't found what it's causing this crash. It seems to be related to complex data types. I will post support resolution...

Did you remember to drop your stored procedures, UDF, etc. before the upgrade. Some claim that's not necessary, but my experience is that some stored procedures will crash an upgrade. Dick Snoke IBM Data Management - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "PAULO RAFAEL PADILLA" <rafaelpadilla@grupomayan.com> To: ids@iiug.org Date: 02/03/2009 11:57 AM Subject: Re: Error moving from ids 9.40fc9 to 11.50fc3 [14714] Sent by: ids-bounces@iiug.org I have been working with IBM IDS Support during almost 3 weeks. Together we can reproduce crash with only loading my database structure in 9.40 and then migranting it to 11.5 They haven't found what it's causing this crash. It seems to be related to complex data types. I will post support resolution... ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

It's nice workaround, it works... Thanks In spite of we have to do extra tasks to save all procedures and drop them and load them after migration. Support gave same advice it's because extended datatypes used on SPs. They will continue searching how to fix this. that could be nice for IDS.