SAP Knowledge Base Article - Preview

2081522 - Targeted CR List for ASE 15.7 ESD#1 - SAP ASE


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

Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.

CR NumberDescription
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 > ) < 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 > ) < 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(
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.



  • 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


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 15.7 Cluster Edition


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.