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 |
---|---|
466609 | Repartitioned exchange can cause poor performance and in some cases we do not need to incur that performance penalty. Instead, it can be handled during a selective index scan, provided the column on which the data needs to be partitioned is part of the index. |
475469 | Message 4207 Dump transaction is not allowed because a non-logged operation was performed on the database will be raised if the SELECT INTO EXISTING TABLE syntax is used even if the SELECT INTO / BULK COPY dboption is turned off. The SELECT INTO EXISTING syntax was meant for internal use and not intended to be documented or used by end-users. |
488602 | Enable memusage and enhance who command in sybmon |
491727 | In rare circumstances, after HA-failover, message "infected with signal 11" in module 'astc__h_ase_sendrpc' may be reported in the errorlog along with a stacktrace. |
539699 | Computed columns using global variables may under some conditions provide unexpected values. Sometimes stack traces may happen with reference to add__computedcol module when using the table with such computed columns. |
547757 | Error 559 and 3702 could be raised when executing a stored procedure if set fmtonly is on. |
555255 | When a query contains a negative integer specified such as -(90), and when literal parameterization is on, parser or normalization syntax error might be raised when the query is cached and has to be recompiled during subsequent executions. |
568554 | In some circumstances, when attempting to login to the server and the server runs out of locks, a 1204 error may be raised and a signal 11 may be reported in the errorlog followed by a stacktrace involving the module 'lock_logical'. |
571074 | Specifying fill factor for a table has no effect on the subsequent REORG REBUILD. |
577089 | SELECT * INTO temp table from a VIEW with TOP and UNION ALL doesn't return all the rows. |
578391 | The DBCCLOG command in sybmon is extended to support reading compressed dumps. |
581438 | New built-in function migrate_instance_id() to return the ID of the instance that initiated a task migration in SDC environment. |
589686 | Feature request to have Msg 935 (WARNING - the timestamp in database '%.*s' is approaching the maximum allowed) always be sent to the errorlog when it is raised. |
590312 | If reformating strategy is used and an index key has BIT datatype, it could return wrong result sometimes. |
590626 | The database timestamp could wrongly exceed its maximum value following a 6901 error, "Overflow on High component of timestamp occurred in database < dbid > . Database table possibly corrupt". This is no longer possible. After warnings that the database timestamp is reaching its limit, the database will finally be shut down, leaving the database in read-only mode. |
592395 | Signal 11 in function ResRelOp()and spid termination with ResRelOpProcess(), CgpPop::_CgpPePredBmToScalar visible in the stack trace in the error log. Query involving outer join onto a virtual expression from a sub-query containing the column involved in the virtual expression in a further outer-join clause. A virtual expression is generally the result of a built-in function (isnull etc) Trace flag 7757 turns off this change. |
596198 | User with sa role is allowed to login to cluster while polite shutdown is waiting for current user connections to exit. |
596681 | Missing message in outputs of sp_helpconfig for some parameters in ASE 1503. |
610496 | Signal 11 in function CgEvals::_CgCompVcol() may be seen in the error log and the spid terminated under rare circumstances involving a reformatted correlated subquery with group by\having clause which references a column in the outer query. Other entries in the stack would include CgpGroupHashing & CgpStoreInd |
610956 | ASE installations with large number of databases, with high number of engines and inter database transactions would result in high contention of dbt_spin. |
618881 | An infected with 11 involving operator LeHashOp or LeGroupSortedOp may be raised when selecting an aggregate function such as count() from a DISTINCT derived table based on an equijoin between local and proxy tables and the equijoin is on char/varchar type columns. |
619134 | @@rowcount is not 0 after TRANSFER TABLE command failed to import data. |
620806 | For INSERT SELECT queries with an ORDER BY clause, the ORDER BY clause may be ignored if the table being inserted into has referential integrity checks. |
621863 | When a DISTINCT view (or derived table) is queried in a parent DISTINCT query or is part of an EXISTS join (e.g. under IN/Any subquery), signal 11 stacktrace could happen in CgpPop::_CgpPePredBmToScalar() for distinct operator (CgpDistinctHashing/CgpDistinctSorting/CgpDistinctSorted) when the following three conditions are all true: 1. The DISTINCT view/derived table has at least one expression SELECT column; 2. The parent SELECT DISTINCT columns are only a subset of the DISTINCT view columns. Or if the EXISTS join is on one of the DISTINCT view columns; 3. One of DISTINCT view columns which is not part of 2) has a predicate on it in the parent query block. |
622415 | If a table has a trigger defined and 'statement cache' and 'literal autoparam' are enabled, it could cause a problem if a error is detected when processing the trigger. |
622722 | In SDC, error 2601 is seen when insert large number of identity values into table with unique index. Trace flag 16842 can be used to track the SQL that caused the 2601 error. |
623591 | Error 691, "Encountered invalid logical page < pgid > while accessing database < dbname > , object < objname > , index < idxname > , partition < ptnname > . This is an internal system error. Please contact Sybase Technical Support.", will be raised when running WRITETEXT statement on a text page chain of a replicated table after rebuilding this text page chain using DBCC REBUILD_TEXT with the first text page number specified. |
628124 | In ASE Cluster Edition, server may hang under rare circumstances while running utilities like ALTER TABLE. |
628597 | In a shared disk cluster system, poor performance of failover recovery can result from an unnecessarily large number of disk writes that are performed when recalaculating OAM counts at the end of the failover recovery redo pass. |
629475 | A 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." may be reported when running a SELECT INTO from a view that had to be internally recreated from its source text, for example, because the database was upgraded from a previous version. |
629846 | Executing CIS queries concurrently accessing external files on a multi-engine server may crash the server with signal 10 (SIGBUS). |
630202 | In rare circumstances, stale log pages might be cached after node failure in a shared disk cluster such that two or more surviving nodes are left and failover recovery was needed for a multi-database transaction that was found in a prepared state. If the database is replicated, it is possible that the stale log pages will result in errors during replication. |
631758 | The value1 and value2 fields in sp_dbcc_run_differentialreport have insufficent length, thus causes conversion error. |
631915 | A signal 11 followed by a stacktrace involving CgpSort::_cgpInit() may occur when a VIEW or derived table with a non-correlated scalar aggregate subquery expression SELECT column is participating in some equijoin over the VIEW column. |
632023 | Under very specific circumstances a query that has been cached in the statement cache appears to be cached a second time according to the output of showplan, but the query has actually reused a cached plan. |
632055 | When large Java classes using nested methods causing deep recursions are run concurrently by multiple sessions, ASE may run into a situation where the signature cache of the PCI integrated JavaVM gets corrupted causing the report of inconsistent error messages. In some cases this may result in the JVM aborting or ASE shutting down itself. |
632076 | Executing ALTER TABLE with a MODIFY clause together with a clause for addition of a table level constraint may result in signal 11 followed by a stacktrace involving the module 'palt__build_insert_forusertable'. |
635663 | Executing parallel SELECT on syscomments with traceflag 15331 enabled may result in a 1289 error followed by a stacktrace involving the modules 'lock__ins_logical' and 'lock_logical'. |
636684 | sp_unbindexeclass fails with error 512 when more than one row qualify for the delete operation. |
636825 | If "enable ssl" is configured and there is no ssl entry in the interfaces file when starting an ASE, sp_listener "start","ssltcp: < host > : < port > :'CN= < common name > '"," < engine > " will fail, with common name mismatch error. |
637307 | Using the "with verify=full" option for a database causes warning messages in the backup server log relating to pages 24-31. These messages are due to the system table that uses these pages having a special format. They can be safely ignored. |
637395 | In the Cluster Edition, when monitoring is enabled, the MaxIOServiceTime in the MDA table monOpenPartitionActivity may sometimes have values less than the AvgIOServiceTime. |
637589 | Signal 11 in function ScalarNormalizing() (amongst others) may be seen in the error log and the spid terminated when attempting to insert < table > ( < column-list > )..select < col > from < table2 > union/union all < select > in a procedure where < table > is created inside the procedure and < table > contains non-nullable columns that are not in < column-list > . |
637600 | Signal 11 stacktrace with error msg 416 may be seen in the error log and the spid terminated when attempting to insert < table > ( < column-list > )..select < col > from < table2 > union/union all < select > in a procedure where < table > is created inside the procedure and < table > contains non-nullable columns that are not in < column-list > . |
637698 | A 9543 error, "Parameter passed to the builtin 'lockscheme' has an invalid type.", may be encountered when the lockschme function is used with id and dbid parameters from master..sysprocesses. |
638488 | A SELECT query after USE DBNAME in the same line may look up a previous cached statement in another database and raise 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." |
639045 | Under some rare condition, Msg 913 might raise when pagesize() is used with other builtin functions or UDF functions in a query. |
639969 | A 530 message, "Attempt to insert NULL value into column < column_no > in work table (table id - < table_ID > ); column does not allow NULLS. UPDATE fails." may be encountered when executing queries involving derived table and aggregation functions. |
640541 | Error message 14702, "XMLPARSE(): XML parser fatal error < < An exception occurred! Type:RuntimeException, Message:The buffer manager cannot provide any more buffers > > at line < line_number > , offset < offset_num > " may be reported when parsing XML documents with large number of namespace prefixes. |
640552 | A mismatch between the Config Value and the Run Value will occur during booting of the dataserver if a load of sybsecurity database had resulted in less tables than configured for. The mismatch will be seen when executing sp_configure 'current audit table'. |
641091 | When running "sp_configure 'mnc_full_index_filter', 3", which will set the optimizer criterion full_index_filter=1, a poorly performing plan may be generated in circumstances whereby a query is running under rowcount (or top) and the lead order by column doesn't have an entry in the predicate and is the lead key column of an index. In this circumstance, the index will not be costed and if this table is placed outermost in the plan, a complete scan of the table and a sort to generate the order prior to application of the row count is used. |
641109 | The message "current process infected with 11" in the module 'getvalue' together with a stack trace which includes the modules 's_retparams' and 'execproc' may be reported in the error log when an INSERT statement is run on a table having an encrypted CHAR/VARCHAR column, the configuration parameter "statement cache" is active and the INSERT statement was previously cached but it had to be recompiled or renormalized because, for example, all the query plans were in use or the schema for the underlying table changed. |
641192 | Reboot of a cluster edition server may fail to recover local system temporary database, when model database is loaded from a lower server version dump, but not onlined before reboot. The errolog will contain message "infected with signal 11" in the module 'obj_id' along with a stacktrace which includes the modules 'recover_tempdb', 'upgd_upgrade_db'. |
641535 | sp_sysmon output may sometimes show negative value for the total task context switches due to "Other causes". |
642571 | A SELECT using an IN clause with more than 128 elements on a table with an indexed encrypted column fails with an infected with 11 in stu_bincharinter |
642812 | In ASE Cluster Edition, under some rare conditions, graceful shutdown of a cluster instance may crash the instance being shutdown and result in failover. |
643625 | Historical Server may crash with a core file when executing hs_list sessions command if the client's charset is incompatible with the server's charset. |
643910 | The severity for error 13905 is wrongly reported as 16. It should be 10 as in the manual. |
644280 | After executing ALTER TABLE MODIFY an identity column and the server crashes, a large identity gap is observed after reboot. |
644357 | If a stored procedure is created based on a non-partition table and later on this table is altered to a partition table, it will cause stacktrace and raise 12329 error when we execute this stored procedure when compatibility mode is enabled. |
644479 | If traceFlag 15891 is enabled, the message, "mhdc_get_stat: No persistent reservation holder with res_type:2109524184" will be displayed during shutdown. |
644607 | When using the plancost command from sybmon, ASE will stack trace. This is observed mostly on the Windows platform. |
644669 | The message "WARNING: The transaction log for database ' < dbname > ' (dbid < dbid > ) can no longer be dumped due to user ' < username > ' (suid < suid > ) executing < cmdname > " is now reported in the error log when the transaction dump sequence is broken. |
644994 | Under some conditions, for example reset or reconfigure 'parallel degree', statement cache clean up issues and memory leaks may occur and it could also make the purge statement cache entry impossible due to ssql_keep > 0. |
645530 | Sometimes the DBCC CACHEDATAREMOVE command may fail when executed on a system table, and the following 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family...", may be reported even when there is no contention. |
645753 | Temporary tables created with the ALLPAGES lock scheme may report error 311 when an attempt is made to read the table using a cursor, despite a unique index having been created. The error only occurs in the case of ALLPAGES lock scheme and if multiple cursors are declared in the same stored procedure. |
645810 | Linux with multipathing displays "reservation conflict" errors in the machine log when fencing is enabled. |
645860 | The message "current process infected with 11" in the module 'lt_sqlrep_comp_policy' together with a stack trace which includes the modules 's_compile_stmt' and 'GenLava' may be reported in the error log when a session executes a query that is being compiled by ASE, while a REORG REBUILD command or DDL activity takes place concurrently on the same table. |
645944 | Issue a warning if a network listener is using the IP address of a CIPC interconnect |
646024 | Sort operators are undercosted in fastfirstrow scenarios. Fastfirstrow scenarios include min/max optimizations, exists scans and the fastfirstrow optgoal. This can lead to discarding fastfirstrow strategies in preference to other less efficient strategies incorporating sorts. The fix for this is enabled by the cr646024 optcriteria. |
646101 | Under rare circumstances, DISK INIT may hang indefinitely. |
646141 | Print a warning message if the timestamp of a joining instance is not in sync with that of the existing instances. |
646207 | When executing DBCC TUNE (des_bind) on a table, a 8428 error may be encountered after which the table is no longer usable. |
646220 | When selecting from a VIEW using an equality predicate over two view columns where the two VIEW columns are the two SELECT DISTINCT columns of the VIEW and one of them is also a non-correlated aggregate subquery result there, it could lead to signal 11 stacktrace in CgpDistinctHashing::_cgpInit() or in CgpPop::_CgpReplaceVars(). |
646467 | ASE Cluster Edition running on SuSE linux may hit SEGV if native CIPC thread is enabled (traceflag 15582 is not used). |
646490 | For a table with auto identity column, REORG REBUILD after any data copy operation (like ALTER TABLE involving data copy or REORG REBUILD) would fail with error 1763. Also, two consecutive ALTER TABLE ADD/MODIFY operations involving data copy may remove the auto-identity column so that any later attempt to see the values under SYB_IDENTITY_COL may fail with error 207. |
646693 | After migrating from pre-15.0 to ASE 15.5, sybmigrate may report diff failures with 16201 error, "Remote datatype 'usmallint' (65) is unsupported in local server". |
646844 | On AIX platforms, logical volumes cannot be fenced directly. |
646933 | In a 4-node cluster, if any node crashes, executing DROP INDEX from active node will result in a 3757 error. |
646987 | When inserting data using PreparedStatement and DynamicPrepare=True, data might be truncated when the column type is UNIVARCHAR and the first value inserted into the column is less than or equal to 128 characters in length. If these two conditions are true, then every subsequent value inserted into the column will be truncated to 128 characters, if greater than 128 in length. |
647051 | The selectivity estimates for predicates on columns with NULL values may be incorrect for the !=, < , < = operators. There is also a correction for ANSINULL handling of NULL selectivity in which magic numbers were used instead of histogram values. Change is turned on by optcriteria cr647051 in optlevel ase155esd4 |
647138 | A 11035 error, "Execution of procedure < proc name > failed because upgrade found no entry in syscomments for this object. Please drop and recreate dbo." may be reported when executing a stored procedure which belongs to a procedure group that was created using deferred name resolution and at least one of the procedures in the group has a SELECT * statement. |
647202 | The Opertions column in the MDA table monOpenObjectActivity is not incremented when statement cache is on. |
647239 | DBCC PROC_CACHE("free_unused") doesn't refill other engine's ELC. |
647569 | Certain parallel query plans available in ASE releases before 15.0 are not supported in ASE 15.0. Cases include joins between partitioned and unpartitioned tables. This change adds capabilities and costing support for these queries. Changes are enabled using trace flags 16970 and 15331. You may also need to sp_chgattribute to set the plldegree on a per table basis. |
647726 | A parallel reformat inside a subquery may be costed incorrectly. |
647973 | When insufficient served licenses are available ASE should report the requested license type and quantity, as is the case for unserved licenses. |
648018 | A 257 error, "Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed", may be raised when migrating a pre-15.0.2 server to ASE 15.0.2 or later versions. |
648511 | If sp_passwordpolicy "expire login passwords" is executed without specifying a login or wildcard string, it expires every login on the server. |
648664 | Under some rare conditions, the statement cache entry could have ssql_keep > 0 and this entry could not be removed by the DBCC PURGESQLCACHE command and this could cause problem for the statement cache. |
648948 | Executing a procedure with derived table containing UNION queries could lead to permission errors. |
649006 | Table scans were avoided since the CPU cost for table scans did not take into account reduced row counts due to partition elimination |
649038 | Under some rare circumstance, parallel queries using expression involving LIKE and variables or parameters could cause stacktrace and the stack will show modules copy__eval() and copy__eoplike(). |
649145 | In rare circumstances, the message "Sybmon encountered signal 11" in the module 'pci_configured' together with a stack trace which includes the modules 'sm__exec_memload' and 'shm_memload' may be reported in the error log when a memory dump is loaded with Sybmon while attached to ASE server. |
649470 | When conserve_tempdb_space optcriteria is used, then tempdb space estimates inside subqueries are not recognized when query plans using large amounts of tempdb space are to be avoided |
649590 | Inherently zero row queries, ie with an always false constant conjunct (ie where 1=0), can take a long time to find a query plan. |
649710 | You may retrieve a strange row which has ErrorNumber=110081 and Time='Jan 1 1900 12:00AM' from monErrorLog just after the ASE is restarted if the ASE is configured with multiple engines. |
650076 | Cluster lock space rebuild takes time and as CLM rebuild is a blocking operation, cluster is hung for the duration. |
650268 | For options, for example 'cpas per ccb', defined as CFG_MEMORY_USED but do not consume any memory at run time, sp_helpconfig will raise error when estimate the memory usage on them. |
650660 | Queries with outer joins on encrypted columns may not return all the rows from the outer table if the encrypted column uses the decrypt_default modifier. |
650977 | Unnecessary procedure renormalization involving INSERT/UPDATE into temporary table may happen after temporary table re-creation and recompilation. This can cause sysdepends or sysprocedures contention. |
651021 | Error msg 7105 was changed from "TEXT/IMAGE/UNITEXT page < page id > does not have a next page, although it should." to "TEXT/IMAGE/UNITEXT page < page id > does not have a next page. Either there is a suspect text page chain, or transaction isolation level 'read uncommitted' has been set. Database < db name > , table < table name > , first text page < page id > ." |
651085 | If the stack size is under-configured, showplan may sometimes cause stack corruption for a very complicated plan. |
651228 | Running Job Scheduler installTemplateXMl.csh script results in a "ASE150.csh: No such file or directory" error. |
651865 | UPDATE on a nested VIEW may cause a stack trace involving the modules 'vu_mergetress', 'vu_analyze_view' and 'vu_call_analyze_view'. |
651914 | The 0x08 bit for sysindexes.status2 field does not get correctly cleared when running sp_rename or dropping a constraint. |
652103 | The message "current process infected with 11" in the module 'des_unkeep_or_drop' or s_free() with a stack trace that includes the modules 'apm__metrics_insert', 'kill_proc' and 'proc__dealocmem' may be reported in the error log after a session that was hanging because of the transaction log being full was killed and the configuration option "enable metrics capture" was active. This error resulted in ASE shutting down itself. |
652110 | If a constant expr is in the select list of a VIEW or derived table, and the VIEW is the inner of an OUTER JOIN, and the constant attribute is correlated into a subquery outside of the ON clause of the OUTER JOIN, then a stack trace could occur if a subquery reformatting strategy is chosen, such as in the following query: select Panel = (select PN.c1 from tb1 PN where A.r2=PN.c2) from T3xxx RE left join (select 1 from T1xxx r) A(r2) ON RE.c3=A.r2 |
652160 | DBCC CHECKTABLE may result in 12905 errors when executed on DOL table with indexes. |
652275 | When ASE is waiting for tasks to exit, print additional information to understand why shutdown is not proceeding. |
652396 | In rare circumstances, the message "current process infected with 11" in the module astc_xid_gen along with a stack trace which includes module sysxacts_materialize may be reported the error log while using systransactions system catalog or stored procedure sp_transactions. |
652562 | A Cluster Edition instance cannot be "onlined" after it was previously killed by VCS during an attempt to join an existing cluster. |
652634 | When selecting from a VIEW that selects DISTINCT rows from a base table with at least one encrypted column that specifies a decrypt default value, Adaptive Server gets a SEGV violation and aborts the user session. |
652646 | A SELECT statement with a qualification that searches an encrypted column that has a decrypt_default modifier and another column using the LIKE operator may ignore the LIKE filter and produce wrong results. |
652738 | When inserting audit records into audit table fails and node shutdown is issued, the node shutdown may encounter a signal 11 followed by a stacktrace involving the modules 'insert' and 'audproc'. |
652772 | Alter table drop column operation may result in a 804 error while dropping a TEXT column from a Datarow Locked table with forwarded rows. |
653067 | sp_helpcache does not display the correct cache binding. |
653157 | In Adaptive Server/Cluster Edition, the opening of databases when booting a non-coordinator instance, is performed serially so that making all databases available takes an unnecessarily long period of time. The opening of databases is now done in parallel. The previous behavior has been retained under the 2796 trace flag. |
653246 | In 'Advanced Options' page of 'Add Database Device' Wizard, the 'skip allocation' is enabled by default (the box is checked). |
653511 | If a stored procedure undergoes recompilation, and the procedure makes assumptions regarding session's state (ie session environment settings), the resulting recompiled plan can be significantly different to the original. This fix is only active when traceflag 7773 is active. |
653694 | Transfer table command with destination to a 'fifo' file can fail for tables with rows of larger size. |
653722 | An infected with 11 occurs in NormalizeScaler when inserting the results of a UNION into a table with a materialized functional column. |
653786 | Sybase Central 6.0 with ASE Plug-in may raise the ClassCastException when displaying device information from database property if an additional segment exists on the database. |
654233 | Adaptive server goes down after an assertion is hit in the module th__refresh_threshcache(), when running alter database command if systhresholds system table is corrupted and diagserver is used. |
654532 | A 15412 error may be raised when during a decryption operation if there are a lot of concurrent user sessions using encrypted columns features in Adaptive Server. |
654617 | Enable CIPC native thread on HP platform. |
654653 | The database option "no chkpt on recovery" may be left set for a given database mistakenly when ALTER DATABASE and QUIESCE DATABASE are executed by two sessions concurrently. |
655352 | When expressions on GROUP BY lists are in the select list or HAVING clause in which the same column is used on both sides of an operator, then a wrong answer could result e.g. col1 + col1 |
655386 | When gracefully shutting down the coordinator node, the cluster may perform failure handling which will be aborted. This will cause some remaining nodes to become inaccessible. |
655613 | A DB2 error indicating an invalid value may be returned when a query referencing a remote DB2 table contains a DATE search value. |
655642 | In ASE Cluster Edition, under some rare conditions, the CREATE/DROP database commands may hang forever as the other task does not send the wakeup event. |
655766 | On some heavily-loaded systems, sybcluser might hit timeout error if it takes more than 1 minute to start a cluster or instance. |
655828 | During shutdown instance processing, the shutdown thread may hang during dbtable cleanup. This prevents local instance polite shutdown |
655846 | ASE at a higher engine count may encounter error in allocating monitor memory during disk init for higher device count. |
656351 | In a shared disk cluster, a change in ownership of a database on one node may be undetected by another node when a cross-database access is made to a dbo-owned table. |
656374 | Sybase Central may fail to load 32bit mclib.dll on Winx64 platform. |
656475 | After changing the server's default sort order id from 52(no-case) to 50(binary), INSERT into list partitioned tables may result in error 9573. |
656566 | On AIX platforms, a client session running a batch job may be terminated with error "ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect] SQLCODE[-84083974]" and the ASE errorlog is logged with message"kernel nrpacket: recv, Resource temporarily unavailable, spid: < spid > , suid: < suid > ". |
656606 | The message "current process infected with 11" in the module 's_retparams' together with a stack trace which includes the modules 's_setreturns' and 'execproc' may be reported in the error log when a SELECT statement is run on a table having an encrypted column and the configuration parameter "statement cache size" is greater than 0. |
657271 | A 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache", may be reported followed by a stacktrace involving LeScrContext::updCacheStat when a query tries to acquire the cursor cache. |
657353 | Monitor elements SMC_NAME_PAGE_LOGICAL_READ and SMC_NAME_PAGE_PHYSICAL_READ may be calculated incorrectly. The logical and physical read counts are coming out the same, even when queries that only do logical reads are executed. |
657380 | The RowsAffected column in MDA table monSysStatement is incorrect for parent procedures. |
657522 | After a polite ASE shutdown, no_recovery durability databases whose log segment is mixed with data segments may have inaccurate free space counts. |
657655 | sp_helprotect shows only public permission instead of permissions of group that the user belongs to. |
657997 | House keeper task never writes the in-memory statistics (SYSTABSTATS) of table created with 'for load' option to disk. This may result in sub optimal plans after un-paritioning the table. |
658105 | "set switch serverwide on 'disable_minmax_optimization' with override" has been enhanced with new session level criteria "set allow_minmax -1|0|off|1|on". It can also be used in query level AP to control just that query. |
658122 | The DBCCLOG command in sybmon is extended to support reading dumps taken on a server with a logical page size greater than 2KB. |
658276 | A "9219, severity 20, state 83" error may occur when a stored procedure with enough wide parameters that the number of bytes necessary to log an invocation would require more than a single log page. The error will only occur if the stored procedure has been previously invoked with null values in the wide parameter(s) and is subsequently invoked with non-null values in those same parameter(s). |
658317 | The DBCCLOG command in sybmon is extended to support displaying pre-15.5 ASE transaction log records. |
658430 | The PR_DESCHAIN NHASH sybmon command does not print the right information with regards to the hash by name table of DEScriptors. |
659042 | When the master database is marked for replication the execution of sp_addlogin does not replicate the login with the correct password expiration interval. |
659485 | A timelice error together with stack trace which includes module 'idt_value_verify' may occur when several rows are inserted into database, or inserting rows followed by retrieving identity value from the database, if BIGINT datatype is used for the identity column. |
659910 | Query with TOP, UNION ALL and ORDER BY clause could return fewer rows. |
659912 | If a query HASH joins a UNICHAR and UNIVARCHAR column and the joining values differ only by trailing blanks, then the row may not be returned. |
659996 | Under very rare circumstances, a task committing its transaction may go into an undetected deadlocked condition with another task which is truncating the transaction log. |
660311 | Less rows than expected may be returned when executing a query which joins 3 or more tables with All Pages Locking schema, there are some duplicate conditions in the WHERE clause and the SET SHOWPLAN ON output shows that it used a N-ARY NESTED LOOP JOIN operator. |
660820 | sp_helprotect does not consider roles inherited through login profiles when reporting permissions. In addition, on a High Availability environment, when a primary fires a command to CREATE/ALTER/DROP login or login profile and if the command fails on the secondary, the TDS return status of the command on the primary is still a success. |
661265 | A 7105 error, "TEXT/IMAGE/UNITEXT page < page > does not have a next page" together with a stack trace may be reported when input text string containing partial character at the end is inserted into Adaptive Server which has the same character set as client by BCP...IN. |
661802 | Sybcluster always performances heartbeat check according to "quorum heartbeat retries" and will not stop even if the check if successful. |
661814 | Changing ASE config parameters can cause exception java.lang.NullPointerException at java.lang.String.compareTo(String.java:1168) |
662014 | Signal 11 can occur in the module 'th_curunreservedpgs' when an ALTER DATABASE is run at the same time the curunreservedpgs() builtin function is used. |
662247 | DBISQL's preference files location can now be configured on a per-installation basis. |
662338 | IOTime in monIOQueue is incorrect for multiple engines server on Windows platform. |
662586 | ASE dataserver does not give page or dbid information with error 290024. |
663005 | A cluster setup with more than 1 instance may encountered a signal 11 with a stacktrace involving the function 'lock__mmaster_processque'. |
663109 | Under some very rare circumstances, one of the cluster instances may abort with an infected with 11 message together with a stack trace showing module name 'dbt_rdump_action_pcm_callback'. This may happen after a DUMP DATABASE command was interrupted or hit an exception. |
663203 | Error 2502, "Table Corrupt: A page is linked in more than one chain; check this page:page number= < page number > allocation status= < status value > ", followed by error 7968, "The object allocation map for tabid < object id > indid < index id > partition < partition nid > is corrupt, therefore the optimized report cannot be generated. Contact Technical Support for assistance.", will be reported when running "dbcc textalloc" with "noreport" option multiple times. |
663224 | In some cases, ASE WebService cannot consume the WebService which has SOAP datatype parameters including soapenc:byte, soapenc:boolean, soapenc:long and soapenc:int. |
663304 | If an APL table has a unique CLUSTERED INDEX with all keys specified by constants and a non CLUSTERED INDEX is forced, then the join order will place this table at the beginning of the join order, bypassing costing, which could result in a performance problem. This behavior is fixed by optcriteria cr663304 or trace flag 16926. |
663359 | A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified." may be reported when running SP_HELP_REP_AGENT with no parameter values. |
663628 | Worktables will not be shown in monProcessObject. |
663945 | When creating a functional based index, data may get truncated when using CONVERT(). |
663994 | Signal 11 could occur in CgEvals::_CgCompVcol(tree*) during DistinctHashing operator code generation when there are two distinct expression columns and one is becoming dependent on the other through equijoin transitive closure. Using diagserver, the assertion "Assertion (GcvIsVirtualColumn(pNode))" could fail in cgevals.cpp line 202. |
664161 | The message "current process infected with 11" in the module 'fglk__send_prom_attn' together with a stack trace which includes the modules 'fglk__promote' and 'getnext' may be reported in the error log and may bring the server down if a query involving a big number of tables (more than 50) was being executed in parallel and due to the number of locks acquired it attempted to promote the locks to a lock of a higher level. |
664833 | Normally, if an attribute from a table inner to an outer join is referenced in a higher scope outer join or in the WHERE clause, it would cause the outer join to degenerate into an inner join since all null extended rows would be eliminated. The exception occurs with "null preserving" predicates such as IS NULL which would not eliminate the row. If a nested outer join exists where a table is inner to an outer join and an attribute of the table is referenced in second higher scope outer join ON clause in a "null preserving" predicate then a wrong answer could result when a mergejoin/hashjoin is chosen for the higher scope outer join. |
664984 | When executing an INSERT-SELECT query from a proxy table having a LOB column into a local table, a NULL value may be inserted into a LOB column on the local table if a cursor is opened on any proxy table. |
665043 | The following is observed when 'restricted decrypt permission' is configured: (1) a table owner who has decrypt permission on an encrypted column through group membership is not permitted to select decrypted data from the column. (2) sso_role who should have implicit decrypt permission is not permitted to select decrypted data from the column and is not permitted to insert into the column when trigger present on the table (3) a table owner who has been granted decrypt permission through a user defined role is not permitted to insert data into the column when trigger present on the table |
665170 | sp_shmdumpconfig raises message 18502 when an "error" dump type is specified when "message" should have been specified. This CR is a feature request to find ways to reduce the confusion between the two types of dump conditions. |
665639 | When 'statement cache' and 'literal autoparam' are configured on ASE the @@identity retains a non-zero value after an INSERT into a table that contains no IDENTITY column. |
665651 | If server has 'capture missing statistics' enabled, and if multiple parallel threads execute queries involving a column for which stats are missing, then all such threads would try to insert the missing stats; one of the threads would succeed, and the others would get 2601 error leading to transaction and command rollback. |
665666 | Specifying "as template" in a sql select list incorrectly reports a syntax error. |
666362 | A signal 11 may be reported with a call stack involving the modules 'do_bt_release_rlocks' and 'rec_undo_session' while accessing the buffer address from an address lock of an APL page. |
666371 | TF2792 blocking on user table for select operation. |
666577 | Cannot access Monitor Server counters from Sybase Central when SQL Server names are different in client and server side interfaces file. |
667065 | Under some rare conditions, queries with computed columns could cause stack traces involving the module 'add__computedcol' when using the table with computed columns. |
667552 | sp_sysmon might report wrong engines when some engines are offline. |
667726 | sp_helprotect truncates object and column names which are greater than 30. |
667923 | A 290024 error, "Invalid column length: < number > Value must be between < number > and < number > at offset < number > ..." may be reported in the errorlog when a session executed a trigger which contains a SELECT FOR XML referencing INSERTED or DELETED virtual tables and previously the same session had been executed a different trigger for a different table but with the same SELECT FOR XML statement. |
667943 | In some cases, low throughput or poor performance may be observed during partially logged operations like BCP on indexed table or REORG REBUILD. sp_sysmon output shows high contention on dbt_seqspin spinlock. |
667977 | When a table in a VIEW is modified, multiple SELECT statements on the VIEW may return different results. |
668380 | When free lock pool resource goes below critical threshold, server goes to slow response state due to heavy spinlock contention. |
668846 | PIOs, LIOs, and CPU for nested loop join index scans are not reported in the estimated cost diagnostics (statistics plancost) for parallel optimized strategies. |
668909 | When creating a lightweight procedure, if all negative object IDs are used up, the 2012 error message is not reported. |
669413 | Backup Server support for the MOUNTWait option for Tivoli Storage Manager. |
669429 | Infected with 11 in function testpasswd following an upgrade. |
669592 | When sp_extrapwdchecks is installed in the master database, adding or changing a login password to one containing single quotes fails with errors 102, 105 and 17720. |
669847 | A 290024 error, "Invalid column length: < number > Value must be between < number > and < number > at offset < number > ..." may be reported during a UPDATE plan execution when a complex VIEW or derived table (such as UNION or GROUPBY) is used in the FROM clause of the UPDATE statement. |
670074 | High spinlock contention on Resource- > rdbts_spin and Dbtable- > dbt_seqspin when running concurrent BCP IN jobs against a partitioned table. |
670199 | A signal 11 could with a stacktrace involving the function ResRelOp() called from CgpDistinctSorted::_cgpInit() when a DISTINCT VIEW with an expression DISTINCT SELECT column is queried with a constant equality predicate over the expression column and the final plan chooses DistinctSorted operator. |
671228 | ASE running on Linux platforms with batch I/O enabled (which is enabled by default) could hit timeslice errors in the module basis_flushbatchio(). |
671436 | Job Scheduler runs a job multiple times over a minute under some situations. |
671437 | Parallel query plans are not chosen over serial query plans when using a large number of engines due to over optimistic costing of serial query plans. |
671536 | In certain circumstances, a query that contains an OR clause with multiple joins may generate a sub-optimal plan, with respect to result accurracy, when executed with the optimizer level of ?ase_default?. |
671950 | DDL generated by sp_helptext using the 'ddlgen' option may result in an error. This occurs due to the expansion of "*" to the individual column names. |
672144 | A 2540 error may be reported by DBCC CHECKALLOC following instance failover recovery when a REORG REBUILD (index), CREATE INDEX, DROP TABLE or TRUNCATE TABLE command had completed on the instance just prior to its failure. |
672196 | MERGE UNION DISTINCT plan could return duplicate rows incorrectly when the union view/derived_table is participating in an equijoin join with another table and there is also a constant sarg (col= < const > ) on the other table's equijoin column. |
673169 | Msg 5893 prints wrong values while trying to increase the number of user connections. |
673179 | A user defined function or a stored procedure that calls the radians() function with numeric parameter may start returning NULL for all executions once it has been called once in a way that passed NULL to the radians() function. |
673379 | Under some rare circumstances, SELECT INOT on UNION view may fail with error 225, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization". |
673487 | In limited cases, parallel GROUPBY queries that use 2-phase grouping strategies and have two or more XCHG operators beneath the 2-phase grouping operator may return duplicate groups with partial aggregate results. |
673494 | Historical Server will hang if one attempts a recording session and the monitor server name doesn't start with a letter or this name does't exist in the interface file. |
673625 | Sub optimal plan with INSERT and/or SELECT INTO using an ORDER BY occurring when optcriteria avoid_bmo_sorts is on |
673764 | While 'lob compression' is enable, BCP and SELECT INTO operations will reserve more pages than the original table, which may cause regression in LOB reserve space. |
673971 | New monitor counters are added to the monEngine, monOpenObjectActivity and monOpenPartitionActivity MDA tables. |
674064 | ALTER TABLE ADD PARTITION on a Data-only Locked table followed by a CREATE CLUSTERED INDEX with sorted_data option and some DMLs may result in a 1581 error, "Create index was aborted because pages in the data only locked table are not linked." |
674251 | A roundhash N to roundrobin 1 NLJ strategy may return too few rows if compile-time thread adjustment is done. Typically, compile-time thread adjustment might occur if "max parallel degree" is not configured at least one (or more) higher than "max scan parallel degree". |
674278 | In limited scenarios, right nested outer joins optimized in parallel mode could generate a SEGV. This would occur if the outer stream of the right nested OJ had replicated partitioning. The stack would contain a calls to OptDeepPDTransform() and eqcGenNlJoinPop(). |
674607 | The threads required to run a parallel query may be under calculated. The problem occurs in plans that contain store_index or N-to-1 Nlj strategies. This can lead to the selection of plans that require more threads than the system/query was configured for. This fix is enabled with optcriteria cr647607. |
674622 | A query with a LIKE clause using a long LIKE term and having escape characters may return incorrect results. |
674645 | If a database has LOB compressed tables which stores compressed XML doc, DBCC CHECKDB may report 15960 error message for LOB compression issues. |
674877 | Performance issue on SELECT INTO from encrypted tables for non-privileged user. |
675292 | Undo of inserts into data-only locked tables that have an index, either by transaction rollback or by database recovery, is slow due to poor prefetch of affected index pages. |
676013 | The MDS table monSysLoad may contain NaN,Infinity values for some statistics |
676654 | In rare circumstances an uncommitted change to text/image data by the execution of a WRITETEXT non logged command may not be rolled back during ASE boot time recovery and after ASE was shutdown with nowait. |
677059 | When parse_text() builtin with execute immediate is run concurrently in many sessions with each session running the query multiple times in a loop, it will result in segmentation violation in prot_desc(). |
677153 | When loading a dump generated by an ASE 12.5 (which is not AIX) to an ASE 15.5 AIX server, an invalid column length error may be raised raised. |
677481 | In rare circumstances, Adaptive Server may hit signal 11 at mda__process_sdes. |
677580 | When executing SP_SETREPTABLE with the parameter value 'USE_INDEX', the indexes created for the replication of off-row text/image columns may become inconsistent when the table does not have any other non-clustered index. In that case 'DBCC CHECKTABLE' would report error 7928. 'UPDATE' or 'WRITETEXT' may fail with error 644 or error 7165 respectively. |
677991 | Sometimes after a failed attempt to drop a large buffer pool in a busy system, the pool may still be be available for use even if sp_cacheconfig shows the pool status as "Unavailable/deleted". However, subsequent use of the pool may, under rare circumstances, lead to timeslice error with modules like pg_allocate(), bufnewpage() and cm_cache_wash() reported in the stack. |
678278 | BCP into a range partitioned DOL table can result in excessive unused space. |
678432 | If a target list for a view maps to more than one encrypted column in the base table with the decrypt_default attribute, Adaptive Server may fail to check the user's decrypt permission and incorrectly return the decrypt_default value instead of the actual column value. |
678763 | Updates on tables that have foreign key constraints may take exclusive row locks on non-qualifying rows. |
678812 | Sybmigrate hits a 247 error (Arithmetic overflow during explicit conversion of NUMERIC value to a INT field) on tables with more than 2.1 billion rows. |
679300 | Updating configuration parameter on ASE Cluster Edition gives error, "Notification failed for parameter 'esp execution priority'" |
679561 | When max number replications paths is 1 and physical paths/bindings exist, print the following warning message on Rep Agent startup: Warning: the maximum number of replication paths is set to 1. All bindings for database ID '%d' will go to the default path despite the presence of %d physical paths. |
679807 | For a SELECT statement in a stored procedure, if the table has more then one partition keys and not all the partition keys in the predicates are constants, neither compiler time partition elimination nor dynamic partition elimination occurs. |
680360 | In Adaptive Server version 15.5 ESD#3 or later, failure to move requested memory between buffer pools using the sp_poolconfig system stored procedure, may lead to error 2747: "Incorrect position specifier in format string of PRINT command" followed by message: "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = X, Current count = X+1". |
680730 | In rare circumstances, a spid in Adaptive Server may hang. A stack trace of the hanging spid will involve the modules mda_populate_monOpenObjectActivity() and des_get(). |
680759 | In rare circumstances, terminating an idle CIS connection may result in some form of memory corruption in the next connection attempt. |
680776 | When using some devices (i.e. EQLOGIC) on Linux with multipathing, ASE cannot correctly locate the alternate paths to the raw devices for I/O fencing which may prevent ASE from starting up. |
681107 | With using Sybase Central ASE-Plug-in, clicking database - > right click Property - > device tab may result in a Java error, "java.lang.Integer cannot be cast to java.lang.String" when the database has user-defined segment. |
681347 | The number of page-level compressed rows in the DBCC CHECKTABLE message is zero on nt386 platform. |
681352 | Replication Agent starts while the number of replication paths configured is less than the number of replication paths stored in sysattributes. |
681516 | Under Windows 2003 NT platform when ASE is booted using the COTS JVM version JRE-6.0.24 from Oracle/Sun, the JRE headless mode is not correctly supported therefore allowing methods using that mode to be executed although they should not. |
681538 | When installing ASE using one off release EBF #19426, misleading warnings about connectivity may be reported. These can be ignored. |
681574 | show_cached_plan_in_xml() does not display BIGDATETIME and BIGTIME values correctly. |
681622 | Enable HA support on Windows 64 bit platform |
681629 | "alter database ... set lob_compression = 0" command doesn't work when executed following "alter database ... set compression = < new compression schema > " command. The LOB compression level will stay unchanged after the command. |
681652 | For roundrobin partitioned table, if each individual partition has its own compression level, the compression level setting is lost after create global clustered/placement index. |
681666 | The message "Error #0; Result Table was expected but not received" may be reported in Sybase Central when running "Object Page IO Monitor" in monitors folder. |
681817 | When configuration parameter 'FIPS login password encryption' is enabled and there is no valid ASE_ASM license, sp_configure unexpectedly succeeds. License checks done at ASE startup correctly report that no license is available, but unexpectedly allow continued use of the FIPS login password encryption configuration option. |
682053 | A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1." will be reported when running ALTER TABLE ... ADD COLUMN NOT COMPRESSED with 'enable compression' being configured as 0. |
682374 | When capturing metrics using ?sp_configure ?enable metrics capture?? stack traces may be reported in mem_pageallocate. The issue does not occur if ?enable metrics capture? is not configured. |
682479 | Upgrades involving views or procedures whose definitions contain "select *" might fail if any of the column names in the expansion of "*" requires delimited identifiers. |
682864 | Error 17290 can be reported by syconfig when creating a backupserver even though it is correctly created and setup in the ASE. |
682958 | Using bigdatetime caused DML performance drop when 'stmt cache monitoring' enabled, Revert bigdatetime back to datetime to fix performance drop issue, these changes will cause the granularity of elapsed time increase to 3ms. |
683008 | In rare circumstances, e.g under heavy load environment, Adaptive Server may encounter timeslice error when querying the MDA table monCachedProcedures. |
683014 | Replication Agent related MDA tables like monRepLogActivity in a multi-engine ASE environment may report wrong values for various monitor counters. |
683015 | The execution of DBCC LOGTRANSFER may be aborted with the error message "ct_fetch(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect" when attempting to process a BIGTIME value. |
683137 | Using Sybase Central ASE-Plug-in to set the Cluster Edition (CE) cluster admin password does not work. |
683192 | After downgrading from ASE 15.7 to ASE 15.5, when booting the ASE 15.5 server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options. This prevents successful completion of the server boot. |
683378 | Enhance Active Messaging to avoid memory leak for MSGRECV() and MSGCONSUME() with STRING property. |
683626 | Abstract plan error message could be reported when using "set forceplan on" for outer join query with subquery. |
683708 | On IBM and HP platforms, when running in HA mode, console logging has to be enabled regardless of the setting of 'enable console logging' configuration parameter. |
683815 | A 16321 error, "Integer value ' < value > ' is disallowed." may be reported when a CREATE LOGIN command is executed and the option FULLNAME, PASSWORD EXPIRATION and SUID are specified. ALTER LOGIN command may result in similar error when the options FULLNAME and PASSWORD EXPIRATION are specified. |
683967 | In case of language batch parameter processing, error 2834 may be reported together with the stack trace involving module proce_release(), s_copytmps() and s_cleanframe(). |
683997 | When show_cached_plan_in_xml is executed, the time calculated for AVG and MAX time is in milliseconds. If a query takes less than a millisecond, the time displayed is 0. A more granular time mechanism is now provided to display the query execution time in microseconds. |
684046 | Free the Kernel Resource Memory after copying the thread pool configuration. |
684069 | DBISQL cannot be invoked from Sybase Central after ASE 15.7 is uninstalled from a common IQ15.3/ASE15.7 installations under the same $SYBASE (installed in that sequence.) |
684110 | Under rare circumstances, a 8601 error, "Process < pid1 > tried to keep the PSS for process < pid2 > when it already had the PSS for process < pid3 > kept", may be reported when executing utility functions, such as sp_showplan, which query another active spid. |
684174 | When a scheduled job is deleted before its next execution time, then when its actual schedule time comes and if the number of 'job scheduler tasks' is less than number of jobs running simultaneously, then at this point of time the Job Scheduler task may stop with error "Job Scheduler Task state set to stop". |
684188 | When the systabstats row for a table is deleted and the DES for the table is flushed (such as on a reboot), the table can no longer be accessed. A 15601 error, "Failed to cache systabstats contents for database < dbname > , object < objname > " may subsequently be reported in the errorlog. |
684753 | Occasionally with 15.7 ASE on HP Itanium the message "Current process ... infected with signal 4 (SIGILL)" in the module 'pci_launcher_trigger' together with a stack trace which includes the modules 'jcnstCopy' and 'LeExecEvalsExec' may be reported in the error log when queries that are using Java datatypes are being executed. |
684761 | A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1.", will be reported when running ALTER TABLE ... MODIFY < non-LOB column > NOT COMPRESSED or ALTER TABLE ... DROP COLUMN on compresssed table with "enable compression" having been configured to 0. |
684849 | Code optimization in the compression module to reduce the repeated acquisition of the resources and to use the local information as much as possible to avoid referring to global structures. |
684903 | sp_help_rep_agent < dbname > ,'scan' does not correctly show log_recs_scanned and oldest_transction. |
684918 | The message "current process infected with 11" in the module 'upsleepgeneric' together with a stack trace which includes the modules 'ha_checkalive' and 'ha_vcs_getgroup' may be reported in the error log during the installation of ASE HA Cluster companionship on AIX. |
684938 | In rare circumstances, if TEXT/IMAGE/UNITEXT columns have NULL value previously, they may not be updated to have the new value in some qualifying data rows when running UPDATE command on these columns. |
684967 | Only one text page for compressed LOB columns will be allocated during INSERT/UPDATE, others will be allocated on demand. This will reduce unnecessary text page reservation and is enabled only with a new session level Traceflag 7192. |
685000 | If the version of source server is ASE 15.0, the exception "Error while getting the configuration of net password encryption reqd for server" may be raised. |
685186 | When marking a database or a table for replication and for using replication indexes for text/image columns, error 1906 may be reported when processing a table whose owner is not the current user or the dbo. |
685367 | A user who does not have the sso_role should not be authorized to run the installmaster script. |
685409 | While restarting ASE after a non polite shutdown, Asynchronous Pre-Fetch subsystem may be inefficient for the allocation page scan happening during data free space recalculation. This may happen for dedicated log databases having one or several log fragments in between their data fragments. |
685536 | The CompRowUpdated value in the monTableCompression MDA table is not increased after a UPDATE is done on a Datapages Locked table. |
685718 | Performance improvement for disk init on XFS and EXT4 file system devices in AIX and Linux platforms. |
685808 | Trailing blanks are not trimmed whn converting in-row UNITEXT/TEXT into VARCHAR/UNIVARCHAR. |
685956 | On Solaris, in rare circumstances, some tasks may hang trying to send data. |
685996 | Abstract plan error could happen failing to apply a right nested outerjoin abstract plan. It is more likely to happen when there is a subquery at the inner side too. Same issue could also cause optimizer to ignore certain legit merge/hash outerjoin bushy plan too under allrows_dss optimization goal. |
686131 | I/O fencing on AIX uses raw SCSI-3 PGR commands which may not be supported on some IBM storage devices. ASE will display I/O fencing reservation errors and will fail to boot. |
686159 | Login and login profile attribute-value 'authenticate with ANY' fails. |
686160 | In the case of working with DOL tables that are marked as hot objects using DBCC TUNE(..des_bind) there is still contention on the locks. |
686186 | Wrong result could happen when using an IN clause over a complex union view column and one side of the union is directly projecting a constant for the column and the constant is also part of the IN clause list. |
686209 | When statement cache is on and after a variable assignment from a column of a table statement is cached, it will return wrong results for the subsequent select the variable value if the lwp for the statement need to be recompiled. |
686223 | Some performance improvements are made by 1) reducing client-server communication overhead when client passes parameters to dynamic SQL statements and 2) by optimizing the ASE code path for processing dynamic SQL batch commands when configuration option 'streamlined dynamic SQL' is enabled. |
686282 | Idle timeout value for a thread pool is set to 0 if it is set to 'DEFAULT' in configuration file. |
686385 | In a Sun Cluster 3.x High Availability environment, executing the kill_ase_engines function may lead to lots of time being spent constructing the pid list. |
686441 | When batch inserts are executed on a compressed DOL heap table, the compression ratio maybe lower than the compression ratio obtained from reorg rebuild. Certain conditions that can contribute to this run-time space bloating issue are addressed. |
686481 | 311 errors can occur on every second execution of a stored procedure that uses dirty reads on a #temptable/index created within the stored procedure. |
686631 | Pre-fetch allocation page while inserting forward row and while de-allocating the DOL data page. At the same time, use hint from placement index while inserting into a DOL table without page linkage status bit. |
686821 | Trigger support is enabled for the MERGE statement. |
686891 | DSParser's discoverInterfacesServerNames(), which uses SyInterfacesDriverBase.loadFile(InputFileStream), may raise a NullPointerException. |
687001 | When MetaData Reduction is turned on ASE RepAgent sends integers in Metadata rows with the integer data type and with no data type for Data Only rows. This causes problems when HVAR is being used. The ASE RepAgent has been changed to always send integers as character strings. |
687106 | In syconfig.exe, many sort order options are missing if user chooses to set utf8 as the default character set. |
687139 | ASE stalls when the license server host machine dies (or is shutdown). During that period ASE does not accept new connections. |
687265 | When configuring a new ASE server,the configuration may fail and terminate while configuring PCI because the max memory configuration is not enough to allow "enable java". |
687551 | A UNION ALL query which involves ORDER BY and an in-row LOB column, where the column coming from the first side of the UNIONALL is not an in-row LOB column, but a corresponding column from the second or subsequent side is, can cause error 7139 to be raised. |
687576 | When Metadata Reduction is turned on but an insufficient Replication Server exec cache size is configured, RS may return a cache error. The logic for processing cache errors on the ASE RepAgent side is changed to skip records that were already sent to RS. |
687735 | Populating a proxy table that contains TEXT columns with several hundred rows of data using INSERT INTO... SELECT may fail with Error 3651, "This transaction has been rolled back, rather than only the current statement." |
687787 | Sybdiag does not work if it cannot log into the ASE server |
687909 | Adaptive Server may disconnect a client with TDS version below 5.0 logging "nast_readpost: Invalid tdslength" message in the error log. |
687982 | sp_showoptstatus does not handle BIGDATETIME datatype. |
688086 | A 529 error may be raised when all of the following conditions are met: (1) The configuration option 'enable functionality group' is enabled. (2) The configuration option 'statement cache size' is larger than 0. (3) A dynamic SQL statement with at least one parameter whose dataype depends upon a table-column referenced in the statement has been prepared and executed at least once, so that a query plan is available. (4) The table-column's datatype has been changed to a type that is not implicitly convertible to the original type by dropping and re-creating the table. (5) The dynamic SQL statement is re-executed with a parameter type that matches the new column dataype. |
688198 | Nested loop join plan with StoreIndex (reformatting) could return wrong result when there is an expression join predicate and the expression involves columns from both sides of the join (e.g. t1.c1*t2.c2=t1.c3). |
688284 | When updating a LOB column with itself, if the original LOB data is compressed while neither this LOB column is defined to be compressed nor the table has LOB compression currently, ASE does not decompress the original LOB data. |
688338 | Query involving column relop NULL clause may result in a 403 error message if the column projects NULL and the relop is =, > =, > , < = or < . |
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. |
688414 | Drop index may hang in a 3-node Cluster setup. |
688706 | ASE WebServices server fails to start on Winx64 platform. |
689028 | When creating a new ASE, syconfig prompts for whether the optgoal should be set to OLTP, DSS or MIX but it never sets the configuration option 'optimization goal'. |
689084 | In replication environment, if a table has data compression, and some data rows becomes forwarded due to UPDATE, rep agent will report 9275 error "%S_REPAGNT: Could not locate the %s image for the %s log record at (%d,%d)." |
689142 | Executing ALTER DATABASE to extend a database onto a new device may fail after loading a dump of a read only or single user Quiesce database. |
689176 | A segmentation fault followed by a stack trace involving the functions LeDataRow::_copyVarnoToCnst(), LeDataRow::readRow() and LeSortOp::_LeOpNext() may arise when a query with all of the following is executed: (1) An outer join the projects a LOB column from the inner side of the join and (2) A UNION ALL operation and (3) An ODERBY clause. |
689195 | When a user chooses "Optimize Adaptive Server configuration" during ASE installation with the GUI tool or resource file utility, the syb_default_pool thread pool is not set. |
689206 | Replication Agent treats normalization (NRM) errors from Replication Server as warnings. All normalization errors should be treated as fatal. |
689431 | UPDATE on DOL table with non-clustered index on two fixed length columns may fail with a 644 error. |
689650 | The message "current process infected with 11" in the module 'open__common_sdes_setup' together with a stack trace which includes the modules 'open__lwpbyname' and 'proc_get' may be reported in the error log and the session killed if a 603 error has been previously hit "There are not enough system session descriptors available to run this query. Raise the value of the configuration parameter 'number of aux scan descriptors' or retry your query later.". |
689691 | The Resource- > rpdeshash_spin may result in high contention under some workloads. |
689812 | syconfig.exe does not set/add backupserver name to master..sysservers. |
689860 | ASE will fail to dump shared memory when 'number of dump threads' are configured to 2 or more. |
689889 | Automatic partitioning of data caches does not occur in threaded mode if "number of engines at startup" does not equal number of engine threads. |
689906 | The error 8009, "Logical page < page number > is not in the given database map." could be raised by the backup server when trying to load a database that has a hole and the physical size of the target database is bigger than the physical size of the archived database but the logical size is smaller. |
690028 | In rare circumstance, error 9209, "Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker = (page id, rowid))", will be reported if a TEXT/IMAGE/UNITEXT columns is defined to be compressed explicitly, or the table it belongs to has LOB compression, and this column is configured to be replicated. |
690064 | 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.". |
690380 | In ASE 15.5 Cluster Edition, under rare circumstances, rows in a DOL tables may get inserted into a deallocated page and lead to consistency errors later on. For example, the error 12301, "Internal error: the index (id = < indid > ) and the data for row ( < page > , < row > ) in table ' < table > ', database < dbid > are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported in the errorlog. |
690406 | When the coordinator node is shutdown, the new coordinator may be fenced out when new instance joins the cluster. The new coordinator will display write errors and then shutdown. "sddone: write error on virtual disk 0 block 4598" |
690665 | The cpu utilization may be excessively high when 'enable hp posix async i/o' is set as 0 and 'allow sql server async i/o' is set as 1 on HPIA64 platform. |
690707 | ASE running on Windows platform crashes on startup when the configuration parameter 'allow sql server asynch i/o' is set to the non-default value of 0. |
690730 | High rprocmgr spinlock contention may be observed under heavy workload of dynamic SQL and stored procedures. |
690805 | When a server user executes the SQL builtin valid_user( < suid > ) passing his own server id to the function, the builtin incorrectly returns TRUE in the case where the server user is NOT a valid user in any database but where there exists a guest user in at least one database. |
690990 | The message "current process infected with 11" in the module 'rec_undo_session' together with a stack trace which includes the modules 'xact__rollback_local' and 'crt_main' may be reported in the error log when the 1105 error was previously reported during the creation of a table. |
691255 | Grouping by UNIVARCHAR column may return wrong result if the UNIVARCHAR column contains NULL and pure blank values and a GROUP HASHING plan is chosen. |
691291 | Using JDBC with SELECT_OPENS_CURSOR=TRUE and isolation level 0, error number 16820 is sometimes reported when cursors are erroneously changed from readonly to updatable. |
691315 | A signal 11 followed by a stacktrace involving the module 'stb_insertvalue' may be reported when UPDATE STATISTICS is run on one column of an All-pages Locked table and the All-pages Locked table has at least one index with the updated column being one of the key column in the index. |
691412 | The error, "worker Server message: Unclosed quote before the character string ' < string > '", followed by error messages "worker jsd_GetResults() failed" and "worker jso_FlushBuffer() failed" may be reported by the JS Agent in the JS agent log. |
691478 | Replication Server may raise the error 14138 when attempting to process a writetext LTL command that was generated using metadata reduction. |
691572 | Under rare circumstances, selecting over 32 columns using DISTINCT and with the configuration option 'avoid_bmo_sorts'/'ase_current' can lead to 325 errors. |
691595 | Full syntax object defination is not allowed for ALTER ENCRYPTION KEY ... MODIFY OWNER command. |
691627 | The message "current process infected with 11" in the module 'css_deallocate' together with a stack trace which includes the modules 's_free' and 's_cleanframe' may be reported in the error log under some circumstances if the execution of a stored procedure using a cursor was aborted by an error (like a 1205 error caused by a deadlock) and the plan being executed was just recompiled. |
691780 | In rare circumstance, error 874, "Process < process id > is trying to unkeep buffer < buffer address > (dbid: < dbid > , pageno: < page id > ) without releasing the exclusive latch it holds on the buffer.", may be reported with stack trace when running UPDATE/WRITETEXT commands on TEXT/IMAGE/UNITEXT columns, or DELETE...FROM/TRUNCATE TABLE/DROP TABLE commands on tables which have TEXT/IMAGE/UNITEXT columns, or DROP DATABASE command on databases which have tables contains TEXT/IMAGE/UNITEXT columns. |
691812 | After the master key owner sets the password for the master key on one cluster instance, creating a column key protected by master key on another cluster instance may result a 2950 error (master key copy does not exist). |
691967 | Dynamic SQL execution with noexec set correctly suppresses execution but does not result in a query plan. This results in no output from show_cached_plan_in_xml(). |
692003 | Sybmon failed to load memory dump with error 13 on ibmaix64 platform. |
692050 | After inserting XML data into compressed TEXT column using BCP IN/ODBC BULK/WRITETEXT BULK, 7136 error, "ASE is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table < table name > . Use DBCC FIX_TEXT on this table before running the query again", may be raised when query data from this compressed TEXT column. |
692086 | A task may hang even though the connection at other end is down. |
692176 | In ASE Cluster Edition, dropping a database and recreating a new local temporary database reusing the same database ID may result in issues during runtime. |
692233 | When Replication Server set dsi_bulk_copy 'on' to replicate compressed LOB data to the replicates ASE, the replicated ASE may be not able to recognize the compressed LOB data and insert them incorrectly as plain TEXT. |
692246 | When replicating compressed data, the RepAgent thread is leaking memory from the 'compression info' memory pool. As a consequence, error 716 may be reported ("Unable to allocate memory of size < n > bytes from the 'compression info' pool."). |
692333 | In rare circumstances on a heavily-loaded multi-engine system, the message "timeslice < value > , current process infected" together with a stack trace which includes the modules 'jldr_ReleaseLocalLoader' and 'pci_free' may be reported in the error log when applications use JAVA extensively. |
692431 | When executing an EQUI-JOIN using a local index scan at the inner side of a NESTED LOOP JOIN, a stacktrace involving the module CgpUnion::_cgpInit() may be reported in the errorlog. |
692775 | The message "current process infected with 11" in the module 'open__common_sdes_setup' together with a stack trace which includes the modules 'pggam_getfree_lowhigh' and 'crt_work' may be reported in the error log and the session killed if a 603 error has been previously hit "There are not enough system session descriptors available to run this query. Raise the value of the configuration parameter 'number of aux scan descriptors' or retry your query later.". Alternatively a stack trace which includes the modules 'open__lwpbyname' and 'sqt_get_plan' may be reported. |
692872 | In rare circumstances, Adaptive Server may hang as a result of an undetected deadlock between a process that is executing a DUMP TRANSACTION and another process that is running a query that uses the last-chance threshold builtin LCT_ADMIN. |
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. |
692898 | The stored procedure, sp_reptostandby, will now print a message warning that the execution can take a long time. |
692959 | ASE on Windows platform crashes with a storage access violation followed by a stacktrace in the errorlog involving the modules 'spinobtain' and 'ws__nclose_defer'. |
693221 | When one of the configuration options, enable functionality group or streamlined dynamic SQL, is enabled and a query containing a COMPUTE clause is executed more than once and the query is either a dynamic SQL or an ad hoc query that is stored in the SQL statement cache, then an extra empty row may be returned on the second and subsequent executions. |
693269 | sp_who in chained mode fails with 226, 17260, and 3701 errors due to misplaced select in installmaster script. |
693358 | After inserting data into TEXT column using java string in ASE server which uses multi-byte character set, a 7136 error, "ASE is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table < table name > . Use DBCC FIX_TEXT on this table before running the query again", may be raised when querying data from this TEXT column. |
693413 | The wash size may be returned as a negative value in the ASE configuration file. |
693592 | DUMP TRAN may fail with a 4205 error if the database has any sysusages rows in the master database with a NULL value for the location column and an unreservedpgs value larger than 65535. |
693925 | When Server Discovery is enabled and "UDP" discovery service is included, server discovery such as "Find" on Connect Dialog, or verifying cluster name on Create Cluster Wizard may take a very long time. |
694123 | The 10330 error message is issued on a select from a join with a normal table and a view after dump/load database. The view and the normal table both have encrypted columns that have decrypt_default. The server has restricted decrypt permission set. |
694188 | The message "current process infected with 11" in the module 'sg_simulate_corruption' together with a stack trace which includes the modules 'bt_traverse_get_apf_pagenos' and 'getcachedpage' may be reported in the error log during the rollback of a transaction either at run time or at ASE boot recovery stage, when the recovery fault isolation feature for a user database, which governs how recovery behaves when it detects data corruption, is active. |
694197 | Executing 'sp_encryption null, login_passwd_check' may mistakenly report that the key copy's login password is not synchronized with the assignee's login password. |
694262 | When using BCP to import data to a Page-locked table that permits nonmaterialized columns, ASE will incorrectly report that a data set contains badly formatted rows if it happens that the first row in the data set has a NULL immediately preceding the first nonmaterialized column in the row. |
694368 | The OSPID value in the monEngine MDA table does not match with the osprocid value in sysengines. |
694413 | Decompression may fail when we update one forwarded row during RID scan. |
694488 | In rare circumstances the message "Infected with 11" together with modules like s_cleanframe, s_senddone followed by spid termination may occur when set statistics time is enabled with a create proc referencing a non-existent temporary table and a particular Sybase supplied traceflag is enabled. |
694724 | In ASE Cluster Edition, during cluster reboot after a shutdown cluster with no_wait has happened, in rare circumstances the cluster is not bootable, with 12314 error and a stack trace with "des__set_clstats". |
694750 | For a table which has more than one LOB columns, if one LOB column is set to be replicated and at least one of other LOB column which follows the replicated LOB column is compressed, update on the compressed LOB columns may not take effect. |
694916 | In rare circumstance, 691 error, "Encountered invalid logical page ' < page no > ' while accessing < parition name > . This is an internal system error. Please contact Sybase Technical Support.", may be raised when inserting data in bulk mode into replicated table with compression and LOB columns while sp_reptostandby is turned on. |
694961 | Reservation conflict messages may appear in the system log on systems with multipathing when I/O fencing is enabled. |
695221 | Upgrade fails when system tables are bound to a named cache. |
695738 | For the schedules running over midnight, Job Scheduler sometimes misses execution of first valid schedule job and sometimes executes scheduled job on invalid schedules time. |
695923 | During an upgrade from ASE 15.5 to ASE 15.7, an error may occur on upgrade step [ID 246]: clear unused columns (table sysindexes). This is followed by a storage access violation with a stacktrace involving the modules 'upgd__do_clear_columns', 'collocate' and 'col_find_default'. |
696067 | ASE running on IBM AIX platform stack traces with exception code 4 in iocPoll+0x54(). |
696150 | When changing the replication status of a table, error 7941 may be reported when processing a table whose owner is not the current user or the dbo. |
697003 | When HA companion is dropped, sp_addexternlogin tries to acquire lock on companion server. This lead to following error: Could not acquire a lock within the specified wait period. DTM_SERVER level wait period=... Cannot lock table 'master.dbo.rmt_ha_sysattributes'. HA Internal Error: Cannot acquire locks for stored procedure 'sp_addexternlogin' on server ''. Retry later. |
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 ESD#1, ASE 15.7, ESD#1, 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.