SAP Knowledge Base Article - Preview

3253524 - Targeted CR List for ASE 16.0 SP04 PL04

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 PL04. 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 NumberDescription
768285 A 834 error, "Illegal attempt to clean buffer: BUF= < buffer-address > ...", may be reported in the SAP ASE error log during boot recovery of an encrypted database after DISK REFIT was executed. See KBA 3256646.
774799 A 290024 error, "Invalid column length: < column-length > . Value must be between 0 and < maximum-column-length > at offset < column-offset > for ' < row-format > ' row with minimum row length of < minimum-column-length > .", may be reported by SAP Adaptive Server when a SELECT query is executed and an invalid column length is encountered.
819608 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 'make_fake' and 's_setuptables', may be reported in the SAP ASE error log during the execution of a query involving systransactions. See KBA 2894955.
821662 The Message 701, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.", may be reported when executing the built-in 'hashbytes' or 'hash' by using the ‘md5’ hash algorithm against a table which has millions of rows stored. See KBA 2925203.
822348 When TRUNCATE TABLE is executed in an encrypted database, SAP Adaptive Server may write some data in cleartext form on disk. See KBA 2952769.
823360 In rare circumstances, after loading a cumulative dump an invalid row may be seen in master..sysusages for the target database with segmap and location column values set to zero and a positive vdevno column value respectively. See KBA 3238664.
824691 In a very busy SAP Adaptive Server system, some procedure cache memory corruption may happen when concurrently one task is recompiling a cached statement and other tasks are competing for procedure cache memory while ASE is running short of procedure cache memory. A possible side effect is described in KBA 3051772 whereby ASE will shut down implicitly after a signal 11 (SIGSEGV) error is hit in the module 'senderror'.
825338 In rare circumstances, a 6913 error, "DUMP DATABASE < database-name > FULL is unable to clear the list of changed database pages. Future incremental dumps will be unnecessarily large until the next successful full DUMP DATABASE.", may be reported by SAP ASE when DUMP DATABASE is executed while the database option 'allow incremental dumps' is enabled. A diagnostics message will be printed in the Adaptive Server error log to help diagnose error 6913. See KBA 3238636.
825383 The 'Housekeeper Section' of sp_sysmon may recommend to increase "housekeeper free write percent" even though there is a low ratio of 'Dirty Buffer Cache Washes'. See KBA 3087788.
825614 In rare circumstances, a timeslice error together with a stack trace in the module 'oj_merge_ojblock' may be reported in the SAP Adaptive Server error log when a complex query that includes multiple views is executed. See KBA 3033730.
825780 The message, "timeslice < negative-value > , current process infected", together with a stack trace which includes the modules 'GenCondensedText::isInTree' and 'show_condensed_text' may be reported in the SAP ASE error log when a SELECT query is using SHOW_CONDENSED_TEXT() built-in function. See KBA 3255032.
825986 The error message, "ANS0344E (RC2107) Cannot Send data with a zero byte sizeEstimate", may be reported in the SAP Backupserver error log when DUMP command with database size greater than 4TB is executed using TSM. See KBA 3135839
826147 The message, "Current process infected with 11 (SIGSEGV)", in the module 'ssl_cipherbypss' together with a stack trace may be reported in the SAP ASE error log when a remote procedure call executes SELECT @@ssl_ciphersuite and the connection uses a site handler. The local client making the call will hang and the stacktrace will be reported in the remote SAP ASE error log. See KBA 3145809.
826338 Workload queries captured in a source capture are not shown in the Replay Analysis dashboard in Workload Analyzer of Administration and Management Console (AMC). This happens when the Use a generic password for all logins option is enabled for a replay in AMC. See KBA 3243010.
826383 In rare circumstances, SAP ASE may shut down implicitly after multiple 1204 errors, "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.", or 1105 errors, "Can't allocate space for object 'syslogs' in database 'sybsecurity' because 'logsegment' 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.", have been reported causing the termination of the audit process. See KBA 3229085.
826409 A 247 error message,"Arithmetic overflow during implicit conversion of UNSIGNED INT value ' < integer value > ' to a INT field" may be reported by stored procedure sp_ddlgen when the database is large enough to use pages in unsigned int page range. See KBA 3191721.
826412 New dbcc command, 'dbcc alarms' is added in SAP Adaptive Server Enterprise server to print alarms and their status. Additionally 'dbcc mempool("Alarms","show",1)' command is enhanced to print information about the alarm structures which are in use. See KBA 3189250.
826455 The SAP ASE procedure cache memory management is improved to free already allocated memory after encountering a 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache.", when a dynamic prepared query execution attempts to insert a huge amount of LOB data in a table. See KBA 3193727.
826550 SAP Adaptive Server has been improved to handle errors better during RPC execution.
826558 A 692 error, "Uninitialized logical page ' < page-number > ' was read while accessing database ' < database-name > ' ( < database-id > ), object '' (99), index ' < Unknown > ' (0), partition ' < Unknown > ' (99).", may be reported in the SAP ASE error log when executing CREATE DATABASE FOR LOAD using over 6.25 terabytes of space. See KBA 3204034.
826565 A SELECT query on system table master..syscurconfigs may display negative values indicating an overflow when a data cache is configured with a greater than 2TB size.
826623 In rare circumstances, the ASE Rep Agent may hang when the error message, "(CI-Info) Message: 76066, Severity: 5 Failed to serialize a package for Stream 'ISP'(pbuf = < package-information > , cnt = < counter-information > , cmds = < number-of-commands > , xdr = < package-information > ).", is reported in the SAP ASE error log under an HADR setup. Subsequently any attempt to either stop the Rep Agent or kill the Rep Agent will fail. See KBA 3207018
826658 The message, "ELC_VALIDATION_ERROR: Page not marked free.", may be reported in the SAP ASE error log when CREATE INDEX fails with a 1521 error, "Sort failed because a table in tempdb used for the processing of the query had a bad data page count. Tempdb should not have been damaged.". See KBA 3210652.
826708 A 5123 error, "DISK INIT encountered an error while attempting to open/create the physical file for device ' < raw-device > '. Consult the Adaptive Server error log for more details. For the Cluster Edition, check the error log of each instance.", may be reported on AIX platform by SAP ASE when DISK INIT is run on a raw device and the sector size is of 4096 bytes. See KBA 3213002.
826718 DUMP DATABASE when used with compression levels 1 to 9 may expose a performance degradation on SunOS platform after having upgraded Adaptive Server to 16.0 SP03 PL06 release whereby the support for Zlib 1.2.12 version has been added. See KBA 3147657.
826725 In rare circumstances, the message, "BACKUPSERVER: bs_trap; process received signal 11", together with a stack trace which includes the modules 'as_report_progress' and 'srv_lockmutex' may be reported in the SAP Backup Server error log during LOAD DATABASE execution. See KBA 2896338.
826736 A 247 error, "Arithmetic overflow during explicit conversion of NUMERIC value ' < value > ' to a INT field.", may be reported by sp_sysmon_dcache_sum when running sp_sysmon for a large sample time on a very busy ASE. See KBA 2544721.
826739 A 4956 error, "Cannot alter table if REORG command or level 0 scans are active.", may be reported when simultaneous ALTER TABLE ... ADD PARTITION are run against a table while the configuration option 'enable utility lvl 0 scan wait' is enabled. See KBA 3216925.
826780 In rare circumstances, an undetected deadlock may occur between two tasks when SAP ASE is started with trace flag 859 which enables role lookup optimization and high access concurrency on sysattributes takes place. See KBA 3217673.
826819 The system stored procedure sp_altermessage is enhanced with the addition of new option ‘with_stack’. This new option allows to report in the SAP Adaptive Server error log the call stack from where in the code a given error is raised along with the error message itself.
826834 In rare circumstances, the message "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the module 'ra__ci_stpmgr_execute' may be reported in the SAP Adaptive Server error log when the Rep Agent is stopped in an HADR setup. See KBA 3238648.
826869 The message, "Current process infected with signal 11 (SIGSEGV)", together with a stack trace which includes the modules ‘dumpnames’ and ‘uni25m2__sqlhilo’ may be reported in the SAP Adaptive Server error log during DUMP DATABASE execution and TSM is in use. See KBA 3238651.
826899 In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'subglobals' together with a stack trace may be reported in the SAP ASE error log during the execution of a query and a 261 error, "' < name > ' is not a recognized global variable.", was first reported. See KBA 3238692.
826901 In rare circumstances, the message, "Current process infected with signal 11 (SIGSEGV)", in the module 'LOBparamCacheRelease' together with a stack trace which includes the modules 'terminate_process' and 'lava_last_chance_cleanup' may be reported in the SAP ASE error log when a session is killed while executing a select query with LOB datum.
826916 A 15946 error, "Invalid column length < column-length > found for column, column ID < column-id > , row ID < row-id > , page number < page-number > , partition ID < partition-id > . The length is greater than the expected maximum column length < maximum-column-length > .", may be reported by SAP Adaptive Server when a SELECT query is executed and an invalid column length is encountered. See KBA 3238630.
826969 A new configuration option 'HADR primary strict bootstrap' is added to SAP Adaptive Server, which when enabled would disallow primary ASE to boot if the standby ASE is not reachable.
826995 A 17471 error, "The device name supplied is not a normal database device.", is reported instead of a 17470 error, "No such device exists -- run sp_helpdevice to list the ASE devices.", when either executing sp_dropdevice, sp_logdevice, or sp_deviceattr using a device that does not exist. See KBA 3234009.
827045 The message, "Current process infected with signal 10 (SIGBUS)", in the module 'LeSendRow::_sendColsToClien' or 'sendtext' together with a stack trace which includes the modules 'LeSendRow::sendRowToClient' and 'LeEmitSndOp::_LeEoRouteResults', may be reported in the SAP ASE error log on Solaris systems when a SELECT query that includes in-row LOB columns is run while Adaptive Server executes the query using a HASH operator. See KBA 3238270.
827068 When SAP ASE Workload Analyzer Command Line Utility (WLACLIUtil) is used to capture a workload from a windows ASE server or replay a workload against a windows ASE server and the "Do you want to automatically download PCAP files to local after capture is stopped" answer is set as "Yes", ASE will crash and WLACLIUtil will report an exception in com.sybase.workload.ASECatCaptureMgr$ASECatPCAPDownloadTask.run.
827078 A timeslice error in the module 'prepprev' together with a stack trace which includes the modules 'onl__test_upgraded_replicated_db' and 'apl__startscan' may be reported in the SAP ASE error log during database boot recovery. See KBA 3242248.
827101 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=0x(nil), lrmagic=", may be reported in the SAP ASE error log when ALTER TABLE ... DROP PARTITION ... WITH ONLINE is run while replication is enabled in the database. See KBA 3248910.
827115 SAP ASE server will fail to boot, if the underlying platform does not support TSX (Transactional synchronization Extensions) capability, but the ASE configuration option “enable transactional memory” is set in the config file. See KBA 3245400.
827132 The system stored procedure sp_sysmon_locks misses to report 'Lock Promotion' values for 'Up-Page' and 'Up-Row' cases. See KBA 3252094.
827133 A 529 error, “Explicit conversion from datatype 'IMAGE' to 'VARCHAR' is not allowed.”, may be reported when insert auditing is enabled and a data row is inserted into a table that has an IMAGE column defined. See KBA 3245904.
827148 In rare circumstances, a 692 error, "Uninitialized logical page < page-number > was read while accessing database < database-name > ( < database-id > ), object 'sysimrslogs' (59), index 'sysimrslogs' (0), partition 'sysimrslogs_59' (59). Please contact SAP Technical Support.", may be reported in the SAP ASE error log under an HADR system which includes an IMRS-enabled database.
827181 Changes to hashing algorithm to provide better hash key distribution for SAP ASE statement cache component. Adaptive Server needs be stared with trace flag 11032 to enable this change.
827193 In some circumstances, the query plan hint for WITH RECOMPILE is not recognized by execute cursor statements.
827195 DBCC FIX_PAGE utility has been enhanced to support new mode 'relaxed'.
827197 The output of DBCC SHOWRECOVERY may sometimes report an inaccurate value for "Percentage of log scan completed". See KBA 3252031.
827202 In some circumstances, when a query that includes a nested execution of the built-in 'hashbytes' is run, SAP ASE may produce an incorrect results set.
827207 The message, "Current process infected with 11 (SIGSEGV)", in the module 'mda_populate_monDeviceIO' together with a stacktrace may be reported in the SAP ASE error log when queries are being run against MDA table master..monDeviceIO while a device is simultaneously being dropped via sp_dropdevice or unmount database. See KBA 3124331.
827232 The execution of built-in show_cached_plan_in_xml( < statement-id > ,0) will not print the query plan details for execute cursors.
827325 A new option to skip 'removehadr' is added in 'setuphadr' utility while configuring an HADR system.


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR, CR List, ASE 16.0 SP04 PL04, ASE SP04 PL04, SP04 PL04 Adaptive Server Enterprise, Fix, Patch, Error, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW 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.