SAP Knowledge Base Article - Preview

2156266 - Targeted CR List for ASE 16.0 SP01 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.0 SP01 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 NumberDescription
575996 Enable SELECT INTO at LEVEL 0 by extending the already present INSERT SELECT at LEVEL 0.
743245 KBA 2067664 : ALTER TABLE places TEXT pages of a table onto incorrect system segment if ALTER TABLE adds the first TEXT/IMAGE/UNITEXT column for the table.
743958 Under some rare situation, the error, "Current process infected with signal 11 (SIGSEGV)" followed by a stack trace involving the module 'CgEvals::_CgCompVcol' may be reported if the plan has HASH join or MERGE join with numeric parameters in the join predicate.
745472 Incorrect output of message 3705 is displayed when executing DBCC TABLE sysdams if trace flag 3717 is on.
746163 A warning message, "WARNING: memory usage in procedure headers ( < count > ) does not match memory usage count in Pss ( < pss_memusage_count > ) for server process id (spid > ", may be seen in the SAP ASE error log when dumping a database to a non-existing directory.
750720 Selecting a remote column with a LIKE clause may get wrong result if the remote server's collation is different from that of the local server.
753408 Under some rare circumstance, the value of PagesTouched queried from the monCachePool MDA table is larger than AllocatedPages .
754621 preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later.
762262 ALTER DATABASE set durability no_recover does not show "enhanced performance" status in sp_helpdb output.
767058 In rare circumstances, the error, "Current process infected with 11 (SIGSEGV)", followed by a stack trace involving the function 'com__exctnume_copy' may be reported in the SAP ASE error log when executing a query if a java client set "HOMOGENEOUS_BATCH" to true and the parameter is numeric type and its value is set to NULL.
768319 In some cases, killing an Adaptive Server process that is executing a dump command on a big database, might take some time to terminate the Backup Server process. While the process in the SAP Adaptive Server is gone, the counterpart process in the SAP ASE Backup Server could continue running for some extra time unnecessarily.
768510 Database timestamp (@@dbts) jumps by a large amount unexpectedly during LOAD TRANSACTION.
768530 On a hash partitioned table, a disqualified partition predicate (i.e always FALSE predicate) can be treated as a predicate on non-partitioning columns. This causes certain partitions that could be eliminated, to be classified as valid partitions.
769444 An 832 error, "Unable to place buffer < buffer_id > holding logical page < page_id > in sdes for object < object_name > - there is no room in sdes aux keep pool", may be reported when 'max buffers per lava operator' is set to the maximum config value of 65535 or to a value very close to maximum value.
770449 Even if "number of open databases" is increased on ASE in a High Availability System, the additional number of open databases cannot be used.
770497 Error 2809 may be raised incorrectly, specifying the name of an object that isn't involved in the query, for some queries involving a derived table and view in another database that has the same object id as a procedure in the user's current database.
770759 Creating a login by using CREATE LOGIN command within conditional statements like IF etc., with auditing enabled may lead to stack trace due to incorrect length for a memory move.
770863 The error, "Current process infected with 11 (SIGSEGV)", may be reported in the SAP ASE error log and SAP ASE may core dump if SAP ASE receives an external attention during MERGE join and internal sorting.
771137 Performance enhancement for "DUMP TRAN with TRUNCATE_ONLY" option when many concurrent sessions are active.
771147 Enhance the error handling and diagnostic reporting for invalid column data length errors.
771630 Reduce contention for the MONITOR_LOCK spinlock when resource monitoring is enabled.
771719 DDLGEN may capture incorrect stored procedure DDL when stored procedure is set to both ‘anymode’ and 'dynamic'
771876 Performance problem with application context builtins
772741 KBA 2084181 : ASE running on Linux shows the incorrect time for Europe/Moscow Time Zone.
772979 DDLGEN does not support WITH DBID= for CREATE DATABASE in ASE 15.7
773070 Under some circumstances, the assertion failure, "Assertion (pwdlen < SAMAXPWDLEN+1) failed in file /remote/aptos_bld1/asecorona/SMP/porttree/svr/sql/generic/source/utils/ssladmin.c line 414", may be reported when running SAP ASE diagserver and the service key 'syb_extpasswdkey' is dropped.
773131 In rare circumstances, a heap memory error 712, "There is insufficient heap memory to allocate %ld bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less activity on the system" may be reported when executing DBCC LISTOAM on table with high OAM entry count.
773880 In rare scenarios, during a workload startup the rdbtmgr_spin spinlock might have contention.
774198 KBA 2077419 : When DOL tables are partitioned the values for concurrency_opt_threshold are lost.
774555 DDLGen with option -Cnumber will generate wrong table owner
775123 Performance enhancement provided for estimating the size of the log to be processed by Replication Agent.
775622 When upper case letters are used in a login name, sp_passwordpolicy 'expire login passwords' on that login name fails to find the login.
775888 If SDC instances are running with different versions of ASE server then the data exchange between the nodes may fail.
775947 New built in functions hadr_state(), hadr_mode() and sp_hadr_admin stored procedure options "state", "mode" that provide descriptive output for globals @@hadr_mode, @@hadr_state are now provided.
776552 After upgrade from SAP ASE 15.7 ESD#4.2 or older releases to SAP ASE 15.7 SP63, SP130, ASE16.0 the decryption of LDAPUA access account passwords or SSL private key passwords stored in sysattributes which use 3DES encryption algorithm fails with message in errorlog: "... SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt.'."
776653 An invalid record with dump type 6 will be added to the dump history file when the option 'dump history' is enabled and a DUMP TRANSACTION WITH STANDBY_ACCESS is executed.
776836 New column 'execution_time' is added into system table SYSPROCESSES. Execution time (including compilation time) is the time that the process has been running and the precision is milliseconds.
776950 When auditing is enabled and audit options turned on, inserting an empty string value as a variable into a table that does not allow NULLs will incorrectly fail with Msg 515, "Attempt to insert NULL value into column ...; column does not allow nulls"
776962 Under some rare circumstance, the error, "Current process infected with signal 11 (SIGSEGV)", may be reported during concurrent queries on the monProcessProcedures MDA table. It is possible that no stacktrace is printed.
777033 New permissions granted to system defined roles post 157esd#2 are not reflected in the upgraded server.
777475 In rare circumstances, a 644 error, "Index row entry for data row id ( < page > , < row > ) is missing from index page < page > of index id of table 'sysstatistics' in database ' < db > '", may be reported during the load of an SAP ASE 12.5 database into an SAP ASE 15.7 dataserver.
777895 A 6103 error, "Unable to do cleanup for the killed process; received Msg < message_num > " followed by the error, "Current process infected with signal 11 (SIGSEGV)", may be reported in the SAP ASE error log, when executing sort on a worktable.
777994 In ASE HADR cluster, if ASE is already in Primary state and 'sp_hadr_admin primary' command is issued, incorrect message "standby command is not allowed in current server state" is reported.
778217 KBA 2123202 : A 2601 error, "Attempt to insert duplicate key row in object 'sysusers' with unique index 'ncsysusers1'", may be reported when some legacy user databases fail to upgrade to SP130 (or SP131) at upgrade step 245.
778304 The error, "Current process (0x1c3300de) infected with signal 11 (SIGSEGV)", followed by a stack trace involving the module 'ubo_slotscan_getnext' may be reported in the error log when sp_sysmon is executed or the monTask MDA table is queried with KTID or ThreadPoolID specified.
778585 A 2540 error, "Table Corrupt: Page is allocated but not linked" may be reported when running DBCC CHECKALLOC on a SDC server.
778882 After executing the procedure sp_dumpoptimize to set the backup server allocation threshold level, every DUMP command execution should resend the defined values to the backup server. Instead, the DUMP command is only sending a command to the backup server to retrieve and display the current setting.
779387 KBA 2184272 - Error messages 15960, 806 and 15996 may be reported when encrypting and then decrypting a database.
779495 KBA 2153917 : A 624 error, "Adaptive Server failed to retrieve a row via its RID in database ' < dbname > ' because the requested RID has a higher number than the last RID on the page.", may sometimes be encountered while rolling back a transaction containing an open cursor on an ALLPAGES LOCKED table with a clustered index and one or more nonclustered indexes, if DMLs within that transaction caused a page split of the data page on which the cursor was positioned.
779891 DDLGEN may report a “Critical internal application error” if there is a Cross Database Foreign Key and there is a bad dbid in sysreferences.
779974 In rare circumstances, when REORG REBUILD ... WITH ONLINE is aborted due to an internal error or a forced kill, while the database options ‘full logging for all', 'full logging for reorg rebuild', and ‘enforce dump tran sequence' are enabled, errors like 605 "An attempt was made to fetch logical page '' from cache ''. Page belongs to < > and not to < > .", 697 "An attempt was made to fetch logical page '' for < > from cache ''. Wrong logical page '' was found in cache.", 12546 "During undo the timestamp to be assigned to a page is less than the current page timestamp. Page = '', object id = < > , page timestamp = (x y), new page timestamp = (p q), or 806 "Could not find virtual page for logical page '' in database < > ' may be reported in the SAP ASE error log.
780039 KBA 2135472 : REORG REBUILD on deferred tables fails with 691 error.
780228 When the stored procedure sp_hadr_admin 'config_bs' receives a NULL second parameter it inserts one entry for the backup server listener IP address in the hosts.allow file. This a new feature to insert one line for each of the host names aliases for the listener IP address instead of the IP address.
780390 When shared memory is not available from the operating system during server startup and a memory allocation fails during initialization of RSA module, then a segmentation violation may occur in uppopaffinity().
780424 During periods of heavy I/O stress, creating page signatures can result in incorrect page linkage with 2628 error, "In database < db_name > , page < page_id1 > is linked forward to page < page_id2 > , but that page is linked backward to page < page_id3 > . Please report this internal error to Sybase Technical Support" reported in the error log.
780619 KBA 2140170 : Under some conditions, such as killing a process using execute immediate, may cause the server to hang.
780724 A timeslice error in the module 'dol_def_update' together with a stack trace which includes the modules 'dodeferred' and 'xact_endupdate' may be reported in the error log when an UPDATE is executed for a long transaction in deferred mode.
780736 A 9242 error, "RepAgent( < dbid > ): Underflow or overflow of state stack occurred.", may be reported in the SAP ASE error log when the stream replication is enabled. This error will shutdown the Replication Agent process for the given database.
780738 DBCC ZAPDEFRAGINFO will not delete the rows from sysattributes when no action is specified.
780764 The error message, "Current process infected with signal 11 (SIGSEGV)", followed by the stack trace involving the modules 'ra__coord_driver' and 'ra_schema_dealloc_cache' may be reported against the Replication Agent Coordinator Thread when Replication Agent is configured for Multiple Paths Replication and Multiple Scanners, and it is stopped by executing sp_stop_rep_agent.
781067 New feature request to allow the Backup Server be identified by another remote Backup Server by its listening address instead of using the default one defined by the routine tables in the operating system. This option is enabled by default. To disable this feature execute sp_configure 'bind backupserver address', 0.
781099 KBA 2143875 : SAP ASE goes into an infinite loop during index creation with parallel hashstats enabled.
781374 A 7175 error, "Textptr ( < > ) for an in row lob either contains an invalid datarow RID or the datarow cannot be read.", may be reported when running WRITETEXT command with a text pointer value obtained from @@textptr immediately after updating in-row LOB column and one or more columns of other datatype in the same UPDATE command.
781403 DBISQL/jConnect sometimes fails to connect in a VLAN setup and gets a connection timeout when the host is behind a proxy server. To work around the connection issue, try to add "-Dase.useSystemProxies=false" to "VM_ARGUMENTS" line in dbisql.ini file (which is located under "bin" directory.)
781455 Running UPDAT STATISTICS and TRUNCATE TABLE concurrently may cause the server to hang due to undetected deadlock.
781495 KBA 2153895 : An 814 error, "Keep count of buffer < ID > in cache < cache_name > holding logical page < page_id > in database < db_name > has become negative", may be reported when altering an IMDB having multiple cache partitions.
781513 ASE on windows may report an error with a stack trace including an unknown signal (-1073741784)followed by the message, "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED".
781577 In some circumstances for some queries joining several tables the optimizer could choose a query execution plan which generates bloom filters that at the end are not efficient in filtering out any row and could result in a slight performance degradation.
781610 Under rare circumstances, REORG DEFRAG utility when run with the option 'skip_compact_extents' may terminate prematurely with the error, "REORG DEFRAG of < dbname > terminated due to error or user interrupt.
781650 834 error seen during buffree due to DESTROY bit set for IMDB when validation fails.
781815 Under rare circumstances, a 605 error, "An attempt was made to fetch logical page ' < > ' from cache ... ", together with a stack trace which includes the module 'dol_bt_getnext' may be reported in the error log when a DML is executed on a table on which a REORG DEFRAG command was run before while rows were being concurrently inserted.
781825 When "enable streamlined parallel" is set to 1, parallel query plans may get generated resulting in serious performance issues.
781828 A 12964 error, "DBCC cannot insert the row in the dbcc_operation_log table for this check of database < database name > , aborting check." may be reported when running DBCC CHECKSTORAGE on a SDC server.
781853 In rare circumstances a query executed in parallel may appear as hang when it is killed by other session. If DBCC STACKTRACE() is run in the parent session it would report a stack trace which includes the modules 'uwdisconnect' and 'err_disconnect_allchildren' and if run in any of the worker processes it includes 'LeScanContext::syncOnBloomFilters' and 'LeExecuteWorkUnits'.
781859 In some circumstances, Adaptive Server may report a stacktrace which includes modules GtsState::GtsGetGt() and SeHyPsStarQueryRule::_RuleSnowFlakeMatch(), when a fact_table hint is given in the input abstract plan.
781934 sp_monitorconfig "additional network memory" always return a value of 0 for Num_active.
782006 A new error message 140064, "ERROR in < module_name > for plc < 0x > ... " is created to qualify for a shared memory dump condition in case wrong number of log records are moved during PLC discard which may result in wrong count in PLC. Additionally new error message 140063, "ERROR in < module_name > for plc < 0x > ... " is created to qualify for a shared memory dump condition in case of wrong PLC count or wrong log record size in PLC while the PLC is flushed to syslogs. These messages are printed in the error log. These errors may result in error 3475.
782010 In rare circumstances, SAP ASE may hang as a result of an undetected deadlock between a process doing REORG DEFRAG and a process doing level 0 scans or dirty reads under a transaction that included DMLs.
782011 A 1108 error, "Cannot deallocate extent < extentid > , database < dbid > . Object id < objid > , index id < indid > , status 1 in extent does not match object id < objid2 > , index id < indid2 > , status 0 in object being deallocated. Run DBCC CHECKALLOC." may be reported in the module 'pg__dropbuf' together with a stack trace in the error log which includes the modules 'xact_rollback' and 'undo_apl_aextent', when online reorg rebuild rolls back.
782102 A 3475 error, "There is no space available in SYSLOGS to log a record for which space has been reserved in database ' < dbname > '", can sometimes be reported if the current process or other processes in the system are executing minimally logged DMLs on tables having TEXT/IMAGE columns.
782158 An 806 error, "Could not find virtual page for logical page < page_no > in database < dbname > " may be reported in the error log when executing ALTER DATABASE for encryption after an upgrade from a pre-16.0 server.
782182 New option "short" added for sp_showplan to display statistics information only. Query text and plan won't be printed with this option. "Rows affected" is also added to output of sp_showplan.
782222 The fix for CR 776287 is redesigned not to take corrective actions in the context of error 3475.
782225 A 1105 error, “Can't allocate space for object ' < > ' in database ' < > ' because 'syslogs' segment is full/has no free extents…”, may be reported on a user defined temporary in-memory database when DML commands are executed concurrently in cross-imdb transactions whereby the log cannot be truncated.
782294 When auditing is enabled and an audit option that captures ALTER LOGIN is set and ALTER LOGIN .. MODIFY PASSWD is executed, then the ALTER LOGIN audit event is missing in the audit trail.
782316 A 11277 error, "Operating system error 2: 'No such file or directory'", may be reported on Windows when the stored procedure sp_dump_history is run with the 'list' option.
782443 When ASE Replication Agent is configured for Multiple Paths Replication, the procedure rs_ticket is not distributed properly to all replication paths due to missing 'begin tran' commands.
782486 The error, "Attempt to start database device i/o failed: State = 118 Msg = Attempt to issue i/o beyond offset of 2 GB failed, since the operating system does not support it", will be reported in the Backup Server errorlog when a database device is bigger than 2GB in solaris 64 bits.
782519 The error,"Current process infected with signal 11 (SIGSEGV)", followed by a stack trace involving the module 'decompress_column_by_coloff' may be reported in the error log when executing online split partitions.
782571 Addition of validation checks for a session's User Log Cache when log records are added or removed from it, so as to allow diagnostics in case of inconsistencies found.
782596 KBA 2168634 : A 3474 error, "During redo the page timestamp value is less than old timestamp from log. ...", may be reported during LOAD TRANSACTION of a transaction log dump that includes log records pertaining to DMLs executed after a successful run of the online reorg rebuild. Or, a 2503 error, "Table corrupt: Page linkage is not consistent" may be reported by a DBCC CHECKTABLE on the table after the database has been onlined after the above mentioned load sequence.
782609 The timestamp in a database after a cross platform load does not match the timestamp of the source database.
782634 Print object list for INSERT/UPDATE/DELETE/SELECT with option 'set show_object_list on'. Print object list in output of sp_showplan with option 'long' and 'full'.
782706 When using deferred parallel, optimizer may not choose parallel query plans that it would have chosen in non-deferred mode.
782714 If more than one dimension tables are joined using the same column from a fact table, the fact_table hint may fail.
782735 role_locked audit option is missing in the list displayed by sp_audit
782817 The error, "Current process infected with signal 11 (SIGSEGV)", followed by a stack trace involving the function 'bi_dbencryption_status' may be reported in the error log when executing ALTER DATABASE for encryption/decryption.
782835 KBA 2161415 : On ASE Cluster Edition, the value of the spid displayed is zero when executing the system stored procedure sp_help_rep_agent and when querying the MDA tables monRepLogActivity, monRepScanners and monRepSenders even though the Replication Agent Thread is running.
782845 When using "alter database ... off" to shrink a database, if a disk piece's location column in sysusages is null and that disk piece must be divided, the resultant sysusages entry for that disk piece can have invalid entries for unreservedpgs and crdate.
782869 SQL query with TOP and abstract plan using user defined optimization goal may fail with stack traces reported in the error log.
782871 KBA 2164927 : In some circumstances, a query on the monLock MDA table may cause some running processes to be infected by timeslice errors.
782880 A 10350 error, "Permission related internal error was encountered. Unable to continue", may be reported when executing DML statements on tables with encrypted column having decrypt default on columns 64 and above.
782896 Allow the use of sp_chgattribute < tablename > , plldegree < degree > as a way to force HASH based parallel scan of a table that does not have a data skew above the maximum threshold for partitioning skew.
783048 An 806 error, "Could not find virtual page for logical page < psge# > in database 'master'", may be reported in the SAP ASE error log when streaming replication is enabled and while failover or failback operations are taking place in an HADR system.
783072 A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error", may be reported when executing a stored procedure that includes a SELECT INTO with the source table having an encrypted column with decrypt default and a convert() function.
783261 KBA 2162777 : A 9209 error, "RepAgent( < dbid > ): Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker = ( < page# > , < row# > ))", may be reported in the SAP ASE error log during data replication, if the server uses a multi-byte character set, and if LOB data is inserted by WRITETEXT bulk command, and if the last character of the LOB data is a multi-byte character that has to be split into two LOB pages. Alternatively a 9219 error, "RepAgent( < dbid > ): Internal coding error", may be reported.
783294 KBA 2161945 : Error 4902 is reported when running ALTER TABLE on a table named 'master'.
783581 Do not log DDL for replication when dropping a definition time object.
783594 jConnect: Calling getColumns() method on DatabaseMetaData object may execute with sub-optimal query plans after a large number of database objects are created.
783598 If a query has several predicates on the same columns and the columns are CHAR/VARCHAR datatypes, it could cause AIX machine to hang when we try to eliminate some predicates. For the DEBUG binary, it will cause an assertion failure.
783610 When stream replication is enabled the Replication Agent scanner process can sometimes not be killed using the T-SQL kill command.
783665 The PCA/JVM default configuration settings have been changed to disable File I/O opeartions for the temporary directory option 'pca_jvm_tmp_dir' and the working directory option 'pca_jvm_work_dir'.
783667 The PCA/JVM provided Secure Class loader will deny executing methods that request to load dynamic shared libraries by default.
783804 The 15413 message, "An internal error occurred during an encryption operation (error code -1). Please contact Sybase Technical Support", will be reported with inserting into encrypted columns with select list and order by having encrypted column with length > 255 bytes.
783985 The error, "Pathname parameter must specify an absolute pathname", followed by error, "RPC ('as_arch_device') execution failed", may be reported in the SAP Backup Server error log if a remote DUMP DATABASE USING CONFIG command is executed while using a remote configuration option that was defined by sp_config_dump 'remote_cfg'.
784030 The 15432 message, "A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password.", will be raised when ALTER ENCRYPTION KEY is executed to add key copy for recovery and to recover the key copy in a stored procedure.
784222 KBA 2170606 : An 899 error, "The page < page# > requested for in-memory database ' < dbname > ' ( < dbid > ), object ' < name > ' ( < id > ) was not found in in-memory storage cache ' < cachename > '(id < cacheid > ). Please contact Sybase Technical Support.", may be reported in the SAP ASE error log during startup while an in-memory database is recovered and when there is more than one in-memory database and the configuration option ‘number of large i/o buffers’ value is not sufficient. This error can also be reported during the creation of in-memory database when a concurrent load database is run. Sometimes a 6103 error, "Unable to do cleanup for the killed process; received Msg 14120.", may also be reported.
784547 A 3101 error, "Database in use. A user with System Administrator (SA) role must have exclusive use of database to run load.", may be reported during the execution of DUMP database, if the RepAgent has been previously shutdown.
784606 An 871 error, "Process %d is trying to release a latch on buffer 0x%x (dbid: %d, pageno: %u) without holding a latch on the buffer", may occur when executing an online parallel create index in the Data Page lock scheme.


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 SP01 PL02, ASE SP01 PL02, SP01 PL02, SP01 PL 02, Adaptive Server Enterprise, Fix, Patch, Error, Bug, GA SP01 PL02 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.