Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar

Search for    in all of
view all search results right arrow

Support > Technical Documents > Document Types > Technote > Targeted CR list for ASE 12.5.2 ESD #2.

This document lists Change Requests (CR) for Adaptive Server Enterprise 12.5.2 ESD #2.
RSS Feed

Targeted CR list for ASE 12.5.2 ESD #2

Bug ID Description
95163 A column created with the system datatype 'sysname', defined as a varchar(30) NULL, will get a length of 1 char instead of 30.
335542 CIS: An outer join query declared inside a cursor can't be passed to the remote server completely even if all tables involved are on the same remote server. Cursors involving remote tables are READONLY by default. They can be made UPDATE-ABLE by default upon enabling traceflag 11218.
342856 Under very rare circumstances, DBCC CHECKSTORAGE may incorrectly report a large number of 100018 soft faults.
345943 After unmirroring the master device keeping the secondary side, dumps of the master database fail with an attempt to access the original master device.
346426 The $SYBASE/$SYBASE_ASE/scripts/installjconnect script has "^M" characters at the end of every lines.
347380 Msg. 103, "The identifier that starts with '<textpointer>' is too long. Maximum length is 30." is raised when executing the command WRITETEXT BULK <tablename>.<colname> <textpointer> and colname is called "parameter".
347753 Enhanced diagnostics for access violation errors.
348384 The error 1505, "Create unique index aborted on duplicate key. Primary key is '<value>'" may report an incorrect key value if the index is created in parallel mode as opposed to serial.
349251 When a single long transaction is aborted in a primary database because it has filled up the log, replication agent is not able to move the secondary truncation point, even if all transactions have been processed by replication agent.
349790 CIS : Execution of multiple Extended Stored Procedures might result in performance improvement due to an efficient connection establishment model when routed through CIS RPC mechanism after both 'cis rpc handling' and 'negotiated logins' options are turned on.
351008 Replication Agent may report the error 691, including page '0', when trying to process an update where the before image has not been marked for replication.
352027 A 7951 error may be reported by DBCC CHECKTABLE after a valid XML document that is encoded in a multi-byte character set, has been BCP'd into this table.
352044 If character set conversion is already active, executing the statement "set char_convert on" will cause incorrect information to be reported via the global variables @@char_convert and @@client_csid, and it may ultimately lead to the process being terminated with a a stack trace.
352103 CIS: SELECT..INTO from proxy table command against DB2 backend is slow when the WHERE clause is not forwarded to the remote server.
352153 A 257 error, "Implicit conversion from datatype <datatype1> to <datatype2> is not allowed" may be raised when inserting a NULL value using a parameterized statement and the datatype of the parameter does not match with the datatype of the column.
352568 In rare circumstances, ASE may hang forever if the IO subsystem is overloaded and a process goes to sleep while holding the default data cache spinlock. The call stack of this process will show the modules 'dstartio', 'kd_p_semaphore' and 'upsleepgeneric'.
353460 sp_monitor stored procedure executed with the 'connection' parameter gives incorrect time values for sleeping processes.
353718 A 2628 or 2630 error together with message "Mass <addr> found in the buffer wash with incorrect state dirty but not writing" may sometimes be encountered while doing a lot of UPDATEs or DELETEs on a Data Only Locked table.
353866 A user trying to log into the server may be blocked forever if the master database is quiesced.
354208 Cannot Delete an Extended Stored Procedure in the 12.5.2 version of the ASE Plug-in.
354281 The message "current process infected with 11" in the module 'memshrink' together with a stack trace which includes the modules 'cri_physbuild' and 'cri_bldindex' may be reported in the error log when a DUMP DATABASE statement is run at the same time as a CREATE INDEX, SELECT INTO or BCP. The diagserver will return error message 3205 in this case.
354511 Msg. 156, "Incorrect syntax near ELSE" is raised when executing an IF ELSE construction whereby the SQL statement in the IF block is cached using the Statement Cache feature.
354578 CIS: sp_passthru is not returning the correct @rowcount value when no rows are fetched or affected by the pass-through query.
354585 A batch executing the sequence of statements: CREATE CLUSTERED INDEX on a table and then UPDATE table may fail with error 629, "Clustered index row entry for data page # is missing in index page # of table `tabname` in database 'dbname'; index row contains data page # instead. You can recreate the clustered index to fix this error Xactid is (xactid)."
354650 Noticeable performance degradation is observed in query performance when migrating to ASE and later versions on IBM 64bit platform built on AIX 5.1 OS (ASE version string reported by 'dataserver -v' has "AIX 5.1" rather than "AIX 4.3.3").
354727 When the Statement Cache is enabled and a normalization error occurs, the keepcounts of other statements in the batch may not be decremented resulting in incorrect keepcounts. This prevents these statements from ever being purged using DBCC PURGESQLCACHE.
354768 Allocate memory for EJB connection sockets only under traceflag -T 1642. This new default behavior change eliminates unused memory reserved for EJB server when EJB server is not configured so that more user connections can be configured for the ASE server.
354772 When the 'number of user connections' is configured to a large value (around 30000), ASE may fail to start due to a timeslice error in module 'dbt__getfree' after the message 'Opening Master Database ... ' has been reported in the error log.
354798 Traceflag 7842 can be used to log a diagnostic message when a client cancels an operation. Traceflag 7843 can be used to reverse the changes from bugfix 269372 for situations where an existing application relies on the previous (incorrect) behaviour of ASE attention handling.
354936 In rare circumstances, ASE may report a timeslice error in the module 'lm_internal_ctxchain_release' if a session has acquired a very large number of locks. If the lock manager spinlock is held at this point, the server will crash.
354984 A 694 error, " An attempt was made to read logical page '<pageno>', virtpage '<pageno>' from virtual device '<devno>' for object '<objid>' in database '<dbid>'. The page was not read successfully. You may have a device problem or an operating system problem." may be reported under rare circumstances when CREATE INDEX and DUMP DATABASE are running concurrently and the server has large pools configured.
355108 When two instances of the same shared memory dump condition occur at almost the same time, it is possible for the number of shared memory dumps created to exceed the configured maxdumps value for that dump condition.
355551 When an ASE (12.5.1 and beyond) listener encounters some recoverable network errors, like client aborting a connection, when ASE is in the process of accepting the client connection, ASE may consider the error to be unrecoverable and terminate that listener. If there is only one listener, no new connections can then be established. However if a system administrator isql session is available, then listener can be restarted. This condition may be triggered by some activities like a long duration shared memory dump.
356005 A 2780 error, "maxlen (1) is less than length (2)" may be raised and reported to the errorlog together with a stack trace which includes the modules 'sybase_asejdbc_Param_nt_1setBigDecimal' and 'j2c_setVal' when executing a java method that uses ASE internal JDBC driver and tries to convert from BigDecimal java datatype to NUMERIC SQL datatype.
356027 A 8201 error, "Keep count of descriptor ... expected to be 1. Instead 0 was found." may be reported in the error log followed by a stack trace including the modules 'proc_get' and 'des_rekeep' during the execution of a stored procedure whose previous execution had failed with the message 'current process infected with 11' in the module 'proc__setdb_plan'.
356785 ASE ESD#4 running on HP-64 platform after a few days suddenly becomes very slow, triggered by high network activity. Incoming network I/O is very high, ASE engines use 80% to 100% of CPU at Operating System level, but do not perform any useful work. New incoming connections are most of the time refused, effectively ASE seems to be hung.
357181 The amount of memory needed by Adaptive Server may be overestimated. This could happen when a large number of "open objects", "open databases" or user-defined caches are configured so that following an upgrade, Adaptive Server may be unable to boot. The following message, "The value of the 'max memory' parameter (<value>) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file...", is reported in the error log.
357477 A 871 error, "Process <spid> is trying to release a latch on buffer <value> (dbid: <value>, pageno: <value>) without holding a latch on the buffer." may be raised in module 'getnext' or 'dol__get_lock' when the given process selects rows from a Data Only Locked table while DML commands are taking place concurrently by other processes.
357658 In an HA environment that is configured "with proxy_db", the error "Infected with 11" followed by a stack trace that includes the module 'palt__gen_addcol_clause' will be printed in the error log and the process will be killed when a table is altered to add a new non-null column without providing a default. A 4997 error, "ALTER TABLE '<tabname>' failed. Default clause is required in order to add non-NULL column '<colname>'", should be printed instead.
357688 A 530 error, "Attempt to insert NULL value into column ... in work table (table id ...) column does not allow NULLS. UPDATE fails." may be raised when a java class running inside the ASE's JVM is connecting to the server using the internal JDBC driver and then executes a query on a table that has wide columns and a worktable is necessary to resolve that query.
357839 The command DUMP TRAN <dbname> TO <devname> WITH STANDBY_ACCESS may take too much time to stop when interrupted with Ctrl C or killed from another session.
358007 Stored procedure executing INSERT into a table with some VARCHAR columns may incorrectly leave trailing spaces in the VARCHAR column if the source of the data is a table with CHAR column.
358092 When forcing an index, the optimiser considers only the 1st SARG.
358269 A SELECT UNION query using a view which is materialized whereby columns of the view are used in an outerjoin-clause can return incorrect results.
358397 Transient 806, 691, 605 errors may be seen in very rare circumstances when multiple sessions are scanning the same page of an index in an Allpage Locked table.
358418 Monitor tool to display in English only.
358450 If a new data cache is created using sp_cacheconfig, the "APF Percent" for the default memory pool may be incorrectly set to zero when Adaptive Server is next rebooted. This can cause performance degradation when accessing any objects that are bound to this data cache.
358758 When a transaction is being implicitly rolled back by ASE, then the command "KILL <spid> WITH STATUSONLY" will mistakenly report the message "Status report cannot be obtained. ROLLBACK for spid:<spid> is not in progress.".
358800 On AIX platforms, there may be a problem with populating the aio_return field of an aio control block in a timely fashion within the ASE.
358868 Character set conversions are rejected for older (DBlib) clients when the server's default character set is SJIS and the client's character set is EUCJIS.
358954 When CREATE TABLE and INSERT are in the same store procedure, and the table is a non-temporary table with IDENTITY column, the IDENTITY column data will be incorrect.
359128 A 10479 error, "Conversion error detected while converting Java data to SQL data. Either the conversion is not supported or the datatype(s)is invalid." may be raised when using CONVERT() function to convert certain JAVA datatype values to NUMERIC SQL datatype values.
359172 If Job Scheduler Task fails to initialize, infected with 10 in kbfalloc() is caused by running sp_sysmon with "cache wizard".
360063 Under large number of user connections, if connections are killed repeatedly, then subsequent logins may take a long time to get through resulting in slower response time.
360414 Under rare circumstances a session may hit a segmentation violation with message "current process (<value>) infected with 11" in module 'bufdlink' followed by a stack trace in the error log. This results in an implicit shutdown of ASE.
360599 The current limit of 1024 AND/OR conditions in a WHERE clause has been raised to 2000. In order to take advantage of this new limit, it is necessary to adjust the default stack size upward, to approximately 300K. No change to the stack size is required unless the application desires to take advantage of this new limit. In addition to stack space, this new limit may result in a need to allocate more procedure cache space to the server. The dataserver must be started with traceflag 404 ( -T404 ) to allow this new limit to take effect. Otherwise, the current limit of 1024 will remain.
361498 SSL Clients specifying "Diffie-Hellman" key exchange algorithm in the ciphersuites fail in the SSLHandshake. Some clients, such as ODBC TDS based driver, offer ciphersuites which will cause the handshake failures. The certificates don't seem to matter in this problem. isql and OCS clients are fine as long as they specify the default ciphersuites but if the defaults are overridden and "Diffie-Hellman" is offered, the ASE fails in the handshake with them.
361694 A 691 error: "Encountered invalid logical page '<pageno>' while accessing object '<objid>' in database '<dbid>'." may sometimes be encountered when inserting data into an Allpages Locked table with large length columns and having a clustered index.
362041 Replication Agent may not send to Replication Server an INSERT or DELETE operation performed on a table with text/image column, if a partial rollback occurred during processing.
362369 On Tru64 Unix platform, ASE may generate stack traces with the wrong symbol names due to the missing file.
364293 Update language module version, so that locales files will overlay earlier versions of the files.


Last Revised: Feb 23, 2005
Product: Adaptive Server Enterprise
Technical Topics: Error Message, Database Admin, Bug Information, Troubleshooting
Business or Technical: Technical
Content Id: 1030336
Infotype: Technote

© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics