/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 |
|---|---|
| 52945 | Enhance sp_dboption to instruct the user when to run DUMP DATABASE in case options like 'trunc log on chkpt' or 'select into' are changed. |
| 348743 | New Feature: Java in ASE to support java.security package. |
| 360969 | Eliminate duplicate wait event descriptions in the monWaitEventInfo MDA table. |
| 392556 | sp_monitorconfig reports a high value for Num_Reuse output per pss resources and doesn't correlate with the values displayed in column Num_Active. |
| 397291 | Global variables may return invalid negative values |
| 397342 | Flush all data to the Sybmon log file whenver the 'log off' command is executed. |
| 402472 | Historical Server playback mode returns incorrect information on 64bit platforms |
| 405784 | The "Add" items (e.g. "Add Database Device") in various folders, normally used for opening a wizard, are replaced by toolbar buttons (e.g. "Database Device" button). |
| 415162 | On a heavily-loaded system, the message "The Java VM associated with process < spid > is abnormally terminated" in the jvm module may be reported in the errorlog even though the client performing the java work terminates normally. |
| 426791 | ASE hangs or crashes when 3604 flag is enabled along with 7825, 7826 or 7827 flags. |
| 430568 | Feature request to increase or eliminate the current limit of 48 on number of execution classes. |
| 432469 | There is no error message in the errorlog indicating shared memory is locked successfully into physical memory or otherwise. |
| 436330 | Under rare conditions querying the monOpenObjectActivity table may result in error 14108 or a stack trace reported in the error log including the modules "mda_populate_monOpenObjectActivity", "mda__accumulate_ptnstats_for_obj" and "ind__get_sysindrow". |
| 438678 | User may receive bogus SySAM warning emails during product installation. |
| 440821 | Add to installmaster a new system stored procedure (sp_tab_suspectptn) to list table(s) with suspect partitioning. |
| 440924 | ASE prints the User Connection Report at the 24hr interval irrespective of the license type. |
| 441274 | CREATE RULE statement incorrectly allows the creation of rules that use subqueries on its definition. |
| 441776 | Historical Server version 12.5.4 crashes using the 'direct load to ASE' feature when executing hs_create_recording_session. |
| 442525 | A union with subquery in the result list may fail with error 530 ("Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails.") if the subquery is producing empty result set. |
| 444292 | The common name in ASE SSL Certificates is restricted in that it must match the name of the dataserver. |
| 445595 | Add a MaxOutstandingIOs column into monEngine for "Max Outstanding I/Os" per engine. |
| 447210 | Need updated/configurable java VM in ASE for upcoming changes to Daylight Savings time. related to Solaris issue http://sunsolve.sun.com/search/document.do?assetkey=1-26-102178-1. Customer would like to know the versions and date as soon as possible. |
| 452033 | Backup Server needs to print Open Server operating system related error message in error log as well as standard error. |
| 452178 | Optdiag input mode may fail with error message "At step < n > of the histogram for < column > , the step value is not increasing" for variable length datatypes. |
| 453103 | After primary service group fails over to secondary node, the primary HAase resource cannot go offline if the secondary ASE resource is already offline. The failure to go offline properly may also prevent primary HAase resource from going online on secondary node later even if primary ASE resource is brought back online. |
| 454460 | Query executed from the trigger and referencing tables INSERTED or DELETED may fail with errors if the optimizer decides to apply a strategy which is using a worktable based on INSERTED or DELETED table. |
| 454609 | Table scans on DATA_ONLY locked tables running at isolation level READ COMMITTED may sometimes fail to return qualifying rows if there are concurrent INSERTs/UPDATEs happening on the table. |
| 460825 | Execute immediate queries referencing outer scope variables may sometimes fail with syntax error about non declared local variables. |
| 460907 | Under certain circumstances, when ASE is using Java(enable java = 1) with multiple engines online, server may crash with signal 11 in kbfalloc routine. |
| 461201 | Poll for all completed ct-lib I/Os issued from the engine every time the scheduler checks for I/O completion. Also, the engine does not relinquish CPU to the OS if there is any pending ct-lib I/O from that engine. |
| 461850 | A new configuration parameter called 'bind to engine' added for Rep Agent. Using this Rep Agent may be forced to run on a particular engine. |
| 462331 | soc_printpeername should print port number of client associated with invalid tds |
| 463176 | Schema count is not incremented correctly for a table when dropping a foreign key constraint on if a table has multiple foreign key constraints. A stored procedure using this table will not automatically be recompiled yielding a 3601 internal error. |
| 464192 | In some circumstances, the message "current process infected with 11" together with a stack trace that includes the modules "fdpr_glue_tramp_align__fdpr", "conn_hdlr__fdpr", may be reported when using XML features on IBM Linux Pseries platform. |
| 464760 | Login to ASE using LDAP may hang with the message "Waiting for native threads to be released, or for 'max number of ldapua native threads' to be increased." even after increasing value of 'set_max_ldapua_native_threads'. |
| 465198 | infected with 11 in OptGlobal::_GblInitPopRules due to size of 0 |
| 466507 | Running the installer with "-options-template" switch generates an incomplete options file. |
| 467566 | Specifying an abstract plan (AP) with any query will cause the query not to be stored in the statement cache. |
| 468188 | SELECT INTO query with UNION may not execute correctly if the query plan generated for the parallel execution will be adjusted to the serial execution. |
| 468715 | If current LDAP URL state is ACTIVE, it becomes READY after sp_ldapadmin 'activate'. |
| 469316 | A login occurring during engine startup can hang until another login occurs when extended password encryption is used to encrypt passwords on the network. |
| 470113 | RPC call from ASE12.5.x to ASE15.0.1 might not work normally when sending bulk data. Increasing ASE parameter "remote server pre-read packets" from the default value 3 to 200 can workaround the issue. |
| 471674 | A 835 error (Illegal attempt to change contents of buffer) may be reported on Linux 32-bit systems, if the extended cache is enabled. This CR fixes the problem. |
| 472260 | Previously Database Device Wizard asked for device path first before device name. This has been reversed to be more consistent with other wizards. |
| 472679 | When running "sp_spaceused" stored procedure without any parameters against a database with a very large log device, response time maybe slow. |
| 472783 | The sp_modifylogin setting "max failed_logins" is documented to be the number of allowable failed logins before the account is locked, however ASE is locking the account upon that number of failed logins. |
| 472960 | Attempt to convert UNICHAR data to TEXT succeeds on the first row but fails on subsequent rows. Example: select convert(text, my_unichar_col) from table. |
| 474593 | When configuration option 'select on syscomments.text' is set to '0', Adaptive Server doesn't permit access to 'text' column of syscomments by non-sa users. |
| 474808 | When setup with "-console" is executed,some parts of License Agreements in Japanese are unreadable. |
| 474897 | The 'srvbuild' binary when used on solaris 10 will fail if there is no existing interface file. |
| 475245 | In some cases, DDLGen incorrectly misses out the WITH OVERRIDE clause for the last disk piece of a database when generating the DDL for multiple databases named by a pattern specifier. Also in some cases, when generating the DDL for a single database, the WITH OVERRIDE clause is generated for some ALTER DATABASE statements even when it is not necessary. |
| 476068 | 18278 error occurs when the number of unrelated execution classes exceeds 50. |
| 476090 | On some storage devices when creating a new ASE server the srvbuildres utility will erroneously report that the master device does not exist. |
| 476441 | On IBM AIX platform, Backupserver can occasionally give false io errors due to a synchronisation issue. The error message could be similar to the following: D00: SYBMULTBUF ERROR: Wait for i/o completion failed: State=zzz, Msg=Attempted to transfer xxxx bytes, but yyyyy bytes were transferred by operating system call read/write. Backup Server: 4.145.2.22: [zzz] Error for device ' < device > '. Attempted to transfer xxxx bytes, but yyyyy bytes were transferred by operating system call read/write. |
| 476631 | When executing a stored procedure with trace flag -T299 (to open temporary tables by name and avoiding recompilation of procedures using externally created temporary tables) the ASE may decide to renormalize the procedure too often. This happens if a procedure includes a statement performing covered index scan on a temporary table created outside of the procedure. |
| 477152 | sp_fixindex run for the Sysusages clustered index may lead to errors 8204, 806 and ASE boot failure. |
| 478171 | The BatchID column value in the monSysStatement and monSysPlanText MDA tables may be different for statements executed within a single batch for statements using execute immediate or deferred compilation. The monSysStatement and monSysPlanText ContextID value is not set consistently. |
| 478928 | Auditinit may incorrectly claim that there is not enough free space on the specified device(s). |
| 479378 | To support SQLs UDFs in ASEP. |
| 480644 | A new string comparison implementation for GBPINYIN and GBPINYINNOCS sortorders has been incorporated into ASE to improve query performance on queries involving Simplified Chinese (GB) characters. This essentially replaces the default string comparison processing which uses the Unilib APIs. Streamlining the Unilib comparison removes the processing overheads hence improves performance. The new implementation supports the existing GBPINYIN and GBPINYINNOCS sortorders for UTF-8, CP936, GB18030 and EUCGB charsets. A boot-time Traceflag 2411 is available to revert back to the default behaviour. |
| 480690 | ASE version 12.5.4 ESD #5 and 12.5.4 ESD #6 on Solaris may show higher cpu utilization due to a high number of brk system calls. |
| 481144 | Parsing of very large TEXT literals may case timeslice errors in heavily loaded systems. |
| 482129 | Under some circumstances the message "current process infected with 11" maybe reported in the error log when executing a batch of DML statements and a trigger executed a ROLLBACK TRIGGER WITH RAISERROR. |
| 482398 | If an attempt is made to use DISK INIT/DISK RESIZE to add more space to a device than is actually available, the command aborts on some systems and on some systems the commands executes to add as much space as is available. |
| 482482 | When killing a task in "LATCH SLEEP" state, message "Killing spid: < SPID_1 > will not be immediate because it is waiting for a latch held by spid: < SPID_2 > ." will be printed to the errorlog. This connection cannot be killed until all latch owners have completed their work or terminated. |
| 482563 | Unnecessary join with sysprocedures, in a SQL command in the procedure 'sp_sproc_columns'. Its columns are not being used either in projection list or where clause. This is leading to more I/Os which are unnecessary. |
| 483642 | No error messages or trace information is available when the High Availability agent for ASE on Windows/MSCS cluster decides to failover sometimes. |
| 484076 | Under some circumstances the execution of a stored procedure which uses execute immediate for creating other stored procedures and had to be recompiled maybe be aborted reporting in the errorlog the message "current process infected with 11" in the module 'set_cast' including a stack trace which includes the modules 's_renormalize' and 's_recompile'. |
| 484098 | HA VCS 4.x: Enhanced diagnostics information for the VCS4.x HAase Agent. Also fixed a possible hostname comparison failure when one hostname obtained is short form of the hostname, and another is a fully qualified hostname with tailing domain name. |
| 484549 | Explicit or implicit convertion of java datatypes may someties lead to the corruption of the query plans. |
| 484805 | Numeric modulo function can generate wrong result when aggregate functions are involved in the calculation. |
| 484982 | When long running chained transactions are left active in the database, even though they have not done any DMLs, they may prevent housekeeper from doing garbage collection in the database. |
| 486766 | A join query with a plan using the Dynamic Index strategy may sometimes fail with error "Msg 1504 Internal Sort Error. Empty Index Page found.". This may happen if the optimizer decides to use the Dynamic Index as an inner table in the join and the parallel sort is applied to the Dynamic Index worktable. |
| 486888 | The Monitor Server can be slow in detecting ASE has shut down. This can lead to problems on restart. |
| 488339 | For query with varchar/varbinary column and there are a lot of histogram steps on the column, the compilation could hit the Assertion ((*ppFreeBase > = *ppBoundary + ElementSize) || (*ppFreeBase + *pFreeSize < = *ppBoundary)) failure under diagserver. Under non-diagserver, it might lead to memory corruption and signal 11 stacktrace in the optimizer statistics handling code area. |
| 488436 | Backup server may display configured shared memory per stripe value incorrectly. The message with wrong value will be as follows (in this example, 0 indicates wrong value. It could be other value): "Backup Server: 1.70.1.2: Configuring the shared memory per stripe to 0 bytes." |
| 489273 | Job Scheduler stored procedure sjob_control enable / disable fails on cursor execution |
| 489402 | Job Scheduler stored procedure, sp_sjobcontrol, may fail with invalid cursor name |
| 490808 | PowerTransfer does not support the Sybase traditional "-I" parameter to specify an alternate location for the interfaces file. |
| 491127 | Sybmigrate may fail against 15.0.2 or higher when translating sysservers due to added column srvstatus2. |
| 491163 | Outer join queries that incorporate a merge-join/hashjoin strategy may not return null-supplied rows. |
| 491593 | When like clause contains expressions such as 'a12' + '%', the query may run slower where a table scan is choosen instead of index scan. |
| 491882 | Historical Server doesn't respond anymore after hs_create_recording_session is issued. |
| 492349 | Connecting to a remote server that has not been started hangs if the retry and delay counts are configured for the remote server in the interfaces file. |
| 492373 | Implementation of "Large Page" support on AIX platform |
| 493198 | Pre-12.5.4 and pre-15.0.2 logins need an upgrade action so that "Authenticate with" functionality will properly work for KERBEROS logins. An upgrade action should modify the status bits so that values 244 or 480, which have meant 'ANY' in the past, are reset to 0 in the 4 authentication mechanism bits of syslogins.status |
| 493736 | During UPDATE STATISTICS, the number of extended steps, that is, the product of the requested step count and the histogram tuning factor, is restricted to the maximum of 10% of the number of rows in the table and the requested step count. However, if the histogram tuning factor is at the default value of 20 and the proposed number of extended steps is greater than 400, then the actual number of steps in the histogram is restricted to a maximum of the requested step count and 400. |
| 494315 | If a query which uses distinct either explicitly or implicitly and no legal query plan is found and it is observed that there has been a timeout event during optimization then it may be due to this CR |
| 494709 | The dataserver engine fails to restart after running CSMD in sybmon. |
| 495055 | When sp_monitorconfig "number of user connections" is run, the result may show "Num_active" and "Max_Used" as 0. |
| 495587 | 12.5.x OpenClient that are using SSLPlus 3.x cannot connect to ASE15 or OpenServer with 2048bit RSA keys. |
| 495877 | Signal 11 (SIGSEGV) could happen in the module 'ResRelOp' when compiling a query qualified for a general OR plan (e.g. with IN predicate). Also it would only happen when the index used for the general OR doesn't cover all search clause columns of the table and there is some equijoin on the column which is not part of the index. |
| 497387 | ASE 12.5.4 ESD#8 Installer would not proceed again when a wrong directory is specified in the first instance. |
| 497557 | A 821 error "Attempt to unhash buffer in cache ..." may be reported in the error log together with a stack trace which includes the modules 'buf_online_database' and 'cm_bufunhash' when an offlined database is in the process of being onlined while a concurrent session is trying to run a DBCC command in the given database. |
| 498072 | When the 'expire login' option of sp_passwordpolicy is set to '0', the password of new logins are expired and needs to be changed upon first login. |
| 498076 | When a database is set in single-user mode and one tries to start the replication agent on the database, replication agent does not start and reports errors 924, 9229 and 9241. Subsequent attempts to re-start replication agent will fail with error 9262 and 18421. |
| 498088 | SySAM2.0 setup of ASE15.0.2 installer can be set up only at once. When you make a mistake in a setup of SySAM2.0, please modify using a sp_lmconfig command. |
| 498184 | Clarification of error message 7628. This error needs to explicitly state that the ASE must be rebooted to start the auditing process. |
| 498215 | When Running the following query sp_helpdevice it is taking DBISQL a very long time to return the plan in the plan tab. In some case past the five min mark. Seems to be performance degregation going on. |
| 498243 | Request to support configurable keystore for SSL certificates. |
| 498930 | Remove licensing requirements for Java in database feature. |
| 499058 | Improved "insert into < table > values " performance when statement cache is off. |
| 499092 | Update variable assignment expression involving subquery was being evaluated at the Subquery Filter operator in order to improve subquery performance and avoid possible exception. But this led to some undefined behavior change compared to pre-15.0 with respect to some form of variable assignment. This happens only because we use a form on non-deterministic SQL syntax that is well documented. The fix here is temporary in nature using trace flag 15322 so that customers could use the old semantics with the possible caveat that this could lead to run time exceptions or performance issues. |
| 499408 | When real time messaging is enabled on ASE to use MQ. The additional engine spawned to handle MQ tasks uses up very high cpu even when there is only 1 messaging operation. |
| 499656 | Different messages are printed on error of dropping a login through sp_droplogin when ldapua is enabled and disabled. |
| 500330 | sp_sysmon "app_only" stops reporting application detail after several hours |
| 500736 | Character data type table column in the SELECT list might return unexpected trailing blanks when the column is involved in an equjoin with some character data type expression. Also hash/merge join was not available between character data type column equijoin under nocase sort orders. |
| 500872 | After a database dump and load, ASE may not be able to access the SQL UDFs created before the dump. |
| 528407 | In some circumstances, Adaptive Server may throw a message "current process infected with 11, in the module CgpUnion::_CgpInitProjection, together with a stacktrace which includes modules like CgpMergeUnionAll::cgpInit", when a UNION ALL query is being executed. |
| 528604 | On the Solaris platform, ASE may encounter a timeslice error during boot if ISM (intimate shared memory) is in use and the amount of memory configured is approximately 100 Gb or more. |
| 528830 | Previously DBISQL11's OUTPUT command did not work in command-line mode. This has been fixed. |
| 528833 | Previously DBISQL 9.0.2's PARAMETERS command did not work properly. This has been fixed in DBISQL 11.0. |
| 528848 | For failed authentication, authentication mechanism is missing in login audit record. |
| 528854 | Auditing of dropping and adding user messages prints the database user name information in the "objowner" column of the audit record. |
| 528994 | Previously, DBISQL11 would report a synax error if you executed an INPUT, OUTPUT, or READ statement which was followed by "GO". This has been fixed. |
| 529256 | Checkstorage may fail on 64bit platforms, with an arithmetic overflow error 247 followed by error 12964 DBCC cannot insert the row in the dbcc_operation_log table for this check of database '%s', aborting check. |
| 529566 | New feature: Create a password_random() built-in that generates a random password which satisfies the password complexity "minimum checks". |
| 530220 | Kerberos logins with connection failover support fail to connect to ASE when HA is configured. |
| 530481 | LDAP URL setting did not fail when the access account distinguished name (DN) is an invalid or non-existing DN. The error 'No such object' is returned by LDAP server for invalid DN. |
| 530498 | Misleading error message from Backup server indicating write failure for archive device during load operation. The actual failure occurs while writing to data device. Following or similar error messages could be seen in errorlog: D01: SYBMULTBUF ERROR: Internal error: In db_proc, the C_MBUF command is invalid when the context is DEST_RUN. Backup Server: 4.145.2.22: [107] Error for device ' < archive_device > '. Attempted to transfer xxxxxx bytes, but yyyyyy bytes were transferred by operating system call write/read. |
| 530618 | Indirectly activated sa_role is not able to execute system stored procedure sp_listener. |
| 530958 | Introduce a new dbcc command to delete a particular plan or all plans associated with a particular procedure from the procedure cache. dbcc deleteplan(db_id/db_name, obj_id/obj_name, plan_number) Delete the procedure plan specified by plan_number dbcc deleteplan(db_id/db_name, obj_id/obj_name, 'all') Delete all plans associated with this procedure object. |
| 531043 | In case of database with mixed log and data, 603 error (out of session descriptors) might occur due to lot open descriptors on an object with id 99. |
| 531111 | When 'statement cache' is enabled, Adaptive Server might incorrectly display that it is using an expression to evaluate the selectivity of a predicate containing a 'BUILT-IN function' as part of 'set option show long' output. |
| 531199 | Optimizer doesnt consider certain query plans for large queries, which could result in suboptimal query plans. |
| 531713 | UPDATE with view and inner join fails with error 206. |
| 531911 | Install JRE 1.6 in $SYBASE/shared for ASE 15.0.3 release |
| 531947 | dbcc replicate_txtcol does not reflect 4th parameter (setrep_index) in the 9142 message. |
| 531964 | The sysprocesses cpu and physical_io fields are both flushed together whenever the lesser of the "io accounting flush interval" or "cpu accounting flush interval" is reached. |
| 532198 | When ASE starts up with large default network packet size which is equal to max network packet size, ASE may raise a message "usinitpktsz: Unable to allocate overflow buffer of size xxxxx from pool". |
| 532743 | Running a query with large joins of more than six tables may get a stacktrace in the module 'stat_add_sample'. |
| 532911 | Kerberos logins with 'data integrity' or 'replay detection' option (-Vi, -Vr) may raise a TDS protocol error: "An invalid PARAMFMT stream was received." when a query is sent to ASE. |
| 533001 | External LDAPUA/PAMUA login accounts with 'CREATE LOGIN' mapping failover to ASE authentication when 'enable ldap user auth'/'enable pam user auth' is set to 1. |
| 533030 | When LDAP User Authentication is configured and there is exactly one mapping of LDAP user to ASE login, then synchronization of LDAP and ASE password fails. Additionally, when LDAP server is down and failover to ASE authentication is permitted by configuration (enable ldap user auth = 1), then providing LDAP user name with correct password fails the login - despite the fact that there is mapping of the LDAP user to ASE user. |
| 533277 | A query involving a UNION such that 1) one side of the UNION is a SELECT from a derived table involving a join between two tables with a DISTINCT on the projection; and 2) the other side of the UNION is a SELECT < constant > might lead to wrong results. An example query would be: select et.col1 from (select DISTINCT et.col1 from et, cl clkp where et.col2 = clkp.col2 and clkp.col1 = 'Dependency' ) et UNION select 'All' |
| 533419 | ASE does not set the length for text columns in dynamic sql statements |
| 533467 | A query of the form: INSERT tab1 SELECT ... UNION ALL SELECT ..., where the second SELECT contains a NOT EXISTS subquery that references the target table (tab1) may insert extra rows into tab1 in ASE 15 compared to pre-ASE 15 versions. The ASE 15 behavior is the expected behavior, but to maintain backwards compatability, command line trace flag 9580 has been introduced to force pre-ASE 15 behavior. |
| 533686 | The message "User has been dropped from current database" may be mistakenly reported when SP_DROPUSER is run although the user to drop is not actually dropped. |
| 533812 | If an insensitive cursor referenences a java ADT, then doing fetch may hit error 'process infected with signal 11" with stack trace in the module of jcnstGetObject() and LeEmitSndOp::_LeEoRouteResults(). |
| 534108 | In multidb transaction, tempplc gets flushed even when it is not necessary. |
| 534175 | Query with a groupby under a correlated subquery might miss a much better execution plan if the groupby itself also has its own correlated subquery. The better plan would be evaluating the groupby only once and storing the intermediate result in a worktable. |
| 534293 | When there is an entry name " < hostname > " exist in interfaces file, custom configure js cannot proceed. |
| 534553 | DBCC TABLEALLOC/TEXTALLOC/INDEXALLOC when run in 'OPTIMIZED' mode and with the 'FIX' option supports the correction of '100039' faults reported by DBCC CHECKSTORAGE for user tables; this fault describes an incorrect extent OAM page hint. |
| 534554 | Dynamic Buffer Allocation for group_hashing and distinct_hashing strategies is limited to sessions where the tempdb is bound to a named cache. |
| 534605 | A stored procedure, which creates a table and reads or writes that table, may incorrectly access a table by the same name created outside of the procedure. This happens in the following circumstances: - Database owner creates procedure - Database owner creates a table with same name as table created in procedure - Procedure is executed by a non-database owner - Procedure's access to the table is specified without qualifying the table name with an owner name. |
| 534688 | On IPv6 enabled machines, the sp_listener stop/suspend command fails to stop/suspend a listener after starting the listener successfully by the command "sp_listerner start". |
| 534827 | Query with AND/OR clauses may stacktrace for certain order of OR clauses in the query. |
| 534890 | Arithmetic overflow for numeric +/- expression involving more than 2 operands could happen during execution. |
| 535392 | Procedural query compiled in the deferred compilation mode may fail producing stack traces if during the compilation the server has to perform the internal upgrade of the DEFAULT clause. Errorlog indicates modules 'add_default', 's_getTreeOrPlan', 's_reinstallProcTree' and 's_normalize'. |
| 535559 | Repeat to issue the message reporting that there are insufficient spinlock monitors to monitor all allocated spinlocks. |
| 535630 | The error 206 is raised when executing a query containing views and involve nested outerjoins. |
| 535666 | TEXT values returned by remote procedure calls with CIS RPC handling could be corrupted when UTF-8 character set is used. |
| 535719 | When turning on statement cache, subsequent execution of a query on VIEWs that fires an instead-of trigger and involves LOB may hit SIGSEGV and stack trace from the module 'eval_locator_bi'. |
| 536105 | There is a syntax error in GenericTempUtil.sh when used on AIX platforms. It can be corrected by changing: export LIBPATH $SYBASE_JRE'/bin:'$SYBASE_JRE'/bin/classic' To LIBPATH=$SYBASE_JRE'/bin:'$SYBASE_JRE'/bin/classic' export LIBPATH |
| 536161 | The Sybase Central ASE Plugin may display negative or otherwise incorrect values for the unused space field under the devices tab. |
| 536186 | For self-join delete queries, different rows may be deleted depending on the table order in the FROM list. By default, the first reference to the table being deleted in the FROM list, whether it has a correlation name or not, is used as the source of rows to be deleted. Under command line trace flag 120, if there is a reference to the table being deleted without a correlation name, it will be used as the source of rows to be deleted, regardless of where it appears in the FROM list. If no table without a correlation name is found, the first reference to the deleted table will be used as the source of rows to delete. |
| 536314 | On Unix systems other than Solaris, a server may hang under heavy CPU load while executing the command DBCC STACKTRACE(0,-1,1) and the server may not accept any new connections. |
| 536528 | Appropriate errors are raised for DDL operations that do not suitable for VHASH table. |
| 536565 | Max row size limit is unchanged when alter table lock scheme is done more than twice. |
| 536616 | ASE gets infected 11 in sqx__do_transform during update statement w/ trigger |
| 536815 | The message "Failed to allocate memory for column level datachange counters for database 'dbname' (dbid), 'objname' (objid), ..." may be reported in the error log mistakenly when a session is killed or otherwise interrupted. |
| 536894 | When the following conditions are true: 1. trace flag 7725 is on 2. abstract plan load is on 3. enable literal autoparam is on if failed to associate APs with the parameterized text, text will be parameterized again using 15.0.1-style autoparam name, and retry AP apply with the new text. |
| 536912 | Loading a 12.5 transaction dump including REORG REBUILD log records into a 15.x ASE may fail with a segfault error showing the modules 'bt__rebld_row' and 'bt__rebld_prepdestrow'. |
| 537367 | Under rare circumstances the message "process infected with signal 11" in the module 'ind__ides_getnext' may be reported in the error log with a stack trace which includes the modules 's_compile', 'substitute' and 'ind_rowcopy' when a SQL command is in the process of being compiled. This will result in ASE shutting down itself. |
| 537570 | SEGV in the module 'CgpInplaceUpdateVars' could happen when the query has a subquery under an OR predicate and there are more than 6 joining tables. |
| 537601 | Executing a query having more than 6 tables may hit a 540 error when the optimizer's alternative greedy algorithm leaves tables opened in the event of an exception. |
| 537823 | In some circumstances, queries involving declared variables may result in character interpolation assertion (ratio > = 0.0 && ratio < = 1.0) on diagservers. |
| 537887 | Overwriting of authentication mapping takes place silently without any warning. |
| 537931 | When the number of free object descriptors is less than the number of objects with entries in sysprotects calling sp_helprotect without parameters can flush the object descriptor cache. |
| 538161 | sp_statistics could return arithmetic overflow during implicit conversion of NUMERIC value to a INT field when operating on tables with more than 2^31 rows. This could also be seen when creating proxy tables. |
| 538487 | When the Job Scheduler component is not selected during installation, using srvbuildres can still configure it. |
| 538488 | DDLGen generates 'NULL' SQL statement for granting the permission of the DELETE STATISTICS command. |
| 538527 | select show_plan() can get error msg and SIG 4 sometimes. |
| 538584 | Clearing sql replication settings via sp_setrepdefmode, may remove the threshold configured at object level. Simmilary, when clearing the object's threshold, the sql replication settings may be lost. |
| 538649 | A 5846 error, "Illegal value '128' specified for configuration option.." displayed while trying to configure 'global cache partition' to 128. |
| 538693 | signal 11 (sigsegv) might happen in ResRelOp() for a nested outerjoin query with more than 2 table join inner to the outerjoin. |
| 538727 | Provide users an option to disable "Remember Password" feature in Sybase Central ASE Plugin during installation for ASE. |
| 538777 | HA failover or failback can fail when the connection that is running the HA takeover on the companion and a connection that is failing over have the same user login and the connection that is failing over gets locks on syslogins catalog before the HA takeover process does. The failover or failback does not complete and HA state on the companion remains unchanged. |
| 538910 | In rare circumstances, a stack trace may be reported in the errorlog involving the modules 'GtuUnion::_GtcNTopPopsGenerate' and 'GtcChildOptBlockN::_GtcBestArgsGenerate' during a query that involves both more than 4 UNION sides, parallelism and one UNION side with a distinct projection and greater than 6 tables. |
| 539103 | Monitor Server crashes in comn__sig_accept_thread upon receiving SIGHUP. |
| 539162 | The message "no message text" may be reported when a DBCC CHECKTABLE command has been previously run against an ASE configured to use a non-English language. |
| 539355 | Job Scheduler fails to start on Windows with IPv6 enabled. |
| 539440 | When statistics are not available for queries that consider "distinct" operators, either an implicit distinct (such as an EXISTS subquery) or explicit "distinct", then the magic number used for the duplicate count is 10% for each column in the projection list. If there is one column in the distinct operation, then 10%=1/10 translates to 10 distinct values, or 10 rows. Creating statistics on the distinct column(s) will correct the problem. The default behaviour has been changed to assume a unique column, i.e. no reduction in rows after a distinct operation, when statistics are not available. This can be reverted to the old behavior of 10% by using the new optcriteria no_stats_distinctness either at a session or query level. The new behavior will tend to discourage eagerly placed sort nodes in query plan when statistics are not available, whose purpose is to reduce row count. |
| 539513 | SybCent 15.0.2 - permissions tab error "For input string "" on Unix platforms |
| 539757 | sp_displayaudit doesn't report auditing configuration on extended stored procedures |
| 539780 | Executing groupby queries with groupby columns reference java ADT may hit stack trace from LeHashEntry::Compare() in the module of LeHashContext::ProcessTuple() if the query plan chosen uses HashVectAggOp. |
| 539782 | For cursor query referencing java ADT, spinlock and guardword corruption may happen if the cursor is not closed before exiting the session. |
| 539821 | Wrong result could happen for MERGE or HASH join when there is an equijoin predicate t1.c1 = < expression on t2.c2 > and another redundant or equivalent equijoin predicate t2.c2 = < expression on t1.c1 > is added which is simply a transformation from the first one. For example, t1.c1 = t2.c2-1 and t2.c2 = t1.c1+1 |
| 539853 | Application Tracing doesnt work with "set statistics" options in login triggers. |
| 539897 | When the host component of a sp_listener command is an ipv6 address, it should be encloded in brackets. For example "tcp:[2001:ec8:4008:1::123]:80" |
| 539924 | ASE 15.0.2/AIX does print stacktrace with fdpr (Feedback Directed Program Restructuring)on FBO binary instead of trying to map that to the correct function. |
| 540008 | There is no uninstall binary on HP-UX Itanium (B.11.31) after install ASE. |
| 540060 | Sybase Central stack traces when trying to view roles: Current thread: AWT-EventQueue-0 java.lang.NullPointerException at com.sybase.aseplugin.bo.ASEBasePage2.getJDialog(ASEBasePage2.java:73) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage.initTableComboBox(RoleProperties.java:2432) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage.initComboBox(RoleProperties.java:2403) at com.sybase.aseplugin.bo.prop.RoleProperties$RoleColumnPermissionPage. < init > (RoleProperties.java:2336) |
| 540144 | A session executing a query may hang in modules 'des_get' and 'open__lwpbyname' while the statement cache is active. |
| 540214 | In some rare situation, printing SQL text could cause stacktrace. |
| 540230 | May hit 11501 error while drop a function based index on partition table |
| 540770 | In rare circumstances, the message "Infect with 11" in modules 'memcpy' and 'com__dateadd_both' may appear in the errorlog during a query involving more than 6 tables, Nested Loop Joins and SARGs with convert(), dateadd(), getdate() and datepart(). |
| 540794 | If statement cache is turned on and 'enable metrics capture' is also set, executing a query referencing temp tables will hit SIGSEV in the module 'memalloc' along with stack trace in the module 'metrics_dump' and 'ssql_purge_stmt_hastemp'. |
| 541218 | The rollback of a bulk insert operation on a table with TEXT columns may encounter a 3478 error. This situation may happen for UNITEXT, or TEXT columns in a multi-byte character set server. |
| 541567 | Previously when DBISQL tried to connect to an ASE running on HP-IA, the connection would fail with a mustached character set. User had to manually select "iso_1" to connect to the server properly. This has been fixed so that no user-interaction is required in such situation. The Connect Dialog would internally switch to the proper character set. |
| 542013 | After running sp_companion 'prepare_failback', an error 940("Dbtable in wrong state for operation") is reported while committing a transaction. |
| 542079 | In Adaptive Server 15.0.2 ESD#6 and later, when a database, originally created with log and data mixed, is extended on to another device using the ALTER DATABASE command without using the LOG ON clause, the newly added disk piece gets marked as "data only" instead of "data and log". That is, no log space is added by the command. Due to this, the database may run out of log space sooner than expected. |
| 542096 | For UNION ALL query under allrows_dss optgoal (or "advanced_aggregation" is on), signal 11 stacktrace might happen in CgpUnion::_cgpInit() during compilation. The stacktrace is more likely to happen if "append_union_all" is also turned off. |
| 542143 | When an instead-of trigger is defined on a VIEW that involves LOB columns and proxy tables, then executing a statement on the VIEW that fires the instead-of trigger may fail with message 3621, "Command has been aborted." |
| 542209 | Support reuse of cached statements that reference TEMP tables across sessions under trace flag 299. |
| 542234 | Firing an instead-of trigger on a view with big LOB colums may hit SEGV in memtextlen() along with the stack trace in the module of '_LeEoSendColumnToClient' |
| 542352 | For select query in browse mode and the query does not involve any tables, it could cause: CT-LIBRARY error: ct_results(): protocol specific layer: external error: There is a tds protocol error. Premature end of the datastream was encountered. e.g. select 'Mary' for browse |
| 542539 | Improvements include: * Release of the basic QPTune functionality * Add missing stats support * Save queries to user specified groups before any tuning exercise * Change setting default optgoal during fix to avoid any conflict * Other bug fixes and cosmetic changes to improve the existing utility overall |
| 542721 | Executing a query with parallel reformatting plan may hit error 8211 in the module of 'des__hashinst' together with stack trace in the module of 'lwp_create'. |
| 543088 | sp_showplan may not provide correctly the query plan for a stored procedure with statements compiled in the deferred mode. |
| 543422 | Installer failed to create UAF Windows service in upgrade install. |
| 543639 | Using "bcp in" to a table whose specified name (database + owner + table name) exceeds 255 bytes will fail with no error message from ASE. |
| 543800 | A search with a equality clause comparing an INT column with a literal numeric that exceeds MAXINT incorrectly returns rows. |
| 543930 | ASE failed to disable mirror device if error occurred while opening the mirror device. |
| 544112 | Queries that use a partition table (call it PT) and contain a SARG against PT on a non-partitioning column may return too few rows. The query must also contain a SARG against PT's partitioning columns such that some partitions can be eliminated during optimization. Take the following query as an example: select * from S inner join PT on S.c1 = PT.npc and PT.pc > = 1 The predicate "PT.pc > = 1" can be used to eliminate some partitions during code generation (pc is PT's partitioning column). The equijoin "S.c1 = PT.npc" is a SARG against one of PT's non-partitioning columns. In this case, once S.c1 has a value of NULL, no more rows will be returned from this equijoin even after S.c1 is refreshed to non-NULL value. Note that this problem could also occur across stored procedure or cached statement invocations. |
| 544247 | Many "Error formatting options file entry..." errors occurred during generate silent install record file, and when execute silent install, also has errors. |
| 544256 | On some platforms a stack trace in n3__make_jsig() may result when a sqlj procedure is created with more than the allowable number of parameters and there is a matching java function installed on the server. |
| 544679 | Executing UPDATE queries involving NULL LOBs may hit error 691, "Encountered invalid logical page 0 ..." with a stack trace in the modules 'updtext()' and 'wrongpage()'. |
| 544704 | The query below may return 0 row if FKcol1 and FKcol2 columns on table B are character variable-width, nullable datatypes and col1 and col2 columns on table A are character fixed-width, non-nullable datatypes. select B.FKcol1 + ',' + B.FKcol2 from A, B where B.FKcol1 + ',' + B.FKcol2 = 'TEST5,T' and A.col1 = B.FKcol1 and A.col2 = B.FKcol2 |
| 545058 | ASE running on Sun Solaris machines which do not have ISM configured within the kernel will cause additional engines to SEGV during their online operation. |
| 545119 | This fixes an issue where server is reporting an error (named cache is configured too small for current demands state 3. Transaction progress may cease) too early. |
| 545130 | If both expr1 and expr2 are float numbers in 'select isnull(expr1, expr2)'and if precision of expr1 is less than precision of expr2, it returns error msg 247. |
| 545296 | QPMetrics are not captured for statements inside a store procedure which is created and compiled before QPMetrics is enabled |
| 545413 | DUMP DATABASE/TRAN with compression may fail with an error, "Length of compressed buffer is greater than the original buffer length". |
| 545444 | Under rare circumstances an ASE system running on a 64 bits Windows Server with a high rate of DML commands executed may result in some data not be written to disk. |
| 545662 | Under rare conditions a query on the monOpenObjectActivity MDA table may result in a signal 11 and server crash. |
| 545665 | If a server was configured for an ipv6 address 'connect to' would fail. A new syntax is being used to add an ipv6 address in sp_addserver. The syntax will encapsulate the ipv6 address with in brackets '[,]'. An example of an sp_addserver command for an ipv6 address: sp_addserver 'rmtsrv1',ASEnterprise,'[fd77:55d:59d9:167:203:baff:fecd:2b0d]:6268' |
| 545754 | Application Tracing does not trace actual and estimated I/O statistics when "allow resource limits" configuration parameter is enabled. |
| 545900 | Replication Agent may report the error 9205, state 0, after a cross database transaction happened between two databases and the table or the database is configured to use sql statement replication. |
| 545960 | isnull() builtin on character data could return blank padded data while returning values substituted for nulls |
| 546047 | Executing a query involving IN clause, some builtin and OR predicate may hit SEGV and stack trace in the module of 'LeEvals::LeEvRun()' and 'LeOrScanContext::setOrVtuple' if the query plan chosen has OrScan in it. |
| 546075 | The message "process infected with signal 11" in the module 'des_rekeep' may be reported in the error log together with a stack trace which includes the modules 'vu_getviewdefn', 's_reinstallProcTree' and 'proc__linktopss' when two concurrent sessions access a VIEW whose query tree needs be redefined by ASE. |
| 546651 | SET PROXY executed in the procedure using deferred compilation will not have its scope limited only to the current procedure execution but for the whole session. |
| 547622 | Adhoc batch may be silently aborted if it creates a temporary table and a clustered index on this table. |
| 547741 | Under some circumstances a stored procedure execution which aborts with certain errors (like, for example, a 226 error "... command not allowed within multi-statement transaction.") could unexpectedly close the tables used by the session who previously executed the same stored procedure. |
| 547925 | If the ASE license has expired, silent install throws java.lang.IllegalStateException. |
| 549168 | When set locale to Chinese, the Chinese characters in sysam checkout messages shows as boxes or garbage. |
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.0.3
- 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
Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0
Keywords
Fix, Patch, 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)