SAP Knowledge Base Article - Preview

2085509 - Targeted CR List for ASE 15.5 ESD#2 - 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
172714 New feature request to make DBCC MONITOR a grantable command.
384140 Failed to build sample programs testmon and testhist on multiple platforms.
409793 OLE DB Provider by Sybase: Cannot install OLE DB meta-data stored procedures if ASE db option "allow nulls by default" is set to true.
415383 An error message "The configure size for data cache < cache name > is not sufficient to handle the sort buffers < value > requested. The data cache is waiting to claim sort buffers." will be printed to errorlog if there are no enough buffers in the cache to be claimed when doing the no-parallel sort on runtime.
439123 With low cardinality tables i.e. the number of rows is less than the number of steps in a histogram, then there is a possiblity of having a 1 row range density selectivity, where the range density should be 0.0 optcriteria cr439123 needs to be on to see the change.
464489 The error 'Error while parsing ASE version string 12.5.3a' would be reported when migrating ASE 12.5.3a to other versions with migration tool.
470289 Under rare circumstances a 12511 error, "During recovery, quiescent last log marker was not found for database ' < name > '. The backward log scan was started on marker ( < value > , < value > )." may be reported when a transaction dump that has been created with the STANDBY_ACCESS option is loaded.
484306 Sybmigrate does not recognize source databases that have XPDL bits set.
484811 Sybmon can't load memdump file smoothly on linuxamd64 platform.
495245 "sample" command in sybmon can't print useful stack info on hpia64 platform
533609 kill command will not work for Kerberos logins when trying to kill a spid on a remote instance. Workaround is to: Login with username/password to kill DBMS processes on remote instances. OR Login to the instance of the cluster where the DBMS process is local. OR Define external login mappings (using sp_addexternlogin) for Kerberos logins for each instance.
533623 Error 287 "Command not allowed within a trigger" may happen during trigger's execution. The message header indicates the name of a stored procedure called by the trigger and not the trigger's name.
537382 dbcc sqltext(@spid) print the sql text of current thread rather than the content of specified thread when passing smallint data type variable to this command in little-endian platform.
543877 When you install ASE 15.0.2 ESD5 and select "Update" as Install Type to update all installed ASE components, the installer should determine the installed components and update them to the latest available versions. But the installer may additionally install the following connectivity components even if those are not installed components. o Embedded SQL/C o Monitor Client Library o XA Interface Library for ASE Distributed Transaction Manager o Connectivity Language Modules for chinese, japanese, spanish, french, korean, polish, thai, german and portuguese.
549264 When doing an alter table on a replicated table containing a text column, and the alter table does not involve dropping a column, ASE produces a SIGSEGV in cri_ncrebuild().
550607 Skip opening and holding lock on sysconfigures for some config option; Skip starting an xact for some more config options.
551875 UPDATE on an Oracle DATE column results in error 1843 when both the configuration option 'enable literal autoparam' and 'statement cache size' are set.
556015 VCS HA cannot failover to companion server due to weak regular expression check in "".
558228 In DBISQL 11.0.0, the plan output which was displayed following SET SHOWPLAN ON always contained plans from a number of other statements which the user did not directly execute. This has been fixed to restore the 9.0.2 behavior which is as follows: If DBISQL is configured to display results as text, or read-only grids, the SHOWPLAN output is just for whatever statement(s) you explicitly execute. If DBISQL is configured to show results as editable grids, it requires more metadata. That metadata is provided by the JDBC driver (JConnect) which makes a number of database requests on our behalf. These requests themselves cause SHOWPLAN output which users might not expect, but there is nothing further which can be done about it. DBISQL also includes a plan viewer window which is a good alternative to the textual SHOWPLAN.
561513 Allow the i_scan() construct to be used in abstract plans to indicate that an index scan is preferred over a table scan is possible. If the query does not contain any columns of the index which are in optimizable predicates or is not covering, then the index will still not be used.
562507 Optdiag output will result in "Internal error: data length mismatch in ct_fetch()" if the table contains a unichar column of size larger than 127 characters.
562630 sp_sproc_columns contains several joins that needlessly result in Cartesian products.
565377 The tracefile generated on NT and viewed from notepad does not have carriage return and appears that the whole content is printed in a single line.
566608 If statement cache is enabled, the value of the global variable @@error will be reset if it is accessed in a batch together with a statement that gets cached.
569005 Upgrade may fail with a 2601 error on sysusers while trying to add system role 'dtm_tm_role'. A workaround is to remove DTM_TM_ROLE, HA_ROLE, MON_ROLE, MESSAGING_ROLE, JS_ADMIN_ROLE from sysusers and sysroles in the database on the original ASE version and retry the upgrade.
574923 Part of the optimizer search space involving merge joins and/or hash joins are skipped if plans are evaluated before the exhaustive search engine is entered. The symptom may be seen by forcing a query plan which has a better estimated cost than the query plan that is eventually chosen.
575195 duplicate references in the ORDER BY list of a query could result in signal 11
575562 Error: 2805, Severity: 18, State: 0 Bad pointer 0x4 encountered while remapping stored procedure. This may be seen in the error log on execution of sql statement containing constants in both the predicate and in a group by clause. Should only happen with 'enable query metrics' enabled at point of proc creation.
577149 Performance has been improved for databases with a low durability level in cases where many DMLs are simultaneously done on the same page.
578797 Neither of these traceflags introduced via this CR should be required and should only be considered if stack traces are seen in 15.0.3 ESD#4 involving des_wkinstall() For 578797-1, we added some codes under trace flag 7751 to clean up worktables at the end of execution if worktables are not dropped. We also add some diagnostic codes under trace flag 7752 to print out diagnostic info if we found the worktables are left at the end of the execution. SQL Text and the query plan are printed to the errorlog and the showplan is printed on the console if both trace flags 7751 and 7752 are turned on.
579283 Error 1622 following error 1105 and error 3621 may be reported when bcp in data into table with text/image columns.
579446 In rare circumstances, setuser command fails sometimes producing stack traces in setuser().
579925 Error 247 is raised incorrectly in some cases when performing calculations on literal numeric values involving different implicit precision and scale.
581045 With statement cache\literal parameterization enabled. If a parameterizable statement has a literal value whose precision exceeds the limit of decimal\numeric (38) then a 2756 error may be received on recompile followed by a 706 error and stack trace in the error log involving the function rm_prochdr(). The spid will be terminated.
582009 Queries accessing remote tables do not return any rows after a connection error even if the remote server is started up later and the connection is established.
582157 The stored procedure sp_export_qpgroup raises error 213 " Insert error: column name or number of supplied values does not match table definition in 15.0.3 and higher. New columns were added to sysqueryplans but the procedure was not updated accordingly.
582328 Sometimes, the SIG 11 in the module s_handle is reported in the error log along with errors 2601 and 546 while trying to insert into a table with foreign key constraints.
582989 INSERT < table > SELECT < scalars > UNION ALL SELECT < scalars > can be non-performant when there are many union sides.
584457 QPMetrics was not capturing ad-hoc statments when enabled statement cache. This was observed after QPMetrics lazy dumping was introduced. The change fixes the problem.
585221 In rare circumstances, the message "current process infected with 11" in the module 'des_rekeep' together with a stack trace which includes the modules 'proc__linktopss' and 'lwp_proc_setup' may be reported in the error log when a client application is executing a query using "dynamic sql" and the system is configured with a low value for the configuration parameter "number of open objects" according to its workload.
585304 Parallel BCPs into a semantically partitioned DOL table can deadlock when two sessions perform allocation at the same time. The deadlock information will consistently show the deadlock ccurring on rowid 0 for both spids.
585474 When using a dblib client version < 5.0 that doesn't permit numerics, selecting on a bigint column creates a tds stream error.
585588 When a disjunctive predicate that is same as a row constructor is used in a query, the optimizer will not chose a general OR strategy (also know as index union) will not be selected. The row constructor type predicate will have to look as follows (col1 > < literal1) OR (col1 = literal1 AND col2 GT/GE literal2).
586861 Query with CASE expression returning TEXT columns and TEXT constant may fail to execute correctly producing stack traces.
587406 In specific circumstance, error 511 may occur during optdiag input mode when creating column histograms.
587442 Error 1265 when cursor fetch rows from syscomments table.
587864 Parallel query plans are not chosen when using tables that are not partitioned, despite using the stored procedure sp_chgattribute to set the parallel degree. Traceflag 15331 will be added to enable this fix.
588214 Under rare circumstances when an ASE task disconnects due to connection loss the Java associated thread executing on the behalf of the ASE task will not be notified to clean up its resources. This will result in leaking thread and memory resources at operating system level.
589235 ASE raises an infected with 11 stacktrace in function valid_Xcast with lasterr 10762 if an attempt is made to use a Java method when there is no JavaVM in place.
589346 The message "Current process infected with signal 11" may be reported with the stack trace including modules 'NormalizeScalar' and 'Optimize' when executing a SELECT statement with a GROUP BY clause which joins two or more views including subquery(s) in the SELECT list of the view(s). The query must be a non-ANSI extended column aggregate query, which references columns outside the GROUP BY list, in the SELECT list or HAVING clause, outside aggregate expressions.
589619 In rare circumstances, the message Current process (0x...) infected with signal 11 (SIGSEGV) together with module names like SeClock::SclResetTimeoutCeil() may appear for queries involving many tables ( > 10).
589650 Error "Msg 325, Level 18, State 1: Server '...', Line 1: Adaptive Server finds no legal query plan for this statement." may be generated for queries involving outer joins to a derived table (and/or views) which itself contains grouping and the user has disabled reformatting, either via "set store_index off" or traceflag 328. The 325 error can also occur in derived tables (and/or views) using unions, and/or when multiple derived tables are in the same query with "store_index" turned off.
589780 The table-level SQL statement replication threshold setting is not kept consistent on all the nodes of the cluster when it is changed on one of the nodes and the table is not marked explicitly for replication.
590027 Hit the error 1950 while creating an index by primary key constraint on a partitioned table.
590183 In rare circumnstances, sp_monitorconfig might report higher Max_Used value than configuration value.
590636 A SEGV could occur in norm3_get_node_sqlt() in union queries where there is an expression in the select-list that requires a sequencer node to evaluate it(e.g. - any single table column that appears in an expression in the select-list). This will occur in parallel queries if an XCHG op is placed between sequencer node and union node where it must be evaluated.
590800 In some cases, it could raise meaningless error message when using triggers that select from a text column or an image column of the inserted or deleted table because this functionality is not fully supported.
590845 The message "kernel PCI(M1): PCI Bridge Config: Found incorrect table data, sockatmark() for 1 is not supported" may be reported on Solaris 10 setups unnecessarilly.
591328 The message "current process infected with 11" in the module 'memmove' may be reported in the error log while executing a query requiring to access a partitioned table which partition conditions had to be recreated from source text and statement cache is enabled in the server.
591472 Error 16022 may be reported "The ASE PCI-Bridge is not able to process the requested dispatching. This is a fatal error, etc." when the PCI is unavailable with a stack trace in the error log showing modules "jvminit", "SYB_CreateJavaVM" and "terminate_process" although the stack trace information is unnecessary.
591540 Strong "exponential" performance degradation is observed by customers running ASE_JAVA invoked methods which perform lots of ASE table stored data manipulation or direct Client related data processing. Although it is known that current execution performance is limited with respect to what can be done it was found that certain COTS JavaVM instrumentation flags caused huge impact on top of the current model. These instrumentation flags should not be enabled within customer / production environments.
591604 When statement cache is on and a cached query is run twice with invalid parameter or datatype, 706 error might be raised.
591867 During upgrade from ASE 15 to another version of ASE 15, if 'enable merge join' is 1, the upgrade process fails with a stack trace containing function names alloc_dirtychains() and LeWkTbl::crtWkTbl().
591988 Adaptive Server may hit timeslice error during 'disk init/resize' involving filesystem devices or on usage of the device immediately after creation of the device using 'disk init' for huge database devices.
592686 In a GROUP BY ALL query which has an outer join in which an inner table's column is in the GROUP BY list, there is a possibility of the NULL group not being included unless there already is a NULL value in the column i.e. if all NULLs are created by the NULL extension of the outer join, then the NULL group would not be included.
592745 DBISQL raises a syntax error at line 1, column 1 when trying to use the dbisql CONNECT TO HOST:PORT command syntax against ASE.
592829 In some cases, using duplicate correlation names for the expressions can lead to a stacktrace in function find_dup_corrname().
592948 The newly added optcriterion (disable_nonbin_sortorder_interpolation) will turn off interpolation costing. This is a session-level counterpart of Traceflag 15310. It is OFF by default for all optgoals.
592977 Some queries using "not equal" operators and involving local variables when they are run with SET ANSINULL OFF could return different results from Adaptive Server 12.5 when the results from Adaptive Server 12.5 are considered correct.
593464 Runtime execution errors may happen when executing a stored procedure creating temporary tables with column based on user defined datatypes if the datatype definition is changed between execution of the procedure.
593682 select of varchar returns trailing spaces
594101 The newly added optcriterion (multi_attribute_density_costing) will use the legacy multi-attribute density costing technique. This is a session-level counterpart of Traceflag 437. It is OFF by default for all optgoals.
594140 Error 204 and stacktrace could happen during codegen when SELECTing from a UNIONALL over DISTINCT query and the DISTINCT select list has two char type columns which are equijoin'ed together. This would only happen when the optcriteria "opportunistic_distinct_view" is off (by default it is on) or the DISTINCT select list also has some expression (including subquery).
594228 Executing an OPTDIAG STATISTICS command without specifying a table name may not succeed if an underlying table contains a column name longer than 31 characters.
594364 When the target file of a 'transfer table' command is a pipe and there is no reader waiting to read the pipe, the 'transfer table' command can encounter a time slice error while attempting to open the pipe.
594449 The initial value of "ASE.autoCommit" of setting file".isqlPreferences11" of DBISQL is not correct.DBISQL will work an auto commit. However, on the option screen of DBISQL, an option is OFF.
594489 The predicate transformation code for or-clauses was modified from that of version 12.5. In some cases, this may result in or-clause predicates that reference only one table to not generate new optimizable clauses. Support has been added to revert the same table predicate transformation behavior to be more similar to 12.5. This can enabled using trace commandline flag 15333.
594502 Wrong result could happen for EXISTS/IN subquery with an ORDERBY clause on a character type column under non-binary sort order when merge_join is disabled. The EXISTS subquery's correlated predicate contains only equijoin.
594510 Update and delete queries may choose a bad join order when run in compatibility mode. Specifically, "PLAN FOR ONEROW" scans are not placed at the start of the join orders. This only occurs when the query in run in "restricted compatibility" mode as indicated by @@qpmode=2. See the "Using 'Compatibility Mode' In ASE 15.0.3 ESD#1 For ASE 15 Migration" technical white paper or the "Sybase® Professional Services - ASE 15 Migration Strategy" paper for more details on restricted compatibility mode.
594957 If there are more than 32 keys in a group by and there exists a unique index which has attributes which are a subset of the group by keys, then there is a possibility of a signal 11
595091 Msg 325, Level 18, State 4 may be seen reporting no legal query plan found under specific circumstances pertaining to a TSQL outer join with an or-clause that contains a subquery that references an inner member of the outer join.
595448 Sig 11 at GcvIsVIrtualColumn when using allrows_dss and a query involving aggregation and grouping on same column used in a join with a char/varchar match.
595458 A table corruption may occur with 2525, 1133, or 7968 errors being reported during dbcc tablealloc or dbcc checkalloc when a constraint is dropped and added in the same user transaction.
595516 A 8203 error, "Expected to find the descriptor for object < negative id > in database 2 in DROP state." together with a stack trace which includes the modules 'lwp_drop' and 'des__markdestroy' may be reported in the error log when a session is trying to release a dynamic SQL statement (previously prepared) and concurrently another session is trying to access the same prepared statement, for example using the OBJECT_NAME() builtin with the id used by the internal procedure created for the prepared statement.
595550 A 257 error, "Implicit conversion from datatype '...' to '...' is not allowed. Use the CONVERT function to run this query." maybe be raised when "statement cache" is configured and a client sets the parameters of a store procedure with a different datatype as defined in the store procedure with NULL value. Command line traceflag 7741 could be used to allow the execution of such application with success when 'statement cache' is configured.
595709 Incorrect cleanup of the cursor worktable may happen leaving worktable descriptor in the incorrect state. Additionally the worktable datapages may remain in the tempdb and sometimes different stack trace may happen during cursor cleanup code or while installing/dropping subsequent worktables for the same session.
595713 The DBCC REBUILD_LOG command may assign a used timestamp value for the database.
595882 When execute a select into an existing table multiple times, it could cause stacktrace.
596045 An infected with 11 error on function LeSortInputStream may occur when a query generates a very wide worktable.
596227 When parallelism is turned on, some queries may hang waiting for read operations on pipes.
596593 Using ASE version 12.5.4 ESD# 9 or version 15.0.x using trace flag -T519 to disable streaming sort, Adaptive Server may hit timeslice error when a lot of spids doing sorting or running ASE with compatibility mode.
596623 ASE prints "Warning: ASE_HA has no valid license ..." messge in errorlog even when HA feature is not enabled.
596681 Missing message in outputs of sp_helpconfig for some parameters in ASE 1503.
605364 When ASE is booted with trace flag 9403 Java performance issues may result due to implicit engine affitinity.
605817 Previously in DBISQL 9.0.2 the command "set" brings up the Options dialog displaying the current options, but in DBISQL 11.0.1 the dialog is empty.
605862 If IN lists occur under OR predicates then OR optimization will be considered for example a query such as the following select id from sysobjects c where (id in (1,2) and cache = 10) OR (name="edwin" and uid = 5)
605864 Session can be disconnected if SQL Function references a dropped object.
606015 backupserver's charset setting is not correct.
606096 Corrects a signal 11 which occurs inside the PeAnySetAllPredBm routine, which can occur if the query is complex and IN list within OR predicates
606231 Execute sp_showplan on a running CIS query may get a Signal 11 stacktrace at CgpGenerateSQL::_findVariableValue.
606473 Sybmigrate cannot handle the new device that never used on the source server.
606489 Signal 11 occurs with replication setup when Adaptive server is booted with -psa option to reset the sa password.
606659 If the optimizer chooses a hash-join strategy and the hash key requires an implicit conversion and the build input set has a column with null values, then a 530 error may be generated during execution: Msg 530, Level 16, State 3: Line 2: Attempt to insert NULL value into column 0 in work table (table id 4294967295); column does not allow NULLS. UPDATE fails. Command has been aborted.
606867 A query that contains more than one outer join and one of the inner member's of the first OJ is a derived table or view may return wrong values. This could occur only if the second OJ uses a hash or merge join strategy. Here, first and second are referring to the relative join order processing. Using the following query as an example: select a.c1 from a left join (select distinct b1 from b) as dt on a.a1 = dt.b1 -- OJ #1 left join c on dt.b1 = c.c1 and a.a1 = c.c1 -- OJ #2 Here, OJ #1's inner member is the derived table dt. OJ #2 uses the result of OJ #1 in the on-clause "dt.b1 = c.c1" and these columns are transitively associated to OJ #1's result. All of these on-clause conditions must exist for the problem to occur. In that case, incorrect values for a.c1 may be returned.
607416 sp_object_stats skips to report the lock contention details for the objects in tempdb.
607451 Error 11076 is raised if a procedure name longer than 30 characters is passed to EXECUTE as a variable rather than a literal, i.e. execute @procname. A workaround is to convert this to dynamic sql, i.e. execute (@procname)
607747 If a view is inner to an outer join and a view column has an expression under it which could lead to potential null row extension, it could return wrong results for assigning this view expression to an local variable.
607765 procedure group cannot be created using DBISQL attached to ASE15.0.3 ESDE1 or later. DBISQL returns a syntax error.
607924 this change corrects a "no plan found" error when using trace flag 450
608223 The message "Infected with 11" together with modules like "stio_write_missing_stats", can be found in the errorlog when "capture missing statistics" is enabled and there are greater than 32 missing statistics to report. If the session-level 'set option show_missing_stats on' is used it is also possible to hit this bug, stack trace will include VbmManager::_VbmPutBm() and GttTable::GtGatherNoStats()
608297 DBISQL:To return number of rows when text result style option is choosen.
608362 Expression subqueries in the select list of a view, which is the inner of and outer join, may get merged into an OR predicate which has other subqueries, can result in an incorrect answer. Trace flag 16902 will turn off this change since there may be some performance degradation.
608905 In sybmon, memload might hit signal 11 on a host which has different page size with the host for memdump.
608975 The error 3906, "Attempt to BEGIN TRANSACTION in database 'archivedb' failed because database is READ ONLY. " may be raised when trying to access a partitioned table in an archive database.
609045 Quoted identifiers are inconsistently handled by the SQL Replication module leading sometimes to the syntax errors on the replicated site.
609078 In rare some situation, query with host variables could cause SIG 11 at LeColumn:LeColumn().
609543 A complex query using CIS tables and OR predicates may stack trace with a SEGV in Pop::popIsCollocated().
610076 Querying a proxy table may get a wrong result in rare circumstances when an exact same IN item list is present in different clauses of the query.
610506 QPTune "collect" may appear to hang when processing a large number of rows (eg. about 2M) in the catalog sysquerymetrics.
610763 monOpenObjectActivity does not record stats for system table even if the traceflag 3650 is on.
611152 SET ROWCOUNT does not take effect for CIS quickpass UPDATE, DELETE and INSERT-SELECT queries which do not return a result set.
611385 improved "values scan" costing, which can occur for an "if exists", large "IN list". Previously defaults of 300 rows with 100 pages were used for costing. This behavior is enabled with the cr611385 optcriteria.
611637 if there are 2 or more != or IS NOT NULL predicates on the same column of the form tab.col != constant1 and tab.col != constant2 ... then there is a selectivity estimation error proportional to the number of NULL values in the column. Also, for the specific case of tab.col != NULL, the estimate w.r.t. the ANSINULL state was inverted, i.e. 0.0 if ANSINULL was off, and the number of NULL values if ANSINULL was on.
612264 FORXML query fails to execute if it uses LIKE operator with local variables or parameters. Stack trace is produced indicating module opt_like_and.
612300 User performing a DROP INDEX is blocked indefinitely by the HOUSEKEEPER CHORES process in what appears to be an undetected deadlock.
612316 signal 11 at CgLavaUtils::CgTargetListExprs could happen for DISTINCT view self join. Due to the self join, DISTINCT view has to be materialized using a Store operator. The DISTINCT view select list has a char type column which is equijoin'ed with another char type column. This would only happen when the optcriteria "opportunistic_distinct_view" is off (by default it is on) or the DISTINCT select list also has some expression.
612448 For a query with an expression involving subquery and the expression is projected out and it is also used in local predicates, it could return wrong result sometimes.
612451 On hpia64 and hppa64 platforms, while unmirroring a device, the unmirroring task may hang and subsequently hanging other tasks in ASE. The unmirroring task cannot be killed and the ASE server needs to be restarted.
613054 When a NULL = NULL join is used on top a materialization step such as a vector aggregate or in an extended column aggregate, then there is a possibility of a wrong answer, when the join is pushed down into the materialization step. The NULL = NULL join is created when an explicit predicate such as r.a = s.a OR (r.a IS NULL and s.a IS NULL). The NULL = NULL join can be implicitly created in an extended column aggregate (a non ANSI sybase feature) such as select r.b, avg(r.c) from r group by r.a The NULL = NULL join semantics can be turned off, and instead normal join semantics could be used instead, resulting in a wrong answer.
613305 On Power6 architecture running AIX Operating System, alstat tool shows alignment exceptions when ASE is performing certain operations, for example floating point operations.
613330 sp_setrepdbmode and sp_setrepdefmode with 'threshold' raise an error if you connect to the ASE with japanese language.
613585 Distinct queries that contain a non-correlated subquery in the select list may raise a 530 error (NULL can't be inserted in worktable) if the query uses a distinct_hashing strategy and the non-correlated subquery returns a NULL.
613631 In some situations, computed column could get wrong result from an identity column.
613678 When an SSO drops a login, which is a user in a database having status 'dbo use only', sp_droplogin gives error 923 and 208.
614461 There is a costing adjustment for rid joins that reduces the estimate of in-order rows if a general OR optimization is used or if the non-covered index scan is not clustered. The in-order row estimate is used to help reduce physical IO estimates when good cache hits occur.
614567 Extend internal diagnostics to trace recompilation of stored procedures.
614637 Server hits 806 error when inserting a row into an APL table with non-clustered index, the row being fetched from a cursor that involves the same table again. This situation is only likely to occur when index split happens due to the insertion of data row.
614952 The message "Infected with 11" maybe be found in the errorlog together with modules like "LeOperator*LopScanValues::_lopCodeGen" for queries involving only derived tables and a redundant distinct operator.
614959 Incorrect number of rows (more rows) may be inserted when inserting or selecting into a table from a DISTINCT view or derived table on some outerjoin inner table column, provided there is an extra WHERE clause on the outerjoin inner table column before the INSERT. The extra rows are due to not including the WHERE clause in the final plan.
615110 If a client is old version which can not understand a DATE data type, ASE in compatibility mode may raise a 247 error (Arithmetic overflow during implicit conversion of DATE value to a DATETIME field) on a row containing NULL in a nullable DATE column.
615852 DBCC CHECKTABLE may report invalid very large values for the empty pages and pages which could be garbage collected counters. The correct value is in the lower 32 bits of the reported value.
616415 The message "current process infected with 11" in the module 's_begupdate' together with a stack trace which includes the modules 's_execute' and 'execproc' may be reported in the error log when a stored procedure executes a DML statement which was compiled at runtime and affects a view which had defined an Instead of Trigger.
617605 Network memory pool is exhausted and authentication fails with message in errorlog: ... ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 8192)
617809 Update statistics does not allow "with consumers" and "sampling = n percent" to be specified simultaneously.
617850 If the client is an old client, pre-15 client, in some rare situation it could get unexpected 103 error message for alter table command when a column name is over 28 bytes.
618219 Wrong result could happen when selecting from a distinct view/derived table over an outerjoin with a WHERE constant equality clause (col= < cnt > ) on an outerjoin inner table column and DistinctSorting is in the final plan. This will only effect non-binary sort orders.
618289 User performing a DROP INDEX is blocked indefinitely by the HOUSEKEEPER CHORES process in what appears to be an undetected deadlock.
618469 The message "Current process ... infected with signal 11 (SIGSEGV)" in module "CgEvals::_CgCompVcol" may be reported in the error log followed by a stack trace during the execution of a query involving UDF/ADT constructions. The modules "jvmfini" and "BRIDGEjvm_AbortJavaVM" will also be reported resulting in the current session terminating. This error is caused because the COTS JavaVM integrated PCA/JavaVM cache gets corrupted. Alternatively this may cause ASE shutting down itself. In order for the current fix to be effective and prior to start the COTS JavaVM, the PCA/JavaVM cache needs to be disabled by the SA user by running in the sybpcidb database the command: sp_jreconfig "disable", "pca_jvm_sigcache_enabled"
618513 sig 11 is not triggered on recovery of sybystemdb on 15.0.3 upgrade using in place upgrade. It does not stacktrace on dump and load migration of sybsystemdb onlinedb.
618518 sp_configure 'enable HA' does not report failure on platforms that do not support HA.
618776 In Sybase Central 6.0 the 'execute' button may become inactive when attempting to execute an external web service through the right-click- > 'Execute Web Services dialogue box on the 'Web Methods' tab under the 'Web Services' node.
618778 When compatibility mode is turned on, select assign query which assign a local variable or parameter and use the same local variable or parameter on the qualification side could return wrong results.
619238 Under certain specific circumstances, calling a user defined function within a cursor that is defined in a second user defined function can result in a stack trace in ASE.
619267 User Defined Functions may not get called correctly in queries involving outer joins
619387 Print command in sybmon cannot print double data type correctly.
619396 On the platforms that support dynamic CPU additions, after adding a CPU, ASE engine online fails with error like "kernel ueonline: Not enough CPUs to online engine. Number of CPUs 7. Engine Number 8. Please reset the number of engines at startup parameter."
619707 Errors 208 and 267 'Object not found' may be raised incorrectly from a stored procedure if the procedural statement is compiled in the deferred mode.
619756 Row estimates for a distinct or GROUP BY aggregate operation may not be accurate, which may result in an incorrect row count estimate of 1532 rows. This can occur when there are missing histograms involved on some of the columns or expressions are used for which histograms do not exist.
619916 If a query involes a column from a view and the column is defined as an expression with subquery, and this column appears in the select-list and in a conditional expression(or-clause or case statement) in the query's predicate-list, the query might return wrong results.
619965 if a histogram cell has the specific date "Jan 1 1900 12:00:00:000AM" then it will not be recognized as a dense frequency cell, which means that for this specific date, the range density would be used for an estimation rather than the weight of the frequency cell in the histogram. fix is enabled under optcriteria cr619965 which has been associated with optlevel ase1503esd4 for all optgoals
620045 Under -T2792, if built-in functions are trying to access a table on which a reorg-rebuild is under way there is a possibility of undetected deadlock between reorg rebuild and the running task. Note that 2792 is a trace flag used to make the concurrent tasks sleep when reorg rebuild/AMC is under way instead of throwing 8233 error.
620181 In multi-engine systems, performance downgrade might happen because of high spinlock contention on rdesmgr_spin.
620278 SEGV 11 in AnyDataType::_computeBoolResult.
620587 A 2583 error, "Number of data pages ( < n > ) counted by DBCC differs from count in the data OAM ( < n2 > ) for dbid < db > object .." may be reported by dbcc checkdb when a dump from a previous ASE version is loaded when a table is bound to a named cache.
620677 Procedure sp_spaceusage raises error 247 when run on a table that has more than MAXINT rows.
620992 Under very specific circumstances, delete involving with merge join and using direct update mode an error msg 644 could occur and the delete will fail.
620994 In Cluster edition, Object creation in local temporary databases is slow when there are multiple objects created parallelly in local temporary databases.
621129 A deadlock may be encountered between a task waiting to get the PLC lock and another task trying to latch on a buffer on Sysobjects when a create table is being done on a database marked for replication.
621156 Reference to unknown procedure sp_fragmentation in the definition of sp_index_space_est.
621276 sp_sysmon reports Error 969/14/4 against local user tempdbs
621333 On sunx64 platform, signal context output in sybmon is incorrect.
621449 Enhance Active Messaging to support empty string message properties.
621493 "Sample" command in sybmon show incomplete stack info on AIX platform
621750 In complex nested views on the inner table of an outer join, in which at least 2 nested views have string expressions or constant expressions, then there is a transformation to allow merging of the views. If the predicate is such that the outer join degenerates into an inner join, the resulting strength reduction assumed the previous transformation would only occur once, when in fact it could be nested and occur twice. The end result is a partially dengenerated outer join that results in an inconsistent state that results in a signal 11.
621762 Under some rare situations, if a table has expressions as computed columns and the expressions reference different data types, it could return wrong results.
621817 With the configuration option 'net password encryption reqd' set to 1, the JSagent fails with "ct_connect() failed", "jsd_MakeConnection() failed", "jsj_AddConxs() failed", "jsj_AddConxs() failed" and "Initialization failed initializing connection pool" messages in jsagent log file.
622001 Traceflag 3710 enables an enhancement to improve the performance of DROP INDEX and CREATE INDEX by releasing the system catalog locks when not in DDL-IN-TRAN mode after the commit of the transaction but before post commit work started. This CR is a feature request to make this default behavior and retire the traceflag.
622114 In some situation, if compatibility mode is on, computed column is not getting the correct values from an identity column.
622150 A statement may fail to compile in deferred mode (and will successfully compile in normal mode) when it references a view and there is another view of the same name under the user executing the procedure. With 'set showplan on', you will see:- QUERY PLAN IS RECOMPILED DUE TO DEFERRED_COMPILE_FAIL, TABMISSING. THE RECOMPILED QUERY PLAN IS:
622151 An additional line of client-side output with respect to 'rows affected' may be seen in circumstances where the procedure has been recompiled due to a deferred compilation failure. For example:- 1 > exec p1 2 > go (1 row affected) c1 ----------- (0 rows affected) (return status = 0) 1 > Instead of:- 1 > exec p1 2 > go c1 ----------- (0 rows affected) (return status = 0) 1 >
622771 Error message: ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 2097152) is reported in errorlog and login failures prevent additional user connections.
623274 If a hash-join has a buildset/probeset key pairing of {BINARY/VARBINARY} or a key pairing of {BINARY(length M)/BINARY(length N)} and the binary values differ only by the number of trailing 0s, then these rows won't be returned.
623284 Integrates with new Certicom and OpenSSL security libraries that tackle SSL renegotiation vulnerability described in RFC5746.
623402 Under certain circumstances using daylight saving can cause historical server to generate incorrect date/times.
623412 The message "process infected with signal 11" in the module 'txtimg_get_datarow' may be reported together with a stack trace which include the module 'writetext' when executing the command 'WRITETEXT WITH LOG' on a replicated text column which does not have an index for replication.
623788 ASE can't start Job Scheduler on IPV6 enabled AIX server for specific ipv4 addresses
624017 When RepAgent is configured to use a trace file, trace flags 9200 and 9215 are set and the parameter 'bind to engine' is not set, memory heap corruptions can occur and lead to unpredictable errors in ASE.
624086 The NETWORK HANDLER gets a timeslice error and the stack trace contains pss_init().
624114 In a complex predicate involving ORs in which it may qualify for a "row constuctor" transformation as defined by SQL semantics, if there is a IS NOT NULL or a IS NULL predicate, along with other inequalities, then there is a possibility of a stack trace.
624187 Under specific circumstances during the close cursor of a query involving more than 128 hash distinct operators, an Error: 706, Severity: 20, State: 2 may be seen and the spid terminated - it may also manifest iself as signal 11 in rm_prochdr() if the cursor is non-procedural.
624218 In rare circumstances, timeslice error might be reported when running query on monProcessProcedures.
624245 The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3. The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE. Backup Server error message: Backup Server: Improper parameter count 6 for RPC bs_begin_load; expected a minimum of 3 parameters and a maximum of '5' parameters. The ASE stack trace gives the impression that the problem is complicated. The simple solution is to use the newer version of the Backup Server.
624565 Stored procedure "sp_poolconfig" will fail with return status =1 when configuring/updating cache pools and auditing is enabled.
624734 sp_configure returns no output when sort order is set to case insensitive.
624835 Correlated predicates are not recognized as search arguments for purposes of constant attribute optimizations so a query like select * from t1 where t1.a1 = (select max(b2) from t2 where b2 < = 10 and a1=b1) should behave the same w.r.t. subquery index selection on an index on t2(b1 asc, b2 desc) as select * from t1 where t1.a1 = (select max(b2) from t2 where b2 < = 10 and 5 =b1)
624979 Performance drop with sp_helprotect on databases with large syscolumns tables.
625144 Sometimes the bind cache operation can raise an error 834 at an instance, when one of the other instances crashes.
625356 Diagnostics with "set option show_lio_costing on" was incorrectly reporting large I/O prefetch being used when eventually it was not
625360 Reorg processing messages seen in too long intervals.
625395 The error Msg 3114, "Database does not have an entry in Sysdatabases", can be seen at load transaction time, if we load several transaction dump repeatedly into an archive database, each of them from a different node.
625430 The error Msg 12594,"Unable to obtain exclusive access to database ' < archive_db > ' can be raised when bringing an archive database online on a node in the cluster if the database is loaded repeatedly and each load is done in a different node.
625572 Alter table add partition command on APL tables with clustered index will zero out the table statistics while writing new rows to SYSTABSTATS catalog.
625582 Version string is truncated in sp_sysmon output.
625722 Migration of a client spid from one node to another will fail when using SSL connections. Many errors will be produced with -6989 in the error message.
625816 Fix the 832 error when building index.
625977 Adaptive Server 15.5 ESD #2 adds wait event IDs and descriptions to monSysWaits and monProcessWaits monitoring tables to improve their wait event reporting and eliminating situations in which the same wait event ID was used to report more than one wait event. Adaptive Server 15.5 ESD #2 also adds new descriptions to the monWaitEventInfo monitoring table.
626000 A 702 error, "Memory request for < big number > bytes exceeds the size of single page of 16384 bytes" or some random stack traces may be reported in the error log when a stored procedure (or SQL user defined function) which contains an insensitive cursor involving an expression which results in a size bigger that 255 bytes is executed by reusing a plan generated by a previous session.
626029 If SSL is used, trace flag "3608" will cause ASE dataserver startup to fail.
626258 In situations where only index ddl has been generated, the existence check for the index will not exclude the entry in sysindexes for the table itself. This could lead to a failed drop index on running the script in scenarios whereby a table has the same name as one of its indices.
626423 When upgrading ASE, ASE may encounter conn_migrate_read_context error when restarting, if it was shutdown with migrations in progress.
626435 Signal 11 in LeSQLRep::LeSQLRep is happening occasionally when using SQL statement replication and the ASE is configures with CIS services to access non ASE servers.
626471 Performance of log scans are negatively impacted by the fix for CR 623307. CR 623307 fixed a problem in which a 692 error might be reported by the Adaptive Server Replication Agent task.
626655 If there is an instead of trigger on a view and this trigger has an outer join of inserted or deleted table with other table or view, it could raise 225 error msg when insert/delete/update this view.
626767 Deferred compilation is sometimes not used for a statement with LIKE clause.
626833 cpuinfo.mechanism=NOAPICCHECK exists in ASE-15_0/sysam/ < server > .properties file
626918 Heap memory growth is observed when a readtext or writetext command on a textpointer pointing to a proxy column is executed repeatedly.
627114 ASE configured with hugepages on Linux platform hits leak in hugepages in every boot-shutdown of ASE due to Linux kernel bug . Install Linux kernel patch for this bug to resolve the memory leak.
627118 DDLGEN write objects the order depends on the object ids in sysobjects. This makes it very hard to find differences
627222 Adaptive server might update the values of few page counts in systabstats incorrectly especially for partitioned tables, when upgrading the database from any release to 15.0 or higher.
627722 Intermittent memory errors resulting in various stack traces and 'infected with 11' messages may happen when executing a procedure with a cursor with union operator and if the query returns constant literal values.
627725 This is a memory corruption issue and the following case could cause this memory corruption.If a table is created with a column of BIT datatype and this column is encrypted, after insert a row to this table, the memory could get corrupted. The subsequent queries could get stacktraces or some unexpected results.
627908 BCP into a table with at least one encrypted columns and more than one "bit" type column raises 15417 errors on select of the rows.
627993 A 208 error may be mistakenly reported " < tablename > not found. Specify owner.objectname or use sp_help ..." with Adaptive Server 15.0.3 when a SELECT command is run against an archive database user table and the archive database dump was taken with Adaptive Server version prior to 15.0.
628284 In a rare scenario it may happen that requested lock was granted , but the corresponding lock request is still sleeping.
628305 If forced indexes do not exist then table scans will be used instead of ignoring the bad index id and using the best index available
628311 if a reformat on a table in a "multi-table" subquery is executed outside the subquery (i.e. it was "decorrelated") and if there are correlated joins to that table, then it is possible that cost of the reformat could be very underestimated resulting in a performance issue. optcriteria cr628311 associated with optlevel ase1503esd4 or trace flag 16909 will turn on the change to correct this issue.
628555 Many long-running sessions which need to create worktables, could lead to a signal 11 (or storage access violation on Windows) in memset() and stacktrace. This is due to fragmentation in the Pss Session Heap memory pool
628566 ASE incorrectly reports directio ON in sysdevices table, even if setting directio failed for devices not supporting directio.
628590 'drop role' sql may hit SIG11 in qualpage() due to faulty internal scan method
628691 When a stored procedure is first executed by a session with a particular SET ANSINULL setting (ON or OFF) and later a session with different SET ANSINULL setting executes the same stored procedure then the stored procedure is recompiled. This could cause excessive recompilations if the same stored procedure is executed concurrently by many sessions with different ANSINULL setting.
628845 If running optimizer level ase_current on 15.0.3 ESD#2 or higher (or any optimizer level from ase1503esd2), and your server is configured for parallel, you may see a degradation in performance for certain ORDER BY queries due to the avoid_bmo_sorts optimizer criterion being enabled. optcriteria cr628845 or trace flag 16912 will correct this issue.
628867 signal 11 on solaris, and error 403 without stacktrace on aix with insert into a table after adding a check constraint on encrypted column with a decrypt_default
628876 A new script "registerASEIP" is available under $SYBROOT/DBISQL/bin. Execute this script to register ASE DBISQL Plug-in with DBISQL. Normally the plug-in is registered by the installer. The script is useful when DBISQL's registration file ($SYBROOT/DBISQL/bin/dbisql.rep) contains invalid paths when, for example, when user copied the release directory into a different location.
628996 monSysStatement table report incorrect CpuTime and WaitTime when nested procs are used
628997 Sometimes a 605/696 error "An attempt was made to fetch logical page < page > belongs to object with id ..." may be falsely reported during INSERT. The modules pg_allocate() and pg_latchoam() will be reported in the stack.
629164 Fix 832 error when reorg rebuild a lot of index partitions.
629322 In queries with EXISTS or IN subqueries that get flattened and a CIS table is referenced in the main query (not the subquery), then there is a possibility for a stack trace if a unique index exists on the CIS table, if not all the columns in the unique CIS index are referenced.
629634 Backup servers are not roundrobin'd in a cluster after an error at one of the backupservers.
630246 In 15.0.3 ESD #3 and 15.5 ESD #1 there may be incorrect answers or stack traces in queries involving OR predicates (i.e. IN lists) with equi-sargs on the same column, and joins to columns on differing datatypes e.g. r.intcol in (6,10, ...) AND r.intcol = s.numericcol This should only happen if constants are used without literal parameterization, i.e. using variables in the OR predicate should avoid this error.
630362 Server Properties Configuration page would not allow value to be changed when the configuration parameters are filtered. The workaround is to use up/down arrows of the table cell spin box to change values.
631179 A 14108 error, "Could not find partition descriptor for objid < objid > , indid < indid > , ptnid < ptnid > in dbid < dbid > " may be reported when creating a huge non-clustered index on an allpage-locked table using parallel sort.
631204 The message "Native thread (ThreadID < value > ) infected with 6", OR "PCI(T1): - > PCA_JVM: JVMLOG 'FATAL ERROR in native method: Bad global or local ref passed to JNI'" followed by "PCI(T1): JVM_ABORT called - ignore", OR "PCI(T1): DEBUG: pci_command_stop; Request to stop slot 1" may be reported in the error log during the execution of a query involving UDF/ADT constructions. This error is caused because the COTS JavaVM integrated PCA/JavaVM cache gets corrupted. This will result in either the current session terminating or ASE shutting down itself. In order for the current fix to be effective and prior to start the COTS JavaVM, the PCA/JavaVM cache needs to be disabled by the SA user by running in the sybpcidb database the command: sp_jreconfig "disable", "pca_jvm_sigcache_enabled"
631308 If a scalaragg is projected from a view (or derived table) and the scalaragg is subsequenctly used in a group-by clause and the result of the scalaragg grouping column is is subsequently joined to itself, then a SEGV could occur in _CgReplaceVars(). Note extended column semantics will create an implicit join between the grouping instance of the scalaragg and another instance of the scalaragg. The following extended column query is an example of the problem: select s.c3 from (select count(r.c1) cntem, r.c2, r.c3 from r) s group by s.cntem, s.c2
631382 Possible 712 error and stack trace when using reserve_identity for many reservations over a long lived session.
631531 Renormalization of stored procedure or triggeres may fail with error 208 (Object not found) if the procedure was created by the user with 'sa' authorization under impersonated user with setuser 'username' command and the execution is done by the real connection with 'username'.
632330 Need to migrate option "builtin_date_strings" for cluster edition.
632515 alter table with 256 length encrypted column and init_vector is 30x slower on 15.0.3 than it is on 12.5.4 and windows.
632572 comparison of metadata names sometimes ignores the sort order character semantics for comparisons of table names, correlation names index names, work table names, disk names, view names, node names. This could result in name mismatches with mixed case for nocase installations.
632623 Trace 299 has no effect on queries with outer joins if the temporary table has the outer position in the join.
632694 891 error along with stacktrace may be reported when creating placement index on empty non-partitioned DOL table to which a named cache is bound implicitly or explicitly.
632760 When reconfiguring the option "optimizer level", the new value is shown as INT instead of STRING in the config file, which may cause server boot failure.
633087 After a placement index column of empty DOL table is changed using ALTER TABLE cmd, error 2583 may be reported when running "dbcc checktable" on this empty DOL table.
633168 A client which can not understand a BIGINT data type may get a tds protocol error when trying to retrieve a signed 8-byte integer value in compatibility mode.
633287 Error 100016 will occur when doing dbcc checkstorage after create placement index on unpartitioned DOL table using parallel sort and not explicitly requesting multiple consumers.
633942 When an expression contains the string concatenation operator "+" that references a column in the inner table of an outer join and that expression is in the WHERE clause, then the outer join can degenerate into an inner join (as seen in showplan) resulting in an incorrect answer with null-supplied rows being eliminated.
634285 A global reference to a Java object may be mistakenly destroyed twice, resulting in methods being executed unexpectedly due to class-loader structures getting corrupted. Alternatively Java Null Pointer Exceptions may be raised within classes unexpectedly. When global references get destroyed repeatedly, this will result in the COTS JavaVM aborting.
634875 ASE 15.5 running on Windows can’t be shutdown using the Windows Services Manager. Stack trace is seen in error log referring to storage access violation in syb_polite_shutdown
635084 At the end of a load sequence, a database incorrectly inherits the database timestamp of the database into which the load was done, if that is bigger than that of the database that was dumped.
635453 sp_post_xpload without force option will cause error605(reindex)
635627 In rare circumstances following the undo of a deallocation, the database timestamp may be inadvertently set higher than it needs to be, increasing the likelihood of running out of timestamps for any database during its lifetime.
635778 The message "process infected with signal 11" may be reported in the error log together with a stack trace which includes the modules 'lt_sqlrep_comp_policy', 's_compile_stmt' and 's_recompile' when a DML command is ran and the involved queries are eligible for SQL Statement Replication.
637828 ASE tasks may be terminated with a timeslice error if the ASE is running a multi-byte character set and SQL batch capture is configured to 1. The stack trace may contain oh_get_obfuscated(), copy_sqltext() and sqlpars().



  • 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 ; Sybase Adaptive Server Enterprise 15.5


CR, ASE 15.5 ESD#2, ASE 15.5, ESD#2, 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.