3632181 - Targeted CR List for ASE 16.0 SP04 PL08

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.0 SP04 PL08. 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.
803692	SAP ASE may report error 1972 without tableID and databaseID information when an index is created.
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.
819997	A query from proxy table with long fixed binary column mapped to remote IQ table of binary column data type raises SIGSEGV sometimes. See KBA 2836702.
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.
820797	Signal 11 on OdbcRemoteAccess::prepareResultSet(). See KBA 3586459.
821446	In some circumstances, SAP ASE sp_sysmon may not report correct "Total Parallel Queries" information (count is 0) in the "Parallel Query Management" section even though parallel execution is actually used.
821551	Sybmigrate doesn't report object status if using objtype_create_list_from_sql=QUERY in resource file. See KBA 3007251.
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.
825178	SAP ASE installjava may report an error like 'Server Message: asename - Msg 10795, Level 16, State 1: The file ' < classname > ' contained in the jar does not represent a valid Java class file.'. See KBA 3075958.
825654	A new configuration parameter 'lob cache percent' is introduced into SAP ASE allowing to limit the amount of memory used from the procedure cache by LOB objects.
826254	The TRUNCATE TABLE command cannot be revoked from the dbo user. See KBA 3157522.
826302	Load database from a remote backupserver with blocksize greater than 229376 (4K*56) failed with error,"The database page size of 4096 bytes obtained from ASE is different from the database page size of -1024 bytes read from the dump header. The LOAD session must exit.". See KBA 3192324.
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.
827444	A 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr= < lock-address > , lrmagic=f).", in the module 'lock_release' together with a stack trace which includes the modules 'unmountdb' and 'dbs_shutdown' may be reported in the SAP Adaptive Server error log when UNMOUNT DATABASE is executed and at least one session was found active in the target database or doing cross database transaction involving target database which had session level attributes associated with it. See KBA 2933398.
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.
827994	SAP ASE may report an error message, "ASE is terminating this process" with the connection terminated when running commands "dbcc addextendedproc/dropextendedproc/findstranded" without input parameters. See KBA 3652196.
828148	DDLGEN is terminated after reported a user table has syntax error. Apostrophe (') in a column name is causing the problem. Please see KBA 3348879.
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.
828817	Provide a stored procedure to report the progress of a database shrink and additionally provide estimated completion time. See KBA 3254621.
829295	SAP ASE may report NULL in monProcessLookup,ListenerPort and monProcess.ListenerPort when server listener port number is above 32767. See KBA 3452072.
829378	The message, "Segmentation fault (core dumped)", will be reported when attempting to start the SAP ASE Backup Server without first having set the SYBASE environment variable. See KBA 3471199.
829470	In SAP ASE HADR environment, if 'cis packet size' is set to a value greater than 'max network packet size' the RMA reports error 'The packet size ( < value > ) specified at login time is illegal. Legal values are between < value > and < value > ' and execution of setuphadr fails.
829918	In rare circumstances, an Adaptive Server hang may be observed after a session hits a 1249 error followed by errors 1251 and 6103 together with a stack trace which includes the modules 'lock__semawait', 'log__lock', 'xls__get_lastlogbp', and 'plc__flush' on AIX systems. See KBA 3536134. Start SAP ASE with trace flag 1240 to collect diagnostics information to help narrow down the root cause.
830040	In rare circumstances, a COMMIT TRANSACTION may not finish if an external attention is sent to SAP ASE by the client application on version which includes fixes for CRs 829240 and 828165. See KBA 3422036.
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.
830194	The message, “Current process infected with signal 11 (SIGSEGV)”, in the module ‘ubffreef’ together with a stack trace which includes the modules ‘LePlanRelease’ and ‘s_result_const_memfree’, may be reported in the SAP ASE error log during the execution of a query in parallel mode. See KBA 3550356.
830258	A 8233 error, “ < command-type > operation is in progress on the object < table-name > in database ' < database=name > '. Retry your query later.”, followed by a 941 error, “Illegal database context operation.”, together with a stack trace which includes the modules ‘s_runtime_compile’ and ‘closedb’, may be reported in the SAP ASE error log during the execution of a query. This may cause Adaptive Server to be unresponsive following error 6103, “Unable to do cleanup for the killed process; received Msg 941”. See KBA 3559053.
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.
830351	SAP ASE DDLGen may run into hang without any error message when -CNUMBER option is greater than 1.
830375	In rare circumstances, a 8210 error, "Duplicate of work table descriptor found in the id hash table for temporary object < a negative value > ” together with stack trace, may be reported mistakenly by SAP ASE when execution a special query. See KBA 3577504.
830400	DBCC CHECKSTORAGE can take longer to prepare for checking when the number of objects is in the 10's of thousands.
830455	Stored procedures such as sp_help, sp_options, and sp_helpcache are not executed in read-only mode because the 'COND' operation is not allowed in read-only mode. See KBA 3652157.
830507	The configuration option "open index hash spinlock ratio" does not impact the number of spinlocks used for Index Hash Spinlock Contention. See KBA 3617221.
830511	In a database setup for LTL replication, a 9241 error, "RepAgent( < database-id > ): Failure initializing the Rep Agent Context.", together with a stack trace in the module 'ra_alarm_handler' may be reported in the SAP ASE error log when the RepAgent is killed and restarted immediately. Eventually, the message "Scheduler infected: exiting" is reported in the SAP ASE error log and ASE terminates. See KBA 3587182.
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.
830531	The message, "Current process infected with signal 11 (SIGSEGV)", in the module 'Optimize' together with the message, "SIGSEGV is caught by VEH_Optimize()", may be reported in the SAP ASE error log during the execution of a SELECT query. See KBA 3618167.
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.
830572	The execution of sp_helpconstraint will fail if the executor does not have the sa_role granted and a table has columns with default values, even when the executor is aliased to dbo. See KBA 3590836.
830605	SAP ASE may consume huge heap memory when a MDA table having huge rows is queried. See SAP Note 3595727
830633	Provide a sql interface to retrieve environment variable values.
830660	On a heavily loaded system, sub-optimal performance and very high contention on ‘rpmctrl_spin’ is observed.
830677	Further adjustment/enhancement for new feature request under CR 828658.
830696	In rare circumstances, SAP ASE may report incorrect times metrics in 'monCachedStatement' table whereby 'MaxElapsedTime' may be less than 'TotalElapsedTime' while a long running query is being executed by another process. See SAP note 3602036
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.
830782	In rare circumstances, a 605 error, “An attempt was made to fetch logical page < ... > ”, together with a stack trace which includes the modules ‘lava_psort_consumer’, ‘lava_startsort’ and ‘lava__nextpage’ may be reported in the SAP ASE error log when one session is creating an index and another concurrent session is inserting data with bulk copy while the 'compression info pool size' is under configured.
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.
830801	In some circumstances, an undetected deadlock may be observed between processes trying to acquire a PLC_LOCK (Private-Log-Cache Lock) together with a stack trace which includes the modules 'buf_get_latch', 'xls_bufunpin', and 'plc__lock', sometimes followed by an 1105 error, "Can't allocate space for object ' < object-name > ' in database ' < database-name > ' because ' < segment-name > ' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment.". See KBA 3618683.
830815	Adds a new message 1881: "Database '%.*s' has been created with success.", this will be printed to console & in ASE error log on successfully creating a database.
830827	A 10354 error, "Permission denied. You must be either the system administrator (SA), the database administrator (dbo), or the owner of this object to perform this operation.", may be reported by SAP ASE when sp_dboption is executed within the master database for another database. See KBA 3658780.
830872	SAP ASE may consume huge heap memory when a MDA table like monProcess or monOpenObjectActivity having huge rows is queried. See SAP Note 3595727.
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.
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.
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.
831025	Apache Commons CLI and POI library in Workload Analyzer Command Line Utility is upgraded to commons-io-1.9.0 and poi-5.4.1.
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.
831034	Apache Commons CLI is upgraded to version 1.9.0.
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.
831108	ASE: Proxy table with a view and select with in clause generates incorrect query. See KBA 3641689.
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.
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.
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.
831238	When attempting to display the Backup Server log in SAP ASE AMC, the message "You are not authorized to perform this action. You need at least one of the following privileges: Manage Server" is popped up if the user does not have "Manage Server" privilege.
831241	In AMC, if the language of the browser used is configured as Japanese, when browses Diagnostics - > SAP ASE Error Log Job and select the 'Time Frame' as 'Last Hours' and 'Last Days', the display result shown as 'データなし' which means 'No data'. See KBA 3657771.
831335	commons-io-1.0 and log4j-2.17.1 in sybrestore are upgraded to commons-io-1.9.0 and log4j-2.25.1.
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.

Environment

AIX 64bit
HP-UX on IA64 64bit
Linux on x86 64 64bit
Solaris on Sparc 64bit
Windows on x64 64bit

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR, CR List, ASE 16.0 SP04 PL08, ASE SP04 PL08, SP04 PL08 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.