Welcome,

I'm using:
Adaptive Server Enterprise/12.5.0.3/EBF 10696 IR/P/Linux Intel/Linux
2.4.7-10smp i686/rel12503/1915/32-bit/OPT/

and I've got the following error:

0:00000:00070:2004/08/31 08:53:57.85 kernel
************************************
00:00000:00070:2004/08/31 08:53:57.86 server SQL Text: Exec
outXMLActivityEnhReport 262787, null, 274274
00:00000:00070:2004/08/31 08:53:57.86 kernel curdb = 5 pstat = 0x10000
lasterror = 0
00:00000:00070:2004/08/31 08:53:57.86 kernel preverror = 0 transtate = 1
00:00000:00070:2004/08/31 08:53:57.86 kernel curcmd = 224 program =
MFSearchCGI.pl
00:00000:00070:2004/08/31 08:53:57.87 kernel pc 0x8668b05
ucbacktrace+0x89(0x0,0x1,0x8d7c1cc,0xb,0x46dc2428)
00:00000:00070:2004/08/31 08:53:57.87 kernel pc 0x8110385
terminate_process+0xa35(0x0,0xffffffff,0xb,0x4006f b44,0x0)
00:00000:00070:2004/08/31 08:53:57.87 kernel pc 0x8681500
kisignal+0x48(0xb,0x427c60b8,0x427c6138,0x43fcfc74 ,0x8d7c1cc)
00:00000:00070:2004/08/31 08:53:57.87 kernel pc 0x4006c516
init_dummy+0x377632b2(0xb,0x427c60b8,0x427c6138,0x b,0x0)
00:00000:00070:2004/08/31 08:53:57.87 kernel pc 0x42028c40
init_dummy+0x3971f9dc(0x469fb4d8,0x469fb5cc,0x8d7c 1cc,0x46a14d1c,0x469fb4d8)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x8456e06
pull_join+0x2ea(0x46a14d1c,0x8d7c1cc,0x469faa50,0x 469fb4d8,0x81e9e19)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x846dad5
decision+0x211(0x469fb4c8,0x8d7c1cc,0x469fb4d8,0x4 27c6668,0x46a14cfc)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x846ee2f
decision_all+0xab(0x469fb4c8,0x8d7c1cc,0x469fb4c8, 0x469fb4c8,0x427c6610)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83efa32
optimize_cmd+0x7a(0x469fb4c8,0x427c6664,0x427c6668 ,0x0,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83efb3a
s_optimizecmds+0xee(0x469fb4c8,0x427c6664,0x427c66 68,0x0,0x1)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83d99f2
s_compile_stmt+0x276(0x469fb478,0x46db6584,0x1,0x9 6,0x8d7c1cc)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83d9132
s_compile+0x6d6(0x106,0x8d7c1cc,0x43fd4e04,0x427b8 bc8,0x4629b148)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83f7231
s_recompile+0x179(0x106,0x8d7c1cc,0x0,0x0,0x427c00 05)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83f53e1
sequencer+0x935(0x46c1d000,0x8d7c1cc,0x421c2640,0x 421c2640,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83e6a7e
execproc+0x6de(0x46438920,0x464389ac,0x0,0x0,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83e0d46
s_execute+0x2922(0x8d7c1cc,0x0,0x0,0x0,0x1)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83f5a5d
sequencer+0xfb1(0x4603a000,0x8d7c1cc,0x421c2640,0x 421c2640,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83e6a7e
execproc+0x6de(0x464b4d20,0x464b4dac,0x0,0x0,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83e0d46
s_execute+0x2922(0x8d7c1cc,0x0,0x427c7b14,0x0,0x41 4c4d58)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x83f5a5d
sequencer+0xfb1(0x45c25000,0x8d7c1cc,0x0,0x427c7b1 4,0x811ff8e)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x8133a6e
tdsrecv_language+0x2de(0x0,0x0,0x0,0x0,0x0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x814266d
conn_hdlr+0x256d(0x3c,0x427c7bc4,0x895eed31,0x0,0x 0)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x818e98b
ex_cleanup(0x0,0x0,0x0,0x42597900,0x23)
00:00000:00070:2004/08/31 08:53:57.88 kernel pc 0x895eed31
init_dummy+0x80ce5acd(0x0,0x42597900,0x23,0x1,0x53 74616b)
00:00000:00070:2004/08/31 08:53:57.88 kernel end of stack trace, spid 70,
kpid 1414725666, suid 1

00:00000:00070:2004/08/31 08:54:01.32 server The Java VM associated with
process 70 is abnormally terminated.
00:00000:00013:2004/08/31 08:54:33.79 server Java VM Host: Memory
allocation request failed because of insufficient memory in Jvm Process 13.
....several times

00:00000:00082:2004/08/31 08:54:33.86 server Failed to create Jvm Process
82 Fragment Pool. Please consult the Adaptive Server errorlog for further
information as to the cause.
00:00000:00015:2004/08/31 08:54:34.02 server Failed to create heap of type
'2' and maximum size 24561664.
....several times

00:00000:00002:2004/08/31 08:54:34.39 server Error: 1601, Severity: 17,
State: 3
00:00000:00002:2004/08/31 08:54:34.39 server There are not enough 'user
connections' available to start a new process. Retry when there are fewer
active users, or ask your System Administrator to reconfigure SQL Server
with more user connections.
....several times


these are ase parameters:

size of global fixed heap 150
size of process object heap 10000
size of shared class heap 10000
number of java sockets 10
number of open indexes 3000
number of open objects 3000
max memory 130768
number of user connections 150

can you tell me what might be a problem here?

TIA

Best Regards,
ViBart

"ViBart" <bartekz (AT) uhc (DOT) com.pl> wrote

Add more memory....