on 12-12-2013 10:39 AM
Dear All,
i get error message "System Message N" more often means at least once in a month, then i have to restart the system and error gets resolve.
But business have to wait in between restarting the system.
we are using Suse Linux 11 and SAP Sybase ASE 15.7
few points i would like to mention
1) Transaction logs Runs correctly
2) File system has enough space
3) in ECD.log file one error i can see is that "Unable to insert task into scheduler as the scheduler has already shutdown."
Thanks and Regards,
Murtaza
I got the solution of this problem and it is resolved now.
the reason was statement cache is not configured with sufficient memory.
there is document for sybase ASE Runtime Best Practice
for increasing the statement cache you have to first increase max memory.
for this i have changed below parameters in my system and it is working fine now
sp_configure 'js job output width',2048
go
sp_configure 'max memory', 0, '6G'
go
sp_configure 'statement cache size', 0, '200M'
go
sp_configure 'procedure cache size', 0, '1G'
go
sp_configure 'permission cache entries',256
go
sp_configure 'allocate max shared memory',1
go
sp_configure 'number of user connections',500
go
sp_configure 'number of sort buffers', 2000
go
once again thanks juan reyes for helping.
Thanks and Regards,
Murtaza Najmi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
please check log details hear
00:0003:00000:00011:2013/12/17 17:54:46.28 kernel Begin processing to generate RSA keypair.
00:0003:00000:00011:2013/12/17 17:54:46.36 kernel Completed processing to generate RSA keypair.
00:0003:00000:00011:2013/12/17 17:54:46.36 kernel Begin processing to generate RSA keypair.
00:0003:00000:00011:2013/12/17 17:54:46.42 kernel Completed processing to generate RSA keypair.
00:0003:00000:00224:2013/12/17 23:01:39.53 server WARNING: The transaction log for database 'saptools' (dbid 5) can no longer be dumped
due to user 'sapsa' (suid 4) executing DUMP TRAN WITH TRUNCATE_ONLY.
00:0002:00000:00391:2013/12/18 00:25:58.96 server Increase the config parameter 'number of open partitions' to avoid descriptor reuse.
Reuse may result in performance degradation.
00:0003:00000:00363:2013/12/18 03:53:32.87 kernel kbfalloc() retrieved null MEMFRAG from free list at 0x0x1e2f59390. Heap memory corruption may have occurred. Check diagnostic printout.
it is showing that Heap memory corruption may have occured
Please suggest how to proceed on this issue.
Thanks and Regards,
Murtaza
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a documented error,
Read,
SAP Note 1929770 - SAP System freezes and reports : "SAP SYSTEM MESSAGE N"
Regards, Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Juan,
Thanks for the quick reply.
Please find below my system parameters
dbs_syb_schema=SAPSR3
dbs_syb_server=jfcdevecc
dbs_syb_dbname=ECD
dbs_syb_port=4901
as per note suggesting i need to change dbs_syb_server from jfcdevecc to <IP Address>
is this going to work? or is it saying something else?
Please suggest
Regards,
Murtaza
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.