Abdul

As requested, call support

Keith

-> -----Original Message-----
-> From: abdoell@yahoo.com [mailto:abdoell@yahoo.com]
-> Sent: Thursday, October 07, 2004 7:34 AM
-> To: informix-list@iiug.org
-> Subject: Error -9791 when execute routine (procedure) - pls asap.....
->=20
->=20
-> Current Environment:
-> IDS9.40.FC4, O/S: AIX4.3
->=20
-> Dear folks
->=20
-> I got a problem, When SPL(Stored Procedure Language) program is
-> performed from 4gl or PowerBuilder program, an error occured, In this
-> case, Informix system is going to DOWN.
-> here is the log:
-> ################################################## ##################
-> 10:15:10 Assert Failed: Exception Caught. Type: MT_EX_OS, Context:
-> mem
-> 10:15:10 IBM Informix Dynamic Server Version 9.40.FC4 =20
-> 10:15:10 Who: Session(40492, larry@152.202.30.10, 3852,
-> 700000070400068)
-> Thread(53579, sqlexec, 7000000703c6488, 3)
-> File: mtex.c Line: 377
-> 10:15:10 Action: Please notify IBM Informix Technical Support.
-> 10:15:10 stack trace for pid 274566 written to=20
-> /IDS0/dumb/af.d533c85c
-> 10:15:10 See Also: /IDS0/dumb/af.d533c85c
-> 10:15:12 Exception Caught. Type: MT_EX_OS, Context: mem
-> 10:15:12 (-9791): ERROR: Routine execution trap --=20
-> procname=3D<Lr01spl>
-> procid=3D430
-> reason: mem
-> 10:15:14 Assert Failed: No Exception Handler
-> 10:15:14 IBM Informix Dynamic Server Version 9.40.FC4 =20
-> 10:15:14 Who: Session(40492, larry@152.202.30.10, 3852,
-> 700000070400068)
-> Thread(53579, sqlexec, 7000000703c6488, 3)
-> File: mtex.c Line: 431
-> 10:15:14 Results: Exception Caught. Type: MT_EX_OS, Context: mem
-> 10:15:14 Action: Please notify IBM Informix Technical Support.
-> 10:15:14 stack trace for pid 274566 written to=20
-> /IDS0/dumb/af.d533c85c
-> 10:15:14 See Also: /IDS0/dumb/af.d533c85c
-> 10:15:16 mtex.c, line 431, thread 53579, proc id 274566, No=20
-> Exception
-> Handler.
-> 10:15:16 Fatal error in ADM VP at mt.c:12298
-> 10:15:16 Unexpected virtual processor termination, pid =3D=20
-> 274566, exit
-> =3D 0x100
->=20
-> 10:15:16 PANIC: Attempting to bring system down
-> 10:29:52 IBM Informix Dynamic Server Started
-> ################################################## ###########
<SNIP>
-> You're help in this case would be greatly appreciated...!!!!
-> Rgds
-> Abdul
->=20


************************************************** *************************=
*******
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** *************************=
*******

sending to informix-list

Hi All,
Deep appreaciated for your kind response,
I'll try to increase STACKSIZE as recommended on this post to me.
Beside that, you're right, this IDS running on AIX 5.3, instead of AIX 4.3

Will you know the result once i have change stacksize.

Kind regards..!

"Simmons, Keith" <keith.simmons@office2office.biz> wrote in message news:<ck3k0n$t01$1@news.xmission.com>...
> Abdul
>
> As requested, call support
>
> Keith
>
> -> -----Original Message-----
> -> From: abdoell@yahoo.com [mailto:abdoell@yahoo.com]
> -> Sent: Thursday, October 07, 2004 7:34 AM
> -> To: informix-list@iiug.org
> -> Subject: Error -9791 when execute routine (procedure) - pls asap.....
> ->=20
> ->=20
> -> Current Environment:
> -> IDS9.40.FC4, O/S: AIX4.3
> ->=20
> -> Dear folks
> ->=20
> -> I got a problem, When SPL(Stored Procedure Language) program is
> -> performed from 4gl or PowerBuilder program, an error occured, In this
> -> case, Informix system is going to DOWN.
> -> here is the log:
> -> ################################################## ##################
> -> 10:15:10 Assert Failed: Exception Caught. Type: MT_EX_OS, Context:
> -> mem
> -> 10:15:10 IBM Informix Dynamic Server Version 9.40.FC4 =20
> -> 10:15:10 Who: Session(40492, larry@152.202.30.10, 3852,
> -> 700000070400068)
> -> Thread(53579, sqlexec, 7000000703c6488, 3)
> -> File: mtex.c Line: 377
> -> 10:15:10 Action: Please notify IBM Informix Technical Support.
> -> 10:15:10 stack trace for pid 274566 written to=20
> -> /IDS0/dumb/af.d533c85c
> -> 10:15:10 See Also: /IDS0/dumb/af.d533c85c
> -> 10:15:12 Exception Caught. Type: MT_EX_OS, Context: mem
> -> 10:15:12 (-9791): ERROR: Routine execution trap --=20
> -> procname=3D<Lr01spl>
> -> procid=3D430
> -> reason: mem
> -> 10:15:14 Assert Failed: No Exception Handler
> -> 10:15:14 IBM Informix Dynamic Server Version 9.40.FC4 =20
> -> 10:15:14 Who: Session(40492, larry@152.202.30.10, 3852,
> -> 700000070400068)
> -> Thread(53579, sqlexec, 7000000703c6488, 3)
> -> File: mtex.c Line: 431
> -> 10:15:14 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> -> 10:15:14 Action: Please notify IBM Informix Technical Support.
> -> 10:15:14 stack trace for pid 274566 written to=20
> -> /IDS0/dumb/af.d533c85c
> -> 10:15:14 See Also: /IDS0/dumb/af.d533c85c
> -> 10:15:16 mtex.c, line 431, thread 53579, proc id 274566, No=20
> -> Exception
> -> Handler.
> -> 10:15:16 Fatal error in ADM VP at mt.c:12298
> -> 10:15:16 Unexpected virtual processor termination, pid =3D=20
> -> 274566, exit
> -> =3D 0x100
> ->=20
> -> 10:15:16 PANIC: Attempting to bring system down
> -> 10:29:52 IBM Informix Dynamic Server Started
> -> ################################################## ###########
> <SNIP>
> -> You're help in this case would be greatly appreciated...!!!!
> -> Rgds
> -> Abdul
> ->=20
>
>
> ************************************************** *************************=
> *******
> This message is sent in strict confidence for the addressee only. It may
> contain legally privileged information. The contents are not to be disclosed
> to anyone other than the addressee. Unauthorised recipients are requested
> to preserve this confidentiality and to advise the sender immediately of any
> error in transmission.
> This footnote also confirms that this email message has been swept for the
> presence of computer viruses, however we cannot guarantee that this message
> is free from such problems.
> ************************************************** *************************=
> *******
>
> sending to informix-list