3702129 - Targeted CR List for ASE 16.1 SP00 PL02

Symptom

The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in Adaptive Server Enterprise (ASE) 16.1 SP00 PL02. Please be sure to read the Disclaimer below.

If the EBF/SP has been released, check the CR list and coverletter at the support.sap.com.

Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.

CR Number	Description
653826	The message, "Backup Server: 4.139.2.82: [25] The 'open' call failed for database/archive device while working on stripe device < device-pathname > with error number 2 (No such file or directory). Refer to your operating system documentation ...", if the physical device name being used contains a "carriage return" or "newline" character, could be reported by SAP ASE when DUMP DATABASE or TRANSACTION is executed.
792140	"create index < index_name > on < table > WITH statistics HASHING" may give warning message 1965 for tables created with deferred allocation even if the table is not proxy table.
800691	A 1790 error, "Table ' < table-name > ' cannot be compressed; none of the columns are compressible.", may be reported when using ALTER TABLE to compress a column that has a user defined datatype. See KBA 2348588.
800812	A 17209 error, "Illegal format: ' < date-value > ' ...", may be returned by SAP ASE when sp_logging_rate is executed with a day component value. See KBA 2351065.
815054	No 1708 (EXCEEDED ROWSIZE) warning when creating a function based index (which adds a hidden column to the table) if the hidden column would cause the maxlen of the row to exceed the maximum for the page size.
820135	In rare circumstances a 14622 error, "The dbinfo anchor in the database 'database ' < database-name > ' ( < database-id > )' is already locked by the task. Nested access to dbinfo anchor is not allowed. Lock was acquired in file 'checkpoint.c' at line 2955. This is an internal error. Please contact SAP Technical Support.", may be reported in the SAP ASE error log. See KBA 3656582.
822306	In rare circumstances, SAP Adaptive Server may hang during INSERT operations while the session option 'ins_by_bulk' is enabled.
824919	In rare circumstances, the SAP ASE error log gets filled with messages like, "kernel host_ntwk_recv_iocp: vsn < virtual-socket-number > kpid < kernel-process-id > unexpected attention pattention 0 ststatus 0x10001". Boot strap Adaptive Server with trace flag 1677 to suppress these messages. See KBA 3063647.
826284	Provide a new dbcc command to report objects residing on a device. dbcc listobject (dbid [, device_id\|-1 [, -1,-1 \| start_page,end_page [, printopt {0\|1}]]]). See KBA 3159484.
827002	A 15960 error, "The compression information of LOB started with page < > does not match that found in system catalog.", may be reported in the SAP ASE HADR secondary site when dbcc checktable is run. See SAP KBA 3335392.
827242	A 247 error, "Arithmetic overflow during implicit conversion of NUMERIC value ' < large-numeric-value > ' to a NUMERIC field.", may be reported when executing sp_chgattribute to change the identity burning factor 'identity_burn_max' for an identity column with a large NUMERIC value. See KBA 3257658.
827352	"create index < index_name > on < table > with online" may give warning message 1968 for tables created with deferred allocation. KBA 3256508.
827384	A 804 error, "Unable to find buffer < > from cache 'default data cache' holding logical page < > in sdes < > kept buffer pool for object < > .", may be reported in the SAP ASE error log when REORG REBUILD is run. See KBA 3271126.
827979	A 702 error, "Memory request for 16514 bytes exceeds the size of single page of 16384 bytes.", may be reported in the SAP ASE error log when a query is performing a 6 way self-join against a view with a union. See KBA 3330490.
828164	Allow readonly session to create temp tables. See KBA 3350121.
828701	In rare circumstances, a 2540 error, "Table Corrupt: Page is allocated but not linked. Run DBCC TABLEALLOC to correct the problem. (allocation page#= < page-number > , extent id= < extent-number > , logical page#= < page-number > , object id in extent=8, object name=syslogs, index id in extent=0)\|, may be reported mistakenly by SAP ASE when running DBCC CHECKALLOC.
829295	SAP ASE may report NULL in monProcessLookup,ListenerPort and monProcess.ListenerPort when server listener port number is above 32767. See KBA 3452072.
829653	SAP ASE adds a new session level option, memdump, so that user can tentatively disable memory dump on a session.
829920	The message "LeOperator::LeOpProcessIOStats(): process xxx has negative physical reads counters. les_cur_fetch_physreads = -xxx, les_cur_fetch_physapfreads = 0" is reported in the SAP ASE error log when monitor counters have been found to be inaccurate. See KBA 3538250.
830077	A 692 error, "Uninitialized logical page ' < page_id > ' was read while accessing database ' < db_name > ' ( < db_id > ), object ' < object_name > ' ( < object_id > ), index ' < index_name > ' ( < index_id > ), partition ' < partition_name > ' ( < partition_id > ). Please contact SAP Technical Support.", may be reported when a trigger exercised, which is referenceing large object data type inside the trigger.
830153	The message, “Current process infected with signal 11 (SIGSEGV)”, in the module ‘pipe_read’ together with a stack trace which includes the modules ‘LePlanOpen’ and ‘LePipeRepart::LePipeReadVtuple’, may be reported in the SAP ASE error log during the execution of a query in parallel mode post-CR 826833 fix resulting in an implicit shutdown of Adaptive Server.
830270	A 1538 error, "max utility parallel degree 255 is less than the required 'max utility parallel degree' 8589934848 to create clustered index on partition table. Change the parallel degree to required parallel degree and retry.", may be reported in the SAP ASE error log while creating index.
830297	When the session level setting SET SHOWPLAN is enabled, the output generated for queries performing SELECT DISTINCT on two or more columns may report the usage of 'HASH DISTINCT Operator' even if the session level setting SET DISTINCT_HASHING was disabled. See KBA 2976938.
830441	Extend the configuration history to include changes done by sp_passwordpolicy.
830483	The message "stack_abort: kpid < kpid > spawn a stack tracer task with kpid < kpid > " together with a stack trace which includes the modules 'LeLOBCache::LeLOBCacheRelease()' and 'exc_raise()' may be reported in the SAP ASE error log when large object data type refered.
830493	SAP ASE may report many temporary tables/indexes instead of user tables/indexes in the cache wizard of sp_sysmon output.
830521	The message, "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the modules 'LeRun', 'LeNLJOp' and 'LePlanOpen' may be reported in the SAP ASE error log when a SELECT query with a LIKE clause is executed. See KBA 3587168.
830565	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'ptn__get_pdes' together with a stack trace which includes the module 'open__common_sdes_setup' may be reported in the SAP ASE error log when inserting into a table that is currently undergoing an ALTER TABLE ... DROP PARTITION execution. See KBA 3595739.
830620	In rare circumstances, a session that is executing 'dbcc upgrade_object < db-name > ' may be put to sleep while an REORG utility on the same table is in progress. The call stack of the hanging session may report the modules 'des_do_get' and 'des__in_use_error'.
830660	On a heavily loaded system, sub-optimal performance and very high contention on ‘rpmctrl_spin’ is observed.
830661	Duplicate key rows ignored from an INSERT INTO a table with an insert trigger having a unique index created with ignore_dup_key can be seen in the trigger's inserted table. See KBA 3597886.
830667	When SAP ASE is started with trace flag 11036, the build in func show_cached_plan_in_xml() with specifying ssqld fails to report the query plan while the query is cached in statement cache.
830680	The message 940, "Dbtable in wrong state for operation: DBTABLE pointer = < addrress > , dbid = 2, state = 0x2, status= 0xc, keep = 1, system task keep = 0, name = 'tempdb'.", is reported in the SAP ASE error log when a stored procedure conditionally uses and creates a global temporary table while the configuration "deferred name resolution" is disabled. See KBA 3600824.
830724	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'ubffreef' together with a stack trace which includes the modules 'clean_process' and 'actx_free' may be reported by SAP ASE when a task is being terminated causing Adaptive Server to shutdown implicitly. See KBA 3604956.
830745	A 529 error, "Explicit conversion from datatype 'FLOAT' to 'FLOAT' is not allowed", may be reported by SAP ASE during a FETCH command from a cursor that explicitly converts a varchar value to a float.
830800	Under rare circumstances, the message "timeslice < negative-value > , current process infected at "ktMuxThreadMain" together with the message "Stack overflow detected" may be reported in SAP ASE error log on linux platform, resulting in an implicit shutdown when the host CPU is at or near 100% utilization. See KBA 3614197.
830900	In rare circumstances, a stack trace which includes the modules 'icpinfo_free' may be reported in the SAP ASE error log when one session is creating an index while the 'compression info pool size' is under configured.
830903	The message "ASE booted on host < host-name > running Windows < version > " has an inaccurate version description printed in SAP ASE error log on windows platform. This inaccuracy is cosmetic only and has no impact to the Server.
830907	A 2601 error, "Attempt to insert duplicate key row in object ' < table-name > ' with unique index ' < index-name > '", may be reported during HADR replication which will bring down the DSI thread connection to SAP ASE. The connection cannot be restarted, and re-materialization is necessary. See KBA 3630732.
830935	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'kmuxtskGetPrevThreadpool' together with a stack trace which includes the modules 'etc_notify_binding' and 'etc__evalandset_addsv' may be reported in the SAP ASE error log when binding a RepAgent process to a user-defined execution class with sp_bindexeclass. This will cause an implicit shutdown of Adaptive Server. See KBA 3628006.
830944	Replication support has been added to SAP ASE Rep Agent for DDL commands 'CREATE TYPE' and 'DROP TYPE'.
830949	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'bi_xml_xquery_open' together with a stack trace may be reported in the SAP ASE error log when Insufficient memory for PSS_MEMALLOCHEAP_SESSION.
830952	Under certain circumstances, a character will get omitted in audit record.
830956	SAP ASE trace flag 16996 which enables the Vectored Exception Handling (VEH) tracing in the Query Processing area is now acknowledged when Adaptive Server is started.
830980	A process (spid) executing a corrupted query plan may end up allocating a very large amount of procedure cache memory. The allocator value MEMC_DSEG_1 for the AllocatorID column in the monProcedureCacheMemoryUsage MDA table will be significantly elevated. See KBA 3634689.
830991	When SAP ASE is started with trace flag 11036 the message, "Current process infected with 11 (SIGSEGV)", in the module 'proc_release' together with a stack trace which includes the modules 's_dealloccss' and 'css_deallocate' may be reported in the SAP ASE error log when DEALLOCATE CURSOR is run while the statement cache is enabled.
830993	sp_dbcc_faultreport does not report a unique state value for the reported fault. See KBA 3632685.
831004	When upgrade ASE server with the GUI tool sqlupgrade, a segmentation fault might happen.
831012	SAP ASE Sybmigrate may report an error like "The specified password is too short. Passwords must be at least 8 character(s) long" when migrating a lower version server than 16.1 SP00 PL01 to 16.1 SP00 PL01 when "login_password_file= < generate > " is specified in resource file.
831016	The message, "Current process infected with signal 11 (SIGSEGV)" in the module 'NormalizeScalar' followed by a stack trace that includes the modules 'PesState::PesInit' and 'OptBlock::OptPhaseTcLists', may be reported in the SAP ASE error log when executing a query that includes 'CASE THEN' and VEH mechanism in QP is disabled with TF 16995.
831026	In rare circumstances, the message, "timeslice < negative-value > , current process infected", in the module 'sysxacts_materialize' together with a stack trace which includes the modules 'null', 'make_fake', may be reported in the SAP ASE error log during the execution of a query involving systransactions. ASE server could crash when the affected spid is holding spinlock on ASTC_SPIN. See KBA 3635452.
831037	Infected with signal 11 (SIGSEGV) at address in make_fake() while ASE is underconfigured for "number of open databases".
831065	After upgrade of the HADR system to SAP ASE 16.0 SP04 PL06, Adaptive Server might report message "server Rep Agent on database ' < db_name > ' switched from mode 'sync' to mode 'async' because timer on commit expired" when there is transaction with large number of save tran being replicated. See KBA 3637208.
831070	When shutting down SAP ASE, invalid text may be shown for "shutdown info" in the SAP ASE error log even though no shutdown info message was provided to the shutdown command.
831079	When SAP ASE is started with trace flag 11036 the message, "Current process infected with 11 (SIGSEGV)", in the module 'kbfalloc' together with a stack trace which includes the modules 'ssql_save_SQL' and 'lwp_create' may be reported in the SAP ASE error log when a query is run while the statement cache is enabled.
831108	ASE: Proxy table with a view and select with in clause generates incorrect query. See KBA 3641689.
831110	In some cases when loading a compressed dump, backup server may report error, "Backup Server: 4.139.2.22: [205] The 'fastlz_decompress' call failed for database/archive device while working on stripe device ' < device-name > ' with error number 0 (Success). Refer to your operating system documentation for further details. Look for '00002: 01: Aug 8 15:24:31 2025: A00: SYBMULTBUF ERROR: ' in the backup server errorlog for additional information from SYBMULTBUF."
831120	A 872 error, "Process %d is trying to get a %s latch on buffer 0x%p (dbid: %d, pageno: %u) while already holding a %s latch on the the buffer." with a stacktrace that includes the module 'bt_getnext_no16FTR', 'dol_bt_getnext_no16FTR', 'sdes_scan_setup', 'hk_flush_acct_stats' may be reported in the SAP ASE error log if the task runs out of locks reporting error 1204 : "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS."
831123	The database option, "no free space acctg" will be missing from the DDL scripts generated by DDLGen in SAP ASE.
831141	A 456 error, "Failed to execute SET ROW COUNT, because this is a read-only connection. Read-only connections can only execute SELECT statements. Use 'set readonly off' to execute SET ROW COUNT.", may be reported by SAP ASE if a read-only connection tries to enable the SET ROWCOUNT option. See KBA 3656556.
831178	SAP ASE WLACLIUtil may report an exception like "Exception in thread 'Thread-3' java.lang.NumberFormatException: For input string: '2191039722'" which includes "java.lang.NumberFormatException.forInputString", "java.lang.Integer.parseInt" and "com.sybase.workload.cli.task.WLACapture.status" in the stack trace after starting a capture.
831185	In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)" or timeslice error in the module 'Optimize' together with a stack trace may be reported in the SAP ASE error log during the compilation phase of a query execution.
831199	Enabling SSL without setting ssl_ca_file left the value empty, allowed the backupserver to boot, but caused dump and load to fail because the dataserver could not establish a secure connection without a valid CA file.
831203	Load of a database dump or a transaction log dump from a tape fails if the dump was performed using compression. See SAP note 3653734.
831210	A 9416 error, "Rep Agent on database ' < database-name > ' switched from mode 'sync' to mode 'async' because timer on commit expired", may be reported by SAP ASE Rep Agent when DUMP TRANSACTION in run on an HADR system.
831233	A 1526 error, "Sort failure. The configure size for data cache ( < cache-name > ) is not sufficient to handle the sort buffers (xx) requested. Please reconfigure the data cache or sort buffers and try the command again.", may be reported when heap memory has been exhausted. Any sort buffer requests for this cache will fail with error 1526, requiring a reboot to clear. See KBA 3656469.
831237	Error 716 (state 32)‌, "Unable to allocate memory of size 0 bytes from the 'compression info' pool.", may be reported in the SAP ASE error log when the 'compression info pool size' is too small.
831279	Stack guardword corrupted after error 1204 with GP turned on.
831281	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'hk__wash_mass' together with a stack trace which includes the module 'hk__pool_wash' followed by an implicit shutdown is reported in the SAP ASE errorlog. See KBA 3662868.
831305	A 9970 error, "DBCC cannot update the finish time in dbcc_operation_log table for this operation(opid = ' < op-id > ') of database ' < database-name > '. This can be patched by executing sp_dbcc_patch_finishtime.", may be reported in the SAP ASE error log when run sp_dbcc_runcheck command.
831312	Error 714 "Unable to locate a procedure cache memory control descriptor for memory ' < memory__address > ' allocated by process < process_id > ." maybe reproted when execsicing procedure with large object data type as parameter.
831320	SAP ASE may report "**********" for Grabs, Spins or Waits in the "Spinlock Activity" section of sp_sysmon report on a very busy server or very long running samples of sp_sysmon.
831347	A 10707 error, "Unhandled Java Exception: java.lang.UnsatisfiedLinkError: no sunmscapi in java.library.path: ...", may be reported in SAP ASE on Windows when a Java UDF tries to encrypt string data with 'RSA' algorithm.
831382	A new column, SpinlockNumber, is added to monCachedStatement MDA table to report the spinlock number in monCachedStatement when "number of cached stmt spinlock" is configured. See KBA 3675285.
831404	Apache Commons CLI and IO in Workload Analyzer Command Line Utility is upgraded to commons-cli-1.10.0, commons-cli-2.20.0.
831430	Apache Commons CLI in Sybdiag is upgraded to version 1.10.0.
831431	Create encryption key command might fail quietly without displaying any message in case of HSM library is absent in the release area.
831435	commons-io-1.0 and log4j-2.17.1 in sybrestore are upgraded to commons-io-1.10.0 and log4j-2.25.2.
831437	In rare circumstances, the message "Current process (0x0) infected with signal 11 (SIGSEGV)" in the module 'ra__ci_call_CloseStream_unblocking' together with a stack trace which includes the modules 'ra_ci_scanner_thread' and 'ra__ci_scanner_close_stream' may be reported in the SAP ASE error log when a second attempt to stop a Rep Agent using the no_wait option is made. See KBA 3683098.
831450	In rare circumstances, a stack trace which is related to 'Assertion (vinfo- > indscv_indpgchecked == FALSE)' may be reported in the SAP ASE error log when one session is doing DML while Garbage Collect is ongoing.
831483	In AMC Planning Calendar, when attempting to create a job, AMC displays the message: "Job created successfully." and there are no errors shown, but the job does not exist when trying to verify the job from the ASE side. See KBA 3687004.

Environment

AIX 64bit
Linux on x86 64 64bit
Windows on x64 64bit

Product

SAP Adaptive Server Enterprise 16.1

Keywords

CR, CR List, ASE 16.1,SP00 PL02, Adaptive Server Enterprise, Fix, Patch, Error, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.