Solman: disp+work stopped and greyed out (from yellow to grey). Windows 2012 server memory consumption > 90 %

[Former Member]

Hi Experts,

I am facing issue with my SAP solman dev system (EHP7) with SYBASE.

When I start the system after abrupt shut-down, disp+work for ABAP system goes Yellow to Grey in few

seconds. I searched multiple threads but couldn't find proper resolution.

Please let me know for any pointers.

SAP EHP7

Sybase ASE 15.7

Shut-downdate : MM:DD:YYYY = 06:04:2015

Error while restarting the SERVICE = (attached)

Please find attached the Database log (SID= PR1) .

**Points will be awarded*

Log says:

00:0000:00000:00000:2015/06/06 16:24:44.37 kernel  Allocating a shared memory segment of size 1298006016 bytes.



00:0000:00000:00000:2015/06/06 16:24:44.32 kernel  Adaptive Server Enterprise (Enterprise Edition)
00:0000:00000:00000:2015/06/06 16:24:44.34 kernel  Using config area from primary master device.
00:0000:00000:00000:2015/06/06 16:24:44.34 kernel  Warning: Using default file 'E:\sybase\PR1\PR1.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:0000:00000:00000:2015/06/06 16:24:44.36 kernel  SySAM: Checked out license for 1 ASE_PARTITIONS (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:44.36 kernel  Checked out license ASE_PARTITIONS
00:0000:00000:00000:2015/06/06 16:24:44.36 kernel  SySAM: Checked out license for 1 ASE_COMPRESSION (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:44.36 kernel  Checked out license ASE_COMPRESSION
00:0000:00000:00000:2015/06/06 16:24:44.37 kernel  SySAM: Checked out license for 1 ASE_ASM (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:44.37 kernel  Checked out license ASE_ASM
00:0000:00000:00000:2015/06/06 16:24:44.37 kernel  Allocating a shared memory segment of size 1298006016 bytes.
00:0000:00000:00000:2015/06/06 16:24:45.28 kernel  Allocating a shared memory segment of size 52297728 bytes.
00:0000:00000:00000:2015/06/06 16:24:45.28 kernel  Allocating a shared memory segment of size 258408448 bytes.
00:0000:00000:00000:2015/06/06 16:24:45.28 kernel  Allocating a shared memory segment of size 1012727808 bytes.
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Kernel memory at 0x0000000020000000, 1298006016 bytes
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Kernel memory at 0x0000000020000000, 2816000 bytes
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Server part of first shared memory region at 0x00000000202AF800, 1295190016 bytes.
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Failed to log the current message in the Windows NT event log
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Server region 0 at 0x000000006D6B0000, 52297728 bytes
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Server region 1 at 0x0000000070970000, 258408448 bytes
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Server region 2 at 0x000000007FFF0000, 1012727808 bytes
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Highest valid address is 0x00000000BC5C0000
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Adaptive Server is using the threaded kernel mode.
00:0000:00000:00000:2015/06/06 16:24:45.29 kernel  Using 100000 file descriptors.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Adaptive Server Enterprise/15.7/EBF 23465 PR1 SP131 /P/X64/Windows Server/ase157sp131x/3896/64-bit/OPT/Mon Nov 03 17:27:09 2014
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Confidential property of Sybase, Inc.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Copyright 1987, 2014
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Sybase, Inc.  All rights reserved.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Unpublished rights reserved under U.S. copyright laws.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  This software contains confidential and trade secret information of Sybase,
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Inc.  Use,  duplication or disclosure of the software and documentation by
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  agreement  specifying  the  Government's rights to use the software and any
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Using E:\sybase\PR1\ as the 'SYBASE' environment variable, found during startup.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Using OCS-15_0 as the 'SYBASE_OCS' environment variable, found during startup.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Using ASE-15_0 as the 'SYBASE_ASE' environment variable, found during startup.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  ASE booted on host 'YARMOUTHPR1D' running Windows Server 2012 build 9200 .
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Using 'E:\sybase\PR1\PR1.cfg' for configuration information.
00:0000:00000:00000:2015/06/06 16:24:45.31 kernel  Logging ASE messages in file 'E:\sybase\PR1\ASE-15_0\install\PR1.log'.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  Disk Controller Manager is online.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  Network Controller Manager is online.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  Ct-Lib Controller Manager is online.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  Platform TCP network support seems IPv6-aware, IPv4/IPv6 are both enabled.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  ASE booted with TCP_NODELAY enabled.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  Network and device connection limit is 99987.
00:0000:00000:00000:2015/06/06 16:24:45.32 kernel  ASE - Dynamic Pluggable Component Interface is disabled
00:0000:00000:00000:2015/06/06 16:24:45.36 kernel  *** WARNING ******************
00:0000:00000:00000:2015/06/06 16:24:45.36 kernel  Operating system may favor the system cache when memory is at a premium.
To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:0000:00000:00000:2015/06/06 16:24:45.36 kernel  Adaptive Server Enterprise NT process id is 0x118c.
00:0000:00000:00000:2015/06/06 16:24:45.36 kernel  Adaptive Server Enterprise was started as a windows service.
00:0000:00000:00000:2015/06/06 16:24:46.17 server  Number of blocks left for proc headers: 313184.
00:0000:00000:00000:2015/06/06 16:24:46.17 server  Proc header memory allocated 3914 pages for each per engine cache.
00:0000:00000:00000:2015/06/06 16:24:46.17 server  Proc header memory allocated 3914 pages for engine 0 local cache
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Create Thread Pool 2, "syb_system_pool", type="Run To Completion", with 1 threads
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Create Thread Pool 3, "syb_blocking_pool", type="Run To Completion", with 4 threads
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Create Thread Pool 1, "syb_default_pool", type="Engine (Multiplexed)", with 1 threads
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Aggressive task stealing enabled
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Initializing virtual device 0, 'E:\sybase\PR1\sybsystem\master.dat' with dsync 'off'.
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Virtual device 0 started using asynchronous (with DIRECTIO) i/o.
00:0000:00000:00000:2015/06/06 16:24:46.17 server  Loaded default Unilib conversion handle.
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Worker Thread Manager is not enabled for use in ASE.
00:0000:00000:00000:2015/06/06 16:24:46.17 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:0001:00000:00000:2015/06/06 16:24:46.37 kernel  I/O controller 2 (NetController) is running as task 542332720 on thread 1 (LWP 4160).
00:0007:00000:00000:2015/06/06 16:24:46.37 kernel  I/O controller 3 (DiskController) is running as task 542333056 on thread 7 (LWP 4496).
00:0000:00000:00000:2015/06/06 16:24:47.07 kernel  Loaded encryption provider CSI-2.9M12-winx64-2014/06/05 20:16:32 PDT-sybcsi_openssl-OpenSSL 1.0.1h-fips 5 Jun 2014.
00:0000:00000:00000:2015/06/06 16:24:47.07 kernel  Begin processing to generate RSA keypair.
00:0000:00000:00000:2015/06/06 16:24:47.14 kernel  Completed processing to generate RSA keypair.
00:0000:00000:00000:2015/06/06 16:24:47.14 kernel  Begin processing to generate RSA keypair.
00:0000:00000:00000:2015/06/06 16:24:47.21 kernel  Completed processing to generate RSA keypair.
00:0000:00000:00000:2015/06/06 16:24:47.21 kernel  Encryption provider initialization succeeded on engine 0.
00:0009:00000:00000:2015/06/06 16:24:47.21 kernel  Sybperf helper thread is online
00:0000:00000:00000:2015/06/06 16:24:47.32 kernel  Sybperf performance monitoring subsystem is active
00:0006:00000:00000:2015/06/06 16:24:47.32 kernel  Network and device connection limit is 99987.
00:0006:00000:00000:2015/06/06 16:24:47.32 kernel  ASE - Dynamic Pluggable Component Interface is disabled
00:0006:00000:00000:2015/06/06 16:24:47.32 kernel  Thread 6 (LWP 3556) of Threadpool syb_default_pool online as engine 0
00:0006:00000:00000:2015/06/06 16:24:47.32 server  No active traceflags
00:0006:00000:00001:2015/06/06 16:24:47.32 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/15.7/P-EBF23553 SP132/X64/BUILD1570-046/OPT/Sun Nov 02 11:18:33 2014'
00:0006:00000:00001:2015/06/06 16:24:47.32 kernel  Cannot allocate shared memory as 'max memory' limit of '1280000' pages has been reached. Please increase configuration parameter 'max memory' to allow additional shared memory allocation. Total physical memory allocated so far '1280000' pages.
00:0006:00000:00001:2015/06/06 16:24:47.51 server  Configuration of the cache (default data cache) failed since the defined cache configuration consumes more memory than is available for buffer caches.
00:0006:00000:00001:2015/06/06 16:24:47.53 server  Invalid Configuration: Unable to start Adaptive Server. The server may be started with a default configuration using the -c startserver option.
00:0006:00000:00001:2015/06/06 16:24:47.53 kernel  ueshutdown: exiting
00:0009:00000:00000:2015/06/06 16:24:47.53 kernel  Sybperf helper thread is quitting
00:0000:00000:00000:2015/06/06 16:24:47.54 kernel  Main thread performing final shutdown.
00:0000:00000:00000:2015/06/06 16:24:47.61 kernel  Blocking call queue shutdown.
00:0000:00000:00000:2015/06/06 16:24:48.69 kernel  SySAM: Checked in license for 1 ASE_ASM (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:48.69 kernel  SySAM: Checked in license for 1 ASE_CORE (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:48.69 kernel  SySAM: Checked in license for 1 ASE_PARTITIONS (2020.1231/permanent/100C 0F04 3F88 1821).
00:0000:00000:00000:2015/06/06 16:24:48.69 kernel  SySAM: Checked in license for 1 ASE_COMPRESSION (2020.1231/permanent/100C 0F04 3F88 1821).

Please assist and let me know if more details are required.

Thanks,

Aadil

PR1_Deleted Old data.txt.zip

[divyanshu_srivastava3 · Accepted solution]

have you check below thread which talks about similar issue ?

Regards,

[Former Member · Accepted solution]

Thanks Divyanshu!

Increasing MAX MEMORY and killing/stopping some running (uncessary ) processes fixed my issue.

Cheers!

A

[Former Member]

Hi Adil

Kindly, Try to shutdown database from cmd and start from services.msc

and it seems kernel is not properly upgraded.

Regards

Ahmed

[Former Member]

Thanks you Ahmed. I am new to Sybase and you have provided me knowledge to STOP from cmd and START from services.

Regards,

A.