I get error "SAP System Message:N" more often

[former_member201768]

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

[former_member201768 · Accepted solution]

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.

[former_member201768]

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

[JPReyes]

This is a documented error,

Read,

SAP Note 1929770 - SAP System freezes and reports : "SAP SYSTEM MESSAGE N"

Regards, Juan

[former_member201768]

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

[JPReyes]

Well, SAP Notes are fully supported by SAP, so if its says it will fix it... it most likely will.

Regards, Juan

[former_member201768]

i am still getting problem after following this note.