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 SP02. 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 |
---|---|
73037 | There is no convenient way to reclaim unneeded space from a database except to drop and recreate that database. |
393424 | The sp_monitor connection option may encounter an arithmetic overflow exception of any of the connections with active queries on the server has been established for a long period of time. |
448907 | Adds the PREPARE DATABASE command. This command is very similar to the QUIESCE DATABASE command, with the exception that it does not block write activity during the HOLD phase. The HOLD/RELEASE options can be used to execute a mirror split or snapshot on the database using a certified agent, to create a copy of a database on which transaction logs can be loaded. |
464605 | The "enable large pool for load" configuration parameter is added to configure the use of large buffer pools during the recovery phase for LOAD DATABASE and LOAD TRANSACTION commands execution. This configuration parameter will default to 0 if "enable functionality group" is set to 0, and to 1 if "enable functionality group" is set to 1. |
480652 | The paths for the cluster devices are not checked to insure they are not reused in the same input session when creating new cluster. |
484059 | Cluster failed to start after creation if interfaces path contains "#". |
484953 | Sybcluster show instance status does not show correct status if shutdown instance outside sybcluster immediately. |
493317 | When quorum device cannot be accessed, running 'show cluster status' will report an inexplicit error "The cluster entry did not contain any servers" |
498501 | Sybmigrate - unable to generate index ddl when user\db have same name |
500347 | Temporary files are not cleaned up after cluster creation. |
542339 | The command, 'diagnose instance', does not report any message if the interfaces file is missing the domain suffix of the machine name. |
545716 | Long Running Transaction against an SAP ASE server can prevent the log being truncated, causing risk of data unavailability for DMLs. Improve how this can be managed. |
546891 | Permissions on "sysslices" system table remain unchanged when "GRANT DEFAULT PERMISSIONS ON SYSTEM TABLES" or "REVOKE DEFAULT PERMISSIONS ON SYSTEM TABLES" SQL commands are executed. |
548593 | Updating a TEXT value into a proxy TEXT column using the value from a local TEXT column results in garbage being inserted. |
565321 | In parallel query mode, monProcessWorkerThread.ThreadsActive, monProcess.NumChildren, monSysWorkerThreads.PlansAltered and monProcessStatement.PlansAltered are always 0. |
575996 | Enable SELECT INTO at LEVEL 0 by extending the already present INSERT SELECT at LEVEL 0. |
578515 | sp_sysmon appl_and_login does not show the detail of activity by application name and login name. |
590190 | If a table is on an inner side of a join, the 'UsedCount' of the table could be incremented multiple times of 'OptSelectCount' of the table in monOpenObjectActivity table. |
609692 | When dumping and loading databases containing functional indexes between specific platforms, dropping indexes on the new server can fail with a syntax error message. |
618245 | UPDATE STATISTICS on a proxy table with a specified column may return error 12814 - "Failed to write information in SYSTABSTATS." |
618451 | The message "dbid < dbid > objid < objid > open failed" may be reported when running DBCC EXTENTZAP or EXTENTCHECK on a table that is missing entries in sysobjects. |
625217 | UPDATE STATISTICS command on a proxy table writes the wrong page count for a row having indid 0 or 1 into systabstats system table if the ASE page size is more than 2K. |
636424 | A new recommended corrective action has been added to sp_dbcc_help_fault for type_code 100004. |
639813 | Execution of stored procedure 'sp_renamedb' from read-only database results in a 3906 error, "Attempt to BEGIN TRANSACTION in database failed because database is READ ONLY." Message should reflect that "You must be in master in order to run stored procedure for read-only database." |
643556 | Cross platform transaction load is not supported, but it is allowed and it may result in Msg 695, Level 21 "An attempt was made to read logical page ' < pageid > ' for database ' < db_name > ' ... Wrong logical page '2433379939' was broughtinto cache"; Cross platform load in an archive database is also not supported but it is allowed and may result in Msg 15760 - "Invalid dump header when loading the database with ID ' < n > '.". |
645898 | In rare circumstances, after configuring a big data cache or a large stack size, SAP ASE might implicitly shut down following a JavaVM crash while executing a Java query. The message EXCEPTION_ACCESS_VIOLATION or 'ExceptionCode: c0000005' will be reported in the SAP ASE error log. |
648514 | Error 1105 States 4, 5, and 7 may no longer mean what they are documented to mean in the ASE Troubleshooting Guide due to reuse of the values in new code. |
652328 | TEXT/IMAGE page chains are not deleted properly from sysattributes when REORG REBUILD is called on a table with TEXT and IMAGE data. This can result in reduction of unreserved/available space in the database. |
653277 | An UPDATE query running in a batch that includes a CREATE INDEX or UPDATE/DELETE STATISTICS or an UPDATE query running simultaneously with a workload that involves CREATE INDEX or UPDATE/DELETE STATISTICS may lead to data inconsistency. |
656902 | If a query contains a join between partitioned tables and one of the partitioned tables degenerates to a single partition through dynamic partition elimination and there is a CIS table in the query, then a SEGV could occur in the PartNodeInfo::collocatedSite() method. |
664714 | Increase the limit on the number of historical configuration files saved from 999 to 999999999. |
664848 | KBA 2011340. In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 'ind__get_sysindrow()' together with a stack trace which includes the modules 'getindexname()' and 'CgGenLava::CGConsScanOp()' may be reported in the SAP ASE error log. This may happen when a statement, using temporary user tables or tables created in the same batch or stored procedure and with indexes defined, is being compiled before execution. |
665284 | The message, "Current process infected with signal 11" followed by a stack trace that includes the module Partitions::initHintsForDegree() may be reported when a remote procedure is executed with the recompile option. |
666239 | The limit for cache partitioning has been extended from 128 to 256. |
666597 | New Feature Request ... add indicator to monCachedProcedures to show active entries |
668638 | The sp_opt_querystats stored procedure reports error number 17077 indicating that the optimizer diagnostic results were incomplete and does not generate any output. |
670273 | In some circumstances, the Operations value in the monOpenObjectActivity MDA table does not reflect the actual number of table accesses. |
672255 | In some circumstance, the CPU usage of ASE might increase to near 100% after turning on the “plan text pipe active” option. |
672606 | In some cases the output from the sp_opt_querystats stored procedure would be formatted incorrectly due to lines being broken in the middle of words or due to missing letters or characters. |
674535 | Products: ASE 15.5 ESD#3 SQL Advantange 12.5.3 EBF 12338 DBISQL version 11.01, build 2430 Problem Description: Customer reports that DBISQL does not report as much detailed message compared with SQL Advantage. Since SQL Advantage is deprecated customer is requesting FR to be implemented: |
674632 | Enhance index scan perforamce on little-endian platforms if the index includes large mount of duplicated keys. |
675791 | Enhance sp_rename stored procedure to rename data and index partitions. |
676122 | ASE does not respond and appears to hang when invalid packets are sent to it. |
678527 | KBA 2016211. In some long running ASE servers, an 8203 error - "Expected to find the descriptor for object < objid > in database < db_num > in < state > state." might be raised with crt_main in the stack trace while creating a temporary table. There will be an information message "INFO: Total Object Ids in temporary database generated: < total id count > , LWPs generated: < LWP id count > " printed for every 100 million object ids generated |
680899 | sybcluster should have a way to back off incomplete removal or alternately the CR 680891 should provide complete instructions for recovery from errors during "drop instance". |
682354 | Allows stored procedures which reference temp tables created outside the procedure to not require recompilation for every execution. This was previously supported by trace flag 299. |
682486 | Add a new fake table in 'master', named 'syslogsdetail'. This is used to serve up the log records details, only metadata and not including user data, as a result set. |
683127 | DDL is now replicated within user stored procedures. |
683762 | On Windows platforms, preupgrade eligibility test fails when using sysconfig.exe to upgrade ASE. |
683882 | Excessive I/O to quorum devices is observed when SCC is up and cluster is down. |
684459 | On AIX platform, the mapping of addresses to function names in SAP ASE stack traces has been improved. This will provide a superior mapping when the address is in a shared library. |
687372 | A 697 error, "An attempt was made to fetch logical page < pagenum > for database < dbname > ....", during transaction rollback, if the transaction is doing some DMLs to upgrade row lock to table lock. |
689004 | Setting the configuration parameter 'send doneinproc tokens' to zero, can cause the global variable @@rowcount to report an incorrect value inside a stored procedure or trigger. |
691074 | sybmigrate: initial login screen doesn't see servers named with "query" |
691582 | In rare cases, a DUMP TRAN command is incorrectly allowed following a DUMP DATABASE command during which a partially-logged command like SELECT INTO was active that also commits some time towards the end of the DUMP DATABASE command. The partially logged operation will be lost when the database dump and transaction log are loaded. |
692237 | Starting the Backup Server with -D4096 will suppress messages "Attempting DSync I/O for device ' < value > '." from being reported in the Backup Server error log during the execution of a DUMP DATABASE command. |
692359 | Performance Enhancements to BCM Latching without Cache spinlock in addition to Buffer ELC changes for ASE Scaleup. |
692509 | sp_sysmon 'cache wizard' got Msg 3606 "Arithmetic overflow occurred" |
693775 | Job Scheduler is enhanced to execute job from startdate:starttime to enddate:endtime under new schedule property 'continuous_run'. |
693982 | alter table fails to update status2 in syscolumns when column being modified to add/drop a default value |
694495 | The command DBCC SETTRUNC('ltm', 'end') extends the transaction log with one page before setting the Secondary Truncation Point to the new end of the log so as to avoid unwanted data replication. |
694912 | Exception is raised from localize command in sybcluster if ASE-15_0/locales contains unnecessary files/dirs. |
697129 | Supporting Lock Remastering for SAP ASE Cluster Edition. When the master assignment is set to affinity mode, the masters will gradually get re-allocated to the instances that initiates the lock convert requests, if “enable lock remastering” is set to 1(ON) in the configuration file. By default, “enable lock remastering” is set to 0 (OFF). It is not recommended to set “enable lock remastering” to 1 (ON) for badly partitioned cases. |
700227 | Reduce additional logging done on page compressed DMLs for replication support, trigger support, and online utilities support. |
701608 | Signal 11 in LeSarg::mapSarg is reported due to incorrect classification of Transitive Closure predicates, at optimization time. |
701705 | New monitors have been added to collect each engine resource's Engine Local Caches (ELC) performance. |
702725 | In circumstances whereby the select list of an INSERT SELECT with ORDER BY does not include the 'order by' columns, it is possible that the optimizer will favor a non-matching index scan using an index with the order by column(s) as opposed to a more efficient plan using a matching index scan for one or more of the filter predicates. A new optcriteria cr702725 has been introduced for this change. Use "set cr702725 1" to turn on the change and "set cr702725 0" to turn it off. |
702907 | In specific circumstances it is possible to receive a 2601 error on execution of a stored procedure. The issue is much more likely to happen with 'deferred name resolution' enabled. This can happen when a stored procedure has been initially created, then for the 'first' execution, multiple concurrent connections all run the procedure at the 'same'time. If running with 'deferred name resolution' enabled at create procedure time, the error is much more likely to occur. It could also happen in circumstances where the query tree needs to be recreated from text as in after the ASE is upgraded. |
703134 | ASE provides inaccurate estimation for 'kernel resource memory' configuration parameter. |
703607 | Backup Server is enhanced to provide Multithread support needed for Tivoli Storage Manager options such as LAN-FREE. This support is off by default. It can be turned on by using the new –D8192 option during Backup Server startup. For example: ${BACKUPSERVER} -SSYB_BACKUP -I$SYBASE/interfaces -M${SYBMULTBUF} -D8192& |
704671 | While executing large amount of dynamically prepared statements we could find DBT_SPIN as still contentious. |
704744 | Log an informational message in the error log when memory allocation with Linux 'hugepages' succeeds. Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages. |
704899 | Add new configuration option 'enable HugePages' for Linux to control whether to boot ASE with HugePages and 'enable ISM' for Solaris to control whether to boot ASE with ISM |
705198 | Generating ddl for proxy tables includes create index ddl for the proxy table |
705390 | number of checkpoint tasks has to be set to default or 1 before upgrade, or it will fail, and require manually editing the config file before restarting the upgrade process. This should be handled in the preupgrade. |
705516 | Feature request to improve sp_configure to perform kernel resource memory consistancy checks. |
706543 | sybmigrate and DDLGen fail when there is "&" in the object name |
708143 | asehostname() can return null or truncated values when the hostname is greater than 30 characters. |
708830 | sp_dump_history returns error 17152, version missing or invalid, when dump history file does not exist. |
709060 | When creating a cluster or adding an instance, sybcluster cannot detect invalid device name immediately after it is entered. |
709090 | Release DBISQL 16 for ASE. |
709474 | A new SpinlockSlotID column has been added to the monSpinlockActivity MDA table. This column provides a unique identifier for each spinlock in the current ASE server. This ID is not persistent across servers or restarts of the server. |
709754 | It is possible for a spid to terminate and a stack trace to appear in the SAP ASE error log containing the functions memset and bi__xml_query/bi_xmlextract. This can happen under heavy usage when the session heap memory pool has become starved. |
710057 | The timing and IO metrics in monCachedStatement for running queries were unchanged until the query completed. Four new columns have been added to provide intermediate updates. The new columns are called TotalLIO, TotalPIO, TotalCPUTime and TotalElapsedTime. |
710300 | Deploy plugin raises an error but reports that it succeed |
711106 | OPTDIAG and sp_showoptstats has been enhanced to support Precomputed Resultsets. |
711248 | Error 14575, "CREATE TABLE WITH COMPRESSION is not supported for in-memory database", followed by error 11050, "Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors. If there are no preceding errors, please contact Sybase Technical Support.", and error 11934, "REORG REBUILD of table 'tabname' failed due to an internal error. Please contact SYBASE Technical Support", may be reported when running 'reorg rebuild' command on table which has data or LOB compressedion defined after user is bind to temporary in-memory database. |
711328 | Using sybcluster to add an instance in interactive mode failed. |
711928 | sp_sysmon would report a 265 error, "Insufficient result space for explicit conversion of SMALLINT value '100' to a VARCHAR field" if ASE is configured with more than 100 engines. |
712125 | If there are more than 32 columns used in an UPDATE STATISTICS command, either explicitly or implicitly through the auto_temptable_stats feature, then there is a possibility of a stacktrace. |
712461 | If multi-column syntax is used with update statistics tabname (colname1, colname2,...) using out_of_range {on | off | default }, then the assignment of out_of_range behavior may not be associated with the correct columns. |
712480 | The LAVA based index creation is enhanced to support the case where the index leading columns are duplicated. |
712897 | sp_bindcache information is missing from DDLGen output. |
712957 | sybcluster will fail to connect to the cluster if duplicated agents are specified. |
712970 | Enhancement is made to sp_placeobject system procedure to support partitions. |
712996 | sp_showoptstats output has been changed for the < statsOutRan > tag to have a value of "on" if the "using out_of_range on" phrase was used in update statistics, and "off" if the "using out_of_range off" phrase was used, and will not be printed if "default" is in effect. Previously "true" was printed when "on" or "off" was used. |
713074 | Monitor server has been retired since 15.7 GA but sybcluster still contained the operations for configuring monitor server. These operation options have now been removed. |
713189 | If the Cluster Editions is configured with both backup or xp servers, then adding an instance with an xml input file may fail. |
713464 | Error 1503 may occur when index is created with LAVA based index creation if the number of distict index value is not greater than CONSUMERS number. |
713572 | A 12319 error followed by a stack trace that includes the modules LeMergeStmtOp::_LeOpClose() and dol_def_update() may be reported when a MERGE statement is using cloned plans. |
713638 | LIKE predicate optimizer estimations may be incorrect when UTF-8 is used. Optcriteria cr713638 is added to correct this issue. |
714330 | Add functionality to the LOAD ... WITH LISTONLY=CREATE_SQL command to include the various database options (applied with sp_dboption) and attributes (applied with CREATE and ALTER DATABASE) of the source database, in the generated SQL. |
714773 | In a multi-engine ASE running on the Unix platform, the tracefile for the spid (created using 'set tracefile < path > for < spid > ') is truncated in pre 15.7, while the tracefile is not populated post 15.7 in process kernel mode, when the spid being traced is affiniated to an engine other than the one which created the tracefile initially (This can happen if the engine that created the tracefile is offline). |
715203 | DBCC CHECKSTORAGE does not detect LOB compression flag inconsistencies in the TIPSA. With DBCC CHECKTABLE and DBCC CHECKDB these types of inconsistencies were already being reported with message 15960. |
715228 | Wrong result could happen when referencing a non-correlated scalar aggregate view at the inner side of an OUTER JOIN. |
715312 | Use of online utilities like 'reorg rebuild with online' might lead to incorrect used/unused counts in the OAM for the table. This is reflected by a later 'dbcc checkalloc' on the table reporting error messages 7949 and 7940. |
716262 | On HPIA64 platforms, ASE may report error 16747, "The 'enable hp posix async i/o' configuration option is only available on the HPUX platform. This option is not valid on the current platform." if 'number of disk tasks' is set as larger than 1 when 'enable hp posix async i/o' is enabled. |
716645 | During an UPDATE command on a table that has in-row LOB columns defined, ASE may move some of these columns from in-row to off-row or vice-versa if the size of a datarow exceeds configured limits. When such a table has a datarow with an off-row LOB column that is not explicitly updated, ASE may not log this column data correctly. This will result in replication failing if this column is marked as always_replicate. |
716957 | In rare circumstances, a 614 error, "Adaptive Server accessed a row that has an illegal length of < value > while in data base < database > " may be reported when running DBCC FIX_TEXT on a data-only-locked table. |
717026 | KBA 2093231. Improve spinlock efficiency on Solaris SPARC platform. |
718253 | Utilities like haisql, HAase agent or MSCS HA agent, connects to the ASE server, however not using login/password encryption on the network. When configuration parameter "net password encryption reqd" is set to 1/2, the utilities like haisql, HAase Agent or MSCS HA agent will fail to login to server with following errors : Msg 1640, Level 16, State 2: Adaptive Server requires encryption of the login password on the network. Msg 4002, Level 14, State 1: Login failed. CT-LIBRARY error: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed. |
718398 | Update statistics options are 'sticky', meaning previous values which are explicitly set will continue to be used for future update statistics and create index commands on the same table if these options are not specified. These sticky options are: step count (using step values); histogram_tuning_factor; sampling; hashing, partial_hashing, no_hashing. This CR implements a configuration parameter "enable sticky statistics" to control statistics stickiness server wide. The default for "enable sticky statistics" is 1, which matches existing sticky statistics behavior. To turn off sticky statistics, use: sp_configure “enable sticky statistics” , 0 |
718658 | A signal 11 (SIGSEGV) error occured in kmuxtskGetThreadpool() while running sp_sysmon. This is a timing-related issue that is not easy to reproduce. It occurs only on a server that is running in threaded kernel mode. |
718733 | Support a 'WITH RECOMPILE' clause at the statement level. |
718741 | Signal 11 in bufdlink() *also reporting ups_nosort_init_prestat() & us_allocate_stat_proc_hdr() * may appear in the error log along with the server shutting down. This can happen when there is a worktable used by an update statistics command that resides on an in-memory tempdb (IMDB) |
719212 | Applications running against ASE on Solaris platform (SPARC and x64) in threaded mode may experience poor performance (response time and throughput). Analysis of sp_sysmon outputs and MDA tables may show high I/O Busy% and high wait times on disk-related events. Solution requires installation of OS patch for Oracle Bug 16054425 and setting ASE configuration parameter "solaris async i/o mode" to 1. This issue only affects ASE on the Solaris platforms. |
719374 | When changing the character set to a multibyte character set and running DBCC FIX_TEXT for the table with TEXT columns, the DBCC CHECKTABLE will fail with error 7951, "Data size mismatch while checking a text value". |
721270 | Immediate PRS creation with a LIKE clause throws a misleading error message that involves a builtin clause, because LIKE is internally converted to a BUILTIN operator. |
721403 | The status field in sp_helpdb output does not give any indication for temporary databases created with durability of "no_recovery" and normal temporary databases. |
721482 | sp_configure "o/s file descriptors" may show a larger value than the actual number of file descriptors as indicated in the error log. |
721543 | When using a resource file with sybmigrate, despite having plenty of room on the repository device specified, sybmigrate does not create the work database at the size specified in the resource file. |
721737 | When updating a column to have NULL value and an immediate refresh pre-computed result set (materialized view) exists which selects that column, the session will be disconnected unexpectedly and a stack trace that includes the module memmove() will be reported in the error log. |
721799 | The user usedb_user should not be allowed to create any objects. |
721809 | ASE at times sends extra TDS DONE packet for ct_cancel CT-Lib call. |
721824 | When the following is true: (1) the statement cache is on and (2) a dynamic prepared SQL statement containing a abstract plan clause is executed and (3) the same statement is prepared and executed by another ASE session, then the entry in the statement cache that was created by the first execution is not found when the dynamic prepare command is executed in the second session. As a result, a new LWP is created by the second session. |
721887 | With partitioned tables, some query plans may choose the MERGE UNION ALL operator, rather than Dynamic Partition Elimination. |
722058 | sybmigrate fails with the error, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'" at set up stage (sybmigrate -m setup). |
722240 | ASE Agent Plugin does not automatically detect the ASE error log file location changes. |
722535 | On Windows 2012, using syconfig, the backup server does not start when using the default backup server name. |
722539 | DDLGen does not support object dependency export. |
722591 | Execution of a stored procedure sometimes raises message 10334, "Permission related internal error was encountered". The statement being executed involves many UNIONs selecting from derived tables based on a temp table and the server is configured for multiple tempdbs. |
722610 | Configure server using different account |
722673 | The execution of the command "DROP PRECOMPUTED RESULT SET < prs_name > " on the primary database cannot be replicated into the standby database successfully. |
722777 | ASE does not respond and appears to hang when certain invalid packets are sent to it. |
722801 | Support is now provided for "high domain" (i.e. > 65535 unique values) parallel create index HASH based statistics gathering on minor attributes. |
722823 | Different behaviour for ISNULL on a MAX() or MIN() aggregate of a character column may be observed when statement cache is used with esql. |
722856 | In an HA environment when a role that contains a role activation predicate is dropped on the primary server the secondary server does not remove the predicate metadata. |
722867 | On Windows machines having multiple network interfaces i.e. both IPv4 and IPv6, ASE may fail to boot Job Scheduler with error, "JS: Failed to connect on socket" whereas JS Agent log indicates that JA Agent is listening with message, "SYB_JSAGENT waiting for connection". |
722898 | Under some circumstances, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table." may be reported while a temporray is being dropped. Such temporary table is found to have a dlevel0cnt = 12. |
722902 | DDLGen generates data partition names instead of index partition names in the index partition clause for a clustered index on an all pages locked table . Also the semantic order of partitions in the index partition clause for both clustered and non clustered indexes is not correct. Also if index partition names are system generated, then they are not generated in the partition spec , when -XPN option is specified |
723015 | The backupserver error message "3.27.2.1: Invalid RPC sequence at RPC as_cmd." followed by "5.7.2.7: RPC ('as_cmd') execution failed." may be reported when a LOAD DATABASE is executed and the backupserver name "hostname:portnumber" cannot be resolved correctly. |
723226 | After changing the owner of a replicated user table while DDL is not setup for replication, RepAgent may replicate DML commands on that table using the wrong owner name. |
723259 | In rare circumstances, a task may hang when LIKE clause or patindex builtin operator is used on columns which contain LOB data marked as compressed. |
723356 | A segmentation fault in tally_fetch() after a 249 error may occur during BCP IN due to invalid column default. Previous CR number is 552227 and the fix is under trace flag -T2781. Please turn on the trace flag to check column default data type during table creation time. |
723437 | A new database option "deallocate first text page", and a new configuration value 2 of table attribute "dealloc_first_txtpg", are provided for tables having TEXT/IMAGE/UNITEXT off-row storage columns, to control whether to deallocate the first text page after updating off-row LOB value from non-NULL to NULL, or whether to allocate a first text page when updating LOB value from NULL to NULL. |
723566 | The audit option sproc_perms can not be configured with sp_audit. |
723588 | Under certain circumstances, sp_monitorconfig 'number of locks' reports Max_Used as the total number of locks configured in SDC. |
723602 | A 156 error, "Incorrect syntax near the keyword 'default'" may be reported when executing ALTER TABLE MOVE PARTITION to 'default' segment. |
723672 | An 806 error, "Could not find virtual page for logical page < pagenum > in database < dbname > " may be reported when executing DBCC CHECKTABLE. |
723847 | SELECT INTO and INSERT SELECTs that use UNION statements terminated by a UNION ALL statement may fail with a signal 11 and stack trace that includes the module tree*GcElement::GcGetVar(). This tends to happen if the table being inserted into contains any identity columns that are not explicitly generated in the UNION ALL query. |
723872 | If there is an UNIQUE index with IGNORE_DUP_KEY option on a partitioned table with many partitions such as 60, the BCP loading performance of OLD DATA may be much slower than that of NEW DATA. NEW DATA means most rows of it will be loaded into the table. OLD DATA means most rows of it will be ignored because they have been loaded into the table. |
724023 | The message "current process infected with 11" in the module 'bufreserve' together with a stack trace which includes the modules 'drop_al_dbid' and 'alterdb' may be reported in the error log when an ALTER DATABASE LOG OFF command is executed to shrink this database log space. |
724175 | The Remote Backup Server name is extended to allow the use of IPV6 hostnames with domain name. |
724343 | When configuring RepAgent to use a security mechanism, the RepAgent Thread may fail to start and report a 9210 error. Moreover, RepAgent is using the ASE server name instead of the ASE principal name. |
724472 | In rare circumstances, recreation of in-memory databases during start up of SAP ASE may hang when there are more than one in-memory databases with the same template database. SAP ASE can still be used, but an attempt to use the in-memory databases that are not recreated will result in an error 962, "Database with ID ' < value > ' is not available. Please try again later." being reported. |
724593 | In some rare cases, a UNION query could return wrong result resulting in truncation. |
724603 | When executing a JOIN involving a proxy table, and the optimizer chooses GROUPINSERTING for the NESTED LOOP JOIN plan, the ordering information in the query is lost and the result is not ordered as expected. |
724815 | sp_config_dump stored procedure will now display usage information if invoked as sp_config_dump help or sp_config_dump 'help'. |
724843 | Signal 11 in OmniQuickPass::targetlist()could occur for SQL statement with subquery when show_transformed_sql is on. |
724959 | When a database is loaded, the dump history file does not show any record for it and hence it is not possible to generate the dump sequence for this database. |
724990 | In 15.x, under the default isolation level (Level 1), DELETEs/UPDATEs involving JOINs and/or correlated SUBQUERY could cause more number of exclusive locks to be acquired even when the qualifying number of rows are much less. |
725065 | DBCC SERVERLIMITS displays a wrong value for the limit 'Max database device size'. |
725140 | In some rare cases, running queries involving SQLUDF could lead to stacktrace in cpysqludf(). |
725195 | The monThread MDA table should list all ASE threads, however, on Windows platforms, the ASE clock thread is not listed in this table. |
725209 | ASE on Windows may report "LAST CHANCE EXCEPTION HANDLER on OS thread id < threadID > ...A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED SERVER MAY NOT BE ABLE TO CONTINUE" with kcierrfmt() on the stack during shutdown when the server is forcefully shutdown, for example through CTRL-BREAK. |
725315 | The VERIFY option for the DUMP and LOAD commands does not give the user any indication of whether errors were found or not. The errors are currently reported only in the backupserver errorlog. |
725318 | The dataserver gets a segmentation violation when dropping a login while the dataserver configuration for 'number of open databases' is less than the actual number of databases defined in sysdatabases. The segmentation violation is followed by a 905 error, “Unable to allocate a DBTABLE descriptor to open database 'dbname'. Close or drop another database before opening this one, or ask your System Administrator to raise the configuration parameter 'number of open databases'” |
725376 | Hit error 806 when running shrink database and reorg defrag concurrently. |
725608 | When resource limits is activated and a maximum transaction elapsed time is set, in CHAINED mode, a transaction is not rolled back after the specified elapsed time limit is exceeded. |
725661 | The performance of the rollback of a skewed transaction, that is, a transaction that has bursts of activity separated by periods of inactivity, is unnecessarily slow. |
725667 | Miscellaneous enhancements to the performance of boot time, LOAD DATABASE and LOAD TRAN recovery including better performance in undoing long-running (incomplete) transactions i.e. those that have bursts of activity separated by periods of inactivity. |
725669 | New feature that reduces the amount of recovery time during LOAD DATABASE at the expense of increasing the time taken by DUMP DATABASE. Data that is changed while DUMP DATABASE is active is included in the dump so that the dump has more up-to-date contents. This is enabled using sp_configure 'optimize dump for faster load', < percentage > . Changed data is included in the database dump when the percentage of database data changed during DUMP DATABASE is more than < percentage > . This defaults to 0 in which no changed data is copied, and there is no reduction in the recovery time of LOAD DATABASE. |
725708 | The KILL WITH STATUSONLY command has been enhanced and now provides information on the amount of log space scanned and to be scanned for a full transaction rollback. It differentiates different types of rollbacks, and reports a subset of information in cases where the rollback is not a full transaction rollback. |
725767 | On big-endian platforms, queries involving BIGINT columns in MDA tables may return wrong results. |
725858 | A 15095 error, "An invalid 'data row id' value was found in first text page of a text/image/unitext column." may be reported when running DBCC CHECKTABLE or DBCC CHECKDB on replicated Data Only Locked tables that have TEXT columns with values on forwarded rows. |
725864 | Improve "ddlgen" performance for generating ddl for schema objects |
725872 | Print extra information for home location of DOL forwarded rows in DBCC PAGE output. |
725885 | srvbuildres cannot configure ASE when the available free space on the disk is very large. |
725956 | If a previous Job Scheduler configuration failed, syconfig.exe and sybatch.exe do not re-install the ASE-15_0/scripts/installjsdb script in a rerun. |
725998 | Running ins_syn_sql on a 2K page ASE may lead to the log segment being full. |
726158 | Under some rare conditions, a query using a NESTED LOOP JOIN in an OUTER JOIN may encounter a signal 11 followed by a stack trace that contains the module LeSarg::mapSarg(). |
726234 | A timeslice error followed by a stack trace that includes the module rvm_dispatch() may be reported when show switch or any server-wide statement is executed in stored procedures. |
726379 | KBA 2114463. A 11051 error, "ALTER TABLE ' < table_name > ' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.". |
726439 | Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur. |
726551 | DDLGen does not extract DDLs correctly when stored procedures are grouped. |
726760 | sp_helpsegment reports wrong used_cnt after shrink database. |
726763 | The command ALTER DATABASE LOG OFF can result in the error 5057 ("The free space counts for the log are incorrect ...") being raised if the database has been loaded from a database dump where the command ALTER DATABASE LOG ON was run initially to extend the log. |
726770 | In rare cases of extreme heavy loading, it is possible that BCP/SELECT INTO a big table might lose allocation page entries from the OAM. |
726776 | The message, "Current process infected with signal 11" followed by a stack trace that includes the module altdb__clear_chunk() may be reported when executing SHRINKDB concurrently with sp_placeobject. |
726933 | New feature request to avoid copying log pages to a transaction dump that are already included in a previous transaction dump in the dump sequence. This feature is enabled using trace flag 4226. |
726936 | When I/O fencing is enabled, the server may fail to correctly fence the devices and start up. Need environment variable SYBASE_MAX_MULTIPATHS to override number of paths iterated which should be set to 1 if PowerPath is enabled. |
726957 | The message "current process infected with 11" in the module 'ksct_startio' together with a stack trace which includes the modules 'ra_init_rs' and 'ra__connect_server' may be reported in the error log when the Rep Agent Thread attempts to open a new connection to the Replication Server and a previous connection attempt has failed. |
727073 | DDLGen does not generate DDLs of a logical key on VIEWs when using -TLK or -TV. |
727123 | Display Stat Wizard may fail with the error message, "Client password encryption fails". |
727134 | Reduce the use of MASTER..SYSDATABASES scans in order to avoid high SPINLOCK contention on "DEFAULT DATA CACHE" in some cases. |
727186 | ASE may report errors like "JS: failed to receive jsagent response" and "Job Scheduler Task lost its Agent connection". JS Agent terminates without any errors in the JS Agent log. If core dumps are enabled on the platform, a core file is generated from JS Agent that contains the function sybcsi_mem_free() on the stack. |
727277 | Auditinit may fail to add devices on space larger than 1 TB. |
727310 | The message "current process infected with 11" in the module 'th_curunreservedpgs' may be reported when a session executes a SELECT statement that uses the T-SQL function "curunreservedpgs" while another session is in the process of extending the size of the current database with ALTER DATABASE command. |
727475 | If the user is granted system roles indirectly through a user defined role, execution of sp_addthreshold fails with error message 10353 "You must have any of the following role(s) to execute this command/procedure: ' < names > ' . Please contact a user with the appropriate role for help." |
727484 | A 17260 error, "Can't run sp_dbextend from within a transaction" may be reported when sp_dbextend is invoked in CHAINED mode. |
727762 | Query with long IN list might cause stack corruption. |
727816 | sp_downgrade 'downgrade' will fail at step 990 with a 137 error, "Must declare variable '@show_'". |
727846 | The APFPercentage value in the monCachePool MDA table may report incorrect value. |
727884 | Downgrade to versions lower than 15.7 ESD#2 will not remove the predid column from sysprotects.csysprotects. sp_fixindex or dbcc reindex will not change the index to the pre 15.7 ESD#2 definition. |
727887 | Trace flag 364 support added for ASE 15.0 which uses the range density instead of the total density for optimizer costing when constant sarg values are unknown. Trace flag 16982 is created which uses the total density instead of the computed join histogram density. If trace flag 364 and 16982 are both set, then the sarg density will be used for the join. |
728027 | In rare cases, the TRANSFER TABLE command may skip exporting an updated row if a target table is a Datapage or Datarow Locked table and it has forwarded rows or may hang up if a target table is a Datapage or Datarow Locked table and it has forwarded rows and large I/O buffer pools are configured. |
728157 | Auditinit may a core dump if the "LANG" environment variable is not set correctly. |
728173 | When inserting data into a table containing LOB columns and ASE happens to run out of log space, the message "Space available in the log segment has fallen critically low in database < dbname > . All future modifications to this database will be aborted until the log is successfully dumped and space becomes available" followed by a stack trace that includes the module logmodify() may be reported in the error log. |
728364 | KBA 1857851. An 806 error, "Could not find virtual page for logical page < pagenum > in database < dbname > " may be reported when executing a stored procedure whose query plan is cached. |
728419 | DDLGen does not generate the partition name and segment information for a hash partitioned All Pages Locked table with a clustered index. Only the number of partitions are generated in the DDLGen output. |
728430 | Running UPDATE STATISTICS on an index containing non-materializing column may hit an error with a stack trace containing the modules stat_bld_row() and collocate(). |
728444 | A 2601 error, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", followed by an 11068 error, "Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.", may be reported in the error log during ASE startup in a Windows environment, if the configuration file has a 'Dump Configuration' section where the 'stripe directory' option is set to a value where backslash characters are specified. |
728497 | The message, "Current process infected with signal 11" followed by a stack trace that includes the module init__data_vs_strategy() may be reported when running REORG REBUILD following which a DROP TABLE is executed. |
728528 | Upgrade from 12.5.4 may fail at step 1564 with message 3606, "Arithmetic overflow occurred." |
728563 | In ASE 15.7 ESD#2 and above, under some circumstances, ASE may encounter signal 11 or timeslice error with a stack trace involving the module idt_remove_all_reservations() while cleaning up identity reservations assigned for specific object. |
728634 | A 17879 error, "Only users that have System Administrator (SA) authorization granted directly may add, or modify thresholds in that database" may be reported if a user that has been granted sa_role indirectly through a user defined role executes sp_addthreshold in a database where the user is not the actual owner. |
728667 | A stack trace may be encountered with sybcluster if other plugins are installed incorrectly in the same directory. |
728759 | When the number of statements in the Adaptive Server statement cache is large (approximately 13,000 or more) a query on monCachedStatement may terminate with error 3621, "Command has been aborted". |
728804 | A procedure having SELECT INTO a temp table having UNION ALL and encrypted columns could result in wrong data in the target table and a subsequent SELECT from the table will result in a 15417: "An internal error occurred during a decryption operation (error code < n > ). Please contact Sybase Technical Support." error. |
728845 | When attempting to migrate objects that may have storable comments such as PROCEDUREs, VIEWs, UDFs, PRE-COMPUTED RESULTSETs etc, if there are braces (curly brackets) within the comment section migration will fail with with a java.sql.SQLException. The same error will be observed if a curly brace appears anywhere in the proc DDL (search argument for example). |
728894 | ASE fails to install with Job Scheduler on roman8 charset. |
728903 | Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur and it could also lead to data corruption. |
728961 | Error 207 may occur while running the sp_dboption stored procedure if quoted_identifier is turned on. This may also affect the Sybase Control Center Database Properties dialog by preventing the database options from being viewed or modified within Sybase Control Center. |
728963 | Fixed spelling abbraviation error, mesc (millisecond) to proper abbreviation: sec. |
729022 | KBA 2013813. For some special table names, REORG REBUILD and ALTER TABLE fail with an infected with 11 error on IdentifierType::IdentifierType. |
729088 | ASE on Windows crashes due to system exception (0xc0000005) generated by a storage access violation with error message "attempted write to memory location 0000000000000000 from instruction at location 0x0000000000000000". This issue only affects ASE on the Windows platforms. |
729192 | Deadlock may occur when SHRINKDB runs concurrently with REORG DEFRAG. |
729204 | Data Only Locked tables with placement index undergoing ALTER TABLE MERGE PARTITION may lead to index corruption with 696 errors. |
729335 | ALTER TABLE MERGE PARTITION may fail with error 14108 on a empty range partitioned All Page Locked table with a clustered index. |
729373 | During the execution of DUMP DATABASE if the "compress::" option is used and only one stripe is specified, ASE 15.7 ESD#3, 15.7 ESD#3.1 and 15.7 ESD#4 will ignore the compression option prefix, resulting in an uncompressed dump. Additionally loading a valid pre-15.7 ESD#3 compressed single stripe dump will fail. |
729461 | Columns with more than 65535 unique values, which also have some skewed values (i.e. represented as frequency cells in the histogram) could result in inconsistent histograms in which weights are outside the range of 0.0 to 1.0 |
729509 | An 8201 error, "Keep count of descriptor was expected to be 1. Instead 0 was found" may be reported by the upgrade utility when upgrading from 12.5.4 |
729603 | In rare cases, after the last chance threshold is crossed and the user executes DUMP TRANSACTION to free up log space, the last chance bit DBTH_LASTCHANCE will remain set in memory in DBTABLE, which will continue to cause processes to be suspended by the last chance threshold mistakenly. |
729624 | Cluster deadlock occurs when process allocating a new page holding LLOL waits on WAIT_FOR_BASTPENDING. This issue only affects ASE Cluster Edition. |
729766 | A new configuration value of '2' is added to configuration option 'enable xml' for external entity reference in XML documents, ie, set "sp_configure 'enable xml', 2" for external entity reference in XML documents. |
729795 | The incorrect message "The dump configuration ' < value > ' supplied for SELECT is invalid. The change is completed. The option is dynamic and ASE need not be rebooted for the change to take effect." may be reported by sp_config_dump with an option that is longer than the supported length. |
729919 | In very rare situations where incorrect port number is specified for sp_listener, subsequent calls to sp_listener might fail. |
729937 | Enhancement is made to reduce the use of MASTER..SYSDATABASES scan for better performance when accessing tables in other databases. |
729957 | A 2626 error, "Illegal attempt to insert duplicate key row in the clustered index partition database < dbname > , object < objname > , index < idxname > , partition < ptnname > " followed by a stack trace involving the module indinsert() may be reported when inserting and deleting duplicate key rows in the clustered index partition for All Pages Locked table numerous times. |
729984 | getpass.exe which is utilized in Web Services on Windows only, is currently not compatible with x64 platforms. This issue only affects ASE on the Windows 64 platform. |
730051 | When REORG REBUILD WITH ONLINE is running in parallel with DMLs, DMLs may fail with a 540 error - "Schema for database object ' < name > ' has changed since compilation of this query. Please re-execute query.". |
730082 | DBCC REINDEX has been enhanced to provide a new option (option value: 32) to drop suspect replication indexes only. The syntax is DBCC REINDEX (tab_name | tabid , 32) |
730154 | Increase the number of expressions allowed in an ORDER BY clause. |
730183 | Extended stored procedures added using sp_addextendedproc are malformed leading to failure of the extended stored procedure. sp_helpextendedproc shows an extraneous '[' character in the DLL name. |
730215 | KBA 2013030. The message, "Current process infected with signal 11" followed by a stack trace that includes the modules d_deleteplan() and proc_plan_get() may be reported in the SAP ASE errorlog when executing DBCC DELETEPLAN. |
730276 | The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3. The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE. |
730280 | 12308 error with delete or update against table in a query with distinctness e.g. joining to a distinct view or distinct derived table, and exists subquery, a union view or union in a derived table. changes associated with optcriteria cr669847 are enabled by default, but previous behavior (i.e. turn on fix only if optcriteria cr669847 is on) can be obtained by using trace flag 16987 |
730281 | The sense of Trace Flag 7773 has been inverted. Use of Trace Flag 7773 now disables the fix for CR 653511, which is on by default, ie, if a stored procedure undergoes recompilation, and the procedure makes assumptions regarding the session's state (ie session environment settings), the resulting recompiled plan can be significantly different than the original. This fix is now disabled when Trace Flag 7773 is on. |
730354 | sp_sysmon can return incorrect CPU metrics. |
730503 | An update of a view that has an INSTEAD OF trigger can cause an infected with signal 11 stacktrace in function copy_one_resdom() if the update assigns values to local variables. |
730608 | ASE might report the 225 error that some query--referenced object cannot be dropped during query optimization in sp_sysmon_kernel_threaded when running sp_sysmon in parallel. |
730656 | Cache bindings may be ignored if a 'strict' database recovery order is specified. |
730673 | The PCI Memory management layer is enhanced to better service memory allocation requests for ASE tasks executing JAVA operations. The layer now makes a better decision from where to allocate the requested memory. It either uses the PCI Fragment memory pool for end-user coded objects, or the O/S system run-time for JavaVM internal operations. |
730787 | CREATE LOGIN does not check if the login name already exists before calling sp_extrapwdchecks. This can cause sp_extrapwdchecks to update information stored for the existing login. |
730807 | While using the partition_name builtin on multiple objects, the active objects could be recycled resulting in an information message, "Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation" being printed in the ASE errorlog. |
730831 | sybcluster: create cluster complain release not exist when just no permission |
730906 | Isolation level 0 queries occasionally fail with errors when REORG REBUILD WITH ONLINE is in progress concurrently on the same table. |
730953 | The global variable @@tranchained shows inconsistent value when "SET CHAINED ON" is executed in the login trigger. |
730962 | When running installhasvss, an error message indicating that it has 'failed to locate the sybsecuritydb' is hit. |
730982 | When downgrading from 15.7 SP100 to a lower version, a 943 error will be raised when booting the server with the lower version and a stack trace will be encountered when running installmaster. |
731023 | Relax restriction when we raise the message 3193 in relation to ALTER DATABASE OFF at LOAD TRANSACTION time, by delaying the generation of holes in a load sequence to ONLINE DATABASE time. |
731026 | Certain stored procedures created with "execute as caller" may encounter errors at execution time. |
731065 | KBA 2113967. DUMP DATABASE is getting a inappropriate warning message about DUMP TRAN with truncate_only |
731079 | The number of unreserved pages may be incorrect after LOAD DATABASE has been executed if the database dump is from an older ASE version and it contains a large number of tables, each having multiple partitions. |
731171 | An arithmetic overflow error may be reported by the function sp_f_getval when sp_spaceused is executed against large tables. |
731179 | The recovery redo pass unnecessarily attempts to fix problems with deallocations and reservations for some committed transactions in cases where there was a long-running transaction at the time of the last checkpoint. |
731354 | A signal 11 occurs in the function collectMonCSInfo when a query is executed on the monCachedStatement MDA table and the statement cache contains a statement that was created with a user-defined optimization goal. |
731372 | On tables with indexes, heavy insert activities can lead to 1295 errors, "Unconditional lock request for table or page was made while holding a latch". |
731437 | DUMP DATABASE with verify[=header | full] options and LOAD DATABASE with verify[only][=header | full] options commands have been enhanced to detect a mismatch between the page header and tail timestamps for Data Only Locked tables. |
731468 | sp_versioncrack returns NULL as ESD, with new ASE version strings. |
731531 | Enhancement is made to use less SYSTYPES scans when creating table. |
731617 | KBA 1827181. When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file ‘backup_tape.cfg’ exists, ASE will not be able to read it and the dump will fail. The Backup Server will report the error, "The format of the device configuration file < $SYBASE > /backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0". |
731718 | When a character set conversion is required for very long string input ( > 255 character), for example converting client Windows code page 1252 to a server using code page 850, if the input string had a character unconvertible to the server character set, the connection would be inappropriately killed (with a stack trace), in addition to the issuance of the server conversion error message. |
731753 | If ALTER TABLE is used to add a NOT MATERIALIZED column < c2 > with a default, then another nullable column < c3 > is added to the table and REORG REBUILD the table, a query to the table will also assign the default to the column < c3 > . |
731758 | When executing UPDATE STATISTICS with an object name that contains unusual characters, the command may fail with an internal error. |
731769 | In case of an exception, SAP ASE hits an error 1265 while aborting / rolling back the transaction. Abort or rollback of the transaction may happen because of some internal / external error. Error: 1265, Severity: 20, State: 1 An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family. |
731783 | The message, "An internal memory management error has occurred. Error code: Invalid slot id.", followed by a stack trace involving the modules mda_exec() and mda_populate_monTask() may be reported when querying table monTask with clause KTID=0. |
731808 | If a LIKE predicate is used, then optimizer estimates for keys for a limiting index scan may be incorrect if a VARCHAR variable is used for the pattern match. This is especially true when there are no pattern matching characters used e.g. r.a LIKE "ABC". optcriteria CR731808 can be used to correct the optimizer estimate issue. Command line trace flag 16965 will also enable the fix. |
731818 | The Backup Server is enhanced to perform consistency checks on All Pages Locked (APL) and Data Only Locked (DOL) data pages during DUMP DATABASE execution. If an error is detected on a page, the page is reread for validation. These checks will be performed if DUMP DATABASE is executed using WITH VERIFY option. Alternatively, start up the backup server with boot time trace flag -D64, or use the run time trace flag SYB_BACKUP...qatraceon 8, to enable these checks by default. |
731874 | A 15432 error, "A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password" is raised when a user with login association of a key executes a stored procedure that accesses a column that is encrypted with the key. |
732064 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module ptn_get_aphintpage() may be reported when executing a CREATE INDEX or REORG REBUILD command. |
732185 | An ALTER TABLE command issued on a partitioned table where the partition degree is greater than the user's parallel degree may result in various failures. |
732258 | DBCC UPGRADE_OBJECT with the "check" option may raise bogus 11031 (Execution of < type > < name > failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate < name > ) errors on every object checked after it encounters an object with an actual error. |
732329 | Under some rare conditions, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table" may be reported if auto_temptable_stats is turned on. |
732385 | The message, "Current process infected with signal 11" followed by a stack trace that includes the module VTABRemoteAccess() may be raised when accessing a proxy table materialized at procedure whose name starts with a '$'. |
732393 | An 804 error, "Unable to find buffer < buffer address > from cache < cache name > holding logical page < page number > in sdes < sdes address > kept buffer pool for object < table name > ", may be reported when inserting data into TEXT/IMAGE/UNITEXT columns. |
732406 | sybmigrate does not preserve indexes in the indexid order. |
732410 | In rare cases, dataserver can hang due to this deadlock situation: one session sleeps on grabbing DES while updating statistic in rollback a DELETE; the other session sleeps on writing dirty buffers when scavenging a DES. |
732482 | A query against a remote table may get a signal 11 during UPDATE STATISTICS. |
732503 | The message "current process infected with 11 (SIGSEGV)" in the module 'des__clean' together with a stack trace which includes the modules 'des_refreshall' and 'online_database' may be reported in the SAP ASE error log when multiple sessions are executing the ONLINE DATABASE command simultaneously for the same database. This will result in SAP ASE shutting down implicitly. |
732588 | Under certain circumstances when a threshold action is defined, and user is dropping a procedure, and the procedure happens to be the last row of the sysprocedures page, an 873 error may be reported when log space is low, and the threshold proc gets spawned. |
732604 | The summary stats for histogram (i.e. unique count, density) generated by hash based statistics gathering may be inaccurate. This could occur when OPTDIAG labels a histogram as "high domain". |
732613 | The Job Scheduler fails to start if quoted_identifier property is set for the connection (which is used to start the Job Scheduler). The following error is logged in the SAP ASE errorlog: "Job Scheduler: IS_ISQL_EXT failed [set nocount on use sybmgmtdb print ":s: %1!", "sybmgmtdb"]" |
732631 | REORG REBUILD < table_name > WITH ONLINE command, does not update the index create time-stamp(index_created field in sp_helpindex output) for the indexes rebuilt. |
732640 | Schema lock displayed as GUID lock in sp_lock output |
732693 | ALTER TABLE < TABLENAME > SPLIT PARTITION may fail with errors such as 2601 (Attempt to insert duplicate key row in object < name > with unique index < name > ) when there is a non-clustered index. |
732728 | The unreserved space stored in the table sysusages can become a huge number bigger than the fragment itself if the number of allocated pages indicated in the OAM pages for some objects becomes corrupted and show pages allocated that are not. |
732777 | Under some circumstances, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table." may be reported while a temporray is being dropped. Such temporary table is found to have a dlevel0cnt = 12. |
732921 | A 8201 error, "Keep count of descriptor (objid=14, dbid= < value > ) was expected to be 1. Instead 0 was found" followed by a stack trace that includes the module 'des__unkeep' may be raised if ASE fails to allocate space for either SYSGAMS or SYSDAMS. |
732995 | Sometimes Procedure Cache ELC (Engine Local Cache) for some of the engines does not get configured during engine boot, which leads to Procedure cache ELC not getting used on the engine and thus leads to contention on the rproccache_spin spinlock. This condition can be detected using the ASE errorlog. If an engine is brought online but does not have the message "Proc header memory allocated < nn > pages for engine < engine_id > local cache" for that engine then the Procedure Cache ELC is not properly configured for that engine. |
733051 | If the number of system roles of target server is more than source server's, after running symigrate -m migrate, sybmigrate will drop from sysusers those roles that are 'new' in the target server. This issue can specially be seen when users are migrating from ASE 12.5.4 to ASE 15.7.x |
733146 | In rare cases, the message "Invalid column length" may be reported in the ASE errorlog to indicate there are issues in the index creation when creating an index on a Page Compressed table. |
733194 | Incorrect disk activity may be reported by sp_sysmon_diskio when there is no disk I/O in given sample period on this device. |
733215 | After upgrading, the value of systabstats.rowcnt for the syspartitions and sysobjects tables will be 1 less than the actual number of rows in these two system tables. |
733226 | If a parallel plan's thread count exceeds the session's parallel degree, then the plan will undergo Compile time Thread Adjustment (CTA). If the plan contains a semantic scan under a semantic dependent operator (JOIN, DISTINCT, GROUP, or UNION_DISTINCT), then the semantic dependent operator's plan fragment (from its containing xchg op) may have it's degree adjusted incorrectly which could result in wrong results. |
733305 | KBA 1864300. An ASE spid with remote I/O may hang when killed. Even reissuing the kill does not help. |
733331 | Error message 1509 may be raised when CREATE INDEX or UPDATE STATISTIC is executed in parallel on huge table where there are very few distinct COLUMNS values. |
733346 | The stored procedure sp_dropexternlogin will fail when executed by a user that has SSO_ROLE and not SA_ROLE when granular permissions is not enabled. |
733367 | Provide downgrade support from 15.7 SP110 to SP100 to prevent loading database or transaction dumps containing transactional activity from INSERT-BULK with parallel index updates work load. Extend db_attr(), and loginfo() built-ins to examine database feature-set. Extend LOAD ... WITH HEADERONLY to report the features found in the dumps. |
733428 | The "recovery prefetch size" configuration parameter is added to configure the lookahead size (in terms of log pages) in order for recovery to prefetch to-be-recovered pages. When set to 0, SAP ASE will automatically optimize the value. |
733446 | In DDLGen 15.7 ESD#3 and later, 'set quoted_identifier on' is reported in the DDL output even when it is not specified in the actual create table SQL. |
733462 | A timeslice error may occur followed by a stack trace involving the module itl_au_update_xfer_mark() with executing BCP-IN or update DMLs, if 'transfer table' is set on a large table with data more than 47GB on 2KB page size (95GB on 4KB pagesize, 190GB on 8KB pagesize, 380GB on 16KB pagesize). |
733579 | The unreserved page count might be off by the number of pages of the table SYSDAMS if SAP ASE uses the OAM pages to calculate the free space counts. The database fragments containing pages of the system table SYSDAMS will show the space used by this table as free. |
733604 | Add the ability to suppress warning message regarding the ignoring of hints under the presence of abstract plans. This is enabled under Trace Flag 15381. |
733623 | ASE allows configuration parameter 'max online engines' to be set to a value lower than 'number of engines at startup' leading to an incorrect value for the parameter 'max online Q engines'. This can result in incorrect calculations for the 'maximum number of engines' resulting in ASE hitting a SIGSEGV followed by a stack trace involving the module ueisonline(). |
733750 | Timeslices may occur with statistics gathering using hashing. |
733752 | The estimate for NULLs in the optimizer may be incorrect if hash based statistics gathering is used, when the number of unique values in the column is greater than 65535. |
733766 | The severity of error message 5805 and 5806 is now changed from EX_USER to EX_INFO since they are just warnings. |
733776 | After an upgrade, execution of a procedure may fail with error 102 "incorrect syntax near [ endend | grantgrant ]" and error 11031 due to the source code being stored incorrectly in syscomments when it contains multiple GRANT statements. Manually correct the source code, then drop and re-create the procedure. |
733838 | ASE no longer rejects requests to add remote logins with same server name as local server. |
733893 | Device Props does not display databases that are using a device on little-endian machines. On big-endian machines, unintended databases may get displayed. |
733904 | Active roles being reset leading to permission errors. |
733907 | The error 822 "Could not start I/O for request.." followed by a stack trace that includes the module altdb_shrinklog() could be raised in a Cluster Edition server if a fragment of the database log is shurnk using the command ALTER DATABASE LOG OFF and the device where this fragment was is dropped. |
733932 | KBA 1914594. When a user with sso_role runs a query accessing a table, a 2736 error, "Owner name that was specified is a group name. Objects cannot be owned by groups" may occur followed by a 706 error, "Process < n > tried to remove PROC_HDR < addr > that it does not hold in Pss", during recompiling a light-weight procedure if statement cache is enabled. The processed will be terminated. |
733937 | When using hash based statistics gathering on columns with more than 65535 unique values there is a possibility of inaccurate summary statistics of the range density and range unique counts as displayed in optdiag. This may lead to suboptimal query plan selection. |
734031 | Add open client version to monProcess under column ClientVersion |
734125 | The 695 error, "An attempt was made to read logical page ' < n > ' for database ' < dbname > '..." could be raised in an archive database when the database dump contains more than 256 contiguous log pages. |
734176 | If DBCC DBREBOOT is unsuccessful for some reason, the status in sysdatabases may sometimes incorrectly indicate that a forced shutdown is in progress, even after SAP ASE has been shutdown and rebooted successfully. |
734184 | In rare occasions, Adaptive Server's internal timer becomes non-operational. Such occurrence is reported to the errorlog with messages like “Warning: Alarm Service for Timer non-operational. If this message generated multiple times, report to support and restart the server (alarminterval=-7001)” |
734204 | When the configuration parameter 'max network peek depth' is configured to a positive value, ASE will look for an attention up to the specified depth in the pending input on a connection, and if one is found, all input preceding the attention packet as well as the attention packet itself are discarded, the currently executing command is canceled and an attention acknowledgement is sent to the client. When running with the default value 0 of the configuration parameter, ASE looks for an attention only at the start of pending input. |
734211 | DDLGen can generate an incorrect header message while generating ddl for a load profile. Instead of saying 'DDL for LoadProfile', it can say 'DDL for :user'. |
734212 | ASE hits SIGNAL 11 (SIGSEGV) when it runs out of spinlocks under heavy CT-Lib calls if 'max cis remote connections' configuration value is DEFAULT (which is 0). Setting 'max cis remote connections' to appropriate value is suggested to avoid reserving high number of spinlocks (upto four times 'number of user connections'). |
734214 | Command line trace flag 16964 is added to turn off the row constructor optimization for range predicates. This optimization may cause an underestimate of the limiting selectivity of an index scan when a range predicate exists on an indexed column followed by limiting predicates on subsequent columns. For example, if an index I(a,b,c) has predicates a > 5 and b=10 and c > 20 then the range predicate on “a” is followed by minor attributes “b” and “c” which also have limiting predicates... then the scan selectivity on the index "I" may be underestimated. |
734394 | When ASE Server is not in single user mode during sp_downgrade 'prepare', report a warning message to indicate it instead of stopping the validation. |
734395 | When dropping an encryption key, the 15401 message is reported with malformed values in the message. |
734470 | When SAP ASE is booted with trace flag 7437 it will not switch from an OAM scan to an allocation page scan when an incorrect page count value in one or more OAM entries is found during boot time recovery and while calculating the free space page counts for a database. |
734475 | The LogicalReads value in the monProcessActivity and monProcessStatement MDA tables remained unchanged when a long query is executing. |
734500 | The index page scanning selectivity estimate may be too optimistic for an index, in which a prefix of 0 or more positioning equality predicates (such as r.a = 1 and r.b = 2) is followed by a positioning range predicate such as (r.c > 5) is following by subsequent trailing positioning predicates (such as r.d = 10 and r.e > = 20). The change enabled by the new optcriteria limit_row_constructor will limit the index page scan reduction by at most 50% (in our example it will limit reductions contributed by r.d, r.e). |
734617 | Adaptive Server 15.7 may execute SELECT queries at isolation level 3 on Data Only Locked scheme tables slower than SAP ASE 15.0.3 or 15.5 if the session executing the SELECT query holds a large number of locks. |
734660 | The error "Page Verification Error: Page mismatch. Page < page # > contains 0 in page header." could be incorrectly printed in the Backup Server errorlog when executing DUMP DATABASE WITH VERIFY. This error is spurious and can be ignored. |
734702 | For objects with no storage, error 691 may be reported while running a CREATE INDEX command if either a dump is in progress or an incremental dump is in progress. |
734705 | After running sp_reptostandby/sp_setreptable/sp_setrepcol with "use_index" option on compressed in-row LOB columns, dbcc checktable() may report various kinds of index errors. |
734716 | At times the systabstats empty page count column may get values near to 2^32 (~4294967295) if inserts into a table are rolled back. |
734750 | srvbuildres optimization fails when specifying '16K' as the logical page size in the resource file for the Adaptive Server. |
734800 | Backup Server may occasionally report a spurious error when executing a DUMP or LOAD WITH VERIFY[ONLY], as a result of checking a page that is already deallocated. This is more likely to happen when the deallocated page belonged to compressed table. |
734866 | The builtin asehostname() is now made a grantable builtin. |
734897 | On a High Availability (HA) System, sp_companion may hang if sp_sysmon is running at the same time. |
734899 | A 692 error, "Uninitialized logical page < pageno > was read while accessing database ...", may be reported after loading an in-memory database dump from a database where this page was used but was marked as deallocated incorrectly, resulting in this page not being archived in the dump. |
734968 | Sometimes queries that involve multiple DERIVED TABLEs or VIEWs may return wrong results. The kind of queries that could be affected by this needs the following elements: (1) A DERIVED TABLE with a correlated expression SUBQUERY as one of the DERIVED TABLE’s SELECT list items. (2) Another correlated SUBQUERY in the parent query block which is referencing the expression SUBQUERY result from 1) as the correlated column. (3) Both 1) and 2) are under an IN SUBQUERY of the top query block. 1) and 2) lead ASE query tree to use a worktable for the DERIVED TABLE and 3) puts an EXISTS requirement over a table used by the DERIVED TABLE. The combination causes ASE to miss the EXISTS requirement on the table when generating a plan and leads to duplicate rows. |
734983 | Added new option SET PLAN SHARED ON and server wide param 'abstract plan sharing'. It enables Abstract Plan sharing between different users. Tables in the query with shared abstract plan must be explicitly prefixed with the owner name or belong to the DBO user. |
735003 | The built-ins or stored procedures that rely on OAM for space accounting get blocked on an exclusive table lock on the table. |
735029 | When the source server is 15.7 ESD#2 or later, sybmigrate -m migrate session may fail with the error, "The catalog 'sysusers' in the target database appears to contain rows which were either installed by the user or were previously migrated. Cannot proceed with migration of 'Users'". |
735036 | KBA 2011833. When running concurrent SELECT commands and DELETE/UPDATE commands on TEXT/IMAGE/UNITEXT columns, the client connection may hang or report a TDS token error or raise error 7128 state 6. |
735107 | A 247 (arithmetic overflow) error may be reported when the syscachepoolinfo and syscacheinfo MDA tables are queried. |
735163 | Adaptive Server Enterprise may crash and generate a core dump without any stack trace or messsage while multiple sessions run sp_companion simultaneously in threaded kernel mode. |
735187 | A 2583 error, "Number of data pages < value > counted by DBCC differs from count in the data OAM < pageid > for dbid < dbid > object < objectid > ." may be reported when running DBCC CHECKTABLE on a table having a clustered index or placement index after the database that the table resides on experienced a load tran of ASE 15.5 or earlier to a server of ASE 15.7 or after. |
735256 | Sometimes an insert query with union view or derived table with union in which tables have check constraint, could cause a signal 11 (SIGSEGV) and a stacktrace in errorlog involving the function NormalizeScalar(). |
735270 | For query SELECTing multiple count aggregates, wrong result could happen when the final plan uses two phase aggregates. One of the count aggregates could come from an AVG(). It is more likely to happen when the two phase aggregate plan is also a parallel plan, or when the query is also a GROUPBY query with a HAVING clause equal-comparing two of the count aggregates. |
735292 | An ASE task making a remote procedure call to a server with server option 'net password encryption' set to true and 'cis_rpc_handling' disabled can go to sleep indefinitely and the client appears to be hung. |
735311 | syconfig.exe fails to optimize the server. |
735327 | A 692 error, "Uninitialized logical page '24' was read while accessing object '2' in database ' < dbid > '. Please contact Sybase Technical Support." may be reported when a 12.5.4 ASE database dump that was made with a 15.7 ESD#4.2 Backup Server is loaded back in a 12.5.4 ASE. |
735346 | ALTER TABLE on a data compressed table may lead to heap memory (CPINFO pool) corruption. ASE stacktraces may be seen involving the functions kbfalloc() and cpinfo_allocbufs(). |
735431 | The error, "Table Corrupt: The row number and offset of each row in the page should have a matching entry in row number table ..." will be incorrectly reported in the Backup Server error log on pages with deleted rows that belong to an All Pages Locked table when executing DUMP/LOAD WITH VERIFY. |
735513 | System table sysusers is accessed too often during procedure execution. |
735516 | Need a mechanism to change the size of Engine Local Cache (ELC). By default ELC is 50 % of configured procedure cache size. |
735567 | The Backup Server is enhanced to perform consistency checks on Data Only Locked (DOL) index pages besides data pages during DUMP DATABASE execution. |
735662 | In rare scenarios, highly contended system with large number of databases, workload consisting of large number of short dmls, rdbts_spin could be highly contended. |
735692 | The function row_count() when used on system tables returns zero after upgrade from SAP ASE 12.5.4 |
735705 | If a procedure get recompiled during execution, query against monProcessProcedures may get duplicate procedure entries. |
735727 | When updating an in-row LOB datum to NULL, the LTL generated for the update of the datum wrongly includes the LTL qualifier 'tpinit' instead of the qualifier 'zerolen'. This does not cause data corruption, or interruption of replication. Nevertheless, according to the LTL specification, the qualifier 'zerolen' must be used. |
735812 | The unreserved space reported by either the stored procedure sp_helpdb or the builtin curunreservedpgs() could be wrong after executing any of the stored procedures sp_addsegment, sp_extendsegment or sp_dropsegment. |
735863 | When running optimization goal allrows_dss it is possible that an incorrect aggregate result may be returned in rare circumstances involving a derived table or view containing a union all with the aggregate operating on a constant in the select list on at least one side of the union all. |
735868 | In rare case, SELECT on a DOL table with index may cause ASE to shut down with a timeslice error and followed by a stack trace that includes the modules bt__handle_LAdone(), bt__qualpage(), bt__scan_massoffset() and bufoffset(). |
735879 | The backupserver sample resource file is missing ASE login and password attributes for sybatch.exe |
736017 | A 7949 error, "The number of pages used and unused for object < objid > index 255 partition < ptnid > on allocation page < alloc_page_no > do not match the counts in the OAM entry." followed by error 7940, "The counts in the OAM are incorrect. This implies that there are entries missing. Run tablealloc utility with the FIX option on the table with the inaccurate OAM counts." may be reported by DBCC TEXTALLOC and FULL option after inserting data with BCP into a table that has LOB columns and the option 'lob_compression' is enabled in the target database. |
736019 | When using hash based statistics collection and over 65535 unique values exist in the column then it is possible that the summary statistics (such as density) may be slightly inaccurate. If one looks at the optdiag output for the column and determines that a range cell is used for the first cell even though only one domain value can fit into the cell, then it is possible for summary statistics inaccuracies. It is possible, but unlikely, that query plans could be adversely affected. |
736079 | A cheaper plan containing the merge_union_all operator may be skipped in favor of a more expensive plan using a sort operator on top of an append_union_all. |
736093 | In rare cases in a cluster environment with more than one node, ONLINE DATABASE may hang if the log segment free space falls below a threshold. |
736179 | A 3261 error, "You cannot load this dump because it contains functionality that is available only on the server on which it was dumped" will be reported by LOAD DATABASE when trying to load a database dump which was taken while the database option "deallocate first text page" was active, or at least one table in this database had the attribute "dealloc_first_txtpg" set to 2. |
736268 | A login account that has a login-specific password expiration setting may have the global password expiration setting applied to it if the server encounters a 1204 (out of locks) error during the login attempt. |
736426 | The Java Compile Suite layer in Adaptive Server that is responsible for UDF/ADT support and SQLJ queries execution towards the target JavaVM has been enhanced to allow the release of intermediate allocated Java objects. This was causing the JavaVM heap memory allocation to be exhausted under a heavy load application environment. |
736428 | The message, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = 1, Current count = 0" is wrongly reported in chain mode. |
736435 | In rare circumstances, dropping a connection upon the CIS idle timeout may result in concurrent execution of Ct-library calls which may result in undesirable behavior. |
736499 | Linux client failed to redirect connections to Windows Server. |
736536 | sp_dbextend does not observe default device growby limits. |
736538 | sp_sysmon gives wrong average values for 'Engine Busy Utilization' in process kernel mode. |
736550 | Under rare circumstances a 696 error: "An attempt was made to read logical page ' < page# > ' for database ' < dbname > ' ( < dbid > ), object ' < tablename > ' ... from disk. Wrong logical page ' < page# > ' was brought into cache 'default data cache'." may be reported in the error log for allocation pages after the execution of CREATE, ALTER or LOAD DATABASE commands in an ASE installation using a page size that is greater than 2K-bytes and when during their execution the message "No large buffers were available, so pages are being cleared by writing each page separately. Please be patient" is reported. Alternatively a 2529 error, "Table Corrupt: Attempted to get page < page# > , partition ID 99; got page < page# > , partition ID 99." may be reported by DBCC CHECKALLOC. |
736603 | In some rare cases, accessing a system table could result in 8201 error being raised. |
736622 | When running REORG REBUILD against a table whose name or any column name might form part of a reserved double or triple keyword phrase it is possible for an error 156 error to be reported along with error 11934 and for the REORG REBUILD command to abort. |
736626 | KBA 2015067. When ASE is configured with the 'process' kernel mode and with several engines, the RepAgent Thread may be infected with signal 11 in the module 'uctSetIssuedCnt' while shutting down with a stack trace reported in the error log which includes the modules 'usctclose' and 'ra_drop_csconn'. |
736645 | After downgrading from ASE 15.7 to ASE 15.5GA, when booting the ASE 15.5GA server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options. |
736699 | If there are significant concurrent activities which pin buffer cache pages in the named tempdb cache (or default data cache) then it is possible that the server could appear to hang due to lack of buffer cache. The kind of activity that could lead to this state is "hash based statistics gathering", "sorts", "query plans using hash operators". |
736754 | The error 2550, "Missing segment in sysusages segmap", will be unnecessarily reported by DBCC CHECKCATALOG if a database has a fragment with a segmap equal to 0. |
736888 | In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log" may happen while loading a transaction log dump containing a rollback of a CREATE INDEX operation in database that has ddl_in_tran option on. |
736902 | Optdiag tool was running as a ctlib application of a lower version, so it misinterpreted (and wrongly displayed) BIGDATETIME and BIGTIME values reported for statistics. |
736951 | Improved the RAT Multiple Scanners code concurrency by removing the usage of un-needed locking primitives. |
736957 | In certain circumstances, databases, including system databases, can incorrectly get into LOG SUSPEND mode, issuing message: "Space available in the log segment has fallen critically low in database ' < dbname > '. All future modifications to this database will be suspended until the log is successfully dumped and space becomes available." This may happen even though there is much unreserved space in the database. The problem may also manifest in 3475 errors: "There is no space available in SYSLOGS to log a record for which space has been reserved in database < dbname > ." |
736978 | On High Availability (HA) System, accessing a proxy table may raise a 102 error (Incorrect syntax near '.') after failover occurs and the connection is migrated to the secondary companion ASE. |
737039 | A 941 error, "Illegal database context operation." may be repeatedly reported in the error log by the housekeeper wash task. An ASE reboot is the only option to stop this message from being reported. |
737093 | When a table is partitioned based on a list of values including the NULL value, the NULL value may be ignored when compared to NULL, leading to wrong results. |
737108 | Assertion fail in le_subst.cpp maybe raised when index only contains fixed-length columns. |
737292 | In some circumstances, monOpenObjectActivity may report ObjectCacheDate for the cached object as 'Jan 1 1900 12:00AM' or other wrong date value. |
737327 | Querying a DATE column from remote DB2 table may result in cs_convert overflow error. |
737338 | When the stored procedure sp_renamedb is executed from a read-only database, a wrong error message, "You cannot run stored procedure 'sp_renamedb' from a low durability database" is reported. The message should be "You cannot run stored procedure 'sp_renamedb' from a read-only database". |
737365 | DUMP DATABASE to TSM API on Windows platforms can fail with the error message, "D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=109, system message=Cannot get operating system error tex." Occasionally, the message, "system message =The pipe has been ended. Refer to your operating system documentation for further details." can also be reported. This issues only affects ASE on the Windows platforms. |
737481 | In rare cases, when updating CHAR, VARCHAR or IN-ROW-LOB columns on a PAGE compressed table and there are many non-printable characters in the existing column value, the update may fail. |
737524 | In rare circumstances, an 8201 error, "Keep count of descriptor (objid= < obj_id > , dbid= < db_id > ) was expected to be 1. Instead 2 was found" followed by a stack trace that includes the modules des__clean() and des__scavenge() when a system is running out of descriptors. |
737543 | KBA 1912577. Added a diagnostic check to help identify LRU chain issues. Trace flag 897 has been added to enable the diagnostics. |
737577 | The 3702 error,"Cannot drop the procedure 'sp_aux_getsize' because it is currently in use." will be raised if a user tries to drop the stored procedure sp_aux_getsize before the server has finished the recovery of every database. |
737628 | Intelligient index scan may lead to non-optimal index in plan selection. |
737697 | When running UPDATE INDEX STATISTICS with SAMPLING command, numerous errors may be reported in the errorlog - 1105 errors: "Can't allocate space for object 'temp worktable' in database 'tempdb' because 'system' 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" and 1764 errors: "Failed to insert row into worktable, when projecting base table on to work table for collecting statistics". |
737702 | Certain stored procedures created with "execute as caller" and using user defined datatypes may produce 2716 errors at execution time. |
737733 | The 12320 message, "Fatal internal error encountered when forwarding row < rowid > in table < tablename > , database < dbname > during update. Aborting the transaction" may be reported when updating a DOL row on a table defined as Page Compressed. |
737762 | Under rare circumstances backup server may produce unpredictable text attached to the dump trailer. |
737824 | The 18124 message, "No matching configuration options" may be reported when executing sp_configure "solaris async i/o mode" |
737837 | Shrinkpage() will raise a 631 error if the parent nonleaf page has only one nonleaf row that points to the shrinking page. |
737879 | When backup server is started with trace flag –D2048, the pages that have been allocated after the backup server built a list of pages to be archived and before the related allocation page is read by sybmultbuf, will be resent. Prior to dump a database one can run “SYB_BACKUP…qatraceon 105” that will add appropriate messages in the backup server error log when a resent has occurred. |
737907 | If the server crashes in the middle of SHRINKDB, the segmap number on sysusages table may not be updated to 0. |
737933 | Add option to Connect Dialog to connect to the last-used database (instead of the default database). |
738007 | In rare circumstances, the RepAgent thread may fail to terminate and hang in the module 'upsleepgeneric'. The execution for DBCC STACKTRACE( < RepAgent_spid > ) would indicate the RepAgent sleeping in the modules 'usctcancel' and 'ksctsuspend'. |
738033 | When auditing option to remove java classes is turned 'on', sp_audit stored procedure returns with a message that the option is 'off'. |
738117 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module ssql_release() or ssql_choose_victims() may be reported in the SAP ASE error log when the statement cache is full in a high concurrency SAP ASE environment. |
738189 | Load dump with list_only=create_sql sometimes fails. A Unrecoverable I/O or volume error may be reported. |
738196 | A core dump facility is added to the sybmon configurable shared memory dump feature. This is supported only on Windows platforms. |
738218 | A 1209 error, "Internal Error in lock manager routine: Attempted lock upgrade from shared intent to shared table in parallel query thread is illegal", may be reported in the error log during a SELECT or SELECT-INTO query on a table with parallel plan if there are concurrent DMLs or utilities operating on the table. |
738309 | In rare circumstances, the task will hang when LIKE clause or patindex(builtin) operator on the columns which contain the LOB data defined as compressed. |
738319 | After multiple HADR failovers, new client connections to a server in the HADR group may fail with error message "Read from the server has timed out" or "There is a tds login error". |
738322 | Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature (NB, CR 749101 also needed if the network interface has more than one IP address). Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. |
738367 | Stored procedures using "execute as caller" with builtin functions may attempt to access objects that do not belong to the caller (but do belong to the procedure owner). |
738403 | The show_cached_plan_in_xml() function reports incorrect timings on the AIX platform. |
738412 | KBA 2114731. Increase query table limit from 50 to 255 tables. |
738537 | When LOAD DATABASE < dbname > WITH LISTONLY=LOAD_SQL is executed, incorrect output may be generated if the database was dumped using a dump configuration with an external API. As an example "LOAD DATABASE test FROM 'C:\Windows\system32\syb_tsm::test.DB.20130429.171214.000'" may be reported instead of "LOAD DATABASE test FROM 'syb_tsm::test.DB.20130429.171214.000'". |
738538 | "shutdown with nowait" may fail to shutdown the server followed by SIGSEGV stacktrace with modules ktMuxThreadGetSchedQ(), ktMuxThreadTick(), utpApplyAll(), utpmApplyAll(), kaclkintr_thread() on the stack. |
738552 | If a table has small compressible off-row LOB columns that are not compressed due to size or other factors, ASE RepAgent may send an incorrect text length to Replication Server causing the Replication Server to stop replicating. |
738633 | RepAgent may run out of memory and shutdown if started and stopped a large number of times. |
738655 | Inappropriate right truncation error is raised when long BINARY values at or near the full width of a long column are inserted via dynamic SQL prepared statement. |
738675 | Database device remapping is disabled when a database is loaded with VERIFY. |
738692 | When a query involves multiple subqueries under, and the final plan places the subquery JOIN operator at the top of the plan, then there a much better plan that may be skipped. Optcriteria cr738692 will turn on the fix. |
738710 | A Fault Type Error 100008, "Fixed format error", may be reported by DBCC CHECKSTORAGE if DBCC CHECKDB or DBCC CHECKTABLE is run on a database/table which contains variable length columns previously. |
738731 | An 806 error, "Could not find virtual page for logical page < page_id > in database < db_name > ", may be reported when executing DBCC CHECKTABLE/CHECKINDEX/CHECKDB/REINDEX after shrinking a database containing a table with suspect index. |
738744 | The message, "Error: sdt_getpage: Attempt to read page '0' but device < device_name > is not open. Exiting", is reported when a cumulative dump is used as a metadata file for sybdumptran. |
738758 | A CIS spid in a 'terminating' state might hang at times in the usctconnect() function as observed in the DBCC STACKTRACE(spid) output. |
738771 | Under rare circumstances, a 12313 error, "Internal error: Insert into page id < pageno > of index id < indid > of table 'sysobjects' (id= 1) in database ' < dbname > ' tried to replace undeleted RID ( < pageid > , < rownum > ) at slot < slotnum > and ridposn < ridposn > . Try dropping and recreating the index." may be reported while loading a transaction log dump after onlining the database with STANDBY_ACCESS mode. The fix provides trace flag 3170 to bypass this error. Please turn on trace flag 3170 and reload the dump sequence. |
738777 | ASE will now no longer cache INSERT VALUES statements that has LOB literals exceeding 16k size. |
738790 | Some user queries might cause segmentation fault with signal 11 when auditing and compatibility mode options are turned on. |
738792 | If an ODBC or JDBC client enables one or both of HADR_MAP and HADR_NOKILL capabilities, different message text for same error codes is seen in case of HADR errors. |
738952 | The message, "Current process infected with signal 11", followed by a stack trace that includes the modules s_compile() and s_recompile() when a stored procedure is renormalized and phdr_nondiskres is set for the proc_hdr. |
739014 | ASE Cluster Edition fails to boot when using EMC devices. A truss on AIX or Solaris will show repeated ioctl system calls. This issue only affects ASE Cluster Edition. |
739040 | In rare circumstances, for APL table with both clustered index and non-clustered indexes which are created on a shared disk cluster ASE server, INSERT task may not respond even if it is cancelled (by CTRL C) when run with concurrent INSERT tasks. Meanwhile, lots of 1205 error messages, "Your server command (family id < value > , process id < value > ) encountered a deadlock situation. Please re-run your command", will also be seen in the error log. |
739067 | ASE will fail to startup if I/O fencing is enabled on devices with virtual uplinks. This issue only affects ASE Cluster Edition. |
739074 | KBA 2109883. In some scenarios, a database in single user mode could be used by a user session that is not expected to be using the database. |
739077 | sp_showoptstats does not correctly display the derived statistics message. A derived statistics tag is now added to sp_showoptstats. < statParDer > true < /statParDer > will be displayed when histogram statistics are derived from underlying partition statistics. |
739079 | If any of the system databases is > 2GB, the Update Adaptive Server in the installer or $SYBASE/ASE-15_0/bin/updatease (%SYBASE%\ASE-15_0\bin\updatease.exe on Windows) utility will fail with "Arithmetic overflow occurred." error. |
739080 | The show_condensed_text built-in function returns a NULL value for queries in the statement cache when the 'enable literal autoparam' configuration parameter is enabled. |
739129 | For a share disk cluster database with tables having identity column, the Error 2601, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", may be encountered when executing DUMP DATABASE or REORG REBUILD TABLE if nodes leave and re-join the cluster. If the cluster is killed, the old identity values may also be generated. |
739222 | ASE may report a 12062 error that the operation stack has overflowed when "execution time monitoring" is on. |
739288 | The message, "Current process infected with signal 11" followed by a stack trace that includes the module ktMuxThreadGetSchedQ() may reported during shutdown and may not lead to a complete ASE shutdown. |
739299 | When the example stored procedure sp_extrapwdchecks from Adaptive Server documentation is created in master database to perform additional password checking and password history maintenance, a new row is incorrectly inserted into the password history table with a value of “null” for the column “name” when the password change is done by a different user with role sso_role or Granular Permission privilege manage any login. |
739315 | A non-privileged connection to primary with HADR_MAP capability enabled gets killed after primary is deactivated without any error message. |
739363 | An undetected deadlock may occur between DUMP DATABASE and other tasks trying to reserve space in syslogs. |
739469 | When a merge statement inserts a new record into a table with an identity column, the identity column will be populated with correct value but the global variable @@identity will remain unchanged. |
739477 | If HASH based statistics gathering is used during an UPDATE STATISTICS or a CREATE INDEX statement, then there may be a failure if the respective column contains the next to lowest value of the domain but not the lowest value of the domain. The statement may be aborted. e.g. if the column is an unsigned integer then 1 is the next to lowest value and if the column contains a 1 but not a 0, then the statement may be aborted. |
739497 | Inaccurate histograms can be created when the unique value count of the column exceeds 65535 unique values. |
739529 | ASE logs the message, "Expected object passed to utGetThid is not of type thread", repeatedly. |
739531 | DBCC HELP(PAGE) does not display the correct usage of the parameter 'logical'. |
739568 | The message, "Current process infected with 11", followed by a stack trace which includes the modules lwp_create() and freeprocs() may be reported in the error log when a cached statement is normalized which can lead to other ASE tasks to wait indefinitely on the statement cache pool semaphore acquisition. |
739572 | On Windows 2008 R2 platform, ASE HA may fail to create Sybase Companion Server. "sp_companion configure" fails with message "HA Config Error: Unable to write cluster resource properties for ASE server ' < name > ' (operating system error 183)." |
739578 | If a column has more than 65535 unique values then UPDATE STATISTICS or CREATE INDEX with HASH based statistics gathering may result in an out of order boundary value in the first few cells of the histogram. |
739611 | Add option to append results in text mode. |
739656 | Running REORG DEFRAG from the same session multiple times might eventually cause a 705 error, "There is no room for process < spid > to store PROC_HDR < address > in Pss. ASE is terminating this process". Also, every run of REORG DEFRAG throws a noisy warning, "WARNING: memory usage in procedure headers (n) does not match memory usage count in Pss (m) for server process id < spid > " |
739664 | Queries with OUTER JOIN and a reference to syscomments.text can get wrong results when "select on syscomments.text" is set to 0. |
739678 | Generating DDL for a table using DDLGen does not generate DDL for indexes which have been created with sorted_data option. |
739679 | Enable usage of subqueries in the SELECT with FOR UPDATE clause under global switch 7791. |
739710 | ASE running in process kernel mode (pre 15.7 or 15.7 and above process kernel mode) may encounter issues like Error 14130 when an engine is onlined after some licensed feature is enabled. |
739725 | sp_configure 'dump history filename' may return an incorrect filename on a Windows environment when a dump history filename has '\' characters specified and after an ASE restart. For example, dump history file 'D:\sybase\dumphist' would be returned as 'D:sybasedumphist' mistakenly. |
739735 | Hard fault 100007 (extent id error) may be reported by sp_dbcc_faultreport if DBCC CHECKSTORAGE is run with frequent DDL commands. |
739736 | A 12319 error, "Fatal internal error encountered during deferred dml on table < tabname > in database < dbname > . All rows that qualified during the first phase were not visited during second phase of dml" may be reported followed by a stack trace that includes the modules dol_def_update() and dodeferred() when running CREATE INDEX or REORG REBUILD with ONLINE option with concurrent DMLs on hot objects. |
739784 | If a table is altered and is present in an UNION query in a derived table which is further defined in a VIEW, it could lead to permission denied errors. |
739820 | Inaccurate overly optimistic cluster ratios could result when executing a parallel create index. This could lead to inaccurate index selection in the query plan. After the first UPDATE STATISTICS command on this new index, the cluster ratios will be corrected and plan selection should be more accurate. Optcriteria CR739820 enables the change to improve the accuracy of the cluster ratios during parallel create index |
739932 | The optimizer estimates involving columns defined as BIGDATETIME and BIGTIME types may be suboptimial. |
740018 | An incorrect negative value may be reported in the error message, "A system call has not responded for x seconds". |
740020 | Under rare circumstances on Windows NT 64-bit platform ASE may stop with no errors being reported while processing Web Services requests that involve the execution of Java code. |
740031 | If a high domain column (greater than 65535 unique values) has a histogram created by using the HASH based algorithm, then it is possible that an inconsistent histogram could be created if there are some skew values in the histogram. |
740079 | Log the full sql text of the string passed to execute immediate in the monSysSQLText table. This is only available when traceflag 8391 is enabled. |
740115 | "sp_hadr_admin status, 'anyvalue'" fails when executed on standby HADR server when quoted_identifier is on. |
740137 | The message, "Current process infected with signal 11" (SIGSEGV), followed by a stack trace that includes the module stu_get_next_active_hist_slot() may be reported in the SAP ASE error log when using HASH based statistics gathering and the column has more than 65535 unique values. |
740148 | If an object name (such as a table) contained a parenthesis (as could be possible when using quoted identifiers), any SQL text for a statement using that object name would not be stored in the statement cache. |
740221 | Under heavy network load, SAP ASE on the Windows platform may hang. |
740223 | Job Scheduler can fail to execute jobs for users with high SUIDs. |
740247 | Under some rare circumstances, a shrink-database operation can encounter errors that kill the processing thread but do not clean up the memory it was using. |
740262 | Full text not being audited for DML when option update/select/insert/delete is turned on. Parameter values are also not printed for local variables and dynamic prepare statements. |
740317 | UPDATE skip uncommitted insert row caused ABAP like below output unexpected error message. (pseudo code) UPDATE row if (no rows found) INSERT row if (duplicate key) UPDATE row if (no rows found) ERROR out (assumption this should not be possible) The new feature is enabled when the new configure option "donot skip uncommitted insert" is set as 1. |
740321 | ODATA provider uses JDBC connection string from a configuration file. End users may add their Jconnect parameters and values to this connection string. The connection string is manipulated by the odata producer to add certain required parameters for its correct operation before adding user supplied parameters to it. |
740364 | Sometimes a read for non-syslogs object on a stale syslogs page for a user tempdb may results in 692 error. |
740410 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module aud_getsdes() may be reported in the error log when opening cursors declared without user tables when auditing is turned on. |
740471 | The loginfo() built-in may return wrong values for parameters 'can_free_using_dump_tran', 'oldest_active_transaction_pct', 'stp_span_pct' for databases having mixed log and data segments. |
740479 | A 9633 error, "RepAgent( < dbid > ): Cannot authenticate Replication Server < RS_nname > to use multiple replication paths", may be reported when the RepAgent is configured for Multiple Paths Replication i.e. 'max number replication paths' is greater than 1 and 'multithread rep agent' is reset to false, preventing RepAgent from starting. This can be corrected by setting 'max number replication paths' to zero. |
740499 | When HADR feature is enabled in ASE, internally spawned user spid would get killed during deactivation of the Primary server. Also these spids will not be able to start a transaction on a Standby server. |
740512 | DELETEs or UPDATEs doing a table scan on a DOL table following an INSERT-BULK performed in a multi-statement transaction may sometimes not qualify all rows, and the DELETE / UPDATE may leave some qualifying rows unaffected. This is most likely to occur when the affected table is bound to a very small cache, usually of the minimum size. |
740529 | The format for the Object_status column output of "sp_help < tablename > " may have a missing comma. |
740568 | When MERGE JOIN is turned off, a SELECT query joining a local and proxy column with a search using an IN list will not return the correct result. Currently, traceflag 16976 provides the workaround to the problem. |
740576 | Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL table. |
740597 | When RepAgent terminates abnormally with an error while connecting to Replication Server, the connection is not closed and the associated session is still held on Replication Server mistakenly. |
740609 | In an HADR environment, the privileged connection (to the old primary) with info capabilities gets killed upon activation of the new primary server. |
740613 | LOAD TRANSACTION of a transaction dump involving the log records of materialization of an indexed table with 'deferred allocation' property may fail with the 3474 error, "During redo the page timestamp value is less than old timestamp from log. Page #=x, object id = y, page timestamp=z. Log old timestamp=a. Log record marker =(p, q)." |
740635 | In rare circumstances, when running TRUNCATE TABLE on a very large table, the table does not show up on monProcessObject. |
740711 | A 9284 error, "RepAgent( < dbid > ). Cannot allocate 9024 bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory." may be reported when LOB off-row data is replicated, resulting in the Rep Agent Thread for this database to be terminated abnormally. |
740730 | The 1514 error, "Sort failed because it attempted to allocate page < page > and found that the page was busy. Buffer < buffer > contains a cached and referenced page with ptnid < ptnid > indid < indid > and status < status > ", may be reported when executing a subquery plan and there is a StoreIndex(reformatting) operator under the subquery. |
740732 | If a database is configured to 'allow incremental dumps' updates to pages that happen when bringing the database online could be missing from the next incremental dump. |
740741 | Using DDLGen to extract CREATE DATABASE DDL fails when the database name is greater than 23 characters and the "-F" option is used. |
740746 | A new feature request to make ASE set 0 to segmap of sysusages if ASE finds segmap=0 in allocation pages of tempdb while rebuilding sysusages. |
740800 | In rare scenarios, a timeslice error may be reported along with stack trace which includes the modules ind_ides_init() and ind__ides_install() after using the DBCC TUNE('des_bind') utility. |
740814 | There are missing VA information in some Lava plan operators when using show_cached_plan_in_xml(). |
740835 | In stress test, when scanning a table using transaction isolation level 0, error 12301 state 1 "Data is marked deleted but index is not." might be output. |
740878 | If a process uses up all the locks leading to error 1204, then a new login attempt may cause a stack trace that involves the module lock_do_logical() to be reported in the ASE error log. |
740882 | Table scans may be used by the optimizer if parameters values are not visible at optimization time for range predicates since the magic numbers used by a range predicate " > ", " < ", " > =" or " < =" will use 33% selectivity, and an "in-between" predicate in which a lower and upper bound are specified will use 25% selectivity. sp_modifystats has a new option MODIFY_DEFAULT_SELECTIVITY for which the defaults of .33 and .25 can be overridden for a specific column if it is known that typical predicates for a column has different selectivities from the defaults. |
740909 | Error 913:"Could not find row in sysdatabases with database id 4" observed while creating database asynchronously. |
740957 | The message "current process infected with 11" in the module 'LeBulkOpOpenCleanup' together with a stack trace which includes the module 'LeBulkOpOpen' may be reported in the error log while migrating data from one platform to another using sybmigrate. |
740987 | In rare circumstance, the size of non-unique indexes on DOL tables may grow very quickly if lots of data is inserted, or the index columns are updated frequently. |
741021 | Buffer pool wash size increments unexpectedly for user defined caches when remote node is booted |
741063 | The 6914 message, "Procedure 'sp_dump_info', The parameter 'Invalid pointer param number 1, pointer value 0x000000000000000A' is not a valid dump type", will be raised if an invalid dump type is passed to the stored procedure sp_dump_info. |
741071 | When executing a subquery with a scalar aggregate, ASE may fail to clean up resources and terminate processing after an attention thus leading to an 803 error. |
741105 | The message, "Current process infected with signal 11", together with a stack trace that includes the module scan_getrow() may be reported in the error log when executing DBCC CHECKTABLE if a shrink-database operation is not completed and the dataserver is rebooted. |
741178 | An 806 error, "Could not find virtual page for logical page < pagenum > in database < dbid > ", may be reported in the error log with a stack trace which includes the modules bufnewpage(), quitfn() and log_to_virt() if a session is killed while executing a query that required a work table creation in the tempdb database, or, required page allocations in a different database. |
741191 | Under some rare circumstances, a shrink-database operation can encounter errors of index not consistent on DOL tables and little endian platform. |
741229 | Permission denied errors might be reported when executing nested stored procedures if unrelated roles are modified. |
741239 | In some cases, runtime rollback of a transaction that is done in parallel (parallel CREATE INDEX, SELECT INTO, REORG REBUILD or ALTER TALBLE (with data copy)) will be incomplete leaving the database in an inconsistent state. |
741278 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module ra__store_last_rs_error() may be reported in the error log if multiple Rep Agent threads are started on the same database at the same time. |
741330 | The message, "Current process infected with signal 11", followed by a stack trace that includes the modules sparclock() and kssolnetctlrWaitForCompletion() may be reported in the error log when SAP ASE is running in the threaded kernel mode on the Solaris operating system after which the ASE may become non-responsive. This issue only affects SAP ASE on the Solaris platforms. |
741350 | The stored procedure sp_helprotect does not display a row for built-in function asehostname for a user who has been granted SELECT on the built-in function. |
741352 | Under rare circumstances the Rep Agent may report a 9219 error with state number 61, "RepAgent( < dbid > ): Internal coding error", when processing LOB data resulting in the Rep Agent termination. |
741368 | If DDL IN TRAN is turned on and some indexes are created in an uncommitted transaction, then concurrent DBCC CHECKDB, DBCC CHECKTABLE or DBCC CHECKINDEX that involves the table will hang. |
741386 | Schema creation is incorrectly logged for DDL replication if the CREATE SCHEMA is not the only statement in the batch and when the statement cache is ON. |
741426 | The messages, "ncheck: select, Operation not applicable" or "poll() returned 32 on socket < # > " may be repeatedly reported in the errorlog after an ASE listener has migrated from a non-responsive engine. |
741439 | A 4306 error, "There was activity on database since last load, unable to load", may be reported when loading a database or transaction log dump of a database whose size is smaller than the target database into which it is being loaded, thereby breaking the load sequence. |
741451 | A 691: "Encountered invalid logical page ' < page > ' while accessing < partition > . This is an internal system error. Please contact Sybase Technical Support." error followed by a stack trace that contains the modules getpage_with_validation() and wrongpage() may be reported in the error log under the following conditions: (1) The configuration option "streamlined dynamic SQL" is enabled, either directly or by enabling functionality group and (2) A dynamic prepared INSERT or UPDATE statement is executed on a table that has been created with deferred_allocation and (3) The prepared statement has been executed successfully at least once and (4) The target table that is inserted/updated is dropped and re-created as a defered_allocation table and (5) The dynamic INSERT/UPDATE query is re-executed from the same ASE connection. |
741461 | When ASE attempts to write a CSMD (configurable shared memory dump) after a failure, it fails to halt and resume the engine threads with the error, "SuspendThread failed for thread (n), error 6". |
741481 | An 804 error, "Unable to find buffer < buffer_address > from cache < cachename > holding logical page < pageno > in sdes < sdes_address > kept buffer pool for object < objname > ", may be raised under heavy load of concurrent DMLs when the log is nearly full. |
741487 | A timeslice error followed by a stack trace that involves the module buf__unhash_and_keep_grabbed_mass() may be reported in the error log during HASH based statistics gathering. |
741621 | SAP ASE reports invalid process status messages like "kpsched: kpid 1962483841 bad status 0x400414" followed by "upstatus: kpid = 1962483841, status 0x400414 not valid". The exact bad status may vary across messages. |
741677 | Under some conditions in threaded kernel mode, when the ASE task is blocked in some OS call, it can hit timeslice error if the thread gets a SIGUSR1 signal. |
741742 | When a small table (number of rows is less than twice the number of steps in the histogram) has a unique index, the range density and range unique values may be inaccurate on the column set for the unique index. This costing change is enabled with optcriteria cr741742. |
741751 | Under rare circumstances, the SAP ASE Cluster Edition keeps running into a lock lookup error and may hang. In the SAP ASE errorlog there will be messages such as "Cluster lock manager of instance 1 has received an invalid lookup request for directory instance 1 from instance 4" |
741759 | Enhance DBCC LOG to support specifying a start marker for the log scan when searching for log records affecting a page, or log records for a transaction. For some usages, the (indid, ptnid) arguments are over-loaded to specify a start (log page#, row #) marker for the log scan. Extend DBCC HELP('log') output to reflect the entire set of options, arguments and variations. Various other improvements to the scan filtering for DBCC LOG added. |
741770 | The error message, "Could not execute login script for user sa", may be reported in the error log when the global login trigger is updated with a new login trigger. |
741786 | A 706 error, "Process < pid > tried to remove PROC_HDR < phdr > that it does not hold in Pss", may be encountered when an SQL statement is executed and it is either stored in the SQL statement cache or it is a dynamic SQL statement and during execution a regeneration of the statement query tree from SQL text is required and an exception is encountered during the parsing of the corresponding SQL text. |
741799 | The Sybmon restart command fails with an error, "Unknown command", when executed without specifying an engine number for a server running in process kernel mode. |
741847 | The 3051 message, "The dump configuration '' supplied for DUMP DATABASE is invalid", can be mistakenly returned for the valid dump configuration which has a 30 bytes long name. |
741871 | The sp_downgrade_esd stored procedure cannot be used to downgrade to ASE 15.7 SP50. |
741894 | When DDL replication is ON, the execution of a DDL command as a prepared statement aborts with error 11314. Trace flag 9152 can be used to allow the DDL command to proceed without being replicated. |
741901 | When a CREATE INDEX command is executed and the following conditions are met, (1) The configuration option, 'enable functionality group' is on and (2) The table upon which the index is being created has datarows locking scheme and (3) The first index-key column contains at least one NULL value and (4) a Lava parallel execution plan is used, then the resulting index may be missing rows for the NULL-valued columns. |
741910 | Enable a login with mon_role to execute sp_monitorconfig on SAP ASE 15.7 |
741924 | An undetected deadlock might occur between a process that ran out of syslogs space and has crossed the last chance syslogs threshold and another process that is attempting to expand the syslogs size by executing an ALTER DATABASE command. The output of dbcc stacktrace( < spid > ) command for one of these two processes will show the modules 'th_sleep_on_lct' and 'upsleepgeneric' whereas for the other process the modules 'writeLock' and 'upyield'. An SAP ASE restart is needed to unblock this situation. |
741934 | In rare circumstances, a time slice error may be reported in the error log followed by a stack trace which includes the modules ind_ides_init() and ind__ides_install() while DBCC TUNE ('des_bind') is executed concurrently with utility commands such as CREATE TABLE that is run at isolation level 0. |
741959 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda__process_sdes() may be reported in the error log when querying the monProcessObject MDA table. |
741984 | A stack trace may occur when a CREATE INDEX command is interrupted (using Ctrl C) and the command is being executed using a parallel Lava query plan. The stack trace may include functions such as bt_create_index(), ups_stat_memalloc(), ups_get_stat_page() and/or memalloc_auxbufarray(), bufauxinstall() depending upon which phase of the CREATE INDEX processng is active at the time of the interrupt. |
742008 | If a database that is created WITH ASYNC_INIT option is used before it is fully initialized as the target database of a LOAD command, the execution of system stored procedure sp_helpdb will display "Allocation Unit Initializer disk fragment" entries that should have been removed. |
742031 | Shutting down an instance may cause a stack trace if I/O fencing is enabled. |
742098 | 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= < value > , lrmagic= < value > )" together with a stack trace which includes the modules 'th_lct_admin' and 'num_logpages' may be reported in the error log if the builtin lct_admin("num_logpages", < dbid > ) is executed concurrently by several processes. |
742139 | The message, "Current process infected with signal 11", in the module 'dam_prepare_dump_end' together with a stack trace which includes the modules 'dpdb_main' and 's_execute' may be reported in the error log when a DUMP DATABASE command is executed and the database option 'allow incremental dumps' is enabled and the system table SYSDAMS contains an extent that is the first extent of an allocation unit causing this table to have a number of pages that is not a multiple of 8. |
742143 | The nested level of functions in expressions has been raised from 10 to 32. |
742152 | On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is < keyname > ", may be reported in the error log. |
742158 | If 'literal autoparam' is enabled, the sometimes a print statement that uses a literal in a stored procedure could lead to remap error 2805 'Bad pointer 0x%p encountered while remapping stored procedure '%.*s'. Must re-create procedure.'. |
742168 | When SAP ASE is running in process mode, if the dynamic listener is on a hung engine, SAP ASE may continuously report , "necheck: select, Bad file descriptor" in the errorlog. |
742191 | SAP Adaptive Server may hang without reporting an error when the pool of locks is exhausted. |
742216 | Booting an SAP ASE may fail permission checks with an error message, "Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE SERVER CONFIGURATION", when the configuration parameter 'enable granular permissions' is set in the default configuration file. |
742226 | Support of DDL replication for prepared DDL statements is now provided. This is enabled by trace flag 16984. |
742233 | Incorrect results can be reported with 'streamlined dynamic SQL' on when using a subquery not containing a table reference to check for no rows returned. This can affect SQl constructs that include (but not limited to) isnull, nullif, case, if not exists & coalesce. |
742249 | With single engine configurations, a SAP ASE polite shutdown request may hang if the JS Agent is executing a job whose spid is set to LOW priority. |
742263 | The error 14108, "Could not find partition descriptor for objid, indid -1, ptnid in dbid" may be reported when either the command DBCC DBSHUTDOWN or DBCC FAILBACK_DBSHUTDOWN is executed and the database option 'allow incremental dumps' is enabled in the given database. |
742292 | Sybmon might get hang with huge garbage SQL text printed when running "sample context=y" command. |
742310 | After running DUMP DATABASE, the time stamp of some pages may become incorrect. If DBCC CHECKSTOREAGE is subsequently executed, error message "Fault Type: 100004 (timestamp error); Hard fault" may be reported. |
742312 | DDLGen generates duplicate partition values when a range or a list partitioned table has a local index |
742352 | When running the DISK INIT/RE_INIT command or the sp_deviceattr stored procedure, ASE silently ignores dsync=false if DIRECTIO is not specified. |
742356 | An 803 error, "Unable to place buffer < buf > from cache < cache_name > holding logical page < page_num > in sdes for object < object_name > - either there is no room in sdes or buffer already in requested slot", may be reported when running a multiple table join under parallel processing. |
742376 | The built-in function set_appcontext() mistakenly allows the update of an attribute without running rm_appcontext(). |
742407 | Add extra diagnostics for the data change fragment pool in order to help catch incorrect memory accesses of the data change fragment pool and thus also improve robustness. |
742434 | The message "current process infected with 11" in the module 'pthread_kill' together with a stack trace will be reported in the error log on Linux platforms only, when the Java option is enabled, the Kernel mode is set to process mode, and the PCI option is disabled. |
742485 | If 'stack size' is configured too small, sometimes it could lead to error, 'Stack guardword corrupted', with OmniQuickPass::generateSelect(), OmniQuickPass::generateStatement() in the stacktrace when select large number of columns for a remote table. |
742515 | RepAgent may not send table schema information to Replication Server if the table contains a compressible LOB column. RAT may also wrongly consider that a table contains a compressible column when it has sent the table schema to Replication Server. |
742541 | New 'force' option to the kill command to forcibly kill the spid. |
742603 | The PhysicalReads value in the monProcessActivity and monProcessStatement MDA tables do not include APF Reads. The PagesRead value in the monProcessActivity MDA table is also incorrect. |
742667 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module ulpspinlock() and kstcpnetctlrCancelRequests() may be reported by an SAP ASE running in the threaded kernel mode on the Solaris platform. The SAP ASE may subsequently hang. |
742693 | 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= < addr_val > , lrmagic= < char_val > )." may be reported when running DBCC FIX_TEXT on a table having one or more text columns. |
742762 | Under some circumstances, an 8203 error, "Expected to find the descriptor for object < object_id > in database < db_name > in < state > state", followed by a stack trace that include the modules ssql_droptext() and procrm() may be reported in the error log. |
742782 | Sometimes, sp_showplan may cause a signal 11 (SIGSEGV) with a stacktrace reported in the errorlog involving the function listChildQueries(). |
742786 | In very rare circumstances, error 1765 (related to level 0 scan) could be raised unexpectedly. |
742847 | With a new set option 'set sqlnull on', string concatenation with NULL value will follow SQL standard, i.e. return NULL value |
742871 | If 'procedure cache' is configured too small for a heavy loaded server, it could lead to stacktraces with s_chooselocks(), s_setup_lockrequest() and insert_to_heap(). |
742896 | In some cases, SAP ASE may report a timeslice error in module shm_mergedump() when "memory dump compression level" is set as non-zero value. |
742985 | Default value of max total shared memory is insufficient to build server. |
742987 | KBA 1952370. An 814 error, "Keep count of buffer < buf_num > in cache < cache_name > holding logical page < page_id > in database < db_name > has become negative", followed by an 837 error, "Attempted to grab wash header" may be reported during UPDATE STATISTICS or CREATE INDEX. |
742991 | After a server crash while shrink database is sorting a non-unique index, boot-time recovery will set the index to be suspect with out any information in errorlog. |
742992 | "alter database" option "with check_only" does not warn about indexes having many duplicated key entries, which could cause shrink database to keep the table locked for unacceptable lengths of time while it sorts index entries. Knowing about these potential problems can help customers plan their work. |
743045 | When log segment of a database exhausts and tasks involving page allocation are in progress, ASE could hit 804 error : "Unable to find buffer '0x..' from cache '...' holding logical page '...' in sdes '0x...' kept buffer pool for object '...'. |
743055 | A SAP ASE that running in threaded kernel mode on the Linux or HPUX operating systems may print a stack trace including ulpspinlock and kstcpnetctlrCancelRequests and thereafter the SAP ASE becomes non-responsive. |
743075 | The configuration option, 'enable plan sharing' is no longer automatically enabled when the configuration option, 'enable functionality group' is enabled. The option 'enable plan sharing' must now be enabled explicitly. |
743145 | Cumulative dumps cannot be done in Cluster Edition. An error will now be reported if sp_dboption is used with the "allow incremental dumps" option in Cluster Edition. |
743177 | System stored procedures, such as sp_password, sp_extrapwdchecks, sp_addlogin, do not have asterisks stored in audit table for password parameters when 'exec_procedure' auditing option is on. |
743203 | DDLGen cannot generate 'Granted by' permission clause for ASE 15.7 SP50 and higher version. |
743211 | During BCP for a table which has undergone an ALTER TABLE DROP column with no datacopy operation, ASE may send wrong default values for columns to the client. |
743218 | When a table is altered to have not materialized columns with default values, null values are sent to the Rep Server instead of the default values during the execution of an UPDATE command. |
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. |
743270 | When an APL table is defined as PAGE COMPRESSED and contains a clustered index, some duplicate rows may be inserted successfully even though this is not allowed. |
743321 | Altering an un-partition table with unique local index to a roundrobin partition table does not give an error. |
743361 | The row count used when a histogram is created on a column is now printed by optdiag and sp_showoptstats. The line "Scanned Rows:" will be added to optdiag output, and the tag < scannedRows > will be added to the sp_showoptstats output. |
743433 | Performing decryption of encrypted column data can be much slower for standard users when decrypt default is used. |
743486 | Auditing of GRANT and/or REVOKE commands may cause a timeslice error when the command contains many whitespaces. |
743496 | Under rare circumstances SAP Adaptive Server Cluster Edition may report during the execution of sp_config_rep_agent an inaccurate run value for parameter 'bind to engine' on some nodes in the Cluster. |
743558 | Error 14613 (The ' < name > ' field in usage anchor has ' < n > ' which does not match with ' < n > from sysusages. Dbid ' < id > '. Lstart ' < n > '.) formats the last 4 parameters incorrectly so the output appears garbled. The field name is correct. |
743573 | The message "Current process infected with signal 11" in the module NormalizeScalar() with a stacktrace which includes the modules PesState::PesInit() may be reported when executing an UPDATE...FROM query on a table that has immediate refresh pre-computed result set (PRS) defined on it. |
743601 | Stack trace with error 622 may occur when running update statistics |
743637 | MERGE triggers on DOL tables may return the incorrect number of rows for the inserted table: too few rows for the UPDATE trigger and possibly too many rows for the INSERT trigger. |
743731 | An 806 error, "Could not find virtual page for logical page < page_id > in database ' < db_name > '" may be reported when executing CHECKTABLE/CHECKINDEX/CHECKDB after shrinking a database containing a table with suspect index. |
743775 | Audit table records might be malformed or missing for table access events when auditing is turned on. |
743795 | ase_default optlevel changed to include all optimizer changes from all releases prior to ase 15.7 sp200 |
743864 | When using alter table not materialized with defaults replication needs to be supplied with the correct default values for log records created before the alter table if replication is behind in reading the log. |
743913 | When a new plan for a procedure is installed, the accumulated metric LogicalReads in the monCachedProcedures table for the cached procedure maybe incorrect. |
743922 | In rare circumstances, a SELECT FOR UPDATE query may return successfully without getting the exclusive lock on the row, even if READPAST mode was not being used. This only affects the AIX platforms and has been identified as an AIX compiler optimization issue when high levels of optimization are used on a specific module. |
743929 | The maximum length of a user defined datatype (UDD), formerly restricted to the page size, is increased to the maximum size of a local variable of the same base type. See the output of DBCC SERVERLIMITS for the values of current limits. |
743936 | srvbuild/srvbuildres does not report any error message if the given device file paths do not have read/write permission. |
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. |
744013 | In a High Availability server, sp_addlogin and sp_addremotelogin will fail with permission errors when the user executing the stored procedures is granted sso_role only. |
744015 | syconfig: Syconfig.exe: additional argument cannot be read into "Command Line" field |
744021 | When the RepAgent configuration parameter 'rs servername' is longer than 30 characters, the run value of that parameter gets corrupted in memory. |
744049 | sp_help does not display information if partition locking is enabled on table. |
744075 | When RepAgent is configured to use multi-path replication thru the option ‘multithread rep agent’ and the number of replication paths is at least set to 2 thru the option 'max number of replication paths', in rare circumstances the replicated data between the primary and the standby databases may show inconsistencies resulting in data not being correctly replicated. |
744116 | The SAP ASE Rep Agent thread sends float values ending in .0 without the .0 which makes them appear to be integers instead of floating point values. This can cause statement caching to create multiple plans for the same table leading to contention in the statement cache and degrading query performance. |
744123 | A 2760 error, "Column name '' does not exist in target table", may be reported during the automatic generation of temp table statistics when the temp table uses a NUMERIC datatype. |
744181 | The message, "Current process infected with signal 11", may be reported in the error log when killing the spid (using the sql 'kill < spid > ') while running REORG DEFRAG. |
744185 | When running reorg rebuild index on compressed index, error 12323 state 43 may be raised during key movement. |
744195 | A 10707 error “Unhandled Java Exception: …” may be reported by the PCA/JVM Security Manager when the JRE needs to internally process information on native methods properties while executing a user supplied method. In order for the PCA/JVM Security Manager to allow the execution of native methods the directive "-Dsybase.allow.native.lib=true" in the "pca_jvm_java_options" configuration must be set to true in the sybpcidb database. |
744256 | In rare circumstances, soft fault 100015 (page loop error) reported by DBCC CHECKSTORAGE may be upgraded to hard fault after running DBCC CHECKVERIFY. |
744283 | When the SAP ASE builtin function ABS() is given a bigint or integer minimum value, a negative result is returned. |
744303 | In cases where REORG DEFRAG or SHRINK DATABASE command encounters a signal 11 error, the table might not be usable by Level 0 scanners. |
744317 | Reorg rebuild index on compressed index may hit assertion failure in bt__rowcmp() during key movement. |
744375 | The scheduled jobs configured using the Job Scheduler, with 'repeats' value greater than one day (eg. repeats=2d or repeats=25h or repeats=1441m) may run daily at the incorrect time. |
744389 | The message, "Current process infected with signal 8 (SIGFPE)", followed by a stack trace that includes the module sam_setup_ptn() may be reported in the error log under rare circumstances. |
744484 | The datatype of 'starttime' output parameter of sp_xact_loginfo is not correct. This results in a NULL value in starttime when executing the stored procedure with the 'oldestactive' option. |
744492 | Backup Server: does not support syntax " dump ... with compression = 0" contrary to documentation. |
744541 | Assertion (ISUSERTABID(objid)) fails in the function xact__getdlm_fromxdes() during upgrade when running diagserver. |
744560 | In rare circumstances, when the CREATE INDEX and REORG REBUILD commands are running in parallel, WORKER processes may hang/sleep infinitely. |
744564 | Error 2622 can be generated while gathering statistics on a DOL (data only locking) table, in which the set of attributes cannot fit into an APL (all pages locking) row of a worktable. This can happen when statistics are explicitly updated on a column(s), or implicitly when auto_temptable_stats is enabled (explicitly or thru an optlevel containing this optcriteria). |
744567 | Improve HK Chores cleanup processing after errors. |
744571 | The DBCC utility reset_cached_plan_stats incorrectly checks for granular permissions. |
744634 | Support Volatile Table whose row count may change dramatically so corresponding statistics are not maintained. |
744650 | When Engine local cache percent value is increased above the threshold, the server is infected with SIGNAL 11. |
744670 | In very rare cases open cursor may give incorrect results if a concurrent online partition utility like SPLIT, MERGE commits concurrently. |
744671 | Under rare circumstances, shrinking a database can cause a subsequent recovery failure of that database. This is indicated by a message in the error log upon restart, saying that the object descriptor of object {N} cannot be installed. {N} may be 1, 2, or 28. |
744695 | The show_condensed_text() function will return NULL with 208 error in some cases and will return NULL for dynamic prepared statement with the 102 error. |
744696 | On the Hpia64 platform, when SAP ASE is running on a real cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang. |
744713 | Backup Server may wrongly issue the message, "The change is completed. The option is dynamic and SAP ASE need not be rebooted for the change to take effect", for an invalid configuration with a config_name more than the 30 bytes allowed. |
744714 | sqlupgrade and upgrade for unix to have dynamic timeout. |
744740 | When displaying information about a dump from a file that was created on a different byte architecture with LOAD DATABASE ... WITH HEADERONLY, the error message, "Message too long", may be reported in the error log where it should display the originating device information. |
744807 | LPAD function will left-pad the input string with a specified pad to a supplied number of characters. RPAD function will right-pad the input string with a specified pad to a supplied number of characters. |
744810 | If the SAP ASE configuration value 'cis connect timeout' limit is exceeded, the local process with the P_OMNI_TIMEDOUT status set will continue to sleep. |
744830 | Aborting a bulk page allocation process can give 'table already closed' error while closing SYSALLOCPG. |
744842 | Memory usage keeps increasing when querying MDA tables in a loop in stored procedure. |
744872 | The 692 error, "Uninitialized logical page < page_no > was read while accessing database < dbname > , object 'syslogs' (8), ...", could be raised if the loginfo() built-in function is executed concurrently with DUMP TRANSACTION. |
744957 | When the default of a non-materialized column is altered on a table that is replicated, extraneous updates to that column may be sent for replication. |
744975 | An incorrect index can be selected when a query contains a multi-column ORDER BY, if the avoid_bmo_sorts optcriteria is turned on explicitly or thru enabling the ase_current optimization level. If a sort is used below a nested loop join, and the ordering that the sort produced contains a unique key, and the ordering is extended by the nested loop join and eventually used to satisfy the ORDER BY, then this plan may be skipped if the avoid_bmo_sorts optcriteria is turned on. |
744978 | TEXT/IMAGE data could be corrupted by byte-swap if the database once performed cross-platform database load on 15.0 ESD#2 or later version of SAP ASE, and the database was originally from a pre-12.0 version of SAP ASE. |
745032 | set plan opttimeoutlimit does not follow the same rule as optgoal and optcritera for optimization and execution. |
745071 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module TcsState::tcs_merge() may be reported in the error log when optcriteria cr702725 is enabled and the query invokes referential integrity check and has an attribute in the ORDER BY clause which is not in the selection list. |
745081 | syconfig.exe cannot select an empty directory correctly. |
745087 | Signal 11 stacktrace might happen in LeEmitXchgOp::_LeOpNext() for a union query between a list partitioned table and other table(s). |
745098 | (INTERNAL_ONLY) Development oversight. |
745112 | Modify srvbuild[res] and syconfig.exe/sybatch.exe utilities to support Remote Dump Host Control. |
745141 | This is low-level thread coordination infrastructural code which the customer doesn't need to know about. The low configuration/performance gains due to the use of transactional memory may be interesting to the customer though. |
745184 | Execution of stored procedures containing statements that are executed using deferred compilation causes the original SQL text in the monProcessSQLText MDA table to be replaced. |
745283 | SAP ASE on AIX does not use 'Large Pages' with the configuration option of 'lock shared memory', resulting in suboptimal memory access |
745325 | Boot SAP ASE with trace flag 9166 when dbcc logtransfer replication is used to diminish the likelihood of contention on the Network Memory Pool spinlock that can cause high CPU utilization when a user table is marked for replication. Don't use trace flag 9166 with Rep Agent replication because operations such as DDL replication or request functions won't work anymore. |
745446 | A stacktrace may occur if auto_temptable_stats is enabled along with parallel sort, either explicitly or via using ase_current. This change will disable parallel statistics gathering on #temptables when update statistics is implicitly invoked via the auto_temptable_stats feature. |
745472 | Incorrect output of message 3705 is displayed when executing DBCC TABLE sysdams if trace flag 3717 is on. |
745492 | srvbuild creates a sparse file for tempdb file system device |
745599 | In rare circumstances the message "current process infected with 6" in the module '__systemcall' together with a stack trace which includes the modules 'jvmfini' and 'BRIDGEjvm_AbortJavaVM' may be reported in the error log during the execution of a UDF/ADT or SQLJ query. |
745655 | If the number of the engines is over 33, max repartition degree is 1 (default) and the tables for the join is unpartitioned, it could lead to stacktrace. |
745776 | A new configuration option "LARGE ALLOCATION AUTO TUNING" is added to enable/disable large allocation auto tuning feature |
745795 | A 15052 error, "Index error: Table id < tabid > , indid < indid > calculated < name > < value1 > does not match value < value2 > in Sysindexes." may be reported when running DBCC CHECKCATALOG on a database containing tables with option 'transfer table' on. |
745872 | When the command: sp_online "engine", < 42 > .. fails, i.e due to OS resource issue, SAP ASE's listener will hang, preventing new connections to be established. |
745873 | In rare cases a 692 error, "Uninitialized logical page ' < pageno > ' was read while accessing database ..." may be reported sometime after loading a database dump that was taken of a database in both Enterprise Edition and Cluster Edition, that had been created on devices with “direct i/o” turned on, or taken of a database in a Cluster Edition system only, that had been created on devices with “dsync” turned on. |
745888 | The FIPS ciphersuites are stricter in OpenSSL not all ciphersuites that were supported by Certicom in FIPS mode are supported by OpenSSL. |
745914 | DBCC CHECKALLOC may report an incorrect number of unreserved log pages after ALTER DATABASE LOG OFF fails to remove a log fragment because some of the pages to remove are allocated. |
746028 | If a UDR roleid is greater than 1024 then a timeslice error may be reported in the SAP ASE errorlog. |
746056 | Sybcluster needs to support remote dump host control. |
746083 | New feature request to build backup server binary on 64-bits in those platforms that still use the 32 bits image. |
746101 | When using sp_downgrade to downgrade an SAP ASE from version 15.7 or higher to an SAP ASE that is version 15.5 based, the keycnt in sysindexes for index sysattributes.ncsysattributes will become incorrect. |
746156 | In some rare cases, when DOL data pages are undergoing deallocation while table scans are concurrently executed on the table, inserts from other concurrent threads may incorrectly qualify to-be-deallocated pages. This may result in 7928 or other index corruption errors reported from DBCC CHECKTABLE. |
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. |
746179 | New feature to specify configuration parameters like interface file or error log file for Job Scheduler Agent using sp_jsconfigure. |
746238 | Enhance DBCC REINDEX to support RID comparison mode change for empty deferred_allocation table. |
746255 | The cache partition maximum value has been increased to 256. The MAX value in cfg_options has been updated to be applicable for all stored procedures. |
746260 | Logging into remote server using a login user granted with a user-defined role will fail. |
746261 | SAP ASE CE hangs when it cannot access storage devices due to a fencing or storage disconnect. |
746285 | Enhancement that adds the possibility to add a cyclic redundancy check to a database or transaction dump created with compression (VERIFY=CRC), as well as to verify that the compression blocks can be correctly read and decompressed (WITH VERIFY=READ_AFTER_WRITE). |
746312 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module mda_calc_proc_hdr_mem_KB() may be reported in the error log while querying the MDA table, monProcessProcedures. |
746330 | When sp_maplogin LDAP, NULL, 'create login' enables an authenticated LDAP user to create their own login and master database replication is enabled, the CREATE LOGIN statement on the replicate database gets error: "Message: 10331, State 2, Severity 14 -- 'Permission denied, database master, owner dbo. You need the following permission(s) to run this command: MANAGE ANY LOGIN. " The error is mapped to stop replication. |
746344 | SAP ASE may hang when doing a disk mirror in some situations. The disk controller thread consumes 100% of the CPU utilization while the server hangs. Also, no new connections to the server can be established. |
746349 | Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a named pipe. |
746367 | monSpinlockActivity configuration option to decompose the aggregate data. |
746376 | After shrinking database, DDLGen encounters the error message, "DDLGen started with the following .... Found 1 dbids with wrong number of rows cached in '#seginfo' v/s the rows in 'master.dbo.sysusages'". |
746442 | Backup Server introduces a remote access control feature that prevents remote dumps and loads and execution of remote procedure calls (RPC) from any client or server running on unauthorized servers. Local dumps are not affected by this feature. Authorization to dump or load, to or from Backup Server is achieved by including the authorized hosts in the host.allow access control file. The default location of hosts.allow file is $SYBASE. The location and name can be changed using the Backup Server parameter -h. This feature failed when the connection to the backup server was through a AF_UNIX socket. |
746464 | Stored procedures using "execute as caller" with queries that call builtin function ISNULL() and create and query #temporary tables fail with error: Msg 208, Level 16, State 1: Server ' < servername > ', Line 26: < #temporary_table > not found. |
746475 | In an HADR configured server, "select * from monHADRMembers" may cause timeslice error like "timeslice -1001, current process infected at 0x15efbc4 (atomic_try+0x2)". |
746528 | Killing a task which involves cursor or work tables might cause the server to hang, waiting for EX_LATCH on an allocation page on which EX_LATCH had been acquired by the same task before the 'kill' was issued on it. (A diagserver throws an 872 error). |
746562 | A trigger defined on MERGE statement executing both INSERT and UPDATE actions may return incorrect rows for inserted table for the INSERT action. This happens if the same trigger is defined for both INSERT and UPDATE: "create trigger T on TAB for insert,update as ..." |
746597 | In some cases an error may be reported in the SAP ASE errorlog, accompanied by a stack trace with the functions kbfalloc() and ptn__pdes_init_colupdcnt() in the stack. |
746601 | When a table which is defined as compressed, and there is some fixed length column which is 'not null' and 'not materialized' in this table, update (index) statistics on this table may hit stack trace and SIGSEGV at decompress__column_by_colinfo(). |
746614 | INSERTs using normal page allocation running alongside operations using large-scale page allocation (LSA) scheme can overwrite the content put in by LSA operations in certain race circumstances between them. |
746620 | A process can hang when executing ALTER DATABASE and DUMP DATABASE if another process goes to sleep when allocating a new page. |
746736 | The text for error 9218 mistakenly stated sp_enable_rep_agent as opposed to sp_config_rep_agent in order to enable the Rep Agent for a given database. |
746741 | Job Scheduler fails to schedule the job which does not specify end date and has the continuous_run property set. |
746759 | New feature request to print trailer information from a dump archive. The new option is LOAD DATABASE < dbname > WITH LISTONLY=TRAILER. |
746820 | Online database will fail with the message 2778, "The object 'sysdams' is not a table. Update statistics can be used only on user tables or system tables" if a cross platform database dump from a lower version that requires upgrade is loaded. |
746826 | KBA 2095983. A 9950 error, "Workspace ' < name > ' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace." may be reported when running DBCC CHECKSTORAGE. |
746827 | The monitoring table monRepSenders has been enhanced with information such as counters for the number of bytes sent and number of commands processed with information that is useful for a single-task Rep Agent. |
746994 | The DISK REMIRROR command hangs after simulating a disk I/O error on a mirrored device. |
747046 | The odata metadata query shows precision=0 and scale=0 for money, smallmoney, datetime, bigdatetime, time data types. The values are now displayed correctly following the code change. |
747089 | When Rep Agent is configured for 'stream replication' and sync or near sync stream mode, two user tasks running in parallel DML and DDL on the same table may lead to hang one of the user tasks and Rep Agent waiting each other till the 'max commit wait' is reached. Rep Agent will then switch to asynchronous mode. |
747092 | When using syconfig to upgrade backup server 12.5.4 to 15.7, the character set in configure backup server dialog is empty. |
747100 | In rare circumstances the message "WARNING: memory usage in procedure headers (...) does not match memory usage count in Pss (...) for server process id ..." may be reported in the error log when the configuration options "enable functionality group" and "plan sharing" are active and the execution of a prepared statement is interrupted due to an error that caused the current transaction to be aborted. |
747110 | Add step to preupgrade to check the configuration option 'user log cache size' is sufficient for using buffer unpinning optimization in the ASE 16.0 server. |
747158 | In a jConnect application with DYNAMIC_PREPARE set to true, auditing of DML statements doesn't print the correct parameter values when the same cursor is closed and opened again. |
747168 | A 702 error, "Memory request for NN bytes exceeds the size of single page of 16384 bytes. ASE is terminating this process", may be reported when using queries with tables that have more than 4192 partitions. |
747189 | Password echo on console when entering it using auditinit in sa login screen. |
747193 | Internal Only: Auditinit.exe failed to configure ASE Server on windows. |
747209 | KBA 2013774. The builtin function MAX() may return an incorrect value when used with a compressed table. |
747251 | During extreme insert load on APL tables with clustered index, during page allocation, server might hit error 8419 as : Error: 8419, Severity: 20, State: 3 Could not find index descriptor for objid 240003886, indid 0 in dbid 19. |
747444 | Customer may see error 644 when create a temp table and hit memory issue in the middle of update syspartitions table. |
747463 | Alter table add/drop partition command gets 4956 error while level 0 scans are active. This new feature is enabled when the new configuration option 'enable utility lvl 0 scan wait' is set. |
747507 | UPDATE a column referenced by a materialized computed column after an ALTER table modifying a column may corrupt the computed column. |
747572 | 100001 faults (Invalid page ids in header) may be reported for DOL tables by dbcc checkstorage() if it's run after shrink database operation. |
747591 | MERGE into statement with columns having decrypt defaults in their ON clause may not produce expected results when the user does not have decrypt permission. |
747648 | A 3478 error: "During undo the page timestamp value is less than new timestamp from log...", or a 3474 error: "During redo the page timestamp value is less than old timestamp from log...", or a 12337 error: "Page < pageid > in database < dbname > was incorrectly found to be uninitialized when it was read. Recovery of this database cannot continue." may sometimes be reported during recovery if the server crashed while a transaction doing a CREATE TABLE operation was rolling back. |
747758 | In HADR configuration: 1. If the length of hostname and port number together are equal to or more than 30 characters, login redirection fails. 2. SAP ASE runs into different issues when server options are changed using sp_serveroption for HADR_GROUP class(17) entry in sysservers. |
747778 | After loss of ASE_ENCRYPTION license, DROP ENCRYPTION KEY generates a segmentation violation and stacktrace. |
747948 | There may be inconsistencies in the values reported between the monProcedureCacheModuleUsage and monProcedureCacheMemoryUsage tables. |
747977 | KBA 1932594. The command ALTER DATABASE will fail silently to extend a database that is offline if the database dump is from an SAP ASE version where the table SYSDAMS did not exist. |
748000 | SAP ASE running in process kernel mode may hang waiting for disk IO completion. |
748008 | Signal 11 in alt__lock_fix_computedcol |
748021 | Add an option to disable the session-level lock wait period to the 'set lock wait' command. |
748027 | The error IO_UNCOMPRESS_BUF_E, "The 'uncompress' call failed for database/archive device while working on stripe device < filename > with error number 0 (The operation completed successfully)." could be raised by sybmultbuf when using a block size bigger than the default. |
748031 | Avoid a rare race condition in the SAP ASE buffer handling that may result in an 839 - "Grabbed buffer dirty but not writing: < buffer info > " error. |
748045 | Job scheduler upgrade sometimes hit this error failing Job Scheduler to boot : "Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state" |
748086 | When DOL data pages are undergoing deallocation and table scans are concurrently executed on the table, inserts from other concurrent threads may incorrectly qualify to-be-deallocated pages. This may lead to error: "12316: Attempt to garbage collect a deallocated data page 13407 in table 'table1_PDR', database 'onlinedb'. Aborting the transaction" could be seen. |
748258 | A dynamic sql statement with a LIKE and ESCAPE or builtin with more than one declaration in a where clause could have a performance issue if the plan is removed from procedure cache. |
748302 | Logical cluster failback without a failover leaves the logical in a timed_wait state. |
748320 | Alter table split/ move partition on a table followed by drop column with no datacopy can cause data corruption. |
748377 | Change in number are messages being printed in errorlog. Earlier used to print a message for every cache-partition in the cache, now it will be printed only for 1 cache-partition. This will avoid flooding messages in the errorlog. |
748391 | When tracing systabstats values using trace flag 2701, during UPDATE STATISTICS operations that reference non-clustered indices, the command may be aborted due to printing an uninitialized float value. |
748423 | DUMP DATABASE CUMULATIVE will silently fail when the auditing configuration option is turned on. |
748519 | Various errors like 206, 4701, 247 maybe given when using EXECUTE AS CALLER procedure with select into a temporary table or create index statements. |
748569 | When the EQUALS_SCAN_SUPERSET optcriteria hueristic is enabled, it would not apply in the case that the index with no positioning equi-sargs exist (i.e. a full index scan). The heuristics should apply in this case if the more expensive index covers all the equi-sargs of the former index, and includes positioning equi-sargs as well. optcriteria cr748569 will support the enhanced functionality to heuristic optcriteria EQUALS_SCAN_SUPERSET. Related to this enhancement to the EQUALS_SCAN_SUPERSET is optcriteria cr763859 |
748689 | Add support for single instance user databases for the SAP ASE Cluster Edition. |
748815 | A segmentation violation followed by a stack trace that contains the module strtok_r() will be raised at boot time on a Windows SAP Adaptive Server Enterprise if the configuration option 'enable dump history' is enabled and the file configured in 'dump history filename' exists but it's empty. |
748851 | 'Invalid pointer value' error messages may occur when a non-database owner accesses the SAP ASE database. |
748853 | sybatch.exe: Usage message was not completely displayed. |
748867 | internal only: version change. |
748941 | installTemplateXml.bat fails with EOF error |
748968 | The sybdumptran utility has been enhanced to switch automatically to the mirror of a log device when opening the primary log device fails. The metadata file used by sybdumptran must be a dump that has been made using an SAP ASE version that contains the current fix. |
749004 | The message "current process infected with 11" in the module 'getpage_with_validation' together with a stack trace which includes the modules 'apl__startscan' and 'startptnscan' may be reported in the error log when the stored procedure sp_helpdb is run and its execution is interrupted. |
749046 | INSERT SELECT does not support LEVEL0 scan. This is a new functionality request, to allow INSERT SELECT to support LEVEL0 scan. |
749058 | KBA 2111507. In rare circumstances on a heavily-loaded Server, the message "current process infected with 11" together with a stack trace which includes the module 'mda__tc_scan_mempool' may be reported in the error log when table monTableCompression is accessed. |
749080 | When using date_diff with smalldatetime and varchar arguments, a bigint may be returned. |
749086 | CREATE and ALTER DATABASE FOR LOAD initialize the database allocation pages when it's unnecessary. |
749097 | If update statistics is used on a table with a large number of partitions (e.g. 1000), then the performance declines significantly, and an inordinate number of log records are created. |
749101 | The connection to a backup server can be rejected if the client host has multiple IP addresses and the entries in the target backup server hosts.allow file are not authorizing the first remote IP address. Likewise, the connections will be rejected if the host name used in the first column of the hosts.allow file specifies a host alias different from the actual host name. |
749129 | The command "select * from monHADRMembers" sometimes returns 0 rows when executed on a standby member of an HADR cluster. |
749138 | A 422 error, "Too many nested expressions or logical operators to compile. Try splitting query or limiting ANDs and ORs." may be reported during the execution of a SELECT query that uses an abstract plan and references a table with more than 2000 range partitions. |
749156 | A 3474 error: "During redo the page timestamp value is less than old timestamp from log." and other miscellaneous errors can be encountered upon loading a transaction log dump containing a CREATE INDEX transaction on a table that has compressed data and nonmaterialized columns having default values. |
749172 | If JS Agent hits some inconsistency in operation then Job Scheduler auto restart attempts may enter into an infinite loop. |
749267 | DBCC TABLEALLOC needs to scan allocation pages of the database several times, when used like 'DBCC TABLEALLOC(name, full, fix)', it may partially cause the command run a long time. DBCC CHECKALLOC has same performance issue. |
749274 | When the monDeviceSpaceUsage table is queried concurrently from different processes, SAP ASE running with threaded mode might report a SIGSEGV (infected with 11) error that mentions the function mda__init_FSList() on the IBM AIX platform. |
749279 | When a rule is created which is not compatible with the column to which it is bound, SAP ASE generates an error message when it tries to insert a value. After raising the error, an infected with 11 (SIGSEGV) along with a stack trace is reported in the SAP ASE errorlog. |
749311 | When 'set option show_abstract_plan on', SELECT FOR XML query may return error instead of the acutal return |
749312 | KBA 2089476. When using a large IN list and the statement cache is on, if the plan chosen has > 96 tables, the query may stack trace during compilation. |
749368 | DDLGen not displaying SAP ASE errors raised during execution |
749381 | Job Scheduler may go down during HADR deactivation. |
749443 | Under some rare situation, if statement cache is on and a plan need to be recompiled during execution time, it could leave the statement pagecount with a negative number for FBO binary and stacktrace for DEBUG binary. |
749449 | If dump history file is manually edited and the first line becomes blank, the file is assumed to be empty and then is initialized. |
749462 | KBA 2115602. When statement cache is on and if fewer of parameters are sent to SAP ASE than the query expects, then an infected with 11 (SIGSEGV) stacktrace in the s__make_param() function may be reported in the SAP ASE errorlog. |
749479 | A Parallel query that uses a shared worktable may result in a 940 error "Dbtable in wrong state for Operation" and the process being terminated. |
749486 | Loading a transaction dump created with NO_TRUNCATE will fail with a 4334 error, 'Specified file is out of sequence...' if it is loaded after a cumulative dump has been loaded. |
749526 | internal review |
749669 | Add new -D option to specify user data directory |
749712 | Add a db shrink warning if there not enough space available. This has been added as a part of the checking done by "alter database ... with check_only" |
749721 | In rare circumstances, a 2601 error, "Attempt to insert duplicate key row in object ' < name > ' with unique index ' < index name > '", may be reported during the load of an 12.5 database in a 15.7 dataserver. |
749795 | The loginfo() built-in has been optimized to avoid blocking while database dump or dump transaction is executed concurrently. Similar optimization was made to lct_admin() built-in when used with "num_logpages" option. |
749845 | While trying to create and access vhash tables, the table might not be accessible. |
749879 | HADR deactivation process can fail or get delayed due to transactions started by housekeeper and checkpoint tasks. |
749880 | HADR deactivation operation should not wait for open transactions belonging to non-replicated databases to be completed. |
749899 | monSysStatement does not show stored procedure when executed with another statement. |
749927 | If a database is dumped after an "alter database log off" command has failed, that database dump may produce an incorrect disk map after being loaded. |
749941 | SAP ASE might report an infected with 11 (SIGSEGV) stacktrace in the function mda_flush_iostats() when the SAP ASE configuration option "enable monitoring" is set to 1. |
749957 | Support to create non-clustered local index in parallel for partitioned table with some empty partitions. |
750056 | Dump database with protected password ('with passwd = ') option only worked if specified in all lowercase letters. |
750062 | internal only: Auditinit didn't accepet empty sqlsrv.sa_password attribute in resource file. |
750085 | A 14108 error, "Could not find partition descriptor for objid < obj_id > , indid < indid > , ptnid < ptn_id > in dbid < db_id > " will be raised when creating a local index on a partitioned table if the database option 'allow incremental dumps' is enabled, or while a concurrent database dump command is executed. |
750163 | In ASE 15.7 SP110 and above, under certain circumstances on AIX only, SAP ASE may erroneously produce the message "Message empty." while attempting to clean up after a previous failure. |
750167 | Job Scheduler prints incorrect restart count while auto restarting. |
750314 | Need a script to calculate transaction log growth rate |
750324 | REORG REBUILD cmd may take more time than before if table have TEXT/IMAGE/UNITEXT columns. |
750354 | The LOAD DATABASE CUMULATIVE command succeeds incorrectly, rather than failing with a 4334 error, 'Specified file is out of sequence...', if the cumulative dump is loaded after loading a transaction log dump that was dumped before the cumulative dump. |
750436 | A 1105 error, "Can't allocate space for object ' < object_name > ' in database ' < db_name > ' because ' < segment_name > ' segment is full/has no free extents. . . ." may be reported when running DBCC CHECKSTORAGE after the Server reboots from crash. |
750468 | INSERT query raises error 225 (statement cache off) or 11060 (statement cache on) after loading a database with materialized columns using SQL functions to another database with different database id. |
750500 | KBA 2111156. Stored procedures with application context functions take a very long time to execute because SAP ASE accesses system catalogs each time for protection checks. |
750590 | When RepAgent is configured to use multi-path replication where two paths are having a different set of transactions bound to them, the replication flow between the primary and the standby databases may stop working if this setup is used in conjunction with a warm standby setup. |
750617 | There is high spinlock contention on the dbt_spin for some user workloads even when not using multiple databases. |
750645 | An infected with 11 (SIGSEGV) in the function ct__tds_fetch_cache_cols() is reported in the SAP ASE errorlog and then the server crashes. |
750655 | The message, "current process infected with signal 11", together with a stack trace involving the functions rtms_print_um_error() may be reported when a spid waiting for get a JMS message raises error. |
750665 | internal only: support upgrade from 15.7 to 16.0 |
750683 | In rare circumstances, the execution of Java User Defined Functions (UDF) could mistakenly ignore the arguments it expects when these are presented to it through a single argument that holds a white space separated string. |
750705 | Query performance may be affected on queries for which optimizations are based on stale statistics where column histograms are out-of-range. A new UPDATE STATISTICS option is added to provided to collect statistics for a user-specified growing column so that a new histogram which include the out-of-range values can be generated during optimization. |
750719 | Error 247:"Arithmetic overflow during implicit conversion of < type > value < value > to a < type > field ." can be seen while running stored procedure sp_spaceusage on large table. |
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. |
750731 | internal review |
750763 | An SAP ASE task keeps sleeping in remote i/o state even if the connection terminates while the SAP ASE task is executing a query to the remote SAP ASE. This problem may occur if the client program executes a query accessing a proxy table. You have to kill the spid manually. |
750787 | sybatch:Failed to Create Self Management login/user |
750807 | KBA 2112945. Correct an 814 error situation (Keep count of buffer '0x%lx' in cache '%.*s' holding logical page '%u' in database '%.*s' has become negative). |
750883 | auto_temptable_stats will automatically generate in-memory statistics on a #temptable column on the first optimizable statement that needs statistics on that column. However, the statistics are not regenerated after a subsequent INSERT/DELETE/UPDATE or TRUNCATE table command. The optcriteria or traceflag 12801 will delete all in-memory statistics on the respective table so that up-to-date statistics will be generated on the next optimizable query referencing the respective #temptable. Note that the ase_current optimization level will not enable this functionality. In order to enable this functionality, explicitly execute "set cr750883 on", or define a user defined optgoal that includes this optcriteria, or enable trace flag 12801 on server startup. |
750913 | On Windows 64-bit, sp_helpdevice incorrectly reports 'unknown device type' for file system devices that are 4Gb or larger. This also prevents sp_deviceattr from issuing the warning: "Warning: ' < large device physname > ', is a file system device. A system failure may cause data loss if the dsync option is set to false." |
750937 | Sometimes a long running transaction can be seen in tempdb for $sort_local which results in tempdb filling up if a large data set needs to be sorted. |
750972 | Server crash after writing the commit log during merge partition or online create index can cause data corruption. Pages deallocated during merge partition were getting allocated to same or other tasks even before merge partition is over. |
750981 | Trace flag 7795 will force a union query to return results in a sorted order. The sort order is determined by the order of the projection list. |
751034 | If the DUMP DATABASE is run on a database, a 691 error, "Encountered invalid logical page < page id > while accessing database < database name and id > , object < object name and id > , index < index name and id > , partition < partition name and id > . This is an internal system error. Please contact Sybase Technical Support.", might be reported when running SELECT INTO cmd to create a proxy table in this database. |
751062 | A 12954 error, "Database < dbname > : upgrade could not install required upgrade item 80." may be reported when upgrading from ASE 12.5 or after to ASE 16.0. |
751067 | DELETE not using row limit optimizations The optimization is enabled by optcriteria. |
751184 | The Secondary Truncation Point may not be moving as expected by the SAP ASE RepAgent process in a Multiple Paths Replication environment. |
751192 | A 9022 error, “Cannot deliver a command from < connection > . < database > since no transaction is open.” may be reported in the SAP RS error log, when the SAP ASE RepAgent is configured to use the ‘Multi-Path Replication’ feature and while a DML command is rolled back in ASE resulting in the replication stream to fail. |
751238 | On the Windows platform, an SAP ASE server might fail to start up if it uses the -r option to specify the mirrored device. dcmpmirror and kdactivate messages are reported in the SAP ASE errorlog. |
751331 | No error is raised when compression option is used in index partition clause of CREATE INDEX. |
751471 | SQL Statement replication using CI is not supported for GA. |
751510 | If any online utility is running and HK_GC fails to get DES, it gives rise to an 8233 error (" < name > operation is in progress on the object ' < obj > ' in database ' < dbname > '. Retry your query later."). If traceflag 2792 is ON HK_GC will wait there, which may then cause an undetected deadlock. |
751612 | When Kerberos is configured and many engines are created using 'create thread pool', then deleted with "alter thread pool', and then created again, Security Control Layer initialization fails due to exhaustion of memory resources with errorlog message: 00:0061:00000:00000:2013/11/07 00:41:47.50 server Security Control Layer's memory allocation routine returned an error. |
751664 | New option 'config_bs' for the built-in function hadr_admin() to add an entry to the hosts.allow file. |
751670 | When creating a new 8k or 16k page SAP ASE using syconfig (Windows) or srvbuild(res) (Unix) and additionally setting up PCI at the same time, SAP ASE may not have enough memory to boot. |
751820 | New feature request to allow DUMP TRANSACTION to use the options WITH VERIFY=CRC and VERIFY=READ_AFTER_WRITE as well as LOAD TRANSACTION WITH VERIFY[ONLY]=CRC. These options are applicable only at DUMP TRANSACTION time if the option WITH COMPRESSION is also used. Likewise, the CRC verification at LOAD TRANSACTION time is only applicable if the transaction dump is created with the CRC verification option as well. |
751829 | Alter table split/ move partition on a table followed by add non materialize column can cause data corruption. |
751851 | On AIX platform, dataserver and libbtsymbols.so pair should match from the same build, otherwise stacktraces will be incorrect. There is no validation to indicate incorrect install/update process may result in a mismatch resulting in wrong stacktraces. This change issues a warning if there is mismatch like "kernel Warning: mismatch of dataserver (90112) and libbtsymobls.so (90113)". |
751900 | 'REORG REBUILD WITH ONLINE' may fail with error 806 (Could not find virtual page for logical page < page# > in database ' < dbname > '.), if the table has undergone an 'ALTER TABLE DROP COLUMN WITH NO DATACOPY' operation. |
751923 | During continuous replication Rep Agent configured for STREAM REPLICATION may shutdown when receiving an a retrievable error from the Component Interface native thread. "Error: Streaming replication stream error (-1). Severity 2, MSProdReceiver: receive error occurred, shutting down xport" will be found in the ASE errorlog. |
751924 | A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" may be reported when SET ANSINULL statement is used inside a batch containing other statements. |
751933 | When HADR is enabled, a graceful shutdown of the primary server requires that its state be inactive and the transaction logs be drained unless the new shutdown option 'nowait_hadr' be used. |
751934 | HADR feature to allow server to be promoted to primary mode only if the transaction logs are drained from older primary and those transactions appears on this server. Secondly, if "nodrain" option is used in "sp_hadr_admin deactivate" command, then demotion of the server to standby using "sp_hadr_admin standby" would fail. The usage of 'force' will override this behavior i.e. "sp_hadr_admin standby,force". |
752105 | Once Rep Agent has swirthed from (near)sync to async it will attempt to switch back again to (near)sync mode. In order to accomplish that the user task are slowed down so Rep Agent can reach again the end of the log. However if the initial scan after the switch is long, Rep Agent will not be able to slow down the user transacations for a long time. |
752115 | When the SAP ASE kernel mode is configured as process and an SSL session/connection is abruptly killed/aborted, a SIGSEGV (infected with 11) with a stacktrace may be reported in the SAP ASE errorlog. The functions drop_connection() and ssl_nclose() are likely to be seen as part of the stacktrace. |
752170 | The ASE COTS JavaVM version is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database. |
752211 | Error message 3128 "The dump image specified does not contain information for any of the database devices" will be printed when a transaction dump generated by sybdumptran is use with the command LOAD DATABASE ... WITH LISTONLY = CREATE_SQL" |
752225 | If there are more than 32 columns in the GROUP BY list, and more than 6 tables in the query then the query plan performance could be significantly different than equivalent queries which have less than or equal to 32 columns in the GROUP BY list. The optcriteria cr752225 eliminates the discontinuity in query plan selection/performance when the threshold of 32 columns in the group by list is passed. |
752351 | sp_hadr_admin activate may report Msg 18703, "Please execute the procedure 'sp_hadr_admin' from master database." |
752352 | In some rare cases, in SAP ASE Cluster Edition, when one of the nodes goes down and FAILOVER recovery starts on the other node, a deallocated page can be wrongly brought into the cache. An INSERT which is fired after recovery has completed can pick up this deallocated page and insert into it. This may result in 7928 or other index corruption errors reported from DBCC CHECKTABLE. |
752367 | A data truncation error may occur when executing a query on the monTableColumns table and retrieving the value of the Description or Label columns in the Japanese language using an SAP ASE server that is configured to use the utf8 character set. |
752391 | In rare case, if DOL table has unique index, concurrent DML may hit index corruption (error 12313 "Insert into page id < page # > of index id < index # > of table ' < table name > ' (id = < id # > ) in database ' < db name > ' tried to replace undeleted RID ( < > , < > ) at slot < slot # > and ridposn < # > . Try dropping and recreating the index.")x. |
752408 | In rare circumstances, a 3474 error, "During redo the page timestamp value is less than old timestamp from log....", may be reported during boottime or LOAD DATABASE recovery, when a transaction that allocated a page, rolled back that allocation while a checkpoint was active. |
752415 | Forcing an index on one table, where the query has more than 6 table joins and the configuration parameter 'enable deferred parallel' set to ON, can cause an infected with 11 (SIGSEGV) to be reported in the SAP ASE errorlog with a stacktrace involving ResVector::getScalarSum or GtgGroup::GtSecondaryInit |
752438 | Under some rare condition, when statement cache is on, a parameter bound to a value is not sent back the correct new value. |
752471 | In rare circumstances, the message "current process infected with 11" in the module ‘ocm_hold’ together with a stack trace which includes the modules ‘des_has_onlutl_active’ and 'checkpoint’ may be reported in the error log by the process doing 'CHECKPOINT' in a Cluster Edition SAP ASE environment. |
752500 | If upgrading from 15.7 GA or ESD#1,2,3 to 15.7 SP60 or 15.7 SP121, SAP ASE may encounter a segmentation fault error in the function upgd__find_basic_depends() during open database. |
752523 | Switch ASE_JAVA support from COTS JavaVM towards SAP JVM delivery |
752591 | A segmentation violation occurs when the config option enable xact coordination is set to 0 and a connection is established between a primary and secondary server. |
752639 | When the SAP ASE server is out of locks, a permission check can cause the error message "ulpspinlock: spinlock order violation" to be reported followed by a crash the SAP ASE server. |
752660 | In rare circumstances, an infected with 11 (SIGSEGV) may be reported in the SAP ASE error log together with a stack trace that includes the modules 'rec_dynamic_prefetch()' and 'rec_undo_session()' when recovery is being run at boot time or during LOAD DATABASE or LOAD TRAN. |
752668 | The error "table still open - dbid < value > table id 58" or the error 12330, "An attempt was made to fetch logical page < value > with partition ID '58', ..." followed by a stack trace that contains the module 'closetable' may be reported when the database option 'allow cumulative dumps' is enabled. |
752670 | Stacktrace could happen during showplan (LeScanOp::_LeOpShowBloomFilterInfo(char*)) or in LeSarg::mapSarg() for hash semijoin query plan when pushdown bloom filter for the hash join is used. |
752705 | Bulk insert on tables with roundrobin partitions may encounter signal11 with pg_get_targetpage() in the stack. |
752839 | KBA 2096910. The message "current process infected with 11 (SIGSEGV)" in the module 'cpynodes' together with a stack trace which includes the modules 's_copytmps' and 'batch_loopend' may be reported in the SAP ASE errorlog when a BATCH INSERT into a temporary table is executed, followed by 6103 and 703 error while SAP ASE attempts to free procedure cache memory. |
752858 | Replicating "datetime" data type from primary DB when primary client application apply data having different localization than RepServer, cause DSI to goes down with error #249 when Statement-Replication is activated and threshold is reach: E. 2013/12/02 08:55:31. ERROR #1028 DSI EXEC(106(1) db_srv2.ads_main) - dsiqmint.c(4358) Message from server: Message: 249, State 1, Severity 16 -- 'Syntax error during implicit conversion of VARCHAR value 'Dez 1 2013 11:00:23:020PM' to a DATETIME field.'. (here, “Dez” word (in datetime value “Dez 1 2013 11:00:23:020PM”) is the short name for December month in German) This may also impact other "date" data type. |
752871 | A 644 error "Index row entry for data row id ( < page# > , < row# > ) is missing from index page < page# > of index id < value > of table ' < name > ' in database 'name'. Xactid is ( < page# > , < row# > ) ). Drop and re-create the index." may be reported when a clustered index on a Data Locked Only table permits duplicate keys and the index refers to pages with logical page numbers higher than the value of 2147483647. |
752892 | DDLGen failed and showed error 'UDM51: java.sql.SQLException' if syslanguages.langid > 99 |
752991 | Trace flag 7796 will prevent the query from being aborted when the recompilation limit has been exceeded. Instead informational messages will be printed when some multiple of the recompilation limit has been reached. |
753022 | SAP ASE running on Windows platforms may report the following message in the SAP ASE errorlog early on during startup: "kernel KERNEL structure not padded correctly - size = 1736". This message may be safely ignored, and this CR prevents it being reported. |
753035 | When merge partitions for table with local indexes, if index rebuild on parallel, error message 14108 will be raised. |
753036 | There is an incorrect assertion that hits with diagserver during rebooting the server if server crashed during online reorg rebuild. |
753037 | Fail to replicate a new login, or a password change in UTF8 dataserver when 'stream replication' is set to TRUE. A stacktrace is reported in the standby dataserver including the functions lobj_crtlogin()- > lobj_crtloginmain() |
753079 | For internal use. |
753085 | Tracing optimizer behavior may not use the correct indentation when printing plan fragments |
753098 | In a long running SAP ASE server configured for SSL, SSL handshake errors due to memory allocation failures appear for new incoming connections. |
753140 | The message "current process infected with 11" in the module 'plc__discard' together with a stack trace which includes the modules 'xact_endupdate' and 'reorg_main' may be reported in the error log during 'REORG REBUILD < table > WITH ONLINE' while this command is executed on a system where high concurrent DML activity is happening on the same table. Alternatively this error can occur during a high concurrent DML activity in a low durability database. |
753147 | In an HA environment, when the same user tries to login on both primary and companion server at the same time then the login process occasionally hangs. |
753171 | Error 1289 - "Internal Error in lock manager routine: Invalid lock mode ..." may be raised when SAP ASE executes a select-for-update (SFU) query and the following conditions apply: 1. The SFU query contains a TOP clause or a 'set rowcount' command was previously executed to limit the number of rows returned by the SFU query and 2. The number of rows that qualify for the SFU query exceeds the limit imposed by the TOP clause or 'set rowcount' command and 3. The optimizer chooses a parallel query plan to execute the SFU query. |
753175 | The database level replication status may become inaccurate after changing the replication status of tables or stored procedures while the secondary truncation point is not set. |
753181 | The monDeviceIO table Reads column value includes the count of APF reads. The description for this column in the monTableColumns table incorrectly stated that it did not. We removed this phrase from the description of this column. |
753302 | When we create a table with global variable as a default and then insert a row into this table in the same batch, it will trigger a n infected with 11 (SIGSEGV) stacktrace in the SAP ASE errorolog if the insert is not cached either due to switch off due to the statement cache being disabled or by using special traceflags. |
753408 | Under some rare circumstance, the value of PagesTouched queried from the monCachePool MDA table is larger than AllocatedPages . |
753461 | A segmentation violation occurs when sp_listener starts an SSL listener where no SSL listeners had been started previously. |
753525 | SAP ASE running on Unix/Linux platforms only prints the top 25 stack frames in a stack overflow stacktrace report which could mask the root cause and also provide insufficient diagnostics when a stack overflow is caused by a recursive function. If the stack overflow backout code uses too much stack, the backout process can cause stack guard word corruption resulting in server shutdown. This CR removes the limitation on number of frames in the stacktrace and if the stack overflow backout code use of the stack reaches within 4K bytes of the stack boundary, it then initiates forcible termination of the task to prevent stack guardword corruption. The default value of 'stack guard size' is increased by 4K bytes to retain earlier level of stack availability. Traceflag 3687 provides a stacktrace when a transaction is aborted due to insufficient stack space that can provide additional diagnostics on stack usage by the query. Traceflag 3686 disables this change. This change is not applicable to the Microsoft Windows platform. |
753577 | ASE with SSL configured and using CIS may hit SEGV in np__validate_servername() which would bring down the server. |
753695 | If a stored procedure is compiled in deferred compilation mode and when a compilation error is raised, it could cause an infected with 11 (SIGSEGV) stacktrace and other unexpected error messages to be reported in the ASE errorlog. |
753704 | If quoted_identifier is ON and sp_hadr_admin primary is executed, next time HADR primary server reboots as standby, instead of primary. |
753753 | In rare circumstances Online REORG / ONLINE CREATE INDEX may hit SIGSEGV when table contains compressed row but table is marked as not compressed. |
753842 | In rare circumstances, 691 error, "Encountered invalid logical page '0' while accessing database 'dbname' (dbid), object 'object name' (object id), index 'index name' (index id), partition 'partition name' (partition id). This is an internal system error. Please contact SAP Technical Support." may be reported with stacktrace when inserting data into TEXT/IMAGE/UNITEXT columns. |
753905 | When using ALTER DATABASE, an 806 error, "Could not find virtual page for logical page < page# > in database ' < dbname > '..." may be reported if ALTER DATABASE removes more than a single fragment from the end of the given database. |
753942 | In rare cases, if SAP ASE server crashes during a ALTER TABLE UNPARTITION or MERGE PARTITION transaction, after recovery, DBCC CHECKTABLE of the table may report a 2583 error, "Number of data pages (#) counted by DBCC differs from count in the data OAM (#) for dbid < db_id > object < obj_id > ". |
753956 | When an insert trigger exists on the target table of the MERGE statement, the wrong result may happen. |
753996 | An SAP ASE shutdown occurs after hitting a SIGSEGV (infected with 11). In the SIGSEGV message in the SAP ASE errorlog the faulting address may reference the function uppushaffinity(). |
754075 | In some rare conditions, error 8201 - "Keep count of descriptor (objid= < objid > , dbid= < dbid > ) was expected to be < n > . Instead < m > was found.", error severity 26, state 1 might be raised during high availability failover accompanied by a stack trace in the SAP ASE errorlog with the functions des_do_get()/ha_session_check() in it. |
754081 | Signal 11 stacktrace could happen during LePipeRepart::LePipeWriteVtuple() call when a list partitioned table is the inner table of a parallel outer equi-join and the join is on the partition column. The same stacktrace could also happen for a range partitioned (instead of list partitioned) table when the upper bound of the partition condition is not MAX. |
754095 | On the AIX platform, when SSL is enabled, after a few thousand connections, connection failures occur and error message "ks_falloc: Cannot allocate using ubfalloc" appears in the SAP ASE errorlog. |
754167 | When upgrade from 16.0beta1 to 16.0beta2 or later version, If the master database has a secondary truncation point set, it indicates to turn the secondary truncation point off using older server, and when rebooting with the older server an error 950(Database 'master' is currently offline. Please wait and try your command again later) will be raised. |
754255 | A 331 error, "Query is too complex and has exhausted the name space for Ordering IDs, please breakup query into simpler components.", may be reported during a complex query with multi-tables especially using aggregates and allrows_dss optgoal. |
754273 | Client connections to SAP ASE may hang when SSL is enabled and the network memory pool is exhausted. |
754283 | KBA 2099194. Backup Server on HPUX may die with error messages: A00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 1, error code=0, system message=Pipe I/O returned 0 bytes. D00: SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes while trying to print out a legitimate API error. |
754371 | When using compatibility mode with more than 32 columns in an order by expression, the server may stack trace. |
754508 | The message, "Current process infected with signal 11", followed by a stack trace that includes the modules def_insert() and xls_sessionid() may be reported in the error log when an INSERT query is run in DEFERRED mode. |
754542 | KBA 2202799. Under some rare condition, an infected with 11 (SIGSEGV) error in the function querytuning_ins_sysoptions() may be reported in the SAP ASE errorlog. |
754548 | In rare circumstances, a 2583 error, "Number of data pages ( < count1 > ) counted by DBCC differs from count in the data OAM ( < count2 > ) for dbid < dbid > object < objid > ", may reported when running dbcc checkdb after rebooting a crashed server or loading a database dump, when a SELECT INTO or ALTER TABLE command was active at the time the server crashed or the dump was taken. |
754621 | preupgrade may underestimate the needed space for databases to be upgraded to 15.7 SP100 or later. |
754622 | Performance of concurrent insert is slow. |
754644 | After upgrading from SAP ASE 15.7 SP100 to a higher version and re-running installmaster, configuration parameter 'engine local cache percent' may not be configurable through procedure sp_configure. |
754648 | KBA 2010108. The message, "Current process infected with signal 11 (SIGSEGV)", followed by a stack trace that includes the module mda_fill_and_send_monProcessStatement() may be reported in the SAP ASE error log when running a query of the form SELECT ... INTO #temptable. |
754653 | SAP ASE may fail to boot on an AIX 7.1 machine if the machine has a missing /usr/vacpp/lib/libhC.a library. The AIX error message will report that "Dependent module libhC.a(ansi_64.o) could not be loaded." |
754679 | In some cases, a DML command is not correctly replicated because SAP ASE Replication Agent may mistakenly generate the table schema definition for metadata reduction for a table that is marked for replication. Schema building is needed when the table is created or altered in the same user transaction as the DML which affects the same table. |
754736 | When starting an SAP ASE server up with hundreds of engines, the CPU utilization is high and the server seems to hang. |
754753 | Alter table move partition can fail with error 326 (ALTER TABLE ' < table name > ' failed. The table is 0-way partitioned, and a 1-way parallel plan was generated due to lack of parallel resources. Increase the value of 'max parallel degree' and 'number of worker processes' to at least 0, and try again.), when compatibility mode is ON. |
754792 | SAP ASE may enter a CPU intensive loop after a SIGSEGV (infected with 11) at ktMuxThreadTick+0x24d with the following seen in the errorlog: "Returning from kmultimap_iterator_cleanup with lock held" and "Attempting to return from utpApplyAll while holding a multimap read lock (0x < address > ). The lock will be released" |
754856 | When we try to alter temporary table for the database which has proxy database mapped on secondary companion, we hit error 177: CREATE PROXY_TABLE cannot create a temporary object (with '#' as the first character name. |
754928 | Add Partial Index support to SAP ASE. |
755181 | Updated sp_help_rep_agent 'config' output to include properties related to stream replication. |
755230 | For tables with several indexes and TEXT/IMAGE/UNITEXT columns, a 605 error, "An attempt was made to fetch logical page < page id > from cache < cache > . Page belongs to database < db > , object < object > , index < index > , partition < partition > and not to database < db > , object < object > , index < index > , partition < partition > .", may be reported when running 'SELECT...INTO...FROM ... WHERE condition1 or condition2 or ...' command on it with concurrent DELETE/UPDATE/TRUNCATE TABLE commands. |
755287 | An assertion will occur if encrypted columns is enabled and there are external passwords that need to be recreated. |
755330 | When using LDAP, an assertion message and a SIGABRT/SIGIOT (infected with 6) stacktrace may be reported in the SAP ASE errorlog. The assertion will say "result == SYBCSI_RESULT_OK, file core/source/csimemory.c". The stacktrace will include the function login__ldapauth(). |
755333 | The Sybmon 'stack all' command may hit signal 11 because of reference to null pointer. |
755424 | When RepAgent is configured for Multiple Paths Replication and verbose LTL traces are active through Repagent traces 9201, 9227 and 9228, a SIGSEGV may occur together with a stack trace showing the module ra__sender_ltl_cmds. |
755454 | When migrating from SAP ASE 15.5, Sybmigrate fails at report session and shows the error: There are still external logins for the server 'mtrs$999'. |
755465 | Dynamic SQL with LOB parameter which results in a character set conversion for a single, very, very large text field can raise a 712 error (out of heap memory). Avoidance of the 712 error involves using a workaround that avoids the large text field character set conversion altogether. When the error is invoked by a Java program, instead of by batch mode processing there can be a large memory leak of the heap memory for the connection. That memory leak is addressed by this CR. |
755473 | The DUMP DATABASE command may hang when run concurrently with a many other tasks if the option 'optimize dump for faster load' is set to a non zero value. |
755520 | An "infected with 11 (SIGSEGV) may occur in LeScanOp::LeGetScanInd (called from LeOrScanContext::getNextVtup) when the SAP ASE configuration option 'streamlined dynamic SQL' is turned on and the query contains ORed joins and one of the outer table's join columns contains a NULL value. |
755558 | The message "timeslice -501, current process infected" in the module 'ra_ms_get_object_filters_for_path' together with a stack trace which includes the modules 'ra__ms_apply_repfilters' and 'ra_ms_get_object_filters_for_path' may be reported in the error log by the SAP Replication Agent scanner thread for the default path when the filter distribution model is used. |
755644 | Ocassionally, a heap memory spinlock violation and followed by various stacktraces may happen for session running multiple XML queries with errors. |
755682 | An ALTER TABLE SPLIT PARTITION command may report a SIGSEGV (infected with 11) in the SAP ASE errorlog if the destination partition name is not specified. |
755705 | SAP ASE Replication Agent under a multiple path replication setup will not replicate the execution of rs_ticket stored procedure to all paths. |
755714 | If the DML contains a builtin function with two or more parameters, the audit trail may print the parameters in reverse order. |
755734 | When using Synchronous Replication, the size of a batch of replicated commands can be configured by using sp_config_rep_agent to set the parameter 'max commands per package'. |
755806 | Under extreme OLTP activity in a mixed-log and data database (like tempdb), a task doing CREATE INDEX may report "Stack overflow detected: limit: 0x0x*, guardpage: 0x0x*, sp: 0x0x*" and "*** Stack guardword corrupted" together with a stack trace that includes the modules 'pg__updateoam', 'pg_oamspace', and 'pg_allocoam'. |
755887 | The error 1120, "Adaptive Server failed to access page < pageno > in database ' < database name > ' because it is not an allocation page." can be raised if the commands DBCC CHECKALLOC or DBCC TABLEALLOC(syslogs) are executed on an archive database. |
755917 | Additional stream replication specific diagnostic information is provided through the sp_help_rep_agent procedure and several MDA tables. |
755985 | HADR deactivation operation with 'force' option kills transactions on non-HADR databases. |
756069 | When text is bound to a different cache than data for a given table, back-linking text partitions via dbcc shrinkdb_setup() can produce bad links. |
756100 | When the SAP ASE RepAgent is started and stopped simultaneously by concurrent users, this may cause the SAP Replication Server to shut down itself. The message "Open Server error: Error: 16330, State: 0, Severity 15 -- 'Pass-through is incomplete for spid: < number > '. RSCIOCSDisconnectHandler: consumer not up. Exiting due to a fatal error." will be reported in the Replication Server error log. |
756143 | Stack overflow may occur which would terminate the server, instead of the offending session. This may occur if the stack is insufficient and there are a large number of tables in the FROM lists of the query. |
756199 | Applying update statistics in parallel mode on a HADR configured standby generates stacktrace and fails. |
756274 | When reporting on the dump header of a dump that was taken with a higher SAP ASE version that has used new metadata in the dump, an error 3264, "The dump header contains device information with invalid token length ...", possibly followed by errors such as 3208 “Unexpected end of file while reading beginning of dump...” will be reported. An unknown element warning message will now be reported instead. |
756284 | When there are nested subqueries with invariant materialization steps in each respective subquery, it is possible that a signal 11 can occur. |
756321 | The message "Invalid column length: < num > . Value must be between 0 and 255 at offset 0 for 'data-only' row with minimum row length of 70." together with a stack trace including the modules 'collocate' and 'ra__new_schema' may be reported if a row for a replicated table with a name of the maximum length (255 char) created by a user with a name of the maximum length (30 char) is encountered by Replication Agent. |
756412 | internal only: wrong cfg file name was created if make an overlay installation with ASE16.0GA. |
756437 | A statement that inserts into a table with an identity column and references a view or derived table that contains a union-all that terminates a union statement may generate a 264 error (duplicate column id) if the identity value is implicitly generated (i.e. - not explicitly provided in the insert's value list). |
756574 | When dbcc page(dbid,pageno, opt) searches the desired page in deleted cache, causing sig 11. |
756600 | Error 11203 - "The command ' < cmd > ' is not legal for objects of this type. External definition: < name > " may be incorrectly raised when a proxy table mapped to a file system is part of an update/delete statement. |
756609 | The wrong suid may be reported in sysprocesses when executing a stored procedure with execute as owner from another database context. |
756618 | KBA 2070185. Duplicate identity values may be generated after loading a transaction log dump containing transactions that inserted identity values reserved using multiple calls to RESERVE_IDENTITY(). |
756619 | Selecting a remote column from DB2 may hit illegal symbol error if the schema name contains special characters. |
756631 | A 644 error, "Index row entry for data row id ( < pageid > , < rnum > ) is missing from index page < index_pagenum > of index id < indid > of table ' < tablename > ' in database ' < dbname > '. Xactid is ( < xactid > ). Drop and re-create the index." may sometimes be reported in heavily concurrent systems using DATAROWS LOCKED or DATAPAGES LOCKED tables. |
756646 | Replication Agent running on 'stream replication' mode may shutdown with the error 'Error: 9219, Severity: 20, State: 66' after a re-connection attempt. |
756648 | A 213 error, "Insert error: column name or number of supplied values does not match table definition." may be reported in a stored procedure, when deferred compilation is active, if a column is added to a table and there is a dependency on "select * " behavior to ignore the extra column. Trace flag 7798 will ignore this error if deferred compilation is turned on and allow normal compilation to process the statement. If normal compilation still sees an inconsistency, or some other activity causes re-resolution of the stored procedure, then errors may be still be reported. |
756819 | Arithmetic overflow occurred in procedure 'sp_sysmon_kernel'. |
756854 | Executing sp_help / sp_helpartition when online reorg / online create index is in its final phase (Blocking Logical Synchronization), may cause deadlock. |
756875 | When executing a DUMP command with more than one VERIFY option, the backup server will ignore all but the last one. Also, on Windows platform, if the archive is bigger than 4GB and we are executing WITH VERIFY=READ_AFTER_WRITE or VERIFY=CRC and the verification fails when reading a block that is at an offset greater than 4GB, the error message will report an offset value that is only the two lower bytes of the actual offset, for example "There was a failure decompressing < # > bytes at offset 804831240 when processing stripe ' < the stripe name > '" instead of the offset value for 5099798536. |
756894 | The error message 7786 has been updated to include the server user name. |
756966 | An 8211 error: "Mismatch found between the name and id descriptor hash table for table < objname > , objid = < objid > " may sometimes be raised if an attention is hit while dropping an object. |
756976 | When procedure deferred compilation is turned off, DML auditing of stored procedures may not print variables in audit trail. |
756988 | Reduce dynamic SQL procedure cache footprint when 'streamlined dynamic SQL' is configured by saving SQL text in the statement cache only. |
756990 | Raise the restriction limit on proxy table queries from 50 tables to 250 tables. |
757027 | In some circumstances when using the command SET STATISTICS IO ON or SET STATISTICS PLAN_HTML ON the runtime execution statistics reported for some queries could be inaccurate when the plan displays some operators like "HASH JOIN PROBE", "HASH JOIN BUILD", "SORT (GETSORTED)" or "SORT (SORTBUILD)". |
757038 | Sometimes, error 7705 could be raised unexpectedly for LIKE predicate with ESCAPE clause if there is a same letter in LIKE and ESCAPE clause, but one is an upper case letter and the other is a lower case letter. |
757061 | When shared memory size exceeds 1TB, sp_shmdumpconfig might report error 265, "Insufficient result space for explicit conversion of INT value '1382954' to a CHAR field.". |
757142 | Stored procedure sp_dbextend fails with Error 3626 / 17 / 4 |
757156 | In some special cases, the index size with index compression is larger than when the index is uncompressed. |
757164 | A timeslice error followed by a stacktrace that includes the modules stphd_release_last_mvcc_histogram(), stphd_release_unreferenced_mvcc_histograms() and stu_nosort_range() may be reported in the error log in a heavily loaded system during the CREATE INDEX operation when using hashing. |
757177 | LIKE optimization does not happen for a ? + ? pattern that is used in a prepared statement. |
757192 | Rolling back of a drop object sometimes could result in an error 8211 with "Mismatch found between the name and id descriptor hash table for table 'tablename'". |
757215 | In rare circumstances, a 1105 message "Can't allocate space for object 'syslogs' in database 'tempdb' because 'logsegment' segment is full" may incorrectly be printed for tempdb when the first pages of tempdb are not mapped in sysusages. |
757251 | Add 'Proc Cache Header' diagnostic enhancements for the block pool to capture the time spent in bitmap scanning and collect memory allocation/free patterns. These diagnostics are disabled by default. |
757258 | When displaying configuration values for Replication Agent using the sp_help_rep_agent procedure the 'rs_servername' displays only the first 30 characters. |
757301 | When a 331 error occurs or there are long query optimization times or large procedure cache usage occurs in the optimization phase, then this may be due to the optimizer not pruning subplans in the search space as early as possible. Improve pruning can be turned on with optcriteria cr757301, or by using ase_current with optimization level of at least ase157sp130. Trace flag 16992 will turn off the optimization even if the optcriteria is enabled. |
757310 | Cannot use syconfig to do backup server upgrade on Windows 64bit |
757323 | The MDA table monRepSyncTaskStatistics that provides statistics on (near) synchronous replication, will report information erroneously when the current replication mode is asynchronous. |
757393 | KBA 2115255. If SAP ASE is upgraded from pre 16.0 to 16.0, then dbcc tune(volatile,4, < table name > ) or alter table < table name > set index_compression = page for the existing table may raise error 12859 like Column sysobjects.sysstat4 has length '0', should be '1'. The sysobjects row is for database ' < db name > ' (db id), object ' < object name > ' (object id). |
757398 | In some rare scenarios, a utility command modifying a table and waiting for a level 0 scanner on the table to exit, might not respond to a client killing the session where a utility command is executed. |
757459 | A timeslice error, followed by a stacktrace that includes the module memshrink(), may be reported in the SAP ASE errorlog during a sort operation on a very large data set. |
757495 | XP server will fail to boot, to execute extended stored procedure or to shutdown if some other process is listening on the xpserver port. ASE shutdown may also hang if some other process is listening on the xpserver port. |
757501 | Improve the clarity of error message 16346, "The LOAD_SQL LISTONLY option is valid only if a stripe device is not specified.". This error message will now be reported as, "You cannot use the FROM clause with the LISTONLY=LOAD_SQL option.” |
757531 | RepAgent may fail with error 9275 "RepAgent ( < dbid > ): Could not locate the before image for the INSERT log record at ( < page# > , < rowid# > )." while processing the log records for a MERGE command leading to inserts and updates. |
757612 | srvbuildres may fail with an uninitialized buffer error if user does not have write permission on /tmp . |
757620 | Add the capability to do a Deferred Recovery of Create Index to SAP ASE. |
757634 | Under certain circumstances, a 2956 error, "Unable to grab a buffer to encrypt logical page < pagenum > in database < dbid > . Increase the size of the 16K buffer pool in the buffer cache 'default data cache'", may be reported when using an encrypted database. |
757643 | Child sort thread during index rebuild leads to assertion failure as it does not recognize concurrent partition level utility execution. |
757649 | A 4720 error, "Cannot truncate table < tablename > because there are one or more isolation level 0 scans, or REORG command, active on the table", may be reported during a TRUNCATE TABLE command while level 0 scans are active. This new feature is enabled when the new configuration option 'enable utility lvl 0 scan wait' is set. |
757824 | When running in SAP ASE process mode under heavy load in a multiengine environment, an engine may become CPU bound when handling network cancel requests arising from attentions received either from the client or from kill commands. In the event that the network listener was on the run queue of the engine which has become CPU bound as above, it may be impossible to establish new logins to the server. |
757829 | Incorrect hash partition elimination may lead to incorrect results when there is an OR predicate on the partition column(s) |
757850 | When running on a table with thousands of partitions, create local nonclustered index or placement index command may fail due to stack overflow with no error message printed. |
757867 | In rare circumstances, checkstorage or sp_dbcc_alterws might not expand the scan/text workspace to the size suggested by sp_plan_dbccdb or specified value. |
757883 | When a user invokes DDLGen from a script and wishes to hide the password by supplying the pseudo password (-Pext) and including the actual password in a file or setting in an environment variable, the error "DG16: Could not get Console instance" is reported. |
757895 | Support Quoted Identifiers on session temporary tables. This requires that the configuration parameter "quoted identifier enhancements" is set and the session level option "quoted_identifiers" is on. |
757962 | Error message 806 (Could not find virtual page for logical page ... in database ...) may be reported for an update query with multiple outer joins when the update mode chosen for the query is not deferred update mode. |
757974 | Under rare circumstances, some qualified data rows may not be returned for a query which uses RID list scan on a partitioned DOL table. |
758105 | The error message, "SSL or Crypto Error Message: 'csi_cipher_crypto'" may be reported when encrypting an existing database. |
758109 | During upgrade from pre-16.0 to 16.0, if the older server's max memory configuration is very close to the amount required by that server, ASE 16.0 can report that max memory is not sufficient. If that happens, ASE 16.0 will not start. |
758119 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeExecuteWorkUnits(), may be reported in the error log during execution of query plans that use both the 'dynamic thread assignment' and 'parallel index update'. |
758144 | 1) If SAP ASE is installed as an overlay, sybatch will reset the XP Server port to default during upgrade. 2) sybatch requires user to specify sqlsrv.master_device_physical_name, sqlsrv.master_device_size, sqlsrv.master_db_size and sqlsrv.application_type which are not really needed in upgrade. 3) sybatch recreates the XP Server Windows service even if it doesn't exist for the old server. |
758214 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module s_recompile() may be reported in the error log when a table schema change happens after processing the first row, and before finishing the second row of an dynamic batch INSERT. |
758249 | When upgrading to SAP ASE 16.0, the upgrade utility will report error 4243, "DUMP TRANSACTION WITH NO_LOG or DUMP TRANSACTION WITH TRUNCATE_ONLY is not allowed in database ' < dbname > ' while the 'enforce dump tran sequence' database option is enabled." if a database has option "enforce dump tran sequence" set. |
758260 | In rare circumstances, a 8201 error "Keep count of descriptor (objid= < value > , dbid= < value > ) was expected to be 1. Instead 2 was found." together with a stack trace which includes the modules 'ptn__pdes_scavenge' and 'open_user_table' may be reported in the error log when SAP ASE attempts to reuse a descriptor and an online utility such as 'truncate partition' had been previously used. In the SAP ASE error log the message "Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation." would have been also reported. |
758297 | Skip blank lines in the dump history file when searching for the version record. If an invalid version record is found, initialize the history file after copying the file to a backup. |
758328 | A poor index may be chosen for a join, if the selectivity of previous joins is estimated to be 0 rows (likely caused by a predicate selecting an 0.0 weight range cell in the histogram). The optcriteria avoid_zero_weight_histograms or trace flag 16991 will adjust selectivity estimates so that at least one row will be selected when joining histograms. Note that ase_current will not enable this functionality, and that "set avoid_zero_weight_histograms on", a user defined optgoal which includes avoid_zero_weight_histograms or trace flag 16991 is needed. |
758340 | Creation of temporary tables in a large number of concurrent user sessions leads to a high number of accesses to syslogins. |
758349 | DDL commands within prepared statements can now be replicated. |
758353 | When using data encryption functionality on Windows platforms, encryption operations can make an engine stall for short periods of time. |
758408 | KBA 2111503. Stored procedures using "execute as caller" with queries that create and query #temporary tables fail with error 208, "Server ' < servername > ', Line 26: < #temporary_table > not found after LOAD DATABASE". |
758440 | Database encryption fails with error 16839, "Database < dbname > cannot be encrypted when encryption is in progress.", after an abnormal shutdown. |
758507 | Executing DBCC CHECKSTORAGE on an encrypted archive database may raise suspect conditions. |
758765 | An incorrect decision by optimizer to do the update in direct mode might result in consecutively repeated update of the same row and resulting in page corruption, manifesting in the errors 806, 614, 120024, etc. |
758774 | The Job Scheduler may fail to start after setting the minimum password length using sp_passwordpolicy to a value greater than the value of the minimum password length set by sp_configure. |
758796 | KBA 2006614. If a database and objects within the database are bound to different caches, ASE could run into SIGSEGV issue when it performs encryption/decryption on the database. |
758809 | Supplying the Rep Agent 'connect dataserver' property with a value longer than 30 characters causes memory corruption which leads to connection failure or other unpredictable behavior depending on the size and content of the longer value. |
758868 | Under a heavily used replication environment and in rare circumstances the Rep Agent schema cache and the Rep Agent memory pool can run out of memory because of a memory leak issue. |
758938 | When a process that is executing a DUMP DATABASE command is killed either using the KILL command or using CTRL-C or the SQL session goes away, the Backup Server will not release its associated resources until it finishes copying the whole database. One of the consequences is that the archive devices can remain locked for a long time because the sybmultbuf processes stay alive. |
758959 | In rare circumstances, when the MDA table monProcessProcedures is being used, an infected with 11 (SIGSEGV) error along with a stacktrace may be logged in the SAP ASE errorlog . This is a similar situation as addressed by CR 754648 (which covered monProcessStatement). |
758961 | syconfig.exe/sybatch.exe and sqlupgrade[res] needs to install Job scheduler stored procedures and templates when upgrading the ASE server. |
758973 | A SIGSEGV (infected with 11) can be logged in the SAP ASE errorlog on the Windows platform if the loginfo() built-in is called with three parameters and for whatever reason the built-in returns an error. |
759012 | A 614 error - "Adaptive Server accessed a row that has an illegal length of < n > while in data base ' < dbname > '. < page info > . The minimum row length is < n > . The page size is < n > ." may be reported when executing DBCC CHECKDB on an unencrypted database that is encrypted first and then decrypted. |
759041 | Support online parallel create index. |
759142 | When UPDATE STATISTICS is performed on a character column with a non-binary character set, and in addition UPDATE STATISTICS uses the consumers phrase, then there is the possibility of many small weight frequency cells following a zero weight range cell. This may cause poor query plan selection if a predicate selects a zero weight histogram cell. Optcriteria cr759142 will avoid generation of small frequency cells following a zero weight range cell, when the consumers phrase is used in UPDATE STATISTICS to generate stats on a mostly unique non-binary character set column. |
759143 | A poor query plan might be selected when parallel UPDATE STATISTICS (for instance using the consumers phrase) is used to gather statistics. After installing SAP ASE with the fix for this issue, update statistics will need to be run on affected tables. |
759188 | KBA 2013610. The message, "Current process infected with signal 11", followed by a stack trace that includes the module sendtext() may be reported in the error log when a MERGE JOIN is being used and if the inner table has in-row LOB columns with NULL values. |
759245 | If there are equality predicates or joins which are used for index keys, then occasionally an index which has few positioning keys specified than another index will be chosen. If 2 indexes have only equality predicates or equality joins used for keys, then a heuristic is added to choose the index with more limiting keys if those keys cover all the limiting and filtering keys of another index. The optcriteria EQUALS_SCAN_SUPERSET and trace flag 16989 will apply the heuristic to index scan which are not the inner of a nested loop join. The optcriteria EQUALS_NLJOIN_SCAN_SUPERSET and trace flag 16990 will apply the heuristics to all index scans. Note that the optcriteria are not turned on by any optgoal, and a SET command, user defined optgoal, or trace flag is needed to enable the heuristic. |
759270 | In rare cases, when a transaction rolls back, it may hit error 623 when starting the backward scan on a page. The 623 error message will indicate that the Rid pageid = 0; row num = 0. |
759322 | If replication is currently disabled and a table having non-materialized columns is dropped or one of its non-materialized defaults changes, then when replication is enabled again, it can encounter errors when trying to replicate that table's rows. |
759377 | In very rare situations, SAP ASE may panic and shutdown if sp_sysmon is being run and a connection disconnects at the same time. |
759433 | On Windows platform, SAP ASE may open an arbitrary listener port during MS DTC service initialization for distributed transaction management. |
759501 | Allow the command LOAD WITH VERIFYONLY to be executed using less stripes than the number used at DUMP time. |
759528 | REORG command has been changed such that it cannot be executed while encryption or decryption of database is in progress. |
759562 | Add support creation of a global index in parallel for a partitioned table that has one or more empty partitions. Previously, when creating a global index on partition table, if there were any empty partitions, then the index would be created in serial. |
759590 | When SAP ASE is upgraded and the higher version server writes a new configuration file after upgrade is complete, then under some circumstances that configuration file may contain entries that were unexpectedly changed from what the older version server originally configured. |
759624 | On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted into the target table. There are NO lost inserts but, dbcc checkalloc or tablealloc may report Msg 2546 or we may encounter deadlocks which can be seen in the error log. |
759637 | The message, "Current process infected with signal 11", followed by a stack trace that includes the module LeScanOp::_LeOpNext() may be reported in the error log when an online utility (e.g. REORG REBUILD) is in progress on a table that contains forwarded rows. |
759646 | Arithmetic overflow may occur when executing the stored procedure sp_sysmon_locks. |
759679 | When 'net password encryption reqd' set to 1, charset/langinstall will run into 1640 (Adaptive Server requires encryption of the login password on the network) and 4002 (Login failed) errors. |
759728 | CREATE TABLE commands may not perform well in situations where a lot of CREATE TABLE commands are run in parallel and the SAP ASE configuration has 'enable inline default sharing' set. |
759748 | On Microsoft Windows platforms, SAP ASE messages may be incorrectly logged in the Windows Event Log. |
759867 | When granular permissions is not enabled, users with sa_role not allowed to replace objects owned by other users, getting permission denied error. |
759923 | Traceflag 3605 gets left on after error 707 state 11 is hit, resulting in a wide variety of diagnostic information being written to the errorlog, in turn causing the errorlog to grow rapidly. |
759937 | If a trigger for a DML query has certain commands that execute immediate are not allowed, such as begin tran, rollback trans, etc, error 11736 and 11031 could be raised for the first post-upgrade using execute immediate for the DML query. |
759945 | When LOAD DATABASE ... WITH LISTONLY = 'CREATE_SQL' is used with the new functionality to create DDL for a differently named target database, the target database name is not reflected in the sp_dboption statements. |
759995 | KBA 2013809. A 169 error, "Expressions in the ORDER BY list must be unique", may be raised for OUTER JOIN queries involving remote tables even when the queries contain no ORDER BY clause due to incorrect ORDER BY clauses generated by the CIS layer for the queries sent to the remote server. |
760002 | DBCC CHECKTABLE may encounter a 2511 error, "Keys of index ID < id > for table < tablename > in leaf page are not in the correct order. Drop and re-create the index (index page < pageno > , partition ID < partition_id > )", if 'enable functionality group' is enabled and the base table lockscheme is DOL and changing the table's lockscheme from DOL to APL as part of AMC. |
760054 | On ASE Cluster Edition insert jobs may unexpectedly continue to run with no new rows inserted to the target table. Dbcc checkalloc or tablealloc may report Msg 2546. |
760159 | KBA 2110039. The 6918 error, "The SYSDAMS page that stores the state of page # in database ' < dbname > ' could not be found. The option 'allow incremental dumps' will be disabled because SAP ASE cannot continue recording page modifications", can be raised if the table SYSDAMS gets the very first extent of an allocation unit allocated. |
760176 | Optcriteria equals_scan_superset and avoid_zero_weight_histograms are associated with the ase157sp130 optimization level. Previously, a user defined optgoal needed to be defined to enable these optcriteria (or trace flags 16989 and 16991 respectively). |
760187 | The index ID is incorrectly reported as 0 in the SAP ASE error message number 12301, "Internal error: the index (id = < ID > ) and the data for row ( < page > , < row > ) in table ' < table > ', database < db > are inconsistent; data is marked deleted but index is not. Aborting the transaction". |
760241 | The error message, "Length of plain text is less than one cipher block", may be reported in the error log during encryption of a database. |
760248 | Under some circumstances, a worker thread may hang due to incorrect error handling during parallel CREATE INDEX with "utility statistics hashing" turned on. |
760269 | A 9254 error 'RepAgent( < dbid > ): Could not locate schema version for object id ' < value > ' in the transaction log." followed by a 9204 error 'RepAgent( < dbid > ): Could not locate schema for object with id = ( < value > ), current marker ( < page# > , < row# > ).' may be reported in the SAP ASE error log when SQL Statement Replication is active and a transaction involving SQL statement Replication is rolled back. This will result in the Rep Agent Thread terminating abnormally. |
760274 | In rare circumstances, a time slice error followed by a stack trace that includes the modules ups_end_statglobalnosort() and close_table() may be reported in the SAP ASE error log when running UPDATE INDEX STATISTICS. |
760365 | Isolation level 0 queries fail with errors when CREATE CLUSTERED INDEX WITH ONLINE is in progress concurrently on the same table. |
760373 | Resource limit violation message 11001 (severity level 17:EX_RESOURCE) is reported when action 5(record action) is configured. |
760390 | A DUMP WITH COMPRESSION could fail with the message "SYBMULTBUF ERROR: Emulator interprocess communication failed with error state = 9, error code=0, system message=Pipe I/O returned 0 bytes". If a core file is produced the stack will show the module sm__do_allocations(). |
760437 | Under certain circumstances, the preupgrade utility from SAP ASE 16.0 can encounter data conversion errors and overflow errors when checking for free space in a database's system segment. |
760453 | Wrong result could happen when an EQUIJOIN on a single INT4 column is placing a bloom filter probe into the scan and the scan is at the inner side of another NESTED LOOP JOIN with a pushdown EQUIJOIN sarg on the same column. |
760539 | SAP ASE fails to boot on Windows with the message "FATAL: shared memory region is being held at xxx bytes but yyy bytes are required" being reported in the SAP ASE errorlog. |
760621 | On a server that has a large number of objects, the sp_sysmon report may take a long time to complete and error message 1508, "Create index aborted on duplicate rows. Primary key is < keyname > ", may be reported in the error log. |
760654 | DBISQL 16 stopped reading interfaces entries when the file contains a large number of entries. |
760661 | The procedure cache allocation is optimised. This vastly speeds up the start-up of SAP ASE configured with a very large procedure cache. |
760672 | A 3478 error, "During undo the page timestamp value is less than new timestamp from log." or other fatal errors may be reported in the error log when SAP ASE is rolling back a transaction following an 863 error, "Buffer resources in cache < cache_name > are unavailable. Please re-run this query or ask the system administrator to re-configure buffer cache memory." that is accompanied with messages "Named cache < cache_name, cache_id > is configured too small for current demands". |
760673 | If the data cache is configured small, SAP ASE may report a 'cache too small' error when the new sort buffer algorithm is used. |
760684 | A 707 error, "System error detected during attempt to free memory at address < addr > . Please consult the ASE error log for more details", may be raised by SAP ASE when multiple SAP ASE connections are executing parallel CREATE INDEX commands. |
760711 | In rare circumstances, after using the configuration option 'global cache partition number', the dataserver may hang. If the diagserver was being used then an Assertion (! "locks not cleaned") will be reported in the SAP ASE errorlog. |
760751 | A parallel query may be rejected during execution because the worker thread pool has fewer threads available than the minimum number of threads required to execute the plan. In this case, the query should be sent back to be recompiled in serial mode. However, the query will be recompiled in parallel mode and then fails during execution again if it contains a plan-clause with the following directive "(use optgoal allrows_dss)". At this point a 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization", is raised because the procedure buffer object is missing. |
760781 | When there is no active transaction in a database, running select loginfo('dbname','stp_pages') will give the result of 0 even if the secondary truncation page is not the same as the last log page. |
760836 | In some rare cases, some of the pdes spinlocks show contention with objects that have a large number of partitions. |
760875 | sp_sysmon and monEngine do not report DiskIOChecks in process mode. |
760876 | Deprecate the plan sharing feature (used to be enabled via the SAP ASE configuration option called "enable plan sharing"). |
760897 | A 6908 error, "During redo the page timestamp value is less than old timestamp from log. etc." followed by a stack trace that includes the module 'recovery' could be raised when loading a database dump if the configuration parameter 'optimize dump for faster load' is enabled and there is very high update activity in SAP ASE while the dump database command is running. To workaround the problem the end-user can set the trace flag 3022 (either via the command line or by using dbcc traceon or by using SET SWITCH ON ignore_trailer_ckpt) before loading the database. |
760910 | KBA 2014957. In rare circumstances, when a partitioned table has a local index and partition lock is enabled, SAP Adaptive Server may hit error 12212 during an index scan, if a committed transaction deletes few rows from a partition that cause deallocation of extent (say X) and a uncommitted transaction inserts rows in another partition, cause allocation of same extent(X). After hitting 12212 error SAP ASE terminates the connection and logs a stacktrace in the SAP error log. Error 12212 " Internal Error: The partition ID ( < ID > ) of the lock does not match the partition ID ( < ID > ) of the new request on this lock. dbid= < DB_ID > , objid= < OBJ_ID > , pageno= < Page number > , rowno= < Row Number > locktype= < lock type > ". |
760917 | Upgrade to SAP ASE 16.0 may fail with the error message "Kernel resource memory pool has been exhausted. Try increasing the value of 'kernel resource memory'". |
760979 | On AIX platform, in rare circumstances,buffer unlatch raises 871 error OR CREATE INDEX may fail with error 1289:"Internal Error in lock manager routine: Invalid lock mode exclusive page, requested by task (family id < > , spid < > ) conflicts with existing family request mode exclusive page belonging to task (family id < > , spid < > ). |
761036 | Under rare conditions, a 12301 error, "Internal error: the index (id = < num > ) and the data for row ( < page# > , < row# > ) in table < table_name > , database < dbnum > are inconsistent; data is marked deleted but index is not. Aborting the transaction", may be reported during an isolation level 0 scan. |
761062 | When using sql replication and nested builtins with a column reference, an incorrect sql statement may be generated instead of defaulting to row replication. |
761117 | DML on tables with Encrypted Columns are significantly slower than SP50. |
761155 | For SAP ASE Cluster Edition, when table creation is in progress, the checkpoint process may hit an infected with 11 (SIGSEGV) in the module 'ocm_hold()' and report a stacktrace in the SAP ASE errorlog that includes the modules 'des_has_onlutl_active()' and 'cm_writedes()'. |
761188 | Monitoring Tables to have an extra column as "OrigServerUserID" to track original ServerUserID when executing procedures with "execute as". |
761275 | KBA 2108695. When there are several scans on the same index and some of the scans hit the same index page needed to be shrunk concurrently, the index page may be shrunk twice. The second attempt will fail and a 2630 error, "In database < db > , page < page#2 > is linked backward to page < page#1 > , but that page is linked forward to page < page#3 > . Please report this internal error to SAP Technical Support". Although a 2630 error is raised, the index is not corrupted. |
761282 | KBA 2000553 - When execute command ALTER TABLE ... SPLIT PARTITION ..., use of parallel sort and table's partition number > 1, it will encounter an Error 675: "Invalid Buffer Cache Access: Attempt to locate page < page > , database < dbid > in cache failed because no object id was specified. scan_context={objid < objid > , indid < indid > , cid < cid > }. Contact Technical Support for Assistance." |
761333 | In some workloads with lot of dynamic prepare statements executing on the system, we would see buffer cache of system table 'sysusers' and 'sysdatabases' to be hot. |
761385 | The message, "Current process infected with signal 10 (SIGBUS)", followed by a stack trace that includes the modules 'loginfo_builtin' and 'exec_lava' may be reported in the error log when the builtin loginfo(' < dbname > ','oldest_active_transaction_date') is executed. |
761410 | UPDATE STATISTICS WITH SAMPLING may report error 614: "Adaptive Server accessed a row that has an illegal length of < n > while in data base ' < db > ." or error 806: "Could not find virtual page for logical page < n > in database ' < db > ', while concurrent DML is going on the same object. |
761514 | sybatch.exe failed to set the XP Server in upgrading server if Replication Server is configured. |
761518 | A 7786 error, "Unable to turn role off since user is not a valid user in the current database", may be reported incorrectly when executing the SET ROLE OFF command. |
761555 | Some of the cache buffers used for sort are not claimed and unclaimed correctly. This can lead to a performance impact if cache swap occurs. |
761668 | A 614 error may be reported when executing DBCC CHECKSTORAGE on an encrypted database. |
761679 | LOAD DATABASE WITH LISTONLY=LOAD_SQL with UNTIL_TIME after a tran dump and before a database dump generates incorrect load SQL. |
761710 | SAP ASE server may hang during the rs_init() command on encrypted databases. |
761743 | The optcriteria EQUALS_SCAN_SUPERSET and EQUALS_NLJOIN_SCAN_SUPERSET have had the comments changed so that the respective optcriteria names shows up in the sysoptions output. |
761825 | Bulk insert to proxy tables mapped to DirectConnect for Oracle was disabled in ASE 15.0. |
761830 | New SAP ASE built-in IS_PREPARED( < dbid > ) will report if a database has been put in a PREPARE state. |
761835 | KBA 2130834 - SAP ASE might hit a timeslice error in the function kbfusage when doing a query involving the monMemoryUsage table. |
761836 | Add a "Bucket Pool" memory manager to help improve enable ASE scaling over large CPU core configurations. |
761860 | Executing DBCC CHECKSTORAGE on an encrypted database gets aborted at the 'index chain' check. |
761881 | BCP in to a table with encrypted columns is much slower with the change from the use of the Certicom libraries. |
761932 | The time range restriction in Resource Governor does not allow users to add time range overlap limits even with different limit types. |
761934 | A 18207 error, "Illegal action 5", may be reported when executing stored procedure sp_modify_resource_limit. |
761958 | KBA 2011331. DBCC CHECKTABLE may report a 605 error, "An attempt was made to fetch logical page < pageno > from cache < name > . Page belongs to < info1 > and not to < info2 > " may be reported after creating an index with online option. |
762026 | syconfig/sybatch try to recreate XP Server during upgrade even it doesn't exist. |
762057 | In rare circumstances if DBCC PSS fails it may leave the pss in a kept state and cause subsequent commands to get fail with error 8601 "Process < n > tried to keep the PSS for process < m > when it already had the PSS for process < p > kept." |
762072 | The messages 'ERROR: JNI_CreateJavaVM; failed attaching to the JVM for AttachCurrentThread() with -1', 'WARNING: FindClassWithLoaderID; is re-throwing Exception' or 'WARNING: FindPublicMethodFlags; is re-throwing Exception' may be reported in the SAP ASE error log, when the PCI memory pool is running out of memory. |
762174 | KBA 2011755. The message, "Current process infected with signal 11", followed by a stack trace that includes the module SearchEngine::_SeFindOptimal may be reported in the error log after a lengthy optimization, most likely after an aggregate with a GROUP BY in which the GROUP BY columns originate from multiple tables. |
762178 | When ansinull is off, an incorrect NULL value row could be returned when an equi-join under an OR predicate is on two columns with NULL values and the final plan is using a special OR strategy plan for the OR predicate. An example of such an OR predicate is "t1.col1 IN (1,2,t2.col2)". |
762199 | The SAP ASE COTS JavaVM version (used for the Java in SAP ASE functionality) is updated to version JRE 7 update 55 for each supported platform in the sybpcidb database. |
762257 | When a dynamic batch insert is executed, an "infected with 11" (SIGSEGV) stacktrace may be reported in the SAP ASE errorlog. The stack trace will reference the functions tdsrecv__process_batchparam() and tdsrecv_dynamic(). |
762262 | ALTER DATABASE set durability no_recover does not show "enhanced performance" status in sp_helpdb output. |
762266 | Under a rare condition, the fix for CR 750937 could cause a performance regression. The fix for 750937 is now only enabled under traceflag 219. |
762281 | The version of OpenSSL used has been upgraded to OpenSSL 1.0.1g |
762349 | The expression -(minimum integer value) does not raise an error. |
762392 | In rare circumstances many processes could get locked when a 'dump database' or 'alter database' command is running. |
762538 | On HP-UX platform, sqlupgrade[res] cannot boot the old SAP ASE if LD_LIBRARY_PATH environment variable is set. |
762625 | An UPDATE statement which doesn't update any row and involves a replicated table with a LOB column may fail with an error 539 state 31. |
762712 | KBA 2010681. When a non-language batch query (e.g. 'if @@transtate = 3 select 3 else select 0') is followed a language batch query which triggers an error (e.g. a query causing parsing error), an "infected with 11" (SIGSEGV) stacktrace to be reported in the SAP ASE errorlog. The stack trace will reference the functions batchparam_save_SQL() and memalloc(). |
762728 | When INSERT INTO SELECT at LEVEL 0 is enabled, SELECT INTO does not wait for locked rows so may return wrong results. |
762805 | The query result of monProcessActivity.WaitTime is not correct in production system. |
762901 | A 3651 error, "This transaction has been rolled back, rather than only the current statement" may be reported when running insert-select query involving proxy table. |
762909 | sp_showoptstats will have poor performance if a large number of partitions are defined and/or a large number of columns have histograms defined. |
762959 | DDLGen terminates when the SAP ASE configuration option 'quoted identifier enhancements' is off. |
762960 | When permission on built-in function is granted to a role which is granted to a user, then executing the built-in function may result in permission error. |
763128 | When RepAgent is in skip mode and meta-data reduction is enabled, if the last log record processed by Replication Server before entering skip mode is a ROWIMAGE log record that contains in-row LOB data, RepAgent may generate timeslice errors. |
763150 | Create login command does not pass the login name to sp_extrapwdchecks. |
763162 | For tables with LOB columns and attribute "dealloc_first_txtpg" set to 1, error 7133 "NULL textptr passed to %s function." will be reported when WRITETEXT command is running with the new text pointer after the LOB column is updated to NULL. |
763166 | DBISQL16/ASE in scrollable table mode, trimmed leading/trailing white spaces from error/warning/info messages, affecting the stored procedure output formatting such as "sp_showtext", where the output consists only info messages. This behavior is removed. Also, in scrollable table mode, previously Messages panel limited the number of messages to 1000 items. This limit has been removed. |
763213 | KBA 2012622. Sybmigrate space estimation report fails with error 291 state 1 "Access to sysdams is disallowed". |
763247 | Using a NOT LIKE clause to compare with a local variable assigned to a constant string could return different results than comparing to the constant string directly if the column has NULL values in it. |
763271 | For the diagserver on Solaris platforms, if SAP ASE is running in threaded kernel mode, setting the configuration option "number of disk tasks" to any value greater than 1 will result in an assertion failure being reported in the SAP ASE errorlog. |
763285 | In rare cases when online utility is executing, concurrent updates may hit error 12319 and terminate the session. /* 12319, EX_CMDFATAL, 1 ** Fatal internal error encountered during deferred dml on table '%.*s' in database '%.*s'. All rows that qualified during the first phase were not visited during second phase of dml. */ |
763289 | sp_monitor inherits permission of exec to public from lower version server (i.e. 15.5) after upgrade to 16.0. |
763351 | In rare circumstances, error message "WARNING - Fatal Error 614 occurred at ... Adaptive Server accessed a row that has an illegal length ..." may be raised if there is "ORDER BY" clause in a query that uses an in-memory temp database. |
763354 | The "Command" column in the query of monThresholdEvent is displayed as "AWAITING COMMAND" when using dynamic SQL. |
763376 | A 6908 error, "During redo the page timestamp value is less than old timestamp from log. Page .. object id = 99, page timestamp=0000 00000000. Log old timestamp=0000 00000001." may be reported during load tran in a database that has been altered with the "async_init" option. |
763415 | The message, "The log for database < dbname > includes a CREATE INDEX (with deferred roll-forward) operation that is incompatible with this server version and operating environment", is not reported as expected, if a transaction log dump from an earlier 15.7 release is loaded and the dump contains a CREATE INDEX transaction that was originally done WITH DEFERRED_RECOVERY=MANUAL or DEFERRED_RECOVERY=NONE. |
763510 | If many queries that use an "ORDER BY" clause are executed concurrently and the "default data cache" is configured to use a large value for the "local cache partition number" parameter, then SAP ASE may run very slowly or even appear to hang. |
763514 | A 2510 error, "Key mismatch between index page < value > , partition ID < value > ;... Drop and re-create index ID < value > of table ' < value > ' in database ' < value > '." followed by the message "current process infected with 11" in the module 'byte_eq' together with a stack trace which includes the modules 'compress_page' and 's_xoltp_dml' may be reported in the error log when an INSERT is executed and while the configuration option "streamlined dynamic SQL" is active. Additionally a 631, "The length of < n > passed to delete row routine for the row at offset < n > is incorrect on the following page of database ..." error will be reported while SAP ASE is rolling back the current transaction. |
763609 | If an upgrade from a SAP ASE server with a version lower than 15.7 SP100 fails to create the table SYSDAMS because it ran out of space, executing ALTER DATABASE to extend the space will fail with the 12324 error, "In database < dbname > , the server failed to open required table 'SYSDAMS'". |
763615 | A 9502 error, "Data exception - string data right truncated", may be reported during ALTER TABLE MODIFY column to NULL with multi-bytes charset and the session property string_rtruncation is set. |
763672 | Update statistics on proxy table mapped to Oracle using DCO may stacktrace at stat_sargden_accumulate if the proxy table contains NULLs. |
763738 | KBA 2016098. A 913 error, "Could not find row in sysdatabases with database id #", occurs while selecting from the MDA table monCachedProcedures when procedure cache contains a procedure that references an object in a database which has been dropped. |
763772 | Conversion to a TEXT or IMAGE column containing nulls in a stored procedure may cause seemingly random stacktraces (infected with 11 (SIGSEGV)) to be reported in the SAP ASE errorlog. |
763794 | When a RID is used to scan a table and the table has defaults that are not materialized, wrong results may be returned. |
763834 | Some system stored procedures inherited permissions from lower server (i.e. 15.5) after upgrade to 16.0. |
763859 | The EQUALS_SCAN_SUPERSET optcriteria hueristic rule is applied to prefer an index with more limiting equi-sarg keys specified over another index with fewer limiting keys, given that the index limiting equi-sargs keys is a superset of the latter index, and that it is also a superset all the limiting sargs and filtering sargs the latter index. However, if an enforcer such as a SORT or XCHG is applied, the index with fewer limiting equi-sarg keys may still be chosen. Optcriteria cr763859 will use the rule hueristic, but it will only apply if optcriteria EQUALS_SCAN_SUPERSET is also enabled. |
763861 | In very rare circumstances, when querying the MDA monOpenObjectActivity table, error 14108 "Could not find partition descriptor for objid < objid > , indid < indid > , ptnid < ptnid > in dbid < dbid > ." may be reported. |
764036 | An UPDATE with a builtin in the SET clause executes ineffieciently as compared to ASE 12.5. |
764060 | The message "current process infected with 11" in the module 'ubffreef' together with a stack trace which includes the modules 'ra_free_mempool' and 'ra__schema_dealloc_obj' may be reported in the error log preceded by a 9685 error, "Rep Agent on database ' < dbname > ' switched from mode 'sync' to mode 'async' because timer on commit expired.", when SAP Adaptive Server Rep Agent is configured to use streaming replication in either near-sync or sync mode. This will result in SAP Adaptive Server to shutdown implicitly. |
764074 | The "Alter thread pool" command may cause an infected with 11 (SIGSEGV) along with a stacktrace that references the function rvm_dispatch() to be reported in the SAP ASE errorlog. |
764121 | The showplan in xml utility could return the strings "Sort (Build)" and "Sort (GetSorted)" for the splitSort operator. These strings generate an XML parser error when running a query that qualifies XML using xmltest. |
764158 | If the secondary truncation point is enabled on the master database on a pre 16.0 server installation, and then 16.0 server is booted against the installation without having followed the required SAP ASE 16.0 upgrade steps (run preupgrade first), then the SAP ASE 16.0 server will fail to boot. The pre SAP ASE 16.0 version will then also fail to boot with the following messages being reported in the ASE 160 errorlog: "server Opening Master Database ..." and "kernel The secondary truncation point is turned on in the master database. Please use your older ASE version to turn the secondary truncation point off before using this ASE version". |
764186 | KBA 2109838. In rare circumstances, the message "current process infected with 11" (SIGSEGV) in the module 'dpdb__dflpurge' together with a stack trace may be reported in the error log followed by the message "Spinlocks held by kpid ... Resource- > rdbt_ext_spin" resulting in SAP ASE shutting down implicitly during the execution of a DUMP DATABASE command and while the configuration option "optimize dump for faster load" is set to 1. |
764274 | In some cases when updates is executed concurrently with DROP PARTITION, MERGE PARTITION or TRUNCATE PARTITION PLM utilities. updates convert to delete + insert. |
764288 | Under a rare condition, if compatibility mode is enabled and when trying to delete a row from a table which has IN ROW LOB, error msg 605 "An attempt was made to fetch logical page ' < n > ' from cache ' < name > '. Page belongs to < ptninfo1 > and not to < ptninfo2 > ." could be reported. |
764402 | KBA 2053674. A 692 error, "Uninitialized logical page ' < value > ' was read while accessing database 'value', object '' (99), index ' < Unknown > ' (0), partition ' < Unknown > ' (99)." may be reported during the execution of either ALTER or CREATE DATABASE command when the "FOR LOAD" option is used and while the database is larger than 63 GB. This may be followed by the message "current process infected with 11" in the module 'buf_cleanup_write_queue' together with a stack trace in the SAP ASE error log which includes the modules 'terminate_process' and 'quitfn'. |
764437 | KBA 2021875. A 2956 error, "Unable to grab a buffer to encrypt logical page < page_num > in database < db_id > . Increase the size of the buffer pool in the buffer cache < cache_name > ", may be raised to report buffer shortage when large transactions are executed on an encrypted database. |
764438 | There is a potential for high statement cache spinlock contention when the statement cache is full and all/most of the statements are pinned by a SPID. This may result in significant system sluggishness. Dumping the monitor counters shows that proc_ssql_not_found is relatively high while proc_ssql_procs_available is relatively low for an interval in addition to the SSQL_CACHE spinlock counters being high and possibly negative due to overflow. |
764448 | Support the migration of ASE stored procedure to HANA procedure |
764509 | Modularize output from sp_help, sp_helpindex and sp_helpartition to provide terse output which is useful for tables and indexes with large number of partitions. |
764543 | Backup Server may log false page verification errors with a message "Incorrect column type in the offset table of row x in page xxx of object ID xxxxxxxx." when executing dump database command with verify = full on a database with 'allow wide dol rows' turned on. |
764623 | KBA 2020850 . When performing a dictionary decompress for varchar column with character encoding, SAP ASE may report a 9829 error - " Compressed data row < rowid > in objid < objid > , dbid < dbid > is corrupted." |
764630 | Checkpoint sleeps on buffer in encrypted db |
764801 | Under an HADR environment the current task may hang forever in the log drain phase of the deactivation process if the SAP ASE Replication Agent is unable to connect to the SAP Replication Server during the execution of 'sp_hadr_admin deactivate'. |
764830 | When the advanced_aggregation optcriteria is used (typically this occurs when the optimization goal is allrows_dss), then there is a possibility of a wrong answer when a SUM, or AVG aggregate is used on an exact numeric datatype column. |
764843 | When 2-phased sort execution plan (i.e. with SORTBUILD and GETSORTED operators) was chosen, Dynamic Thread Assignment (DTA) was causing exceptions in Linux platform due to synchronization issues supposedly due to thread migration. DTA would internally be disabled for such queries with 2-phased sort which might prevent performance gain for the queries that benefit from DTA. |
764862 | The message text for error 3543 is enhanced to include the database id value such as "One or more entries in the data segment free space counts in database ID %d was found to be negative and has been set to 0." |
764924 | The errors 'Object id wrong' or 'Page mismatch' can be mistakenly reported by DUMP WITH VERIFY if the system is very busy while the database dump is in progress. |
764953 | fact table hint may lead to less optimal plan with huge table ( > = 1 billion rows). |
765065 | The MDA table monRepSyncTaskStatistics is enhanced by adding new monitor columns that provide information on the time spend in the transaction commit processing when using streaming replication in (near) sync mode. |
765074 | A 2546 error: "Table Corrupt: Extent id < extid > on allocation pg# < pg
Read more... Product
SAP Adaptive Server Enterprise 16.0
KeywordsKBA , heiko , 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 pageThis 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 resultsVisit SAP Support Portal's SAP Notes and KBA Search. |