I updated my system and now server is crahing

[oneeyeman1]

Hi, ALL,

I just updated my system (Linux) including kernel and now running the server produces following:

[code]

IgorReinCloud /opt/sap/ASE-16_0/install # startserver -f RUN_REINCLOUD
IgorReinCloud /opt/sap/ASE-16_0/install # 00:0000:00000:00000:2021/05/16 23:19:23.98 kernel SySAM: Using licenses from: /opt/sap/SYSAM-2_0/licenses/SYBASE_ASE_XE.lic
00:0000:00000:00000:2021/05/16 23:19:24.08 kernel SySAM: Checked out license for 2 ASE_CORE (2020.1231/permanent/02EB A703 F9CB 1D54).
00:0000:00000:00000:2021/05/16 23:19:24.08 kernel This product is licensed to: ASE Express Edition Free Deployment License
00:0000:00000:00000:2021/05/16 23:19:24.08 kernel Checked out license ASE_CORE
00:0000:00000:00000:2021/05/16 23:19:24.13 kernel Adaptive Server Enterprise Express Edition. (Limits: 4 Engines, 50G Disk space).
00:0000:00000:00000:2021/05/16 23:19:24.33 kernel Using config area from primary master device.
00:0000:00000:00000:2021/05/16 23:19:24.51 kernel Could not allocate memory using Huge Pages. Allocated using regular pages. For better performance, reboot the server after configuring enough Huge Pages.
00:0000:00000:00000:2021/05/16 23:19:24.51 kernel Internal run-time model set for Linux - Native
00:0000:00000:00000:2021/05/16 23:19:24.51 kernel Adaptive Server is using the threaded kernel mode.
00:0000:00000:00000:2021/05/16 23:19:24.51 kernel Using 40000 file descriptors.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Adaptive Server Enterprise/16.0 SP03 PL02/EBF 27415 SMP/P/x86_64/SLES 11.1/ase160sp03pl02x/3096/64-bit/FBO/Fri Oct 6 04:51:57 2017
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Confidential property of SAP AG or an SAP affiliate company.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Copyright 2017
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel SAP AG or an SAP affiliate company. All rights reserved.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Unpublished rights reserved under U.S. copyright laws.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel This software contains confidential and trade secret information of SAP AG or
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel an SAP affiliate company. Use, duplication or disclosure of the software and
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel documentation by the U.S. Government is subject to restrictions set forth
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel in a license agreement between the Government and SAP AG or an SAP affiliate
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel company, or other written agreement specifying the Government's rights to
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel use the software and any applicable FAR provisions, for example, FAR 52.227-19.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel SAP AG or an SAP affiliate company
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Using /opt/sap as the 'SYBASE' environment variable, found during startup.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Using OCS-16_0 as the 'SYBASE_OCS' environment variable, found during startup.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Using ASE-16_0 as the 'SYBASE_ASE' environment variable, found during startup.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel ASE booted on host 'IgorReinCloud' running Linux release 5.10.27-gentoo version #1 SMP Sat May 15 23:16:44 CDT 2021.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Using '/opt/sap/ASE-16_0/REINCLOUD.cfg' for configuration information.
00:0000:00000:00000:2021/05/16 23:19:24.52 kernel Logging ASE messages in file '/opt/sap/ASE-16_0/install/REINCLOUD.log'.
00:0000:00000:00000:2021/05/16 23:19:24.53 kernel Disk Controller Manager is online.
00:0000:00000:00000:2021/05/16 23:19:24.53 kernel Network Controller Manager is online.
00:0000:00000:00000:2021/05/16 23:19:24.53 kernel Ct-Lib Controller Manager is online.
00:0000:00000:00000:2021/05/16 23:19:24.56 kernel Platform TCP network support seems IPv6-aware, IPv4/IPv6 are both enabled.
00:0000:00000:00000:2021/05/16 23:19:24.56 kernel ASE booted with TCP_NODELAY enabled.
00:0000:00000:00000:2021/05/16 23:19:24.58 kernel ASE - Dynamic Pluggable Component Interface is disabled
00:0000:00000:00000:2021/05/16 23:19:24.58 kernel Network and device connection limit is 39985.
00:0000:00000:00000:2021/05/16 23:19:24.58 kernel Adaptive Server is running as process id 14288.
00:0000:00000:00000:2021/05/16 23:19:26.04 server Number of blocks left for proc headers: 725984.
00:0000:00000:00000:2021/05/16 23:19:26.04 server Proc header memory allocated 181475 pages for each per engine cache.
00:0000:00000:00000:2021/05/16 23:19:27.08 kernel Create Thread Pool 2, "syb_system_pool", type="Run To Completion", with 1 threads
00:0000:00000:00000:2021/05/16 23:19:27.08 kernel Warning: Operating System stack size is greater than 2MB. If it is too large, ASE may run out of memory during thread creation. You can reconfigure it using 'limit' (csh) or 'ulimit' (bash)
00:0000:00000:00000:2021/05/16 23:19:27.10 kernel Create Thread Pool 1, "syb_default_pool", type="Engine (Multiplexed)", with 2 threads
00:0000:00000:00000:2021/05/16 23:19:27.10 kernel Aggressive task stealing enabled
00:0000:00000:00000:2021/05/16 23:19:28.13 kernel Create Thread Pool 3, "syb_blocking_pool", type="Run To Completion", with 4 threads
00:0000:00000:00000:2021/05/16 23:19:28.37 kernel Enabling Linux Native Kernel asynchronous disk I/O strategy.
00:0000:00000:00000:2021/05/16 23:19:28.37 kernel Initializing virtual device 0, '/opt/sap/data/master.dat' with dsync 'off'.
00:0000:00000:00000:2021/05/16 23:19:28.37 kernel Virtual device 0 started using asynchronous (with DIRECTIO) i/o.
00:0000:00000:00000:2021/05/16 23:19:28.37 server Loaded default Unilib conversion handle.
00:0000:00000:00000:2021/05/16 23:19:28.37 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:0009:00000:00000:2021/05/16 23:19:28.37 kernel I/O controller 2 (NetController) is running as task 786438 on thread 9 (LWP 14362).
00:0008:00000:00000:2021/05/16 23:19:28.37 kernel I/O controller 3 (DiskController) is running as task 917511 on thread 8 (LWP 14361).
00:0000:00000:00000:2021/05/16 23:19:28.41 kernel ASE libsybibmmq/16.0 SP03 PL02/EBF 27415 SMP/P/x86_64/SLES 11.1/ase160sp03pl02x/3096/64-bit/OPT/Fri Oct 6 03:09:45 2017
00:0000:00000:00000:2021/05/16 23:19:32.44 kernel Loaded encryption provider CommonCryptoLib 8.5.8 (), CryptoKernel version 8.5.8.
00:0000:00000:00000:2021/05/16 23:19:32.44 kernel INFORMATION: The FIPS Certified Crypto Kernel is not enabled.
00:0000:00000:00000:2021/05/16 23:19:32.44 kernel Begin processing to generate RSA keypair.
00:0000:00000:00000:2021/05/16 23:19:32.62 kernel Completed processing to generate RSA keypair.
00:0002:00000:00000:2021/05/16 23:19:32.65 kernel ASE - Dynamic Pluggable Component Interface is disabled
00:0002:00000:00000:2021/05/16 23:19:32.65 kernel Thread 2 (LWP 14350) of Threadpool syb_default_pool online as engine 0
00:0002:00000:00000:2021/05/16 23:19:32.65 kernel bucket manager consolidator online
00:0002:00000:00000:2021/05/16 23:19:33.02 kernel Current process (0x670034) infected with signal 11 (SIGSEGV)
00:0002:00000:00000:2021/05/16 23:19:33.02 kernel Current Process is running on Engine 0
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel Address 0x0x00007f9de40893a0 (), siginfo (code, address) = (2, 0x0x00007f9de40893a0)
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel **** Saved signal context (0x0x0000000148ea8d40): ****
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel uc_flags: 0x6, uc_link: 0x(nil)
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel uc_sigmask: 0x7bfbf037 0xb 0x2 0xe40893a0
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel uc_stack: ss_sp: 0x(nil), ss_size: 0x0, ss_flags: 0x2
00:0002:00000:00000:2021/05/16 23:19:33.04 kernel General Registers (uc_mcontext.gregs):
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel PC : 0x00007f9de40893a0 ()
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel RAX : 0x00007f9de40893a0 RBX : 0x00007f9de400c3b0
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel RCX : 0x00007f9de40008d0 RDX : 0x00007f9de4000a38
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel RBP : 0x0000000148ea9cd0 RSP : 0x0000000148ea9188
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel R8 : 0x00007f9de400092a R9 : 0x0000000000000002
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel R10 : 0x0000000000000001 R11 : 0x00007f9df17636a0
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel R12 : 0x00007f9de40893a0 R13 : 0x00007f9de40022c0
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel R14 : 0x0000000148ea9710 R15 : 0x0000000148ea9700
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel RDI : 0x00007f9df23ce540 RSI : 0x0000000000000003
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel RIP : 0x00007f9de40893a0 CSGSFS : 0x002b000000000033
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel TRAPNO : 0x000000000000000e ERR : 0x0000000000000015
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel EFL : 0x0000000000010206
00:0002:00000:00000:2021/05/16 23:19:33.05 kernel **** end of signal context ****
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x000000000146f110 pcstkwalk+0x482()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x000000000146eacf ucstkgentrace+0x20f()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x000000000146b2f2 ucbacktrace+0x54()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x00000000017328fc terminate_process+0x121c()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x000000000149b4aa kisignal+0x5f4()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x00007f9de40893a0 ()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x00000000020c82bb Snap::Validate()+0x3b()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x000000000176cc1d SnapValidation+0xfd()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel pc: 0x0000000000871a86 dsinit+0x2f16()
00:0002:00000:00000:2021/05/16 23:19:33.11 kernel end of stack trace, kernel service process: kpid 6750260
00:0001:00000:00000:2021/05/16 23:19:57.59 kernel Adaptive Server had 302613 major and 1808 minor page faults since boo

[/code]

How do I investigate what is happenning and fix the kernel so the server will start again?

Thank you.

[dan_thrall]

Hi Igor,

During this moment in the boot sequence, ASE will perform some work related to initializing the SNAP functionality. It appears the initialization is not compatible with the version of Linux (5.10.27-gentoo version #1 SMP). Keep in mind, this initialization will occur whether "simplified native access plan" is enabled or not.

The workaround/cure for this is to boot ASE with trace flag 11889 which will skip this initialization and allow ASE to boot. When using this trace flag, please be sure to not enable "simplified native access plan" in the configuration as it has been effectively turned off in the bootstrap. This stacktrace is also reported in KBA 3018138.

Thanks

Dan

[oneeyeman1]

dan.thrall ,

OK, so it looks like its a known issue?

Now, it still feels like the hack to turn something off in the configuration of the server.

I also have some questions:

1. What is SNAP functionality? From what you said I think it is not important for the server to function properly and can be switched off. Is my understanding correct?

2. Should I, as the end-user of the server, even care about this?

3. Will there be a patch (or maybe a minor release) that will fix the crash? Or maybe its already out? If it is - where can I get it? And if its a patch - is there an instructions on how to apply it?

Thank you.

[Former Member]

dan.thrall thank you. This worked for me

[oneeyeman1]

dan.thrall

So, how do I do it?

I unfortunately can't access the link you referenced, since it requires a higher level ,login.

Help?

Thank you.

[dan_thrall]

Hi Igor,

You will add a -T11889 to your RUN_server file and restart ASE.

Example from my ASE:

/ase/sp04/ASE-16_0/bin/dataserver \
-d/data/rel16/sp04/m.dat \
-e/ase/sp04/ASE-16_0/install/sp04.log \
-c/ase/sp04/ASE-16_0/sp04.cfg \
-M/ase/sp04/ASE-16_0 \
-N/ase/sp04/ASE-16_0/sysam/sp04.properties \
-i/ase/sp04 \
-ssp04 \
-T11889 \

As you can see, the last line of the RUN_server file added the -T11889

Once set, you'll see the following lines in the log at boot time:

00:0002:00000:00000:2021/05/19 14:18:04.73 kernel *** NOTE ***: SNAP structure validation is being skipped as TF 11889 is ON. 00:0002:00000:00000:2021/05/19 14:18:04.73 server Active traceflags: 11889

Best Regards

Dan

[stevendawe]

Thanks a lot, I was having problems with docker containers running sybase when we upgraded to version 20.n.n docker engine. This fixes it for all of our instances.

[tilman_model-bosch]

Check ASE config parameter 'simplified native access plan' if it is set to 1 , set it to 0 .

Issue appears to be in code relewvant fo simplified native access plans.

I suggest to upgrade to ASE 16.0 SP03 PL09 orPL10 instead of PL02 . PL02 is quite back level . (SP03 PL10 is not yet released but expoected by end of May)

With kind regards
Tilman Model-Bosch
SAP SE

[oneeyeman1]

tilman.model-bosch ,

What is the difference? What is controlled by this option?

I think I didn't set some option(s) during kernel configuration or set incorrectly. I was hoping to find which one.

This looks like a workaround.

Thank you.

[former_member188958]

Hi Igor,

Yes, changing the "simplified native access plan" configuration is a workaround. The option
is documented here https://help.sap.com/viewer/a7b3e46335184f5caf70a08c91c540f3/16.0.3.7/en-US/39657c5e52f54a0b95eca500...

I don't think you did anything incorrectly - there is a defect CR open in engineering for this problem,
see KBA 3018138 (you can mark it as a favorite to be automatically notified when the CR is resolved).

Cheers,
-bret

[oneeyeman1]

bret.halford ,

How do I check that option?

From the link you referenced I see only the info and links to switching this option on/off from the running server...

Thank you.

[oneeyeman1]

Hi, guys,

[code]

IgorReinCloud /opt/sap # grep -ri "simplified" *
ASE-16_0/REINCLOUD.000000021: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000035: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000022: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000034: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000010: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000020: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000031: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000008: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000024: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000028: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000048: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000047: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.bak: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000036: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000043: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.cfg: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000027: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000044: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000033: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000017: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000019: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000009: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000039: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000041: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000011: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000045: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000016: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000013: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000014: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000049: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000005: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000029: simplified native access plan = DEFAULT
grep: ASE-16_0/bin/dataserver: binary file matches
grep: ASE-16_0/bin/preupgrade: binary file matches
grep: ASE-16_0/bin/diagserver: binary file matches
grep: ASE-16_0/bin/upgrade: binary file matches
ASE-16_0/REINCLOUD.000000051: simplified native access plan = DEFAULT
ASE-16_0/scripts/installmaster:/* Add new param 'simplified native access plan' */
ASE-16_0/scripts/installmaster:exec sp_addconf 649, 'simplified native access plan', 9, 31
ASE-16_0/scripts/instmsgs.ebf:exec sp_us_mesg 10285, 10, "To be prepared at runtime using simplified native access plan."
ASE-16_0/scripts/instmsgs.ebf:exec sp_us_mesg 10286, 10, "Prepared at runtime using simplified native access plan."
ASE-16_0/REINCLOUD.000000023: simplified native access plan = DEFAULT
ASE-16_0/locales/us_english/server.loc:10285 = 16.0, "To be prepared at runtime using simplified native access plan."
ASE-16_0/locales/us_english/server.loc:10286 = 16.0, "Prepared at runtime using simplified native access plan."
ASE-16_0/REINCLOUD.000000018: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000046: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000003: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000030: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000004: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000015: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000037: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000001: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000006: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000032: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000025: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000050: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000026: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000002: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000040: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000007: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000038: simplified native access plan = DEFAULT
grep: ASE-16_0/symlib/pca/libPCAjvm.so: binary file matches
ASE-16_0/REINCLOUD.000000052: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000042: simplified native access plan = DEFAULT
ASE-16_0/REINCLOUD.000000012: simplified native access plan = DEFAULT
charsets/eucgb/charset.loc: description = "Extended Unix Code for GB2312-80 (Simplified Chinese)."
charsets/eucgb/binary.srt:; Based on the EUC GB2312-80 simplified Chinese character set, this sort
charsets/eucgb/binary.srt:description = "Binary sort order for simplified Chinese using the EUC GB2312-80 character set (eucgb)."
charsets/cp936/charset.loc: description = "CP936 (Simplified Chinese)."
charsets/cp936/binary.srt:; Based on the cp936 simplified Chinese character set, this sort
charsets/cp936/binary.srt:description = "Binary sort order for simplified Chinese using cp936."
charsets/gb18030/binary.srt:; Based on the gb18030 simplified Chinese character set, this sort
charsets/gb18030/binary.srt:description = "Binary sort order for simplified Chinese using gb18030."
grep: data/master.dat: binary file matches
grep: data/sybmgmtdb.dat: binary file matches
grep: DataAccess/ODBC/lib/libsapcrypto.so: binary file matches
grep: DataAccess64/ODBC/lib/libsapcrypto.so: binary file matches
grep: DataAccess64/ODBC/dm/lib64/libdbicudt16.so.1: binary file matches
grep: DataAccess64/ODBC/dm/lib64/res/dblgen16.res: binary file matches
grep: DBISQL-16_0/bin/libdbicu16_r.so.1: binary file matches
grep: DBISQL-16_0/bin/libdbicudt16.so.1: binary file matches
grep: DBISQL-16_0/bin/dblgen16.res: binary file matches
grep: jre64/lib/amd64/libsplashscreen.so: binary file matches
grep: jre64/lib/amd64/server/libjvm.so: binary file matches
grep: OCS-16_0/lib3p64/libsapcrypto.so: binary file matches
grep: OCS-16_0/devlib3p64/libsapcrypto.so: binary file matches
grep: OCS-16_0/lib3p/libsapcrypto.so: binary file matches
grep: OCS-16_0/devlib3p/libsapcrypto.so: binary file matches
grep: shared/SAPJRE-7_1_049_64BIT/lib/amd64/libsplashscreen.so: binary file matches
grep: shared/SAPJRE-7_1_049_64BIT/lib/amd64/server/libjvm.so: binary file matches
grep: shared/ase/SAPJRE-8_1_029_64BIT/lib/amd64/libsplashscreen.so: binary file matches
grep: shared/ase/SAPJRE-8_1_029_64BIT/lib/amd64/server/libjvm.so: binary file matches
IgorReinCloud /opt/sap #

[/code]

Any other ideas?

Thank you.

[former_member605656]

Is ASE 16.0 SP03 PL09 is a stable version? I am planning to upgrade from ASE 15.7

[c_baker]

Did you also try traceflag 11889?

Chris

[dan_thrall]

Hi Igor,

This functionality is part of the simplified native access plan which is not enabled by default. Please see the documentation for more information.

If you aren't using SNAP, disabling this initialization is a non-issue and ASE will operate as normal.

At this time a fix is not available, the trace flag can be used to prevent this issue from happening.

Thanks

Dan

[oneeyeman1]

dan.thrall ,

I posted a reply with the results to the first answer.

I believe that SNAP has a DEFAULT value which is OFF (0).

Anything else I can look for?

Thank you.