SAP Adaptive Server Enterprise的所有已知BUG列表(6)

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

Adaptive Server Enterprise的所有已知BUG列表(1)
Adaptive Server Enterprise的所有已知BUG列表(2)
Adaptive Server Enterprise的所有已知BUG列表(3)
Adaptive Server Enterprise的所有已知BUG列表(4)
Adaptive Server Enterprise的所有已知BUG列表(5)
Adaptive Server Enterprise的所有已知BUG列表(6)
Adaptive Server Enterprise的所有已知BUG列表(7)
Adaptive Server Enterprise的所有已知BUG列表(8)
Adaptive Server Enterprise的所有已知BUG列表(9)
 

CR
Number
Description
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.

585260 Unnecessary recompilations may happen if 'open by name' trace flag 299 is activated

and a temporary table has at least one BIT column.

585267 Derived table without specifying column name in the embedded select doesn't work
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.

585313 Create proxy_table fails when ECDA backend table has default values specified.
585444 This introduces "ULC flushes by Log Markers" entry in the ASE sp_sysmon report.

A high value for 揵y Log markers� indicates that Adaptive Server is flushing the ULCs because of

permanent log marker scans (a permanent log marker scan indicate that syslogs includes the log

record). Adaptive Server uses the log records for operations like executing triggers, rollbacks,

aborts, and so on. When Adaptive Server needs a permanent log marker but does not have one, it

flushes the ULC to create a new log marker. When 揵y Log markers� displays a large percentage of ULC

flushes, you may need to reduce the number of unnecessary or redundant triggers, rollbacks, or aborts.

585467 Despite traceflag 11906 being on, reorg rebuild messages are reported to the errorlog.
585474 When using a dblib client version <5.0 that doesn't permit numerics, selecting on a bigint column creates a tds stream error.
585485 Performance of bcp for SMP server is degraded.
585517 When a user with sa_role executes SETUSER to a non-sa_role user,

creates a table and a procedure referring to that table, then

execution of that procedure following a schema change such as

dropping and recreating the table will result in an "object

not found" error (Msg 208).

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).
585665 User applications that use JDBC or Java Stream operations may be affected

by memory corruptions or abnormal process termination when the optimized

ASE binary is in use. This problem is most likely to manifest on Linux 64-bit

architectures.

585707 Sub-optimal plan may be seen under allrows_oltp for query involving distinct multi-table join.
585711 Change in query plan maybe be seen between 'select' and select into' (or insert..select)

for queries involving distinct multi-table joins.

585772 Internal only: stress tests with competing bcp and transfer-table tasks can cause the transfer to encounter a transitory wrong-page error from an uninitialized page.
585798 BCP Wizard's output shows the connection's password, which should be hidden. Also, BCP Wizard should not open if the server name is not in the interfaces file for BCP utility.
585991 The SET SWITCH command does not work with traceflags 7714 and 7715.
586032 If there is /tmp/locales directory and install ASE 15.0.3 ESD#1 into /tmp/ase1503 directory, srvbuil and srvbuildres does not work with error "unable to load localization file /tmp/locales/unicode/us_engli/srvconfig.lcu".
586084 Feature request to see the detailed information of HA sessions.
586167 Automatic workspace expansion in checkstorage does not expand the text workspace automatically even though the text workspace is smaller than the recommended size, which is 25% the size of the scan workspace.
586220 The error msg 414 could be raised if the plan chose reformatting strategy and it has many join predicates.
586356 For queries containing IN/OR list where one or more elements in the IN/OR list is a built-in function, unexpected results might be returned.
586387 Mistype the SIZE option of a DISK RESIZE command as 'SIDE' gives an error relating to DISK UNMIRROR instead of DISK RESIZE.
586425 When running on a Unix system, the BCP Wizard cannot BCP in/out multiple tables.
586426 sp_dropdevice does not delete the physical file created for filesystem device
586499 On Solaris platform, ASE may report "Unexpected AIO error(Invalid argument)returned from aiowait()."

when LDAP User Authentication is enabled (configuration option 'enable ldap user auth' is set to

1 or 2) and ASE is performing multiple user authentication simultaneously.

This bug can be resolved by installing patch for Solaris BugID 6972029

(contact Oracle for the OS patch, sun sparc: 144190-03, sun x64 144191-02).

Alternatively, it can be resolved in ASE through a workaround fix by enabling boot time trace flag 9415.

586565 A Dump or Load operation failing to open the device may not report the underlying Operating System error.
586638 Need to document how to use password encryption with Sybase Central
586640 SpinBox value get truncated when value greater than max.
586666 Internal only: running 'transfer table' on a multi-engine server can fail with OS reported I/O errors.
586727 Under certain circumstance, during recovery, timeslice may be hit while server is processing multiple lock related messages
586748 In case of a mixed log and data database, a deadlock involving cm__waitfor_io()

may be reported during boot recovery.

586779 The dump command may not raise an error message reporting "No space left on device" on Linux when the device is closed using Backup API compress.
586809 "max transfer history" in DTU is missing after upgrade from 15.0 to 15.5 (Aries)
586833 DBISQL does not support password encryption directly.
586861 Query with CASE expression returning TEXT columns and TEXT constant

may fail to execute correctly producing stack traces.

587115 The kerberos principal name in the audit table is not being displayed.
587182 Advisory messages printed by sp_dboption when trunc. log on chkpt. is turned on/off are confusing

because they appear to be errors. The messages will no longer be printed by sp_dboption.

587220 The error 3146 will be raised when trying to load a database from a valid server version onto a database after having loaded a previous version onto the same database without having set the database online.
587274 In rare cases, a process might hit 706 error with stack trace including functions such as rm_prochdr and rec__ctx_cleanup.
587362 If an application made use of a global temporary table in an external environment via a server-side connection, then there was a chance that the server may have given an assertion, hang or crash when the application connection closed. This problem has now been fixed.
587403 When raised by the DISK MIRROR command, error 5101 may incorrectly state that the command being run was DISK UNMIRROR.
587406 In specific circumstance, error 511 may occur during optdiag input mode when creating column histograms.
587426 Specifying a filename of 256 characters for DTU output file results in the correct error with right file name.
587437 When using parallel sort on worktable, errors and/or stack traces can be encountered while executing the sort operator.
587442 Error 1265 when cursor fetch rows from syscomments table.
587525 set tracefile for spid will fail on ibmplinux platform with error 3659 "The spid 0 does not exist."

even when the spid in the command is valid.

587661 max locked memory should be increased with a call to setrlimit from dataserver processes for linux platforms.
587742 ASEPlugin 15.0.3 - NullPointerException error if SSL check box is checked.
587810 Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages.
587877 ASE may raise the misleading error message "The configuration area in device 'master' appears to be corrupt. The server cannot continue and will shut down." following an upgrade if the master device size is than the minimum for the new version.
587879 preupgrade does not raise an error if the master device is too small and will pass the test, then

while booting up the higher version server to apply upgrade, ASE will raise 110272 error.

587984 sybmigrate may raise a 17741 error and fails to create a foreign key if multiple tables have complex logical relationship

(a primary key and foreign keys) with each other.

588137 Duplicate key values could be generated for identity column during checkpoint of the database. For tables with unique indexes on identity column, it would give error 2601 'Attempt to insert duplicate key row in object <obj_name> with unique index <index_name>'. more co

A more complete version of this fix has been developeed under CR 614823, i.e. 614823 supersedes 588137.

588150 Add InstanceID column to the below tables

monInMemoryStorage

monPCISlots

monPCIEngine

monPCIBridge

monProcedureCacheModuleUsage

monProcedureCacheMemoryUsage

588162 For in-memory storage cache, if the memory allocated is less than user's requested

cache size, cache creation will be failed.

588176 15.0.3 or later ASE Plug-in is not compatible with Sybase Central 4.3.
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.

588263 In rare circumstances we may hit error 8211 (Mismatch found between the name and id descriptor hash table for table) while accesing table in the multinode cluster environment.
588268 Provide a command to enables the ASE sysam heart beat process to be restarted in the event that this process has stopped for any reason.
588272 When the ASE Replication Agent connects to the Replication Server version 15.5 or above,

it will issue the Replication Command Language command 'resetqueue' by default

when starting up against a database with a durability value of 'no_recovery',

instead of incrementing the primary database generation ID, so to prevent

the likelihood of hitting a limit while updating the generation ID value.

The current ASE fix will be effective when the Replication Server CR 615322

is also released in some later Replication Server 15.5 ESD version.

588288 New Feature ... exclude rs dsi thread from being deadlock victim in replicate db

refer to ASE CR 230301 and refer to RepServer CR 370359 ... customer wants a feature request added where the RS thread is never the deadlock victim on a replicate db. He's had issues in the past where even after multiple retries, the tran is still in a deadlock causing the DSI to suspend.

If the rs thread is chosen for the deadlock victim, in some cases even after attempting the tran multiple times it still deadlocks, causing the tran to not complete and the DSI to suspend or if set to ignore the primary and replicate dbs become out of sync

588307 To request high-availability when connecting to a cluster, put the following property on Connect Dialog's Advanced tab: REQUEST_HA_SESSION=true
588310 Instance ID, transfer format (e.g., BCP, etc) are added to monTableTransfer
588334 User sees 'stop pv tracing' msg on preview dialog if user calls scheduler from preview dialog and calls cancel scheduler.
588358 Executing installhasvss script raises a 2615 error.
588464 Sometimes, database upgrade fails with error 1204, "out of lock error" while upgrading a system table with a huge number of rows.
588556 sig 11 in GcvIsVirtualColumn when using view in sql regardless of optgoal setting
588594 When the optimizer chooses a query plan that includes a Nary-Nested-Loop Join Operator

(as seen in showplan output) and at least one of the Scan Operators under the Join is

doing dynamic partition elimination (also shown in showplan), the query may return too few

rows. This problem ocurrs in queries with at least three tables and which contain join

predicates involving columns of the partitioned table that are not part of the partition

condition of that table.

588665 A new column "Transactions" has been added to the monState table
588681 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.

ASE reports incorrect name of the function from which it is raised.

588703 Some of the qualifying rows could be missed by an UPDATE statement using at least 2 tables other than the updated table (either directly in the UPDATE statement's FROM clause or within EXISTS/IN subqueries) and the join of these 2 tables involves an expression which contains one of these tables' columns which is also in the UPDATE's SET clause to compute the new values.
588724 The user_name() function incorrectly returns NULL for negative user ids starting in 15.0 GA.
588739 In SDC, user cannot create/alter/transfer a DTU/normal table.
588918 Signal 11 in s__mergelock_in_sub_step ()may be seen in the error log and the spid

terminated for query involving text column, nested convert with concatenation to correlated

sub-query result.

588954  
588978 Error 804, "Unable to find buffer '0x1ead04898' from cache 'default data cache' holding logical page '17179418212732195' in sdes '0x21f3e4700' kept buffer pool for object ''. " may be reported while trying to allocate a new page.
589030 The error, "Warning: The database '%.*s' is assigned the %s property, which will be ignored, because the database has a durability of %s." may be reported while changing the durability of the database.
589045 ASE running on windows may print the result "-0.000000" for some floating point calculations
589061 TEXTPTR() builtin function may sometimes return truncated results with trailing zeros removed. This occurs when a "hash distinct" operator is involved.
589086 Histsrvr can't work without MS VS2005 Redistributable Package(x86) on winx64 platform
589204 Historical Server playback incorrect spid value on unix 64bit platform

and miss the first sample when the timestamp of sample equal to the start time of playback session

589215 Feature request to increase ASE limit that only allow 30 character for passwords.
589218 ASE LDAP user authentication to support LDAP long token - 40 chars for password.
589220 On little endian platforms the builtin is_quiesced(<dbid>) returns always 0 although

the given database was previously quiesced.

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.
589314 Documentation enhancement request to provide a formula for the calculation of tempdb space needed for the update statistics commands.
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.

589444 1502 QP: underestimated LIOs and PIOs for the scan of an idx after deletes
589446 row_count() returns 0 after select-into in tempdb due to a code error.
589473 When parallelism is involved, some queries having more than 6 tables may timeout earlier during plan enumeration resulting in a merge join plan that uses excessive tempdb space.
589491 The authentication mechanism is not displayed in the audit record when doing

dbcc table_xfer_check.

589591 Release bulletin in 15.0.3 lacks much of the information included in previous versions.
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.
589657 With SQL Replication enabled, queries using "CASE constant expression" (i.e. an expression which is not referencing table columns) may fail with error 401 "Invalid operator for datatype op: = type: MAINTENANCE TOKEN" or error 551 "An unknown EVAL was sent to the execution module."
589674 Sending a Java object using Java/JDBC on the client-side can result in a corrupted object stream

being stored in a database table.

589686 Feature request to have Msg 935 (WARNING - the timestamp in database '%.*s' is

approaching the maximum allowed) always be sent to the errorlog when it is raised.

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.

589879 Error 10865 when increase the in-memory storage cache size.
590027 Hit the error 1950 while creating an index by primary key constraint on a partitioned table.
590032 Error 6901 is always reported as occurring in dbid 0 rather than the actual database containing the high timestamp value. Check @@dbts in each database to find the database(s) that actually contain high timestamp values.
590183 In rare circumnstances, sp_monitorconfig might report higher Max_Used value than configuration value.
590190 If a table is on an inner side of a join, the 'UsedCount' of the table could be incremented multiple times of 'OptSelectCount' of the table in monOpenObjectActivity table.
590249 create a config option in RepAgent to suppress the following messages from showing up in the ASE log ...

00:00000:00066:2009/04/01 13:44:09.02 server RepAgent(41): Connecting to a Replication Server that supports a lower LTL version. Features that are not supported by the lower LTL version may cause the RepAgent to shutdown. Set the 'skip unsupported features' configuration option to prevent shutdown.

00:00000:00066:2009/04/01 13:44:09.02 server RepAgent(41): The Replication Server LTL version should be at least 710 for full support of features. (Replication server LTL version 700, Rep Agent LTL version 710).

590312 If reformating strategy is used and an index key has BIT datatype, it could return wrong result sometimes.
590395 The JVM terminates with an error 143 when a user logs off from a Windows OS that is running ASE.
590420 If there are tables with names wider than 30 characters and SET STRING_RTRUNCATION is set ON, sp_fkeys fails with errors 9502 and 17461
590516 EFTS: textsvr with universal filter dumps a core file when building an index on data containing Arabic characters.
590604 When a view is redefined during deferred compilation an error can be reported along with a stack trace in the errorlog referencing modules like "vu_redefine", "col_open_range".
590626 The database timestamp could wrongly exceed its maximum value following

a 6901 error, "Overflow on High component of timestamp occurred in database

<dbid>. Database table possibly corrupt". This is no longer possible.

After warnings that the database timestamp is reaching its limit, the

database will finally be shut down, leaving the database in read-only mode.

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.

590650 The result of derived_stat builtin is incorrect when the partitionid parameter is not supplied.
590694 When sybmigrate migrates the database 'pubs2' from ASE 15.0.3 to ASE 15.5 EE,

the following error message occurs:

Error while executing SQL for migration of 'LK.dbo..au_pix'.

Root Cause:Msg 17741, Level 16, State 1

Server target, Procedure sp_primarykey, Line 131, Status 0, TranState 1

Primary key already exists on table -- drop key first.

Recoverable error. Task 'LK.dbo..au_pix' for path 'pubs2 --> pubs2' will be retried.

590760 A transaction dump that has a DROP and CREATE INDEX commands logged for a clustered index that has the sorted_data, max_rows_per_page and fillfactor options, may result after load, in a corrupted table where errors 692, 605, 2509, and 2525 could be reported.
590800 ASE fails to raise an error and prevent creation of triggers that select text or image columns from the inserted or deleted tables. Such triggers may raise errors including 10785 or 7128, or return unexpected results for the text or image column.
590806 Feature request for native encrypted TDS language.
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.

590932 Transfer format is not correct set, hence the stack trace is hit.
591016 sp_help_qpgroup output for user shows no plans in the output, even when the user can successfully use a stored abstract plan.
591040 Executing a query involving encrypted column may hit a stack trace, if the encrypted column has decrypt_default and column statistics.
591089 Signal 11 in mda_fill_and_send_monProcessWaits
591168 alter table set transfer table on should also check the license file.
591217 Under rare circmustances ASE may produce a core dump file during a server shutdown

when JavaVM activities have left the PCI Bridge in a stale state previously. This core

dump file is not useful to Technical Support.

591323 Implement CIS support for new datatypes, bigdatetime and bigtime.
591324 abstract plan group works for user on sproc, but not for ad hoc query
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.

591508 Error 16735 when boot server with cache partition set to DEFAULT.
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.
591748 dbcc logtransfer may stop and report a stack trace containing the functions lt_send_xckpt()->lt_get_ref_page()->getuncachedpage() while processing a transaction log for an in memory database.
591766 Please include in the documentation for configuring multiple backup servers a paragraph to describe the reason and requirement to update the interfaces file if a round robin policy is chosen and the client requires that any backup server can be started on any node.

In the case of a round robin policy any backup server should be configured in the interfaces file to run on any instance as supported by the documentation:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00768.1503/html/ase_ce_ug/ase_ce_ug8.htm

Dedicated � each instance in the cluster is assigned a specific Backup Server.

Round robin � instances are not assigned a specific Backup Server, but when they perform a dump or load, the cluster assigns a Backup Server for the job according to availability.

591792 A 13988 error, "ALTER TABLE <Table Name> failed. You cannot change datatype of column <Column name> to <Target Data type> when it is an index key.", will occur if an attempt is made to change the datatype of a key column to BIT.
591842 An infected with 11 in _CgpSubstExprVirtCol may be raised for an INSERT SELECT into a table where some columns have defaults and the SELECT is not providing values for those columns. Workarounds are to provide values for each column or use compatibility mode.
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.

592007 On Windows systems when Adaptive Server is running

with configuration option "enable literal autoparam"

active in some circumstances the execution of a query

containing a big literal binary value may be aborted

and the message "SQL Server system exception (0xc0000005)

generated by a storage access violation" together with

a stack trace which includes the modules 'memcpy' and

'mkconst_desc' may be reported in the error log.

592022 The message "timeslice -<number>, current process infected" together with a stack trace which includes the modules "dbts_insert", 'dbts_commits_addxdes', 'xls_test_set_lrdata' and 'ha_session_dealloc' may be reported in the error log when CHAINED transactions are used in an HA environment.
592026 Configurable control is added in the stored procedure "sp_jreconfig" to allow or disallow loading of native libraries from within the PCA/JVM using the load and loadLibrary methods in the java.lang.System and java.lang.Runtime classes respectively.
592246 Add the formula for load score calculation and more explanation on workload management features.
592254 A procedural cross-db statement may fail with errors 208 'Table not found'

during the upgrade process.

592294 feature request: config parameter to revert to 12.5 worker process behavior
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)

592438 QPTune -A collect_stats ... sort output by count in descending order
592444 QPTune -A fix_stats ... add comments with count and sort by count desc order
592484 The Cluster User's Guide need more documentation explaining possible changes in data storage management for customers coming from SMP to the Cluster Edition
592603 When compatibility mode is enabled and a stored procedure is executed, ASE may stacktrace in the function ind__itagsetup(). This happens if a query in a stored procedure refers to a table that is created and dropped inside the stored procedure and that stored procedure happens to recompile after the table has been dropped.
592605 ASE may report 3474 and 3478 fatal errors if a bulk-insert ctlib application making use

of multi databases transaction needs to rollback.

592608 Decimal portion of the proxy columns mapped to NUMBER datatype in Oracle is truncated.
592641 QPTune gui in Sybase Central ... dropdown list instead of blank single line edit when adding User Defined Mode
592650 QPTune gui Sybase Central ... target db once selected should be used from then on ...
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.
592737 After CR 531964 changes, sysprocesses.physical_io maps to piotot which is only incremented

at the end of each statement because of which monProcessActivity had to be used for

tracking i/o activity for running query. The physical_io should report pbufread\pbufwrite

which are incremented as each i/o completes.

592741 For transfer table, even if there is no row coming in from the nextwork, EX_INT

lock is always held.

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.
592758 Unable to configure large data cache.
592792 QPTune gui Syb Cent ... undo missing stats ... the no-execute option is absent ... add this option just like it has been added for the Fix Missing Statistics
592822 ASE can raise excessive amounts of "Warning! The spinlock pool has grown to be larger than the spinlock monitor area. Not all spinlock statistics is available. A server reboot is needed if all spinlock statistics is necessary." messages.
592829 In some cases, using duplicate correlation names for the expressions can lead to a stacktrace in

function find_dup_corrname().

592839 Multiple assertions leading to SEGVs, 707, 714 memory corruption
592858 QPTune gui ... manually control when tuning task finishes & gives results ... this will give a window where outside application and sql tasks could be done before the results are finalized and written out.
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.

592964 charset utility to support no space for the switches -U -P -S -I.
592971 charset utility generate error when you use -I .

CT-LIBRARY error:

ct_config(SET,IFILE): user api layer: external error: An illegal value of -9 given for parameter buflen.

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.

593003 Request for a mechanism to force an immediate update of licenses, rather than waiting for the next heartbeat or rebooting.
593005 Queries involving java running slower under 15.0.3.x than 15.0.2.x
593053 Fix the performance downgrade of sort module with large buffer pool in 15x.
593117 Unexpected errors may happen as a side effect of the compilation of a SELECT INTO #TABLE

statement. The ASE errorlog will report a stacktrace involving module s_normalize. Also under some very rare circumstances on a heavily loaded system, there a risk of random memory corruptions.

593136 Feature request for a new mda table monSysLookup that would store information from monProcessLookup similar to the way monSysSQLText pipelines data from monProcessSQLText.
593139 sp_metrics takes too many locks
593203 sp_configure "max pci slots" will raise error 5849 and not change the configured value of the parameter if a slot higher than the desired value is currently in use.
593326 customer got msg 11041 after drop and recreating user table
593366 When building a cluster with sybcluster, the operation will abort if entries matching the name of the server already exist in the interfaces file.
593446 In rare circumstances error 941 "Illegal database context operation" may be reported into the

errorlog while terminating ASE process.

593459 Under SMP, sp_configure 'nondefault' shows duplicate rows.
593464 Runtime execution errors (Invalid column length) 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.

593512 User datatype hierarchy is not updated when upgraded to ASE15.0.
593582 In rare circumstances when using the 'SET ROWCOUNT' option or the 'TOP' directive with 'SELECT INTO', when executed in parallel mode the rows may fail to be inserted.
593603 The performance of boot time recovery is made slower by an unnecessary number of physical I/Os during the redo pass.
593682 select of varchar returns trailing spaces
593715 Print format error while doing dbcc table_xfer_check().
593730 Add support for selecting text and image columns from the inserted and deleted tables in triggers.
593931 In order to clarify how the load score for an instance is created. It would be very helpful to include the calculation used internally.

LoadScore = ConnectionsWeight*ConnectionsLoad/100

+ CPUWeight*CPULoad/100

+ RunQueueWeight*RunQueueLoad/100

+ IOWeight*IOLoad/100

+ EngineWeight*EngineLoad/100

+ UserDefinedWeight*UserDefinedLoad/100

594060 The quantity of licenses required for the DH license type should match the number of processor chips. Currently it is being treated as a Server license type and only 1 license is checked out.
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).

594204 When the dboption "dbo use only" is set, the database owner when executing sp_adduser may encounter an access error (Msg 923).
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.

594339 On a complicated query, when unlike datatypes are being compared, using a different optgoal causes different filtering order .

This, in turn, may prevent certain data values from being eliminated before the comparison and cause an Arithmetic overflow. This CR is raised to see if improvements can be made in the allrow_mix to filter out "illegal" value.

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.
594383 A stacktrace containing the following functions : LeHashContext::Close(),

memshrink() may occur after a 701 error.

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.
594482 When marking a table with at least one LOB column for replication and for using a replication index

while such an index already exists (for example, orphan index left over or index created first

with sp_reptostandby then again with sp_setreptable), the index re-created is corrupt.

The command 'dbcc tablealloc' reports error 2525.

Run-time errors 605 and 1133 may also be reported.

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.

594550 select * from monCIPCLinks where ActiveState='Up' is not returns any rows even if the state of the link is up.
594566 INTERNAL ONLY: Increase the default max memory on sol64 platform.
594606 Need DDLGen support password encryption
594668 error 806 occurs when creating a clustered index on a temp table
594812 Customer request to be able to create triggers based on database event for ASE.
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.

595140 The 'showplan' diagnostic output displayed by Adaptive server is incorrect for objects in an in-memory database.
595290 Feature request to add a session specific SET SWITCH equivalent for traceflag 526, which causes a semigraphical tree representation of the query plan to be included in showplan output.
595292 An instance of the cluster which is not down, including the current instance, may erroneously be reported as being down via the following message:

02:00:00000:00000:2009/10/14 15:44:04.07 kernel heartbeat message to server 3

failed, error status 4.

02:00:00000:00000:2009/10/14 15:44:09.10 kernel Instance 3 failed.

03:00:00000:00000:2009/10/14 15:44:04.07 kernel heartbeat message to server 3

595299 The SET SWITCH and SHOW SWITCH commands truncate switch names that are over 30 characters wide. In some cases SHOW SWITCH will not display switches that are active.
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.
595488 Request to improve the way we handle partition elimination and add a traceflag to disable the mergeunionall transformation.
595501 The durability of a database after MOUNT DATABASE is set to UNDEFINED instead of FULL.
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.

595600 Installer and "srvbuild[res]" fail to configure an 16k page size ASE with PCI enabled because of insufficient 'max memory'.
595613 When running traceflag 450 under allrows_mix\allrows_dss

to force group inserting for 12.5.x ordering compatibility (or using group_inserting

abstract plan operator, so not specific to trace 450), a query may hit error

257 (implicit conversion error) if group by clause (with having clause) contains

mixed datatypes which cannot be implicitly converted to one another.

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.
595825 Duplicate rows may be inserted into a table that has a non-unique clustered index and that

has one or more BIT columns even though the option, allow_dup_row is not set. For duplicate

rows to be inserted, the total number of BIT columns in a row must not be an exact multiple

of the number of BITs that can be stored in a BYTE (8) - this is a necesary, but not

sufficient condition.

595882 When execute a select into an existing table multiple times, it could cause stacktrace.
595986 A 3151 error, "Adaptive Server cannot load this database because the database that was dumped

was not quiescent when the dump was performed ..." is reported when loading the dump of a database

that has a durability of either NO_RECOVERY or AT_SHUTDOWN on a platform that has a different byte

order to the platform on which the dump was taken. This is despite there being no activity in the

database at the time the database dump was taken.

595988 If $SYBASE starts with /net, srvbuild[res], sqlloc[res], and sqlupgrade[res] report error: unable to load localization file <path>.
596045 An infected with 11 error on function LeSortInputStream may occur when a query

generates a very wide worktable.

596198 User with sa role is allowed to login to cluster while polite shutdown is waiting for current user connections to exit.
596205 sig11 cause ASE shutdown with nowait fails on Linux
596227 When parallelism is turned on, some queries may hang waiting for read operations on pipes.
596244 A Error 969, "You cannot access local temporary databases from non-owner instance", may be reported when a stored procedure tries to use a temporary table (#table) created outside the stored procedure.
596404 DBISQL keeps displaying results in iso_1, even when session is connected as cp850. This causes users to misunderstand data would be wrong. (SQL Advantage displays results correctly.)
596412 signal 11 at _$o1cexwE0.s_opentables+0xcc
596428 Starting ASE on Solaris 8 can fail with core dump if LD_LIBRARY_PATH contains /usr/lib ahead of /usr/lib/lwp (on 64-bit version, this happens if LD_LIBRARY_PATH_64 contains /usr/lib/sparcv9).

Solution is to fix the environment variable setup scripts like SYBASE.sh/SYBASE.csh not to include /usr/lib in the LD_LIBRARY_PATH (or /usr/lib/sparcv9 in LD_LIBRARY_PATH_64).

596532 ASE Cluster Edition may rarely hang during failover recovery.
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.
596680 Job Scheduler in ASE is not able to run more than 4 jobs simultaneously.
596681 Missing message in outputs of sp_helpconfig for some parameters in ASE 1503.
605256 ASE may hit 692 error during 'disk resize' of filesystem devices when server is using sync IO('allow sql server async i/o' set to 0).
605364 When ASE is booted with trace flag 9403 Java performance issues may result due to implicit engine affitinity.
605626 Job Scheduler (jsagent) heap memory usage grows after job runs resulting in memory leaks.
605661 set option or traceflag that turns on reorg rebuild status percent printing to the errorlog.
605671 Under some circumstances when a parameterized statement is

being compiled and Adaptive Server is running out of memory

for procedure cache the message "Stack overflow detected" may

be reported in the error log together with a stack trace which

includes the modules 'pars_release_resources' and 'recvhost'

and may result in Adaptive Server being shutdown automatically.

605811 After the command 'set proxy' is executed, RepAgent still sends the original login for replicated transactions instead of the new impersonated login. As a consequence, when replicating DDL commands, objects might be created with a different owner at the replicate site.
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.
606012 MonCIPCLinks table not showing the details of all the configured links
606015 backupserver's charset setting is not correct.
606019 In rare circumstances, message "current process infected with 11" in the module 'des_wkinstall' may be reported in the error log while executing a query that needs to use worktables.
606061 For exec_procedure auditing the sysaudits.dbid and sysaudits.dbname is being redefined

to be the dbid and dbname where the stored procedure executes.

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
606210 New feature to provide user defined optimization goal functionality.
606231 Execute sp_showplan on a running CIS query may get a Signal 11 stacktrace at

CgpGenerateSQL::_findVariableValue.

606234 When ASE is booted with Java enabled and running under a multi-engine environment

the module responsible for physical I/O protection may not be correctly installed.

606288 Parallel queries with more than 6 tables may perform poorly

if any of the tables are roundrobin partitioned. The initial

plan generated by the alternative greedy algorithm may not be able to be

applied due to incompatible parallel degrees between a join's

input sets. This problem can be diagnosed with

show_abstract_plan tracing where "fail" will appear

prior to completing the alternative greedy algorithm phase.

606449 Sybase Central BCP in "specify field terminator" requires a "\t" for tab delimited files, while command line -c needs no -t \t arg.
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.
606648 New traceflag to control the synchronization of file/device between writers.
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.

606794 Sybmigrate:- Add support for migration between different database names
606830 Feature request for a method to override built-in JVM methods, such as java.lang.Runtime methods that reveal information about the server's system, a possible security issue.
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.

606970 In some cases, DBCC CHECKALLOC may report error 12909, "Table with object id=<id> (name = <name>) inconsistent after Large Scale Allocation. <no> pages in extent <extid> were found reserved.", some time after either LOAD DATABASE or boottime recovery had processed log records relating to large scale allocation.
607039 A user is not allowed to execute a procedure which makes a cross-database

access based on a chain of ownership after the owner's alias is

removed from both databases and his login dropped.

607095 If a database which is template database for an IMDB is renamed using sp_renamedb, the Imdb will not be accessible on subsequent restart.
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)

607464 In some cases, when a database that is used as a template for creating a database

with a durability of NO_RECOVERY is being recovered, a 973 error

"The database '<template_dbname>' is currently unavailable. It is being used

to create a new database." may be reported in the error log.

607467 In some rare situations, if a plan has a "group insert" operator, it could encounter a 613 error.
607520 DOCUMENT ID: DC38421-01-1503-02

Configuration Guide Adaptive Server� Enterprise 15.0.3 [ Windows ]

page 71 has the following ... ( the mention of gb108030 and big5hk is missing ) ...

...

Table 6-3 lists the simplified Chinese character set:

Table 6-3: Simplified Chinese character sets

Character set Unilib required Description

eucgb X EUC GB encoding = Simplified Chinese character sets

cp936 X Microsoft Simplified Chinese character sets

Table 6-4 lists the traditional Chinese character set:

Table 6-4: Traditional Chinese character set

Character set Unilib required Description

cp950 X PC (Microsoft) Traditional Chinese

euccns X EUC CNS encoding = Traditional with extensions

big5 X Big 5 Traditional Chinese

...

page 71 should have the following ... ( gb108030 and big5hk were added ) ...

...

Table 6-3 lists the simplified Chinese character set:

Table 6-3: Simplified Chinese character sets

Character set Unilib required Description

eucgb X EUC GB encoding = Simplified Chinese character sets

cp936 X Microsoft Simplified Chinese character sets

gb18030 X PRC 18030 standard

Table 6-4 lists the traditional Chinese character set:

Table 6-4: Traditional Chinese character set

Character set Unilib required Description

cp950 X PC (Microsoft) Traditional Chinese

euccns X EUC CNS encoding = Traditional with extensions

big5 X Big 5 Traditional Chinese

big5hk X Big 5 with HKSCS extensions

...

607658 Sometimes, during recovery redo pass, error 3474 may be seen

indicating that a page being recovered has a timestamp older

than what we expect at that point.

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.

607877 Stored procedure sp_poolconfig may exhibit inconsistent behaviour and display incorrect error messages.
607924 this change corrects a "no plan found" error

when using trace flag 450

608062 Additional option to sp_addlogin to allow the suid to be specified.
608117 When user runs sp_configure 'max memory' above <platform memory limit>, server message 16738 will be printed following message 5846 for 32-bit ASE.
608170 Querying or Accessing monTableTransfer when tables with "transfer table set on" are present would cause 14120 errors or timeslice in the server.
608200 Some databases, e.g, sybpcidb, do not show up in ASEPlugin's database list.
608216 ASE server on 64 bit platforms fails to start the Job Scheduler when LDAP Directory services is enabled.
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.
608311 If one attempts to "disk init" a raw device giving a size allocation which exceeds that available on the device then the instance engine crashes bringing down the cluster.
608315 After receiving message indicating out of CIPC regular message buffers and the using sp_configure to increase the amount and instance crashed.
608322 A row width warning is raised when installing the sp_showcontrolinfo stored procedure
608323 The message "Warning: Row size (<value> bytes) could exceed row size limit,

which is 1962 bytes." is raised when installing the system stored procedures

sp_help, sp_helpdb, sp_helpindex and sp_help_rep_agent.

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.

608897 System Admin Guide example relating to the "open objects" configuration parameter is inaccurate
608905 In sybmon, memload might hit signal 11 on a host which has different page size with the host for memdump.
608963 The replication status 'never' set on a table may be ignored mistakenly on ASE CE by nodes other than the node where the status was originally set. Alternatively on ASE SMP, this status may be ignored mistakenly after an ASE restart.
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().
609326 During shutdown, if the transfer table command tries to create a transaction or insert data into the spt_TableTransfer history table and it might dump stacktrace with itl_record_transfer function in the callstack along with the 16024 error.
609330 When a user with sso_role loads a 15.0.2 database into a 15.0.3 server

with esd version #2 or lower, error 2736 occurs if the user is not a

named user in the loaded database and the database has a guest account.

609349 sqlupgraderes can not do upgrade because it can not set $OLDSYBASE.
609365 Enhance ASE WebService to embed Jetty6 and fix SSL MITM vulnerability: CVE-2009-3555.
609460 doc bug: ref manual dbcc monitor also needs sa_role for permissions section
609475 In some cases, the error 15717, "The archive database '<dbname>' is already being updated by the process with spid '<spid>'", might be raised when trying to access an archive database that has been recovered by ASE using parallel recovery.
609534 xp_cmdshell creates defunct processes when using "no_wait".
609543 A complex query using CIS tables and OR predicates may stack trace with a SEGV in Pop::popIsCollocated().
609692 When dumping and loading databases containing functional indexes between specific platforms, dropping indexes on the new server can fail with a syntax error message.
609819 ASE may disable the LDAP URL for a locked or disabled login, if the LDAP server returns error code 53-'Server is unwilling to perform'. ASE treats error code 53 as fatal error and the URL is marked as FAILED. ASE should handle error code 53 without disabling the LDAP URL.
609832 A 3478 error, 揇uring undo the page timestamp value is less than new timestamp from log. Page #=<num>, object id = <id>, page timestamp=<value1>. Log new timestamp=<value2>. Log record marker = (<num>, <rowid>).� may be reported in the error log together with a stack trace which includes the modules 憍act_rollback� and 憆ec_undo_session� when SAP ASE rolls back a transaction and while the housekeeper garbage collection task is working on the same Page# unexpectedly.
609894 Implementation to an updateon image column uses less space of log
609895 Wrong result set for date/time style parameters (117 & 118) for convert function
609943 Signal 11 may be seen in the errorlog wih a lasterror of 9504 in function ind__itagsetup()

and the spid terminated when fetching a cursor after an update at isolation level 0.

The cursor would need to be sensitive (likely to involve a hashing operator)

609946 For SuSE Linux (32 bit) platform, ASE can not use more than 2GB shared memory.
609996 In ASE SDC, the message "current process infected with 11" in the module may be displayed in the 'cm_check_if_noobject_bound_cache' cache deletion module. This may happen when the cache creation succeeds in one of the nodes and fails in others.
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.

610120 Under rare circumstances, it is possible for a distinct operator in the outer query to not

be respected if the query contains nested sub-queries and two or more tables are joined

along with one table also being involved in a left join to another reference of the same

table.

610144 In rare circumstances, the signal 11 might occur when compilation optimization

of LWP with distinct and outer joins.

610150 The Ref Manual entry for sp_server_info attribute_info value 2 incorrectly indicates it is equivalent to @@version. The returned value is actually used to determine version compatibility for ODBC drivers and may reflect a much older version.
610164 The error 822, "Could not start I/O for request" could be sporadically be raised

when ASE incorrectly tries to flush index pages to disk in an archive database,

without having remapped them to the modified pages section.

610310 softlink is added to load libkonavm.dylib in case it is missed on the DYLD_LIBRARY_PATH. ASE must be able to load this dylib to boot
610496 Signal 11 in function CgEvals::_CgCompVcol() may be seen in the error log and the spid

terminated under rare circumstances involving a reformatted correlated subquery with group

by\having clause which references a column in the outer query. Other entries in the stack

would include CgpGroupHashing & CgpStoreInd

610502 doc bug: no doc on upgrading ASE 32-bit to 64-bit Windows
610506 QPTune "collect" may appear to hang when processing a large number of rows (eg. about 2M) in the catalog sysquerymetrics.
610709 Adaptive Server Enterprise Plugin for Sybase Central incorrectly shows that the password for a login is not expired while actually it is expired.
610758 Job Scheduler have the ability to automatically startup on a running node after failover.
610763 monOpenObjectActivity does not record stats for system table even if the traceflag 3650 is on.
610851 Performance for Batch insert is slow for SDC when using large pools for logs.
610956 ASE installations with large number of databases, with high number of engines and inter database transactions would result in high contention of dbt_spin.
610987 sqlloc: cannot select some charsets in gui after charset utility is run
611007 doc bug: ddlgen hide passwd feature is wrong in two places. It is 'ext', not 'pwd', that is passed to the -P arg.
611032 Internal Only: This is a prototype to verify performance gains from compressing network packets.
611067 The spinlock monitor area should dynamically increase to accomodate spinlock pool growth.
611152 SET ROWCOUNT does not take effect for CIS quickpass UPDATE, DELETE and INSERT-SELECT queries

which do not return a result set.

611164 free accounting space on log breaks load sequence and causes error msg 4306 on offline database.
611370 In a Warm Standby environment it is now possible to replicate the new commands 慶reate/alter/drop login profile�. Replication of login profiles is possible when the master database is configured for replication. However, when the version of the source ASE is newer than the version of the target ASE, replication of login profiles is not possible.
611378 Stacktrace with the invalid Column length msg when store_index is used in AP
611383 Conversion error 257 when traceflag 450 is enabled
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.
611577 Signal 11 may be seen in function yyparse() and the spid terminated after having received

an error 156 during attempted execution of invalid 'create procedure' statement contained

within begin..end block.

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.

611689 In some special case of scanning a dol table, the interested page/buffer brought into another cache could cause 871 error.
611707 ONLINE DATABASE command and Faiover Recovery are not synchronized in some cases.

They may progress in parallel on a database; may result in corruption.

611728 Config value like 'SQL batch capture' which is set in config file might be reset

to 'DEFAULT' after reboot.

611797 JVM/PCI Future extensions (performance).
611831 When references are left in sysattributes for a login and replication attempts to

add the same login and suid again, the attempt fails with error:

"Fatal protocol error. xact_beginupdate() API was invoked in the wrong context..."

611840 Sybase Central prior to version 6.0.0.4753 does not support Windows 7.
611851 Integrated login mixed mode fails for local system account even if valid username/password is specified.
612251 Msg 7717 when running dbcc orphantables("drop").
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.

612286 Database and transaction log dumps that are taken on Adaptive Server 15.5 CE cannot be loaded

into a database on Adaptive Server 15.5 (non-CE). In order to ensure disaster recovery then

either load the dumps into a database on Adaptive Server 15.5 CE or use Replication Server

or sybmigrate, the Sybase Migration tool.

612287 High contention on ASE rdesmgr_spin spinlock may be seen with certain workload. This fix reduces contention on rdesmgr_spin in some scenarios on linuxamd64 and sun sparc64 platforms. It does not yield any benefit if des_bind is already used for all tables involved.
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.
612449 If a cursor is used to update a table which contains a TIMESTAMP column and this TIMESTAMP column is not in the cursor's SELECT list, ASE raises error msg 594 when updating other columns in the SELECT list.
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.

612492 Feature request - Enhance update index statistics for proxy tables to import histograms for non-leading columns of a composite index.
612498 If compatibility mode is enabled and an insert is performed requiring a large number of columns with a group by, a message 511 is issued saying that the logical page size limit of 1960 bytes (2K page size) is exceeded. If compatibility mode if off, everything is fine.
612681 Sometimes a task that hits error 892 can go into a loop, continuously raising the same error. This

can result in server shutting down.

612769 The sybcluster do not check the instance names entered by the user and verify that they are valid values.
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.

613175 In system with large number of locks/buffer cache configured sp_clusterlockusage takes very long time to finish.
613221 The sybcluster utility does not check the traceflag value entered by the user and verify that they are valid values.
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.
613411 Currently, using a pre-15.5 client to call current_bigdatetime() directly results in errors 247\3606:-

Arithmetic overflow during implicit conversion of BIGDATETIME value '

Invalid pointer param number 3, pointer value 0x9cf500d408f1

This CR is to change the return value to be either current_date() or raise an error stating 'not supported' when a pre-15.5 client is detected.

613412 sp_monitorconfig may report values of "Pct_act", "Num_free" incorrectly for 'number of locks'.
613474 The first time syconfig is used to create an ASE, the specification for tempdb size and device is ignored and tempdb is created only on the master device with the minimum size.
613537 Customer modified the standard resource file (XML Schema Model language ) "xsd.xsl" by

adding customized Property tab page (e.g. for Element in XSM).

With the new tab page, some buttons do not work as expected, producing empty windows or

no response at all. E.g. it is discovered that those buttons of "reference object" and

"type object" on it are fail to browse and only get an empty list. While the default

General tab has no problem.

613548 Customer modified the standard resource file (XML Schema Model

language ) "xsd.xsl" by adding customized Property tab page (e.g. for Element in XSM).

With the new tab page, some buttons do not work as expected, producing empty windows or

no response at all. With the customized property tab page, there seems no way to add Data Source and data mapping with the source.

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.
613659 When auditing the grant/revoke commands the full command text will be written to

position 2 of the extrainfo section of the audit record if available. Otherwise the

Grantee and Command Type will be written.

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.
613737 When 'disk init' is executed simultaneously from multiple connection may lead to creation of devices with same vdev number.
613750 Feature Request: Make dbcc checkstorage not to report the default excluded faults (ie. 100035, 100037 and 100040) and also other faults which are defined by sp_dbcc_exclusions.
613758 query with order by and rtrim return wrong result.
613782 Under certain circumstances, an ASE server installed on a Linux PAE kernel may not be able to start a second engine
613786 If the size of an in-memory device is not an integer multiple of the size of an allocation unit, creation of in-memory database on such a device may hang.
613808 system procedure 'sp_volchanged' may fail, if the dump operation happens to be on remote backup server.
614211 sub-optimal query plan for Distinct with subquery that include Max()

in allrows oltp compare to compatibility mode.

614236 Some MDA tables are populated with data, even when 'enable monitoring' is set to 0.

This needs to be stated in the docs.

614411 When runing PCClient autorun.exe on FDCC Vista and select "Install PC Client Components", the installer can not be started and show error "Windows error 216 occured while load JVM".
614424 optdiag simulate is broken in 15.5 GA releaase for SMP

installations. The following error is generated:

optdiag simulate statistics qts_db -Usa -P -T1

OptDiag/15.5/EBF XXXXX SMP/B/x86_64/Enterprise Linux/asearies/2431/64-bit/OPT/Mon Jan 11 00:38:22 2010

...

Server Message: - Msg 207, Level 16, State 4:

Invalid column name 'instanceid'.

Internal error: ct_results() returned result type CS_CMD_FAIL.

Optdiag failed. Check for error messages above.

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.

614757 capability 102 uses value 4 by default and doesn't specify what value 4 is for in the dcany.cap.Cause error Msg 30291 with ASE15 onwards
614823 Duplicate key values could be generated for identity column during checkpoint or a node shutdown and rejoining the cluster. For tables with unique indexes on identity column, it would give error 2601 'Attempt to insert duplicate key row in object <obj_name> with unique index <index_name>'
614854 Executing of sp_encryption to add a system encryption password or using the built-in

password_random will cause a SIGSEGV resulting in a stack trace in ASE 15.5

if the /dev/random, /dev/urandom, and /dev/srandom do not exist.

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.
614957 Sybase CE in VCS-mode fail to change sortorder.
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.

614982 In rare circumstances, the message "Infected with 11" together with modules like "Pop<ParallelCost, ParallelProps>::popCheapestDegree()" can appear in the errorlog for queries involving round robin partitioning, or CIS queries.
615025 Changing the charset or sort order while running ASE in VCS membership mode may result in the sybase VCS service faulting.
615029 Adjusting user connection limits under VCS results error 15550.
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.

615210 During bootup or when using sp_configure, ASE may indicate that verification of a

configuration failed because "The sum, (number of user connections) + (number of devices *

max online engines) + (number of remote sites) + (max number network listeners) +

(max cis remote connections) + (number of java sockets), must be no greater than '<value>'", where the 'value' at the end is not correct.

615223 DBCC SERVERLIMITS incorrectly reports the limit on number of user tables in a single statement to be 512. The limit is actually 50.
615382 ddlgen generate syntax error on create table command.
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.
615880 2 queries in 1 batch is slower than 2 queries in 2 batches.
615890 (HP Only) Switching off the 'pca_jvm_netio' property to disable network I/O for RMI sockets

in the PCA/JVM, through either the execution of stored procedure sp_jreconfig "disable",

"pca_jvm_netio" or manually does not prevent RMI socket operations from working despite

the property being set to disabled. Consequently a Java RMI client will continue to be able

to connect to a remote RMI server to execute some functionality over the network, although it

should not. To avoid this problem remove the unused RMI class(es) from the database.

The pca_jvm_netio argument is enabled by default.

615911 Release Bulletin contains inaccurate information about Replication Server.
615923 When changing the default character set id or changing the default sortorder id, after doing sort order chnages when restart the server, it may hit SIGSEGV.
615978 When booting up ASE 15.5 on windows platform by opening a command prompt and executing the Runserver file, an error message is logged indicating that the dll for ldap cannot be loaded.

This error does not occur if the server is started as a windows service.

615992 SELECT show_cached_text(<invalid value>) INTO <table> can generate invalid rows and the following query could cause stacktrace.
616005 On a server with a large number of objects the sp_sysmon report may take a long time to complete and report error number 1508.
616168 When running under traceflag 566 to prevent the truncation of trailing blanks during char -> varchar conversion in worktables and during hashing operations, a 102 message, "Incorrect syntax near ','.", may be raised when running sp_sysmon with 'cache wizard'. The error is raised in sp_sysmon_dcachestats.
616171 Feature request: A copy of common.loc and server.loc that can work with 15.5 langinstall
616224 Like pattern matching may return fewer rows when the following conditions are met:

1. server's default sortorder is non-binary single-byte sortorder

2. like pattern is a constant literal

3. like pattern string length is the same as column data length

4. column is either varchar or char

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.

616466 Added SQL Debugger support for new datatypes:

1. Unichar

2. Univarchar

3. Bigtime

4. Bigdatetime

616604 Integrated login security on 64-bit NT can produce stacktraces
616783 Various issues might show up during cache/pool configuration.
616827 Signal 11 occurred in lmsort() when update index statistics
616836 DUMP WITH COMPRESSION = 101 may fail with messages Pipe I/O returned 0 bytes

followed by Multibuffering subprocesses died

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."
617003 xp_echo.mak make file is incorrectly pointing to libsrv.lib instead of libsybsrv.lib
617191 Sybase Central is unable to recognize and use the OCS interfaces file syntax for commonName handling for SSL of the form: query tcp <host> <port> ssl="CN=<commonName>".
617199 doc bug: missing manual steps to sybsystemdb syscoordinations table
617227 Error 8203 may be wrongly raised when doing select into or alter table. The message

seen is as follows:

Expected to find the descriptor for object %d in database %d in CLONED state.

617372 When user make use of srvbuild to create monitor server and input invalid value which exceeds the allowed maximum number 20, there is no warning message but task will fail due to can't boot server in the end.
617412 Password should be quoted if it has special characters.
617420 Additional diagnostic information is printed in the error log if the 837 trace flag is on and an 890 error occurs.The diagnostic information is either or both of:

log__newpage: Page <pageno> is in DESTROY state prior to bufawrite.

plc__flush: Page <page> is in DESTROY state prior to bufpredirty.

617437 installshield: special character "#" in install path will fail.

This should be fixed or documented in the install guide

617459 Feature request to further automate the process in which the optimal histogram step count is calculated for each object.
617568 Instrumentation to help find the root cause of Error 3501.

The spreading of dbt_dbname field corruption from one instance

to other instance is prevented. The DBCC DBTABLE command is

enhanced to set a new database name in the DBTABLE on all cluster

instances.

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.
617821 query doing table scan in 15x instead of OR Strategy (as in 125x ), query performs better using the m_scan hint under the plan clause.

Optimizer using Table scan because cost is cheaper than OR Strategy

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.
618177 Feature Request: Add replication support for encrypted columns of type Text/Image/Unitext
618191 This CR is to look at improving the capture and reporting of the monitor counters

surrounding lwp (statement cache) and procedure execution.

Currently the figures (which will generally be reported via sp_sysmon) can be a little

misleading under certain circumstances.

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.

618245 UPDATE STATISTICS on a proxy table with a specified column may return error 12814 - "Failed to write information in SYSTABSTATS."
618289 User performing a DROP INDEX is blocked indefinitely by the HOUSEKEEPER CHORES process in what appears to be an undetected deadlock.
618418 The store procedure sp_shmdumpconfig might report incorrect values for estimated dump file size for ASE Cluster Edition.
618451 The message "dbid <dbid> objid <objid> open failed" may be reported when running DBCC EXTENTZAP or EXTENTCHECK on a table that is missing entries in sysobjects.
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.

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.

618515 DiagQ enhancements under TF 15578. Also, fixes a problem inside OCM where A task is sleeping inside ocm_lock waiting for lock-downgrade(BAST) request to be serviced but BAST is not serviced even though no task is holding ocm_lock;this makes other tasks to block/sleep which in turn cause system hang.
618518 sp_configure 'enable HA' does not report failure on platforms that do not support HA.
618609 Optimize NOT IN on NULL columns querys.
618617 (Internal Only) Add support to replicate predicates contained in the "Grant Role" command.
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.
618781 With the configuration option 'net password encryption reqd' set to 1 or 2, 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.

618799 New Feature Request ... create a IndexName() funtion that returns the name of an index when object id and index id are provided.
618815 BCP IN will fail with error 2624 when the target table has one or more encrypted columns and all variable length data in a row is NULL.
618817 Error 624 may be raised during recovery if the rs_locator value used by the replication agent is stale among other reasons. This is a feature request for a new error message that to be raised for the rs_locator case explicitly pointing out that cause of the error.
618851 The message "current process infected with 11" in the module 's_free' together

with a stack trace which includes the modules 'clean_process' and 'kill_proc'

may be reported in the error log when a session executing a query involving

session temporary tables was killed by another session and statement cache is

enabled in Adaptive Server. Under some circumstamces a 6103 error, "Unable to do

cleanup for the killed process; ..." may also be reported after that.

618859 MDA table monCachedObject differentiates user objects as tables or indexes instead of 'user table' only.
618876 Error 585 is raised when IDENTITY_INSERT is used to insert the result of a SELECT UNION ALL into a table with an identity column. No error is raised with plain UNION.
618881 An infected with 11 involving operator LeHashOp or LeGroupSortedOp may be raised when

selecting an aggregate function such as count() from a DISTINCT derived table based on an

equijoin between local and proxy tables and the equijoin is on char/varchar type columns.

618910 The diagnostic information that is reported for the 707 error has been enhanced. Following a 707 error, a message of the form:

(<module name>) Diagnostics for error 707 state 10: <diagnostic info>

is reported in the error log together with a stack trace.

An additional single line of diagnostics is reported prior to the message

and stack trace above, when the 723 trace flag is turned on.

618926 A connection/isql session may get terminated printing out a stacktrace involving the functions :s_compile(), s_compile_stmt(), PssInit(), getdbsize_in_mb() in that order when the task receives attention when waiting/sleeping after a lock request.
618958 ddlgen 155 fail with source ASE 12.5.x.
618963 On a multi-engine server, the number of Ct-lib connections per engine may not be evenly distributed among all the engines. The load imbalance is observed using the sybmon command 'engines -1 ectcount'.
618975 RAT error message 9265 displays an incorrect database id value.
619016 The message "Starting diagnostics for read failure" together with a stack trace which includes the modules 'db_diskremap', 'db__diskremap_sysusages' and 'pg_fill_supergam' may be reported in the error log when a database dump from a different platform and with a different diskmap is loaded in a ASE cluster server.
619051 The Sybase Control Center ASE Monitor reports error 12052 when the Statement Cache screen is opened for an ASE server that does not have the statement cache enabled.
619118 The automatic start of Backup Server results in defunct sybmultbuf process after the backup is complete.
619134 @@rowcount is not 0 after TRANSFER TABLE command failed to import data.
619141 REORG: compact followed by sp_flushstats systabstats.delrowcnt incorrect
619229 Rep Agent does not send some commands to Replication Server.
619234 Feature request to allow success/failure auditing of system stored procedures.
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.
619240 ASE to implement full TOP functionality as views, subquery ....
619259 When an instance is initializing shared memory which could take a very long time, it is not sending cluster heartbeats to the other cluster members.
619267 User Defined Functions may not get called correctly in queries involving outer joins
619324 DDLGen for a table does not generate ddl for indexes which have been created with sorted_data option
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."
619397 Enhance sysdepends so it can handle cross-database dependency and does not lose dependency information as dependent objects are dropped and rebuilt
619431 In rare circumstances error 834 (Illegal attempt to clean buffer) may be reported in the errorlog while starting alter table utility on multinode cluster.
619437 Feature request to provide an option to DBCC LOG to limit output to a particular range of datetime values.
619575 Compatibility mode doesn't update monOpenObjectActivity UsedCount,LastUsedD
619611 Under certain circumstance, an error 632 may happen to an instance of a multiple instance cluster, it

may lead to subsequent error 1601 and error 8601on the same instance, and bunch of user tasks can't

proceed on one or multiple instances of the cluster when the situation occurs.

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.

619781 sp_helpdevice master incorrectly shows that the master device is opened with dsync 'on' and direct i/o 'off'

even if the master device is the file system and the platform supports direct i/o.

619857 Transfer table import command in hppa platform would throw sig11 if the file provided to the command is corrupt or empty.
619893 sqlupgrade help button on the upgrade status screen fails to show the message.
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.
619932 SYSAM lmreread fails due to hostname being truncated at 32 characters.
619938 dbcc checktable returns "An invalid 'data row id' value..." after upgrade
619956 sp_setreptable and sp_setreplicate without table name, do not list tables with replicate status of never.
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.

620108 sp_helpdb will not display information on a database if the suid column value in sysdatabases for that database does not exist in syslogins.
620146 In a Multi-Node cluster, a node crash and re-join could end up generating duplicate identity values for objects with identity column.
620173 Under rare circumstances, due to missing cleanup code that is

normally performed when an ASE task disconnects from the COTS JavaVM,

stale entries for UDF/ADT objects may be left behind and could

be processed mistakenly when the COTS JavaVM migrates to another

engine resulting in unpredictable JavaVM processing and sometimes

in ASE shutting itself implicitly.

620181 In multi-engine systems, performance degradation might happen due to high spinlock contention on rdesmgr_spin.
620183 DB2 DATE and TIME datatype cannot be mapped to an ASE DATE and TIME datatype against

MFC 15. They are mapped to ASE DATETIME datatype instead.

A workaround fix is provided to enable the mapping and traceflag 11238 is

used to turn on the fix.

620241 In rare circumnstances, database processes are waiting for a semaphore from the kernel memory

pool and can not be killed.

620250 The formula provided for calculating the precision and scale of the result of a division operation on two numeric datatypes appears to be incorrect.

The correct formula for the precision should be 憁ax(s1 + p2 + 1, 6) + p1 - s1 + s2� and for scale 憁ax( s1 + p2 + 1,6)�

620278 SEGV 11 in AnyDataType::_computeBoolResult.
620330 SySAM standalone server installer included in the ASE 15.5 installation files missing

cpuinfo , lmutil and sysam.

620382 An ASE installer is aborted when satisfying the following requirements. An installer will be stopped after it selects license type of 1.

1. LANG=ja_JP.utf8

2. setup -console option used.

620470 The message "closetable: table already closed for sdes <value>" together with

a stack trace which includes the modules 'closetable' and 'pg__allocate' may be

reported in the error log when a DML command has been previously run and hit

error 1105.

620503 Doc Enhancement request for discussion of precedence of password policy related settings. In general, login-specific settings override global settings, a login attempt has to pass all the applicable limits to succeed, so the most restrictive limits have precedence.
620504 Fix the error 871/20/2 when running reorg compact in ASE 15.5
620512 Backup Server does not print Operating System error when a Network error (status 32) is encountered in srv__io_check.
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.
620626 In SDC, nodes may run out of physical locks when configured with disparate cache sizes.
620628 EN templates should be displayed when no other templates are available for JS in the language the client machine is using.
620662 Feature request to more clearly document the cardinality relationships between ASE and Web Services engines. As a consumer, ASE can make requests from any WS defined in sysservers, but as a producer WS can only make requests from the single ASE defined in its properties file.
620677 Procedure sp_spaceusage raises error 247 when run on a table that has more than MAXINT rows.
620769 On a Windows 64bit Adaptive Server, a LAST CHANCE EXCEPTION HANDLER on OS thread id caused by an attempted read from an invalid memory address either during LDAP user authentication or with

switch 3635 turned on.

620787 DBISQL will return conversion error when select current_bigdatetime from unixASE
620806 For INSERT SELECT queries with an ORDER BY clause, the ORDER BY clause may be ignored if the table being inserted into has referential integrity checks.
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.
621138 Under certain circumstances, a stored procedure that references a view can raise error 11060 if the objects are created on a 15.0.3 ESD#2 server and that server is subsequently upgraded to 15.0.3 ESD #3
621148 system function and / or system sproc that gives actives roles for all spids

an administrative function and / or sproc to be able to display the info returned by ...

show_role()

sp_activeroles ... this gives both show_role() and user_defined roles

...for spids other than the current administrator spid.

In other words ... let's say there are 3 active users in the server...spids 12, 17, and 21 The administrator is logged in with isql and has spid ... 17. OK right now this administrator is only able to get show_role() to return the active roles for spid 17. What the customer wants is to show the active roles for spids 12 and 21 also.

621156 Reference to unknown procedure sp_fragmentation in the definition of sp_index_space_est.
621167 OLDSYBASE is not a valid SYBASE path.
621276 sp_sysmon reports Error 969/14/4 against local user tempdbs
621323 Some messages in dataserver logs related to failover need clarification or changes to make the actions of the server clearer.
621326 INSERT, DELETE or UPDATE commands executed with minimal logging together

with the chained transaction mode may fail with a timeslice error being

reported in the errorlog showing the module xls_test_set_lrdata and

dbts_commits_addxdes.

621333 On sunx64 platform, signal context output in sybmon is incorrect.
621445 sp_modifylogin delete minimum password length when this value is not default
621449 Enhance Active Messaging to support empty string message properties.
621466 update index statistics tablename partition_name does not update the nonclustered indexes on the partition
621493 "Sample" command in sybmon show incomplete stack info on AIX platform
621615 Sybase Controll Center to have option to configure the sender address.
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.

621863 When a DISTINCT view (or derived table) is queried in a parent DISTINCT query or

is part of an EXISTS join (e.g. under IN/Any subquery),

signal 11 stacktrace could happen in CgpPop::_CgpPePredBmToScalar() for

distinct operator (CgpDistinctHashing/CgpDistinctSorting/CgpDistinctSorted)

when the following three conditions are all true:

1. The DISTINCT view/derived table has at least one expression SELECT column;

2. The parent SELECT DISTINCT columns are only a subset of the DISTINCT view columns.

Or if the EXISTS join is on one of the DISTINCT view columns;

3. One of DISTINCT view columns which is not part of 2) has a predicate on it

in the parent query block.

621978 In rare circumstances, a 707 error with state 10 "System error detected

during attempt to free memory at address 0x<address>. Please consult the

ASE error log for more details." may be reported for an ASE that uses

a procedure cache whose size combined with the size of the statement cache

exceed the value of 4G-bytes.

621996 stacktrace starts with CgEvals::_CgCompVcol when plan use hash join.
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.

622066 Upgrade from ASE1503CE to ASE15.5CE will show in-memory stats for user objects are showing 0 rows/pages unless reboot
622088 monOpenObjectActivity.RowsInserted is wrongly updated even when the INSERT command gets aborted.
622090 ASEPlugin attempts to access local tempdb for another node than the one the user logs into.
622114 In some situation, if compatibility mode is on, computed column is not getting the correct values from an identity column.
622123 In rare cases, the recovery of a prepared multi-database transaction that started in the master database and that had a transaction branch on a remote Adaptive Server, might result in an inconsistent completion state between the branches of the transaction.
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>

622339 In ASEMAP 3.1, on both SMP and SDC screens for ASE monitoring, if user switches database selection in the database table while the bottom tabs are in their default order, the 'Selected database:' will show the correct name of the database. However, if user is on another tab (not the Details tab) and switches the database selection, the 'Selected database:' does not get updated. This issue is fixed in ASEMAP 3.2.1.
622350 The execution of a stored procedure that in turn calls a cross database udf may result

in permission error 10351 if the caller of the stored procedure is not the owner of the

udf.

622415 If a table has a trigger defined and 'statement cache' and 'literal autoparam' are enabled, it could cause a problem if a error is detected when processing the trigger.
622433 Stored proc sp_jdbc_getxacoordinator is not cluster aware (returns Error 512)
622492 When a procedure is created containing a 'select *' from a table which joins a

derived table, the expanded derived table columns may be placed within the derived table

definition as oppose to the outer query.

This could lead to an error 107 when re-creating the procedure from the text stored in

syscomments

622499 Deadlock IDs not correctly inserted into monDeadLock, they are always zero.
622528 On ASE 15.x a Correlated subquery on a proxy table may run much less efficiently than on previous versions.
622538 In rare circumstances, a 12323 error may be raised when running REORG REBUILD on nonclustered index of a DATA_ONLY LOCKED table.
622590 sp_monitorconfig reports inconsistent info if 'procedure cache size' is reduced.
622595 Wrong outerjoin result may happen for a query with

an outerjoin between a GROUP BY view/derived table and other table

when there is a constant sarg in the view for the equality joining

column. Null-supplied rows from the outerjoin may be incorrectly

eliminated.

622717 The example for ALTER TABLE DECRYPT in chapter 9 of the 15.0.2 User Guide for Encrypted Columns is missing the keyword "modify". It should read "alter table stolen_ccards modify ccard decrypt "
622722 In SDC, error 2601 is seen when insert large number of identity values into table

with unique index. Trace flag 16842 can be used to track the SQL that caused the

2601 error.

622771 Error message: ks_falloc: Cannot allocate using ubfalloc(rnetmempool, 2097152)

is reported in errorlog and login failures prevent additional user connections.

622787 ASEPlugin doesn't display 'trunc log on chkpt' and 'select into/bulkcopy/pllsort' databases
622883 In rare situation, "dbcc lockgc" might run into errors related to spinlock
623103 A simple join with order by completes in miliseconds. Use another column, and it never completes, filling a 3 gig tempdb. Changing the join order does not help unless you use "set forceplan on".
623139 Doc bug: We should tell about predicate evaluation order.

There is no guarantee to evaluate and execute predicates in left-to-right order.

For example, if you run a query having "WHERE x != 0 AND y = 10 OR z = 100", Adaptive Server does not guarantee to evaluate and execute "x != 0" first.

Adaptive Server can evaluate and execute predicates in any order.

623166 Under certain circumstance, long lock hash chain(s) might contribute to 100% CPU or performance slowdown
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.
623307 In rare circumstances, a 692 error "Uninitialized logical page '<value>' was read

while accessing ... object 'syslogs' (8) ..." together with a stack trace which

includes the modules 'rep_agent_thread' and 'xsc__syslogs_getnext' and 'wrongpage'

may be reported in the error log by the Adaptive Server Replication Agent task.

623316 Comparing bigdatetime values under a parallel plan may cause error 9566, "worker process plan copy error" to be raised.
623349 Concurrent DML for APL table on different node may cause server hang. ASE may absort the suspect transaction.
623357 BS doesn't use directio or dsync i/o mode as configured for database devices on linuxia32 platform
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.

623444 delrowcnt incorrect even after we run update stats/sp_flush when we delete rows
623569 CIS update on text field (which is documented as not allowed) corrupts remote data rather than giving an error
623591 Error 691, "Encountered invalid logical page <pgid> while accessing database <dbname>, object <objname>, index <idxname>, partition <ptnname>. This is an internal system error. Please contact Sybase Technical Support.", will be raised when running WRITETEXT statement on a text page chain of a replicated table after rebuilding this text page chain using DBCC REBUILD_TEXT with the first text page number specified.
623613 The installdbccdb script raises error 911 if the dbccalt database does not exist.
623658 When literal autoparam is enabled, sometimes query with builtin function hash() and hashbytes() could raise parser error 11793.
623669 Not a bug.
623697 ASE doesn't passes directio or dsync i/o as configured for database devices on HP platform
623776 Do not acquire cluster-wide distributed locks for objects which belong to node-specific databases like local user tempdbs.
623777 Document enhancement to add a note under the REORG command that ""REORG has no effect on space allocated to TEXT or IMAGE columns"
623780 Include the function name in error 14217 text "SQL function not found. If you are attempting to call a java UDF, Java services are not enabled."
623788 ASE can't start Job Scheduler on IPV6 enabled AIX server for specific ipv4 addresses
623833 A 6909 error, "The timestamp (<timestamp>) of the transaction that started at date (<date>) in database '<dbname>' (database id '<dbid>') is earlier than the timestamp (<timestamp>) of the most recently started transaction." may sometimes be reported when the log records of a transaction running in chained mode is flushed from its user log cache by another concurrent session.
623902 For local tempdb, more resources maybe consumed for the applications using local tempdb than it is needed
623912 Implementation of insert/select text value into the compressed LOB columns from constant.
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.
624043 A 12319 error, "Fatal internal error encountered during deferred dml on table '<value>'

in database '<value>'. All rows that qualified during the first phase were not visited

during second phase of dml." may be reported in the error log together with a stack trace

which includes the modules 'dodeferred' and 'dol_def_update' if an UPDATE command has

been previously run against a data-only-locked table.

624050 DBISQL's window title now includes both the login and user name in the following format: "server_name (login_name) / database_name (user_name)". Previously the format was: "server_name (user_name)".
624084 Much description of regedt32.exe is included in the manual of ASE15.5. but regedt32.exe was replaced to regedit.exe. Please use regedit.exe, in using WindowsXP or later.
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.
624215 Connect Dialog's recently connected servers do not load updated host/port information when the corresponding server entries in the interfaces file have been updated.
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.

624536 CIS delete on a non-empty proxy table when involve a join with local table fail
624565 Stored procedure "sp_poolconfig" will fail with return status =1 when configuring/updating cache pools and auditing is enabled.
624566 Under very rare circumstances, for caches using the clock replacement

policy, the instance level physical lock on a page may be released

without ensuring all local users of the page have finished working on it.

Subsequently, the Adaptive Server Cluster Edition will report the

following 892 error:

"Process <spid> is holding a latch on buffer <buffer-address>

(dbid: <dbid>, pageno: <pageno>) without holding a physical

lock on the buffer".

624575 Require the partitioned information of tables saved in errorlog during upgrading from 12.x to 15.x
624724 SET options "literal autoparam" and "statement_cache" are on by default but only have any effect if the corresponding server-level setting is configured on. They are used to allow the session to opt-out of using the feature.
624734 sp_configure returns no output when sort order is set to case insensitive.
624777 New feature: grantable privilege MANAGE ANY THREAD POOL introduced for create/alter/drop thread pool commands.
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)

624853 The definition of sp_passthru procedure of ASE15.5 CIS Users Guide is not correct.

The definition of the @server parameter of ASE15 to sp_passthru procedure was extended to

varchar (255). And the errmsg parameter was also extended to varchar (1024).

624870 The operation procedure of Sybase Central included in an ASE15.5 administrator guide is an old version.
624873 DTM and Java are not option licenses any longer. But the "Note" for the option still exist in Sys Admin Guide 15.5.
624879 The example of SQL is not written to Example7 of isql of an ASE15.5 utility guide.
624923 Reorg rebuild or AMC may get into infinite loop that prints message Error: 8203, Severity: 26, State: 18 when concurrently run with selects.
624938 alternative greedy algo takes too long to complete in parallelism mode
624979 Performance drop with sp_helprotect on databases with large syscolumns tables.
624996 QPTune encounters premature end of file error when there is a different version of xercesImpl.jar released under $SYBASE_ASE/lib directory which might cause compatibility problems with QPTune. So we updated the classpath for running QPTune command to search xercesImpl.jar only under QPTune's own lib directory.
625009 upgrade does not detect and fix id column for external proxy file system access
625010 A feature request for alter table where error 14127 would be raised if necessary during the initial

phases of the operation.

625116 There is a typing error in the online documentation in the section describing the procedure sp_chgattribute for ASE 15.0 and upward.

In Example 11, the object name has been ommited from the command syntax. The first parameter after the stored procedure name has been omitted. This should read:

Example 11

Switches the deallocation for text and image space on using dealloc_first_txtpg:

sp_chgattribute "mytable","dealloc_first_txtpg", 1

To switch the feature off:

sp_chgattribute "mytable","dealloc_first_txtpg", 0

625133 With UTF-8 charset charindex, str_replace maybe give wrong result for space and , on non binary sortorder.
625144 Sometimes the bind cache operation can raise an error 834 at an instance, when

one of the other instances crashes.

625146 ASE CE setup with multiple buffer pools and multiple cache configured may hit timeslice with lock_multiple_physical function in call stack.
625178 feat req: Incorporate Unix groups into user authentication - Kerberos
625200 The dump and load operation initiated by specific ASE version and involving database devices with directio or dsync property may fail with error "Option 'iomode' is not valid" when Backup Server does not support 'iomode' option.
625217 UPDATE STATISTICS command on a proxy table writes the wrong page count for a row having indid 0

or 1 into systabstats system table if the ASE page size is more than 2K.

625226 ASE mis-calculates the used data page count of a proxy table retrieved from systabstats and puts it in memory if the proxy table is an APL table with a clustered index.
625298 Add diagnostics for error 707, state 10 retcode=-10
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.
625365 Internal only. Implement new stored procedure feature in Bharani to report status of external passwords and hidden text protected by service key.
625383 Server build failed using srvbuildres if the resource file including below items:

sqlsrv.avail_physical_memory: PUT_THE_AVAILABLE_PHYSICAL_MEMORY_FOR_ASE_IN_OPTIMIZATION

sqlsrv.avail_cpu_num: PUT_THE_AVAILABLE_NUMBER_CPU_FOR_ASE_IN_OPTIMIZATION.

625392 Feature Request for ASE to support Native hierarchical XML publication.
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.
625429 To support CIO on AIX for ASE
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.
625627 When a 32-bit release is installed on a 64-bit Unix system, Sybase Central launch script doesn't launch Sybase Central. The workaround is to re-define SYBASE_JRE6 to point to SYBASE_JRE6_32.
625660 ASE 15.5 Cluster Edition may raise error 820 in rare conditions, when multiple tasks are

actively inserting and modifying data.

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.

625780 Oam recount thread during failover recovery performance is very slow.
625796 FEATURE REQUEST: ability to monitor physical i/o by virtual page
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.

626273 XPserver: Include files to build Extended Procedure sample xp_echo are missing from ASE 15.5 GA release.
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.

626449 Error: 605 may be seen in the error log accompanied by a read failure

under a scenario whereby a rollback has been performed on an insert via an insert trigger

and a further insert..select then references a text column from the inserted logical table.

It is not supported to reference text (or other LOB off-row storage) datatype columns in

the inserted\logical tables used by a trigger.

inserttext() will be seen in the stack trace.

From 15.0.3 ESD#4, we will raise error 2116 and prevent the trigger from being created.

626458 When sybase NULL semantics are enabled i.e. set ansinull off (which is the default)

then there is a possibility of a wrong answer when a DISTINCT, ORDER BY, or GROUP BY is

used in the query with = NULL .... or an equi-sarg like = @v1.

The behavior is as if ansinull is on, which would eliminate NULLs.

626464 the doc communicates that one could send all 14 (7 pairs) of arguments at one time ... now granted the sp_lmconfig then executes without error but only the first 2 (pair) of parameters / arguments were used to change anything .

the following syntax is incorrect ...

sp_lmconfig

[ 'edition' [, edition_type ]]

[ , 'license type' [ , license_type_name ]]

[ , 'smtp host' [ , smtp_host_name ]]

[ , 'smtp port' [ , smtp_port_number ]]

[ , 'email sender' [ , sender_email_address ]]

[ , 'email recipients' [ , email_recipients ]]]

[ , 'email severity' [ , email_severity ]]

the following syntax is correct ...

sp_lmconfig

[

[ 'edition' [, edition_type ]] |

[ 'license type' [, license_type_name ]] |

[ 'smtp host' [, smtp_host_name ]] |

[ 'smtp port' [, smtp_port_number ]] |

[ 'email sender' [, sender_email_address ]] |

[ 'email recipients' [, email_recipients ]]] |

[ 'email severity' [, email_severity ]]

]

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. The current fix besides addressing

that performance issue it ensures that a scanner of the log is able

to recognize a stale log page and refresh it.

626534 A 7928 error, "Index <idx_name> is not consistent; found <num1> leaf rows but <num2> data rows.", may be reported when running DBCC CHECKTABLE with bottom_up option on a non-empty dol table having one or more indexes.
626618 extend 'order by' clause functionality for 'group by' -specify columns by their IDs (1, 2, 3, ...)
626619 For the system that is heavily use local temp DBs, performance degradation may be noticed for the time being, and long lock hash chains may showed up in "lockhash" output for table locks.
626623 REORG: Access to table while REORG REBUILD is running
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.
626711 There will be exception stack trace when NTLM is used for authentication in 15.0.3ESD#2 on Windows platform.
626744 Bigdatetime/Bigtime types are not disabled under compatibility mode under some circumstances.
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
626839 ASE on hppa64 platform can hit SIGBUS in poll_using_memory function when we do disk init on raw devices.
626890 Per page compaction for DOL with fixed length rows is enabled for REORG RECLAIM_SPACE
626897 On a server that has statement cache enabled, executing a very large SQL query may cause signal 11 and a stack trace starting in the function sqx__do_transform. The problem can be avoided if statement cache is disabled before executing the query.
626918 Heap memory growth is observed when a readtext or writetext command on a textpointer pointing

to a proxy column is executed repeatedly.

627065 ASE goes into grace when local host properties has LT=OT
627074 DBISQL cancel button not effective in canceling executing query.
627103 Login performance degrade when there are a large number of multiple simultaneous connections that use a single or a small pool of Syslogins login credentials.
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

627161 In ASE cluster edition, server may hang after seeing error 8243 when doing "alter table unpartition" on table created for load.
627166 Customer modified the standard resource file (XML Schema Model language )

"xsd.xsl" by adding customized Property tab page (e.g. for Element in XSM).

With the new tab page, it includes the original NAME property in Element entity.

It is discovered that modifying the NAME property, the corresponding CODE property will not be changed together as the default General tab page.

627201 When allocating large shared memory segments on a Red Hat 5.4 system, which also has one or more ramdisk mounted, it may take a very long time for Linux to return the shared memory to the ASE server.
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.

627249 The rowcount reported in sp_spaceused does not match with the actual row count.
627447 Add SMP or SDC to the ICU tools version strings to distinguish the two different binaries.
627651 Cluster may hang if a complex failure occurs when a node is shutdown and then killed.
627652 Union all queries with a distinct select query on one or more

sides of the UNION ALL may generate a SEGV during the cloning of the hash

operator's input aligned data row. This will occur if there is

a join between projected columns of differing lengths in at least one

of the UNION ALLs select statements.

627675 The WITH DBID = <N> option to the CREATE DATABASE command does not work in ASE 15.5.
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.
627751 reorg rebuild on a single partition on a partitioned table with local indexes
627881 Document Enhancement: Java performance can be improved on single-cpu machines by reducing the sp_configure "runnable process search count" setting. This results in ASE voluntarily yielding the CPU more often, which allows the OS to schedule the JVM sooner and more frequently.
627901 In rare circumstances, executing stored procedure including FUNCTION may raise

error 325, Level 18, State 1.

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.
627937 When character set conversion is active, embedded null bytes followed by invalid characters may produce a TDS protocol error instead of expected error message 2403 or 2431.
627992 ASE 15.5 SYBOOKS will not install on a MAC JRE not found error
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.

628012 Include EBF numbers in auditinit version string.
628072 Currently there is a limitation with SOAP 1.2 support for certain web services.

This is due to the current Axis 1.3 implementation within ASE Web Services.

You may receive:-

Msg 15200, Level 20, State 0:

Server 'ws', Line 1:

No web methods mapped to proxy tables for the WSDL URI

on running sp_webservices 'add' against the wsdl

628077 Request to document the behaviour covered under IB entry 11371840.

Since 11.9.2, to facilitate concurrency we raise a 2601 error on insert into a unique index

on a datarows locking table if that key already exists (whether committed or uncommitted).

There is no risk to data integrity.

The request is really to document this from the perspective of the relaxation of the

isolation level for this scenario.

628124 In ASE Cluster Edition, server may hang under rare circumstances while running utilities like ALTER TABLE.
628174 Job Scheduler may be aborted after getting spurious state from the JS Agent when number of jobs running simultaneously is equal to value of 'job scheduler tasks'.
628284 In a rare scenario it may happen that requested lock was granted , but the corresponding lock request is still sleeping.
628292 OPTDIAG: Input mode raises datatype mismatch message for numeric column
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.

628343 XP Server may log the message "16331 - Recursive Calls to srv__seterr() in spid: nnn. Thread terminated." in the XP error log.
628454 Feature request for a lock timeout option for dbcc checkverify.
628508 Windows Only: Monserver boot failed when the ASE installation path include space character.
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

628557 Different results may be obtained for a query that contains GROUP BY when using compatibility_mode.
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
628597 In a shared disk cluster system, poor performance of failover recovery can result from an unnecessarily large number of disk writes that are performed when recalaculating OAM counts at the end of the failover recovery redo pass.
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.

628837 CPU utilization becomes 100% when procedure cache utilization is almost full.

After this fix, boot time trace flag 753 is obsolete and large allocation auto-tune

in memory manager is turned off by default. Use boot time trace flag 758 to turn on

when necessary.

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.

628853 update statistics on partitioned tables may be slower in 15.0.3 ESD #3 than previous ESDs.
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.
628878 customer attempts query with 57 count(distinct ... ) & group by ... error exceed 46 work table limit

Unable to allocate work table for processing group by or distinct clause during query optimization. Maximum limit (46) of work tables is exceeded. Simplify the query and retry.

the workaround is relatively complicated ...

628880 Provide database option so that only replication would be allowed to update it. ISUG replication enhancement 3258.
628916 ASE running on windows may fail to start if Performance registry subkey is not present
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.

629046 OMNI: proxy table as a RPC call get Msg 207 cause is the quoted_identifier this is

on for the CIS connection wish mean double quotes is not allowed.

629134 Row delimiter of generated Load Script is incorrect.

Environment:

Sybase ETL 4.9

Windows 2003 Server

Problem Description:

Row delimiter of generated Load Script is incorrect.

Description of the problem:

Customer tried to use IQ Loader File via Load Table component, and they set 2 properties like following.

- Line Delimiter of Text Source Definition : CRLF

- Row Delimiter of Properties : CRLF

Next, run "Generate Load Script" from IQ Loader File via Load Table comtext menu.

And Pushed Load Script Button.

Then generated load script is....

--------------------------------

LOAD TABLE DBA.test3

(

[col1] ',',

[col2] 0x0d

,FILLER(1)

)

FROM 'D:/work/crlf_test2.txt'

QUOTES OFF

ESCAPES OFF

BYTE ORDER NATIVE

BLOCK SIZE 10000

WORD SKIP 0

--------------------------------

"0x0d / FILLER(1)" was generated insted of CRLF (0x0d0a).

If "0x0d" is included in source data, above load script doesn't work correctly.

f for IQ performance, I think that using "row delimited by" load table command gets more better performance, like following.

--------------------------------

LOAD TABLE DBA.test3

(

[col1] ',',

[col2] 0x0d

)

FROM 'D:/work/crlf_test2.txt'

Row delimited by '\n' <-----

QUOTES OFF

ESCAPES OFF

BYTE ORDER NATIVE

BLOCK SIZE 10000

WORD SKIP 0

--------------------------------

Because if use "row delimited by" statement, IQ tries to load table as multithread.

Results of my test, using "row delimited by" situation is very good performance than original generated load script.

629156 xmlextract is slower on the Windows 32 bites platform and other platforms.
629164 Fix 832 error when reorg rebuild a lot of index partitions.
629301 Sometimes the PCM handler raises an error 941 complaining about illegal database context operation.
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.
629423 A delete statement which joins tables together, can result in a stack trace on a server configured with an optimisation goal of allrows_mixed or allrows_dss.
629430 Poor performance when proxy table is mapped to remote procedure via CIS on ASE15.
629471 Instrumentation to catch the cause of SIG11 seen inside function lock__mmaster_processque at FNA. Traceflag 16899 needs to be switched on to enabled this instrumentation.
629475 A 225 error, "Cannot run query--referenced object (name NAME NOT

RECOVERABLE) dropped during query optimization." may be reported

when running a SELECT INTO from a view that had to be internally

recreated from its source text, for example, because the database

was upgraded from a previous version.

629579 Msg 3606, Level 16, State 0:

Server '<SERVER>', Procedure 'sp_sysmon_netio', Line 260:

Arithmetic overflow occurred.

May be seen when running sp_sysmon.

It is caused by a sum aggregation on an int column (that is required to be int to be in

line with system tables) exceeding max int.

629634 Backup servers are not roundrobin'd in a cluster after an error at one of the backupservers.
629642 When running a large number of dynamic sql statements, it could raise 8210 error with stacktrace followed by 2012 or 1780 or both 2012 and 1780 errors.
629833 ASE xmlservice as xmlextract() xmltest() is slow compare to other vendors.
629846 Executing CIS queries concurrently accessing external files on a multi-engine server may

crash the server with signal 10 (SIGBUS).

630051 The query plan for stored procedures that do not contain any table references is not recompiled when the caller has a different ANSINULL setting than what was used to compile the existing plan.
630052 In Japanese locale, the "Configure PCI" window of syconfig is not localized.
630107 Feature request to have preupgrade generate a script of executable sql commands for all required configuration changes.
630202 In rare circumstances, stale log pages might be cached after node failure in a shared

disk cluster such that two or more surviving nodes are left and failover recovery was

needed for a multi-database transaction that was found in a prepared state. If the

database is replicated, it is possible that the stale log pages will result in errors

during replication.

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.
630377 If user creates a table with round robin partition or hash partition, and the user does not specify partition name, DDLGen can not generate a system generated partition name.
630425 In rare circumstances, the message "kernel timeslice -1001, current process infected at

0x<value>" together with a stack trace which includes the modules 'rep_agent_thread',

'ra_process_lr', 'ra_trace', 'scerrlog' maybe be reported in the errorlog when RepAgent

thread tracing is active.

630510 Poor performance on minimal stored procedures
631049 Implement creating tables with compressed LOB columns
631077 Feature request covering the addition of parameters for srvbuild\syconfig to enable

specification of separate log\data devices for tempdb.

Currently we only have these parameters available:-

sqlsrv.tempdb_device_physical_name

sqlsrv.tempdb_device_size

631082 Request to document IATEMPDIR environment variable that can be used to specify the

temporary directory used by InstallShield (equivalent to setting -is:tempdir on the

command line for the installer).

631130 sqlupgrade finds deprecated functions but stored procedure name absent in msg

$SYBASE/ASE-15_0/init/logs>

find . -name "*" | xargs grep depre

...

./sqlupgrade0601.001: Stored Procedure '' uses deprecated builtin functions as:

...

631133 The stored procedure name may not be displayed correctly in message, "Stored Procedure <stored proc name> uses deprecated builtin functions as", when running the preupgrade tool.
631156 CIS optimizer ignores sending index hint to the remote server if the proxy table is in a subquery.
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

631379 Latest PC Client for the ASE 15.5 ESD#1 release.
631382 Possible 712 error and stack trace when using reserve_identity for many reservations over a long lived session.
631398 15.5 "null" function adds spaces to the result set
631416 Semi join costing estimates are inaccurate (these are the flatten correlated EXISTS subqueries, or some multi-table delete queries, or some cases of DISTINCT queries). The semi join row estimate should not be greater than the outer subplan estimate. Also some cases of semi-join underestimates are corrected in cases where the inner join estimate is fairly selective already. Use optcriteria cr631416 to turn on this change, or trace flag 16918, or use optlevel ase_current
631485 The request is to document SuSE 9 bug 165140 in our Linux install guides for ASE 15.0.x.

It is believed to be fixed in kernel version 2.6.5-7.322

Without the fix:-

kernel BUG at fs/aio.c:733!

may be seen in the messages file during an async i/o operation.

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'.

631695 It is possible to define an in-memory or other low durability database as a scratch database for an archive database.
631758 The value1 and value2 fields in sp_dbcc_run_differentialreport have insufficent length, thus causes conversion error.
631769 In all the 15.5 Installation guides under 'Installing Server Components', the link for

'Creating a Response File' actually points to the PC Client 'Creating a Response File' page

not the server page, as such it contains references to setupConsole as oppose to setup.bin

631782 Feature request for Try / Catch error handling in ASE TSQL.
631785 Feature request for DIFFERENCE / EXCEPT / INTERSECT operators
631887 Need to stop sub-ordinate transactions being created in master database as they may prevent recover in the event of a failure between the commit prepare and the final commit.
631903 A 3172 error, "Adaptive Server cannot load this dump because its version is incompatible with the version of this server..." is reported when loading a future ASE 155* version in a ASE 155 server.
631913 Writetext give you error 207 this is a race condition.
631915 A signal 11 followed by a stacktrace involving CgpSort::_cgpInit() may occur when a VIEW or derived table with a non-correlated scalar aggregate subquery expression SELECT column is participating in some equijoin over the VIEW column.
631963 Execution of DBCC CHECKCATALOG against a database in which a row for a trigger exists in sysobjects and references a table for which there is no corresponding row in sysobjects causes a signal 10 stack trace after errors 2513, 15018 and 15010.

We may see routines endscan() and trigger__target_confirm() on the stack trace.

632021 sp_companion "<servername>", do_advisory, "allow password downgrade" throws a usage error.
632023 Under very specific circumstances a query that has been cached in the statement cache appears to be cached a second time according to the output of showplan, but the query has actually reused a cached plan.
632041 Under certain circumstances a stored procedure that contains a query which mixes ANSI and Transact-SQL outer joins does not report an error upon creation or execution as expected. If the database containing the procedure is dumped and reloaded. The first execution of that procedure may then report error 11041.
632055 When large Java classes using nested methods causing deep recursions are run concurrently

by multiple sessions, ASE may run into a situation where the signature cache of the

PCI integrated JavaVM gets corrupted causing the report of inconsistent error messages.

In some cases this may result in the JVM aborting or ASE shutting down itself.

632076 Executing ALTER TABLE with a MODIFY clause together with a clause for addition of a table level constraint may result in signal 11 followed by a stacktrace involving the module 'palt__build_insert_forusertable'.
632164 Feature request to add message indicating broken sysroles\syssrvroles mappings

during an online database which contains sysroles.id equal to -1

(due to a prior load at some point that didn't have the server roles in syssrvroles.)

632207 In some circumstances, query on MDA table monCachedObject may affect ASE system performance.
632244 Create table hits error 1791 if 'not compressed' is specified on timestamp column.
632285 The replication of text/image columns may not work correctly in case of bulk copy program.
632330 Need to migrate option "builtin_date_strings" for cluster edition.
632360 sp_spaceusage may fail with error 247 arithmetic overflow if systabstats contains inconsistent allocation values for the table.
632456 Sybase Central 6.0.0.4765 display of indexes index_keys lacks delimiters between each column involved in the index keys.

e.g. if you try to distinguish what columns are involved in the index keys from the

index list in Sybase Central then when there are multiple columns involved in the

index, they are all concatinated into one long meaningless name ... ??? ...

for example there is the index ... nc2syspartitions on ... master.dbo.syspartions

with index_keys of ... id, indid, name -- but in Sybase Central this information is displayed as idindidname ... ??? ...

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.

632510 Using a resource file to run sybmigrate allows the user to specify queries to produce lists of objects to migrate.

When this method is used and one of the queries that has been included in the resource file returns no rows,

Migration tool will report an error and the migration process stops.

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.
632532 feature request: unique index on the sysaudits tables
632556 Trace flag 16919 was added to turn off the optcriteria conserve_tempdb_space for all sessions and not require a login trigger. This trace flag will turn off conserve_tempdb_space whether or not this optcriteria is set.
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.

632617 A new feature to enable doneinproc tokens to be turned off at session level.
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.

632695 Error 603 might be seen if server runs out of system session descriptors.
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.

632800 At first dbcc checkstorage may report temporary inconsistencies in a target database loaded a pre-15.0 database dump.

These inconsistencies should not be reported and may disappear on the second attempt of dbcc checkstorage.

632983 Extended column aggregate views (sybase extension which allows

columns in the select list of a GROUP BY aggregate

which are not in the GROUP BY list) which in turn

reference union views can lead to a signal 11 in

markColForStat or ind_get_ides.

632999 During an upgrade of ASE 15.0.2 ESD<X> to ASE 15.5, you may receive

a dbisql dialogue box stating:-

"The runtime environment could not be found in ."

This is due to a call made by the installer to terminate the dbisql fast-launcher.

The error message is raised as it runs the 15.0.2 DBISQL (which is version

633043 readpast having problems getting nextid in 15.x
633074 Duplicate of CR 610496
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.
633149 Using DDLGen to create ddl for all the objects in the database such as:

ddlgen -Usa -Sservername -Ppw -Ddbname -TDB

DDLGen generates the following info for system view: sysquerymetrics

"-- Cannot Generate DDL for system view(s)."

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.
633295 Feature request to support single sign-on with ASE 64bit on Winx64.
633447 Using ASE 15.0.2 or 15.0.3, for all platform, when RepAgent connect to RepServer (the first time), following message occurs:

00:00000:00013:2010/06/25 16:31:42.39 server Started Rep Agent on database, 'prim' (dbid = 4).

Unable to retrieve localized message for ID 1

This message is reported even nor SSL nor LDAP is used.

Even this message is reported, RepAgent thread connection to RepServer succeed and replication works as expected.

This message is raised by CSI layer.

CSI layer is not able to find its localized file to report a warning.

The message that should be report is the following:

00:00000:00011:2010/06/25 16:28:19.20 server Started Rep Agent on database, 'prim' (dbid = 4).

Sybase CSI Error Message: OpenSSL provider instances cannot be loaded concurrently with multiple, distinct, system policies due to limitations within OpenSSL.

CSI layer can't find its localized files because localized files are installed in directory "$SYBASE/locales/unicode/csi/en_us"

instead of "$SYBASE/locales/unicode/csi/en_US" (note the "US" in upper case)

633522 des_bind is still broken for DOL tables. Error 8242 on reorg compact
633656 sysam status -a not showing all ASE servers that checked out ASE_CORE licenses
633698 In shared disk cluster system, LOAD TRAN might report a 692 error and a stack trace due to improper sequencing of events between Adaptive Server and Backup Server while accessing database devices.
633776 sp_options shows the incorrect default setting for "optimizer level", it should be ase_default instead of ase_current
633788 On ASE CE for platform IBM AIX, resolved issue of multi-path access to SAN not working when devices were I/O fenced.
633797 semantically partitioned large table hits deadlocks on sysstatistics when create index

concurrently

633882 If a table is altered to be partitioned and then sp_chgattribute is executed immediately

after to modify the 'plldegree', then the attribute change may be lost the next time the

housekeeper flushes the in-memory statistics.

633897 Signal 11 at memset when ASE fails to allocate free fragment pool.
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.

634054 Under certain conditions a system stored procedure querying a system view may return unexpected results as a result of compilation of that procedure.
634144 Support querying on the compressed LOB columns in ase 15.6
634162 Feature request to add 4 new messages equivalent to the messages currently logged

in the ASE errorlog for reorg rebuild <tablename>.

These should cover:-

reorg rebuild <table> <index>

&

reorg rebuild <table> <index> partition <index_partitionname>

Which would generate:-

Beginning REORG REBUILD of index '%.*s' on table '%.*s'.

REORG REBUILD of index '%.*s' on table '%.*s' completed.

&

Beginning REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s'.

REORG REBUILD of partition '%.*s' of index '%.*s' on table '%.*s' completed.

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.

634321 The values of the monStatementCache table TotalSizeKB and UsedSizeKB columns are incorrect on servers using page size greater than 2K.
634454 investigate: self-deadlocks and causing 12311 error when running online index reorg on 12.5.4 esd #10
634491 If more than one -T parameters are used in ddlgen, e.g,

ddlgen -Usa -S... -P... -D... -TD -TI -TLK -TKC -TR -TRI -TSGM -TTR -TU -TV -N% ,

ddlgen does not print a syntax error.

634536 In some circumstances the message "current process infected with 10"

in the module 'rtrim_unichar' or 'lower_unichar' maybe be reported

in the error log when it is executed a query joining two or more

tables and using the functions RTRIM() or LOWER() on a column of

datatype UNICHAR or UNIVARCHAR.

634619 Transaction block it self when DDL involve Constraint.
634635 Customer needs to present a client certificate to consumer https site. He is unable to give direct webservices to use this certificate and integrate it into a keystore for usage. Gets error 403 when trying to access the https location because of no authentication.
634666 doc bug: tibjms.jar file is different in newer versions
634679 If an additional language has been installed to the ASE, sp_passwordpolicy "list" incorrectly shows 2 rows.
634692 If an additional language has been installed to the ASE, sp_getmessage may show a conversion failure message or a localized message when an error occurs

even if you connect to the ASE with us_english language.

634694 If an additional language has been installed to the ASE, sp_helpconfig may show a conversion failure message or a localized message even if you connect to the ASE with us_english language.
634722 Signal 10 and/or signal 11 may occur in CtlibRemoteAccess::_connectionState(sdes**) for a session which has earlier used an cursor.
634735 When using SQL statement replication, Replication Agent may

shutdown reporting the error 9202, Severity 20, State 0,

if the replicated table has a trigger and the SQL DML

within the trigger attempts to use SQL Statement

replication as well.

634759 Under certain circumstances executing a procedure when using the 憌ith recompile� clause can cause a stack trace if that procedure references a view which in turn has an instead of trigger and the view and trigger have been dropped and recreated between invocations of the procedure.
634801 CIS query fails with error ORDER BY error 169 in 1503 and 155
634808 Under some rare cases, if a query involving processing an IN list with an expression, it could stacktrace during query plan compile time.
634861 Transaction block with a rang lock when DDL involve Constraint.
634875 ASE 15.5 running on Windows can抰 be shutdown using the Windows Services Manager. Stack trace is seen in error log referring to storage access violation in syb_polite_shutdown
634947 Under certain circumstance, dropping a global database within a multi-node cluster may fail due to CIPC message contention.
634993 Lookup of the inetaddr attribute in the UDP response packet was modified to lookup explicitly (based on attribute name) rather than positionally.
635012 Add a MDA table for dynamic SQL LWPs.
635017 Add a function as lwp_number_count(spid) to report number of dynamic SQL LWPs for this spid.
635018 Add a function as show_cached_lwp_text() to report the SQL for dynamic SQL LWPs

a show_cached_text() for the LWPs.

635038 Connection to a case insensitive server from ct-lib using -JUTF8 (specifically upper-case

UTF8) could lead to a failed jdbc connection to the same case-insensitive server.

This will be seen at the client-side:-

java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

SQLState: JZ0IB

Message: JZ0IB: The server's default charset of UTF8 does not map to an encoding that is available in the client Java environment. Because jConnect will not be able to do client-side conversion, the connection is unusable and is being closed. Try using a later Java version, or try including your Ja

va installation's i18n.jar or charsets.jar file in the classpath.

Vendor: 0

SQLState: JZ006

Message: JZ006: Caught IOException: java.io.CharConversionException: java.io.UnsupportedEncodingException: UnsupportedCharset

Vendor: 0

635047 Need to warn against using port scanners in ASE installations in our documentation.
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.
635150 ASE 15.5 CE with wrong version of backup server cause the load database to hange

this is a request to print a error message.

635154 Error 511: "Attempt to update or insert row failed because resultant row of size

<X> bytes is larger than the maximum size (<Y> bytes) allowed for this table"

may be seen during 'optdiag binary statistics' output when running under compatibility_mode.

635155 Feature request: Delay select into creating open transaction until it start populating data into a temp table
635198 New feature request to verify sysattributes passwordd security entries with dbcc checkcatalog.
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.

635329 Login overrides specified through sp_addlogin, sp_modifylogin may fail with error 17932 if sp_setpsexe

was invoked in the current session or adhoc rows were inserted in master.dbo.sysattributes with object_type = "PS".

635362 Increase the default size of CIPC pools.
635364 Document sp_post_xpload with force implemented from ASE1254ESD10
635375 sp_checkreswords always prints out messages in English even if an additional language has been installed to the ASE.
635398 wants to link attributes in complex elements (and elements) in an XML Model to other attributes in complex elements of another XML Model with extended dependancies. Only the complex elements and elements but not their attributes are available for linking (Influenced Object).
635453 sp_post_xpload without force option will cause error605(reindex)
635454 App tracing: File generated by <set tracefile on> is limited to 2GB
635483 The monitor table monCachedStatement may contain wrong data.
635507 Error 9289 , RAT reports inconsistent data in the transaction log.
635620 ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject().

This can occur at server startup or at user authentication when attempting to

obtain the lock which is already held.

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.
635663 Executing parallel SELECT on syscomments with traceflag 15331 enabled may result in a 1289 error followed by a stacktrace involving the modules 'lock__ins_logical' and 'lock_logical'.
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.

635950 Each node in private installation doesn't need its own $SYBASE on CFS from ASE1503CE onwards
635969 In a multi-node cluster, messages like "Object Coherency Block Information: ocb=400385318, lockhandle=1ab1da5a8, version={high=0, pad=0, low=2},.." and "ocm_lock: task going to sleep as ocm__lock_object() returned OCM_ERR_DEADLOCK and bast is not yet received" would appear in the errorlog and transactional activity might be frozen in one or more instances.
636014 Update query never completes on 15.0.3 when it was 4 minutes to complete on 12.5.4.

Once it has been run with the abstract plan from 12.5.4, it completes, but as soon as you update statistics again, it is broken.

636065 On IPv6 enabled machine, Job Scheduler task can not connect to jsagent if interfaces file entry for JSAGENT has IPv4 address.
636236 A 14108 error, "Could not find partition descriptor for objid <objid>, indid <indid>, ptnid <ptnid> in dbid <dbid>." may be reported during SELECT INTO a LOB column from a source table with a non-LOB column.
636238 On ASE SDC, Job Scheduler agent may fail to boot with following error message in the error log.

" Job Scheduler Agent entry for host '<host_name>' not found. " when the machine name(host_name)

for JSAGENT entry in the interface file is not same as name returned by `uname -a`.

636277 Interrupting the load of a 12.x dump on a 15.x server may lead to 605 errors on a subsequent attempt to load the database.
636293 CROSS JOIN is unsupported in ASE.
636306 Infected with 11 occurs with GAGenericArray::_GaGetPtr at the top of the stack.
636334 The version string for Backup Server binaries is directed to STDERR instead of STDOUT.
636431 feature request: expire logins after x number of days with no password expiration/renewal possible.
636439 On AIX, a warning message "iof_reserve_device: fence device %s is already reserved in type 5" is always displayed.
636454 feature request: uncheck preupgrade in sqlupgrade and sqlupgraderes
636592 select DISTINCT queries (or queries referencing DISTINCT views or derived tables) may choose a suboptimial plan, when a D! (i.e. opportunistic partial distinctness) property is found at the top of the unenforced subplan below the EMIT. The fix can be enabled by optcriteria cr636592 or optlevel ase155esd3.
636677 Improve efficiency of spinlocks on the AIX platforms.
636684 sp_unbindexeclass fails with error 512 when more than one row qualify for the delete operation.
636706 The "directio on" attribute of a database device may be lost mistakenly after having

unmounted and mounted a database that is using this device.

636786 The execution of SP_RENAME and SP_CONFIGURE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is

no open transaction.

636791 Timestamps will be recorded when each of the checks begins in the preupgrade process.
636795 The new FR would like to have a output file to save the preupgrade output.
636798 The FR would be possible to let sqlupgraderes use multiple engines.
636806 When Java methods that request lots of memory for their execution are run concurrently

by multiple sessions, ASE may run into a situation where the PCI integrated JavaVM aborts

after having reported "OutOfMemory" error messages. In some cases this may result in ASE

shutting down itself.

636825 If "enable ssl" is configured and there is no ssl entry in the interfaces file when

starting an ASE, sp_listener "start","ssltcp:<host>:<port>:'CN=<common name>'","<engine>"

will fail, with common name mismatch error.

636898 On POWER 7 AIX systems with 4 SMT threads enabled, ASE requests twice as many licenses as it should.
636958 For Internal Use Only: Address review comments of CR#636430
637002 SySAM incorrectly identifies sun4v processor systems as LDOMs and prevents Small Business Edition from running unless a SYBASE_SAM_CAPACITY environment variable is specified.
637005 Documentation needs clarifying with respect to Sybase NULLs and ANSI NULLs
637007 Add a new MDA table monLockTimeout to track info when occurence of lock manager time out
637012 Upgrading to 15.0.3 with bound system tables in model causes 696 errors
637088 Update sp_drv_typeinfo in installmaster script
637114 For Internal Use Only(K21 stab):sig11 in listener_checkagain on solaris
637172 A SELECT query running at transaction isolation level 1 may sometimes not exhibit

expected blocking behaviour on a row that is inserted by an uncommitted transaction

if the inserted row is replacing a row deleted by the same transaction.

637193 In rare circumstances the error 706/20/3 may be raised when executing a query

related to sysobjects with statistics on ASE 15.5

637248 Using compatibility mode results in a marginal performance drop for queries involving worktables.
637262 Adaptive Server Cluster Edition may rarely hit signal 11 error with stacktrace containing cmcc_bufsearch(), under high load of concurrent INSERT and SELECT statements issued on multiple instances of the cluster.
637307 Using the "with verify=full" option for a database causes warning messages in the backup server log relating to pages 24-31. These messages are due to the system table that uses these pages having a special format. They can be safely ignored.
637317 Added ProgramName, HostName, ClientName, ClientHostName, ClientApplName columns to monProcess, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessLookup, Application, HostName, ProgramName, ClientName, ClientHostName, ClientApplName columns to monProcessActivity, HeldProgramName, HeldClientName, HeldClientHostName, HeldClientApplName, WaitApplName, WaitHostName, WaitProgramName, WaitClientName, WaitClientHostName, WaitClientApplName columns to monDeadLock.
637395 In the Cluster Edition, when monitoring is enabled, the MaxIOServiceTime in the MDA table monOpenPartitionActivity may sometimes have values less than the AvgIOServiceTime.
637468 Error 247 Dynamic prepare statement fails with Arithmetic overflow from Jconnect
637538 Queries with non-correlated subqueries that references a grouped aggregated view in multiple places in the query will lead to a parallel plan not created.
637589 Signal 11 in function ScalarNormalizing() (amongst others) may be seen in the error log

and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>.

637600 Signal 11 stacktrace with error msg 416 may be seen in the error log and the spid terminated when attempting to insert <table> (<column-list>)..select <col> from <table2> union/union all <select> in a procedure where <table> is created inside the procedure and <table> contains non-nullable columns that are not in <column-list>.
637651 Update statistics with/without consumers different histograms steps
637698 A 9543 error, "Parameter passed to the builtin 'lockscheme' has an invalid type.", may be encountered when the lockschme function is used with id and dbid parameters from master..sysprocesses.
637723 New Feature - Server wide events are displayed on Overview screen of ASEMAP monitoring view
637729 When running non-English regional settings it is possible for the

CreationDate\LastExecution\NextExecution dates to display a 'null' when viewing

'Scheduled Jobs' (requires Job Scheduler) in Sybase Central 4.3 through to 6.0.

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().

637872 add the hostname and program_name from sysprocesses to the sybsecurity functionality so it can be archived together.
637904 sp_plan_dbccdb has wildly LOW recommendations for the dbccdb databases may cause

dbccdb log fills and when cancel out of dbcc checkstorage may cause sigsegv and stackoverflow.

637993 In some ASE workloads, proc_spin shows up as having high contention. This fix could decrease the contention in some of these workloads.
638062 sp_dboption with no parameter doesn't display full descriptions of the database options if the ASE's language is japanese.
638068 On Windows systems when Adaptive Server is running

with configuration options "enable literal autoparam"

and "statement cache" active in some circumstances the

execution of a query containing a big literal binary

value may be aborted and the message "SQL Server system

exception (0xc0000005) generated by a storage access

violation" together with a stack trace which includes

the modules 'memcpy' and 'mkconst_desc' may be reported

in the error log.

638098 On windows, Database Emulator doesn't receive QaTrflag_status bitmap.
638140 Converting char to int returns 249 error in 15.x
638169 A configuration option 'enable deferred parallel' has been added to enable/disable

the deferred parallel optimization mechanism. The default value is 0 (disabled);

a value of 1 enables this method.

Deferred Parallel Optimization is an alternative method for costing and selecting

parallel query plans. When enabled, the best serial plan is chosen using the

serial optimizer; this plan is then converted to a parallel plan, normally

maintaining the same join order and physical operators as the serial plan.

This method provides a parallel plan using less optimization time, while reducing

the risk that a parallel plan will be chosen which is inferior to the best serial

plan. With the full (default) parallel optimization mechanism, an inferior plan

may be chosen due to optimizer time out, or due to limitations of parallel costing.

638183 Support LOB compression for UPDATE operations, including:

1) update with setting constant data

2) update with setting data from other columns

3) update with setting the column itself

638193 The replication of UPDATE query which is affecting some of the encrypted columns of a table may not work.
638194 Support DBCC check utilities for compressed LOB columns.
638212 Replication may fail while trying to insert duplicate rows on the target site when normal TEXT/IMAGE columns of a table are converted to encrypted columns.
638275 In CR 325947, we expanded out the "by other" information in sp_sysmon to include "by unpin".

However, "by Log Marker" is another line item that has no description in the docs anywhere.

638436 In a multi-node cluster, a shutdown with a timeout smaller than one hour could be sleeping for exactly one hour if any process in a remote node was sleeping and did not wake up to check if it had received an attention.
638447 Report all SQL processing errors during upgrades.
638454 ASE Bit datatype to support NULL or add boolean datatype to ASE so we support

this values "NULL, 0 ,1"

638488 A SELECT query after USE DBNAME in the same line may look up a previous cached statement in another database and raise 225 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."
638556 A 623 error, "Adaptive Server failed to retrieve a row via its RID in database '<dbname>'

because the target page is not a data page... pageno = 0 ..." may be reported during the

execution of LOAD TRANSACTION command using the WITH UNTIL_TIME option from a transcation

dump that was dumped using the WITH NO_TRUNCATE option.

638628 doc bug: add circumstance to 913 error in Troubleshooting Guide
638736 (Internal only) RAT: LTL enhancements for replication definition elimination.
638743 NumRows is not documented in sp_spaceusage
638779 A stack trace may occur for queries with long GROUP BY lists greater than 32 keys.
638786 Parallel activity on tables related with RI constraints may lead to deadlocks
638837 sp_spaceusage sets ExpRsvdPages and PctBloatRsvdPages to null when the reservepagegap being set to null
638838 Job Scheduler installTemplateXml.bat contains some syntax errors.
638843 Total Task Switches reported by Task management section in sysmon report is inconsistent with sum of individual contributions on each engine for both SMP and CE servers.
638972 referential_constraint_create_list_from_sql defines a list of foreign keys to migrate. If this parameter is set to <ALL_OBJECTS> then all foreign keys in the database will be migrated. If the parameter auto_select_dependent_objects is also set then any object that depends on the foreign key will be migrated.

When both referential_constraint_create_list_from_sql and table_create_list_from_sql are both set, both provide a list of objects to migrate. The list of foreign keys does NOT depend on the objects identified for migration by table_create_list_from_sql.

639001 If one of the input row's length for a hash join exceeds the server's

pagesize and the hash join resorts to a nested loops strategy, then

wrong results could be returned. The input row's lengths can be determined

by running with trace commandline flag 9529.

639030 In SDC, when configuration option 'CIPC regular message pool size' is configured not

enough, user may hit error 8211 when try to access the table from remote node.

639043 For multiple node cluster, when there is only one instance left in the cluster, dropping a global database may fail due to corresponding locks are not able to be reclaimed.
639045 Under some rare condition, Msg 913 might raise when pagesize() is used with other builtin functions or UDF functions in a query.
639046 Localization is supported by MDA table. New Language columns are added to monTables, monTableColumns, monWaitEventInfo and monWaitClassInfo. User can use the where clause to specify the language for a query.
639111 During quorum creation time, any "additional run parameters" specified in the cluster portion of the input file will be incorrectly stored as the secondary interconnect protocol, preventing the Adaptive Server instance from booting.
639158 Feature request for using of column alias in a WHERE, HAVING clause
639227 The message "Received the following error message from the Replication Server:

Msg 2056. Line 1, character 8290: Incorrect syntax with ' '" may be reported

in the error log as a result of uninitialized database id.

639234 In a multi-node cluster, a SIGSEGV can be seen in the function lock__wait during alter database operation. The stacktraces in the errorlog would have strings like lock__common(), lock_object() etc.
639254 Error 9996\12905\12323 may be seen after non-clustered index creation on dol table.

The conditions leading to this are data specific and rare.

This may only occur on a non-binary sort order server.

639296 When statement cache is on, a non-dbo user may access a dbo-owned table instead of

its own table when both tables are using same name and a previous access to the dbo

table was done.

639428 Feature request for a method to change table ownership.
639547 The LDAP login module was not including the roles read out of the LDAP server when mapping to uaf/scc roles (only the roles defined as login module options were included).
639557 With I/O fencing enabled AIX may encounter a timeslice if a lot of devices are used.
639568 If a high volume of connect/disconnects using client-side password encryption a SIGABRT

may occur with a stack trace with the following message:

"ks_falloc: Cannot allocate using ubfalloc"

639579 Wrong parameters passed to error message 886 in the code, leading to garbage values in output.
639652 Adaptive Server 15.5 ESD #3 Removing duplicate wait even 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.
639702 If the datachange builtin is used on sysobjects.name there is a possibility of a 706 error.
639802 Allow column alias (AS clause) in subquery SELECT list. But the alias is not useful and

can't be referenced in other parts of the query. This is only to avoid syntax error.

639811 Adaptive Server 15.0.3 Cluster Edition hits error 866, when a cache configured with 'Relaxed replacement scheme' is accessed heavily.
639813 Execution of stored procedure 'sp_renamedb' from read-only database results in a 3906 error, "Attempt to BEGIN TRANSACTION in database failed because database is READ ONLY." Message should reflect that "You must be in master in order to run stored procedure for read-only database."
639826 UNITEXT column values are not being translated correctly when loading a database dump that was taken on a Solaris system, into a database on a Linux system.
639852 When the option 'set merge_join' is turned on, a join query on a remote column with a

different sortorder from the local column may get a wrong result.

639877 Using the LIKE operator, ranges enclosed in square brackets containing embedded square brackets are not interpreted properly. Where '[x]' like '[[]x]' should evaluate to TRUE.
639969 A 530 message, "Attempt to insert NULL value into column <column_no> in work table (table id -<table_ID>); column does not allow NULLS. UPDATE fails." may be encountered when executing queries involving derived table and aggregation functions.
639976 Print procedure plan information from procedure cache
639977 Under specific circumstances involving an outer join to a view\derived table containing

an aggregate (or possible other virtual expression) and a further outer join may result

in a sub-optimal query plan.

640007 An optional third argument has been added to the charindex() builtin function. This argument can be used to give a starting position within the string-to-be-searched that is passed to charindex().
640009 A single asterisk (*) is allowed to be used as a non-EXISTS subquery

SELECT list if the subquery is selecting from a single table/view/derived table

with a single column. It will function as SELECTing the single column explicitly.

640014 Allow multiple SELECT items for EXISTS subquery SELECT list. The existence test function

stays the same. Each of the multiple items will be treated the same way as with a single SELECT item for the EXISTS subquery.

640221 Default/ specified log size may be incorrect when log is bound to a named cache
640224 An unexpected colon may get appended to the dump file names when using a large number of stripes with

Backup API library.

640259 sp_displayaudit output does not include tables that have a negative sysobjects.audflags value (which indicates auditing of encryption_key operations).
640317 When converting a very large unitext value into text where heap memory may run out,712 error will

be raised with sig11 from s_result_const_memfree->free__linkedcst->memfreeheap.

640329 In rare circumstances the message "current process infected with 11" in the module

'ptn_pdes_install' together with a stack trace which includes the modules 'dorecover'

and 'db__create_sysaltusages_map' may be reported in the error log when an archive

database is being recovered.

640484 Provide an historical MDA table for monitoring stored procedure usage.

This table should provide similar information to what is contained in monSysStatement

and monProcessStatement. The data that is captured at the statement level in

monSysStatement will be aggregated to the stored procedure level.

640541 Error message 14702, "XMLPARSE(): XML parser fatal error <<An exception occurred! Type:RuntimeException, Message:The buffer manager cannot provide any more buffers>> at line <line_number>, offset <offset_num>" may be reported when parsing XML documents with large number of namespace prefixes.
640552 A mismatch between the Config Value and the Run Value will occur during booting of the

dataserver if a load of sybsecurity database had resulted in less tables than configured

for. The mismatch will be seen when executing sp_configure 'current audit table'.

640630 On windows only, although the t-sql builtin current_bigdatetime returns a bigdatetime, the microsecond portion is always zeros.
640658 Objects opened by cursor would be missing in monProcessObject while the open is being processed.
640720 After you rename an index name on a proxy table by sp_rename system procedure,

update statistics command with the index name may raise a 2727 error.

640768 CIS text length limitation warning is incorrect
641055 srvbuildres/srvbuild will fail on solaris 10 machines which have ldm installed but not run
641091 When running "sp_configure 'mnc_full_index_filter', 3", which will set the optimizer criterion full_index_filter=1, a poorly performing plan may be generated in circumstances whereby a query is running under rowcount (or top) and the lead order by column doesn't have an entry in the predicate and is the lead key column of an index. In this circumstance, the index will not be costed and if this table is placed outermost in the plan, a complete scan of the table and a sort to generate the order prior to application of the row count is used.
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.

641156 Stacktrace occurs when a TDS fetch cursor command involving proxy columns is executed from external clients.
641192 Reboot of a cluster edition server may fail to recover local system temporary database, when model database is loaded from a lower server version dump, but not onlined before reboot. The errolog will contain message "infected with signal 11" in the module 'obj_id' along with a stacktrace which includes the modules 'recover_tempdb', 'upgd_upgrade_db'.
641253 On Solaris, when ldm is installed but the connection fails (e.g. when the daemon is not running) a message similar to the following is raised and certain SySAM 2 enabled applications terminate: "Failed to connect to logical domain manager: Connection refused".
641258 New functionality has been added that allows a dump of a database (other than the master

or sybsecurity databases), on a server running 15.5.x Cluster Edition, to be loaded into

a database on a server running 15.5.x non-Cluster Edition. This can be disabled using trace

flag 3411.

641272 ErrorNumber value is not correct in monErrorLog for some special messages.
641445 Request a functionality to generate an XML schema from part of an XML model
641535 sp_sysmon output may sometimes show negative value for the total task context switches due to "Other causes".
641536 In multi instance cluster setup when an instance fails, while performing instance failover recover, we may hit SIG11 with call stack having lock__rest_indoubt or hang where task keeps sleep waiting for the cluster lock request but there is no sign of request in the cluster.
641613 When configuration parameter "enable unicode normalization" is set to 0, UNIVARCHAR parameters to dynamic SQL statements are treated as having zero length, which is equivalent to a NULL value.
641679 sp_helprotect truncates the objectname when it is greater than 30 characters.
641692 sp_bindcache: allow indexes to use named cache the table is bound to as default
641696 The message "infected with signal 11" together with modules like "AnyOverUnderCheck(), StMergeHistCatalog::StmhApplyBoundary()" may be encountered when using update statistics on a bigdatetime or bigtime column.
641732 Feature request to restart ASE License heartbeat after it died.
641735 Cluster lock space rebuild takes lots of time and as CLM rebuild is blocking operation cluster is hung for several minutes.
641842 When an invalid database dump is first loaded, a subsequent attempt to load a transaction dump will not report a useful error message to the end user.
641955 Msg 17870 from sp_indsuspect due to non-existance temp table for sp_autoformat
642002 CURRENT_TIMESTAMP is unsupported in ASE.
642018 In ASE, using TOP, it is possible to specify rows [1 ... N], but not to bias this to rows [M, M + N - 1].
642023 The values of InstanceIO column in the MDA table monStatementCache is incorrect when queried on SMP server.
642038 On Platforms other than x86 Linux and Solaris Sparc, the rdesmgr_spin spinlock was hot in some scenarios.
642236 A new option, LOG OFF, has been added to the ALTER DATABASE command to shrink log fragments.
642331 Installmaster 2901 error (Exception stack limit exceeded) and signal 11 stack trace against 15.5 ESD release on HP-UNIX Itanium and Windows x64 platform.
642345 Under some rare circumstances when the "no free space acctg" database option is not set, the time taken to recalculate the free space counts after an impolite shutdown can be unnecessarily long.
642558 Under certain circumstances, it is possible to execute an 憃nline database <dbname>� while the same command is still executing. Executing he same online request twice can lead to errors being reported and the online command failing.
642571 A SELECT using an IN clause with more than 128 elements on a table with an

indexed encrypted column fails with an infected with 11 in stu_bincharinter

642735 Sometimes, boot recovery takes long time due to synchronous reads on sysobjects table
642776 SELECT INTO proxy table may fail silently when inserting NULL into the proxy column.
642812 In ASE燙luster燛dition, under some rare conditions, graceful shutdown of a cluster instance may crash the instance being shutdown and result in failover.
642878 New Feature Request for RepAgent Thread ... add clientname, clienthostname, clientapplname to LTL
642992 Errors 21, 913, and 3413 may be reported during recovery if a user-defined recovery order has been defined using sp_dbrecovery_order and the configuration includes a dbid that no longer exists. The defined order is stored in sysattributes with class = 10 and attribute = 6
643035 New Feature Request ... ASE add clientname, clienthostname, clientapplname in xact log records
643041 Feature request for arrays and tables as native T-SQL datatypes that can be declared as variables, returned by user defined functions, etc.
643124 When you copy a complex type which has other (complex/simple) types underneath, the result is that not only the top-level type is copied, but also all other types linked to it, too.

This however should not be the case.

643125 preupgrade: should run dbcc checks on sybase system databases.
643152 Resources not always retained in perspective after logging off SCC.
643168 Transfer table command for import returns 'unknown error' while file is not found instead of ' error 2: No such file or directory'. There is no effect on the table.
643188 Online database failed with 3461, 3451 and 3454 errors during upgrade system tables. There are two workarounds:

1) If 'max parallel degree' > 1, then please disable parallel sort with

sp_configure 'max parallel degree', 1

or

2) For upgrade a database via dump and load, set dboption 'select into/bulkcopy/pllsort' to false for the database on the target server before load an older version of database dump:

sp_dboption db_name,'select',false

go

use db_name

go

checkpoint

go

load database db_name from ......

643337 Relax restrictions on asterisk (*) in a non-EXISTS subquery SELECT LIST.

Provided the * expands to a single column in a single table/view/derived table:

1. the asterisk can be qualified with a table name (tab.*)

2. the subquery can be a GROUPBY query.

It will function as SELECTing the single column explicitly.

643390 Sometimes a task hits error 644 or raises exception from buffree complaining the

buffer is destroyed.

643536 In an XML Model diagram, when dragging a free-standing element symbol onto a sequence, PowerDesigner moves it correctly. However, the dependent complex and simple types are copied to new entries.
643556 Cross platform transaction load is not supported, but it is allowed and it may result in Msg 695, Level 21 "An attempt was made to read logical page '<pageid>' for database '<db_name>' ... Wrong logical page '2433379939' was broughtinto cache"; Cross platform load in an archive database is also not supported but it is allowed and may result in Msg 15760 - "Invalid dump header when loading the database with ID '<n>'.".
643625 Historical Server may crash with a core file when executing hs_list sessions command if the client's charset is incompatible with the server's charset.
643774 dbcc sqltext can SEGV or timeslice if the spid you want to see the sqltext for are in

the processes of termination.

643811 For queries with large number of joins that time out in the optimizer before a good plan can be found, then the alternative greedy algorithm is useful to find a good starting point for optimization similar what the 12.5 optimizer would choose. The alternative greedy algorithm may not be used for a number of reasons, and this change will allow more cases to use this feature.

This new feature adds support to allow the alternative greedy algorithm to be used when the index row for a 12.5 GROUP BY key is too wide for the query to be executed in 12.5. This new feature can be activated by trace flag 16929 or optcriteria allow_large_index_row.

Also, when partitioned tables are involved in the query the alternative greedy algorithm will now provide an initial starting point using global statistics from the partitioned tables, but otherwise treating the partitioned tables as unpartitioned. This new feature can be activated by trace flag 15366 or optcriteria basic_optimization_partitions.

643859 The "hints" option in Abstract Plan syntax is not backward compatible with 12.5 Abstract Plans.
643910 The severity for error 13905 is wrongly reported as 16. It should be 10 as in the manual.
643987 feature request to speed fast bcp up even faster. Since 15.0.2, we allow fast bcp with non-clustered indexes, but the improvement is a mere 10% over slow bcp. customer would like to have the *risky* option to put off the index and allocation updates to afterwards to get the data in as fast as possible.
644012 If the log I/O size used by Adaptive Server when doing I/O for the transaction log

of a given database is changed by sp_logiosize, then Adaptive Server may incorrectly

ignore it during startup.

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.
644280 After executing ALTER TABLE MODIFY an identity column and the server crashes, a large identity

gap is observed after reboot.

644357 If a stored procedure is created based on a non-partition table and later on this table is altered to a partition table, it will cause stacktrace and raise 12329 error when we execute this stored procedure when compatibility mode is enabled.
644380 A new column StmtType has been added to monCachedStatement. The value of StmtType column will be used to tell the type of cached statement, i.e. 1 means batch statement, 2 means cursor statement, and 3 means dynamic statement.
644394 In rare circumstances unexpected results may be returned

when executing a query on a view defined on other nested

views which require a Worktable to materialize some

intermediate results and involve a join with mixed

datatypes.

644402 ASE fails to account for the failed sdesmgr request when more auxilairy SDESs than configured are required.
644479 If traceFlag 15891 is enabled, the message, "mhdc_get_stat: No persistent reservation holder with res_type:2109524184" will be displayed during shutdown.
644531 When statement cache or literal autoparam is on, the query chooses a bad table scan that takes a long time to complete.

With statement cache off, or literal autoparam off, the query chooses the index.

644607 When using the plancost command from sybmon, ASE will stack trace. This is observed mostly on the Windows platform.
644669 The message "WARNING: The transaction log for database '<dbname>' (dbid <dbid>)

can no longer be dumped due to user '<username>' (suid <suid>) executing <cmdname>"

is now reported in the error log when the transaction dump sequence is

broken.

644677 For table descriptors(DES), Accessing rarely used objects could scavenge Objects that are widely used.
644715 query fails with 249 error with traceflag 450
644777 Multiple IN lists under OR didn't use large IN list transformation even when the total

number of IN values exceeds 128. Consequently, when the number of such IN values exceeds

32K, signal 11 and stacktrace could happen in GaGenericArray::_GaGetPtr() when optimizer is

trying to create more than 32K (int16) internal predicate objects.

644982 sqllocres set incorrect default sort order.
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.
645100 Statement cache lightweight procedures currently use 'sproc optimize timeout limit' and not

'optimization timeout limit' . This can be misleading. This request as to allow statement

cache lwps to use the 'optimization timeout limit' as per ad-hoc sql.

645146 Under some conditions, creating trigger involving union could lead to SEGV in p__check_lob_insdel() function.
645166 Request for 15.x Sybase Central plug-ins and Interactive SQL for MAC client
645301 Change of behaviors in IBM AIX LPAR (logical partition) licensing. This

affects AIX platform only in both ASE SMP and Cluster editions running in

IBM AIX LPAR environment.

The new behavior is that SySAM obtains the CPU core count from the Entitled Capacity

in a Capped LPAR environment, and SySAM obtains the CPU core count from the Maximum

Capacity in an Uncapped LPAR environment.

Prior to ASE 15.5 ESD#3, SySAM obtains the CPU core count from the Maximum Virtual

CPUs and Active Physical CPUs in Capped and Uncapped LPAR environments.

645343 Stack trace in LeDataRow::readRow when fetching insensitive cursor on a union.
645349 Error 206 when traceflag 450 is enabled
645445 For APL table with clustered index and the table is page compression, insert

duplicate row into the table does not raise error 2615.

645530 Sometimes the DBCC CACHEDATAREMOVE command may fail when executed on a system table, and the following 1265 error, "An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family...", may be reported even when there is no contention.
645594 Signal 11 and stack trace may be seen with functions _memcpy()\ LeDataRow::readRow()

LeScrollCache::LeScrCacheGetRow() when fetching rows from an insensitive cursor of a

select..union statement

645682 If auditing is enabled and the ASE server is started with traceflag 3607 a SEGV will

occur when a client does a query.

645753 Temporary tables created with the ALLPAGES lock scheme may report error 311 when an attempt is made to read the table using a cursor, despite a unique index having been created. The error only occurs in the case of ALLPAGES lock scheme and if multiple cursors are declared in the same stored procedure.
645810 Linux with multipathing displays "reservation conflict" errors in the machine log when fencing is enabled.
645860 The message "current process infected with 11" in the module

'lt_sqlrep_comp_policy' together with a stack trace which

includes the modules 's_compile_stmt' and 'GenLava' may be

reported in the error log when a session executes a query that

is being compiled by ASE, while a REORG REBUILD command or

DDL activity takes place concurrently on the same table.

645893 Requests to document the behaviour covered under CR 613678 in the New Features Guide.

This CR introduced a new parameter to sp_droplogin (@with_override).

It is required to be set to 1 if wanting to drop a login when one or more databases

are unavailable to check login references.

645898 In rare circumstances, after configuring a big data cache or a large stack size, SAP ASE might implicitly shut down following a JavaVM crash while executing a Java query. The message EXCEPTION_ACCESS_VIOLATION or 'ExceptionCode: c0000005' will be reported in the SAP ASE error log.
645944 Issue a warning if a network listener is using the IP address of a CIPC interconnect
646013 When creating local index on semantic partitioning table, mapping between index partitions and

datapartitions is not guaranteed in the same order of semantic partitioning boundary.

646024 Sort operators are undercosted in fastfirstrow scenarios.

Fastfirstrow scenarios include min/max optimizations, exists

scans and the fastfirstrow optgoal. This can lead to

discarding fastfirstrow strategies in preference to other less

efficient strategies incorporating sorts. The fix for this is

enabled by the cr646024 optcriteria.

646101 Under rare circumstances, DISK INIT may hang indefinitely.
646141 Print a warning message if the timestamp of a joining instance is not in sync with that of the existing instances.
646149 In rare circumstances, the same Abstract Plan works fine on ASE 125x and failed

on ASE 15.5 with the error 1009, Level 16, State 2.

646206 ASE does not perform implicit conversion when unitext data is sent from external clients to a text parameter.
646207 When executing DBCC TUNE (des_bind) on a table, a 8428 error may be encountered after which the table is no longer usable.
646220 When selecting from a VIEW using an equality predicate over two view columns where the two VIEW columns are the two SELECT DISTINCT columns of the VIEW and one of them is also a non-correlated aggregate subquery result there, it could lead to signal 11 stacktrace in CgpDistinctHashing::_cgpInit() or in CgpPop::_CgpReplaceVars().
646232 Currently ASE is designed to allow an offline database to have it抯 transaction log dumped.

This is a request to change that behaviour and deny that command on an offline database.

646254 Please document the write up for error message 13968

Error 13968

Severity

16

Message text

"ALTER TABLE '%.*s' failed. You cannot drop all partitions of a table."

Explanation

The alter table command provides a method to remove a partition from table. Any data that is stored on that partition is moved to a suitable remaining partition.

When there is only one partition left on a table, it is no longer possible to store the data in an alternative partition. If an attempt is made to remove the final partition from a table using the ALTER TABLE command then error 13968 will be reported.

Action

This error is reported when an attempt is made to drop the only remaining partition of a table. If the requirement is to drop the table from the database then the correct method is to use a drop table command. If this is not the requirement then no action is required.

Additional Information

Refer to the Reference Manual: Commands for information about the alter table command

646295 select fails to convert float to numeric if region setting is german germany and enable pci is set on
646353 A signal 11 may be 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.
646467 ASE Cluster Edition running on SuSE linux may hit SEGV if native CIPC thread is enabled (traceflag 15582 is not used).
646490 For a table with auto identity column, REORG REBUILD after any data copy operation (like ALTER TABLE involving data copy or REORG REBUILD) would fail with error 1763. Also, two consecutive ALTER TABLE ADD/MODIFY operations involving data copy may remove the auto-identity column so that any later attempt to see the values under SYB_IDENTITY_COL may fail with error 207.
646508 Customer required clarifucation.
646647 update all statistics on a table with no index gives Msg 1763.
646693 After migrating from pre-15.0 to ASE 15.5, sybmigrate may report diff failures with 16201 error, "Remote datatype 'usmallint' (65) is unsupported in local server".
646695 Query involving 6 or more tables and greater than 14 worktables can exhaust procedure cache.
646828 New set option to ABORT the transaction for all Error messages.
646844 On AIX platforms, logical volumes cannot be fenced directly.
646877 ASE on Windows can occasionally hang on call csimtx_lock()=>WaitForSingleObject(). This can occur at server startup or at user authentication when attempting to obtain the lock which is already held.
646933 In a 4-node cluster, if any node crashes, executing DROP INDEX from active node will result in a 3757 error.
646987 When inserting data using PreparedStatement and DynamicPrepare=True, data might be truncated when the column type is UNIVARCHAR and the first value inserted into the column is less than or equal to 128 characters in length. If these two conditions are true, then every subsequent value inserted into the column will be truncated to 128 characters, if greater than 128 in length.
647051 The selectivity estimates for predicates on columns with NULL values may be incorrect for the !=, <, <= operators. There is also a correction for ANSINULL handling of NULL selectivity in which magic numbers were used instead of histogram values. Change is turned on by optcriteria cr647051 in optlevel ase155esd4
647052 When deadlock information is required to be printed into error log, corresponding SQL texts are not printed out.
647138 A 11035 error, "Execution of procedure <proc name> failed

because upgrade found no entry in syscomments for this

object. Please drop and recreate dbo." may be reported

when executing a stored procedure which belongs to a

procedure group that was created using deferred name

resolution and at least one of the procedures in

the group has a SELECT * statement.

647202 The Opertions column in the MDA table monOpenObjectActivity is not incremented when statement cache is on.
647239 DBCC PROC_CACHE("free_unused") doesn't refill other engine's ELC.
647356 The procedures cache folder at Sybase Control Centel reported the following error "Arithmetic overflow during explicit conversion of NUMERIC value '119185.603515' to a NUMERIC field" and didn't show no data for memory usage. Y
647485 Executing a SELECT INTO EXISTING command on a proxy table with identity_insert option

turned on does not insert the data.

647569 Certain parallel query plans available in ASE releases before 15.0 are not supported

in ASE 15.0. Cases include joins between partitioned and unpartitioned tables. This

change adds capabilities and costing support for these queries. Changes are enabled

using trace flags 16970 and 15331. You may also need to sp_chgattribute to set the plldegree on a per table basis.

647589 When a stored procedure or dynamic SQL statement that has at least one LOB parammeter is

recompiled after execution starts, a stack trace containing the functions, copyconst(),

copyres() and s_recompile() could be generated.

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'.

647670 DBISQL 11.0.1 for ASE's 'OUTPUT TO Excel' command does not work.
647726 A parallel reformat inside a subquery may be costed incorrectly.
647801 A 691 error, "Encountered invalid logical page '0' while accessing

database 'db_name' (id), object 'table_name' (id), index 'index_name'

(255),..." or a 14108 error, "Could not find partition descriptor

for objid <...> ..." together with a stack trace which includes the

modules 'get_txtpage' and 'instext' may be reported in the error log

when running a SELECT INTO UNION which requires to use an internal

worktable (for example, because of an ORDER BY clause) and a NULL

literal value is used in one of the UNION sides for a TEXT, UNITEXT

or IMAGE column.

647823 Very long boot times when large procedure cache configured.
647831 Signal 11 in s_result_const_memfree sometimes after error 599
647864 The execution of SP_ADDENGINE and SP_DROPENGINE will raise error 17260 "Can't run <procname> from within a transaction." incorrectly when invoked under chained transaction mode despite that there is

no open transaction.

647973 When insufficient served licenses are available ASE should report the requested license type and quantity, as is the case for unserved licenses.
648018 A 257 error, "Implicit conversion from datatype 'INT' to 'VARCHAR' is not allowed", may be raised when migrating a pre-15.0.2 server to ASE 15.0.2 or later versions.
648097 After you run 'set lock wait 0' or 'set lock nowait', @@lock_timeout is still -1.
648131 It can not find the right partition that is remaining.
648155 In-place upgrade hang and on recovery get latch deadlock.
648195 Doc Request: add known performance issues with MDA parameters
648216 Doc bug: update XA Interface Requirements per version
648380 ASE/CIS to oracle ... convert function causes subquery performance prblm
648396 Under爏ome燾ircumstances爐he爉essage "WARNING:爉emory爑sage 爄n爌rocedure爃eaders (x)燿oes爊ot爉atch爉emory爑sage燾ount爄n燩ss (x)爁or爏erver爌 rocess爄d爔"爉ay燽e爎eported爄n爐he爀rrorlog"
648449 SELECT INTO EXISTING, identity fields can cause 12859 errors and stacktrace
648453 datachange() returns contradictory results before statistics are created
648511 If sp_passwordpolicy "expire login passwords" is executed without specifying a login or wildcard string, it expires every login on the server.
648514 Error 1105 States 4, 5, and 7 may no longer mean what they are documented to mean in the ASE Troubleshooting Guide due to reuse of the values in new code.
648582 A feature request to improve index selectivity for constant valued search arguments and encrypted non-character and non-binary columns.
648591 A 8201 error, "Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1.

Instead 0 was found." together with a stack trace which includes the modules 'des_unkeep'

and 'onl__chk_indexes' may be reported in the error log when a database dump is loaded

that has been previously obtained on a different platform.

648593 Repeated invocation of space related built-in functions like data_pages() used in sp_spaceused

reads the missing (not found the in ASE cache) pages from the disk and will never keep them in

the ASE cache. This incurs lot of i/o on large databases (database having lot of tables) and

may degrade the response time.

648623 Feature request: Provide an ASE option for use with MQSeries to use the IBM standard channel table to look up the channel to use based on the queue manager name.
648663 When downgrade 1503 esd#3 or esd#4 server back to 1502 server or older, 515 error was raised for null insert into non-nullable columns.
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.
648688 The new feature request requires the sp_audit "alter" working for all the databases in the server.
648791 Optimiser still picking group_hashing after it was specifically turned off
648848 An OpenSSL error, "SSL or Crypto Error Info: psn -1, vsn -1, sockp (nil) error id 96, severity -2, provider id 2. SSL or Crypto Error Message: 'An unexpected failure occurred while performing an OpenSSL cryptography operation. Root error: error:0606506D:digital envelope routines:EVP_DecryptFinal_ex:wrong final block length'", may be reported while dumping the transaction log.
648863 Dynamically prepared SQL is not executable after HAFailover in the Cluster Edition. This data is currently lost and the application program must re-prepare the data before execution on the HAFailover's connection.
648948 Executing a procedure with derived table containing UNION queries could lead to permission errors.
648998 monProcessObject reports table/partition statistics aggregated to the table level and associates the aggregated statistics with the base table and first partition (if any) instead of providing the detailed statistics for each index/partition involved in the query
649000 In rare circumstances, loading a compressed database dump into an archive database can fail with an error 692, 'Uninitialized logical page '0'..' when Adaptive Server incorrectly loads page 0 from an invalid offset.
649006 Table scans were avoided since the CPU cost for table scans did not take into account reduced row counts due to partition elimination
649030 Provide a configuration option for MQ Series, similar to "xp_cmdshell context", that would would cause ASE to attempt to open the queue as the "sybase" user process by default, with altusr/setid used only when needed for special cases.
649038 Under some rare circumstance, parallel queries using expression involving LIKE and variables or parameters could cause stacktrace and the stack will show modules copy__eval() and copy__eoplike().
649039 Need to have SSL capability in the Agent to ASE links so that SSL can be used on all ASE CE ports.
649087 If a table is altered by adding a column with a user datatype which has a default value bound to it, the user datatype default is missed - a new default is generated. This leads to error 2513 when dbcc checkcatalog being run.
649145 In rare circumstances, the message "Sybmon encountered signal 11" in

the module 'pci_configured' together with a stack trace which includes

the modules 'sm__exec_memload' and 'shm_memload' may be reported in

the error log when a memory dump is loaded with Sybmon while attached

to ASE server.

649171 Under some circumstances, when a UNITEXT value is passed to a stored procedure or dynamic

SQL statement as a parameter where a TEXT value is expected, implicit conversion will take

place within ASE. If the UNITEXT value is larger than 450 bytes and the converted TEXT

value is smaller than 450 bytes, a stack trace including the functions, memtextlen()and

LeLOBCache::_copyConstantToCache() will be generated.

649226 Alter table add column hits error 2705 when "auto identity" is enabled

from a Jconnect client as DBisql.

649307 A new feature request for enhanced timezone support.
649428 Adaptive Server may encounter a storage access violation error when query execution is interrupted.
649470 When conserve_tempdb_space optcriteria is used, then tempdb space estimates inside subqueries are not recognized when query plans using large amounts of tempdb space are to be avoided
649590 Inherently zero row queries, ie with an always false constant conjunct (ie where 1=0), can take a long time to find a query plan.
649701 Previously diagnostic information was available for error 290024 - invalid column. Due to possible performance issues, we now print it only if traceflag 2779 is set.
649710 You may retrieve a strange row which has ErrorNumber=110081 and Time='Jan 1 1900 12:00AM' from

monErrorLog just after the ASE is restarted if the ASE is configured with multiple engines.

649754 Request for a new feature to check any identity columns following a server upgrade to ensure that the upgrade does not result in 2601 errors.
649793 Under certain circumstances when running queries that use MIN/MAX, the ASE optimiser chooses a query plan that is estimated to have a low cost based on the available statistics. When executed the actual cost is much larger than the estimate and the performance may be impacted.
649932 Sessions which execute dynamic sql query may fail with error 2901 and the exception stack limit is exceeded.
649938 Linux Hughpages the documention is not correct.
649987 When running certain stored procedures that use mixtures of local, temporary and tempdb tables, ASE may incorrectly throw error 208: <table_name> not found.
650044 Feature request to allow downgrading of a single database.
650076 Cluster lock space rebuild takes time and as CLM rebuild is a blocking operation, cluster is hung for the duration.
650103 DDLGEN cannot generate range partition clause when there is a local index
650163 Executing dynamic sql query may hit error 8203 in des__markdrop() together with stack trace

involving module ssql__rmplans(), ssql_save_SQL() and sqt_put_in_stmtcache().

650188 Feature Request: have 100039 errors resolved within the upgrade process.
650206 Queries optimized with fastfirstrow optgoal may underestimate

sort operator costs. This problem is exasperated in parallel

query optimization.

650207 Inline default objects created for the default clauses are not shared among different

columns even with the same default value, leading to unnecessary large number

of default objects in ASE.

650268 For options, for example 'cpas per ccb', defined as CFG_MEMORY_USED but do not consume

any memory at run time, sp_helpconfig will raise error when estimate the memory usage on

them.

650297 In rare circumstances, Adaptive Server may hang as a result of being unable

to reuse object descriptors whose statistics metadata are not yet flushed

on disk. The configuration parameter 'number of open objects' would need

to be increased accordingly.

650302 Customer requests that we certify the latest 15.x with the latest versions of NetApp ontap on AIX.
650313 Repeated "Timestamp for database" messages in the errorlog.
650316 When replicating data from a low durability database, RepAgent may sleep on the end of the log

and fail to detect that the log has been extended. The problem is more likely to be seen when

there is little activity and the transactions are short. RepAgent wakes up and resumes replication

once the log grows past the current last log page where it stalled.

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.
650670 ASE needs feature support to assure that some ASE users are logging in and using encrypted traffic on their session connections to ASE. SSL clients and Kerberos clients with encryption properties set would qualify as "encrypted session users".
650686 Linux 32bit setup aio formula is ((max async ios per engine + 1) * # of engines

Linux 64bit(both IBM P-series, x86_64 versions) is

((disk i/o structures + max async ios per engine+1) * number of engines)

650839 sp_plan_dbccdb may raise a 3606 error, "Arithmetic overflow occurred", if the server contains very large databases or very large devices. The device size values displayed for recommended devices is also not properly adjusted for server page size.
650889 On WinX64 platform configured to use SSL client connections, a segmentation violation may occasionally occur during server start-up due to pending read and cancel on the socket for a site handler RPC connection.
650977 Unnecessary procedure renormalization involving INSERT/UPDATE into temporary table may happen after temporary table re-creation and recompilation. This can cause sysdepends or sysprocedures contention.
651021 Error msg 7105 was changed from "TEXT/IMAGE/UNITEXT page <page id> does not have a next page, although it should." to "TEXT/IMAGE/UNITEXT page <page id> does not have a next page. Either there is a suspect text page chain, or transaction isolation level 'read uncommitted' has been set. Database <db name>, table <table name>, first text page <page id>."
651085 If the stack size is under-configured, showplan may sometimes cause stack corruption for a very complicated plan.
651152 optdiag incorrectly raises error: Data type/length of column X mismatch with the stored values in syscolumns.
651190 The reported message of "memory ASE used" looks incorrect on winx64 and nt386 platform if user want to change stack size through sp_helpconfig
651228 Running Job Scheduler installTemplateXMl.csh script results in a "ASE150.csh: No such file or directory" error.
651352 In certain circumstances it is possible that an inner class, that has been installed

into an ASE server is not found when required by executed java code.

651394 doc bug: add -XX:MaxPermSize to the java_options tunable by sp_jreconfig
651654 There is a Typo in the Job Scheduler documentation

Chapter 3: Using Templates to Create Jobs

--------------------------------------------------------------------------------

Installing the templates into Job Scheduler

On UNIX:

installTemplateXML servername machinename serverport username password language

On Windows:

installTemplateXML.bat servername machinename serverport username password language

where:

In fact, the name of the template xml script is installTemplateXml (not installTemplateXML) in the Sybase file directory.

651657 Error 7738 needs meaningfull text adding
651722 "insert partition" for range partitions on the fly to avoid the downtime involved in redistributing the data with unpartition/partition.
651726 Feature Request to eliminate the requirements for kernel.exec-shield=0 and randomize_va_space=0
651853 Doc Bug: typo ">=", should be "<=" ">" cannot be used in the MAX partition
651865 UPDATE on a nested VIEW may cause a stack trace involving the modules 'vu_mergetress', 'vu_analyze_view' and 'vu_call_analyze_view'.
651914 The 0x08 bit for sysindexes.status2 field does not get correctly cleared when running sp_rename or dropping a constraint.
651924 need examples how to configure RPC for CS_LONGCHAR_TYPE
652094 3607 divide by 0 error (return status = -6) with traceflag 3610 on
652103 The message "current process infected with 11" in the module

'des_unkeep_or_drop' or s_free() with a stack trace that includes the modules

'apm__metrics_insert', 'kill_proc' and 'proc__dealocmem' may be reported in the

error log after a session that was hanging because of the transaction log

being full was killed and the configuration option "enable metrics capture"

was active. This error resulted in ASE shutting down itself.

652106 Spinlock contention for Resource->rproccache_spin is huge due to large memory allocation tuning.

------

TF 758 enables this fix. It needs to be used at startup.

Start the server with -T758 and this will enable large scale allocations to use the ELC directly, i.e. 2 page\4 page\8 page.

652110 If a constant expr is in the select list of a VIEW or derived table, and the VIEW is the inner of an OUTER JOIN, and the constant attribute is correlated into a subquery outside of the ON clause of the OUTER JOIN, then a stack trace could occur if a subquery reformatting strategy is chosen, such as in the following query: select Panel = (select PN.c1 from tb1 PN where A.r2=PN.c2) from T3xxx RE left join (select 1 from T1xxx r) A(r2) ON RE.c3=A.r2
652160 DBCC CHECKTABLE may result in 12905 errors when executed on DOL table with indexes.
652269 stored procedure to enable and disable optcriterias server wide
652275 When ASE is waiting for tasks to exit, print additional information to understand why shutdown is not proceeding.
652328 TEXT/IMAGE page chains are not deleted properly from sysattributes when REORG REBUILD is called on a table with TEXT and IMAGE data. This can result in reduction of unreserved/available space in the database.
652364 When naming the configuration file, avoid using a dot in the name of the file, with the expection of the extension �.cfg�. The use of the dot character before the extension 揷fg� is required to maintain the history of configuration changes correctly.
652387 Query on an audit table will hang when the audit table is full. port CR# 493608 to the 15.5 ASE codeline, which is currently fixed only in cluster edition.
652396 In rare circumstances, the message "current process infected with 11" in the module astc_xid_gen along with a stack trace which includes module sysxacts_materialize may be reported the error log while using systransactions system catalog or stored procedure sp_transactions.
652535 Under some circumstances, when STATISTICS IO is enabled and BCP encounters an error, a signal 11 may result followed by a stacktrace with the module 'LeOperator::LeOpProcessIOStats'.
652562 A Cluster Edition instance cannot be "onlined" after it was previously killed by VCS during an attempt to join an existing cluster.
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.
652640 When a user with sso_role runs a query accessing a table on current or another database,

a 2736 error may occur during recompiling a light-weight procedure if statement cache

is enabled and the user is not added to the current database.

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.
652738 When inserting audit records into audit table fails and node shutdown is issued, the node shutdown may encounter a signal 11 followed by a stacktrace involving the modules 'insert' and 'audproc'.
652746 Correct the documentation for limits on user table.

"For a select query, the allowable limit is still 50 tables.

The total number of user tables allowed in a query is 512, you can only achieve that by using UNION, with 50 as the limit at single side of UNION."

652772 Alter table drop column operation may result in a 804 error while dropping a TEXT column from a Datarow Locked table with forwarded rows.
652783  
652802 In rare circumstances, executing a stored procedure may cause the signal 11 in

0x090000000000d6c8 (pci_cfgmgr_default_config+0x7b0).

652932 Have showplan output the stored proc name when it has an EXECUTE step.
653053 In a user-defined transaction, an UPDATE to a VIEW which triggers an insertion to a remote TEXT column may hang indefinitely.
653067 sp_helpcache does not display the correct cache binding.
653075 JConnect may report incorrect row counts when config option 'enable functionality group' is configured.
653101 In very rare circumstances in a multi-engine environment with a high degree of DML concurrency, index corruptions evidenced by errors like 12301, 12314, 632, 692 and others, can occur following the roll back of a transaction in which index splits or shrinks occurred on data-only locked tables.
653157 In Adaptive Server/Cluster Edition, the opening of databases when booting

a non-coordinator instance, is performed serially so that

making all databases available takes an unnecessarily long period of time.

The opening of databases is now done in parallel. The previous

behavior has been retained under the 2796 trace flag.

653210 Queries involving SELECT FOR UPDATE may hit signal 10 on Solaris/HP platforms.
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'.

653246 In 'Advanced Options' page of 'Add Database Device' Wizard, the 'skip allocation' is enabled by default (the box is checked).
653277 An UPDATE query running in a batch that includes a CREATE INDEX or UPDATE/DELETE STATISTICS or an UPDATE query running simultaneously with a workload that involves CREATE INDEX or UPDATE/DELETE STATISTICS may lead to data inconsistency.
653385 In Adaptive Server Cluster Edition version 15.0.1 ESD#4 or later, the message "current process infected with 11" in the module cm_bind_cache() may be reported in the error log when a cache binding or unbinding operation fails due to any error.
653458 Sybase utilities that connect to the ASE server on Windows 64bit platforms may fail to connect when being run in a remote desktop connection and ASE is running as a service or in another (different) remote desktop session.
653511 If a stored procedure undergoes recompilation, and the procedure makes assumptions regarding session's state (ie session environment settings), the resulting recompiled plan can be significantly different to the original. This fix is only active when traceflag 7773 is active.
653512 login with 100 roles assigned directly takes 6 times longer to login than 1 role
653575 ASE 15 change the data type we return for the avg function from Numeric to

Big integer request to have a trace flag to revert the behavior.

653621 showplan shows 2k pool sysmons shows 16K i/o while creating an index
653694 Transfer table command with destination to a 'fifo' file can fail for tables with rows of larger size.
653722 An infected with 11 occurs in NormalizeScaler when inserting the results of a UNION into a table with a materialized functional column.
653786 Sybase Central 6.0 with ASE Plug-in may raise the ClassCastException when displaying device information from database property if an additional segment exists on the database.
653797 New feature request : sp_monitorconfig supports "statement cache".
653916 sybmigrate validate outputs messages "Index, Index Constraint" when the create table ddl on target did not specify the index name.
653938 upgrading ASE database to 15.x may sometimes raise an error Msg 1902, at

upgrade step [ID 53]

653966 The Adaptive Server Enterprise can not bring the second engine online on Linux x86 platforms if max memory is over 2GB.
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.".

654063 A SELECT INTO query that uses an ON SEGMENT clause when selecting data from a UNION ALL may raise an invalid error 205 or an infected with 11 error in GtElement*GcElement::GcGetGt()
654105 infected with 11 in GtuUnion::GtcPropagateAlias caused by a query that does a SELECT INTO that specifies an ON SEGMENT clause when selecting from a derived table based on a UNION.
654233 Adaptive server goes down after an assertion is hit in the module th__refresh_threshcache(),

when running alter database command if systhresholds system table is corrupted and

diagserver is used.

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.

654349 It will return a wrong number for patindex() while the matching text across two compressed blocks.
654404 Depending on the optimization goal, queries that create a table using the 憇elect....into...� syntax may choose a plan that does not use the expected indexes. This can occur if the optimizer has chosed a merge join or hash join for the query.

Queries that do not save the result set in a temporary table are no affected.

654408 Error 3143, which is master database specific, is raised instead of the generic error 3120 if load

database with headeronly is issued from the master database for a user database and the source was

configured with a different character set and/or sort order.

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.
654605 If there are multiple IP addresses corresponding to the hostname provided in the interfaces file, ASE picks one to listen on. It should listen on all of them.
654617 Enable CIPC native thread on HP platform.
654653 The database option "no chkpt on recovery" may be left set for a given database mistakenly

when ALTER DATABASE and QUIESCE DATABASE are executed by two sessions concurrently.

654661 In rare circumstances Runtime execution error "invalid column length" may happen

when executing a stored procedure updating temporary tables

654775 job sched: 'run_now' fails on 15.5 for sa and user
654922 Please add new functionality so that the plan displayed by sp_showplan 憇pid� in isql session 1, executed after opening a cursor in isql session 2, is the same as that displayed when a cursor is opened in a session that has already executed "set showplan on".

In the example below we only see the query type now, but we want to see the query plan from the select statement

SESSION 2 � Long running query

1> select @@spid

2> go

------

371

1> declare C1 cursor for select count(*) from

tempdb..sysobjects a,tempdb..sysobjects b,tempdb..sysobjects c

2> go

1> open C1

2> go

SESSION 1 � run showplan to see the query plan

1> sp_showplan 371, null, null, null

2> go

QUERY PLAN FOR STATEMENT 1 (at line 1).

STEP 1

The type of query is OPEN CURSOR C1.

(return status = 0)

Before opening the cursor, turn on set showplan, when the cursor is opened the plan is displayed.

declare C1 cursor for select count(*) from tempdb..sysobjects a,tempdb..sysobjects b,tempdb..sysobjects c

go

set showplan on

go

open C1

go

QUERY PLAN FOR STATEMENT 1 (at line 1).

STEP 1

The type of query is OPEN CURSOR C1.

QUERY PLAN FOR STATEMENT 1 (at line 1).

STEP 1

The type of query is DECLARE CURSOR.

5 operator(s) under root

|ROOT:EMIT Operator (VA = 5)

|

| |SCALAR AGGREGATE Operator (VA = 4)

| | Evaluate Ungrouped COUNT AGGREGATE.

| |

| | |N-ARY NESTED LOOP JOIN Operator (VA = 3) has 3 children.

| | |

| | | |SCAN Operator (VA = 0)

| | | | FROM TABLE

| | | | tempdb..sysobjects

| | | | a

| | | | Index : ncsysobjects

| | | | Forward Scan.

| | | | Positioning at index start.

| | | | Index contains all needed columns. Base table will not be read.

| | | | Using I/O Size 2 Kbytes for index leaf pages.

| | | | With LRU Buffer Replacement Strategy for index leaf pages.

| | |

| | | |SCAN Operator (VA = 1)

| | | | FROM TABLE

| | | | tempdb..sysobjects

| | | | b

| | | | Index : ncsysobjects

| | | | Forward Scan.

| | | | Positioning at index start.

| | | | Index contains all needed columns. Base table will not be read.

| | | | Using I/O Size 2 Kbytes for index leaf pages.

| | | | With LRU Buffer Replacement Strategy for index leaf pages.

| | |

| | | |SCAN Operator (VA = 2)

| | | | FROM TABLE

| | | | tempdb..sysobjects

| | | | c

| | | | Index : ncsysobjects

| | | | Forward Scan.

| | | | Positioning at index start.

| | | | Index contains all needed columns. Base table will not be read.

| | | | Using I/O Size 2 Kbytes for index leaf pages.

| | | | With LRU Buffer Replacement Strategy for index leaf pages.

655023 After installation on windows, ASE reports it is running as a service but it was actually started by the installer, not as a service
655126 The documentation needs to be clarified with respect to the expected behaviour in the event of error 2749 occuring. This is defined as a user error and in the case of user errors only the command causing the error is aborted and not the transaction. Any open transactions remain and must be handled by the user.
655188 T450 does not work properly with large select list
655195 ASEMAP Monitoring View - Blocked Process screen displays lock configuration information.
655196 Process screen in ASEMAP monitoring view for Sybase Control Center has a new option to allow users to filter out system processes from the list of processes displayed in the datagrid
655342 Provide option for Rep Agent to only send SQL statements to the RS.
655352 When expressions on GROUP BY lists are in the select list or HAVING clause in which the same column is used on both sides of an operator, then a wrong answer could result e.g. col1 + col1
655386 When gracefully shutting down the coordinator node, the cluster may perform failure handling which will be aborted. This will cause some remaining nodes to become inaccessible.
655440 Job Scheduler fails to execute the job, if the text (sql) in the jcmd has quotes around them.
655496 Error 9502 stating "Data exception - string data right truncated" is not raised when statement cache is on
655519 Batch insert run slowly when using enable PCI and java
655556 Feature request to support CREATE FUNCTION syntax with an empty set of parenthesis used when there are no input parameters for the function.
655613 A DB2 error indicating an invalid value may be returned when a query referencing a remote DB2 table contains a DATE search value.
655642 In ASE Cluster Edition, under some rare conditions, the CREATE/DROP database commands may hang forever as the other task does not send the wakeup event.
655643 Re-implementation of the ASE counters supplied to Windows Performance Monitor (windows only)
655745 Under some circumstances index hints prevent the optimiser from coming up with a valid plan resulting in a 325 error.
655766 On some heavily-loaded systems, sybcluser might hit timeout error if it takes more than 1 minute to start a cluster or instance.
655801 In ASEMAP Monitoring's Database screen in SCC 3.1, the value in 'Type' column for a db whose name is 'tempdb' will be shown as empty (compared with 'Temporary') if its 'trunc log on chkpt' dboption is turned off. This fix correct the issue.
655823 infected with 11 in dbt_newseq associated with issuing a dump tran against a database in recovery.
655828 During shutdown instance processing, the shutdown thread may hang during dbtable cleanup. This prevents local instance polite shutdown
655846 ASE at a higher engine count may encounter error in allocating monitor memory during disk init for higher device count.
655917 ASE loops indefinitely with the message "NT operating system error 1056 in module 'nt386\source\demo\scm_nt.c' at line 1263: An instance of the service is already running."
656032 sp_placeobject does not work with the index name having trailing spaces.
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.

656135 Feature request for a Replication Agent procedure to avoid 624 and 692 errors due to stale LTM or rs_locator values.
656139 sp_start_rep_agent failure message indicate reason is db is in single user mode.
656243 Negative column length for collocate called by ptrcopyrow
656248 A way to see if a procedure(object) have been created with T299 on or off.
656294 The values of the metrics in the monCachedStatement table are the same for all related columns.
656337 documentation: engineering saying "SQLJ functions in 1503 are not supported" need to remove any reference to SQLJ in the ASE 15.0.3 documents
656351 In a shared disk cluster, a change in ownership of a database on one node may be undetected by another node when a cross-database access is made to a dbo-owned table.
656374 Sybase Central may fail to load 32bit mclib.dll on Winx64 platform.
656425 Provide compile time warnings to ensure that typing errors which result in too few parameters being passed to raiserror are identified when the a stored procedure is created to help prevent the occurence of 2749 errors at runtime.
656435 Executing a sql query may hit error 8224 from des__lwpdescreate() together with stack trace

involving modules open_lwpbyname() and open__byname().

656463 "kesetown: engine <engine number> is still not online after <number of attempts> attempts to affinity to it"

may be raised when an engine is offline and dbcc monitor is executed multiple times through sp_sysmon.

656469 After upgrade via binary overlay, some parameters are not found in sysconfigures.
656475 After changing the server's default sort order id from 52(no-case) to 50(binary), INSERT into list partitioned tables may result in error 9573.
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>".
656582 An update statistics with sampling operation that runs out of space in tempdb may fail to properly

abort. This may cause an infinite loop of Error 1105, Msg 140030 or other errors.

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.

656619 sybcluster might not work if uaf agent or host is abruptly shutdown.
656643 In rare scenarios when invalid tds packets are received, Adaptive Server gets infected with signal 11.
656782 With 'enable functionality group' is enabled, executing a DYNAMIC QUERY may hit signal 11

together with a stack trace involving the module tdsrecv__dynexec_xoltp() in case of recompilation.

656835 creating spinlock contention artificially
656902 If a query contains a join between partitioned tables and one of the

partitioned tables degenerates to a single partition through dynamic

partition elimination and there is a CIS table in the query, then a SEGV could

occur in the PartNodeInfo::collocatedSite() method.

657023 IF (SELECT ...) statements can perform poorly.
657097 DBCC commands will currently tell you that the consistency of data is ok when the data in a table is not capable of being decrypted by the current key values. This feature requests a more complete check of the data which would identify data rows and columns having decrypt problems.
657187 Request for syslogins table to be altered such that the columns 'pwdate', 'lastlogindate', 'crdate' & 'lockdate' have type datetime (usertype = 12) instead of datetimn (usertype = 15).
657249 Attempting a normal shutdown on a dataserver will not terminate batches of sql which include infinite looping and waitfor delay tsql. Current documentation leads one to believe that loops will be terminated at the end of current sql statements.
657271 A 701 error, "There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache", may be reported followed by a stacktrace involving LeScrContext::updCacheStat when a query tries to acquire the cursor cache.
657320 With 揺nable functionality group� is enabled, executing a CURSOR FETCH may result in a signal 11 together with a stack trace involving the module LeEmitSndOp::_LeEoCopyParams().
657326 Disk mirror should not report an error on a different database device when we mirror a database device which is used by archive database which is doable.
657353 Monitor elements SMC_NAME_PAGE_LOGICAL_READ and SMC_NAME_PAGE_PHYSICAL_READ may be calculated incorrectly. The logical and physical read counts are coming out the same, even when queries that only do logical reads are executed.
657380 The RowsAffected column in MDA table monSysStatement is incorrect for parent procedures.
657407 The error message, "There is heap memory not freed for spid <spid_id>. This heap memory pool will be destroyed", may be reported when ALTER TABLE command fails.
657466 Feature Request for improvements to the number of recovery threads at start-up.
657495 If set 'optimization level' to ase1503 ESD2 or up, then a complex query joining more than six tables and having a few subqueries may get a slow query plan with suboptimal join order. The problem is due to a side effect of the fix of CR 550574 and avoid_bmo_sorts optimization criteria. Please try 'set avoid_bmo_sorts off' to workaround the problem.
657522 After a polite ASE shutdown, no_recovery durability databases whose

log segment is mixed with data segments may have inaccurate free space

counts.

657529 recovery takes longer when database have mixed data and log segement.
657585 An 1105 error on the system segment during upgrade may occur despite preupgrade indicating the database has sufficient space.
657590 DBCC LISTOAM on an invalid index ID may failed silently without any error message.
657619 capability for user written stored procedures to replicate work that would normally be replicated through master database replication.
657655 sp_helprotect shows only public permission instead of permissions of group that the user belongs to.
657705 The message "Current process infected with signal 11 (SIGSEGV)" followed by a stack trace that includes the module crdb_main() can be raised when trying to create a new database and the configuration parameter "number of open databases" has already been exceeded.
657769 Sysam support for cpu-cap with subcapacity liceneses
657797 Document more clearly that turning on statement cache can have a impact on @@nestlevel and @@procid.
657820 set tracing needs mon_role for show_sqltext on if statement cache is on
657855 document feature error: 722

"Procedure cache exhausted before a query plan could be found"

657899 ASE does not perform character set conversion on a text column if a jConnect application uses a PreparedStatement class and sets over 16KB length string data as a parameter.
657908  
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.
657989 Feature request for a batch size option for atomic INSERT, DELETE, and UPDATE statements that would break large atomic operations into multiple smaller independently-committed transactions.
657997 House keeper task never writes the in-memory statistics (SYSTABSTATS) of table created with 'for load' option to disk. This may result in sub optimal plans after un-paritioning the table.
658094 Remove the impact Enable statement cache have on @@nestlevel and @@procid.
658102 APs are not generated when statement cache on, and the statement cache has an entry for the query.
658105 "set switch serverwide on 'disable_minmax_optimization' with override" has been enhanced with new session level criteria "set allow_minmax -1|0|off|1|on". It can also be used in query level AP to control just that query.
658109 Client connections to an AIX server occasionally fail due to the server being busy performing it's periodic CPU license checks. When this occurs the os_populate_cpu_info() function will be seen on the process stack. The default CPU licensing counting mechanism has been changed, however the original behavior can be re-instated by setting the environment variable SYBASE_SAM_CPUINFO=ORIGINAL
658122 The DBCCLOG command in sybmon is extended to support reading dumps taken on a server with a logical page size greater than 2KB.
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).

658298 Need to have some built-in function or global variable that could be checked by customer written tsql applications so that they might finish processing and let normal ASE shutdown with wait proceed.
658317 The DBCCLOG command in sybmon is extended to support displaying pre-15.5 ASE transaction log records.
658340 test and certify a version of ASE 15.5 for solaris 5.11
658430 The PR_DESCHAIN NHASH sybmon command does not print the

right information with regards to the hash by name table

of DEScriptors.

658449 "store_ind" syntax incorrect in AP example in ASE15.5 P&T
658621 Value of Severity columns in monErrorLog is 99 indicates it's a stacktrace.
658661 In some cases, there is certification error between ASE WebService and external webservice.
658668 A 692 error on syslogs is sometimes reported when loading a dump taken of a database that

was in standby_access mode.

658851 DOCCR: DDLGEN support password encryption, fixed by CR594606
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.
659124 After upgrade from ASE1502 to ASE15.5,any user not SA role can't access archive db which is dumped and loaded from ASE1502 onto ASE15.5
659161 Allow the output/result set returned by a stored procedure to be handled via a scrollable cursor
659334 Need feature request for counter of statement iterations
659335 Msg 9561, Level 20, State 1: Invalid pointer param number 2, pointer value
659485 A timelice error together with stack trace which includes module 'idt_value_verify' may occur when several rows are inserted into database, or inserting rows followed by retrieving identity value from the database, if BIGINT datatype is used for the identity column.
659498 SySAM requests double the required amount of chip licenses for Itanium 9300 series quad-core chips. When this is the case 'cpuinfo -v' displays the diagnostic messages "Family 32 Model 2" and "Family 32 >= 32. Montecito or newer, so dual-core".
659629 When the RepAgent configuration parameter 'rs password' is set

by executing the sp_config_rep_agent system stored procedure,

the password is logged encrypted to avoid it from being exposed

in clear text in the transaction log and during the replication

of this stored procedure execution.

659638 Feature request to eliminate the SELECT INTO dboption requirement when using ALTER TABLE to add a NOT MATERIALIZED computed column.
659661 Request a new feature which can always display a running process's outermost stored procedure name with parameter value(s).
659709 A stacktrace may be encountered when executing a MERGE statement involving a DELETE if there is a referential integrity assignment in the source table.
659910 Query with TOP, UNION ALL and ORDER BY clause could return fewer rows.
659912 If a query HASH joins a UNICHAR and UNIVARCHAR column and the joining values differ only by trailing blanks, then the row may not be returned.
659996 Under very rare circumstances, a task committing its transaction may go into an undetected

deadlocked condition with another task which is truncating the transaction log.

660022 A new system stored procedure is needed to convert the existing inline default objects

into sharable inline default objects and drop the remaining duplicate ones.

660060 sysquerymetrics is not recording information on some aborted commands.
660150 Some data rows might be missing from a table following a LOAD TRANSACTION of a transaction log that was dumped after the table was created by SELECT INTO when the "fully logging for select into" database option was turned on.
660152 A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is partitioned.
660173 A stacktrace may be encountered when executing a MERGE statement involving a DELETE if the source table is a VIEW with a GROUPBY clause.
660224 ASE/CIS to oracle ... convert function causes subquery performance prblm
660311 Less rows than expected may be returned when executing a query which joins 3 or more tables with All Pages Locking schema, there are some duplicate conditions in the WHERE clause and the SET SHOWPLAN ON output shows that it used a N-ARY NESTED LOOP JOIN operator.
660481 The recovery REDO pass at boot time or during LOAD DATABASE is unnecessarily slow in cases where there is one or more very long running transactions.
660563 A new interface is provided that enables ALTER TABLE DROP column DDL to optionally execute by deferring the time-consuming data copy path.
660729 LICENSE HEARTBEAT process down with stacktrace.

<environments>

Sun Solaris UltraSparc-T / Solaris 10 / Doesn't configure Logical Domains.

<WorkAround> Use 1 or 2

1) use SYBASE_SAM_CAPACITY enviroment ( sysamcap DEFAULT )

2) add solaris.ldoms.read role to sybase user.

660784 Signal 11 at LeScanOpM_LeOpAcquire6MrnHExeCtxt, LeNaryNLJOp::_LeOpAcquire(ExeCtx
660820 sp_helprotect does not consider roles inherited through login profiles when reporting permissions.

In addition, on a High Availability environment, when a primary fires a command to CREATE/ALTER/DROP login or login profile and if the command fails on the secondary, the TDS return

status of the command on the primary is still a success.

660837 Need an ability to select information from a stored procedure without first having to create a proxy table.
660956 In some cases, ASE WebService may hang while ASE WebService server is started with JRE6 distributed with ASE on IBM AIX.
660984 When a generated select query contains duplicate column names in the select list, then the query should be executed as occurs in ASE 15.0.3 ESD #1, provided that there can be no resulting ambiguity caused by the inclusion of an order by clause.
661262 workaround listed for ase1503esd3 on win2008R2 does not always work
661265 A 7105 error, "TEXT/IMAGE/UNITEXT page <page> does not have a next page" together with a stack trace may be reported when input text string containing partial character at the end is inserted into Adaptive Server which has the same character set as client by BCP...IN.
661425 Document the contents of the Job Scheduler history table
661452 Using control-c to terminate a batch that creates a temp table and uses INSERT SELECT to insert rows into that temptable may result in an orphaned temp table. Use DBCC ORPHANTABLES("drop") to clean up the orphaned tables.
661494 Under multi-byte character sets, selecting rows from text columns may cause more IOs comparing to single-byte character set.
661508 A 3478 error: "During undo the page timestamp value is less than new timestamp from log ... ", may be reported during reboot if a REORG REBUILD command was active at the time the server was killed.
661677 After a cross-platform dump-load, some of the histogram statistics, used by the optimizer, may be incorrect.
661716 The wrong syntax is included in the two following manuals.

Installation Guide Adaptive Server Enterprise 15.5 for Sun Solaris

Installation Guide Adaptive Server Enterprise 15.5 - Cluster Edition for Sun Solaris

Preinstallation Tasks for the Server Installation :

wrong: project.max-shm-memory=\(privileged,17179869184,deny)

correct: project.max-shm-memory=(privileged,17179869184,deny)

661802 Sybcluster always performances heartbeat check according to "quorum heartbeat retries" and will not stop even if the check if successful.
661814 Changing ASE config parameters can cause exception java.lang.NullPointerException at java.lang.String.compareTo(String.java:1168)
661819 Allow the ASE Web Services to support more than one output parameter
661974 With statement cache is ON and literal parameterization is OFF, when a string literal in a UPDATE/SELECT/INSERT/DELETE statement contains quotes and [ ] inside the quotes, if there are whitespaces after the right ], those whitespaces might be filtered out causing a wrong literal value to be stored in the statement cache text entry.
662014 Signal 11 can occur in the module 'th_curunreservedpgs' when an ALTER DATABASE is run at the same time the curunreservedpgs() builtin function is used.
662048 ADO.NET: A Decimal parameter with value of null is sent with Precision = 0, this query fails if ASE statement cache is enabled with message "Length or precision specification 0 is not within the range of 1 to 255.".
662152 ASE WebService will use jConnector-7_0 instead of jConnector-6_0.
662247 OEMs can now specify the directory used by DBISQL, Sybase Central,

DBConsole, and ML Monitor. To do this, you must deploy an OEM.ini file

along with DBISQL (et al). The file must contain the following lines:

[preferences]

directory=preferences_files_directory

where "preferences_files_directory" is a fully-qualified directory name,

e.g. "c:\work\prefs". The directory name should not end in a separator

(backslash on Windows; forward slash on Linux, Unix, and OS X).

Preferences files include:

.isqlPreferences12_32

.isqlPreferences12_64

.isqlHistory12

.jlogon12

.textCompleter12

.SybaseCentralEditor610

.scUserPreferences610_32

.scUserPreferences610_64

among others.

662338 IOTime in monIOQueue is incorrect for multiple engines server on Windows platform.
662402 Running an EXECUTE CURSOR query may hit SIGSEGV in s_compile() in case of recompilation, together with stack trace involving modules s_setupcursor(), curs_execute() and s_recompile().
662410 ARIES CE with >1 instance setup hits SIG11 inside function lock__mmaster_processque
662451 Issue a warning/error when SELECT INTO EXISTING is used on a local table
662458 Feature request for an xmlextract text() option to extract de-entitized string data from xml source. Currently, text() only extracts entitized strings.
662522 timeslice in function pgos_nextpgidsmap when doing create index in parallel
662586 ASE dataserver does not give page or dbid information with error 290024.
662591 Signal 11 at void LeSargArray::setupSargArray(proc_hdr*)
662923 sp_monitorconfig 'procedure cache size' can become inaccurate. Fixed via CR 644156.
662937 Provide global variable @@sbssav and ASE command line option --sbssav, returning a short standardized ASE version string.
663005 A cluster setup with more than 1 instance may encountered a signal 11 with a stacktrace involving the function 'lock__mmaster_processque'.
663109 Under some very rare circumstances, one of the cluster instances may abort with an infected with 11

message together with a stack trace showing module name 'dbt_rdump_action_pcm_callback'. This

may happen after a DUMP DATABASE command was interrupted or hit an exception.

663156 Feature request to have except action option for "sp_audit 'all','all','all"
663203 Error 2502, "Table Corrupt: A page is linked in more than one chain; check this page:page

number=<page number> allocation status=<status value>", followed by error 7968, "The object

allocation map for tabid <object id> indid <index id> partition <partition nid> is corrupt,

therefore the optimized report cannot be generated. Contact Technical Support for assistance.",

will be reported when running "dbcc textalloc" with "noreport" option multiple times.

663224 In some cases, ASE WebService cannot consume the WebService which has SOAP datatype parameters including soapenc:byte, soapenc:boolean, soapenc:long and soapenc:int.
663304 If an APL table has a unique CLUSTERED INDEX with all keys specified by constants and a non CLUSTERED INDEX is forced, then the join order will place this table at the beginning of the join order, bypassing costing, which could result in a performance problem. This behavior is fixed by optcriteria cr663304 or trace flag 16926.
663342 There could be a memory corruption during page allocation either in

case of a MLD database when another task is doing the allocation on

the same allocation page or with any database if the buffer for the

new page could not be allocated.

663359 A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified."

may be reported when running SP_HELP_REP_AGENT with no parameter values.

663436 An infected with 11 with a stacktrace containing functions infected fm_unlink_frame fm_free_frame fm_free_list if the server if the sp_configure setting for open databases is lower than the actual number of databases on the server.
663457 UPDATE STATISTICS actually executes when SET SORT RESOURCES is ON rather than just providing resource usage estimates.
663537 Create table with compressed LOB in imdb should fail but not now.
663600 Updating identity columns gives error 586: Illegal identity value specified for identity
663606 BCP-in performance on a large table having many indices is significantly worse than the performance achieved using 12.5.4
663628 Worktables will not be shown in monProcessObject.
663651 Two new fields (ssql_optgoal and ssql_optlevel) are added to statement cache entry, and two new columns (OptimizationGoal and OptimizerLevel) are added to table monCachedStatement.
663778 Make the statement cache maximum sql size user configurable.
663926 An INSERT into a table that contains computed columns which has been upgraded from ASE 15.0.3 may give Signal 11 (Access Violation) in norm3_expr().
663945 When creating a functional based index, data may get truncated when using CONVERT().
663967 Running a dynamic sql query may hit SIGSEGV in s_normalize() in case of recompilation,

together with stack trace involving modules s_reinstall_lwp_tree(), s_procinstall_lwp(),

s_recompile() and tdsrecv__dynexec_xoltp().

663977 syconfig from 15.5 ESDs fails with side-by-side error.
663994 Signal 11 could occur in CgEvals::_CgCompVcol(tree*) during

DistinctHashing operator code generation when there are

two distinct expression columns and one is becoming dependent on

the other through equijoin transitive closure. Using diagserver,

the assertion "Assertion (GcvIsVirtualColumn(pNode))" could fail

in cgevals.cpp line 202.

664112 sqllocres does not check for valid default language/character set/sort order attributes in the resource file.
664161 The message "current process infected with 11" in the module

'fglk__send_prom_attn' together with a stack trace which

includes the modules 'fglk__promote' and 'getnext' may be

reported in the error log and may bring the server down

if a query involving a big number of tables (more than 50)

was being executed in parallel and due to the number of

locks acquired it attempted to promote the locks to a

lock of a higher level.

664218 When sp_showoptstats is called with cross database objects, optimizer stats for that object is not returned and no error message is raised.
664266 Error: 8203 DES expected in DROP state in ssql__rmplans()
664291 Value of an empty string in date calculations is context sensitive
664361 Docs: clarify "sybase" user account is not literally "sybase"
664620 Suboptimal plan when use NOT in Subquery.
664621 Wrong result set in 1503 compatility mode with statement cache disabled
664703 A query against an MDA table such as monLocks may encounter a timeslice error in

VTABRemoteAccess::getNext() during a period of heavy user activity.

664714 Increase the limit on the number of historical configuration files saved from 999 to 999999999.
664830 Currently one can bind tables or indices to a cache. Partitioned tables can have very active partitions which one might bind to specific caches.
664833 Normally, if an attribute from a table

inner to an outer join is referenced in

a higher scope outer join or in the WHERE

clause, it would cause the outer join to

degenerate into an inner join since all

null extended rows would be eliminated. The exception

occurs with "null preserving" predicates such

as IS NULL which would not eliminate the row.

If a nested outer join exists where

a table is inner to an outer join and

an attribute of the table is referenced in second

higher scope outer join ON clause in a "null preserving"

predicate then a wrong answer could result when a mergejoin/hashjoin

is chosen for the higher scope outer join.

664848 In rare circumstances, the message "current process infected with 11 (SIGSEGV)" in the module 'ind__get_sysindrow()' together with a stack trace which includes the modules 'getindexname()' and 'CgGenLava::CGConsScanOp()' may be reported in the SAP ASE error log. This may happen when a statement, using temporary user tables or tables created in the same batch or stored procedure and with indexes defined, is being compiled before execution.
664877 CREATE INDEX on a large partitioned table may generate an excessive number of steps in

sysstatistics. A subsequent UPDATE STATS reduces the number of steps to an expected value.

664980 When option show_sqltext is turned on some sql statements like use db1, drop proc or drop table, exec proc1 are not traced properly, message like "No useful sqltext available" gets printed instead of the actual sql executed.
664984 When executing an INSERT-SELECT query from a proxy table having a LOB column into a local table, a NULL value may be inserted into a LOB column on the local table if a cursor is opened on any proxy table.
665006 Separate Audit Event for ASE and Backup Server
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

665170 sp_shmdumpconfig raises message 18502 when an "error" dump type is specified when "message" should have been specified. This CR is a feature request to find ways to reduce the confusion between the two types of dump conditions.
665201 The message "current process infected with 11" in the module 'rec__ctx_cleanup'

together with a stack trace which includes the modules 'dsinit' and 'rec__backout'

may be reported in the error log during ASE startup if a 708 error, "There is

insufficient system memory to run kernel task. spid <value>, kpid <value>."

was previously reported in the error log.

665247 A segmentation violation occurs with utilities certreq and certpk12 when the

password is provided as a parameter on the command line.

665251 DocCR : the style 14/114 is listed twice with different specs at BulidingBlock manual.
665257 Under certain circumstances, ASE may fail to boot under the UTF-8 nocase sort order and an 8211 error "Mismatch found between the name and id descriptor hash table for table..." may be seen.
665266 In an HA environment if sp_addexternlogin issued on a HA server to add an externlogin

for a non-ha server the following message will be issued by the companion server:

Msg�10330,燣evel�14,燬tate�1:

Server 'gree1_22760',燩rocedure 'sp_attrib_notify':

EXECUTE爌ermission燿enied爋n爋bject爏p_attrib_notify,燿atabase爏ybsystemprocs,

owner燿bo

665284 The message, "Current process infected with signal 11" followed by a stack trace that includes

the module Partitions::initHintsForDegree() may be reported when a remote procedure is executed with the recompile option.

665367 FR: support Sysam license server on a VMWare VSphere win2008 x64 SP2 that can host multiple licenses for multiple platforms and products.
665426 langinstall for non-us_english languages gives errors because several new messages have not yet been translated in their server.loc files.
665525 Error 221 is raised when UNION is applied to a view containing an outer join returning a BIT value from the inner table. The same error is not raised when tables are used directly.
665639 When 'statement cache' and 'literal autoparam' are configured on ASE the @@identity retains a non-zero value after an INSERT into a table that contains no IDENTITY column.
665651 If server has 'capture missing statistics' enabled, and if multiple parallel threads execute queries involving a column for which stats are missing, then all such threads would try to insert the missing stats; one of the threads would succeed, and the others would get 2601 error leading to

transaction and command rollback.

665658 Infected with 11 in EquivClass::eqcFindPdTreeLogProps
665666 Specifying "as template" in a sql select list incorrectly reports a syntax error.
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.".

665786 Sybase installation account on Windows must have membership of the 'Adminstrators' group to allow creation of Windows Services entries.
666213 The 15.x Monitor Server User's Guide indicates that a login named mon_user is installed on windows. This login is no longer installed or used as of 15.0.
666239 The limit for cache partitioning has been extended from 128 to 256.
666245 doc bug: CR 490866-3 doesn't show global cache partition limit as 128
666362 A signal 11 may be reported with a call stack involving the modules 'do_bt_release_rlocks' and

'rec_undo_session' while accessing the buffer address from an address lock of an APL page.

666371 TF2792 blocking on user table for select operation.
666375 New interface sp_chgattribute <objectname>, 'ptn_locking', 0/1 to enable/disable partition locking
666423 A 644 error and the message "Invalid DOL data row pointer ... must be the forwarded row location" is raised when using ALTER TABLE to add an IDENTITY column to a datarow table that has forwarded rows. Run reorg forwarded_rows and try the ALTER again.
666460 Parallel BCP connections on an indexed DOL table might block each other while loading data into the same data partition.
666556 Performance of sp_spaceused procedure is very slow when executed to get the space metrics for the entire database, especially so for databases with a very large number of objects and indexes. Improve the performance of this procedure by applying server-side changes along with a re-work of the procedure's logic. A new installmaster along with new ASE binary is needed to deliver this performance improvement. (The stored procedure changes alone are not sufficient).
666577 Cannot access Monitor Server counters from Sybase Central when SQL Server names are different in client and server side interfaces file.
666597 New Feature Request ... add indicator to monCachedProcedures to show active entries
666643 In rare circumstances, the extra convert() added on numeric columns in SELECT-list

with UNION ALL can improve the compilation performance in ASE 15.x.

666702 Run 3 or more session running unmount database can dead lock on sysdevices.
666720 If an index whose length is larger than 32767 is defined on a DOL table, some problems may be encountered when using the index.
666728 Update the Open Server Components of ASE to provide essential Open Server vulnerability fixes.
666814 Executing a dynamic SQL query may hit SIGSEGV along with stack trace involving modules sqt_relocate(), sqt_fix_xoltp() and tdsrecv__dynexec_xoltp().
666828 New Feature to use different method to determine if cluster takeover is possible.
667025 sqllocres reports sort order "binary" is not valid for character set "utf8".
667065 Under some rare conditions, queries with computed columns could cause stack traces involving the module 'add__computedcol' when using the table with computed columns.
667124 The current documented limit of 192 referential constraints is too low for the customers application and they would like this increasing.
667341 The FR required to allow BCP (and other ASE utilities) write the outputs to remote locations.
667487 When "procedure cache size" configuration key value is increased, Procedure Cache Pool is not honoring the Engine Local Cache trace flags while allocating the extra pages to engine.
667552 sp_sysmon might report wrong engines when some engines are offline.
667575 Allow object owner to run sp_showoptstats besides SA role.
667653 A query with disjunctive clause on a range or list partitioned table can produce wrong results due to incorrect partition elimination.
667691 An infected with 11 may occur with routines fastLoop and FrameNExecuteHelper on the stack while using JAVA.
667726 sp_helprotect truncates object and column names which are greater than 30.
667751 Support for UNIX Domain Sockets for ASE has been added for the Linux and Unix platforms.

Adaptive Server Enterprise version 15.7 ESD#4 and later now support the UNIX domain socket

communication, which avoids some of the overhead the TCP protocol incurs.

Similar to other protocols, include the AF_UNIX protocol in the interfaces file for clients to

connect to Adaptive Server. The syntax for an AF_UNIX in the interfaces file is:

master afunix unused //<hostname>/<pipe>

667894 Loading a database dumped from a 12.5.4 server as an archive database on ASE 15.5 or later may result in error 11060. This currently cannot be circumvented due to the read-only nature of the archive database
667923 A 290024 error, "Invalid column length: <number> Value must be between

<number> and <number> at offset <number>..." may be reported in the

errorlog when a session executed a trigger which contains a SELECT FOR XML

referencing INSERTED or DELETED virtual tables and previously the same

session had been executed a different trigger for a different table

but with the same SELECT FOR XML statement.

667943 In some cases, low throughput or poor performance may be observed during partially logged operations like BCP on indexed table or REORG REBUILD. sp_sysmon output shows high contention on dbt_seqspin spinlock.
667977 When a table in a VIEW is modified, multiple SELECT statements on the VIEW may return different results.
668088 Inaccurate memory allocation errors may be printed on startup.
668337 In rare circumstances, raising the error 712, Severity: 17, State: 3 when restarted ASE and

increasing the loads. Requires to increase heap memory per user.

668344 parameter declaration in sp_sysmon is incorrect
668380 When free lock pool resource goes below critical threshold, server goes to slow response state due to heavy spinlock contention.
668502 For a DOL partitioned table which has TEXT/UNITEXT/IMAGE columns, after alter table dropping

a column, executing DBCC TEXTALLOC on the table which still have some TEXT/UNITEXT/IMAGE columns will report 15918 error.

668560 Sybase Control Center to have option to configure the sender address in email alerts.
668576 Unsuccessful login attempts on ssl sockets generates ssl_close() SSLCLOSE() failed (-6989) errormessages. Would like the message suppressed.
668617 showplan reports Index name not found for temporary table
668638 The sp_opt_querystats stored procedure reports error number 17077 indicating that the optimizer diagnostic results were incomplete and does not generate any output.
668787 'avoid_bmo_sorts on' uses "index scan" plan for a query that does a 'select into' a #temp table. if the "select into" is removed then "access by key" is used
668790 An audit process exception error message may occur that reports the incorrect numbers. The full error number is reported as the major number, the severity is reported as the minor number, the state is reported as the severity.
668835 Executing a query involving sending LOCATOR with NULL value through TDS_BLOB may hit 'Type 0 not implemented' error, i.e. error 1622.
668846 PIOs, LIOs, and CPU for nested loop join index scans are

not reported in the estimated cost diagnostics (statistics

plancost) for parallel optimized strategies.

668909 When creating a lightweight procedure, if all negative object IDs are used up, the 2012 error message is not reported.
668967 Sub optimal query plan allrows_oltp vs compatibility mode for sub query.
669091 In some cases, after loading a transaction dump which was taken after a fully-logged ALTER TABLE command was executed on an all pages-locked table that has multiple data pages, dbcc checktable on the table reports error 2583 because the number of data pages counted by dbcc is different from the count in the data oam page.
669194 A stored procedure, created with 'deferred compilation' enabled, that accesses cross database views and creates temporary tables may raise error 208 '<#temp_table> not found.' incorrectly.
669301 In rare circumstances, the message "Invalid column length: 12. Value must be between 0 and 10 for 'all-pages' row with minimum row length of 64" together with a stack trace which includes the modules 'collocate' and 'translate_varcols' may be reported on a 64 bits ASE on IBM AIX, when the datbase was loaded from a dump of a different platform.
669413 Backup Server is enhanced to provide support for the MOUNTWAIT option for Tivoli Storage Manager. This option is off by default. It can be turned on by virtue of using the new 朚 option in the DUMP DATABASE or TRANSACTION to 搒yb_tsm::-M::<object_name>� commands. Additionally in the LOAD DATABASE or TRANSACTION from 搒yb_tsm::-M::<object_name>� commands.
669429 Infected with 11 in function testpasswd following an upgrade.
669434 optimizer chooses bad join order with partitions on large dataset
669447 executing the installer in console mode stacktraces when using

relative pathname that includes '../'

669482 Query search fails on utf8 ASE 15.5 with like clause and cursor. Customer using Hibernate/Spring with jConnect so unable to modify internal JDBC Code to work around the problem.
669573 To support LVM for ASE CE
669592 When sp_extrapwdchecks is installed in the master database, adding or changing a login password to one containing single quotes fails with errors 102, 105 and 17720.
669730 Logical errors when parsing complex abstract plans
669736 Large text and data segments are not supported on HPIA64 platform.
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.
669925 Different behaviour when no login trigger present and login trigger not found
669932 With using Sybase Central ASE Plug-in, the Web Services SSL Configuration wizard fails with the error, "ERROR: Could not find java executable at null/bin/java. Please verify that a valid JRE installation exists."
670074 High spinlock contention on Resource->rdbts_spin and Dbtable->dbt_seqspin when running concurrent BCP IN jobs against a partitioned table.
670150 Under certain circumstance, when 1204 error happens, SA/SA role can抰 login to adjust the number of locks
670168 The minimum recommended stack size is a little too small for many operations. The stack size configured on Solaris platforms should be larger than the minimum recommendation for ASE 15.x servers.
670169 Sybase Central ASE Plug-in does not allow browsing 'User Tables' in a database when it contains a table that is marked 'for load'.
670199 A signal 11 could be encountered with a stacktrace involving the function ResRelOp() called from CgpDistinctSorted::_cgpInit() when a DISTINCT VIEW with an expression DISTINCT SELECT column is queried with a constant equality predicate over the expression column and the final plan chooses DistinctSorted operator.
670223 Support rebuilding off-row LOB through REORG REBUILD, if compression level has changed.
670273 In some circumstances, the Operations value in the monOpenObjectActivity MDA table does not reflect the actual number of table accesses.
670275 ASE may allow four reader tasks to skip over a queued update task in lock sleep if the readers are trying to obtain a shared intent lock.
670302 Adaptive Server on AIX-64 platform may cause illegal instruction errors and core dump when using a served license or an unserved sub-capacity license.
670310 The message "PCI(M1): pcidb_get_pci_directive_arg() : Unable to select the arguments for PCI

Bridge directive PCI_BRIDGE_X_OPT." followed by the message "current process infected with 11"

in the module 'pci__cfg_plb_options' together with a stack trace which includes the modules

'dsinit' and 'pci_cfgmgr_init' may be reported in the error log during ASE startup whose

logical page size is greater than 8K if ASE first reported an error during the recovery

of a user database and the configuration option 'enable pci' is active.

670327 Enhance dbcc checktable to capture invalid column length beforehand
670337 srvbuildres issue warning unable to verify raw device sizes
670398 ASE could hit timeslice error while zeroing out the device during the 'disk resize' command.
670498 sqldbgr routines don't check for abnormal termination of procedures
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.
670530 The Job History Output table has extra new line added after each row of the results obtained from the target server.
670587 614, 644, 2610 error etc may be returned due to the non-clustered index leaf page corruption

if max_rows_per_page is set to 1 for the non-clustered index on APL table.

670854 The datediff() function may produce incorrect results when comparing a string literal or bigdatetime with a smalldatetime datatype.
670889 Cosmetic issue

In a XML model, the Orientation display preference options are misaligned.

To reproduce:

1) open a XML model

2) select Tools\Display Preferences

3) Select General setting and General tab

Note: for the Orientation section, the Horizontal option appears to centered vertically and the Vertical option appears to be set to 'Bottom'

--EOF--

  • 本文链接地址:http://www.sybrepair.com/sap-ase-cr-number-6.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《SAP Adaptive Server Enterprise的所有已知BUG列表(6)》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)