/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.
If the EBF/SP has been released, check the CR list and coverletter at the service.sap.com.
Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.
| CR Number | Description |
|---|---|
| 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 "sybhautil.pm". |
| 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: 3.31.2.3: 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 https://bugzilla.redhat.com/show_bug.cgi?id=593131 . 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(). |
Read more...
Environment
- AIX 64bit
- HP-UX on IA64 64bit
- Linux on Power 64bit
- Linux on x86 64 64bit
- Solaris on Sparc 64bit
- Solaris on x86 64 64bit
- Windows on x64 64bit
Product
SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.5
Keywords
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)