/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 |
|---|---|
| 538069 | Connecting to a server that is down or non-existent server could cause memory leaks that eventually could lead to 7220 and 7235 errors. |
| 545741 | Fixed by 547741 which was checked into 15.0.3 IR. |
| 552606 | sp_options may not show no_stats_distinctness option. This is correct in ASE 15.0.3 IR onwards (CR 539440), this CR was to correct a problem with the backport of 539440 in a 15.0.2 1-off. |
| 555255 | When a query contains a negative integer specified such as -(90), and when literal parameterization is on, parser or normalization syntax error might be raised when the query is cached and has to be recompiled during subsequent executions. |
| 577488 | Provide traceflag 1144 to avoid 1127 errors reporting insufficient space in the OAM page when running heavily concurrent multi-user applications simultaneously inserting into the same table. |
| 581138 | Select monCachedObject cause SEGV in mda__set_ptninfo() with spinlock held. This was addressed via CR 539065. |
| 592395 | Signal 11 in function ResRelOp()and spid termination with ResRelOpProcess(), CgpPop::_CgpPePredBmToScalar visible in the stack trace in the error log. Query involving outer join onto a virtual expression from a sub-query containing the column involved in the virtual expression in a further outer-join clause. A virtual expression is generally the result of a built-in function (isnull etc) |
| 616869 | When a proxy table is accessed through a query limited by either SET ROWCOUNT or the query is aborted through CNTL-C, then a subsequent query to the proxy table will raise a 11206 error, "Unable to connect to server < servername > . Command has been aborted." |
| 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 and the JVM aborting. Alternatively this may cause ASE shutting down itself. |
| 632207 | In some circumstances, query on MDA table monCachedObject may affect ASE system performance. |
| 632482 | ASE reports "Protocol < XXXXX > not supported within soc_nopen()" error in errorlog. This may be followed by SIGSEGV, SIGBUS or timeslice error and lead to ASE hang. |
| 635315 | Under some circumstances when the execution of a stored procedure is aborted due to a 1205 error, "Your server command (family id ..., process id ...) encountered a deadlock situation. Please re-run your command." and the procedure was executed by another stored procedure that had a cursor opened inside a user transaction and the option SET CLOSE ON END TRAN was ON then the next execution of the same stored procedure that reuses the plan which was aborted could behave ignoring the WHERE clause for the statement that was aborted by the 1205 error. |
| 637993 | In some ASE workloads, proc_spin shows up as having high contention. This fix could decrease the contention in some of these workloads. |
| 638786 | Parallel activity on tables related with RI constraints may lead to deadlocks |
| 641109 | The message "current process infected with 11" in the module 'getvalue' together with a stack trace which includes the modules 's_retparams' and 'execproc' may be reported in the error log when an INSERT statement is run on a table having an encrypted CHAR/VARCHAR column, the configuration parameter "statement cache" is active and the INSERT statement was previously cached but it had to be recompiled or renormalized because, for example, all the query plans were in use or the schema for the underlying table changed. |
| 642776 | SELECT INTO proxy table may fail silently when inserting NULL into the proxy column. |
| 644104 | Under some rare conditions, stacktrace involving the modules 'LePlanRelease', 'LePlanWriteStats' an d 'LeAlfaStatsCollector' may be reported during query plan generation. |
| 644156 | Under some circumstances the message "WARNING: memory usage in procedure headers (x) does not match memory usage count in Pss (x) for server process id x" may be reported in the errorlog when a session is holding a high number of user temporary tables without dropping them and, for example, runs some stored procedures via Remote Procedure Call. Eventually, after multiple of those messages, a 701 error "There is not enough procedure cache to run this procedure, trigger, or SQL batch." maybe reported indicating that the free memory available in the Procedure Cache is low. |
| 644994 | Under some conditions, for example reset or reconfigure 'parallel degree', statement cache clean up issues and memory leaks may occur and it could also make the purge statement cache entry impossible due to ssql_keep > 0. |
| 645146 | Under some conditions, creating trigger involving union could lead to SEGV in p__check_lob_insdel() function. |
| 645343 | Stack trace in LeDataRow::readRow when fetching insensitive cursor on a union. |
| 646353 | sig-11 raised when upgrade step 245 is involved during upgrade to ase 15.5 smp. |
| 646388 | When tables with large number of partitions (typically greater than 32) are used in a query that has a UNION or a UNION ALL query with ASE configured for parallelism, ASE may stack trace. |
| 646397 | Executing an insert-select from proxy table into local table when a LOB column is present is much slower than in ASE 12.5. |
| 647485 | Executing a SELECT INTO EXISTING command on a proxy table with identity_insert option turned on does not insert the data. |
| 647654 | In rare circumstances an ASE task that is in the process of creating a temporary table in a user defined temporary database may sleep for ever while ASE generates the object ID value for this table. The call stack for the sleeping task will report the modules 'crt_main' and 'objd_id'. |
| 648664 | Under some rare conditions, the statement cache entry could have ssql_keep > 0 and this entry could not be removed by the DBCC PURGESQLCACHE command and this could cause problem for the statement cache. |
| 649428 | Adaptive Server may encounter a storage access violation error when query execution is interrupted. |
| 650660 | Queries with outer joins on encrypted columns may not return all the rows from the outer table if the encrypted column uses the decrypt_default modifier. |
| 652634 | When selecting from a VIEW that selects DISTINCT rows from a base table with at least one encrypted column that specifies a decrypt default value, Adaptive Server gets a SEGV violation and aborts the user session. |
| 652646 | A SELECT statement with a qualification that searches an encrypted column that has a decrypt_default modifier and another column using the LIKE operator may ignore the LIKE filter and produce wrong results. |
| 653212 | The message "Error: 820, Severity: 21, State: 6" may be reported in the error log together with a stack trace including the modules 'bufpindirty' and 'pg_allocate'. Alternatively, the "infected with 11" message may be seen in the error log together with a stack trace showing the modules 'xls_bufunpin' and 'buf_get_latch'. |
| 654011 | The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.". |
| 654339 | A 539 error "Unexpected internal access methods error < value > , state < value > etc." may be reported when an UPDATE with OR clauses is executed on a Data Only Locked table while concurrent DML activity takes place on it. The execution plan would report "Using Dynamic Index" and "Positioning by Row IDentifier (RID)". Alternatively the message "The current row ID ' < value > ' does not match the new row ID ' < value > ' for update, etc." may be reported in the error log. |
| 654532 | A 15412 error may be raised when during a decryption operation if there are a lot of concurrent user sessions using encrypted columns features in Adaptive Server. |
| 655613 | A DB2 error indicating an invalid value may be returned when a query referencing a remote DB2 table contains a DATE search value. |
| 656075 | In environments with a high number of concurrent users and using the statement cache intensively, the monitor counters for spinlocks may indicate that the DES manager spinlock was excessively used. |
| 656566 | On AIX platforms, a client session running a batch job may be terminated with error "ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect] SQLCODE[-84083974]" and the ASE errorlog is logged with message"kernel nrpacket: recv, Resource temporarily unavailable, spid: < spid > , suid: < suid > ". |
| 656606 | The message "current process infected with 11" in the module 's_retparams' together with a stack trace which includes the modules 's_setreturns' and 'execproc' may be reported in the error log when a SELECT statement is run on a table having an encrypted column and the configuration parameter "statement cache size" is greater than 0. |
| 657963 | Error message 233 appears when a ISNULL clause is present in a SELECT INTO EXISTING query where the target table is a proxy table. |
| 658276 | A "9219, severity 20, state 83" error may occur when a stored procedure with enough wide parameters that the number of bytes necessary to log an invocation would require more than a single log page. The error will only occur if the stored procedure has been previously invoked with null values in the wide parameter(s) and is subsequently invoked with non-null values in those same parameter(s). |
| 659042 | When the master database is marked for replication the execution of sp_addlogin does not replicate the login with the correct password expiration interval. |
| 662923 | sp_monitorconfig 'procedure cache size' can become inaccurate. Fixed via CR 644156. |
| 665043 | The following is observed when 'restricted decrypt permission' is configured: (1) a table owner who has decrypt permission on an encrypted column through group membership is not permitted to select decrypted data from the column. (2) sso_role who should have implicit decrypt permission is not permitted to select decrypted data from the column and is not permitted to insert into the column when trigger present on the table (3) a table owner who has been granted decrypt permission through a user defined role is not permitted to insert data into the column when trigger present on the table |
| 665257 | Under certain circumstances, server may fail to boot under UTF-8 nocase sort order, 8211 error may be seen. |
| 665715 | The message "current process infected with 11" in the module 'bufdlink' together with a stack trace which includes the modules 'pg_allocate' and 'bufpindirty' may be reported in the error log when a table was in the process of being created and ASE has previously hit a 1204 error "ASE has run out of LOCKS. Re-run your command when there are fewer active users, etc.". |
| 666728 | Update the Open Server Components of ASE to provide essential Open Server vulnerability fixes. |
| 669847 | A 290024 error, "Invalid column length: < number > Value must be between < number > and < number > at offset < number > ..." may be reported during a UPDATE plan execution when a complex VIEW or derived table (such as UNION or GROUPBY) is used in the FROM clause of the UPDATE statement. |
| 670506 | A server configured with certain specific character sets and case insensitive sort orders can report error 15417 when querying tables that contain encrypted columns. |
| 670907 | ASE may crash unrecoverably with signal 11 in ct_poll when a connection to a remote server running an SQL query is killed. |
| 671440 | Under some rare circumstances, ONLINE DATABASE or LOAD TRAN command may fail with a stack trace showing module xls_pre_alloc_numclrs and plc__flush. This may happen after loading a transaction dump including log records written by a CREATE INDEX command run for a DOL table. |
| 671536 | In certain circumstances, a query that contains an OR clause with multiple joins may generate a sub-optimal plan, with respect to result accurracy, when executed with the optimizer level of ?ase_default?. |
| 671592 | Lots of concurrent logins may result in error 290024 and stacktraces during ASE authentication. |
| 672829 | There can be high spinlock contention on the ASE network memory pool spinlock. |
| 674627 | When a table is being replicated to a table that includes an additional IDENTITY, an error "AOP not found in getAopt" is raised. |
| 674877 | Performance issue on SELECT INTO from encrypted tables for non-privileged user. |
| 675990 | After cross-platform dump and load of a database containing a view defined on a base table with an encrypted column and a decrypt default, the decrypt default information may be lost leading to a 3762 error: "The decrypt_default for column id 27 was not found in the system catalogs." |
| 676991 | High cpu usage seen with rprocmgr_spin contention |
| 678432 | If a target list for a view maps to more than one encrypted column in the base table with the decrypt_default attribute, Adaptive Server may fail to check the user's decrypt permission and incorrectly return the decrypt_default value instead of the actual column value. |
| 678639 | Closing a connection in ASE may cause high cpu usage. |
| 679267 | In rare circumstances, the error 8203 followed by a stack trace that includes the module des_create_inxact() could be raised when rolling back a transaction. |
| 679807 | For a SELECT statement in a stored procedure, if the table has more then one partition keys and not all the partition keys in the predicates are constants, neither compiler time partition elimination nor dynamic partition elimination occurs. |
| 680759 | In rare circumstances, terminating an idle CIS connection may result in some form of memory corruption in the next connection attempt. |
| 683028 | Dynamic Partition Elimination is not used for a store procedure with EXEC IMMEDIATE. |
| 683626 | Abstract plan error message could be reported when using "set forceplan on" for outer join query with subquery. |
| 684110 | Under rare circumstances, a 8601 error, "Process < pid1 > tried to keep the PSS for process < pid2 > when it already had the PSS for process < pid3 > kept", may be reported when executing utility functions, such as sp_showplan, which query another active spid. |
| 685996 | Abstract plan error could happen failing to apply a right nested outerjoin abstract plan. It is more likely to happen when there is a subquery at the inner side too. Same issue could also cause optimizer to ignore certain legit merge/hash outerjoin bushy plan too under allrows_dss optimization goal. |
| 688338 | Query involving column relop NULL clause may result in a 403 error message if the column projects NULL and the relop is =, > =, > , < = or < . |
| 690064 | A 11051 error, "ALTER TABLE ' < table_name > ' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.". |
| 690730 | High rprocmgr spinlock contention may be observed under heavy workload of dynamic SQL and stored procedures. |
| 691248 | When tempdb_space resource limit is reached, any subsequent work table creation operation fails and does not release the buffers and the allocated tempdb pages during the execution. |
| 692550 | A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support.", may be reported under some circumstances when a stored procedure containing a SELECT INTO ... UNION statement is executed and references session temporary tables and/or stored procedure parameters. |
| 694123 | The 10330 error message is issued on a select from a join with a normal table and a view after dump/load database. The view and the normal table both have encrypted columns that have decrypt_default. The server has restricted decrypt permission set. |
| 694488 | In rare circumstances the message "Infected with 11" together with modules like s_cleanframe, s_senddone followed by spid termination may occur when set statistics time is enabled with a create proc referencing a non-existent temporary table and a particular Sybase supplied traceflag is enabled. |
| 696470 | In rare circumstances the message "Infected with 11" together with modules like senderror(),send_msg(), tdsrecv_errorhdl() followed by spid termination may occur when set statistics time is enabled with a create proc failed with syntax error. |
| 697522 | In rare circumstances the message "Infected with 11" together with modules like ex_printmsg(), senderror() followed by spid termination may occur when SET STATISTICS TIME is enabled with a create proc referencing an existent temporary table and a particular Sybase supplied traceflag is enabled. |
| 697828 | High rprocmgr or rpmctrl spinlock contention may be observed under heavy workload of dynamic SQL or stored procedures. |
| 698059 | Multiple failed connection attempts may result in memory related stacktraces in Ct-library and hang up the server completely. This is resolved by OCS CR 585954 (fixed in OCS 15.5 GA onwards). |
| 702653 | When a primary key contains IDENTITY columns, INSERT INTO and SELECT statements may create bad LTL causing the RepServer to report the error message, "Incorrect syntax near the keyword FROM". This is fixed via CR 674627. |
| 712855 | Invoking the soundex() or difference() built-ins on unichar/univarchar strings larger than 127 characters (254 bytes) may cause the process to be terminated. |
| 713677 | Include OCS CR 672301 to fix an AIX specific memory leak. |
| 718191 | Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table. |
| 719019 | An argument to error message 301 is too long. The argument needs to be truncated. |
| 721144 | If Java in the database is being used, then if the "same" shared configuration file is used by more than one instance or Server, then there is a race condition during JVM initialization where it is possible that the message ?current process infected with signal 11? in the function ?jvminit? may be reported in the error log, followed by the message ?Failed to initialize Java services". This may result in ASE shutting itself down. |
| 723777 | During installation, ASE Default Master/Tempdb Device Size is 0 on very large disk |
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.0.3 ESD#4.2, ASE 15.0.3, ESD#4.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)