IDS 9.40 crash

Hello, Can anyone help my with this error message ? What do I have I to check t? My working box is: IDS version is 9.40.UC2, running on Sun-Fire-V240 with SOLARIS 8 Here under there is an extract from the assertion file generated on IDS crash: 11:22:08 IBM Informix Dynamic Server Version 9.40.UC2 11:22:08 Assert Failed: No Exception Handler 11:22:08 Who: Session(16, aaa@tom, 22103, bf0c778) Thread(56, sqlexec, bedc858, 1) File: mtex.c Line: 431 11:22:08 Results: Exception Caught. Type: MT_EX_OS, Context: mem 11:22:08 Action: Please notify IBM Informix Technical Support. 11:22:08 Stack for thread: 56 sqlexec base: 0x0c835000 len: 36864 pc: 0x0071190c tos: 0x0c83cad0 state: running vp: 1 0x00710cf0 (oninit)afhandler(0xb74800, 0x9eb400, 0xbd09cf8, 0x1, 0x601, 0x601) 0x007104e4 (oninit)afcrash_interface(0xae7c94, 0xc83d260, 0xbd09cf8, 0xae7cac, 0x1af, 0x0) 0x00714e54 (oninit)mt_ex_throw_sig(0x9ea2e0, 0xae4e30, 0xb71ce8, 0xae7c68, 0xc40f8e0, 0x0) 0x006e1d80 (oninit)afsig_handler(0xb, 0xc83d810, 0xc83d558, 0x0, 0x0, 0x0) 0xff1108f8 </usr/platform/SUNW,Sun-Fire-V240/lib/libc_psr.so.1>memcpy(0xb62b44, 0xb6bc84, 0x13, 0x13, 0x70014, 0x13) 0x003d10d8 (oninit)_igetpbuf(0x70001, 0x13, 0x0, 0x0, 0x0, 0x4) 0x003776cc (oninit)getval (0xb6bc00, 0xc88b0f8, 0x0, 0x1000, 0xc845d10, 0xc88b0f8) 0x00352784 (oninit)sq_bind (0xb7ea4c, 0xc83dae0, 0xc83db58, 0x9, 0x2, 0xffffffff) 0x003cac68 (oninit)sqmain (0x5, 0xb7e800, 0x9e9000, 0x1020, 0xb6bc84, 0x1000) 0x007330c0 (oninit)listen_verify(0xa1c500, 0xa, 0x9e9200, 0xaeaeb0, 0x0, 0xc4f60a8) 0x006ef3f8 (oninit)startup (0xb748ac, 0x7, 0xb63000, 0x0, 0xc40f8e0, 0x0) 0x00739908 (oninit)net_wait_for_io(0x0, 0x0, 0x0, 0x0, 0x0, 0x0) 0x00000000 (*nosymtab*)0x0 Thank you

Hello Carl, Thank you for the answer. Is true that: - the same application is working fine on other machine with IDS 9.30 UC2 - the application has to perform prepared statements for insert/update in a loop with different values (sometimes null), get from an input file - in my application, I'm passing strings for DATETIME column Maybe I have now to solutions: - to correct my application and to use the appropriate data types for my host variables - to upgrade the IDS version Best regards, Elena Carl Williams Jr <carljr@us.ibm.com> 10/06/2006 03:59 PM To Elena.Nemtisor@softnet.ro cc Subject Re: IDS 9.40 crash [7584] Hello Elena, Reviewing the diagnostic info collected in AF indicates that you have hit bug #163135 (see below long description). Currently this bug is fixed in 9.40.UC3 and higher versions of the engine. Bug: 163135 EXECUTING A PREPARED STATEMENT WHICH USES A HOST VARIABLE IN A COMPARISON CONDITION WITH AN INTEGER COLUMN CRASHES THE SERVER (9.40 ONLY) Description: The server crashes executing a prepared statement in a loop and passing an empty string to a placeholder variable if the previous and next values are strings which can be casted to numeric values. I could reproduce the problem using ESQL/C and Perl(pssing undef values) on IDS 9.40. It did not reproduce on 9.30. Hope this helps -- carl Carl Williams Jr. Technical Support Engineer IBM Information Management Solutions Tel: (913) 928-5333 Ext. 3660 T/L: 337-5260 Toll Free: 1-800-IBM-SERV Take Back Control of your Information, your Risk, your Markets and your Future. Don't miss the IBM Information On Demand 2006 global conference in Anaheim, California on October 15th - 20th! This conference incorporates 6 previous Information Management technical conferences (DB2 Information Management, IMS and Content Management Technical Conferences, Business Intelligence Customer Solution Summit and Information Integration Live), plus it contains a new business leadership program, special advanced technology, architect and developer activities, and other Information On Demand topics. Register now to take advantage of the early bird discount!