Symptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the service.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. |
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" |
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. |
565321 | In parallel query mode, monProcessWorkerThread.ThreadsActive, monProcess.NumChildren, monSysWorkerThreads.PlansAltered and monProcessStatement.PlansAltered are always 0. |
569808 | In rare circumstances, the message "current process infected with 11" in the module 'adb__reserve_pg' together with a stack trace which includes the module 'adb_dirty' may be reported in the error log after the load of an archive database. |
578515 | sp_sysmon appl_and_login does not show the detail of activity by application name and login name. |
584647 | The values in "Default", "Config value", "Run Value" columns aren't right aligned when the sp_configure command is executed. |
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. |
636677 | Improve efficiency of spinlocks on the AIX platforms. |
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." |
642038 | On Platforms other than x86 Linux and Solaris Sparc, the rdesmgr_spin spinlock was hot in some scenarios. |
646013 | When creating local index on semantic partitioning table, mapping between index partitions and datapartitions is not guaranteed in the same order of semantic partitioning boundary. |
649701 | Previously diagnostic information was available for error 290024 - invalid column. Due to possible performance issues, we now print it only if traceflag 2779 is set. |
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. |
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. |
666556 | Performance of sp_spaceused procedure is very slow when executed to get the space metrics for the entire database, especially so for databases with a very large number of objects and indexes. Improve the performance of this procedure by applying server-side changes along with a re-work of the procedure's logic. A new installmaster along with new ASE binary is needed to deliver this performance improvement. (The stored procedure changes alone are not sufficient). |
667751 | Support for UNIX Domain Sockets for ASE has been added for the Linux and Unix platforms. Adaptive Server Enterprise version 15.7 ESD#4 and later now support the UNIX domain socket communication, which avoids some of the overhead the TCP protocol incurs. Similar to other protocols, include the AF_UNIX protocol in the interfaces file for clients to connect to Adaptive Server. The syntax for an AF_UNIX in the interfaces file is: master afunix unused // < hostname > / < pipe > |
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. |
668790 | An audit process exception error message may occur that reports the incorrect numbers. The full error number is reported as the major number, the severity is reported as the minor number, the state is reported as the severity. |
670273 | In some circumstances, the Operations value in the monOpenObjectActivity MDA table does not reflect the actual number of table accesses. |
670275 | ASE may allow four reader tasks to skip over a queued update task in lock sleep if the readers are trying to obtain a shared intent lock. |
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. |
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. |
676991 | High CPU usage may be seen along with with high rprocmgr_spin contention. |
677826 | When 'enable literal autoparam' is on, executing a dynamic SQL query with numerical literal with precision over NUME_USERPREC(38) could cause errors 2756 and 706. |
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. |
682738 | CIS creates the first text page in an INSERT-SELECT query even though the source data is null. To activate the fix, trace flag 11241 needs to be turned on. |
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. |
685171 | When the set option "timestamp_insert" is enabled, an invalid value may result when inserting a "NULL" value into a timestamp column. |
685874 | A 3250 error, "The devices < value > and < value > specified in the command should be differnt" may be reported if the devices name length is more than 127 bytes when running a DUMP DATABASE command. |
688352 | Using Replication Agent with the 'meta data reduction' option enabled can result in a large number of 'remove table' commands being send towards Replication Server. |
688481 | The message "current process infected with 11" in the module sdes_num_in_chain() together with a stack trace which includes the modules kill_proc() and LeExecSqlFunc() may be reported in the error log if a long running user-defined SQL function session gets killed. ASE may need to be rebooted following this error. |
688495 | If a new instance is dynamically added to the cluster in SDC mode, it may not be able to join the cluster when no other activity is taking place in the cluster. |
689230 | The message "current process infected with 11" in the module "uwdisconnect" may be reported in the error log when a DBCC CHECKSTORAGE was aborted by CTRL+C or client application was killed. |
689990 | Using "SET STATISTICS" type tracing without appropriate user permissions can result in a stacktrace in OptGlobal::_GblSearchEngine(int*) being reported in the ASE errorlog. |
690437 | Expression subquery was always evaluated as part of the aggregate input expression even when the subquery is under CASE expression and the actual execution of the CASE doesn't need the result of the subquery. This could lead to unexpected exception during the unnecessary execution of the subquery. |
690533 | A wrong result could happen for an equi- join between two columns with different datatypes (such as INT2 = INT4) and there are two or more OR predicates (including IN list predicates) on one of the joining columns. |
692509 | sp_sysmon 'cache wizard' got Msg 3606 "Arithmetic overflow occurred" |
692870 | Enable pinning of dynamic SQL query plans via the configuration option 'dynamic SQL plan pinning'. This is a productization of trace flag 480. |
692873 | ASE client connection (sometimes a replication agent connection) hangs in a call to ct_cancel with the message, "kernel usrcancel: request structure in use", reported in the errorlog. |
693355 | When the ASE ESD number is not an integer (e.g. 1.1, 4.1 or 5.1 etc), then anything using the sp_versioncrack stored procedure (e.g. sp_spaceusage) may encounter a 249 error (conversion error). |
693775 | Job Scheduler is enhanced to execute job from startdate:starttime to enddate:endtime under new schedule property 'continuous_run'. |
694912 | Exception is raised from localize command in sybcluster if ASE-15_0/locales contains unnecessary files/dirs. |
695557 | Allow a nondefault sql.ini location to be specified in dbisql |
696676 | When a query with IN list chooses a special OR strategy, the query plan still shows a RESTRICT operator which is superfluous and can be quite expensive up to 35% |
697125 | When using sp_downgrade to downgrade from 15.7 ESD#2 or later version of SDC server to 15.x SDC server, prepare will fail and raise message "One or more databases still permit wide DOL rows." on local system and global temporary databases. |
698089 | A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database '%.*s' (id %d)" may be reported under some circumstances when Adaptive Server has been booted with trace flag 3608, shutdown after some operations and then restarted in normal mode. |
698657 | The error 'Invalid RPC sequence at RPC as_cmd' may be reported by the Backup Server when a dump is attempted using a remote backup server and the local interfaces name is different from the remote backup server start-up name. |
700034 | A parameterized varchar column in the SELECT lists combined by a UNION (ALL) clause in the derived table may return unexpected trailing spaces if statement cache is enabled. |
700227 | Reduce additional logging done on page compressed DMLs for replication support, trigger support, and online utilities support. |
701299 | Implement variable network packet size for better performance. |
701705 | New monitors have been added to collect each engine resource's Engine Local Caches (ELC) performance. |
702339 | After upgrading to release 15.7 ldap logins fail. Initial attempt fell back to ase login. Next attempt received 'Server is unwilling to perform'. |
703123 | Predicates that contain more than 128 or- terms in a disjunct may not be optimized using a general-or strategy. In cases where such a general-or strategy provides the only efficient search strategy, query performance could be poor. |
704679 | DISK REFIT fails to restore 'durability' and 'crdate' column information in sysdatabases system table. |
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 |
705093 | Extensions to the Remote Backup Server name feature allowing to be specified as 'hostname:portnumber'. |
706543 | sybmigrate and DDLGen fail when there is "&" in the object name |
706581 | The message, "current process infected with signal 11", together with a stack trace involving the function prot_view_decdef_cols() may be reported with a complex query when access is made through a VIEW and the accessed columns are encrypted with decrypt_default. |
706777 | The message text for error 9262 has been changed to report the database name and ID values such as "A Rep Agent Thread for database ' < dbname > ' (dbid= < value > ) is already running". |
707065 | In rare situations, a 1514 error might occur while creating the index with a reserved page gap. |
707411 | In rare cases with tables having non- unique indexes with huge duplicates, the index might end up having lot of near empty pages. |
707783 | When using traceflag 7738 to enable statement cache user id sharing, sometimes an error 622 (Opentable was passed a varno of ...) may be raised if compatibility mode is also enabled. |
708058 | Extend sp_helpconfig to support a new "estimate" clause to estimate the size of 'compression info pool size' config option based on other config parameters, or user-overrides. |
708071 | In ASE Cluster Edition during instance failover recovery, the checkpoint process may be blocked by the threshold manager process that is doing free space accounting recovery for a large database that has the "trunc log on chkpt" database option turned on. |
708240 | For RTC (run to completion) threads such as syb_system_pool & syb_blocking_pool, values from monThread for BusyTicks shows it is alway busy. It is corrected to reflect work done. |
708273 | For an update query with instead of trigger, if it updates numeric column, it could return wrong result if literal autoparam configuration parameter is turned on. |
708356 | Invoking the reog rebuild command on a table with a bracketed identifiers will generate a warning claimin an Abstract Plan (AP) syntax error. |
708798 | In specific circumstances involving execution of a stored procedure under execute immediate in combination with additional statements it is possible for the following error.. CT-LIBRARY error: ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read ..to be observed when using isql or any other ct-lib client and the subsequent statement (after the execute immediate) to not be executed. The issue only arises under very specific circumstances when certain statements that are deferred for compilation at runtime have to be compiled when under an execute immediate. |
708821 | Checktable and Checkdb report an error that "An invalid 'data row id' value was found in first text page of a text/image/unitext column." for replicated DOL tables that have text columns with values on forwarded rows. |
708876 | When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of commands that are needed to create a target database with the same layout as the source database. |
708900 | In rare circumstances, when a query involves join with many remote tables, a message "current process infected with 11" in the module 'sdes_hookup' together with a stack trace which includes the modules 'omni_remote_name' may be reported in the error log. The problem occurs when 'showplan' is on or 'plan text pipe active' is configured to 1. |
709060 | When creating a cluster or adding an instance, sybcluster cannot detect invalid device name immediately after it is entered. |
709184 | Improve UTF-8 sort order 25 performance for well-formed UTF-8, under sp_configure parameter "enable permissive unicode". |
709255 | In some rare case, it could stacktrace when we print query execution info or final plan in XML. |
709453 | If an application passes an invalid TEXTPTR to different LOB-related T-SQL commands (e.g READTEXT, WRITETEXT, TEXTVALID, etc) for an IN-ROW LOB, sometimes the command may report fatal 605 or 625 errors. |
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. |
709510 | Enabling I/O fencing may result in "reservation conflict" messages in the system log. |
709572 | A 301402 error, "Backup Server: 3.14.2.4: Logical page < page_number > is not in the given database map.", may be reported by the Backup Server during the execution of LOAD WITH VERIFYONLY on a database whose size is bigger than 2147483647 pages in an ASE installation that uses page size greater than 2K page. |
709651 | A number of different errors and stack traces might be seen in the error log in an ASE CE system after executing ONLINE DATABASE on one instance, having loaded one or more dump that were taken on an earlier version of Adaptive Server compared to that into which they are loaded, on another instance. |
709721 | When an in-row LOB column which has both data compression and LOB compression properties defined has its schema changed by setting the LOB compression property to not compressed, ASE following a SELECT query execution may return incorrect results for this column for data that was inserted into this column before the column schema change occured. |
709805 | In some case, downgrade could cause memory corruption issues and stacktrace. |
709963 | If a union view creator does not specify the owner of base views, it could get error msg 225 if the same base view name is created by an sa and the union view creator. |
710240 | Sybmon would report a signal 11 error when the quite command is executed on 32bit or 64bit windows platform. |
710300 | Deploy plugin raises an error but reports that it succeed |
710430 | A histogram with a range cell at the very end of the histogram may have the weight of the lower bound of the cell incorrectly added to the last cell. Range cells by convention are exclusive of the lower bound of the cell. This may result in mis-estimates and poor query plans when predicates in queries reference the lower bound value. This is especially true if the lower bound has a high row count associated with it. |
710495 | On Linux platforms, monThreads.OSThreadID is sometimes reported as a negative number that does not match the OS reported thread ID. |
710496 | When Replication Agent is enabled to use the multipath distribution per connection model, and if the option "ddl path for unbound objects" is set to "default", it is possible that DDL commands are replicated to the incorrect path. |
710536 | Data may be corrupted during page compression if there is a compressed in-row LOB column in the table. |
710589 | Column statistics histogram may be skewed in the last histogram step if the total sampling row count is greater than 2,147,483,647 when updating statistics. |
710594 | DBT_SPIN is hot when there are lot of queries or stored procedures that work across multiple databases. |
710693 | For the jobs having repeat interval of one minute, if job creation time is less than starttime of job, second execution of the job is missed. In addition, for the jobs having repeat interval of one minute, if starttime is greater than or equal to endtime, alternate executions of the job are missed after midnight till endtime. Finally, for the jobs having the same startime and endtime with any repeat interval, the job starts executing before starttime if startdate is same as job creation date. |
710754 | When sort_resources is on, negative row count maybe be reported when executing CREATE INDEX, UPDATE INDEX STATISTICS or UPDATE ALL STATISTICS on table with more than 2147483647 rows. |
710843 | While running a batch of ADD or DROP constraints out of which a few fail due to valid reasons, the subsequent ADD/DROP constraints may fail with the error 4956. |
710847 | The error messge, "Page Verification Error: Virtual page < page_num > in device < dev_num > is out of database range." may be reported in the Backup Server error log as a result of a LOAD DATABASE command. |
711008 | ASE becomes unresponsive, ASE's network controller thread loops consuming 100% of one cpu |
711106 | OPTDIAG and sp_showoptstats has been enhanced to support Precomputed Resultsets. |
711168 | In rare circumstances, when the ASE configuration parameter "disable varbinary truncation" is set to 1, a delete from a DOL table which has a unique index which has varbinary columns may hit a 644 error, "Index row entry for data row id (Pageid, Rowid) is missing from index page < page id > of index id < index id > of table < table name > in database < db name > . Xactid is ( < Transaction Id > ). Drop and re-create the index." |
711170 | When enabling the RepAgent configuration parameter 'activate monitoring', after stopping and restarting the RepAgent, the setting automatically reverts back to 'disabled' mistakenly. |
711220 | DBISQL stacktrace when loading an xml plan generated by sp_showoptstats |
711245 | The stored procedure sp_replication_path 'list' output is enhanced to include information about the default path for a more complete picture of the replication topology. |
711299 | ASE running in threaded kernel mode allows user to decrease the value of 'max online engine' less than the total number of engine threads leading to a boot failure while rebooting the server. A message saying "The total number of mux threads X is exceeding cmaxonline Y." may be reported. |
711328 | Using sybcluster to add an instance in interactive mode failed. |
711332 | ASE may not be able to start a large number of engines with the ASE kernel configured for Process mode as a Spinlock allocation error can be encountered. |
711412 | When the user is running a batch query with a temp table creation outside a stored procedure, and execute the stored procedure referencing this temp table, the procedure will be renormalized each time. When there're many processes calling this batch query at the same time, random signal 11 stack traces will be observed. |
711453 | Permissions through roles granted to non- default login profiles can be lost or reduced if there exists a default login profile that has not been granted all the roles that the non-default login profile has and a permission changing event (such as a grant or revoke) occurs in the server. |
711494 | Server hang when executing ALTER TABLE spt_TableTransfer SET TRANSFER TABLE OFF. |
711654 | The ASE errorlog may contain many instances of the kernel message "Expected object passed to blkioDescriptor is not of type BLKIO,..." |
711713 | In rare circumstance, when replicating an off-row compressed LOB column, the replicate ASE may raise the 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end." and Replication Server will abort the connection. |
711819 | Replicating a SELECT-INTO statement fails when the source table contains quoted column names. |
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. |
711953 | When attempting to execute a stored procedure in a database that the user is not a user in two error messages will be displayed stating that the user is not a user in the database. |
711978 | A segmentation violation can occur when configuration parameter "suspend audit when device full" is set to 0 after the audit segment becomes full. |
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. |
712258 | TOP N syntax is not shipped to the IQ server. |
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. |
712531 | In rare circumstances the query on FDP table might get some uninitialized data after the FDP table is re-sized. |
712541 | sp_displayrole does not report expired password. User get error 11176. |
712554 | The message "infected with 11" together with modules like "tdsrecv__dynexec" and "sequencer" if using jconn3.jar with text/image datatypes and an ASE157 releases. Often, message 3805 will be reported too. |
712636 | Too many steps may be created for a histogram when parallelism is used during create index or update statistics. |
712783 | When multiple queries are executed on one of the MDA FDP Tables with Adaptive Server Enterprise Cluster Edition the same row may appear in the results of multiple queries. This is not expected since the FDP tables should not present the same row in multiple queries. |
712808 | In some cases, DBCC CHECKTABLE may report error message 7948 after a clustered index is created on a compressed APL table which contains only 1 row. |
712855 | Invoking the soundex() or difference() built-ins on unichar/univarchar strings larger than 127 characters (254 bytes) may cause the process to be terminated. |
712897 | sp_bindcache information is missing from DDLGen output. |
712903 | Idle connections may fail to migrate during instance shutdown. |
712940 | Complex queries (often with a large number of group-by columns and a large number of joins where generally each grouping column belongs to a different "joined" table) may SEGV after generating a 331 error terminating the session. The 331 error is raised because the query has exhausted the sort id namespace. |
712949 | When dbcc page() for text page with print option 3 or 4, the output may be out of the range of the page size or hit infinite loop, also, if dbcc page() for text page with print option 1, 3 or 4, it may report a corrupt row message. |
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. |
713291 | In rare circumstance, error 1204, "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", and error 5619, "Adaptive Server internal error. Could not obtain count of in-doubt transactions for space reservation.", may be reoported when running BCP IN/INSERT/UPDATE on table with TEXT/IMAGE/UNITEXT columns marked replicated. |
713411 | When replicating the value from an LOB column which have both in-row and LOB compression property, if the defined in-row length of LOB column at replicate side is so long that is close to @@maxpagesize, replicate ASE may raise error 7153 'Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.' and Rep Server abort the connection. |
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. |
713481 | Negative row count may be shown in the output of DBCC CHECKTABLE and CHECKINDEX commands if there are more than 2,147,483,647 rows in the table. |
713540 | When the user specifies for dump configurations a default directory for the dump stripes with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when generating the list of load database and load transaction commands that are needed to repopulate the database to a specified point in time. |
713547 | A wrong number of rows may be updated with INSTEAD OF TRIGGER when the base table of the view has predicates defined on it. |
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. |
713631 | Error 832 may be reported when creating an index whose depth is greater than 6 if 'number of sort buffers' is configured as smaller value. |
713707 | The message, "Current process infected with signal 11", together with a stack trace which includes the modules 'bi__xml_query' and 'bi_xmlextract' may be reported in the error log when an external KILL signal is issued to a regular XML query session. |
713728 | After upgrade from 12.5 to 15.7 ESD#1 or later version, if the 15.7 server is SMP server, "allow wide DOL rows" option is missing on tempdb; if is SDC server, this option is missing on the local temporary databases. |
713800 | With plan sharing enabled, and under heavy workloads consisting of concurrent queries that qualify for query plan sharing, some shared plans may be prematurely terminated. |
713840 | 'dbcc markproc' was failing with error 12309 : Expanding update on object was failing on page due to insufficient free bytes. |
713848 | On the Solaris platform, when ASE is running on a 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. |
713855 | When migrating from Adaptive Server versions 12.5.4 or 15.0 to version 15.7 ESD #2 using sybmigrate, the execption, "Failed to add the role 'sa_serverprivs_role' into the current database catalogs", may be raised. |
713881 | A 9830 error may be reported when inserting a row into a table with compressed data. |
713945 | In some circumstances, the message "current process infected with 11" in the module 'LeScanOp::_LeOpRelease' together with a stack trace which includes the modules 'LeUnionOp::_LeOpRelease' and 'LeEmittOp::_LeOpRelease' may be reported in the error log after an error message 716 if the query involves a UNION ALL clause. |
713950 | A stacktrace may occur when using UPDATE STATISTICS with HASHING on character string datatypes which have a non-binary sort order, and there are more than 65535 unique values. |
714034 | DBCC CHECKTABLE or CHECKINDEX may report error 803 if the index is very deep. |
714061 | Forwarded row count in the SYSTABSTATS for a table that underwent 'REORG REBUILD < tabname > WITH ONLINE' may be incorrect. |
714086 | In some cases, if a union query involves concate varchar type of variable, it could return wrong result due to unexpected truncation. |
714131 | In some customer scenarios with stored procedures or sql accessing multiple databases, rdbtmgr_spin would show high contention. |
714153 | Parallel index creation may fail because of error 832 if 'number of sort buffers' is configured as very small and the index depth is very large. |
714217 | Supplying an overflow or underflow search constant to a query on a proxy table may return incorrect result. |
714306 | When 'literal autoparam' is enabled, it could raise an error if a query has a literal in order by clause such as ' ', 'a' and the query was cached in statement cache and it needs to be recompiled. |
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. |
714355 | It is difficult to understand just what 'dbcc markprocs' in sp_downgrade is doing, so replace the statement in sp_downgrade with a more understandable SQL update. |
714478 | In some rare case, if a plan has a Hash operator in it, it could cause stacktrace in LeHashInputSet::releaseExtents(), LeHashOP::LeOpSaveIOStates() when a stored procedure or a cached statement is executed multiple times and its plan has LeHash operator. |
714612 | A 2846 error, "SQL function 'dbo.sp_ < function name > ' not found. Specify owner.objectname or use sp_help to ..." may be incorrectly reported when a SQL user defined function created in sybsystemprocs database with a name prefixed by "sp_" is invoked from a database while a open transaction in the same database is creating a stored procedure, view, trigger, rule or default. |
714638 | monEngine connections column is wrong for kernel mode threaded. |
714670 | sp_downgrade_esd does not report tables which are configured for in-row LOB compression. |
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). |
714798 | On AIX platform, ASE Cluster Edition may fail to start if logical volumes are used and I/O fencing is enabled. |
714806 | When ASE is shut down using the 'nowait' option and while data is loaded using fast bulk-copy into a table that is created with the 'fot load' attribute, on ASE restart some data my be lost. |
715086 | When shutdown cluster is issued from one instance, busy user tasks running on other instances may be immediately terminated. |
715094 | A 716 error, "Unable to allocate memory of size %d bytes from the '%S_MSG' pool" may be reported when querying a partitioned view including compressed tables many times. |
715183 | The replication of a stored procedure for which a 'request function replication definition' has been created fails with Replication Server error 5157 indicating that the transaction owner's password is missing. |
715228 | Wrong result could happen when referencing a non-correlated scalar aggregate view at the inner side of an OUTER JOIN. |
715234 | On AIX, the monThread MDA table incorrectly indicates that the Listener thread is consuming 100% CPU. |
715240 | ASE Cluster Edition allows user to create thread pool when "max online engines" is not sufficient. |
715670 | CS_IODESC.name has view name instead of table name for LOB column. |
715785 | Signal 11 in set_password or sync_password |
715835 | Modify auditinit utility to create log file with 600 permission, instead of user's umask. |
715967 | auditinit utility requires user to enter non-null sa password for existing ASE. |
716166 | A 12324 error, "In database 'dbname' the server failed to open required table 'syspartitions'. Please contact Sybase Technical Support." may be reported during the execution of either LOAD DATABASE or USE < database > commands when ASE is requested to calculate threshold information by performing OAM scans. |
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. |
716284 | asecfg core dumps when started on Solaris x64. |
716349 | In some cases, ONLINE DATABASE or DBCC CHECKDB executed on a database with large number of compressed objects might fail with error 716 (Unable to allocate memory from the compression info memory pool), when the 'compression info pool size' configuration option is set too low (e.g. the default value of 4096). |
716457 | The ASE Backup Server process has a memory leak when dumping and loading databases, which causes it to grow until it exceeds the memory limit. |
716567 | A query having MDA table monProcessObject caused signal 11 in routine mda__process_sdes() with an invalid SDES in a cursor. This CR seems a concurrency issue since another session was doing 'OPEN CURSOR' and the related internal cursor structures might be changing. May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject. |
716618 | When use TF7751 and TF7752, sometimes it could cause stacktrace during plan printing. |
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. |
716679 | When network password encryption is used and sp_passwordpolicy option 'unique keypair per session' is set to 0, client connections will fail with error message: Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line CT-LIBRARY error: ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED. |
716720 | Remove error # 12061 when a query is executed on an MDA Table that contains localized message text when the client is configured to use a language into which the MDA Table messages have not been translated. Specifically, if the client language is set to 'german' error 12061 will no longer occur when a query is executed on the monWaitEventInfo table. |
716798 | select involving aggregates and having predicated privileges defined at column level on the table could result in wrong results. |
716870 | Adaptive Server may not kill a task that is marked for termination, which is reporting shortage of buffers in buffer pool like "cache is configured too small for current demands". |
716960 | ASE fails to boot on Windows Server 2012 with a stacktrace containing kiprint_os_version() on the stack. |
716981 | When the configuration option 'number of network tasks' is set to greater than 1, ASE running on HP-UX may hit infected with signal 11 (SIGSEGV) in module kstcpnetctlrCancelRequests. |
717026 | Improve spinlock efficiency on Solaris SPARC platform. |
717050 | A 3502 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled." may be reported during the installation of an ASE ESD release on top of 15.7 ESD #1 version while 'instmsgs.ebf' is installed and ASE uses a dump configuration. Alternatively when ASE uses a dump configuration the execution of "DUMP TRANSACTION < database > WITH NO_LOG" will fail. |
717079 | The ASE COTS JavaVM version is updated to version JRE 6 update 33 for each supported platform in the sybpcidb database. |
717212 | An infected with 11 (SIGSEGV) stacktrace in statinit soblddolpages occurs when trying to ALTER TABLE to add a column to a table with indexes. |
717224 | Execution of sp_sysmon by a user other then "sa" can result in error 4066 when "sa" login is locked. |
717232 | When using update statistics with hashing there may be a stacktrace when the number of unique values in the column is greater than 65535. |
717481 | If with hashing is used, and the column has more then 65535 unique values then there is a possibility that the sarg density and unique count for the column are under-estimated. |
717491 | Importing data in DBISQL by selecting Data - > Import from a database menu option, fails with password length issue JZ002 |
717496 | ASE returns error message (Msg 16341, Level 19, State 1) when split a range partitioned table when partititoning filed is a VARCHAR, DATETIME fields. |
717574 | Event ID 178's description is updated, it is wait time for client connections. |
717610 | when using hash-based statistic gathering, the default column width should be used for fixed length columns instead of being computed. |
717627 | sp_showoptstats would always display 4.00 as the default average width for any fixed length column |
717662 | When using fast logged bcp to insert data into a table that is marked for replication and has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated. |
717740 | Bcp-in was failing for a table with columns more than 128 column and having one of them as text column. |
717828 | A 9254 error, "Could not locate schema version for object id '0' in the transaction log." followed by a 9204 error, "Could not locate schema for object with id = (0), current marker (0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum and the ‘multipath distribution model’ is enabled. This will result in the Rep Agent Thread shutting down itself. |
717879 | When a set role command is executed within a procedure or SQLUDF, it takes effect during the context of the procedure or UDF only. |
717910 | When the built-in function GETREPDEFMODE() is called in a query involving a table, an error 622 may be reported together with a stack trace in the error log which includes the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'. |
718133 | If more than one process tries to materialize a deferred table, they all will be stuck in a deadlock and only one process would succeed causing all others to rollback. |
718191 | Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table. |
718206 | If the master database has a secondary truncation point set during an upgrade from 15.0.1 to 15.7, an error 950(Database 'master' is currently offline. Please wait and try your command again later) will be raised during the upgrade. |
718261 | Running sp_monitor will lead to an error 2812 raised via sp_monitor_server. |
718284 | An 823 error, "I/O error detected during wait for BUF= < value > ... cid=0 ('default data cache') ... " may be reported when an ASE 12.5.4 database dump is loaded into an in-memory database and while ONLINE DATABASE is run. This will result in a database upgrade failure. |
718440 | When executing sp_dboption without any parameters to list database options, the output is hard to read due to a lot of empty spaces. |
718466 | A 1508 error, "Create index aborted on duplicate rows. Primary key is 'spinlock_p, -32768'" may be reported when running sp_sysmon and sp_sysmon runs very slowly. |
718587 | A task deleting rows from a DOL table in an in-memory database might wait indefinitely for an EX_LATCH by holding the SH_LATCH on the data page. |
718628 | Signal 8 can occur when the "update statistics hashing" configuration parameter is used |
718637 | Parallel queries with the following query plan scenario MIGHT fail with a "Command has been aborted" message and no other warnings/errors reported in the error log: (1) There is a merge-join op where one of its child trees contains a replication exchange operator. (2) There is no "draining" operator (e.g. sort operator) between the merge-join and the exchange operator. (3) The merge-join's other child drains its input stream before the child with the replication exchange does. |
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. |
718696 | When an AP plan clause is specified as part of a dynamic SQL prepare statement, the plan clause is not saved in the statement cache when such statement is cached under ‘enable functionality group’ or ‘streamlined dynamic SQL’. |
718710 | The message "current process infected with 11" in the module 's_begupdate' together with a stack trace which includes the modules 's_execute' and 'execproc' may be reported in the error log when a stored procedure executes a DML statement which was compiled at runtime. |
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) |
718778 | The message "current process infected with 11" in the module 'ra__process_xchange' together with a stack trace which includes the modules 'decompress_row' and 'decompress__crow_to_apl' may be reported in the error log, after an alter table with no datacopy command is run on a table that has compressed data, and while the replication agent task is attempting to decompress data to be sent to the Rep Server. |
718876 | sybdiag fails with an unhelpful error on Solaris when the SYBASE_JRE6 environment variable is not set |
719019 | An argument to error message 103 (The < msg > that starts with ' < string > ' is too long. Maximum length is < n > .) is too long. The argument needs to be truncated. |
719023 | The error message "A00: SYBMULTBUF ERROR: Internal error: The number of archive strings in the database info file exceeds the maximum number of allowed stripes." may be reported by the backupserver when an attempt to execute a DUMP TRANSACTION command with many STRIPE ON clauses is made. |
719124 | ALTER TABLE SPLIT raises errror 16341 for range partitioning when it is based on DATETIME values. |
719138 | The ASE server fails to boot on the HP-UX IA64 platform in Process mode if Kerberos is enabled. |
719162 | When using fast logged bcp to insert data into a table that is marked for replication and has compressed TEXT/IMAGE/UNITEXT columns, the compressed TEXT/IMAGE/UNITEXT data may not be inserted successfully and the bcp command fails. |
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. |
719290 | 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 an 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". |
719361 | The reported database name is truncated to 20 characters when executing sp_dbrecovery_order for a database with database name longer than 20 characters. |
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". |
719389 | In sybmon, shared memory dump will not be compressed if "memory dump compression level" is set as 0 although the "memdump compress" command is executed explicitly. |
719399 | When the followng three conditions are met: - the SQL statement has enough predicates to generat at least 400 SARGs and - the SQL statement is executing at isloation level 0 (dirty reads) and - a unique index with at least 10 columns is chosen by the optimizer to use for repositioning the scan, A 702 error can be raised with the function, setupSargArray in the call stack. |
719449 | Adaptive Server may encounter a storage access violation error when query execution is interrupted or some special query is executed on 64bit diagsrvr.exe or 32bit sqlsrvr.exe on windows platform. |
719532 | When GP (Granular Permissions) is enabled, booting ASE could result in a 10331 (Permission denied..) error. |
719560 | On ASE Cluster Edition Solaris platform, when a user with sa_role executes 'set role sa_role on' followed by 'alter thread pool' command, the login connection hangs with following message in the error log: "There is no thread pool named '' defined in the system." |
719597 | Report the compressed shared memory dump file size and configuration setting in the sp_shmdumpconfig stored procedure. |
719616 | When ASE Cluster Edition is configured error message 969 "You can access database ' < db > ' only from its owner instance.." is not being raised when the sp_ddlgen_permissions stored procedure accesses a tembdb on another instance. Errors such as 567 "You must have the following role(s) to execute this command/procedure.." or 17230 "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure" were reported instead. |
719639 | The message "Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt." may be reported when attempting to replicate data after an alter table drop column with no datacopy command is run on a table with LOB data. |
719643 | If hash based statistics collection is used with a large number of steps, then a stack trace in the function ups_stat_memalloc() may be encountered. |
719673 | A 14108 error, "Could not find partition descriptor for objid %d, indid %d, ptnid %d in dbid %d" may be reported when running DBCC DBREBOOT if traceflag 12315 is off. |
719678 | Under some circumstances, in a Shared Disk Cluster environment, sessions may hang because space usage on the segment has been put incorrectly in a freeze state, owing to threshold manager limits being mistakenly hit when they should not have been. |
719683 | A 3223 error, "Attempt to read a dump header failed; returned error code is 12." followed by a 3208 error, "Unexpected end of file while reading beginning of dump. Please confirm that dump media contains a valid ASE dump. The ASE error log may contain more information on the problem." may be reported due to a corrupted dump header while loading a database dump that was taken on ASE 15.7 ESD#2 and the database was created with a template. |
719722 | The values for the IOTime column in the monIOQueue table are incorrect. |
719752 | When GP (Granular Permissions) is enabled, booting ASE could result in 16802 (You must have the following permission to execute this command/procedure..) error. |
719838 | Executing the incorrect syntax 'grant execute on set_appcontext to < user > ' causes a system exception (signal 11) referencing 'grrev_nullflush'. The command should be 'grant SELECT ...' |
719859 | If data row decompression is used, then update index statistics may be slower since an unnecessary data row decompression is performed. |
719911 | DDLGen is not backward compatible for archive databases in ASE 15.7 ESD#2 |
719915 | DDLGEN fails to include the LOB_COMPRESSION attribute when run on a database that was upgraded from ASE 15.0.3. |
719961 | Under some rare cases, a signal 11 (SIGSEGV) could occur in open_byname() when executing nested stored procedures. |
720139 | When doing upgrade using upgrade utilities or downgrade for such databases which name contains blank or tab character, upgrade utilities or sp_downgrade/sp_downgrade_esd will report syntax error on the database name. |
720162 | When the system stored procedure sp_help_rep_agent is executed with no parameter or a null value for @dbname, error message 18374 may be unexpectedly printed with an empty database name. |
720224 | Errors 7961 and 2759 are raised when a variable is used in a GRANT ROLE predicate definition. The errors are raised correctly but the wording is cryptic. |
720313 | ASE 15.7 fails to start during upgrade from ASE 12.5 due to the lack of enough ASE kernel resource memory being reserved. |
720417 | If the user does not have sso_role when running installmaster, the message "You must possess System Security Officer (SSO) role to run the installmaster script" will be displayed when on a Cluster Edition server instead of "You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Suport role and Monitor and Diagnosis role to run the installmaster script." |
720655 | If running:- sp_restore_system_role 'sa_serverprivs_role' after having re-created 'sa_serverprivs_role' and the role id for 'sa_serverprivs_role' is greater than 99, you will receive error 265 Msg 265, Level 16, State 1: Server 'UBUSAP', Procedure 'sp_restore_system_role', Line 202: Insufficient result space for explicit conversion of INT value '100' to a VARCHAR field. (return status = -6) |
720659 | There may be very slow optimisation of queries with large IN clauses or excessive stack usage with aggregate queries with large IN clauses. |
720703 | The first row insertion into DOL table might lead to in-correct emptypgcnt value in SYSTABSTATS due to '0' emptypgcnt set by the task creating the index on empty DOL table. |
720971 | On ASE Cluster Edition, a user connection may not execute the global login trigger. |
720980 | In rare circumstances, ASE might report a signal 11 (SIGSEGV) in collectMonCSInfo() when querying the monCachedStatement MDA table. |
721003 | When downgrade from 157ESD#3 or later version to pre-155, downgrade prepare step will fail with error message "ERROR: Cannot downgrade to '15.0.0.0' server, which does not support bigdatetime and bigtime datatypes." |
721093 | The informational error 16833 was added to extend parallel diagnostics. This error provides a CSMD point to dump the system state at the point that parallel primary error processing begins. At this point, all of the parallel family's state is available for diganostic analysis. |
721144 | If Java in the database is being used, then if the "same" shared configuration file is used by more than one instance or Server, then there is a race condition during JVM initialization where it is possible that the message “current process infected with signal 11” in the function ‘jvminit’ may be reported in the error log, followed by the message “Failed to initialize Java services". This may result in ASE shutting itself down. |
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. |
721278 | A 691 error "Encountered invalid logical page '0' while accessing database ... This is an internal system error ..." may be reported in the error log followed by a stack trace which includes the functions 'set_repdb_status', 'txtimg_upd_table' and 'pg_oamscan_startscan' if a database that has the option "deferred table allocation" set is being marked for replication with SP_REPTOSTANDBY and the 'all' option. |
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. |
721500 | ASE is not able to boot with more than 50 thread pools |
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. |
721559 | On AIX, if ASE threaded kernel mode is being used, then ASE may report a SIGSEGV in mda_nap_start along with a "Scheduler infected: exiting" message in the ASE errorlog. |
721594 | If plan sharing is enabled, an error 8210 "Duplicate of work table descriptor found in the id hash table for temporary object < n > ." with stacktraces including des_wkinstall() and crt_work() may be reported in the ASE errorlog. |
721620 | Msg 2601 duplicate key on 'sysindexes' with unique index 'csysindexes' when dropping and recreating constraint on a partitioned APL table changed to DOL locking scheme. |
721731 | ASE Alarm Subsystem may stop working which can result in "wait for delay hh:mm:ss" to exceed specified time or even hang. This can also cause log records to have stale time values that can prevent "point in time restore of a database" from working. |
721735 | After ASE upgrade, Job Scheduler may fail to boot with error "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." Running "dbcc upgrade_object" on sybmgmtdb resolve the problem. |
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. |
721781 | The value of the 'status' column of most rows of system group in 'sysconfigures' table will be changed from 2 to 386 when upgrading to 15.7 ESD#2 or later version. |
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. |
721889 | When either 'streamlined dynamic SQL' or 'enable functionality group' is configured and a client cursor containing host variables is declared through embedded SQL, and the cursor statement references the same host variable more than once, an error like: -201 : Prodecure < procedure_name > expects parameter < parameter_name > where < parameter_name > is the name of the host variable that appears more than once in the cursor- declare statement, will be generated. |
721959 | Literal auto parameterization of large IN lists may cause performance issues. Trace flag 7786 was introduced to turn off literal auto parameterization of queries with large IN lists ( > 128 constants) as well as avoiding caching of the respective statement. Trace flag 7786 only has an effect if literal auto parameterization is turned on i.e. if literal auto parameterization is turned off, then the statement will still be cached. |
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. |
722547 | On Unix systems the execution of DBCC DBTABLE may report descriptions of DBT3 bits when printing DBT2 bits mistakenly. On Windows systems a stack trace in the module 'prSTAT_str' may be reported in the error log due to a storage access violation. |
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. |
722659 | ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. |
722673 | The execution of the command "DROP PRECOMPUTED RESULT SET < prs_name > " on the primary database cannot be replicated into the standby database successfully. |
722709 | The values of the SharedLockWaitTime, UpdateLockWaitTime and ExclusiveLockWaitTime columns in the monOpenObjectActivity table are incorrect when the DBID, ObjectID and IndexID parameters are fully specified in a query on the monOpenObjectActivity table. |
722767 | The remote backup server name length for DUMP/LOAD commands has been expanded to support more than 30 characters. |
722777 | ASE does not respond and appears to hang when certain invalid packets are sent to it. |
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. |
723026 | In rare circumstances, a stack overflow resulting in stack corruption may occur with a stack trace involving the modules 'XmlMallocFragment' and 'xml_malloc_fragment' when an XML query is executed with insufficent heap memory. |
723116 | sp_sysmon spinlock contention values are incorrectly reported as zero. |
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. |
723250 | Granting an invalid permission to a user will cause the dataserver to print a stack trace and terminate the process. |
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. |
723268 | When granular permissions is not enabled and a user has sso_role if the user tries to online a database error message 2736 will be raised. When granular permissions is enabled a user with online any database privilege can not online a database. |
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. |
723500 | When using Replication Server with HVAR turned on and an update statement against a table on the primary causes non-updated in-row LOB datums to be moved off-row so the new data could fit in the target row, then the LTL generated by Rep Agent may be wrong, and replication may result in those datums being set to NULL on the replicate. |
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. |
723756 | When hash based statistics gathering is used, the histogram tuning factor is not correctly reported by optdiag |
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 is not explicitly generated in the UNION ALL query. |
723861 | During ASE boot in "process" kernel mode, when configured with a high value for configuration parameter 'number of engines at startup', an engine fails to come online with 'ulinitspinlock' error. |
723880 | Column information is unnecessarily displayed when executing sp_help for an object that is not a view, system table or user table. |
723882 | When granular permissions is enabled a user can not online a database that needs an upgrade. The error message 969 will be displayed. |
723984 | Additional diagnostics have been added for hash based histogram gathering under trace flag 2740. |
723986 | After 'reorg rebuild' or 'change lock' an empty table, the emptypgcnt of systabstats becomes 0, which, however, should be 1. |
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. |
724074 | If SET PROXY is used in a stored procedure, then an 4058 error "Login currently under set session authorization. It is required to go back to the original identity before performing another set session authorization." may be reported. |
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. |
724444 | Some web methods added with OVERRIDE clause need to be re-added when ASE WS is restarted. |
724472 | In rare circumstances, recreation of in- memory databases during start up of Adaptive Server may hang when there are more than one in-memory databases with the same template database. ASE can be used, but an attempt to use the in-memory databases that are not recreated will result in error 962, "Database with ID ' < value > ' is not available. Please try again later." |
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'. |
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. |
724987 | A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database < dbname > " may happen under rare circumstances along with the below message in the errorlog:"ERROR: Can't get a new log page in db < dbid > . num_left= < numlogrecords1 > num_in_plc= < numlogrecords2 > ". |
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'. |
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. |
725211 | ASE engines may start consuming 100% CPU which can result in ASE being unresponsive. New client connections may not also be possible. |
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. |
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. |
725810 | The message "current process infected with 11" in the module 'th_curunreservedpgs' together with a stack trace which includes the modules 'LeRun' and 'exec_lava' may be reported in the error log 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. |
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. |
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. |
726003 | In the cases of extreme heavy loading, it is possible that CREATE CLUSTERED INDEX in parallel on a big table causes a small volume of data to be lost. |
726004 | On Solaris SPARC, HP-UX and AIX systems an incorrect result may be reported when executing sp_tran_dumpable_status < dbname > . |
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 | 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. |
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 | Enhancement is made to reduce the use of MASTER..SYSDATABASES scan 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 JA 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. |
727259 | A 9284 error, "RepAgent( < dbid > ). Cannot allocate < value > bytes of memory. You may need to reconfigure the parameter 'replication agent memory size' with more memory.", followed by a 9219 error, "RepAgent( < dbid > ): Internal coding error. Rep Agent Thread for database ' < name > ' (dbid = < value > ) terminated abnormally with error. (major 92, minor 19)" maybe be reported in the error log if the Rep Agent Thread is recycled many times and compressed data is replicated. |
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. |
727786 | After preparing an object or a database for a shrink operation, setting up replication with 'use_index' option at database, object or column level, internal indexes for replication are not created, replication of off-row columns will still proceed as before. |
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. |
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 | 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 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. |
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. |
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. |
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. |
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. |
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) |
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 | 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 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. |
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. |
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. |
730953 | The global variable @@tranchained shows inconsistent value when "SET CHAINED ON" is executed in the login trigger. |
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. |
731026 | Certain stored procedures created with "execute as caller" may encounter errors at execution time. |
731065 | 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. |
731531 | Enhancement is made to use less SYSTYPES scans when creating table. |
731617 | 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. |
731758 | When executing UPDATE STATISTICS with an object name that contains unusual characters, the command may fail with an internal error. |
731783 | The message, "An internal memory management error has occured. 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. |
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. |
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". |
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. |
733305 | An ASE spid with remote I/O may hang when killed. Even reissuing the kill does not help. |
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. |
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). |
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. |
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. |
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. |
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. |
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 |
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. |
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). |
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. |
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. |
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. |
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 | isql client may hang, or wrong TDS token error may be reorted by isql client, when running concurrent SELECT cmd and DELETE/UPDATE cmd on TEXT/IMAGE/UNITEXT columns |
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. |
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. |
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. |
735567 | The Backup Server is enhanced to perform consistency checks on Data Only Locked (DOL) index pages besides data pages during DUMP DATABASE execution. |
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. |
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. |
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. |
736626 | 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' 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. |
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". |
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 the existing column value, the update may fail. |
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. |
737697 | Lots of 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" may be reported in the errorlog when running UPDATE INDEX STATISTICS with SAMPLING command. |
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. |
737824 | The 18124 message, "No matching configuration options" may be reported when executing sp_configure "solaris async i/o mode" |
737907 | If the server crashes in the middle of SHRINKDB, the segmap number on sysusages table may not be updated to 0. |
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. |
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. |
738652 | The error 3105, "Data on dump will not fit into current database. Need # Mbyte database." could be incorrectly reported by LOAD TRANSACTION, if the database has more than 2147483648 pages and the size of the dump is smaller than that. |
Read more...
Environment
- AIX 64bit
- HP-UX on IA64 64bit
- Linux on Power 64bit
- Linux on x86 64 64bit
- Solaris on Sparc 64bit
- Solaris on x86 64 64bit
- Windows on x64 64bit
Product
Keywords
CR, ASE 15.7 SP100, ASE 15.7, SP100, Adaptive, Server, Enterprise, Fix, Patch, Error, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.