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

随着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
279309 Using BCP with packetsize larger than 32767 may fail on ASE running on the windows NT, Linux and Dec Alpha platforms.
279344 ASE Replicator: Sporadically, text/image replication fails when running for a long time.
279406 A 551 error or the message "current process infected with 11" is reported in the error log together with a stack trace when a row is inserted into a table that has a rule which references a constant value which is outside the range of the column datatype.
279474 Check constraint expression shows name of the constraint along with the defination. This happens only when user changes the constraint name in the property page and applies the changes.
279520 When a connection is terminated while running Java, the message "Java services are temporarily unavailable while the Java system is being recycled" is reported in the error log and all other Java operations may be terminated so that no further Java operations can be performed. All subsequent attempts to use Java in ASE are rejected with a 10734 error.
279558 CIS : Performance slows down when there are many idle CIS connections within ASE.
279568 The message "current process infected with 11" together with stack trace which includes the module 'jvmh_mem_p_sema' will be reported in the error log if a reference is made to a Java class before recovery has completed.
279595 If the source ASE has large free spaces in the logical devices and runs Migration Tool in "setup" session, Migration Tool will throw the IndexOutOfBoundsException error in "CALC_DEVICE_SIZE" thread.
279606 ASE 12.0 used to send back the actual table name in the row format information when responding to PowerBuilder. Now with ASE 12.5 the view name is sent back in the row format information instead of the actual table name and this causes PowerBuilder to try an update against the view instead of the actual table.
279616 ASE Replicator: During initial setup, an instance directory is created and RUNinstance scripts are generated. On Unix, the RUNinstance script also has its permissions changed to include execute permission. If there is a problem setting the permissions, an uninformative error message is returned, and the sp_helpddb.sql script does not get generated which causes problems later on. Now, the sp_helpddb.sql script is generated first, and, if there is any problem setting permission on the RUNinstance script, a warning is logged in the system.log, but setup completes successfully. The user will have to manually set the proper execute permissions on the RUNinstance script.
279617 A request to allow aliases to the real server name

to be used with kerberos network based security feature

279641 This is a test
279816 This just removes the conditional line that would only add a flatfileRepositoryXML if there hadn't already been one added. In this regard, we always add one now. This will be a problem if there are ever two instances of the RepositoryInfoPanel in a single Wizard Tree. Not very likely...

RepositoryInfoPanel:

-Removed the conditional inside the build method that controls whether or not we add the xml file as a resource.

-Removed all other references of the boolean.

279855 When a table in a DB2 DRDA Direct Connect has a VARCHAR column greater than 255, a SELECT statement that has a joins involving the VARCHAR column will fail.
279862 Incorrect limit of AND and OR in a query is returned in 404 error messege,

as if the query exceeded the limit of 1024. The real limit is 300.

279883 Performance enhancements made to SELECT INTO by making use of large I/O and extent

allocation for the target table, wherever possible. As a result, SELECT INTO may

choose the largest I/O size possible for the target table, based on the size

of the buffer pools available in the target database cache. ASE 12.5.0.3 will

have this option on by default. ASE 12.0.0.7 requires the use of -T5304 to activate

this enhancement.

279902 The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."

maybe reported when executing a SELECT INTO statement using

views in the FROM clause together with a UNION and a GROUP BY clause.

279928 On the AIX platform, during situations of heavy I/O activity, ASE may report 823

errors. This occurs on the Regatta family of servers and is fixed by IBM APAR IY38226.

279964 Process hit on error 1295 and sometimes some processes are blocked due a 'latch sleep'
279981 In rare circumstances, a 6902 error may be reported when recovering an aborted transaction at boottime or during LOAD DATABASE or LOAD TRAN, after an earlier stack trace was reported in the error log at runtime which included the modules 'terminate_process', 'hdl_default', 's_handle', 'ex_raise' and 'rec_undo_session'.
280035 In rare circumstances, a 2620 error may be reported during the reboot of Adaptive Server if it was terminated abnormally whilst LOAD TRANSACTION was in progress and it had recovered an index page split.
280052 A SELECT with an aggregate function containing a subquery on a proxy table mapped to a MS SQL Server table results in a 30291 error "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."
280073 In rare circumstances, Adaptive Server may generate wrong results when executing extended stored

procedures with parameters where no parameters were defined in the extended stored procedure

declaration list.

280089 Under some conditions the optimizer may incorrectly assume that a scan is able to use I/O greater than 2K thus underestimating the cost of a plan.
280090 ASE only sends out ENVCHANGE token when client is requesting a different character set from server's

and character set conversion is enabled.

280099 7411, 7417 or 7418 errors may be reported by DBCC CHECKCATALOG when checking a database that has a non-dedicated log and which contains user table extents in its log segment.
280133 A stored procedure will sometimes be unnecessarily renormalized when it is run on a 32-bit server having originally been created on a 64-bit server.
280148 Executing a select textvalid(<image-column>) of a proxy table mapped to Oracle in a server configured for the utf8 charset caused a stack trace (current process infected with 11) in routine omni_parse_name.
280177 The use of CIS connections with SSL is fixed on Linux 32bit platform.

CIS connections are used by Replication Agent, Proxy Tables, and

CIS RPC calls, therefore SSL can be enabled to work with Replication

Agent, Proxy Tables, and CIS RPC calls.

280196 User with "sa role" but without "sso role" can incorrectly execute

SP_ADDLOGIN, SP_DROLOGIN and SP_LOCKLOGIN stored procedures.

280231 Added support to srvbuild for Linux ATARAID, RAID and LVM devices.
280237 Executing an ALTER DATABASE ... FOR PROXY_UPDATE command resulted in a stack trace (current process is infected with 11) in routine omni_parse_name when the server was configured for the utf8 character set and the remote server was Oracle.
286067 The automatic drop of a temporary table may sometimes fail with a 216 error together with a stack trace as a result of an incorrect 3702 error, "Cannot drop the table because it is currently in use".
286077 Setting the 'close on endtran' option in a session may result in error 559 or

102 when a SQL query involving proxy tables is executed.

286078 255 error may be returned for a grouped aggregate query with space() or replicate() builtin function.
286082 A select query by a view referencing a proxy table fails with 4409 error

when a 'between' clause is used in conjuction with a correlated subquery

Status: Reviewed Sep 2002. Fix targeted (but not commited) to the 12.0.0.7 release.

286098 The occurrence of SIGURG (typically as a result of old style pre TDS5
cancel command) may result in ASE hang.
286136 Allow elapsed time resource limit to fire whether spid is issuing sql or not.

Status: Reviewed Sep 2002. Feature targeted (but not commited) to the 12.6 release.

286187 Create proxy_table command against ASA/ASIQ may sometimes change the order of columns.
286191 The login audit event is extended to contain additional information such as the IP address where the login attempt originated. This feature can be disabled using the command line trace flag -T7603.
286346 Pre 12.5.0.3, on Digital True64 Unix, only synchronous i/o was supported for file system devices. In 12.5.0.3, asynchronous i/o on file systems is supported.
286418 Starting with ASE 12.5 GA, TEXT columns modified on ASE would not have replicated correctly. They would have meaningless values such as '/00000016\x01'. IMAGE columns would replicate correctly. TEXT columns now replicate correctly.
286421 The fix displays percentage completion for dbcc gam().
286430 While reading the SYSGAMGS table, error 691 is encountered with a request to

to read page 0 (object SYSALLOCPG); this error occurs when there is a corruption in

the SYSGAMS extent allocation.

286432 Missing SYSGAMS extents are not detected until a session tries to allocate

space in the device fragments with no SYSGAMS extensions; this attempt

results in a 605/691 error accessing a page for object SYSGAMS.

286438 Introduced new group on sp_sysmon for ASE replication agent performance and tuning analysis.
286499 CIS: The identity value does not increment when the command SELECT <select list> INTO <local table> FROM <remote table> is executed and an identity column is specified in <select list>.
286576 EFTS: query on text index using a mix of sequenced operator index_any columns and non-sequenced operator index_any columns returns invalid results.
286613 In rare circumstance, a query which includes a LIKE clause and that uses the Dynamic OR strategy can return incorrect results.
286644 Doc Set to reflect changes to buildmaster and sybinit utilities in ASE 12.5 and later. More detailed info in http://my.sybase.com/detail?id=1016939
286674 When ASE is configured for High Availability on Sun Cluster3.0, (1) the fault monitor program doesn't work if the environment file SYBASE.sh is not present in the specified location and (2) modifying any resource property fails.
286675 When ASE is configured for High Availability on Sun Cluster3.0, the fault monitor program doesn't work if the interfaces file is not present in $SYBASE.
286717 "Error: 1515, Severity: 20, State: 1" is found in the error log when a parallel

query generates a sorted worktable on an object with an index generated

from presorted data. Functions 'mjoin_open','pll_sort_open', 'sam_gen_distmap',

'sortclean' will be found in the error log.

286718 Ability to reserve at least one user connection for SA that can always be used to login to ASE, even if the user connections are all being used. This should allow sa to login to the server and maybe rectify the problem or shutdown gracefully.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

286719 This bug fixes the refresh issue on the summary panel. I had to change the InstallationSummaryPanel to remove _subPanel from the content pane and then re-add it every time we hit the entered method. This allows for re-calculation of activated products, and then draws them to the screen properly.
286723 Support added for IBM's HACMP / ES under AIX 4.3.3 for ASE 12.5

Requires: AIX 4.3.3 Maintenance Level 7, HACMP/ES 4.4.1 (with its prerequisite RSCT)

and two patches - APAR IY26561 & APAR IY26492.

286756 On various properties/wizard pages where a file path is needed, the browse button is disabled when the server is not running on the local host. Also a warning message tells the user that the path entered is relative to the remote host.
286771 Table Properties under Lockings Tab, option text is corrected to "Reserve page gap" from "Reseve page gap"
286788 ASE Replicator: If there is any mixed case or upper case in the fully qualified primary article name, then trying to add a replicate article that includes image/text columns for that primary article will fail.
286789 ASE Replicator: Replication of images greater than approximately 16K fails -- only 450 bytes are replicated.
286794 Feature request to have sp_help show what datatype a user-defined datatype was declared as. For example, a datatype declared as a float(8) actually is stored as a real; sp_help currently shows that the datatype is a real with no way to reverse-engineer that it was actually declared as a float with a specified precision.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release.

286862 With "sort_merge" enabled, the optimizer may sometimes fail to choose a cheaper non-merge join plan.
286906 The message "current process infected with 11" in the module 'n3__get_sig_size' may be reported in the error log

when an access rule based on a non-existant Java user-defined function is bound to a table column and

this column is accessed via a subquery.

286939 In certain situations, trying to do an UPDATE to a row on an ALLPAGE locked table where the page already has 256 rows in it, may result in a 2620 error - "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page: <pageid>."
287000 A 3944 error is reported when using a view, trigger or stored

procedure that requires recompilation and the database is

in READONLY or STANDBY_ACCESS mode. Likewise, the view,

trigger or stored procedure is unnecessarily suspended temporarily

when a QUIESCE DATABASE command is active.

287087 A 692 error, "Uninitialized logical page '<pageid>' was read while accessing

object '14' in database '<dbid>'" may be reported in the error log when the database size

exceeds 2016 GB.

287133 When a SQL Query on a proxy table is executed

using JDBC interface, it may result in error 103,

if the columns in a table are of length greater than 28 bytes

287215 Remove "The highlighting feature is no longer supported." from EFTS - Chapter 6 (What's New in Version 12.0.1),Installation and Release Guide states.
287221 ASE Replicator: Text/Image replication fails in cases where the LOB columns either precede or are interleaved with primary key columns in column order. In the case where all primary key columns are followed by the LOB columns, replication succeeds.
287224 list_appcontext ('contextname') raises error 11021 if less than 2 arguments are passed to the function
287236 Feature request. Tempdb space and transactional elapsed time resource limits are enforced outside of their timerange.
287353 "NEW" is a Potential SQL92 Reserved Word, that is the reason why, it does not have the same restrictions as a T-SQL reserved word. ASE 12.5 Ref guide, Vol 1 Chap 8 http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/refman/@Generic__BookView

lists "NEW" as a T-SQL reserved word and is erroneous.

287392 CIS: In rare circumstances, a SELECT INTO statement which includes outer join of proxy tables may return wrong result.
287401 In rare circumstances the message "current process infected with 11" may be reported in the error log together with a stack trace which includes the module 'a_rgused' when processing a query that contains an aggregate within a subquery.
287419 The script "$SYBASE/$SYBASE_ASE/bin/sybmigrate" is changed to use Bourne Shell because not all platforms have Korn shell.
287474 When ASE is configured for High Availability on Sun Cluster3.0, if any error condition occurs (because of incorrect configuration, such as -e option not specified for dataserver in RUN_server_file) the fault monitor program doesn't exit properly. Because of this, the fault monitor program keeps loading and exiting infinitely without doing its job, i.e monitoring ASE and taking appropriate actions such as restarting/failing over ASE as and when required.
287501 An 806 error may be reported, or DBCC CHECKTABLE may report 7951 or 12953 errors on text pages that originate from a pre-12.0 installation and which, subsequent to upgrading to 12.0 or beyond, have been the target of an UPDATE or DELETE operation that has been rolled back. This differs from CR 276568 in that it fixes text pages that have already been incorrectly modified. CR 276568 fixes the original problem.
287505 Feature request to remove or make configurable the limit on the size of the symbol table, which limits the number of variables allowed in a batch. Error 1908 is currently raised if more than ~2-3 thousand variables are declared in a batch.
287513 Need Sanitized customer visible description for this CR as this CR has been referenced

in 12.5.0.1 ESD#2 and later Coverletters.

287524 A 7928 error "Index <value> is not consistent; found <value> leaf rows

but <value> data rows. Drop and recreate the index." may be reported

by DBCC CHECKTABLE on a Data-Only Locked table after having created

either a CLUSTERED or NONCLUSTERED index with the SORTED_DATA

option but ASE was first shutted down with the NOWAIT option.

287559 "NEW" is a Potential SQL92 reserved word . The row referencing NEW in spt_values should be removed.
287585 An incorrect result may be returned by the MAX() aggregate function when the clustered index on an all-page locked table is used to determine the value and the configuration parameter "allow backward scans" is set to 0. Similarly, the MIN() aggregate may return an incorrect result using a descending clustered index.
287659 Proxy Tables can be created on all allowed non-ASE datasources like Oracle, DB2, ASIQ, ASA, MSSQL Server.
287661 There is no option to map a role to a remote login(a login in a remote server).
287681 During procedure I/O monitoring, the messages "**NoObject**" and "**NoDatabase**" may clutter the Historical Server output.
287734 Feature request to enhance ALTER TABLE so it can add BIT columns to a table.
287739 Use of a host variable in lieu of an identifier in parameterized

language statements (e.g. "use @p0") required that the host variable

be supplied using a datatype of CHAR or VARCHAR. Henceforth, the

host variable may instead be supplied using a datatype of UNICHAR

or UNIVARCHAR (assuming the requirements for use of these datatypes

are met).

287744 A negative or zero value may be incorrectly reported as the percentage completed during the undo or redo recovery passes, respectively.
287778 On a multi-engine server, the transaction start time from the syslogshold table may get ahead of the OS time.
287810 Sybase Central ASE Plugin: does not support connection to servers that contain space characters in the network definition of the SQL.INI interfaces file.

Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release.

287816 Sybase Central ASE Plugin: does not support connection to servers using the $BASE$00 syntax in the SQL.INI interfaces file.

Status: Reviewed Sep 2002. A Fix is currently not scheduled, but the issue will be considered at the time of the next release.

287845 A feature request to remove the limits on the number of tables per query (50) and the number of subqueries per query (16), making them unlimited.

Status: Reviewed Sep 2002. Feature targeted (but not commited) for the 15.0 release. While the implementation will not be unlimited, it will be relaxed to a very large extent.

287899 xpserver: "Recursive calls to srv__seterr()" may be entered into the xpserver errorlog when executing xp_logevent.
288059 The stored procedure sp_statistics always returns a 'collation' value of "A" for both ascending and descending index columns.
288066 The error message "I/O error detected for device" is sometimes displayed on IBM platforms.
288092 When running a SELECT query that has a UNION of more than 250 columns in the select list, the

query may hang or return wrong results.

288099 ASE optimizer is not able to perform statistics interpolation for char and varchar

datatypes when server's default sort order is different from binary.

As consequence some queries may be executed using suboptimal plans.

288100 The Large I/O effectiveness section under the "cache summary" section

gives incorrect values when the page size is > 2K.

288109 ASE encounters java.lang.NoClassDefFoundError when multiple java sessions started concurently.
288146 If users run "asecfg" without having the "DISPLAY" environment variable set, segmentation fault will occur.
288167 In very rare cases, during failover, 692 errors may happen on objectid 31. This may cause failover to fail during mount of the master_companion database.
288168 The message "Msg 10334, Level 18, State 135: Line 1:

Permission related internal error was encountered.

Unable to continue execution." will be reported by

the stored procedure sp_helprotect if DBCC or

SELECT GET_APPCONTEXT|SET_APPCONTEXT|RM_APPCONTEXT|LIST_APPCONTEXT

have been granted to any user or role, and auditing

is enabled.

288186 If process which has initiated a shutdown is killed with kill spid command, the shutdown does not happen , but new connections get problems
288226 User can enter default, identity or in row/off row for a column in Table Editor.
288241 The EFTS will now return an integer value for the total number of documents that match the search criteria. This will be returned in a new pseudo column called total_docs.
288291 When "tempdb_space" resource limit is exceeded and client is killed the corresponding

message with the reason is not sent to the client immediately. The message is now

sent immediately to the client.

288339 CIS: The message "current process infected with 11" in the module 'getnext_ctlib_subst', together with a stack trace may be reported in the error log when a client process exits abnormally, or a network error is encountered.
288379 Some error messages that used to report object id were updated to also report partition id if they

apply to single partitioin.

288408 If ssqueue was running in verbose mode, replicating char or varchar columns that contained a percent sign, "%", would have caused ssqueue to crash. This problem has been corrected.
288436 In the Migration Tool, user can not select to migrate the "Server Data" if the target ASE is on NT platform.
288442 Able to read ASE interfaces that contains empty line feeds or interfaces that contains comments symbol # between entries
288467 When updating an ASE resource property (with the command scrgadm -c ) in Sun Cluster 3.0,

if the resource property name is not specified in exact case, the update will not give any

error eventhough the supplied value for the resource property is invalid/wrong

(and hence the ASE resource might not work as expected).

288468 Bulk copy in to a proxy table may result in few rows or no rows being transfered to remote table.
288483 sp_monitorconfig "number of locks" reports number of lock structures allocated rather than number of locks allocated. It takes 3 structures for each lock allocation.
288502 Wrong data may be returned when select from a proxy table and the local server has default character length bigger than remote server (i.e local server utf8, remote server iso-1) this happen if the character received by local server will be converted to more bytes.
288522 Implemented memory management hints to increase the performance of sort with
large configurations of "number of sort buffers".
288545 For database properties under the General tab, if user attempts to change the creator of that database and select the creator's properties on the "Select a user for the creator" dialog. User will hear a "beep" sound and prevent him/her from accessing the creator's properties page. This problem is fixed.
288557 Once a database is restored from backup, there was no means of bringing it online using aseplugin. Now a 'Online' context menu is added to database, facilitating this.
288566 srvbuild utility fails on Tru64 version 5.1a
288620 The Asynchronous disk I/O subsystem within ASE is equipped with an
additional traceflag allowing for instrumentation on initialization
and erroneous o/s conditions. (-T1640).

The Asynchronous disk I/O subsystem changes are generic towards Sun
Solaris 8 and Linux RH7.2 and RH Advanced Server 2.1 and up where both
platforms by default follow a Kernel Asynchronous disk I/O strategy and
where not supported fall back on the (RT) Posix Asynchronous disk I/O
strategy. The use of (RT) Posix Asynchronous disk I/O can be forced by
booting the server with traceflag 1630.

288631 For Database Device properties tab, change sentence from "First Virtual Page Number" to "First virtual page number" and "Last Virtual Page number" to "Last virtual last number"
288643 Database Device properties under Mirror tab, radio button text is corrected to "Disable temporarily" from "Disable temporary"
288648 A 10330 error will be incorrectly raised when SELECT permission

has been granted to read from a table, but the table name is a

built-in function name.

288675 Foreign Key Wizard, correct title to "To Which Columns Does it Refer" from "To Which Columns Does its Refer"
288768 User having permission to execute sp_modifystats can run the SP on any table without checking the permissions of executing user on the target table
288781 On Solaris 7 Operating System, occasionally SIGALRM signals may not be delivered to ASE 12.0

(any 12.0 version) as expected. This can result in sp_sysmon encountering "Divide by zero occurred"

message or sp_sysmon hanging. The SIGALRM issue has been identified by Sun as an error in the

Solaris operating system, Sun Bug ID 4716436. Contact Sun Support for resolving this problem.

288788 Enhanced sp_who output to include the name of the temporary database

used by the spid.

288811 In Migration Tool, if user doesn't fix the warning server configuration values in the "setup" session, he or she will not able to continue nor restart the session. The user would get the error msg "Attention: Summary configuration check failed." and can not continue.
288820 A 'Code' panel is available to view the code of the compiled objects (views, stored procedure, etc.).
288821 SQLJ Function Properties, correct title to "SQLJ Function Properties" from " SQL Function Properties"
288824 DDLGen performance is poor when a database contains a large number of objects.
288933 ASE certificates with chains longer than 1 fail SSL handshake.
This fix incorporates SSL Plus library v.3.1.5 into ASE.
ASE must be used with the corresponding OCS release using SSL Plus v.3.1.5.
288952 If a user is bound to a specific engine via the logical process manager and that engine is in a DORMANT state at the time the user logs in, then the user process will hang.
289047 The message "WARNING: memory usage in procedure headers (<value>) does not match
memory usage count in Pss (<value>) for server process id <value>." may be reported
in the error log when a cursor including an ORDER BY or DISTINCT clause needs
to do a sort.
289060 ASE responds to the client app in a way that causes the client application to hang or coredump. It should be passing back an error message like

"ORA-00932 inconsistent datatypes..dco12_5ss"

Reviewed Nov 2002. Fix is targeted for a future (as yet undetermined) 12.0.x release.

289076 After an attempt to initialize a connection to a remote server fails due to network problems,

if that remote server is rebooted, then further connection request from ASE to that remote server

fails with 7210 error. ASE must be restarted before users can once again connect to that remote server.

289162 ASE Plugin (Java): Sybase Central does not support changes to CHAR type configuration parameters such as DEFAULT UNICODE SORTORDER.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

289168 The message "current process infected with 11" together with a stack trace that includes the module 'lt__skip_upd_image' may be reported in the error log when DBCC LOGTRANSFER processes a data-only locked table that has a TEXT or IMAGE column.
289175 Feature request: enhance the optimizer to choose large i/os when executing an 'insert into select from' statement where the select is estimated to return many rows.
289178 RPC fails when executed using uid with exec privileage, fine with sa uid. This seems to be the behavior when you implement 'Mapping all remote logins to one local name'
289184 An 8201 error, "Keep count of descriptor (objid=<objid>, dbid=<dbid>) was expected to

be <count1>. Instead <count2> was found" may be raised after an ALTER TABLE LOCK command

run for a user table marked for replication has been interrupted.

289253 When upgrading, the default permissions on the 'sysxtypes' and 'sysjars' system

tables are only established in the master and model databases and not in any other

databases. The setting of the default permissions on all system tables in all

databases is now done once only, as an upgrade step.

289287 Variables defined as java datatypes can lose their values and become NULL following an error.
289330 CIS: The commands ALTER TABLE <table> MODIFY, ALTER TABLE <table> DROP or ALTER TABLE <table> ADD may not work properly in an HA environment when the command is executed from the secondary server.
289343 When sp_commonkey and sp_foreignkey are executed against unichar and univarchar columns, error 17566

17394 are raised.

289413 Sub-optimal performance may result during the execution of

a stored procedure that uses SET ISOLATION LEVEL statement

together with conditional statements and that also accesses

temporary tables (#<table_name>) which haven't been created

inside this stored procedure.

289456 New functionality to support Active Passive HA Configuration on Sun Cluster3.0
289547 Made the HashMap that I used to store tabs in a TreeSet with a custom-build comparator that ensures the "Normal" tab gets placed first (or returned first) whenever sorted in the map.
289550 When ASE and Repserver are configured on the same host and Repserver is down,

every attempt by RepAgent in ASE to connect to RepServer leaks one file descriptor.

This can eventually lead to "kernel nopen: accept, Too many open files" error followed

by 1605 error "server Failed to open virtual socket for new connections".

289574 When checkstorage/checkverify is aborted after completing the check
the error message will indicate that sp_dbcc_patchfinishtime can be
run to set the finish time. All required arguments for sp_dbcc_patch_finishtime
is also reported in the error message. This allows users to patch the finish time
if they want to run subsequent operation on the results of this operatin.
289585 Extend dbcc checkverify() to support table level checkverify
by specifying the table name along with the database name.
e.g. dbcc checkverify(testdb, mytable)
289592 A 4324 error may be reported together with a stack trace that includes the module 'check__ldx_time' when LOAD TRAN <db> WITH UNTIL_TIME is used to load a dump that was taken without the FOR STANDBY_ACCESS clause, but which follows the loading of a transaction log which was taken with the FOR STANDBY_ACCESS clause.
289602 ONLINE DATABASE may not roll back uncommitted transactions as

expected after either loading a transaction dump that was dumped with the

NO_TRUNCATE clause or loading a transaction dump using the UNTIL_TIME clause.

289627 Feature request to have ASE support ON DELETE CASCADE referential constraints
289681 When running Migration Tool in GUI mode with "-m setup", "-m migrate", or "-m validate" argument,

the Migration Tool throws a "NullPointerException" error if the "Back" button is clicked

from any of the windows.

289693 CIS: Added direct_connect class capability for identity column support.
289715 When an ASE client is killed (for example using Operating System kill command), its corresponding

ASE task is not removed from the ASE and it continues to run the query consuming resources.

289719 The message " Msg 10707, Level 16, State 1: Unhandled Java Exception: java.lang.NullPointerException"

can be reported when calling the method registerOutParam() for a datatype of java.lang.Types.JAVA_OBJECT.

289763 str() function returns NULL when the length parameter is over 255.
289781 desedit does not properly handle interfaces files named like "interfaces.new" , "interfaces.old"

Reviewed Dec 2002. Fix is targeted (but not committed) for the 12.5.1 release.

289788 If a partitioned APL table has a clustered index, and the first few partitions are empty because of row deletion, dbcc checktable will report 2584 error.
289802 Incorrect results may be obtained when using the REVERSE builtin function on BINARY

data and Adaptive Server is configured with a multi-byte character set.

289837 In rare circumstances, the message "current process infected with 11"

in the module 'th__check' together with a stack trace which includes the

module 'th_log_lct_reserve' may be reported in the error log.

289854 CR 268273 caused performance problems with CREATE INDEX and UPDATE STATISTICS in 12.0.0.5 and 12.0.0.5 ESD 1 when run on large tables. This fix removes CR 268273. A new version of the fix will be available later under CR 288522.
289867 Feature request to add a system stored procedure that displays all logins granted a specified role.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

289879 DDLGen use to fail generating DDL for a default, that had comments pre-pended to the defination.

The error that was thrown was

"The specified Default is a system generated one, whose DDL cannot be generated : <def>".

289901 Columns with dataformat=CS_FMT_NULLTERM in an Open Server application will cause Msg 11213...Column count mismatch when attempting a create existing...against the table in the Open Server applicaton.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

289920 A column defined with a user defined datatype that has an access rule based on it fails

when being accessed within a subquery, generates an error 207.

289966 Occasionally during shutdown of a busy HA system, the HA session of a connected client may be inadvertently removed, causing the client to receive the following message when it attempts to fail over to the secondary server: HA Login failed. Session handle not found (sys:n ses:nnnn)
289990 On Compaq Tru64 platform, ASE requires ssm_threshold=0.

If gh_chunks tuning is desired, the following guideline can be followed.

If gh_chunks is non-zero, shared memory page size is promoted from default 8KB to 4MB,

and those pages can ONLY be used by ASE and are wired down at boot time.

The value for gh_chunks (number of 4MB pages to be wired down) can be calculated as

"max memory"/4MB (for pre ASE 12.5 releases, "total memory"/4MB) rounded up.

For example, to allocate 2GB for ASE, set gh_chunks=(2048MB/4MB)=512.

289999 The message "process infected with 10" may be reported in the error log together with a stack trace

which includes the modules 'senderror', 'd_upgradeobj' and 'exec_dbcc' if the command DBCC

UPGRADE_OBJECT is used to upgrade a compiled object containing a view on a table which does not

exist.

290024 User message for failure of engine offline command is not descriptive of the reason for failure and needs to match the corresponding message logged in the error log
290041 In the "Available Database Devices" dialog box of Create Database wizard, the default size of database will be the larger of the size of the model database or the default database parameter in sysconfigures.
This matches the requirement in Sybase ASE Reference Manual Volumn 2:Command in create database.
290067 Feature request to have a command something like REORG COMPACT that would work to defragment text and image allocations for a table (i.e. combine partially used extents and deallocate unused space).
290070 If database is created with "For Load" option, 'delete', 'restore', 'properties' can be called from its menu.'
If database is "Suspect", only 'delete' can be called from its menu.
290080 If user selects any large size table or index with page size greater than 2^32 / @@maxpagesize for migration, the Migration Tool will return "IndexOutOfBoundsException" error during the migration process.
290139 ASE HA option support for SGI IRIX.
290204 sp_dboption cannot set "ddl in tran" for temdb under HA with proxy_db
290251 CIS : The messages "CT-Library: The connection has been marked dead" and "current process infected with 11" together with a stack trace which includes the modules 'com__async_freecp_pool' and 'com_async_drop' may be reported in the error log when an attempt is made to kill a CIS connection.
290256 Feature request for a "what you select is what you inserted" variation of variable-length

datatypes, that will neither truncate trailing spaces or null bytes (which might be

significant to their application) or pad the type with additional spaces or bytes.

Rather, the datatype should simply store what is inserted.

Space savings would still occur as only as much space as is needed would be used to

store the value.

The variable-length CHAR datatype would be able to distinguish between a null, a

zero-length string "", a single space, and any number of spaces. Likewise, the BINARY

type would be able to distinguish between a null, a zero-length binary string, a binary

string containing a single null byte 0x00, or any number of null bytes.

Reviewed Nov 2002. This feature is targeted (but not committed) to the ASE 15.0 release.

290314 After an upgrade, extended stored procedures using output parameters that were originally created with sp_addextendedproc may cause a stack trace. Redefining the procedure using the 'create procedure as external name' syntax will fix the problem.
290357 Migration Tool fails to validate the stored procedure even though the stored procedure was migrated successfully.
290379 Feature request to speed up index consistency checking by modifying dbcc checktable to use worker processes to scan and check indexes in parallel.

Reviewed Nov 2002. Feature is targeted (but not commited) for the ASE 15.0 release.

290539 Access rules are only applied to the first instance of a table in a FROM clause.
290694 Selecting the id column from a proxy table mapped to an external directory results in an overflow.
290746 3475 or 1105 run-time errors may be raised after sp_logdevice, or

sp_dropsegment 'logsegment', or sp_extendsegment 'logsegment' have

been executed.

Alternativaly, DBCC TABLEALLOC(syslogs, full, nofix) may report a

12947 error "Syslogs free space is currently <X> pages but DBCC

counted <Y> pages. This descrepancy may be spurious if this count

was done in multi-user mode. Please run DBCC TABLEALLOC(syslogs,

full, fix) to correct it."

290820 If a request is made to offline an engine whilst there is already an engine offline operation active, then the new request will wait for the existing request without generating a warning message so that the request appears to have hung.
290832 When the server's default character set is configured with a multi-byte or some

single-byte Asian character sets, non-ASCII characters with ASCII equivalents

are recognized in keywords, numeric literals, and string delimiters. The

command line trace flag -T109 hereby disables this behavior, allowing only

ASCII characters to be recognized in keywords, numeric literals, and string

delimiters.

290839 CIS: A 102 error, "Incorrect syntax near <text>" and 105 error, "Unclosed quote before the character string <text>" will be reported when inserting a single-byte single quote as a string literal in Japanese EUCJIS and SJIS charsets.
290867 A 624 error may be reported during the load of a transaction log that was originally dumped WITH STANDBY_ACCESS, and which follows the loading of a database, or a transaction log that was originally dumped without STANDBY_ACCESS.
290882 The ASE Plugin displays all installed character sets in the character set selection menu of Logon Dialog.
290887 The nesting limit for stored procedures and triggers has been increased from 16 to 50.
290905 Server Config dialog should have an apply button to deploy multiple changes without quitting the screen.
291009 Appendix A in 12.0 ASE Installation Guide notes using logmon to drain the primary databases.

This is incorrect and should be updated to v12.5 Installation Guide documentation...

Chapter 8 Upgrading Sybase Servers ...

Draining the transaction logs for primary databases

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

291114 document shm_max increase to a value at least as big as the ASE "total memory" for version 12.5 in migration document or install document

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

291121 Connections to ASE diagserver (not dataserver) from ODBC clients fails

with an assertion failure.

291124 When Unicode conversion is enabled, parsing error 102 and 105 are raised to

the query that immediately follows conversion error return such as message 2402.

291143 On servers configured with multi-byte default character sets (e.g. UTF-8),

error messages longer than 255 bytes, originating from remote servers (e.g.

backup server) are not relayed correctly to client applications.

291202 New feature: A configuration option 'start xp server during boot' has been added. This option lets user to select whether XP server to be started while booting Adaptive server.
291203 A subquery that is executed with a flattening technique using unique reformatting may

return duplicate rows if the select list for the inner query includes a non-correlated column.

291208 When trace flag 2402 is used together with "enable unicode conversion" set to 0, dynamic SQL fails with error 2402 when converting Hankaku Katakana characters from sjis to eucjis.
291221 If a view contains a subquery in its target list and the view's subquery is then used in a compute clause, then a stacktrace (signal 11) may occur. This has been fixed. Note that using a subquery directly in a compute clause is not allowed.
291279 On IBM AIX platform, attempt to mirror a freshly created master device using the command

"disk mirror name = master, mirror = <mirror device path>" may fail with error 5137

"Dynamic mirroring failed for logical device 'master'. Check the SQL Server error log for more information".

ASE kernel reports "sddone: read error on virtual disk 0 block 0: not within virtual disk range, start bn = 2

Closing the secondary device for virtual device master" in errorlog.

291304 When a SJIS client connects to a EUCJIS server with Unicode conversion enabled,

error 2402 is raised if character data contains roman numerals.

291354 In certain circumstances, an 803 error, "Unable to place buffer '<address>' from cache '<cachename>' holding logical page '<pageno>' in sdes for object '<objname>' ..." may be reported when executing a cursor FETCH AT ISOLATION LEVEL 0 and there is a lot of concurrent DML activity on the server.
291383 CIS: Execution of the UPDATE query with a join between local and proxy tables, and a huge outer table is slow.
291395 Views containing a string operation are always materialized when one of the view's

columns is the inner member of an outerjoin.

Reviewed Nov 2002. Fix is targeted (but not committed) for the 12.5.1 or 15.0 release.

291478 Went out to mysybase and searched the ebf letter for the 10349 jConnect EBF and found the following in http://download.sybase.com/swd/3172/EBF10349.txt:

10106 270704 jConnect now kills the connection when the server's

default charset is unsupported in Java (and the client

has not made a specific request for a charset). When

the client does not request a specific charset,

jConnect will attempt to use the server's default

charset. However, there are cases where the server

charset does not map to Java (because there is no

corresponding converter in Java -- an example would be

the roman8 charset). Previously, jConnect would allow

the Connection to be made, but the connection would be

unusable, as all further communications with the server

would result in an exception. jConnect now throws at

JZ0IB exception and does not allow the connection to be

made.

This problem is not an ASE Replicator problem, but rather a jConnect/Java/roman8 problem.

291577 Table columns and stored procedure parameters may be out of order for NCHAR and NVARCHAR data types in the output of sp_help.
291590 CIS: The message "current process infected with 11" in any of the modules 'omni_sync_remdbname', 'omni_create_existing', 'scan_results_subst', 'scan_from_clause', 'syb10_dynamic_prepare', 'syb10_prepare_bulk' or 'syb_build_insert', together with a stack trace may be reported in the error log when a client process exits abnormally, or a network error is encountered.
291751 cursor update爋f a text燾olumn爄n a proxy table fails with error "137, Must燿eclare爒ariable <name>"
291762 The external DLL file name and not the entire SQL statement used to create an extended stored procedure is being stored in syscomments. This fix is enabled only by starting Adaptive Server with the 2001 trace flag.
291766 Request for a WITH RENORMALIZE option to CREATE PROC and EXEC PROC that would cause

the procedure to renormalize its object references. If a procedure refers to a

table_a, and table_a is renamed to table_b, the procedure will currently continue to

reference the contents of table_b even if a new table_a is created (if the

procedure is dropped and recreated, or the original table is dropped, then it will

start refering to the new table_a). If the RENORMALIZE option was used, the

procedure would start referencing the new table_a.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

291801 On ASE 12.5.x, explain what sp_monitorconfig "txn to pss ratio" returns

in the reference manuals, usibg an example.

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

291814 Feature request for a utility to upgrade a configuration file from a source to a target when the databases of the source are upgraded by dumping and loading into the target.

Reviewed Nov 2002. This feature is not targeted for a future release. The config files can be copied to resolve this problem.

291817 Selecting into a local table from a proxy table mapped to a recursive directory causes a timeslice

followed by a stacktrace.

291821 Feature request for logout triggers, which would operate similarly to the login triggers introduced in ASE 12.5, except that the trigger action would be executed when the client process exits.
291861 When the Rep Agent is up, the housekeeper fails to do any garbage collection even on an otherwise idle server.
291868 CIS : A 1763 error, "Cannot insert rows into sysstatistics, due to multiple equal frequency values..." may be reported when executing UPDATE STATISTICS on a proxy table that has a NUMERIC column.
291890 On HP-UX machines running 64bit ASE versions between 12.5.0.1 and 12.5.0.2, sysprocesses.ipaddr

returns 0.0.0.0 instead of the IP address of the client.

291893 Feature request for a new string function REPLACE(<source>,<oldval>,<newval>) that will replace every occurrance of <oldval> with <newval> in a CHAR or VARCHAR <source>

Reviewed Nov 2002. The fix for this CR is targeted for the ASE 12.5.0.3 release. See also CR 298368.

291899 sp_sysmon under the kernel section will now show accurate recommendations.
291905 The message "current process infected with 11" in the modules omni_ct_command, omni_exec_transtmt, astc__h_predtm_dorpc together with a stack trace may be reported in the error log, if local server from within a transaction looses connection with remote ASE server.
291913 Implementation of built-in function DERIVED_STAT to return the derived

statistics found in optdiag, such as cluster ratios, space utilization

and large io efficiency.

291947 Calculations involving numeric quantities can sometimes fail with Arithmetic overflow when their
results ought to fit within the required precision and scale
292008 Checkstorage sometimes reports transient 100007 errors on ALLOCATION (i.e. on one of the allocation pages that occur every 256 pages in a database).

This is harmless and can be ignored. The suspected cause is that the first extent of an allocation unit is being deallocated at the same time checkstorage is being run, and catches a moment in the processing when the allocation map indicates all 8 pages of the extent are deallocated, although the first page of the extent, which is the allocation page itself, should actually never be marked deallocated.

Reviewed Nov 2002. Pending further research.

292042 When server's default character set is UTF-8, the parameterized language

statement "select * from table where char_column like @p1" sent from

jConnect 5.5 client will fail to find a match.

292050 In the Lock manager recommendation section of sp_sysmon, spinlock contention was wrongly being calculated based on a single bucket instead of averaging out over all the buckets.
292098 If there is only one entry in the interfaces file, Sybase Central gives exception. This problem is fixed.
292112 Corrected misspelling: unselcting --> unselecting

-----[304 changed to 304]-----

< uninstall_feature_reverse_dependencies=The following features require the feature you are unselcting. If you select OK, these features will also be deselected.\n{0}

---

> uninstall_feature_reverse_dependencies=The following features require the feature you are unselecting. If you select OK, these features will also be deselected.\n{0}

292133 sp_configure option to prevent CREATE or ALTER database from shortchanging.

Currently, if you issue a CREATE or ALTER database on a device that doesn't have as much free space

as was requested, ASE allocates all the available space and provides a simple message of how much space it allocates (but without drawing attention to the fact that it is less than was requested). Whether or not it should actually fail with an error instead has been debated for years.

This CR requests a new sp_configure parameter to control this behavior, such as

sp_configure "Cause create/alter database to fail if requested space not available" (default 0)

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

292135 Improves checkpoint performance by increasing the batch size of doing I/O's.
292178 Security restrictions have been relaxed on the sp_monitorconfig stored procedure to support external performance tools. Previously, a user needed to have sa_role to execute this procedure. Now a user requires either sa_role or mon_role.
292184 In sybmigrate, various windows have display size problems. In addition, sybmigrate windows are changed to use the system color.
292188 A column showing the number of processes that have been suspended due to the database transaction log being full has been added to the monOpenDatabases monitoring table as SuspendedProcesses.
292192 sqldbgr now prompts for password to be entered if that option is ignored in the

command line.

292206 The stored procedure sp_audit has been enhanced to allow auditing extended procedures.
292211 Request to have sqldbgr "show variables" command output include the procedure's

parameters as well as declared variables. (Parameters are current visible with the "where" command, but it seems intuitive that "show variables" would display parameters as well, as they look and act just like variables.)

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

292221 Proxy Table Editor should have save(for alter table) & save and close options.
292224 Request to have SQLDBGR's SET command work on procedure parameters as well as

declared variables. Currently it only works against variables.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

292246 Syslogs is unnecessarily flushed to disk when a transaction in TEMPDB

commits resulting in sub-optimal performance. Likewise, the data pages of

a table created in TEMPDB with SELECT INTO are unnecessarily flushed to disk.

This optimization may be disabled using the 2709 trace flag.

292320 Fixes incorrect sp_sysmon recommendations pertaining to pool size and wash size under the "Data Cache Management" section when running with larger page sizes i.e. ASE installations with page sizes > 2K.
Enhanacement to include Object Manager spinlock contention under the "Metadata Cache Management" section and some recommendation on when to use the dbcc tune(des_bind) feature.
292330 Feature request for the ability to grant ability to execute the TRUNCATE TABLE command to other users
292339 For Mac version 10.2, user cannot start ASEPlugin help. This problem is fixed.
292340 Feature request for the ability to declare variables and stored procedure parameters of type TEXT or IMAGE
292430 Feature request for the ability to have remote backupservers handle compressed dumps (currently only available on local backupservers).

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

292435 feature request to have ASE allow comparing text and image fields to NULL directly without having to use the proprietary function textvalid(), i.e. just:

select * from blurbs where copy is not null

292483 Now the conversion between SQL type TEXT/IMAGE and Java type

java.io.InputStream is implicit. The conversion between

SQL type TEXT/IMAGE and Java type java.lang.String has to be

explicit.

292486 First execution of a stored procedure using unichar/univarchar as parameter

after "load database" raises warning message 7961. Subsequent executions are

fine.

292543 The Migration Tool (sybmigrate) reports an error "Error while parsing interfaces file '%1'." if the interfaces file contain comment lines in the beginning of the file.
292546 Insufficient "stack size" configuration can cause a variety of failures in Java initialization and prevent Java operation. In some cases there is no indication that the problem was due to insufficient "stack size". Add a message to the error log to indicate the cause of the failure.
292549 In rare circumstances incorrect results may be returned when executing a SELECT statement with an IN list or an OR operator in which there is a comparison of a BINARY or VARBINARY column.
292574 Request for an sp_configure parameter to control the server's default transaction isolation level.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

292629 Feature request to enhance the SELECT INTO command so that it can append minimally-logged data to a local table that already exists. This can reasonably be limited to tables that have no indexes or triggers, much like fast bcp.

Reviewed Nov 2002. Feature is currently not targeted for any release.

292631 ASE Replicator: Now also runs on Mac OS X v10.2 and RedHat Linux 7.2. For all Unix platforms, the .sh scripts check to see if the $SYBASE environment variable is set. If it is not, the scripts assume they are being executed from within the <install_dir>/RPL-12_5/bin directory, and they set SYBASE to `pwd`/../.. in order to be able to set the other paths that they need.
292636 Restore FTS Highlighting feature documentation to 12.x in FTS Specialty Data Store Users guide: Chapter 5 Writing Full-Text Search Queries - Pseudo Columns in the Index Table

Reviewed Nov 2002. This feature will be addressed in the documentation released with the next release of ASE.

292664 This fixes the null pointer exception that shows up on the reboot panel after reboot. The problem is that we don't have a graphics context (root panel) to root the JOptionPane to. This fix just makes the JOptionPane assume a null parent so that it will display regardless of whether there is a parent panel.
292666 In some circumstances, a query that uses an index may run slower than expected as a result of increased I/O, when it is executed on a server configured with a non-binary sort order, depending on the value specified in the WHERE clause.
292699 Prevent the OS from performing lazy allocation when creating the master device by writing out all pages of the device.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

292713 Unnecesary error messages are printed in the errorlog if ASE is configured for both SSL and non SSL connections.
292725 An 871 error, "Process <spid> is trying to release a latch on buffer <address> ... without holding a latch on the buffer", may occasionally be reported when using a serializable backward scan on a data-only locked table. The stack trace may include the modules 'bt__unwind', 'bt__traverse' and 'bt__getstartpg'.
292764 The work done by a remote server in modifying a proxy table as part of a trigger execution is not rolled back when the ROLLBACK TRIGGER command is executed.
292767 When a task tries to access a database while the database is undergoing

creation through the 'CREATE DATABASE' command, then errors 913 and 834

may be hit with a stack trace reported in the error log showing modules

'dbt_removeall', 'bufdbclean' and 'cm_dbclean'. The same can happen if

instead the database is being dropped through the 'DBCC DBREPAIR(<dbname>,

DROPDB)' command.

292784 We will not allow views with unnamed columns like "create view vw as select 1". The user

must specify the column names. This fix can be disabled by traceflag 1702.

292860 A UNION query with numerous subqueries on one side of the UNION may fail.
292913 The message "process infected with 11" may be reported in the error log together with a stack trace

which includes the modules 'proc_setdb_tree', 's_renormalize' and 's_recompile' if a stored procedure containing a SELECT statement having 16 subqueries in the select list is executed and the table referenced by the SELECT is dropped and recreated in the meantime.

292917 In rare circumstances, the message "current process infected with 11" may be reported in the error log together with a stack trace which includes the module 'a_calcrowlen' when processing a query that uses mutiple worktables and the first aggregate of the second worktable is an AVG aggregate.
293013 On Windows 2000 Advanced Server and Datacenter Edition, running the syconfig program from the Start menu will result in a message box that reads "invalid command line argument 'and'"

You can work around this problem by running syconfig from the command line.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

293070 Add new tab 'Columns' on View Properties dialog. It lists the columns of the view.
293111 Text indexes can now be created on tables that contain an identity column or a suitable primary key. Primary keys defined on a single decimal, numeric, int, smallint, or tinyint column are eligible. Decimal and numeric columns must have a scale of zero.
293127 'Select Distinct with UNION' and JOINS with Distinct keyword may encounter performance degradation if proxy tables are involved.
293149 In rare circumstances, performance of some queries may be sub-optimal because of an incorrect row count estimate in systabstats.rowcnt after a server restart, LOAD DATABASE or LOAD TRANSACTION.
293172 Failover of HA client may fail to login to secondary server with message 'ha session not found'.
293180 In some cases where a datetime column contains a 1/1/1753 value, OPTDIAG STATISTICS will raise error 245 Domain error during explicit conversion of VARBINARY value <x> to a DATETIME field.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.1 release.

293217 DDLGen doesn't generate the correct create database statement for databases that have mixed data a log segments.
293223 If the character or binary result value of a CASE expression in a SQL statement
is greater than 255 bytes long, the data is truncated to 255 bytes or less.
293230 Request for additional language support for srvbuild.
293239 A 3702 error is reported when trying to drop a table which had its schema
changed by an ALTER TABLE command and was later referenced in an OPEN CURSOR
query that failed with a 540 error.
293268 CIS : In a HA environment, ownership of tables in user proxy databases may be incorrect.
293291 Indexes created in a proc are used by the optimizier in queries that are run inside a SP. P&T guide needs to be changed to reflect this behavior

Reviewed Nov 2002. Doc CR is scheduled to be fixed in the set of docs that will be released with the next release of ASE.

293315 CIS: Host name and port number will be dumped to the ASE error log file when a connection

to the remote server fails. This enhancement works only when traceflag 11299 is turned on.

293321 In "sybmigrate", user gets an unexpected exception "java.lang.IllegalArgumentException" when connect to the ASE with port number > 65535.
293372 A query that assigns its result to a local variable and which is run in parallel having executed a SET ROWCOUNT statement may incorrectly return a NULL value. This is likely to happen if the number of worker threads is bigger than the SET ROWCOUNT value.
293494 The Linux/ASE 'showserver' command lists all threads belonging to an ASE engine or

invoked helper process. This can easily confuse the DBA or SA when platform specific

commands are required to control the process. With this fix, 'showserver' command

only lists the main thread for ASE or its related components.

293525 A 4409 error, "The columns in the query definition and the view definition

do not match" may be reported when executing a query that references the

same column in the select list and in the WHERE clause of a view which

itself defines that same column as a subquery.

293531 The EFTS now supports index_any clauses greater than 255 bytes. The column definition of the proxy table was not altered, because its definition doesn't affect the size of the clause that will be sent to the FTS.
293553 There is no index optimization when sum() aggregate and group by clause are in the same query.

Reviewed Nov 2002. A fix is planned but currently unscheduled.

293603 CIS: create proxy_table command may drop the remote table in an HA environment.
293620 12.0 CIS guide refers to sql_server instead of direct_connect for MSSql Server. The doc set is correct for ASE 12.5
293624 On linux, running ASE versions prior to 12.5.0.3 one may encounter errors 903, 834 and a stack

trace in the errorlog when creating a large database on a raw device.

293636 Adaptive Server is started by root and run with root privileges when configured for High Availability on Sun Cluster 3.0 instead of running as user account that owns $SYBASE directory.
293638 A 'like' clause on a column that is seeded by a parameter value and also participates in an outer-join can yield incorrect results.
293651 Migration Tool opens many connections to the source ASE.
293673 Configuration option to disable pre-12.5 clients (and those not capable of wide-table support) from connecting to a dataserver. The idea is to prevent clients who would get warnings about the lack of wide-table support from connecting successfully if an administrator so favored in his configuration options.
293687 A 12818 error, "Cannot create an object of this type in system-created proxy database." maybe raised when an ALTER TABLE command that adds a column with DEFAULT clause is executed on a HA server that has been configured as 'with_proxydb'.
293772 Enhance the sp_sysmon stored procedure to provide an option to execute without clearing the monitor counters. Note: The interface to the sp_sysmon_collect stored procedure has been changed.
293799 ASE Replicator: If the environment for jConnect is not correctly set up, ASE Replicator may fail to start up with the following error:

Failed to re-set the database context to original catalog of <xxx>.

Current catalog is <unknown>.

With this fix, ASE Replicator will still log this error but it will keep going. The side effect may be slower performance because connections to ASE will be closed and re-created instead of being released and held in a pool.

293800 Please see 293800-1 for complete description
293829 Multiple Temp DB Support in Sybase Central ASE Plug-in.

CR 301366 opened for DOC changes

293830 Sybase Central ASE Plug-in starting from voyager(12.5.1) will support Disk Resize functionality of ASE. Users with 'sa' role can increase the size of Database Devices in a ASE, whose version is greater than or equal to 12.5.0.1.
293896 ASE Replicator: When all connection attempts fail, ASE Replicator logs a message that contains the connection properties. Some of those values were displayed as 'null' even though the values were correctly set. Now, all configured values are correctly displayed. Also, these connection properties are now logged as part of regular ASE Replicator startup.
293936 The Interfaces file parser in the past had lots of problems in parsing/decoding the

various entries from interfaces file, especially entries of non-tli styles. Also there were few problems, when the entries in the interfaces had preceding/following white spaces/comment characters.

293946 Using sybmigrate or SELECT...INTO EXISTING TABLE to move data from an iso_1 server to a utf8 server resulted in 11216 and 4847 errors. A temporary workaround has been implemented using trace flag 11224 until the real problem (CR 276619) is resolved.
293974 Sub-optimal performance may occur when executing a query that contains two or more subqueries which are executed at the same "nesting level" (as reported by SHOWPLAN output) as a result of not executing the subqueries in the order that they are specified in the query.
293983 When Adaptive Server is configured with a multi-byte character set, sp_helptext

returns erroneous output for a stored procedure that has a multi-byte character

in the 255th byte position in its CREATE PROCEDURE statement.

294058 In rare circumstances a 622 error, "Opentable was passed a varno of <value>. Object '<obj_name>' already has that session descriptor in use", may be reported against a view that references a table in another database.
294078 SQL Preview feature implements in ASE Plugin -- User has the option to display SQL before execution
294079 When a table is selected, a new panel shows the data of the table.
294092 srvbuild and srvbuildres fail to detect soft partitions feature of the Solstice DiskSuite. This is a regression of CR 278710.
294137 Configuring default network packet size greater than 65535 can cause TDS protocol connections.
294143 extractjava truncates extracted jar files to 32K

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 12.5.0.3 release.

294170 If user resize a column width, its value is stored. The column width is persisent when column get sorted and after SC is exit and restart.
294181 Request for an sp_configure parameter to control when the password expiration warning starts to be displayed. Currently it starts displaying 75% through the password expiration interval, i.e. for 100 day interval, the warning is displayed from the 75-100th day.

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

294182 The creation menu can be accessed by either doing a right-click on the empty area of the details panel on the right hand side (which brings up the pop-up menu containing the 'New' submenu), or selecting 'File'->'New' submenu. For example, when the 'Foreign Keys' folder is selected, the user can select 'New'->'Foreign Key' to invoke the wizard to create a foreign key.
294184 CR 298469 opened for Customer Description
294214 The message "current process infected with 11" together with a stack trace that includes the modules 'pchk_text_page' and 'pchk_all_pages' may be reported by DBCC CHECKSTORAGE or DBCC CHECKVERIFY when using the 7109 trace flag to implement the pre-12.0 TEXT strategy (originally done under CR 237929).
294246 Feature request for builtin functions bintohex and hexto bin, similar to hextoint and inttohex,
that could convert hexidecimal char or varchar strings to binary or varbinary datatypes and vice versa.
Currently isql will automatically display a binary value as a string, but there is no easy way to do a similar conversion within TSQL.
294286 strtobin() built in function should ignore leading 0x in string, now strtobin("0x12ab")

will return 0x12ab instead of null.

294340 Backup server under Linux didn't support long lseek operations when dumping database devices larger the 2GB under linux.
294350 On NT systems, native (OLE) MSDTC distributed transactions hang when a request is made to prepare, commit or rollback the transaction.
294393 After the DDL object migrated to target ASE, the SQL text for the migrated object store in syscomments contain one extra line.
294479 Migration tool should have an option to keep transfered data when rowcounts are different.
294484 Adding a column with a DEFAULT using the ALTER TABLE statement can sometimes cause the text of the DEFAULT constraint to be saved incorrectly in syscomments.
294485 DDLGen cannot generate DDL for all indexes in a database.
294489 DDLGen will print an error message for all errors, which will consist of an error number and an error message. This will be followed by exception stack trace.
294490 A new command line argument -L (which takes the progress log output file name) has been added to the DDLGen. The progress of the DDLGen will be logged to this file.
294492 The total used and total unused page count may not always be recalculated as expected

after 7940/7949 errors were corrected by the DBCC TABLEALLOC command run with the FIX

option.

294501 On a multi-engine server, a timeslice error may be reported in the error log together with a stack trace that includes the module 'cm_grabmem_lru' if many sessions are executing parallel SELECT INTO commands concurrently or otherwise changing the schema of tables.
294513 A 567 error is erroneously reported when a user with "sso_role" attempts to use

sp_modifylogin to modify the attributes of a login.

294583 On the Linux platform, the Full-Text Search server does not completely shutdown aftering sp_shutdown has been issued.
294595 ASE does not respect the -d <master_device_name> and -r <master_mirror_name> names provided on the command line. Instead, it uses its own internally stored names.
294626 GUID generator builtin newid() is implemented in this release. The newid() builtin takes optional argument 0 or 1 which will generate GUID with no dashes or with dashes. The GUID generated is of type VARCHAR. The length of the GUID is 32 bytes for no dashes option and 36 bytes for newid() with option of 1 or any number greater than that
294687 an "insert into <proxy table> select from <local table>" statement may fail with error "206, Operand爐ype燾lash"
294809 Add a new character set mac_euro to support the EURO symbol in 'mac' character set.
294833 sp_rename does not update the CREATE <objecttype> <name> line in the source code stored in syscomments.

Reviewed Nov 2002. Fix is targeted (but not committed) for the ASE 15.0 release.

294874 Because of design issues within the current Linux Native thread run-time
design Linux/ASE must be booted with traceflag 1639 (-T1639). Enabling
this flag will masquarade problems which may lead to timeslice errors when
high i/o load is going under the (RT) Posix Async disk I/O subsystem.
This run-time problem is likely to be fixed when Linux is released with
the nptl (New Posix Thread Library) expected to arrive summer 2003.
294926 A 233 error, "The column in table <table name> does not

allow null values." will be reported, when a stored procedure

creates a table using SELECT INTO with the options IDENTITY_INSERT,

EXTERNAL FILE, EXTERNAL TABLE or COLUMN DELIMITER and

we try to insert into that table inside the same stored

procedure.

294977 Feature request for function to return a true/false indication of whether dump tran is allowed (i.e. would

be false if minimally-logged operations or dump tran with truncate_only had been executed since the most recent dump database).

Reviewed Nov 2002. Pending further research in engineering.

295033 Enhancement request to improve datetime datatype to have full millisecond (or greater) precision (currently granularity is 1/300th of a second rather than 1/1000th)

Reviewed Nov 2002. Feature is targeted (but not committed) for the ASE 15.0 release.

295034 On SGI platform, Adaptive Server may core dump during shutdown occasionally.
295074 If DBCC CHECKSTORAGE crashes, failure to cleanup its resources may cause other processes to hang.
295076 An equality SELECT FROM the sysprocesses table on either 'clientname', 'clientapplname' or 'clienthostname' will incorrectly return no results.
295092 The message "current process infected with 11" in the module 'ap__dt_plan' together with a stack trace that includes the modules 'ap_print' and 's_ap_capture' may be reported in the error log when a plan is generated using SET PLAN DUMP ON for an "INSERT <table> SELECT" query that does not have a

FROM clause and <table> has a referential constraint.

295104 Addition of a new builtin function, audit_event_name(), which given an

audit event number, returns the associated description of the event.

295143 In rare circumstances, a 2626 error or message "current process infected with 11 or 10" together

with the module memmove(),run__fix_collen(),do__groups() or run(), may be reported in the

errorlog when processing a query that contains many aggregate functions needing

multiple worktables.

295151 dbcc memusage reports wrong unused memory
295166 Improved error handling for the audit process when the 'auditing' configuration

parameter is enabled.

295167 Trying to force a dormant engine to shutdown using the dbcc engine('shutdown', <n>) command fails with the message 'engine <n> is not online'
295262 Enhance login triggers so they can set persistant SET option values for the connection. Currently, any SET options set in the login trigger are limited to the scope of the login trigger itself. By starting the server with trace flag 4073 the scope will be the process that just logged in.
295273 In rare circumstances, a query using a 'GROUP BY' may get a signal 11, the stack trace in the error log will show modules 'do__groups', 'add_ind_level' and 'memfreeheap'.
295275 Concatenation of unichar with character or binary datatypes can result in incorrect results.
295284 New attribute is added for sp_chgattribute to support user
to set identity max values.

The syntax will be:
sp_chgattribute tab_name, "identity_burn_max", 0, new_identity_val

295290 692 error may be raised when an exception happened during alter partition operation. The table cannot be dropped unless the server is recycled.
295429 Under some circumstances, the index of a table is marked as "suspect" after loading a database that was dumped on a 12.0.x server, into a 12.5.x server. Msg 3121 may be falsely raised at load database time: "Index <tabname.indname>(objid=<objid>, indid=<indid>) may be invalid. It uses CHAR or VARCHAR columns in its key and was created under a different sort order ID (0) or charset ID (0) than the ones on this server (SortOrd=<sortord id>, CharSet=<charset id>)", even though the index does not have any CHAR or VARCHAR columns and the sortorder/charset id has not changed between the dump and load.
295435 Recursive resource governor exceptions that result in an action of

task termination could lead to phantom processes.

295473 When using JCONNECT_VERSION 6 and server's default character set is UTF-8,

the '=' operator in prepared statements behaves as 'like' clause.

295567 When executing a SQL statement like SELECT @variable1 = <column> FROM <table> WHERE <column> LIKE

@variable1, the index on the <column> is sometimes not used.

295645 Added two new builtins. isdatetime() determines whether an input expression is a valid datetime value. isnumeric() determines whether an expression is a valid numeric type.
295658 Spurious 2503 errors on syslogs can occur in DBCC CHECKDB if DUMP TRANSACTION happens to run concurrently.

These errors are greatly reduced, but in theory not totally eliminated, by the fix to this CR.

295668 In rare circumstances a 2206 error, "Database <proxy_name> with dbid <dbid> is already shut down" may be reported together with a stack trace that includes the modules 'dbt_get', 'pfts_append' and 'bufgrab' soon after HA failover.
295719 An UPDATE command involving an all pages-locked table with a safe clustered

index (the index keys are not being updated), may be incorrectly executed in

deferred mode rather than direct mode, resulting in poor performance.

295743 When the Abstract Plan dump mode is active, then some UNION queries may fail
with a stack trace reported in the error log showing modules 'apg__work_tab'
'apg__setop', and 's_compile'.
295803 Feature request for an sp_configure option, something like

sp_configure "disallow non-sa logins before recovery complete" [default off]

that would prevent any users other than users with sa_role from logging in to the server before

recovery of user databases is complete (i.e. logins would be allowed starting either just before or just after all engines are brought online).

This description is under revision.

In 15.0 GA and 15.0 ESD#1, sp_modifylogin NULL, "enable logins during recovery", "0"/"1" needs to be used.

As of 15.0 ESD#2 onwards, the sp_configure "enable logins during recovery" option needs to be used.

295881 1. An empty spinlock contention scenario in the Data Cache Management section is addressed.

2. The sp_sysmon "Task Management" section has been updated with a more detailed recommendation for the I/O Pacing section.

295908 a SELECT INTO EXISTING TABLE in a stored procedure or in a trigger may return an

empty error message.

295971 On Windows platforms, an engine offline operation may continually report that it is waiting for affinitied processes, when in fact the processes in question are simply idle
296011 When "alter table add/modify column" is used in a stored procedure, a signal 11 may happen in routine memfree() if the session is interrupted or raises an error. Sometimes a memory mismatch warning may be seen in the errorlog.
296064 In some cases, a sub-optimal plan that uses a covering index may be chosen by the optimizer for a query that has an OR clause because this appears to be the cheapest access path. In reality, taking account of concurrency may generate a better plan than simply choosing the cheapest. This fix extends concurrency optimization to enable the optimizer to make a better judgement.
296108 Feature request to have the deadlock information printed by the sp_configure PRINT DEADLOCK INFORMATION option included the index ids of the pages involved.
296194 Two new nopref sortorders are added for cp1251: cyrnocsnopref.srt and

rusnocsnopref.srt.

296292 In an High Availibility asymmetric configuration, if indices are bound to named caches, the failover operation may get aborted with the message "current process infected with 11" in the module 'buf__elcsearch'.
296308 Enhancement request: When updating a text/image column through a view using ct_send_data, update permissions are not inherited from the view because the IO descriptor returned by the ASE references the underlying table and not the view.
296370 The command SELECT EXP(<large negative value>) returns NULL (arithmetic overflow) instead of 0.000000.
296375 Enhance CREATE DATABASE and ALTER DATABASE to allow granularity of 1/2 MB in size. Currently, these commands will only allow allocation in whole MB increments, except that if there is not enough space on the device, ASE will allocate as much as is available to the nearest 1/2 mb - resulting in a fragment that cannot be easily recreated.
296381 If a CREATE CLUSTERED INDEX is run on a partitioned table while a DUMP DATABASE is running concurrently on the database, then, upon trying to load the dump, 605 or 692 errors may be seen. The stack trace may contain modules 'wrongpage' and 'getpage_with_validation'.
296395 Request for method to get full text of last error raised. @@error provides the error number, and the template for the error message can be found in sysmessages, but the parameters (database and table names, ids, page numbers, etc) that are included in the actual message are inaccessible from within TSQL. Request is for a new session-level global variable @@errormessage, which would return a VARCHAR containing the full text of the most recently raised error - in synch with @@error.
296437 License key and user docs use license option 'ASE_DIRS' for LDAP and other directory services. However, ASE only recognized 'ASE_DIR' which made license key for 'ASE_DIRS' unusable.

This fix makes ASE recognize 'ASE_DIRS'.

296477 CIS: When a transaction that involves a proxy table is chosen as a deadlock victim on the remote server, the corresponding local process incorrectly continues to process the remaining statements in the batch.
296577 In some cases select * from syslisteners provides correct results followed by several lines of garbage or an infinate amount of blank lines of output.
296629 Backupserver may core dump with floating point exception during a

dump or load if the product (allocated space * pagesize) exceeds

4gig.

296659 Allow option to run update index statistics in parallel
296689 Feature request to allow xp_cmdshell to accept parameters wider than 255 bytes.
296724 sp_configure parameter "executable code size" reports an incorrect, excessively large value.
296768 CIS: A 605 error may be reported together with a stack trace which includes the modules 'wrongpage', 'getpage_with_validation' and 'gettxtpage' when a "SELECT * INTO" a local table from a proxy table with remote procedure at a remote server is executed.
296781 Incorrect result, 403 error, 678 error, or assertion error in sqx__mvranges() may be returned, or process may be infected with signal 11 in oj_contig_bm(), when query has a subquery against UNION VIEW.
296794 memory used value is not correctly calculated for 'size of process object heap'
296796 The "Memory Used" column may not always be correctly calculated and displayed by the sp_configure command.
296817 For consistency all the config parameter that have a value in the memory used column of sp_configure should be displayed in KB.
296847 Selecting from a proxy table mapped to an RPC results in error 201 is set quoted_identifier is turned on.
296855 Increase the maximum number of SARGS the optimizer can handle from 128

to 585 on 32 bit platforms and 512 on 64 bit platforms.

296898 A query that has an OR condition and a LIKE clause that does a comparison with a pattern with a leading wildcard character may not benefit from some OR optimization strategies with the result that execution of the query will be sub-optimal.
296927 CIS: Queries which contain dates in OR predicates may cause ORA-01858 error when run against DirectConnect for Oracle 12.0.
297001 In rare circumstances the DUMP DATABASE command may timeslice with a stack
trace reported in the error log showing modules 'dpdb_main', 'des_checkpoint'
and 'des__systs_flushall'. Alternatively the UPDATE STATISTICS command may
timeslice with modules 'ups_main', 'ind_ides_init' and 'ind__ides_install'
being reported.
297073 Feature request for a way to manually set/update a timestamp value (more or less according the way <identity insert> is implemented. This would be used in warm-standby replication environments, where transactions are forwarded by RepServer as SQL-statements.

Due to the current implementation of timestamp, this will lead to differences in the timestamp values between the primary side and the secondary.

297135 Customer would like more detail on how to to re-establish

replication if they lose the primary, replicate or DDB database. This would include

recommendations for backups.

Customer would also like complete instructions on how to recover replication

(including locater reset commands, dbcc's ect...) in the event that the customer had

to recover (restore) any of the involved databases from backups.

297184 CIS : A 1763 error "Cannot insert rows into sysstatistics, due to multiple equal frequency values..." may be reported when executing UPDATE STATISTICS on a proxy table that has index columns with NULL value rows.
297222 Creating tables within stored procedures can lead to object resolution problems yielding unexpected 267 errors
297230 In some cases, pre-TDS 5 clients may hang during login with the errors

"noobhandler: recv of OOB byte returned -1 errno 22" or

"noobhandler: recv of OOB byte returned -1 errno 4" reported in the error log,

leaving the corresponding Adaptive Server sessions unable to be killed.

297281 Performance enhancements made to SELECT INTO by using large I/O and extent

allocation for the target table, when possible. As a result, SELECT INTO may

choose the largest I/O size possible for the target table, based on the size

of the buffer pools available in the target database cache.

297350 While the DBCC CHECKTABLE command is running on a data-only-locked schema
table, if the HOUSEKEEPER task deallocates a free page of this table, then
error 2583 may be raised "Number of data pages (<value1>) counted by DBCC
differs from count in the data OAM (<value2>) for dbid <value> object <value>",
followed by message "The total number of empty pages (with all deleted rows)
in this table is <value3>" where <value1> minus <value3> would equal
to <value2>.
297369 A 1581 error, "Create index was aborted because pages in the data only locked table are not linked", may be reported when loading a transaction log which was dumped when a REORG REBUILD was running concurrently on a data-only locked table that has a clustered index.
297378 For certain locales such as Chinese, Japanese, or Korean, the server's minimum database sizes are too small to permit a successful installation: database logs fill up and installation stalls due to lack of space. Provide server command line flags to declare the desired size for the master and model databases, so that new installations can be created with databases large enough to guarantee a successful install. Provide support in the installation tools to calculate these sizes and communicate them to the server.
297385 Entering multiple shutdown commands will result in these processes waiting for each other to finish.
297398 When Java in ASE encounters a severe error, the session is placed in an unkillable state waiting for "remote i/o".

Java capabilities of ASE will become unavailable and attempts to use Java fails in unpredictable ways.

Running "sp_who" will show the process waiting for "remote i/o". The errorlog may have a stacktrace

containing U_get_previous_frame_x and ending with ExecuteJava__7VMFrameSFP6JNIEnvP8VMMethodP6VMword.

297460 Selecting from a proxy table mapped to an external file,

where the data file contains less columns than expected

causes dataserver to crash with a core dump.

297480 When trying issue checkpoint after resetting "single user" option on a database, user

may get error 924 saying that database is in use by other tasks.

297491 Customer wants to assign a role that has the ability to do such functions

as kill spids, truncate table, create/drop index, dump/load database/transaction.

Or add another type of role that would only have a subset of sa_role authorizations (between operator and sa role).

297520 A 2525 error may be reported by DBCC CHECKALLOC or 100006 and 100031 faults

may be reported by DBCC CHECKSTORAGE on page 0 in a database which

has a proxy table to a partitioned remote table.

297617 SYB_BACKUP...sp_who does not return any results.
297625 On HPUX, AIX and LINUX, ASE does not log an error in the errorlog when the request

to Operating System for setting non-blocking mode or asynchronous mode for a client

connection fails.

297659 The message "current process infected with 11" in the module 'astc__dtxp_scavenge' together with a stack trace that includes the module 'astc_dtxp_get_free' may be reported in the error log when updating a proxy table and the configuration parameter "enable xact coordination" is set to '0' and the "number of dtx participants" is underconfigured.
297674 No error message is reported when an online engine command is executed and another online engine command is already active. Rather, the command is blocked until the active command finishes, giving the appearance that the session has hung.
297695 In rare circumstances, an 1929 error "Failed to reserve/initialize allocation hints space in index '<name>' on table '<name>'" may be reported during the execution of a CREATE CLUSTERED INDEX command or an ALTER TABLE LOCK / REORG REBUILD command (on a table that already has a clustered index) if the table has at least one non-clustered index.
297706 Feature request to have dbcc checkalloc recheck errors found at the tail end of syslogs to avoid spurious errors (similar to dbcc checkverify).
297710 CIS: Ctrl-C on RPC queries may result in timeslice -501 error and stack traces. Further access to the proxy tables may not work.
297747 Feature request. Provide mechanism for resource governor to print SQL text when resource limits

are violated.

297753 A new option, 'with dbid = <number>' has been added to

'CREATE DATABASE' command, to allow the database administrator

to specify database id when creating a new database.

297756 CIS: In rare circumstances on a multi-engine system, the messages "uppushaffinity: kpid XXXXXX affinity stack overflow", and "current process infected with 11" in the module 'com_async_assoc' together with a stack trace which includes the modules 'ksctsetamctx' and 'com_async_start', may be reported in the error log when a simple SELECT statement with a subquery involving a remote table is executed in parallel.
297817 During the startup of Adaptive Server, a stack trace that includes the modules 'audproc', 'send_boot_audit' and 'format_audrecs' may be reported in the error log when the 'security' auditing option is active, resulting in the AUDIT PROCESS being killed.
297822 Error 691 "Encountered invalid logical page '0' while accessing object
'<value>' in database '<value>'" will be raised when trying to replicate
a proxy table either through SP_SETREPTABLE or SP_REPTOSTANDBY with a stack
trace in the error log showing modules 'set_repobj_status' or
'set_repdb_status' followed by 'txtimg_upd_table' and 'wrongpage'.
298070 Error message 11136 still references the configuration parameter "max roles enabled per user". This parameter existed in 12.0 but was removed in 12.5, the limit is now simply hardcoded at 127.
298088 Add Resource Limits feature in ASEPlugin.
298099 Feature request for object level backup and restore
298108 Feature request to add a sorted_data option to "alter table" and a primary key option to creatre nonclustered index
298176 This fix: 1. Changes the default value for the configuration parameter "tcp no delay" to 1, which avoids batching TDS packets at the tcp layer. 2 Changes the default value for "disable disk mirroring" to 1, which provides performance benefits since the "device semaphores" need not be held if Sybase mirroring is not used. Both of these will provide out of the box performance gains for most installations. THINGS TO BE BORNE IN MIND: If sybase mirroring is being used, the configuration option "disable disk mirroring" needs to be changed to 0.
298185 Under stress conditions, the number of child worker threads can increase while another
DBMS task is traversing the list of children. A timing window led to an overrun of a dynamically
allocated array resulting in either an assertion failure in diagserver or a segfault.
This fix avoids the array overrun, fixes the assertion statement, and better handles the
effects of the timing window. This change only affects code that uses worker threads.
298244 On HP 64 bit platforms, a session may not be cleaned up immediately when a client process is killed from the operating system command line.
298298 A new config parameter 'send doneinproc tokens' was added to control when the DONEINPROC tokens are transmitted. This can be set to 0 or 1. '0' restricts the transmission of DONEINPROC tokens to after SELECT statements only and 1 indicates there is no restriction on the transmission of these tokens. The default is 1. This replaces the dbcc tune() 'doneinproc' option.
298302 sqldbgr 'help' command and Utility Guide incorrectly specifies 'mysql'

instead of 'sql' as useful for getting temp table info of the debugged task.

298303 The message "current process infected with 11" in the module memalloc together with

a stack trace which includes the modules stu_findslot, st_hist_has_freqcells and

j_process_n_bld_distmap, may be reported in the error log for queries using sort-merge

join, and one of the columns used in the join has the value NULL for all rows in the

table.

298346 Enhancement Request: Allow the auditing of actions based upon the user-defined roles active for a user.
298368 Several built-in functions and global variables have been added for better compatibility with MS SQL Server. See the release notes for details.
298472 On HP64 platform, builtin function sortkey() stack traces when it is executed against

a 16384-byte long string.

298485 A bug where ASE detects incorrectly there was system error when more that 1000 backup config files exists was fixed.
298585 In some cases, truncation of syslogs may be prevented when a query does a "sorted" sort in tempdb (for ORDER BY or DISTINCT) within an explicit user transaction which is neither explicitly committed nor rolled back, despite there being no updates, inserts or deletes done within the transaction.
298620 The non clustered index Sysusers.ncsysusers2 created during the installation

of a 12.5 ASE does not have the unique attribute set whereas it should.

298637 The monErrorLog monitoring table now reports the error state as the State column. Messages of the form 'Error: %, Severity: %, State: %' are no longer reported by monErrorLog as the ErrorNumber, Severity and State are all included for the actual error message, thus making these additional informative messages redundant.
298655 Sysconfigures table should document decimal values alongwith hex values for 'status' column. -1 should be documented as a valid value for 'value4' column.
298720 The message "process infected with 10" may be reported in the error log
together with a stacktrace which includes the modules 'drop_constr' and
'altertab' if an ALTER TABLE <table> DROP CONSTRAINT <constraint id>
statement is executed.
298755 An engine which is part way through going offline consumes 100% cpu until it finally completes the offline operation
298799 If either GRANT actions or JAVA CLASSES REMOVE actions are being

audited, sp_displayaudit incorrectly displays that both actions

are being audited. In either case, only GRANT actions are actually

being audited.

298813 Feature Request: ASE should check for "null" inserts to columns that do not allow nulls at create procedure time. This is in addition to the run time checking that is already done.
298870 Concurrent deletes on an APL table may deadlock, when one session is

deallocating a page (as a result of deletes), while another is trying to

scan the object for the rows it wants to delete. The stacks of tasks

will show functions apl_getnext and removepage respectively.

298899 Linux/ASE does not anticipate for raw device alignment when checking
the physical device mirrored data. This will result in a mirror check
making the mirrorred device not usable when administrated on a linux
Raw bound device.
298976 The message "current infected with 11" in the module 'sqx__do_transform'

or in the module 'com__subquery' may be reported in the errrorlog when

executing SELECT that contains subqueries and assigns multiple local

variables that are used in the SELECT list and in the WHERE clause.

299039 On HP-UX platform, setsockopt(), accept() and connect() system calls may be interrupted by a

signal and fail. ASE treats EINTR as unrecoverable error leading to the connection being

aborted by the network handler. ASE may report "nopen: accept, Interupted system call" in

the errorlog leading to 1605 error.

299108 ASE certificates with chains longer than 1 fail SSL handshake.

This fix incorporates SSL Plus library v.3.1.3 into ASE.

ASE must be used with the corresponding OCS release using SSL Plus v.3.1.3.

299150 When the last non-granted blocking lock is released because its associated session is either interrupted or killed, Adaptive Server does not re-evaluate the grantable lock requests that are no longer blocked. This situation is rare, but it will result in unnecessary blocking situations, for example a 'shared page' lock that is granted to task A may block a 'shared page' compatible lock requested by task B.
299160 "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 or historical server).

299209 A long running transaction doing inserts and deletes on a DOL table

may make a large no. of exclusive row requests and impact performance

due to redundant garbage collection checks.

299239 CIS: Execution of the query INSERT...SELECT <constant string> FROM proxy table, will either cause garbage to be inserted, or give a syntax error with Msg 156, or cause a stack trace in inserttext()

depending on the length of text constant in the SELECT clause.

299280 An 2805 error, "Bad pointer 0x2 encountered while remapping stored procedure. Invalid pointer param number 3, pointer value 0x0'. Must re-create procedure" is reported when executing a SQL statement

that uses an aggregate function in a WHERE clause within subquery under a HAVING clause on a correlated column. The error is raised when such a statement is executed via a stored procedure which is recompiled.

299299 Feature request for a built-in function that would return the page number containing the row being returned.
299320 Stored procedure replicate needs owner and version information
299391 ASE Replicator: In localized versions of Replicator, descriptions of configurable properties, trace flags, and debug flags appear in English instead of the current language.
299413 When a cursor is declared with a right-nested ANSI OUTER JOIN and the SET CURSOR ROWS option is set to more than 1, then a FETCH statement may return an incorrect null-supplied row.
299522 A 2620 error may be raised in module 'putdrow' while inserting data in an All Pages Locked table that has an index such that the length of the index key only allows three rows to fit on each index page. Alternatively a 614 error may be raised in module 'apl_rowsize'. In both cases, this will result in the session being killed with a stack trace reported in the error log showing respectively

modules 'cinsert' and 'ncupdate'.

299527 Implicit conversion from float to numeric fails for proxy tables

in ASE 12.0.x and 12.5.x. with Msg 241:

Msg 241, Level 16, State 2:

Server 'local', Line 3:

Scale error during implicit conversion of NUMERIC value '11.6000004' to a

DECIMAL field.

299611 The first server to server RPC will succeed, but subsequent RPCs will fail with 7211 error

"Can't open a connection to site '<remote server name>' because 'set up channel' message was not acknowledged"

if they are issued to the same remote server after the timeout period.

ASE reports "nconnect: connect, Connection refused" error followed by

"Cannot read, host process disconnected: <remote server name> spid: <n>" in the errorlog.

299696 In certain occasions, NT based ASE servers may tend to favor compute-bound tasks over io-bound tasks (potentially 10 times to 1) resulting in unreasonably poor performance for the io-bound tasks.
299722 DSEdit, Server Config Utilities in sybase central java edition should works as shortcuts, if the utilities are not found in the location ASE is looking for then error messages appear. One should have the option to create/delete/modify the shortcuts.
299829 If you are monitoring stored procedure usage and a ct-lib application

executes a procedure via a cursor then it's usage doesn't show up in the

stats.

299830 Feature request for a method for users to define their own rules for what is or is not a valid password.

A possible implementation of this would be to use an architecture similar to the way sp_thresholdaction is handled with last-chance thresholds.

sp_password could be modified to check for the existance of a user-provided procedure called (for example) sp_validate_password @varchar(30) password, and if it exists, pass the new password to it for checking, based on the results either abort or go ahead and change the password. Sybase would not provide sp_validate_password so that it does not get overwritten (losing the user-provided content) when installmaster was run.

299856 Provide option to 'check for digit' at the time of login
299964 Error messages were previously captured and reported by the monErrorLog monitoring table when the configuration option 'errorlog pipe max messages' was greater than 0, regardless of the value of 'errorlog pipe active'. Now, 'errorlog pipe active' must also be enabled for this to happen.
300015 When server's default character set is UTF-8, the operation to insert into text column using

parameterized language statement through jConnect fails with some multi-byte characters.

300175 Fixed that uninstaller problem. Added 1 line in UninstallableObject that sets the activeForUninstall property to false by default. This ensures that Installshield won't try to uninstall anything without the user pressing anything.
300413 The display names for tables and compiled objects (views, triggers, etc.) on the left-hand-side (tree view) now contain the owner names to avoid confusion when there are multiple same-named objects with different owners. For example, if there are two user tables both named 'test' and owned by user 'user1' and 'user2', by expanding the tables folder, the tree view items for the tables will be 'test (user1)' and 'test (user2)'.
300435 When SET PLAN DUMP for Abstract Plans is enabled, the plans for statements inside a BEGIN-END

block will be missing.

300579 There are limited password complexity checks when a new password is specified or a password is changed. The password expiration warning interval is not configurable. A new login created is allowed to operate with the created password.
300585 Query with a subquery also accessing a view with UNION ALL and some other

view with DISTINCT clause may produce a stacktrace. This happens when the

view with UNION ALL is not materialized into a worktable.

300706 A 540 error followed by a 225 error, will be raised

when accessing a table, if a non clustered index is

created on this table in the same batch.

300788 When running the installer with JRE 1.4, after clicking the OK on the Reboot dialog, java.exe will generate an error. Upon reboot, the installer may not be started automatically.
300790 When running the installer with JRE 1.4, tabbing will not change focus to Swing components, instead of skipping over them.
300807 The statement "ALTER TABLE <tablename> ADD COL <varchar_colname> DEFAULT <default value>" may cause the process to be infected with signal 10 if the default value consists of more characters than the server page size. The bad address would contain module ubffree, and the stack trace may contain routines memfreeheap() and pre_alttab().
300894 The Monitor Server in the ASE-12.5.03 Beta release has a high CPU usage after startup.
300931 dbcc settrunc may report memory allocation warnings when it is run in a database configured for Replication Agent.
300959 Modifying a variable length column's datatype to change its nullability or its length would not cause stored procedures to be renormalized. This could lead to incorrect results or internal memory corruption, which can result in timeslice errors or recursive segmentation violations.
300978 Since 11.9, a query that forces the use of a specific index using the INDEX clause in a SELECT statement and which has an OR clause, may perform sub-optimally because the special OR strategy is not considered by the optimizer. A possible workaround would be to remove the INDEX clause from the query.
301019 TDS_ROWFMT2 token decreases performance by 50% for some queries
301063 When two or more sessions are running concurrently in ASE and ASE runs out of locks and the session causing the out-of-locks error is also using temporary tables to process its query, error 216, "Attempt to automatically drop temporary table failed" may occur followed by error 1204, "SQL Server has run out of locks".
301065 DUMP TRAN using multiple stripes may produce files with very different sizes.
301072 Under heavy load conditions on ASE running on NT using SSL, exceptions arising

in the Connectivity libraries linked with ASE cause ASE to exit abruptly, with

the message "A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED. SERVER MAY NOT BE ABLE

TO CONTINUE" in the errorlog.

301161 Request to "Make the message about invalid MAX_ROWS_PER_PAGE more descriptive as to table names, and if corrections are being performed automatically while upgrade is being performed"
301177 The 'sp_stored_procedures' stored procedure does not show a procedure whose access is granted via

a user-defined role.

301236 When Sybase Central (non-java version)reads database attributes data (when rightclicking a database and selecting properties, for example) and there are more than one row with object_type='D' in master..sysattributes, Sybase central returns an error saying: The Last Query either caused a deadlock or a lock timeout.
301240 In rare circumstances, Adaptive Server will hang during recovery of a

system or user-defined temporary database. The stack trace of the hung process will

include the modules 'recover_tempdb', ..., 'pg__updateoam' and

'pg__updateoam_thru_allocpg'

301262 The command 'set lock wait' called from a stored procedure

is executed only when the procedure is compiled.

301367 The message "current process infected with 11" in the module 'bufsearch' together with a stack trace that includes the modules 'pg__gam_extend' and 'pg_gamalloc' will be reported in the error log if a CREATE DATABASE or ALTER DATABASE command is executed such that the size of the database grows beyond a 63 GB (or multiple of 63 GB) boundary.
301411 A 25000 error, "Invalid number of parameters" is reported by XP Server when executing an

extended stored procedure with a parameter list, this having been created via the

"sp_addextendedproc" procedure. This fix is enabled only by starting Adaptive

Server using -T523 traceflag.

301491 INSTRUMENTATION: The message "current process infected with 11" in the module 'kmrtmsg'

together with a stack trace which includes the modules 'smput', 'send_audit',

'form_and_send_audit', 'chk_and_send_audit' and 'ex_audit' may be reported in

the error log.

301509 ASE Replicator: The descriptions of the "truncate_numops" configurable property and the "DDBLOGTRC" trace flag were not globalized so, when displaying these in a non-English environment, these descriptions appear in English.
301590 Fixed the uninstall issue where we can't uninstall if there is no CIM (i.e. repository down, or not containing data about the product).

SybaseFeatureUninstallPanel: Added some code to figure out whether the repository is "disconnected"

Uninstallable*: Added special methods for selecting withough doing dependency checking.

301692 Sqldbgr could hang when a user attempts to run a non-existent stored procedure.

This problem is fixed by providing an appropriate error message with a trace in

the sqldbgr code and continuing to run the sqldbgr

301729 The default 'max memory' is increased from 46MB to 66MB on NT due to increased default size of the 'large i/o buffer' pool. By default the memory allocated by ASE will not increase beyond the earlier value of 46MB for servers with logical page size less than 16K. The shared memory allocated will increase to about 60MB
for 16K page size servers with the default configuration. However if the 'allocate max shared memory' config option is set to '1' then the max shared memory will be allocated, hence the memory allocated by ASE will increase to the new default 'max memory' i.e. 66MB.

Users using a non default 'max memory' configuration should take note of the
increase in the memory requirements of the 'large i/o buffer' pool and update
their 'max memory' configuration appropriately.

Users using the default 'max memory' configuration and having the 'allocate max shared memory' config option set to '1' should also take note of this change and
make sure that adequate memory is available for ASE or specify an explicit value
for the 'max memory' configuration in the config file.

301730 preupgrade may underestimate the space available in a database

if there is free space in fragments without system segment.

301771 Non sa_role/ha connection requests can prevent polite SHUTDOWN from completing.
301829 sp_sysmon was reporting high engine load on all engines incorrectly, when most of

the engines were less active and only a couple of engines were under high load.

301910 In rare circumstances for an All Pages Locked table an invalid expected

row length and offset VALUE may be reported with error message 631

"The length of <value> passed to delete row routine for the row at

offset <value> is incorrect on the following page: <value>. The expected

row length is <VALUE>. The offset should be no greater than <VALUE>".

Alternatively when the configuration option 'print recovery information'

is active the error message 3410 "Roll back transaction '<value>' -- was aborted."

may not be correctly reported.

301914 Addition of a new command "dbcc tune(loglicenseuse, 0)" for logging "license use" information into syblicenseslog.
301924 When a database is marked read only or in standby access mode, an attempt

to execute a DROP TABLE command fails to report either a 3906 or a 3944 error;

"Attempt to BEGIN TRANSACTION in database '<value>' failed because...".

301935 Arithemtic overflow error occurs when sp_configure is used to configure max memory >= 2G.
301961 Slight improvement to information output to error log when ASE encounters an unhandled exception on the NT platform
301971 Upgrading to ASE 12.5 may fail if the SYSSTATISTICS table has forwarded rows.
The message "Database '<value>': beginning upgrade step [ID 1301]: Upgrade
colidarray in sysstatistics to 2-byte column IDs" would be followed by a stack
trace in the error log showing modules 'st_upgrade_statistics', 'update' and
'dol_update'.
301972 On Windows platform, DUMP and LOAD commands leak file handles which can accumulate over a series of dump/loads, with the backupserver eventually running out of file handles and reporting the error

"nl__write_defer: write failed on socket 1: Insufficient quota to complete the requested service".

301982 XPSERVER: XP server may generate a core file when the 'esp unload dll' configuration option is set to 1.
302065 New configuration property 'cis idle connection timeout' has been implemented. The value

of this property represents seconds. However, the granularity of the timeout is determined

by the housekeeper, which wakes up roughly every minute to perform its housekeeping chores.

One of the new chores is to check for CIS connections that have been idle for a time equal

to or greater than the configured timeout value. If that is the case, these connections

are dropped, if no transaction is pending for the thread that owns the connection.

302072 Run sp_setreptable on large table with text/image column will take a long time and put

exclusive lock on the table.

302099 A 103 error, "The identifier that starts with '<identifier>' is too long. Maximum length is 30",

is reported when a statement with multiple keywords is executed and the total size of all the double and triple keywords within the command exceeds 30 characters.

302115 Provides Java samples to illustrate the usage of SQL-to-XML and XML-to-SQL mapping functionality, as specificed by the SQLX standards (part of ANSI SQL committe). The samples are available under $SYBASE/ASE-12_5/samples/JavaSql-R1 directory.
302123 ASE on windows NT will not listen on the virtual IP address in a Microsoft NT cluster system. It listens on the local node's address instead.
302165 As the size of the default data cache increase the recovery time for the database becomes slower
302167 ASE core dumps on startup if TZ (timezone) environment variable is set to an invalid value. Invalid values generaly involve a standard timezone setting (GMT, CST, etc) with an offset exceeding 12 or 24 hours (depending on platform).
302228 When running with double-byte character sets, the utility cpre raises

M_SYNTAX_PARSE error during precompilation.

302233 Implement a mechanism to detect a loop during recovery that allows recovery to be aborted

at some point so that other databases can be recovered.

302264 1. Automate the process of analyzing the server performance parameters.

2. Automate the process of deleting old inactive sessions & views.

3. Have historical server put the data directly into a table instead of a text file

302276 An erroneous 103 error may be reported by CREATE DATABASE or ALTER DATABASE that uses the FOR PROXY_UPDATE option and either a table name, owner name or column name within the proxy database has exactly 28, 29 or 30 characters.
302300 ha_role whose uid is 16391 is not documented as a sybase role in 12.0 doc
302339 Corrected scjview script to save the log to sc_error.log if exit status is not normal
302414 Database creation or initializing a device through disk init may fail on a file system or raw device when the size is more than 2G bytes on Linux Advanced Server 2.1.
302422 ASE running on NT may get into a hung state, when a session that has SSL enabled is killed.
302428 dbcc checkalloc may report error 2521 with "object id in extent=0". Revise writeup on

Error 2521 in TSG on how to handle this.

302438 A 940 error will be reported when the builtin OBJECT_NAME(<objid>, <dbid>) is
invoked such that the <objid> value is for a master database-only system table,
the <dbid> value is not '1' and the builtin is invoked from a database other
than that given by <dbid>.
302626 When Unicode conversion is on and data may expand from client's character set (e.g. iso_1) to server's charset (e.g. utf8), error 7153 will be raised when sending runtime values to image column.
302696 Under heavy load, in multi-engine system, Rep Agent processes encounter "timeslice" errors in usctconengine().
302877 Customer would like to see Sybase provide the following scripts. They have been asking for such scripts for several years now and would like to see some utilitarian scripts to help reduce manual effort with these tasks.

1. Solaris /etc/init.d/sybase script to start and stop all servers.

2. Script to do master database critical table BCPs, take snapshot of current configuration, and dump the master database.

3. System procedure to run "update statistics" on all user tables.

302892 Introduce a switch to display server-wide or database specific details for sp_displayaudit
302979 A 10367 error will be incorrectly raised when a user with

permission to SELECT a grantable built-in (SET_APPCONTEXT,

GET_APPCONTEXT, RM_APPCONTEXT or LIST_APPCONTEXT), tries

to SELECT them from within a stored procedure owned by

another user who has not been explicitely granted

to do so.

303045 The sybatch sample resource file does not include the sqlsrv.server_page_size attribute
303080 In rare circumstances, the message "current process infected with 11" may be reported in the error log together with a stack trace that includes the modules 'dol_qualrow' and 'dol__get_lock' when a data only locked table is queried. Alternatively, a 12300 error, "Internal error: in table '<value>',

database <value>, the forwarded row (<value>, <value>) pointed to by (<value>, <value>) is invalid", may be reported.

303081 Add an sp_configure option that will allow a user with OPER role to dump databases that are in "DBO Use Only".
303178 If an engine offline request causes the engine to enter the "dormant" state, and the entire server

is shutdown while that engine is still in the dormant state, the unix process corresponding to the dormant engine may still be present after shutdown.

303223 In ASE 12.5 a feature was implemented that filters rows from proxy tables mapped to an RPC so that the result set is consistent with predicates in the where clause. This has caused differences in behavior and customers have asked for the old behavior. A trace flag (11225) has been added which disables the filtering.
303270 When a SELECT INTO command fails during the data insert phase

in the given target table, then some data is mistakenly left

into it, although the target table's creation cannot be undone

at that stage.

303319 In ASE, give Sybase Central the ability to display the Quiesce Database tag for any database in the Quiesce Database hold state.
303371 Prevent QUIESCE DATABASE to become a deadlock victim as QUIESCE DATABASE

is often used in conjunction with backup strategies.

303408 The CountersCleared column of the monState monitoring table is now updated with the date that the monitor counters were last cleared by sp_sysmon.
303423 The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." maybe reported when executing a SELECT INTO

statement using views in the FROM clause together with multiple UNION clauses and a GROUP BY clause.

303508 Assertion failure in ct_con_props->ct_api_constatus() when RepAgent is shutting
down. Occurs only with diagserver and diag OCS libraries. Stacktrace will show
ra_drop_csconn()->ct_con_props()->com_bomb().
303554 On Windows NT platforms as of 12.0.0.3 ESD 3, the Windows NT performance

monitor (perfmon.exe) is unable to list counters from any configured ASEs.

303572 xpserver versions 12.5.0.2 and higher for 32-bit AIX may fail to run if the full OpenServer SDK has

not been installed in $SYBASE/$SYBASE_OCS. Attempting to run xpserver fails in exec() reporting

"Cannot load program xpserver because of the following errors: " followed by the

message "Dependent module libsrv.so could not be loaded".

303579 Request for more explicit documentation over how the inclusion of a JAR file in the java/lib directory will be treated

in terms of class loaders, to the point where behavior may differ from placing the implementation in the java/classes directory. Additionally, the documentation should include recommendations for when a JAR file should be in java/lib versus in the java/classes hierarchy.

303590 The NullPointerException at SunGraphics2D.<init> no longer occurs when clicking the Next button on the Product Selection panel of a Suite.
303695 The error 225 will be raised if a SELECT INTO statement

contains an ORDER BY with a column that does not appear

in the result select list.

303834 When a database (D1) has the 'dbo use only' option set, 923 errors are incorrectly reported when stored procedures in another database (D2) are executed by D1.dbo (who is aliased to D2.dbo) and these stored procedures reference tables in D1.
303850 When executing deeply nested stored procedures (at least 14 levels of nesting with the default stack size), the ASE server may generate a stack trace and the following messages:
"Stack overflow detected:" and "Stack guardword corrupted.", and exit.
303886 Make a utility that will automatically convert an older version of cfg to a newer version of the cfg when doing a database upgrade.
303909 @@sqlstatus values returned by a UNION ALL query having a select <select_list> = hard_coded_value is incorrect
303948 Upgrade to ASE 12.5 will fail if the trace flag 3610 is enabled. The message

"Database '<value>': beginning upgrade step [ID 1307]: executing SQL

statement (if not exists (select 1 from syscol)" would be followed by 1505

error "Create unique index aborted on duplicate key. Primary key

is '<value>'".

303960 Running REORG REBUILD on an index of a DATA_ONLY LOCKED table,

Error 12323, state 51 may be raised when running REORG REBUILD on an index

of a DATA_ONLY LOCKED table. A stack trace will appear in the errorlog with

module bt__batchinsert_log_getendpos() and bt__rebldchk_failed().

303993 Sessions with a 'tempdb_space' resource limit imposed through SP_ADD_RESOURCE_LIMIT may hang in a status of 'MAINTENANCE TOKEN' as shown by SP_WHO. ASE would need to be restarted to alleviate this problem.
304052 A query containing a like clause against a text column will incorrectly return rows where the text

column has a value of NULL. This will happen if the row previously contained a non-NULL text value,

but has since been updated to NULL.

304071 Sessions may be suspended for an unnecessarily long time while waiting for a QUIESCE DATABASE...HOLD operation to take effect.
304152 Syconfig.exe and Sybatch.exe add the Backup and Monitor server entries into the interfaces file when it configures a new Adaptive Server.
304194 CIS : An RPC call from a server in one HA cluster to a remote server in another HA cluster fails with error 11216 and 11206
304223 When connectivity release area is missing the SSL filter shared library,

a segmentation violation occurs on outbound CIS connections using SSL.

The solution is to ensure that the appropriate SSL filter with driver version

is in place in the OCS-12_5/lib directory.

Connectivity is fixing library behavior so that an appropriate error message

is encountered, instead of a segfault.

304244 New Feature request: allow backupserver to write check-sum during dump for possible data

corruption detection due to hardware problem.

304273 In rare circumstances, the sysaudits_0<n> table may become corrupted if a SHUTDOWN WITH NOWAIT is done at the same time as an audit record is being inserted into the table.
304323 When configured with SunCluster3.0 cluster, if monitoring is enabled when the monitor user is not added to ASE, the monitor program fails to start but it doesn't give any error.
304458 dump with compression not working in MacOS X backupserver 12.5.01 (GA).
304543 Multi-engine ASE occassionally fails to bring all engines online on Solaris 9.

ASE kernel reports "Process <process ID of failed engine process> exited with status 0"

in the errorlog followed by the message "current process infected with 11" in the

module 'kediagexit' together with a stack trace.

304544 When configured with Suncluster3.0 cluster, if the ha_companion.<server_name> file is not available on secondary node, failover fails with syntax errors like "syntax error at line 13 : `end of file' unexpected" on console screen.
304593 sp_sysmon now prints the full date and time when the statistics is cleared and sampled.
304690 A variable that is part of an "on" clause raises an error only if the table column has a default.
304695 DBCC CHECKDB incorrectly checks objects that are not tables.
304774 A feature request for installmaster automatically grant existing permissions.
304778 Fixed a harmless typo in helpthreshold procedure
304850 EFTS: For SOLARIS and NT only, additional vdkLanguages and vdkCharsets have been incorporated into the Enhanced Full-Text Search. Please see the Release Bulletin for more details.
304892 sp_spaceused syslogs, sp_helpsegment "logsegment", and DBCC CHECKTABLE(syslogs)

do not report the amount of log space that is reserved for rollback log records.

305016 Sybase Central to be used with unified login
305018 CIS: select from proxy RPC in a stored procedure may not return correct result set.
305035 Update two login failure messages when an invalid TDS token is received so that they print the token value that caused the problem
305058 LOAD DATABASE may fail with error 8201 "Keep count of descriptor
(objid=<value>, dbid=<value> was expected to be 1. Instead 2 was found."
after error 3121 "Index <value>.<value> (objid=<value>, indid=<value>)
may be invalid. It uses CHAR or VARCHAR columns in its key and was created
under a different sort order ID (<value>) or charset ID (<value>) than
the ones on this server (SortOrd=<value>, CharSet=<value>)." was first
raised for a table that has more than one such index. The stack trace
will report modules 'lddb_main', 'des_refreshall' and 'des__clean'.
305064 Need dsedit/dscp to have a option to enable ssl for interfaces / sql.ini
305066 Need dsedit/dscp to have a option to enable ssl for interfaces / sql.ini
305104 Lowest IO Buffer Pool Information will now be reflected in the A.S.E configuration file.
305113 On Mac OS compress dump and load to a backupserver does not work.
305133 DDLGen doesn't generate the 'with override' attribute of a Database DDL.

This caused the ddl to fail when executed against a db, which was created using 'with override' option.

305147 The order in which the rows were inserted in a Data Only Locked table via

the SELECT INTO <target> FROM <source> ORDER BY command was not predictable.

We now retain this sequence by inserting rows in the order of rows received.

305156 On LINUX platform, the Chinese, some Korean entries are missing from the locales.dat file.
305195 The stored procedure sp_sysmon could fail with arithmetic overflow errors if some of the intermediate calculation variables exceed the maxint value. Arithmetic overflow errors however are still possible. To avoid this, the monitoring window needs to be reduced.
305232 The DDL schema migration performance in sybmigrate utility has been improved.
305321 Under certain circumstances, a database dump might hang and will not proceed unless a

system database dump is initiated.

305402 An unexpected 1105 error may be reported on a database whose information

is being cached, due to the premature access of the cached information.

The likelihood of hitting this error increases when the 'number of open

databases' is configured too low.

305536 Inaccurate histograms may be generated for NUMERIC or DECIMAL columns with negative values. Sometimes error 1763, "Cannot insert rows into sysstatistics, due to multiple equal frequency values, please contact Sybase Technical Support." may be raised.
305642 Data truncation may occur on character or binary data that is passsed to

Adaptive Server as a host variable to a Dynamic SQL statement. Truncation

occurs when BOTH the following hold true:

1) The dynamic parameter marker is used as the argument to a builtin

function or a string concatenation expression. For example (using

Embedded/SQL syntax, but not limited to Embedded/SQL):

PREPARE s FROM "SELECT 1 FROM t WHERE col1 = col2 + '?'"

where the host variable data is greater than 255 bytes.

2) The dynamic statement is executed more than once, and the second

execution uses data that exceeds in length the data used on the

first execution. For example:

EXECUTE s USING :one_thousand_byte_var;

. . .

EXECUTE s USING :two_thousand_byte_var;

305687 Proxy table on ASE 12.5 doesn't contain all columns from the original table

if one of the remote columns has a default set to it. Only seems to happen in

conjunction with DC,

305738 ASE can run out of Unilib cache memory in an SMP environment,

with many simultaneous connections, each of which is configured

for a multi-byte character set (e.g. SJIS/EUCJIS)

305825 Stored Procedures folder in Sybase Central ASE Plug-in shows SQLJ Procedures also along with Stored Procedures.
305827 A 7791 error, "Unable to remap lockid for table <table_name> in database <db_name>" or error 267,

"Object '<table_name>' cannot be found." may be reported when executing a stored procedure that

does a CREATE TABLE under a IF statement and a SELECT from the same table.

305865 A new functionality has been added to perform some

simple sanity checks on 'sysgams' system table when

command DBCC CHECKTABLE('sysgams') is executed.

305952 There is no 'Generate DDL' option in the context menu for SQLJFunctions and SQLJProcedures.
305953 Provide an option to filter certain objects from the output of the database/table ddl.
306105 One session logged in with -Jsjis to a EUCJIS server with 'enable unicode conversion' initally set to 2, and changed 'unicode' to 2. When another session logs in with -Jsjis and inserts Zenkaku chars, 102 and 105 errors are raised.
306114 During the creation of a database with a size greater than 63 G-bytes,

the message "Sysgams in database <value> has <value> extents, but

the database needs <value>. Please contact Technical Support for

assistance." may be incorrectly reported in the error log.

306117 A 233 error will be incorrectly reported when compiling a procedure that has an INSERT that does not

supply data for a column having a default when the default is added using ALTER TABLE immediately after the SELECT INTO that created the object.

306145 Error 1158 may be reported together with a stack trace in the error log

including the modules 'attrib_insrow' and 'pg__allocate' when a SELECT-INTO

command is executed that has a local table as destination and a proxy table

as source corresponding to the execution of an external remote procedure.

306154 When a duplicate row or key is inserted into a table where an index

has been created with ignore_dup_key or ignore_dup_row, @@error value

is set to 3601 to indicate the command has been aborted. This value

should be zero as the duplicate key or row has been specified, to be

ignored, through the create index options.

306207 On the AIX platform, a server configured for multiple engines may die at boot time after all

databases have been recovered. Messages similar to "os_process_exists: kill failed. pid 1 Not owner"

and "engine 6, os pid 1 exited" will appear in the log.

306210 When server's default character set is utf-8 (or other Asian character sets), server stack

traces when creating over 16k nchar/unichar local variables.

306222 CIS: A 'sp_stop_rep_agent nowait' command, or a 'kill' of the RepAgent thread could result in

"current process infected with 11" stacktrace on the following functions

ra_ct_sendpassthru(), ct_sendpassthru(), and ksctsuspend().

306265 When used with Unichar values containing surrogate pairs, use of the "stuff"

built-in function sometimes causes truncation of the resulting value.

306276 With 12.5.1, sp_deviceattr will print out a reboot message when 'dsync' attribute is changed. Eg: When 'dsync' is turned 'off' for device 'emp_dev' using sp_deviceattr, you will get the message:

'dsync' attribute of device 'emp_dev' turned 'off'. Restart Adaptive Server for the change to take effect.

306295 dbcc checkstorage will unnecessarily abort after it receives an error 9962, "Access to table '%.*s' index '%.*s' in the target database failed." This can occur when dbcc checkstorage attempts to

gather metadata for a table that is being dropped.

306333 Under some circumstances Adaptive Server could send an additional return status

when a stored procedure is invoked by a client application as a remote procedure

call and a cancel attention is also sent by that client application.

306353 bcp爄nto燼 proxy爐able爉apped爐o燨racle爁ails with Oracle erro燨RA-01036
306457 ASE Replicator: Executing dump database causes the Primary Connection to come down.
306552 Error message reporting CHECK contraint violation may indicate incorrect

constraint name or sometimes no name at all.

306553 In rare circumstances trailing control characters of a CREATE PROCEDURE or CREATE TRIGGER batch are not saved in syscomments.
306566 The 'QUIESCE DATABASE RELEASE' command may fail to resume the update activity

for a given database by raising an unexpected 2222 error. This may happen if

ever the 'sp_configure' stored procedure was run subsequently to suspending

the update activity for this database using the 'QUIESCE DATABASE HOLD' command.

306573 In rare cirumstances an 1127 error, "Internal Error: The OAM has no room for new inserts. Check OAM for object <value>, index <value>.", may be reported when there are very large number of concurrent page allocations resulting in the session being killed. A stack trace in the error log will report modules 'pg__oamspace', 'pg__allocoam' and 'pg__cond_insertoam'.
306744 Performance degradation may occur when running dbcc checkverify() because index

selection may be skipped on the dbcc_faults and dbcc_fault_params tables in the

dbccdb database.

306753 example one for use of proc_role in ASE 1`2.5 Ref Manual Vol. 1, chapter 2 (docid 36271-01-1250-01) is wrong:

It reads:

create procedure sa_check as

if (proc_role("sa_role") > 0)

begin

return(1)

end

print "You are a System Administrator."

The print statement is placed past the end of the proc definition.

The correct code example should be:

create procedure sa_check as

if (proc_role("sa_role") > 0)

begin

print "You are a System Administrator."

return(1)

end

306864 When running parallel queries, the error message "ubo_object_from_slot: Sybproc invalid slot id 0"

may may be reported in the error log together with a stacktrace which includes the modules

'ubo_object_from_slot', 'uwforeachchild', 'wt_pss_family_owners', 'lock__set_sleepingowner_list'

and 'lock__check_deadlock'.

306972 In a very highly active High Available(HA) subsystem, where lots of user tasks are using a database and the system crashes, the database shutdown may not succeed complaining that there are active users currently using the datbase.
306976 With applications that use temporary tables having defaults defined on its columns from within stored procedures, deadlocks may sometimes happen involving tables Syscolumns and Syscomments.
307132 In rare circumstances, a 7949 error may be reported after a transaction log has been loaded that includes a CREATE INDEX.
307212 Extend the 'force' option of dbcc upgrade_object() to force the recreate of a stored procedure from text in syscomments.
307449 sp_checkresword shows in error that 'double and 'precision' are

reserve words.

307460 'About ASEPlugin' dialog now shows the build date of the plug-in. The copyright information is now better formatted. To open the dialog, select menu itme 'Help'->'About ASEPlugin'.
307603 RPM install overwrites customized files.
307773 When loading a transaction log dump containing a CREATE INDEX operation using a server that has a different buffer pool configuration from that at runtime, a 3474 or a 6902 error may be reported.
307785 This feature allows the user to shut down a server from ASEPlugin. The server can be either shut down immediately (with 'nowait' option) or normally. During a normal shutdown, if the server doesn't go down after a certain time period, the user has a choice to continue waiting or shut down the server immediately.
307797 On the Linux platform, improve shared memory address mapping to increase

the upper limit of ASE's "max memory" parameter from roughly 2 gb to roughly 2.75 gb.

307857 The ASE Plugin will now check at the time the backup/restore wizard is started to determine whether the backupserver is running
308175 If the ASE's default sort order is case insensitive 'nocase_iso_1',an index creation on a Data Only Locked table that has a lot of rows may cause 'dbcc checktable' to raise error 12905 "Index <indid> of object <objid> corrupt; key values in child page <pageid> inconsistent for parent page <pageid>. Drop and recreate the index".
308181 Feature request to enhance the resource governor so it can enforce limits against processes that are idle for a configurable amount of time.
308220 Space allocation is not optimal when BCP inserts rows into an indexed DOL

table using a small batch size by using -b option.

308247 The existing data type of count(*) is not enough for a customer's huge table.
308320 The code for compiled objects is displayed on a panel. The code is not formatted correctly.
308334 ASE 12.5.0.2 on Linux RH 7.2 fails to start via rc script during OS boot.
308383 For standby database, message 9215 is in the ASE log, when this is a valid condition for a standby database in a warm standby envionment.
308432 When selecting from a proxy table mapped to a directory and specifying a specific filename a search is done of all files.
308518 When creating a clustered index with sorted_data option, error 1509 Severity 20 State 1 may sometimes occur: "Row compare failure of RIDs (<pagenum>, <rownum>) and (<pagenum>, <rownum>), keycnt = <keycount>, compflags = <value>, rowformat = <value>, minlen = <value>.
308581 In an HA environment, if the primary machine fails (hardware failure), an outstanding HA connection waiting to receive data from the ASE on the primary machine may take a little over two hours to fail over properly. Decreasing the tcp keepalive time period on the OS system where the HA connection is running will avoid this problem.
308621 The message "Logical Process Manager Error: Failed to use database with id 1. Check preceding

errors related to usability of this database." is reported in the error log when loading database

'master' (with Adaptive Server started in 'single user' mode). This message doesn't affect the

load and recovery of 'master' database.

308659 Feature request to support the "with file = <name>" clause when using the dump compression feature.
308668 Add support for a new server class, RPCServer. This will enable Backup Server, XP Server and any other Open Server applications to be handled as RPC servers.
308752 A 325 error "Adaptive Server finds no legal query plan for this statement.

If an Abstract Plan is forcing the query plan, check its correspondence to

the query. If not, please contact Sybase Technical Support." may be reported

when executing a query with nested subqueries which contain an aggregate

function like MAX() or MIN() on a table that is not correlated.

308756 An 834 error, "Illegal attempt to clean buffer", may be reported in the error log if a user tries to log in to Adaptive Server while the master database is being loaded.
308785 A 8402, 6902 or 631 error may be raised during rollback of an "insert..select from view" statement where the view contains a union, and the view references a table in a different database to that where the table is being inserted into.
308823 In rare circumstances the END keyword of a T-SQL batch sent to the server used to create a stored procedure or a trigger could be missing from syscomments. This happens when the END keyword is the last keyword in the batch and there is no space or carriage return present after the END keyword.
308921 It is not possible to audit the "mon_role" system role using

sp_audit "all", "mon_role"

308938 Executing a readtext on a proxy table mapped to a directory, the length argument is ignored and all of the text is returned.
309016 Feature Request: Provide native, non-API based, compression for backupserver.
309113 Sql statement generated produces zero number of records when the

wrong record number is captured.

309170 Add to documentation steps on how to recover a secondary companion from a secondary failover mode.
309232 Finish button on a wizard is enabled when the wizard is ready to create an object. The user does not need to go to the last page of a wizard to create the object.
309287 Error message 2358 is reported when running 'sp_modifylogin' under HA
from user's default database which is not the master database.

Error message 18897 is reported when user switched to the master database
and running 'sp_modifylogin' there.

309392 With syconfig.exe 12.5, the upgrade task of backupserver may add an invalid

'-i' option in RUN_SERVER_BS file and the registry. This problem prevents us from starting up backupserver.

309433 Grid Result View truncates result set at 32760 rows without warning or error message when using SQL Advantage.
309516 EFTS: ICU locales and some filter files are missing.
309558 A 105 error, "Unclosed quote before the character string ')'"

will be raised by the stored procedures sp_password and sp_addlogin

when trying to set a password that contains a single quote.

309680 Fixed a bug in which the server does not take into account static cache parameters while allocating new resources. This will result in ovecompensation of physical memory in a pre 12.5.1 ASE server.
309719 A 2762 error, "The 'CREATE TABLE' command is not allowed within a multi-statement transaction" will be reported when one of the stored procedures sp_tables, sp_stored_procedures or sp_ijdbc_stored_procedures is executed in an active transaction.
309738 CIS: A 911 error, "Attempt to locate entry in sysdatabases for database <name> by name failed", 195 error, "Incorrect syntax near ','", and 102 error, "<char> is not a recognized parameter option" may be reported when CREATE DATABASE...WITH DEFAULT_LOCATION...FOR PROXY_UPDATE is run against a remote table.
309815 CIS: Selecting rows from proxy table which is mapped to a RPC might give ct-library error and hang the dataserver on the subsequent select when the proxy table is defined with more columns than the total number of columns returned by the RPC which it is mapped to.
309909 The message "current process infected with 11" in the module 'vu_unionpushdown' together with a stacktrace which includes the modules 'pre_aggview' and 'tmp_preprocess' may be reported in the errorlog if a SELECT INTO having a UNION clause based on views which also contain UNION clauses is executed.
309945 The peformance of the stored procedure sp_locklogin degrades in a HA environment when ASE contains a large number of logins and roles.
309989 While scanning log operations into the stable queue, ssremote may have crashed when processing a particular set of log operations in a particular order. This bug is now fixed.
310001 syconfig and sybatch delete the namepipe entry in sql.ini
310018 DBCC LOGTRANSFER with a context eauql to 100 does not display to the client columns xold_ts and xnew_ts for data modification log records on tables marked for replication.
310026 The extractjava and installjava binaries were missing from the 12.5.0.3 IR release. As a result, new binaries with fixes were not available in 12.5.0.3 IR
310085 would like to have implemented a way for the server to migrate exisiting connections from an engine to another if engine is to be offlined.
310095 remove the uniqueness requirement csysservers index
310184 A unique build number is provided for easy identification of the product. To see the build number, along with other version information, do one of the following:

- Select 'Help'->'About ASEPlugin' menu item. A dialog shows up with the build information.

- Select 'Help'->'About Sybase Central' menu item. A dialog shows the version string with the build information.

310292 CIS: signal 11 stack traces occur in syb_net_write or syb_net_read when remote connection is killed manually using 'kill spid' or when the remote server is shut down with 'no wait' option.
310384 Under rare circumstances error 2525 may be raised by 'dbcc tablealloc'

when run against a Data Only Locked table followed by a segmentation

violation in module 'getpage_with_validation' with a stack trace in

the error log resulting in the session being killed.

310388 XA: Enhancement request for keeping cursor open while making component call within same transction branch
310441 Document ASE's default locking behavior for uncommitted rows
310444 EFTS: E3-0418 (VDK 2): None of the 1 source keys were valid, error in txtsvr log for query.
310512 The -u option of the Sun Cluster3.0 install/admin script 'syscadm' fails to
UNMANAGE a resource group, if the resource group is not offline
or if any of its resources are not disabled.
310554 Monitoring table date column definitions are changed to 'datetime null' for all columns where the date could be null. Previously these were returned as 'Jan 1 1900 12:00AM'.
310668 The Extended Stored Procedure example, xp_echo on 64bit HP platform failed

with error mesage, "Could not load library examples.sl".

310685 Request to either have an absolute path for 'whoami' in the utils.ksh script eg 'usr/ucb/whoami' or a document warning to have it set in the PATH variable.
310689 ASE diagserver running on Sun Solaris may generate the diagnostic message

"### kipollsignal: resetting sigmask" continuously in the errorlog.

This problem is due to Sun Bug ID 4457358. To resolve the problem, install

Sun patch 105210-41 for Solaris 2.6, 108244-03 for Solaris 7, 109384-02 for Solaris 8.

310696 The CHECKPOINT process will get blocked on a database marked as 'trunc log on chkpt' while DBCC CHECKVERIFY is being executed in that database.
310699 CIS: Temporary proxy tables (#tempTab) mapped to remote procedures do not support "parameter columns" with names beginning with underscores.
310793 When a session opens multiple cursors on an object in a transaction that

results in promotion to an exclusive table level lock on that same object,

then other readers or writers accessing this object will not be blocked by

this exclusive lock. An 820 error may be reported by the concurrent sessions

that are trying to update the same pages.

310798 EFTS: txtsvr aborts when using combination of sequence operators, max_docs and sort_by columns.
310855 New functionality is added, so that CS- / CT-Library messages are printed at boot time when

there's a CS- / CT-Library issue.

310953 remove all references to "load tran with standby_access", as it is incorrect syntax.
310994 The sampling option of update statistics for DOL tables does not result in a significant performance improvement.
311039 When auditing an object with a long name (fully qualified database name and owner name), Msg 7604 "An unknown audit event type was received" will be reported.
311044 XPSERVER: xp_freedll failse with 'unable to unload' error due to incorrect parameter length. Recreate extended stored procedure using the following:

create procedure xp_freedll @dllname varchar(25) as external name sybsyesp

311102 Feature request to allow control of the housekeeper tasks at the database and/or cache level, such as an sp_dboption control over whether housekeeper will do garbage collection in a database in addition to the existing server-level sp_configure "enable housekeeper gc" setting, and a cache-level configuration corresponding to the "free write percentage" setting.
311168 extractjava used to truncate extracted JAR files to a size of 32K. This problem has now been corrected.
311175 When a java method executing within ASE uses the native JDBC facility to execute a query that contains at least one aggregation operation and an ORDER BY clause containing the DESC keyword, the server may terminate the connection.
311206 The following columns are monitor counters and will therefore be reset by sp_sysmon. The 0x00000002 bit is now set in the Indicators column of monTableColumns to indicate this fact:

monCachePool.Stalls

monDataCache.Stalls

monDataCache.CacheSearches

monDataCache.LogicalReads

monDataCache.PhysicalWrites

311229 New monitors have been added to track the number of recompilations of stored procedures and the reason for these recompilations. In the same way, SP_SYSMON output have been extented to report these new values in the "Procedure Cache Management" section.
311461 When the procedure cache is fully utilized, most recently used procedure plans are discarded in favor

of less recently used plans. This unintended change in the replacement policy results in more

procedure reads and lead to a performance degradation. Applications that use EXECUTE <proc> WITH RECOMPILE,

will observe a heavier degradation due to a higher need for caching new plans; creating these

procedures using CREATE <proc> WITH RECOMPILE will improve the performance of ASE.

311477 The total number of parallel queries attempted by a process is added to the monProcessWorkerThread monitoring table as column ParallelQueries. The family identifier is also reported as column FamilyID.
311574 When there exists an application binding (to a specific temporary database or to the default group), and an application with a zero length application name logs into the server, the session gets assigned a temporary database based on the first application binding that gets retrieved from SYSATTRIBUTES. An application with a zero length application name will not have any application

binding that it qualifies for. Further, it will not be possible to create an application binding for an application name of "" (i.e. the empty string).

311604 If user fails to connect to server with default charset, ASE Plugin will suggest user to reconnect using iso_1 charset, it will reconnect after get a confirmation from user.
311691 A 264 error, "Column name appears more than once in the result column list." may be incorrectly reported if a stored procedure tries to create a table with the same name as the procedure.
311722 Fix for CR 196218 causes problems with char_length() reporting a wrong length on variables with

a VARCHAR or VARBINARY datatype. This happens when the variable with CHAR / BINARY datatype is

asigned to the variable with the VARCHAR / VARBINARY datatype. A new version of the fix for

CR 196218 will be available later under CR 263837.

311724 In rare circumstances, Adaptive Server may incorrectly store SQL-text in syscomments when multiple

control characters like spaces are present between certain SQL keywords. For example

CREATE<space><space>TABLE could be stored as CCREATE<space>TABLE.

311725 Sybmigrate fails with error 4847 when trying to migrate an ASE with a single byte default

characterset to an ASE with a multi-byte default characterset

311733 Aggregate function in the Having clause returns 0 rows back
311797 There were no means of specifying user/owner of the SQLJ Function from the list of

available users for the database. This is now fixed.

311824 When using install script 'syscadm' to create ASE resouce group and
related resources on Sun Cluster3.0, the script fails if global device paths
or device group names are specified for SUNW.HAStorage/SUNW.HAStoragePlus
resource properties. Also, the script fails if multiple resource group names
are specified as a comma separated list, to the -r and -u options.
311830 Login bindings for all logins are now possible for the multiple tempdb feature.

Previously these were restricted to the 'sa' only. This restriction has

been removed. Login bindings take priority over application bindings.

(Login, Application) pair bindings are still not supported.

311877 An XAER_RMERR may be reported by 'xa_commit' when committing an external XA transaction and the Adaptive Server configuration parameter "lock scheme" is not set to "allpages". This is applicable only when native XA DTM services are not being used. In order to get the benefit of this fix, the 'sybsystemdb.dbo.spt_committab' table must be dropped before running the 'installcommit' script (the 'instcomm' script on NT). This should only be done when the table has no rows in it.
311901 Negative values for "empty page count" may appear in the output of optdiag.
311983 isql 12.5 hangs if the length of character/binary column is greater than 255 byte in one side of UNION ALL and less than or equal to 255 byte in another side of UNION ALL.
312072 A 156 error, "Incorrect syntax near the keyword 'end'." while creating a procedure or trigger could

be raised because of an empty BEGIN/END block in the SQL being used. This error is raised correctly but the procedure/trigger text is saved in syscomments anyway.

312194 On NT only, booting with -M flag overrides %SYBASE% setting/
312212 Error 11054, "The table '<table name>' is an inner member of an outer-join clause. This is not

allowed if the table also participates in a regular join clause." can be raised when executing a

SELECT INTO. The message is correct but temporary tables created during that session are orphaned.

312304 The message "current process infected with 10" in the module 'getnext' may be reported in the error log for case statement involving text conversion as one of its case elements when trace flag 289 is enabled.
312310 sybmigrate throws "java.lang.NoClassDefFoundError" exception in "sybase/scf/resources/sc/SCResourceConstants" class when parsing incorrect server entry format in the interfaces file.
312344 When creating a stored procedure from within a db-lib or ct-lib application the last command in the procedure may be excluded from syscomments under some circumstances.
312382 add information on how to setup MDA tables in a cluster environment
312432 Under rare circunstances Replication Agent can report the error 9219 followed signal 11 and stacktrace including function kbremove() when it tries to process a corrupted log record.
312480 Bad rowlengths from BCP could corrupt the target table and/or
generate errors 4837, 2624, 631. Errors 614 could follow.
This is usually caused by network/hardware/OS problems.
312518 A 255 error, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization." maybe be reported when executing system stored procedures or when querying system tables.
312541 If the interfaces file has read only permissions, dsedit will get a segmentation fault (core dump) when user clicks the OK button on the first screen.
312570 sysprocesses clientname column stores spaces instead of NULL even when it is set to NULL
312690 If a view, trigger or stored procedure was created on an ASE 12 (or greater) database that contained a "*" as a column list in a select statement, it was possible for ssxtract to either crash or generate a reload.sql file with syntax errors when extracting that object. This is now fixed.
312703 Using JDBC/Jconnect, queries against the Full-Text Search SDS (FTS) fail with the message "syntax error, near TOKEN [.]". The same failure occurs when using isql, if the user has set quoted_identifier on.
312714 EFTS: Error(): Available files (-1) less than min 5 in the txtsvr log. txtsvr process has reached process File Descriptor limit.
312813 Enable shared memory dump on DBCC error messages.
313072 The three files, make.unix, gen_export.sh and examples.imp are missing under

$SYBASE/$SYBASE_ASE/sample/esp/ on ibmaix64 platform.

313075 sp_dbcc_faultreport supports a new parameter, @hard_only that can be 0 or 1.

1 indicates report only hard faults. 0 is the default and reports everything as currently.

313088 Feature Request: enhance errorlog reporting to include: Checked out license as in 12.5
313131 On a multi-engine HP-UX 64-bit system, the message "current process infected with 11"

together with a stack trace which includes the modules 'keipanic' and 'ueshutdown' may

be reported in the error log when 'shutdown" or 'shutdown with nowait' is executed

on an Adapative Server that has started XP server.

313141 The segment size is now corrected for server which is not 2K.

The device tab of segment properties is now showing the size of device that is used by segment, not total device size. The device size can be found in database device properties which can be interlink from the device tab of segment properties.

313152 XPserver: Request for the option to set default character set with a command line option.
313219 In rare circumstances, the message "current process infected with 11" may

be reported in the error log when accessing a proxy table on another server.

313231 DDLGen does not generate definitions for Procedure Groups in an ASE whose version is less than 12.5.0.1.
313273 CIS : In a HA environment, the ASTC coordinator connecting to a companion server as 'probe' login may result in repeated connection failure and error "Msg 4073 : HA login failed. Server not in primary configuration" message
313284 sp_object_stats does not report activity on objects in tempdb.
313290 BCP operation may fail with 4837 (bad row length) or other random error when the real cause is a read failure from the network.
313300 The writeup for error 1108 in the troubleshooting guide states that the error is only raised by the diagserver. This is incorrect.
313324 In rare circumstances, a 2628 or 2583 error may be reported after restarting Adaptive Server following a SHUTDOWN WITH NOWAIT which was performed whilst a transaction that had allocated pages was being rolled back.
313417 str_replace() function does not allow specifying a null replacement string.
313431 In爎are燾ircumstances,爐he爉essage "current爌rocess爄 nfected爓ith�10"爉ay燽e爎eported爄n爐he爀rror爈og爐ogether爓ith燼爏tack爐race爓hich爄 ncludes爐he爉odule 'run'爓hen爌rocessing燼 query爐hat爑ses燼n燗VG燼ggregate on 64 bit ASE.
313444 Error 702 with a stacktrace occurs if parallel degree greater that one and there is

convertion of a char(>15) column to text value.

313459 sp_servertype stored procedure is obsolete and has been removed.
313499 DDLGen gives error for a table, whose inline default/check constraint spans multiple rows

in the syscomments.

313580 UPPER() and LOWER() functions return wrong results for Roman numeral characters in SJIS and EUCJIS

character sets.

313630 Feature request for a command or utility that can extract the segment layout for a database from the dump of a database, so that in cases where the layout of a dump isn't known, the database can be created correctly before loading the database.
313646 Customer is requesting that we add more of a description of the parameters in the Database Types Properties Files.
313706 Feature request for an option to raise an error and prevent LOAD DATABASE from loading a database that would result in segment remapping (which might result in mixed data and log segments on a device) unless a "with override" clause were provided..
313710 When using sp_dropsegment or sp_extendsegment to drop or modify a database segment, if the user is not in the database supplied as a parameter to the procedure then the procedure will mistakenly say that the user may not 'add' a segment in that database.
313720 Without this fix, TEXT/IMAGE column datatype was always showed as JAVA OBJECT type

at meta data in internal JDBC driver.

With this fix, TEXT/IMAGE column datatype is showed as TEXT/IMAGE type at

meta data in internal JDBC driver.

313734 Internal Development: Sanitized Desc. not required.
313744 Under very rare circumstances, an HA failover session may fail raising errors 6502 and 941.
313760 This does not affect English version of the ASE release.
313764 sqldbgr raises a signal 11 on ps_dl_ncmp against a noaccent ASE sort order
313804 ASE skips polling unused network types leading to too few CPU yields. This problem also causes the sp_sysmon 'number of CPU yields' to be incorrect.
313807 The sp_sysmon stored procedure inaccurately reports the number of CPU Yields in the Kernel Utilization section. Users should refer to "blocking network checks" instead. This affects ASE 12.5 on the Solaris and Linux platforms.
313809 Cross-database SELECT INTO using a view may report incorrect user types in syscolumns.
313838 On 32 bit systems, sp_configure "total memory" incorrectly accepts values that are larger than what the underlying 32 bit system platform can support.
313869 A 706 error, "Process ... tried to remove PROC_HDR ... that it does not hold in Pss." maybe reported in the errrorlog with a stacktrace which includes the modules 'free_netdiagbuf' and 'rm_prochdr' when running a stored procedure that contains DBCC TRACEON(3604) or DBCC TRACEOFF(3604) commmands.
313955 Fixed a bug in the Java subsystem where the server allocates java memory under a spinlock. The bug might show up as time slice errors on other tasks in a pre ASE 12.5.1 server.
314030 Under rare circumstances, when a SELECT max(<colname>) type query is run on a data-only locked table, with a backward scan chosen, and there are other sessions doing a lot of INSERTs to the table in parallel, the query might fail with a signal 11 in module bt__lfrow_cmp(). The stack trace will include routines bt__nextpg_chase() and bt__row_and_rid_compare().
314049 In rare circumstances, a protocol error may be incorrectly reported by an XA TM when a thread attaches to a transaction that has a branch in an Adaptive Server database at exactly the same time as another thread detaches from the same transaction.
314059 Add useful information on running processes to the Sybase Central ASE Plug-in Processes folder.
314155 Queries with GROUP BY and ORDER BY clause with DESC order may not return rows in requested order. This happens only if backward scans are enabled.
314222 On IBM AIX and HP-UX platforms, the ASE-imposed limit of 2000 on the maximum available file descriptors has been removed. This will enable more than 2000 user connections per engine, unless limited by other factors such as memory or the OS limit on file descriptors. This change makes obsolete the use of traceflag -T1627 on the HP platform.
314306 Without this fix, "getString" on Java object column will have error raised.

With this fix, the string representation of the object will returned without error.

314332 Error 1605
314435 The 3475 message, "There is no space available in SYSLOGS for process <spid> to log a record for which space has been reserved...", may be incorrectly reported when the failure to log a record is due to a reason other than a lack of space in SYSLOGS.
314463 In rare circumstances error 5854 "Configuration Error: Cannot write

out file '<file name>' due to system error '<system error message>'"

could be unable to report correctly the file name of the configuration

file specifying the message "Invalid pointer param number 2, pointer

value 0x00000000" instead of the default configuration file name.

314468 When the diagserver is run and implicit cursors are used in a client application, the following errors can be generated if all of the qualifying rows of the cursor can be returned in the CURSOR OPEN command (i.e. a subsequent CURSOR FETCH command will find no more rows):
Open Client Message:
Message number: LAYER = (4) ORIGIN = (2) SEVERITY = (6) NUMBER = (36)
internal Client Library error: There is a tds state machine error.
illegal tds token sequence was received.
This error can only happen with the diagserver, not the dataserver.
314474 CR 260642 was reported as resolved in 12.5.0.3 IR. However, the fix for the stored procedure, sp_dbcc_faultreport, was not included in the release.
314497 If a login trigger is created using 'quoted identifier', error 105 "Unclosed quote before the character string 's_proc'." may be reported at login time
314512 CIS: A subset of inserted rows will remain after a 1204 error, "SQL Server has run out of LOCKS...", is reported during the execution of an INSERT <proxy_table> SELECT FROM <local_table>.
314528 The request is to have status messages be written to errorlog during rollback of large transaction, similar to status messages from recovery process.
314697 Feature request to have a way to register a procedure in a database so that it will automatically be run (triggered) every time the database goes through recovery.
314713 Ratio is caused by a high value in "Data page CR count"

We can check the value in column "dpagecrcnt" from table "systabstats". This value is used to calculate the data page cluster ratio.

Solaris% isql -Usa -P -Drepro

1> select dpagecrcnt from systabstats where id = object_id("client_search_100_v2_t")

2> go

dpagecrcnt

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

311.000000

(1 row affected)

1>

Also we can see it in the "optdiag" output:

Table name: "client_search_100_v2_t"

Statistics for index: "idx" (clustered)

Index column list: "search_key"

Data page count: 444

Empty data page count: 0

Data row count: 10001.0000000000000000

Forwarded row count: 0.0000000000000000

Deleted row count: 0.0000000000000000

Data page CR count: 311.0000000000000000 <<<<< high value

OAM + allocation page count: 4

First extent leaf pages: 0

Data row size: 0.0000000000000000

Index height: 2

Derived statistics:

Data page cluster ratio: 0.3427835051546392 <<<< poor clustering

Space utilization: 0.0000000000000000

Large I/O efficiency: 1.0000000000000000

==================================================================================

To Reproduce this issue

// creates the table

isql -Usa -P -Drepro -itable.sql

// populates the table

bcp repro..client_search_100_v2_t in x.dat -fimport.fmt -Usa -P

// create the index with the sorted_data option

isql -Usa -P -Drepro -i idx_datasorted.sql -o idx_datasorted.out

// gather statistics

optdiag statistics repro..client_search_100_v2_t -o idx_datasorted.sts -Usa -P

314717 Add columns to the ASE Plugin Locks folder to make the contents useful for troubleshooting blocking processes and locks.
314806 HS crashes during a recording session, with the "Fatal server error: 16151/20/0: Thread '7' has

overflowed or corrupted its stack -- aborting" message in its log

314833 With this fix, FUNCTION is no longer an ASE reserved word. It can be used as object names.
314862 Internal Development: Sanitized Desc. not required.
314887 During the recovery phase of the LOAD TRAN command an "infected with 11" error

may be hit resulting in the session being terminated. The stack trace in the error

log will report modules 'th_fill_freespaceinfo', 'th__oam_extent_count' and

'pg_oam_extent_count'.

314897 If the reconfiguration of a data cache fails due to 'total logical memory'

exceeding 'max memory', a descriptive error 10879 is printed instead of

the earlier error 5861.

314938 CIS : Error message 207 "Invalid Column name xxxx" may result when select queries are executed

on a proxy table if the proxy_table's column/s have been renamed using sp_rename.

314946 When conversion errors occur during implicit conversions from unichar to char data types, error 2402 was not being raised.
314951 CIS : In a HA environment, proxy database creation fails to import users whose name in the database is different from their server loginame.
314992 Support for SQLX standards in ASE 12.5.1 XML engine.
315018 Doc Bug. On TSQL (ASE12.5 ) page 14, it should be:

"You cannot use the modulo operator on smallmoney, money, float,numeric or

real columns."

315026 The error 7602, "There is no such audit option", will be raised by the procedure sp_audit

when trying to set up ha_role auditing.

315035 Add update statistics feature. User can display/update/delete statistics for tables/columns/indexes.
315040 dbcc checkdb(<dbid>) when run on a database during failover

may result in Error: 12324, Severity: 21, State 1.

315057 References to database names, server names, and replication agent names

in localized (non-English) error messages may be incorrect on 64-bit platforms.

315072 A 1265 error may be raised following error 540 if the SQL batch being executed contained a DELETE prior to the current statement.
315098 A 266 error, "Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is

missing." will occur when executing a stored procedure in CHAINED transaction mode that contains RETURN <value> statement.

315116 With the HA agent scripts provided with ASE 12.5.0.3 ESD#1 for SunCluster3.0, creation of the ASE resource (of type SY.ase) fails.
315182 The source text of compiled objects such as views, stored procedures, etc which is stored in the system table syscomments when they are created, may contain rows with less that 255 characters of text when those objects contain statements using "SELECT * FROM ...".
315237 The execution of DBCC CHECKTABLE on a Data Only Locked table having fixed length rows may continue to report the message, "The total number of pages which could be garbage collected to free up some space is <number>", even after having run on the given table the REORG RECLAIM_SPACE or REORG COMPACT commands.
315292 If the stored procedure, sp_procxmode, is executed without a value for the parameter @tranmode (i.e. sp_procxmode proc1) and then executed again with a value for @tranmode (i.e. sp_procxmode proc1, "chained"), the following error message is generated:

Msg 7981, Level 16, State 1:
Procedure 'sp_procxmode', Line 93:
The new transaction mode must be unchained, chained or anymode.

315335 Create a db through Sybase Central Java version, the size of database field got reset to 0 when go over 9999MB.
315370 DBXray: DBXray gets "SQLException: JZ0I5: An unrecognized CHARSET property was specified" when connecting to ASE using the roman8 default character set.
315403 When Changing ParaWhen Changing Params Via Server Config that require server shutdown(changing Character sets), server config stops the NT service, but then starts up ASE Via RUN_file. The Service indicates that the ASE is not up, but in fact it is Running.
315512 Request for ASE Replicator to be available on Compaq/HP Tru64 Unix
315516 In a Warm Standby replication environment, replication of a system stored procedure fails when

issued via execute immediate or from within another user stored procedure.

315557 sp_dbcc_evaluatedb can underestimate the size of the text scan workspace if a database contains a TEXT column. This fix is made available in a new version of sp_dbcc_evaluatedb by the re-execution of the installdbccdb script.
315661 The server incorrectly sends TDS_DONE instead of TDS_DONEINPROC

packets when the SQL statements are executed using EXECUTE IMMEDIATE

inside a stored procedure.

315756 DBCC CHECKSTORAGE may report a 100016 fault (page allocated but not linked) after a parallel sort is used to create a placement index on an unpartitioned table.
315857 CIS : Server Error Message 30291 may be returned by UPDATE STATISTICS of a proxy table if the proxy column on which statistics is gathered has been renamed via sp_rename.
315897 When server is configured with a multi-byte character set, select object_id(' ')

stack traces and the connection is terminated.

315955 An attempt to read a row from a corrupt page may result in memory corruption as column lengths within a row are misinterpreted.
315966 A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC CHECKTABLE on sysdatabases" followed by a 225 error "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization" may be reported when executing a SQLJ function

from a recently loaded database.

316088 Sybase Central C++ Plugin does not generate correct DDL for a table with identity_gap defined. This problem has been fixed in the Java Edition of the ASE Plugin. Customers should install the ASE Plugin and Sybase Central components from the ASE 12.5.0.1 or later releases. The Java Edition of the ASE Plugin can be used to administer ASE 12.0 and

later servers.

316100 A 7745 error, "Attempting to add a new identity field to a table '<table name>', via select into, which would have a field '<fieldname>' that inherits the identity property.", could be raised during a SELECT INTO. The error is correct but previously created temporary tables are lost.
316101 The message "current process infected with 11" in the module 'xls_sessionid' or 'xact_getxactkey' together with a stack trace that includes the module 'sysxacts__fmtrow_from_xdes' may be reported in the error log when selecting from the table systransactions.
316121 Internal SQL usage can cause stack overflow and/or stack guardword corruption in ASE 12.0 and

subsequent versions up to and excluding 12.5.1.

316146 This bugfix augment functionality of newid() builtin provided in 12.5.0.3.

a) newid(), newid(0) will return GUID as VARCHAR with no dashes

b) newid(1) will return GUID as VARCHAR with dashes

c) newid(0x0) will return GUID as VARBINARY (any varbinary as argument will return

GUID as VARBINARY).

d) newid() builtin in select statement or used as default will generate new

values for every row that is selected or inserted (in case of defaults)in

the statement. TRACEFLAG 395 will disable this behavior.

The following example will explain this new behavior.

create table T1 (c1 varbinary(16) default newid(0x0), c2 varchar(30)

null, constraint pkey primary key (c1))

go

insert T1 (c2) select name from sysobjects

go

--- The above example there will new value generate for every row in sysobjects

316198 Because of a memory leak, queries that send Java objects to non-Java capable clients (such as ISQL) could fail with an java.lang.OutOfMemory Java exception. This exception originates from "java.lang.String.<init>(String.java:244)"
316203 Improve DDLGen performance by improving processing of object permissions checks.
316206 Feature request to support tape devices for compressed backup feature on Windows platform.
316222 Changes are added to increase the performance of a temporary table drop. When not in DDL-IN-TRAN mode, the locks held on system catalogs are released before the post commit work itself is done. This is implemented under the 3706 command line trace flag.
316236 Showplan may report incorrect buffer pool sizes when simulated

statistics are used and Adaptive Server's configured page size

is greater than 2k.

316247 An XAER_PROTO status may be returned by XA commands like xa_end() or xa_commit(ONE-PHASE) if a resource error (such as an "out of locks" error) occurs during detach processing. Further attempts to attach to the transaction (for example by xa_rollback()) will then fail until Adaptive Server or the Transaction Manager is recycled.
316285 A 103 error, "The identifier that starts with '<identifier name>' is too long. Maximum length is 30", is sometimes raised when using long variable names.
316300 The DDLGen utility does not interpret object names containing the underscore ('_') or caret ('^') characters correctly.
316426 When booting the server for the purpose of rewriting the master database, if the user supplies command line arguments -w master, -b, and -f, but NOT -z, the server encounters an arithmetic exception (divide-by-zero). It shuts down without rewriting the master database.
316439 The backup server definition in the snmpagent.cfg file had a typo (locahost instead of localhost).
316483 In a highly parallel environment, clients to ASE may temporarily encounter a high degree of latency when a large number of clients abnormally disconnect.
316519 User does not need to configure the browser for the HTML help pages. ASEP will do that internally.
316550 The message "current process infected with 11" in the module 's__altertab' may be reported in the error log if the command ALTER TABLE ADD CONSTRAINT PRIMARY KEY uses paralelism to create the index, and it fails due to any kind of error.
316587 Remove the recommendation to offline engines from sp_sysmon.
316601 When ANSINULL is on, datatype rules may be violated if the rule allows NULL for the datatype.
316655 Running checkstorage on Linux ASE 12.5.0.x results in numerous sddone errors being reported in

the errorlog if the database being checked resides on raw devices/partitions.

Problem does not exists for filesystem devices.

316726 Internal Development: Sanitized Desc. not required.
316744 ASE 12.5.0.3 CPU utilization may go to 100% when "enable housekeeper GC" is turned on and databases contain old open transactions.
316835 When ASE is running on some versions of HP-UX, waitfor delay time is incorrect when

"sql server clock tick length" is set to 10000. This is due to a bug in HP-UX

being investigated by HP-UX PM scheduler team; the bug id is JAGae81924.

316838 Request to implement DIRECT IO for ASE filesystem access on Digital Unix
316903 INSTRUMENTATION: The server may report a large number of delayed net i/o and eventually

hang because of corruption in an internal queue of i/o structures.

316942 Allow use of parallel query under Small Business Edition license option.
316975 When "stringsize" is set to a value greater than 255, and a query returns a NULL Java object, the client process hangs, and has to be killed.
317000 Feature request to add a mechanism to ensure/check that the local backupserver

is indeed on the same box as ASE.

317014 AIX Install Guide omits upgrade from version 12.0
317098 DATATYPE: User defined datatypes can be mixed up for cross databases SELECT INTO statements with aggregate
317105 The NT sybatch.exe prints the progress tasks to the standard output.
317108 In rare circumstances on a multi-engine server, an undetected deadlock may occur when running 'sp_object_stats' while there are a lot of concurrent table drops.
317137 Internal Development: Sanitized Desc. not required.
317174 When issuing an ALTER TABLE to add 2 or more columns with user defined datatypes that are

not null and where no defaults are defined, the sql server may receive a signal 11 and terminate the client process after issuing a 4997 error:"alter table <tabname> failed. Default clause is required in order to add non-NULL column <colname>." The stack trace in the errorlog may include modules scanstypes(), palt__ck_add(), palt__ck_subclauses() and pre_alttab()

317179 The message "current process infected with 10" in the module 'plc__flush' together with a stack

trace which includes the modules xls_preflush, finishlog and xact__endxact may be reported in

the error log if in chained transaction mode a transaction is opened in a Java method and rolled

back, commited or used outsite this Java method.

317198 Inconsistent results from parallel queries.
317238 Synchronous signals are blocked when signal handler is being called. On some occasions, this can cause ASE to loop if a signal 11 is raised during the execution of the signal handler.
317262 The error 10364 has been modified not to include english hardcoded 'or'

clauses.

317296 The message "process infected with 11" in the module 'bufunkeep' may be reported in the error log together with a stack trace that includes the modules 'apl_getnext_level0', 'level0__findrow', level0__getnextrow' and 'level0_restart' during a CURSOR FETCH at isolation level 0 (read uncommited).
317300 The SP_TEMPDB SHOW, DB command will display the list of all user created temporary databases also.

The SP_TEMPDB WHO, <DB_name> will also display application name through which Login

is associated with the mentioned <DB_name>.

317305 Native XML handling capabilities implementation in ASE 12.5.1. This includes support for XPATH subset of XQUERY, support for XML transformation using 'FOR XML', XML mapping and number of other performance improvements.
317310 A 10330 error, "SELECT permission denied on object <object>, database <database>, owner dbo"

may be incorrectly reported when a stored procedure executes a SELECT ... UNION on a table in

a different database."

317331 ASE will stop accepting subsequent RPC calls (until it is restarted) after one fails with an error

1601 in the errorlog.

317405 If during a cursor FETCH a severe error such as runtime conversion

error (overflow, divide by zero, format error, etc.) OR subquery

error like 512 OR a deadlock is hit, then a subsequent cursor FETCH

may fail with error 803 resulting in the session being killed with a

stack trace reported in the error log showing modules 'curs_fetch'

and 'bufkeep'. With this fix, the default behaviour is to end the cursor scan.

However, if Adaptive Server is started with the 589 trace flag, then

the cursor is implicitly closed instead.

317437 Creating a placement index on a large data-only locked table with allow-dup-row option may cause corruption if there are a lot of duplicate keys. DBCC CHECKTABLE may report 9999 or 12905 errors.
317449 Null supplied row may not be returned for an outer join query if WHERE clause or ON clause has

a predicate with a column from inner table and ISNULL builtin function that has NULL constant

or @variable as a 2nd argument of ISNULL builtin.

317553 The commands CREATE INDEX and DROP INDEX are not audited.
317577 bcp爋f爐ext爋r image data into爌roxy爐ables爉apped to燚irectConnect for Oracle爁ails爐o爄nsert燿ata.
317596 Checkalloc shows performance regression in 12.5.0.3 due to inefficient large I/Os. sp_monitorconfig does not accurately display the details for the 'number of large i/o buffers' config parameter.
317639 jdebug hangs when attaching to vm.
317648 Update "Configure Adaptive Server Failover for Veritas" documentation for version 3.5, it still mentions 1.3.0
317657 dsedit directory location should be $SYBASE/$SYBASE_OCS/bin instead of $SYBASE/bin in the doc set.
317658 User cannot delete or modify the default EJB listener which the EJB Server is listening to.
317659 When server's default character set is GB18030,

the "--" comment style in stored procedures does not work.

317669 The definition of enabling "allow resource limits" in Sys Admin guide is misleading. Need to include info about showplan on or statistics on as well
317675 [Internal Only] Undetected deadlock occurs in some cases in a HA

system when failover occurs with databases being recovered in

parallel.

317778 If an article in a publication was created with a SUBSCRIBE BY clause that selected from a view, and the view was written using "*" as the column list, or if the length of the view exceeded 255 characters, it was possible for ssremote to fail when trying to process operations on the given article with the error "Unable to find subselect clause in view, please make sure your views are formed correctly". This is now fixed.
317910 Internal Development: Sanitized Desc. not required.
317912 CIS: Inserting a date value into Oracle database via DCO12.5 may result in error ORA-01855 in non-US NLS environments.
317976 On a multi-engine server, user tasks may terminate with 3702 state 1 and 216 state 3 errors while dropping a temporary table.
318018 Executes sp_configure 'allocate max shared memory', 1

Received Msg 5850. All subsequent exections of same command are OK.

318085 Max_used value when executing sp_monitorconfig on "number of large i/o buffers" returns wrong value in 12.5.0.3 as compared to 12.5.0.1
318165 User can access Monitor GUI from Java ASE Plugin. This only works for Windows platform.

Go to server properties -> Monitor Server tab. Choose the monitor server name and select Display monitor folder.

318325 The "New Functionality in Adaptive Server Enterprise 12.5.x" under the heading "Using sp_monitorconfig with optional second parameter", has a number of typing mistakes.
318381 DBCC CHECKTABLE on an empty DOL table results in an incorrect empty page count.
318543 Component Integration Services User's Guide, Adaptive Server Enterprise12.5UNIX and Windows NT, Document ID: 32702-01-1250-01, Last Revised: May 2001

Chapter 2 Understanding Component Integration Services

Configuration and tuning

Using sp_configure

Dynamic reconfiguration

CIS dbcc commands

dbcc mempools should be dbcc mempool -- remove the (s)

318561 Execution of SQL with lock table as the first statement of a chained transaction gives error message 12104.

With this fix, in addition to DELETE, INSERT, OPEN, FETCH, SELECT and UPDATE, LOCKTAB can now be used in chained transaction mode to start a new transaction.

318638 Ignore the setting of traceflag 289 if proxy tables are involved in the query.
318704 In rare cases, DBCC CHECKALLOC may report a 2546 error on SYSLOGS after Adaptive Server is abnormally shut down and restarted.
318732 New feature to support automatic database expansion for segments and devices. New install

script, installdbextend, provided as part of SYBASE release that provides generic threshold

procedures which perform automatic expansion at run-time.

318734 On Linux, if a dump is made with the compress option, the dump archive

cannot be greater than 2GB. The problem is fixed by providing

large file support in the compress module.

318756 Under certain unusual load conditions, it is possible for 2 or more CPU bound tasks to block other tasks at the same priority for an unacceptably long time
318782 CIS: Execution of a SELECT statement from a proxy table which was created using the CREATE PROXY_TABLE syntax on a multibyte character set server causes error 208.
318820 Internal Development: Sanitized Desc. not required.
318890 Feature request to have sqldbgr display more source-code context at breakpoints.

Currently, sqldbgr displays just the line of code the breakpoint is on. Request is to have configurable options to display the <x> lines before and <y> lines after the current line being traced. Another alternative would be to have a GUI interface that displayed the entire source for the procedure and indicated the current line via highlighting.

318893 In rare circumstances ASE can return incorrect results when a division is done using 2 numeric

whereby the divisor is very large.

318896 In certain circumstances, SELECT INTO can create a numeric column with precision greater

than the maximum allowed by the server.

318945 Langinstall fails with 102 and 105 errors when installing thai utf8.
319016 Killing a process, parent or child, involved in parallel query execution might in certain cases cause a stack trace in the parent process.
319075 A 277 error, "There was a transaction active when exiting the stored procedure '<proc>'. The

temporary table '#<table>' was dropped in this transaction either explicitly or implicitly.

This transaction has been aborted to prevent database corruption" is reported when

a stored procedure that creates and drops a temporary table in a temporary database

that has the "ddl in tran" property, is executed within a user transaction.

319091 A select statement from a proxy table mapped to an Oracle RPC fails to return any rows when a smalldatetime column is used in the where clause.
319113 A TEXT or IMAGE column that is defined as NOT NULL can still be assigned NULL value through a variable that contains NULL.
319207 Shared memory dump feature does not work for timeslice errors on Sun Solaris.
319219 During DUMP DATABASE or DUMP TRANSACTION of a database with the "trunc log on chkpt"

option set, checkpoint process bypasses the database entirely instead of checkpointing

the database. If a database dump takes one hour, the target database will go one hour

without an automatic checkpoint, despite any activity during that time.

319256 On Windows platform, the configuration file is not copied to the new directory when upgrading ASE

using a separate directory. The resulting ASE is then booted with the default configuration values.

319284 When multiple BCP sessions append data in "fast" mode to the same slice of a data-only locked partitioned table, if one session aborts, then the subsequent creation of a placement index with the SORTED_DATA option may not be done correctly. Consequently, queries that use this index may not always return correct results.
319297 sp_sysmon reports inaccurate spinlock contention values showing greater than 100% spinlock contention at times.
319304 Replication Agent processes unnecessary transactions generated by maintenance tasks such as Housekeeper Garbage Collection, table statistics flushes, reorg command or update statistics.
319327 On the diagnostic server ("diagserver") on 64 bit systems, executing queries that perform Java operations could cause the following error to be printed on the errorlog: "Assertion failed: 'sizeof( VMMethod ) == sizeof( VMMember ) + 19*sizeof( VMword )' in /remote/pea_bld1/main/porttree/svr/sql/generic/jvmsource/p/vmclass.p:811"
319374 Null extended row may not be returned, if OR condition is specified for an index column in the inner table of an outer join and 3 or more tables are involved.
319389 A sub-optimal query plan may be generated for queries using MAX() or MIN() together with WHERE clauses that involve OR clauses.
319397 Allow a transaction that is in a "Done" state to be heuristically committed using dbcc complete_xact() by using "1pc" (an abbreviation for one-phase commit) as the third parameter. This should only be used if there was a single branch in the distributed transaction and the transaction manager used the one-phase commit optimization protocol to attempt to commit the transaction.
319403 sp_sysmon reports incorrect values for 'Max ULC Size During Sample' and a few other rep agent related high water mark values.
319451 A 3474 error may be reported on a sysindexes page after loading a transaction log which was dumped after the reboot following a change to the default character set or default sort order.
319452 The message, "current process ... infected with 11" together with a stack trace that includes the functions 'lwp_create()' and 'sqt__copy_chunks()' may be seen in the errorlog when a Dynamic SQL application is running against an ASE server that is using a multi-byte character set.
319472 The message "timeslice -<value>, current process infected" in the

module 'des__clean' or 'des__unlink' together with a stack trace that

includes the module 'sqt_free' may be reported in the error log

when ASE is cleaning the Light Weight Procedure objects of a session.

This error results in ASE shutting down.

319482 Monitor Client Library and Historical Server lack error messages
319501 Query having a subquery and selecting from a view which also has some subqueries may sometimes return incorrect results. When executed with the SHOWPLAN option ON, the output shows that multiple subqueries have the same subquery number.
319523 Excessive network traffic can be seen in ASE 12.5 for queries selecting a lot of columns.

With the introduction of wide columns in ASE 12.5, a new TDS packet "TDS_ROWFMT2" was introduced

to accomodate the increased length in the data rows. There are additional meta data in "TDS_ROWFMT2"

which lead to the increased network traffic. Performance improvements were made to cache the meta data, as

well as providing an option to disable the transfer of the new meta data in "TDS_ROWFMT2" via -T7705

traceflag.

319600 If the dbcc_exclusions table exists when the installdbccdb script is run, the dbcc_exclusions table will be dropped.
319605 Under some circumstances an UPDATE STATISTICS command on a proxy table might fail with a series of errors including 103, 102, and 105.
319671 The error 8204 is raised when an invalid system table id (< 100) is passed to the built-in function object_name().
319885 The execution of the DBCC CHECKALLOC, DBCC TABLEALLOC, DBCC TEXTALLOC and DBCC INDEXALLOC

commands with the FIX option may result in removing OAM entries that show 0 pages allocated

and 0 pages used. Similarly the OAM chain may be extended should there be a need for this.

319890 The message "process infected with 11" may be reported in the errorlog together with a stacktrace

which includes the modules 'res_find', 'resgotos' and 'sqlpars' if a CREATE PROCEDURE is executed

with a very large number of parameters, local variables and goto labels.

319900 SYCONFIG.exe creates a new ASE server using "NLWNSCK" Driver instead TCP
319980 The performance of BCP in "fast mode" (partial logging) is poor when the target table has a TEXT or IMAGE column.
320007 In rare circumstances, DBCC CHECKDB will report 2540, 2546, 7940 or 7949 errors after a BCP "in" operation has been aborted and the target table is data-only locked and has at least one index.
320009 ASE 12.5.0.x on Linux stacktraces on startup if the i386 glibc libraries are being used.

ASE does not support i386 glibc, install i686 libraries.

320027 Currently all stored procedures referencing a table changed by ALTER TABLE MODIFY <column> or ALTER TABLE DROP <column> will be renormalized. Under some conditions renormalization may not be sufficent. Command line trace flag -T7706 should be used to force automatic regneration of stored procedures from syscomments text instead of simple renormalization.
320076 The execution of DBCC TEXTALLOC("all") will mistakenly raise error

2501 "Table named all not found; check sysobjects".

320167 monProcessActivity.TempDbObjects is not cumulative but shows a moment in time value. This column should be cumulative and report the total number of temporary tables created by the process. The number of worktables created by the process should be separately accounted for in a new column called WorkTables.
320173 Error messages "kernel ncheck: poll, POLLNVAL on fd xx" are logged continuously to errorlog
320178 When the configuration parameter 'number of pre-allocated extents' is set to zero, or ASE has been started with -T1101 to disable large page allocation, a BCP "in" operation may terminate with a stacktrace; modules 'bulk_main', 'bulk__fast_dol_update_lastpage' may be seen in the errorlog.
320193 dbcc checktable() reports Error 2578 for unpartitioned dol tables and

Error 9923 for partitioned dol tables, if the previous page value stored

in the first page is not 0.

320218 Upgrade to 12.5 will fail with error 2601 (duplicate key) while processing upgrade step 1274 if sysroles already contains an entry with lrid equal to a preselected value. This causes the upgrade to fail.
320289 In a symmetric HA configuration, if a failover property enabled
connection is terminated due database shutdown, a ha operation,
the connection will be able to reconnect once the failover/failback
is complete.
320354 Update statistics on a proxy table mapped to a directory returns a syntax error (Msg 11204).
320360 The system roles server id ('suid') in SYSUSERS is incorrectly set to

'-uid' when a database is created or upgraded.

320377 The rows for attributes 'default cluster ID' and 'current cluster ID' are not

inserted into sysattributes table, instead the rows for the definition of those attributes

are modified. That leads to the corruption of the sysattributes table.

320421 The message "CT-LIBRARY error: ct_results(): protocol specific layer: external error: There is a tds

protocol error. An invalid datatype was received." is raised when executing a SELECT on a view

containing a UNION clause with SELECT's having a NULL, like SELECT col=NULL, on each side of the

UNION.

320440 When server is booted with traceflag 3607 or 3608, attempts to access dynamic system tables such as sysprocesses, syslocks, syslisteners and syscurconfigs are infected with 11. On 12.5.x the stacktrace includes functions com_crt_worktable() and com_faketables(); on 15.x the stack includes CgLavaUtils::CgCompFakeTable()
320444 Enable a text column in a table, to be altered from "NOT NULL" to "NULL".
320498 Queries like SELECT <expression1>, <CASE expression2> FROM ... WHERE GROUP BY <expression1>, <CASE expression2> may sometimes return duplicate rows if expression2 contains expression1.
320582 sqldbgr's where command causes an exception in sqldbgr if name of the procedure that is being debugged is greater than 24 characters or 28 characters (dbo.proc_name)
320653 "dump on conditions" parameter should say "sp_shmdumpconfig" instead of "maximum dump conditions", as the stored procedure is what displays the conditions that are set. "maximum dump conditions" just displays the number of conditions that you can set.
320654 "appl_only" and othe sysmon sections should be documented as 2nd parameter of sp_sysmon
320692 New Feature Request that STATISTICS IO information is returned from queries involving proxy tables.
320719 Configuring a large procedure cache results in an '#' before the Memory Used column in sp_configure output.
320734 Fixes rare database corruption problems such as 694 or 692 errors seen during the load of a 12.5.0.1 and above database on NT.
320745 In rare circumstances, recovery may report a 2622, or 12546 during a server restart

following a crash or a SHUTDOWN WITH NOWAIT when the configuration option 'housekeeper free write percent' was non-zero.

320774 Upon successful server configuration, sybatch.exe exits with 134 instead of 0.
320818 Builtin that can return null (e.g nullif) used in where expression doesn't return null

result

320868 A recovery error (such as a 624 error) may be reported during server startup or DBCC CHECKSTORAGE

may report 100004 errors after server startup on a user-created temporary database.

320893 Directories and files mapped to proxy tables now have a file path limit of 255 bytes. Attempting to open a file with the fully qualified name greater than 255 bytes will fail with a file name too long error.
320913 When configuring for SunCluster3.0 cluster,
"sp_companion <secondary_server>, configure" command fails to set
the ASE resource property 'Secondary_companion_name' and doesn't report
the error.
320936 Request for built-in statistical functions including median, standard deviation, variance, correlation coefficient, linear regression
320937 When an invalid configuration group is found in the configuration
file, during boot, ASE prints a message and continues to boot.
Prior to this fix, ASE failed the boot.
320945 Enable implicit conversions between unichar/univarchar and datetime/smalldatetime.
320965 At recovery, attempt to recreate a temporary database when it's devices were not active

could result in failures while attempting disk i/o. A database should not be recovered

if it's devices are not available.

320979 Table scan may be chosen over nonclustered index scan if 16k I/O pool is configured.

Fix is disabled by boot time trace flag 397. (396 on 12.0)

320994 The command DBCC PRINTOLOG always uses the maximum length of the parameter instead

of using the actual length.

321022 The database options for database properties will be retrieved from stored procedure - sp_dboption.
321026 The drop of a java function doesn't correctly cleanup the Syscolumns table,

resulting in 2513 error from 'dbcc checkcatalog'.

321096 If a slice table has a empty slice with an empty first page other than the first page of the table, dbcc checktable will falsely report 2586 error.
321106 Assersion failuare in stu_interpolate() when unichar/univarchar datatypes

are used in certain context.

321133 Instrumentation to try and determine the cause of CR 319319 in which a 3474 error is raised during LOAD TRAN.
321164 Feature request to have the backupserver dump compression module support rsynch, so that compressed dumps can be transferred much more efficiently to remote sites.
321193 When configuring ASE for the Sybase High Availability, no error message is displayed if a cluster or Operating System command fails.
321204 Concurrent inserts in a Data Only Locked table while its index is undergoing split may result in a 644 error when deleting these data rows; the inserted row ends up in the wrong side of the split position and causes the scanner not to find the index row for the associated data row (644 error).
321254 The column properties for a bit-type column always needs to be NOT NULL.

The command "create table" (T-SQL Commands in the ASE ref manual) and the stored procedure "sp_dboption" relating to the "allow nulls by default" database option (System Procedures in the ASE ref manual, and Setting Database Options in the System Admin Guide) are to be updated with comments to reflect this information.

321256 Sometimes Historical Server will receive an invalid database id from the Monitor Server causing it to report an error and fail.
321261 CIS: A 2762 error, "command not allowed within multiple statement transaction" may be reported when executing a SQL INSERT..SELECT from proxy table mapped to a RPC.
321283 MDA config parameters like "errorlog pipe max messages" do not get set immediately
321286 When the non-clustered index of SYSOBJECTS is recreated using the 'sp_fixindex'

stored procedure, the 'sysstat' column is not restored back to its original value.

321298 The Sybmon utility may report that the version of the server that was used to create a dump file is different from the version of Sybmon used to load it. The version string will appear to have some garbage characters appended to it.
321317 Feature request to allow DISK INIT to create multiple logical devices on a single raw partition (for instance, one might want to create two 32-gb logical devices on a 64-gb raw partition)
321366 In a busy system online database dumps will hang while

create index, update statistics, reorg running in parallel.

321406 DBCC CHECKSTORAGE does not check for log free space count discrepancies.
321425 additional information for error 3619
321446 The existing -p flag, used to reset the SSO password, has been enhanced to admit sa_role and sso_role as parameters, to reset the roles password stored in SYSSRVROLES.
321451 Doc Bugs related to Full Text Search

1. Should mention starting the FTS engine during the steps to setup FTS in Chapter 3 of the Full-Text Specialty Data Store User's Guide

2. Chapter 3, under the heading "Name the local server" -- Clarify that it should be ASE server and not FTS engine.

3. Chapter 6, under the heading "Starting the Full-Text Search Engine on Windows NT" --

it should be clarified that the "path to the sql.ini" file must include the filename 'sql.ini'. And if you are adding the errorlog info then it should also include the errorlog file name along with its complete path.

321452 Internal SQL usage can cause stack overflow and/or stack guardword corruption in ASE 12.0 and

subsequent versions up to and excluding 12.5.1.

321471 If you had a local and a remote ASE and configured the local ASE to use trusted login.

sp_serveroption remote_server, 'server login', true

Now do not setup the remote server to trust this server, then the connections to the remote server will fail on second attempt onwards.

321599 In some cases the message "The requested update to the OAM for object <value>, dbid <value>, index <value>, oam page <value>, would cause a negative page count..." may be incorrectly reported in the error log when an error occurs whilst running a REORG REBUILD command.
321618 When ASE encounters a TLI status of TSYSERR returned from the operating system, only the message 'System Error' appears in the error log. For a full diagnosis of TSYSERR, the current value of the global error 'errno' should also be printed.
321744 If a table has both column level and table level check constraints then only column level check constraints are generated and table level check constraints are not generated. This problem is seen in command line version of DDLGen, Migration Tool and DDLGen functionality of Sybase Central ASE Plug-in.
321862 If the 'number of sort buffers' parameter is configured to
a very large value, parallel create index may encounter a
time slice error.
321874 When the database option 'allow nulls by default' is set for the TEMPDB database,

any attempt to encrypt a stored procedure text using 'sp_hidetext' will fail with a

9941 error saying "The source text of object named '<Object Name>' with object id

'<Object ID>' is missing and it is not hidden."

321876 The 2843 error message, "The dynamic statement '<name>' could not be found. This may

be due to insufficient metadata descriptors for the number of tables and procedures

in use by Adaptive Server. Configure the serverwide 'number of open objects'

parameter to accommodate more objects." incorrectly omitted increasing the

'procedure cache size' configuration parameter as a possible solution to the error.

321884 For a newly created device, 'dsync' property could be true even when

it is specified to be false in 'disk init' command. This happens when

a device with dsync=true property is dropped followed by addition of a

new device with dsync=false using "disk init".

322006 Add new definitions for new rows added to master.dbo.sysattributes describing policies of

expansion for segments and devices. These rows are inserted and used by sp_dbextend family of

procedures that are provided as part of installdbextend script to support automatic database

expansion.

322022 The segments size is stored correctly in a 16K server using isql to check.

But, Sybase Central tool displays wrong database segments size.

322026 New Feature Request for "dictionary, case-insensitive sort order" to be supported by the cp1252 charset.
322031 ASE12.5.0.3, sa_role for login behavior changes:

now only sso_role have permissions to play with the logins;

sa_role has no permission to sp_locklogin/sp_addlogin/sp_droplogin login.

322069 When the target database contains a very large number of tables/indexes, checkstorage may produce a timeslice whose stacktrace contains the function 'pchk_pt_sched_objs'. Increasing the 'cpu grace time' parameter may alleviate this problem.
322080 ASE on Linux systems supporting KAIO (RedHat AS2.1, AS3.0) may encounter timeslice errors

under heavy i/o load on block device or file-system based device. This is followed by the message

in the errorlog similar to "timeslice -1501, current process infected" together with a stack trace

which includes the modules 'rt__daiostart', 'basis_daiostart' and 'basis_dstart'.

322084 Running the installmaster script may fail with error 247 when there's an user id in SYSUSERS with a

value greater than 32768.

322095 Enhance dump command so regular dumps can overwrite compressed dumps the same as if they were non-compressed dumps.
322138 Document changes to reflect the sa_role behavioral change for logins after CR 280196 fix.
322218 If the reconfiguration of the 'number of open databases' fails with
error 5861, then despite increasing the 'max memory' configuration
parameter to the value suggested by the error message itself,
a subsequent attempt to reconfigure the 'number of open databases'
may fail again.
322226 During upgrade to 12.0 or beyond, ASE exposes and initializes a previously hidden column, syskeys.spare1. Rarely, initializing this field may encounter duplicate rows, causing upgrade to fail in the affected database.
322328 Add an option to disable the update trigger only if it is called by the insert trigger.
322329 Certain queries involving a join between tables on columns with different datatypes and using subqueries could perform slower than expected in some scenarios because the subqueries are executed for all rows instead for only the ones that match the join condition.
322335 Attempts to drop a locked account using sp_droplogin will fail.
322368 In rare circumstances, the message "current process infected with 11" in the module "memcpy" together with a stack trace that includes the modules "bt__build_add_nonleaf_duplicate", "bt__sim_merge_pages" and "bt__sim_update_tree", may be reported during the parallel creation of an index on a Data Only Locked table and there are very few unique key values in the table.
322369 server爉ay爃ang爓hen爄nstalling爏cript 'installhasvss'爉ore爐han爋nce.
322370 Customer wants a "warning message" in the 302 output when the optimizer is not condsidering a "join" becuase of a datatype mismatch. As of today the 302 output will show 2 blocks of output for each join if the datatypes are compatible and if the datatypes are incompatible it will show just a single block.

From documentation (Performance and Tuning Guide):

Troubleshooting Datatype Mismatch Problems for Joins

If you suspect that an index is not being considered on one side of a join due to datatype mismatches, use dbcc traceon(302). In the output, look for the "Selecting best index for the JOIN CLAUSE".

If datatypes are compatible, you see two of these blocks for each join; for example:

Selecting best index for the JOIN CLAUSE: t1.int_col = t2.int_col

And later in the output for the other table in the join:

Selecting best index for the JOIN CLAUSE: t2.int_col = t1.int_col

For a query that compares incompatible datatypes, for example, comparing a decimal column to an int, column, there is only the single block:

Selecting best index for the JOIN CLAUSE: t1.decimal_col = t2.int_col

This means that the join costing for using an index with t2.int_col as the outer column is not performed

322504 Add a column the sp_shmdumpconfig stored procedure output to indicate the number of dumps already performed for each shared memory dump condition.
322517 The sp_shmdumpconfig reset command generates error message 18517 when it completes successfully.
322536 ASE 12.5.0.3 ESD#1 on Windows platform reports 'KERNEL structure not padded correctly - size = 7256'

during startup. The improper padding will not cause any problems to the correct operation of ASE,

though it could degrade performance.

322568 When using CIS and having active CIS connections the values in sp_monitorconfig

"max cis remote connections" output are not increasing and stay zero.

322575 System table sysdevices should store the type of the device like raw partition or file system etc.
322816 The data and index phases of a migration are slower when allowed to run simultaneously
322947 In rare circumstances, a 605 error "An attempt was made to fetch logical page

'<value>' in database.... Page belongs to object with id '<value>', not to

object '<value>'", a 69* error or an 806 error may be reported when a duplicate

index key is inserted into a table having both a non unique clustered index and

some overflow pages. This is a run-time error and the table is not corrupted

since DBCC CHECKTABLE does not report any error.

323035 The UPDATE INDEX STATISTICS command inappropriately raises error 11715 "Options (index name, partition number) in UPDATE ALL STATISTICS statement are ignored"
323043 Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can

report "Max_Used" quanties that exceed their configured value.

323047 Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can

report "Max_Used" quanties that exceed their configured value.

323049 Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can

report "Max_Used" quanties that exceed their configured value.

323052 Under rare circumstances, on multi-engined ASE Servers under heavy load, sp_monitorconfig can

report "Max_Used" quanties that exceed their configured value.

323081 sp_droplogin is documented to fail if the login being dropped is a user in any datasbase; however, it fails to fail (drops the login anyway) when the login is a user in an offline database.
323088 CIS: After ASE version 12.5.0.1, some SQL statements with JOIN of two proxy tables are not passed to remote ASIQ server, which causes some performance regression
323168 Under heavy load, when the JAVA VM hits PANIC mode,

it leaves the VM in an inconsistent state

323171 Add new configuration option 'histogram tuning factor'. When this option

is set to a value greater than one UPDATE STATISTICS will generate intermediate

histogram with number of steps equal to

number_of_requested_steps * 'histogram tuning factor'. This intermediate

histogram will be later compressed before storing in sysstatsitics.

The size of compressed histogram will depend on the data layout : high

frequency cells will not be compressed. As a result the final histogram should

provide much better representation of the table values.

To activate the feature execute:

sp_configure 'histogram tuning factor', VALUE

whenere VALUE > 1

Good value to use is 20:

sp_configure 'histogram tuning factor', 20

To disable the feature use:

sp_configure 'histogram tuning factor', 1

323177 The configuration parameter 'cis connect timeout' was never implemented and has been removed.
323303 When any version of ASE is running on IBM AIX 4.3.3 with ML11 patch and

a DNS entry is used in the interfaces file, ASE encounters "infected with 11"

stacktrace or "kernel ninit: cannot find host" error and fails to boot.

This is due to a bug in IBM AIX 4.3.3 ML11 patch. To fix this problem,

install IBM AIX 4.3.3 patches bos.adt.prof.4.3.3.89 and bos.rte.libc.4.3.3.90.

The problem als exists on AIX 5.1 (fixed by bos.rte.libc 5.1.0.50) and

AIX 5.2 (fixed by bos.rte.libc 5.2.0.10) also.

323328 ASE running on Linux will not start up if the limit of file

descriptors per process is set to a number greater than 1024.

323337 Enhancement request to have new Audit event codes and new stored procedures for easy monitoring of Auditing information
323338 Enhancement request to enable Sybase Central to monitor Auditing events
323444 The maximum column length of sysprocesses.tran_name is 64 bytes.
However, some rows may return upto 3 bytes more for this column
causing exceptions in the client.
323550 Eliminate "DBCC TRACEON 8399" messages in errorlog when sp_sysmon and other applications use the monitor counters
323628 Msg 103 (Identifier too long) is raised incorrectly for 29 or 30-character long identifiers.
323636 Server will not boot if Server Default Data Cache's name is not correctly set to 'default data cache' in the server config file.
323644 Queries containing DISTINCT, ORDER BY, GROUP BY or UNION or queries whose
execution involves reformatting or sort merge join strategies may get a 511
error when processing wide rows from tables with datarows lock scheme:
Msg 511, Level 16, State 1: "Attempt to update or insert row failed
because resultant row of size nnnn bytes is larger than the maximum size (mmmm)
bytes allowed for this table."
323730 An ALTER TABLE operation with ADD, DROP or MODIFY COLUMN on a large Data Only Locked table having a placement index may cause subsequent DBCC CHECKTABLE to report 7928 errors: "Index <indexname> is not consistent; found <leafrow_num> leaf rows but <datarow_num> data rows. Drop and recreate the index". Subsequent REORG REBUILD on this table may result in data loss.
323822 turning off 'enable monitoring' still logs info in the monitoring tables
323863 When configuring ASE for High Availability with SunCluster3.0, username and password of the user with sa_role/ha_role and the monitor probe user are stored in ase_login_file in clear text format.
323940 Some system stored procedures executed in user databases upgraded from earlier

releases may fail with error 11060: "This statement has exceeded the maximum

number of recompilations (4). This indicates an internal error. Please note

the error prior to this one and contact Sybase Technical Support".

323985 In the following case:

o A view references a Java type that is either system

or cross database defined.

o The view is sourced in a SELECT INTO statement.

This incorrectly generate recompilations. In the case of

a batch, this will produce a 225 error.

324165 On Windows platform, the message "Cannot get unicode conversion handle for character set id 50" may be reported in the errorlog due to an outdated libntlog.dll file.
324250 Syconfig deletes list of selected languages after installing Japanese language along after selecting UTF8 and dictionary case insensitive
324377 OMNI: ASE configured with non-default sort orders (eg: Spanish Dictionary) may get error: ksctsetlocale: connectivity library error. Operation: cs_locale(CS_SET CS_SYB_SORTORDER espdict_iso_1) when a CIS connection is opened to a remote server.
324435 Row level access rule doesn't work if the underlying datatype is BIT
324472 'CPU Yields by Engine' in sp_sysmon doesn't always keep count of individual engine yields (usually manifests as constantly 0 yields for engine 0 even though the engine is yielding).
324531 sp_helpconfig does not display help text when called with the "max concurrently recovered db" configuration option.
324546 ASE does not provide details of the cause of sending ATTENTION to Open Server applications.

For example, backup server may get "A call to srv__waitfor_read() was interrupted by an attention"

message and ASE does not indicate reasons for this condition.

324568 Sybase Central does not display number of rows for proxy table on ASE 12.5 correctly.
324573 Running a query in parallel that uses one of the builtin's day(), month(), year(), left(),

str_replace(), square(), audit_event_name(), derived_stat(), getdllname(), get_xtypeid(),

get_xtypename(), identity_burn_max(), index_colorder(), internal_encrypt(), is_sec_service_on(),

lockscheme(), newid(), next_identity(), pagesize(), show_translation(), syscol_name() may cause

internal memory corruption, resulting in the message "current process infected with 11 in

different functions, incorrect results or errors like 2511. The diagserver will print an Assertion

message in the errorlog together with a stack trace which includes the modules get_eval_param_type()

and copy__eval()

324589 When using divide (/) or modulo (%) in the where clause and the where clause

also has an or in it, depending on the position of / or % you either get

'divide by zero occurred' or some sort of result when dividing or moduloing by 0.

324625 1. in xsm create some objects

2. in diagram, put the mouse on some selected objects. you have a tooltip, but it shows only object type and not name

324638 The error 4216 may be reported in the errorlog followed by a stack trace

containing the module dmp_send_logchain, when truncating a database log

from a recently created database, or at boot time when creating

tempdb, if the log in database model is segragated.

324689 When a dynamic prepare assigns the result of coalesce(?,?) to a char type column

the query fails with error 257 (Implicit conversion from datatype 'INT' to 'CHAR' is not allowed ...)

324759 EFTS: when indexing "non-well formed XML document" with universal filtering turned on, txtsvr core dumps.
324778 xpserver does not set locale sometimes leading to wrong character translation between ASE and the xpserver
324799 Under rare circumstances a stored procedure that executes a

SET ROWCOUNT statement may raise a 9522 error: "The parameter

that specifies the number of rows in a SET ROWCOUNT statement

must be an integer with a value greater than 0." although

the number of rows specified was a correct value.

324847 Passwords from Solaris 32-bit/64-bit can be migrated to Linux using

BCP or other data migration tools and used as such. Traceflag 1650

will turn on the compatibility mode. This compatibility mode is available

only on Linux platform and only passwords from Solaris 32-bit/64-bit can

be migrated.

324962 On some platforms, the following messages may be seen at startup: "kernel ncheck_quit: no pid associated with <fd>, vsn = 32, socket type = 2" and "kernel ncheck_checkconn: Unable to identify thread for <fd>".
325003 In rare circumstances, sessions that access a given database may seem to hang while the transaction log of this database is undergoing truncation either by the 'CHECKPOINT SLEEP' task or through the execution of the DUMP TRANSACTION command.
325042 Error 2610 may be hit in module 'ncrid_update' resulting in the session

being killed when an UPDATE command is run in the 'deferred_varcol' update

mode as shown by SET SHOWPLAN and a data page split occurs. The modules

'xact_endupdate', 'def_insert' and 'linksplit' will also be reported

in the stack trace found in the error log.

325088 A DBCC CHECKTABLE for large Data Only Locked tables may take too much time to stop when interrupted with Ctrl C or killed from another session.
325280 The message "currect process infected with 11" is reported in the errorlog together with a stack trace which includes the module 'execudf' when bcp in to a table with a UDF default value.
325340 Feature request to enhance sysdepends to include references to cross-database dependencies.
325386 If an update is based on a join, the choice between the possible query-paths of the join are

only based on the costing of the query. As a result of this, potential cost differences

between direct versus deferred updates are not considered.

In certain siuations this leads to an overall bad plan.

So the request is, to factor in the potential extra costs of a deferred update

325388 Steps to reproduce behavior :

1- Creae an XML with XSD

2- Move the tool palette and docked it between the workspace and the diagram.

3- Save model and close the PD.

4- Reopen them, we will notice that the tool palette now is docked on the left of the

workspace but not between this one and the diagram

325408 Feature request to have an option for SET STATISTICS IO to return the individual statistics for each fetch, currently the cumulative total is returned for each fetch.
325414 The maximum number of ANDs or ORs in an expression level has been increased from 300 to 1024. As a result, the maximum number of values in an IN-list has also been increased from 301 to 1025. The ASE configuration value, "stack size" will have to be increased beyond the default value to avoid error 3626 when more than 300 AND/ORs are used in a query.
325452 A new command, GRANT/REVOKE DEFAULT PERMISSIONS ON SYSTEM TABLES, has been added to setup or to remove the default permissions assigned on the system tables.
325482 The ASE Replicator folder is only displayed if the ASE Replicator is installed in the ASE. The ASEPlugin uses the stored procedure sp_helpddb to determine the name of the Replicator's distribution database. If the stored procedure is not installed, then the plugin will not display the ASE Replicator folder.
325550 A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC CHECKTABLE on sysdatabases" followed by a 14208 error "Unable to execute SQLJ function .... The function schema may have changed since the command was compiled." may be reported when executing a SQLJ function

from a stored procedure or a view in a recently loaded database.

325557 Adaptive Server Enterprise for IBM AIX platforms encounters disk corruption

if a database is created or altered on the master device after the master device

has been mirrored with the DISK MIRROR command.

325572 feature request to increase speed of the time it takes to run set proxy command, regardless of the number of "enabled by default roles" a login has .
325584 Display the size of all tables in use by a process in the monProcessObject table
325627 A 804 error, "Unable to find buffer '<value>' from cache '<value>'

holding logical page '<value>' in sdes '<value>' kept buffer pool

for object '<value>'." together with a stack trace which includes

the modules 'update_statistics', 'sam__get_dol_pages' and 'bufunkeep'

may be reported in the error log when an UPDATE STATISTICS WITH SAMPLING

command is run on a Data Only Locked table that has forwarded rows.

325693 ODBC types are incorrect for unichar, univarchar when SQLColumns is called. This trnaslates to sp_columns, and the types are defined incorrectly in spt_datatype_info.
325727 CIS: selecting from proxy table with unichar or univarchar column mapped onto a remote server with char or varchar column may result in 'cs_convert: cslib user api layer: common library error' on UTF8 servers.
325729 The procedure cache may be subjected to replacement in some cases
even if free memory is available on other engines. This may
have an adverse impact in performance.
325766 Dynamically increasing the "number of devices" using sp_configure, without actually making use of them, may potentially cause the thread to terminate with segmentation violation, under

1) If you bring an engine online

2) If you try to do a failover(dbcc takeover)

325777 Executing an interactive program via xp_cmdshell can cause the XP server to hang.

For example, executing xp_cmdshell "isql -Usa -Sase12503" will cause XP server to hang.

325793 Disk init of a 32 GB device with a vdevno of 127 fails with error 5115.
325794 When configuring for High Availability with SunCluster3.0, SY.ase resource creation may fail without proper error message if the resource property Secondary_companion_name is specified for the SunCluster3.0 command `scrgadm'. User is not supposed to specify or modify this property, because the HA agent will do that automatically when required.
325849 bcp parameters -F and -L can be used for copying in or out.
325880 In installations created new at server versions 12.5 through 12.5.0.3, index sysusers.ncsysusers2 is not marked 'unique' although it should be. This can permit databases to have several users with identical user IDs (UIDs). Server version 12.5.1 fixes the index problem, but the fix will fail in a given database if sysusers in that database does have duplicate UIDs. (This problem DOES NOT affect installations that were created in versions 12.0.x or older and subsequently upgraded to 12.5.)
325914 The option SET FORCE PLAN ON may be ignored when an UPDATE has a FROM clause with more than one table or view, and the view is updated.
325943 Sub-optimal performance may result under certain conditions when

executing a query involving a MAX() or MIN() aggregate and join

operation between two or more tables because the optimizer chooses

the best index to resolve the aggregate function. New command line

traceflag provided to avoid aggregate optimization for queries

involving joins.

325947 In sp_sysmon Transaction Management section a new cause for "ULC flushes to Xact Log" has been added. This cause is named "by Unpin".
326038 Feature Request: Checkstorage fault 100006 is classified as a soft fault if the target database is not in single user mode. This CR requests that 100006 always be classified as a hard fault, even if

the target database is not in single user mode.

326039 ASE on the windows NT platform performs socket reset on shutdown.
326050 User 'guest'is always created when a new temporary database is created even when the option for creating 'guest' user is not selected in Sybase Central ASE Plug-in. The solution is not to present an option of creating 'guest' user in Temporary Database Creation Wizard as 'guest' user is always created with temporary database.
326060 The error 10812 together with a stack trace which includes the modules

'trunctab' and 'cfg_notify_current_audit_table' may be reported when

trying to change the current audit table using sp_configure, if the

process gets into a deadlock or it receives an attention while trying

to truncate the target audit table.

326076 In some cases when a very large buffer pool is configured we will see the pool configuration failing even when there is sufficient memory.
326091 Session-specific SET options 'proc_return_status' and

'proc_output_params' added to turn OFF sending back a stored

procedure's return status and/or its output parameters back to the

front-end client. These options are ON by default.

326098 Eliminate duplicate wait event descriptions in the monWaitEventInfo MDA table.
326113 When an attempt is made to insert TEXT data encoded in SJIS

using the bulk interface (e.g. BCP) on an EUCJIS server

configured with "enable unicode conversions" set to 0 and

trace flag -T2402 active, error message 7105 is generated

and the insertion fails. This occurs regarless of whether

the data actually contains any Hankaku Katakana characters

whose width expands from one byte to two bytes during

conversion from SJIS to EUCJIS; it should occur only

if the data contains such characters. Furthermore, extraction

of such data using the bulk interface (e.g. BCP out)

produces a TDS protocol error if the data contains

Hankaku Katakana characters. This should not occur.

326126 CIS: SELECT <case expr> FROM <proxy tables join> may result in wrong SQL being constructed when quickpass is disabled.
326152 Replication Agent may shutdown with a stacktrace, including function ra__pack_struct_tok(),

followed by stack overflow, when trying to process an inconsistent log record.

326158 When stored procedure text is send to ASE containing multiple keywords like CREATE TABLE,

all control characters (like space etc.) except for the last control character between these

keywords are not saved in syscomments.

326289 New generic stored procedures added to installmaster. sp_autoformat is a generic procedure

that can output a result set from a table auto-formatting character data. sp_exec_SQL is

a wrapper procedure to execute a SQL statement via 'execute immediate' and handle errors

in a single place.

326386 Infected with 11 when using a subquery and a view .
326398 ASE fails to boot on some versions of Red Hat linux with the message

"current process infected with 11" reported in the errorlog together with a stack trace

which includes a number of instances of init_dummy() module during boot time.

This is due to a bug in Red Hat's glibc patch tracked under RedHat Bug#102995

(Specifically glibc-2.3.1-30 through glibc-2.3.2-30 contains this bug;

which has been fixed from glibc-2.3.2-31 onwards).

Installing glibc-2.3.2-31.i686.rpm or later from RedHat will solve this problem.

326423 The message "current process infected with signal 11" may be reported in the error log with a stack trace that includes the modules 'dol_qualrow' and 'dol__get_lock' when concurrent DML commands are run on a DATA PAGE locked table. Alternatively, this may manifest as a timeslice error or

"infected with signal 11" messages with different stack traces.

326477 When creating a stored procedure normalization process may alter query tree

so that the potential later renormalization of this stored procedure may

not give desired effect. In such cases the only way to obtain the functionality

was to drop recreate stored procedure. This issue is related to INSERT and UPDATE

statements only.

326497 DBCC FIX_TEXT on All Pages Locked table loaded into an utf-8 server from an iso_1 server results in a 605 error after receiving 7952 error on DBCC CHECKTABLE.
326503 A positive (successful) XA status is returned rather than an XAER_NOTA error, when a thread attempts to attach to an XA transaction that is concurrently being rolled back by another thread.
326521 Feature request to have ASE automatically rebuild indexes on user tables after character set / sort order changes
326551 If the machine hostname is an invalid server name, syconfig.exe and sybatch.exe failed to configure server with default server name.
326572 When the configuration parameter 'allow updates to system tables' was

reconfigured, some times memory consumption was reported. This

configuration parameter does not consume memory.

326575 The message "current process infected with 11" in the module 'opt_like' may be reported in the error log for subqueries involving a LIKE clause referencing a correlated column of an outer query block.
326602 The maxinmum number of user connections is 5 when running under the Developer Licensde Option.
326605 Queries that involve tables that are using Referential Integrity Constraints

when executed at 'transaction isolation level 3' may not obtain a 'Sh_intent'

lock but instead a 'Sh_table' lock although the primary key index is being used

by the query.

326620 The message "process infected with 11" in the module 'dbt_curseq' together with a stack trace that includes the module 'lddb_chkcreator' may be reported in the error log when loading a database dump that was originally dumped on Adaptive Server 12.0.x.
326692 CIS : INSERT INTO <proxy table> command may insert additional EUCJIS character 0xA1C7 or SJIS character 0x8166.
326721 Sub-optimal performance may result for queries involving subqueries with non-unique

index which could be used to flatten the subquery.

326741 Feature Request: When possible, optimizer should consider row count limits, set using "set rowcount", in costing
326742 A 12301 error, "Internal error: the index (id = <value>) and the data for row (<pageid_1>, <rowid_1>) in table '<value>', database <value> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported during the execution of a SELECT command on a Data Only Locked table, when another session has concurrently updated the forwarded data row above which resulted in its re-forwarding to an other <pageid_2>, <rowid_2> location.
326743 Feature request for support of FULL OUTER JOIN syntax.
326860 For newly installed dbccdb, the dbcc_faults table will be created as DOL table with datapages lock schmem.
326863 During start up, if an ASE engine dies, the message "current process infected with 11"

in the module 'EngineExitDiagnostics' may be reported in the error log.

326866 Feature request for a command to modify the order of columns in a table
326874 Feature request to have a sqldbgr command to generate a line-numbered source code listing.
326878 Optimize the cost for temporary tables when they are created and used in the same batch file.

Optimizer uses default value of 10 pages and 100 rows to estimate the cost for temp tables when they are created and used in the same batch process.

326908 The composition of the XML Management package has been changed with this release. The new definition is contained in the file $SYBASE/SYBASE-1_0/licenses/sybpkg.dat. Any customer upgrading from 12.5.0.1 or later, who has purchased the XML Management package should compare the definition in sybpkg.dat with the one in license.dat to make sure that they have the definition that includes the ASE_XML option.
326912 HA: Upon hitting 5156 error, dynamically increasing the number of devices

on both primary and secondary does not resolve the issue.

326925 Certain minor changes are needed in databases migrating from ASE version 12.5.0.3 to version 12.5.1. However, a database dumped in 12.5.0.3 and loaded to 12.5.1 will not be upgraded automatically by "online database", even though it should.
326957 HA: HA failback operations may result in unexpected gaps for identity columns if any.
326994 when we execute sp_who the loginame displayed is Sybase User Name, but when one is using NT's integrated login feature, customer would like that sp_who or another stored procedure display the NT user name that is associated with the Sybase user name.
327005 Reconfiguration of configuration parameter 'user log cache size' caused an overflow

of 'total logical memory' that was undetected.

327015 srvbuild won't create master and sybsystemprocs devices on rxvm
327025 DBCC TEXTALLOC("all", full, nofix/fix) has been enhanced to detect/make correction for 100007 hard faults on text/image extents raised by DBCC CHECKSTORAGE.
327064 Client requests to the Monitor Server can experience long delays on very busy systems
327076 An interrupt during the automatic drop of a temporary table results in an endless attempt at retrying the drop. The connection appears to hang and will accumulate a high number of writes. These connections can not be killed and the server must be re-booted to clear them.
327103 Documentation request: add a write-up on timeslice errors to the troubleshooitng guide.
327200 Syconfig and Sybatch do not create local name server on Window platform. "select @@servername" is NULL after the configuration.
327283 A NULL value may be put into non NULL TEXT/IMAGE column when performing

UPDATE statement. This is possible if the NULL is a result of an expression

or local variable value.

327309 When calculating total memory, DBXray is incorrectly using the page size as a variable in the calculation. Memory is always in 2k pages.
327437 Feature request to have string functions such as UPPER() and LOWER() enhanced to work on TEXT as well as CHAR / VARCHAR.
327503 Allow for CSMD configuration to get a memdump for error msg "ubo_object_from_slot:%s Invalid slot id %d".
327534 The message "current process infected with 11" in the module 'Address 0x00000000 ()' together

with a stack trace which includes the modules 'send_proc_audit' and 'cast_const_to_varchar'

may be reported in the error log if auditing is enabled and a stored procedure using Java

parameters is executed.

327546 The error 923, "User <value> not allowed in database '<value>' - only

the owner of this database can access it.", may be incorrectly raised

when trying to online a database that is setup for "dbo use only", if

the database owner in the dump has a different user id from the

database owner of the database being onlined.

327560 A INSERT...SELECT with an ORDER BY (or GROUP BY) clause containing columns that are not in the SELECT part could insert incorrectly those columns in the target table of the INSERT but only when more columns have been specified in the INSERT side than in the SELECT side.
327568 CIS: When the UPDATE STATISTICS command is executed on a proxy table, CIS will

no longer issues the aggregate count SQL and the SELECT with ORDER BY statement

to the remote ASE server for gathering statistics. Instead, the new default

behavior for this will be accomplished via a new strategy that imports the

relevant statistics from the remote ASE system catalogs. This enhancement is

restricted to remote server of ASE class and may be disabled via the trace flag

11229, in which CIS will revert to the previous (old) style for gathering

statistics.

327575 When 16K pagesize is used on Linux, SGI or NT386 platforms running

ASE 12.5.0.3 ESD#2 or ESD#3, dbcc checkstorage results in 702 Error

"Memory request for 16896 bytes exceeds the size of single page of 16384 bytes".

327586 Enable AES encryption algorithm for SSL.

Use traceflag 7825 to display negotiated cipher suite.

Ability to restrict to a particular algorithm or set of cipher

suites and the ability for a user to programmatically obtain

their negotiated cipher suite is being added under a separate CR.

See 231231, also scheduled for this release.

327637 JAVA: The Java IO method InputStream.available() incorrectly returns zero on 64-bit ASE VM's.
327639 SQLAdvantage: SQLAdvantage does not display 8bit chars from unichar columns.
327695 Error 249 may be raised when xmlextract() returns a date, int or float result.
327697 ALTER TABLE raises syntax error 156 for the exp_row_size option when changing lock scheme to DOL from ALLPAGES.
327736 Entering sqldbgr options in different positions raise

ArrayIndexOutOfBounds Exception.

327744 Rows may be missing from the result set of a query similar to "SELECT DISTINCT <col1>, <col_unichar> ... ORDER BY <col_unichar>"

when the ORDER BY clause contains a uni(var)char column and not all the columns in the

SELECT DISTINCT clause are in the ORDER BY clause.

327745 Feature request: add "create" as an option on sp_role
327829 With some search conditions, a OR query against unichar and univarchar columns may return wrong results.
327860 The message "current process infected with 11" in the module 'decision' may be reported in the errorlog for queries involving joins and qualified table names.
327892 Alter table can cause an infected with 11 stacktrace.
327927 The error 3906, "Attempt to BEGIN TRANSACTION in database '<dbname>' failed because database is READ ONLY" will be raised when running the script installmaster, if there exist a database in READ ONLY mode.
327963 Merge-join two tables on cols with diff types (UNICHAR UNIVARCHAR) may give

wrong results. Also, when unique index and special-OR strategy is used for unichar

and univarcharf columns, the result set ends up containing duplicates, which are

not removed by using *distinct* in select statement.

328014 Queries that cause recursive execution of multiple levels of triggers can get a stack overflow

error with susequent server crash. The stack trace will contain multiple instances of the

function, exectrig.

328018 FOR BROWSE queries using reformat strategy may not execute correctly

resulting in the error 403 "Invalid operator for datatype op: type: VARBINARY."

328075 On Digital UNIX, in rare circumstances, a corrupted TDS login packet may cause the ASE server to crash.
328091 Select executed by non table owner causes parser error msg 107
328100 EFTS: can't create a text index on a source table who is owned by a different user id.
328208 Feature request to have each dbcc command grantable to any user, without requiring specific roles.
328211 System functions tsequal() sends timestamp to the client as the parameter.

It may be confusing if the function is used within a stored procedure.

328217 Feature request to enhance the EXECUTE command so that it can perform DUMP TRANSACTION
328246 When abstract plans was turned on, the full derived table query was not being stored in sysqueryplans.
328351 CIS : In rare circumstances, a task which issues the "set proxy" command in a HA

environment will become hard affinity to the engine.

328356 A process infected with 11 error in ct_tds_senddata can occur while running the Migration Tool when the remote server runs out of user connections.
328379 Some rows in sysattributes have tab characters embedded in the char_value field. This can cause problems for character-based bcp. ASE Engineering confirms that those strings are not being used for anything, so they should be removed.
328385 Error 7429/16/1 occurs during recovery when the database option 'no free space acctg' is turned

on after some data segments are installed. This error results in the database being moved to

a suspect state.

328539 Under heavy load, the JAVA VM hits PANIC mode and leaves the VM in an inconsistent state.
328575 The message "current process infected with 11" in the module

'proc__reset_wktbl' together with a stack trace may be

reported in the error log when executing a stored procedure

that inserts or deletes data in a table that has more than one

self-referential integrity constraints and when Adaptive Server

is configured to use multiple user temporary databases.

Later executions of the same stored procedure may raise a

8210 error, "Keep count of descriptor...was expected to be 1...".

328576 When the query sp_helpconfig 'total data cache size', '4G' is executed

on a 32bit version of ASE, a signal 11 is encountered. The stack of the

terminating process indicates kisignal()->cfg__cache_mem_sizes()->

cfg__memory_check()->cfg_main()->...

328689 Correct the two dsparser errors:

If content of the interface entry is separated by tab, then the entry is not read.

Another one: If the end of line is a new line, then NullPointerException.

328709 Some rows may not be updated when an UPDATE statement has a FROM clause with a view containing a

UNION ALL. In some cases the UPDATE may result in the message "current process infected with 11" in the module 'update()'. A DELETE using the same view in the FROM clause will result in the message

"current process infected with 11" in the module 'norm3_setop()'.

328730 The stored procedures SP_SYSMON and SP_MONITORCONFIG may display incorrect values for the "Active" and "Max Ever Used Since Boot" fields for "Open Object Usage", "Open Index Usage" and other parameter when executed in a multi-engine ASE environment.
328769 When the server rewrites the master database on a raw partition (which requires using the "-f/orcebuild" boot-time argument and either "-w master" to rewrite master or the "-z" and "-b" flags to create a new installation), the server does not initialize every allocation page on the raw partition. A subsequent "load database master" can find allocation pages from the previous installation, which can cause spurious entries in sysdatabases and/or sysusages.
328773 Optdiag output and traceflag 302 output enhanced to include sample percent used in gathering statistics using UPDATE STATISTICS with sampling command
328806 The Database folder has a total size (MB) column
328812 ASE on Solaris has TCP/IP incoming connections backlog queue limited to 5 which can

result in some of the clients failing to connect to ASE when there is a surge of incoming connection

requests to ASE. This fix enhances the backlog limit to 128 eliminating this bottleneck.

328836 Feature request to allow shared memory dumps write the dump file in parallel.
328837 Feature request for the ability to create views with a specified isolation level
328888 Database device properties dialog 'Parameters' page is removed and its content is moved to 'General' page.
328896 A new command line trace flag, 10305, has been added to allow

auditing the creation of temporary tables via SELECT INTO.

328961 Feature request for a command to reschedule a historical server session without having to manually delete the existing session and create a new one.
328976 DDL for a user 'guest' in a database (other than master), is not generated along with DDL for all users.
329033 Java/XML samples directory has been renamed to JavaSqlXml to better reflect the kind of sample program it contains.
329088 Migration setup fails due to unique index violation error on sysusers.
329096 The CR 329096 has been corrected as a bundle of CR 276282

The user requests Table Name to be included in the confirm delete message. As of 276282, instead of showing just the confirm message, a Delete Dialog will come up instead. It contains the name of the objects that are going to be deleted, also "Yes" and "No" button for final delete decision.

As a conclusion, the name of the tables that user request to be dropped will be shown in the ASE Plug-in Confirm Delete Dialog, so this CR is closed.

329099 Enhance isolation level 0 to write uncommited data.
329108 sp_helpdevice reports the amount of free space on each database device
329159 In rare circumstances, OPTDIAG, when used in input mode, might fail with message "At step xxx of the histogram for 'xxxxxx', the step value is not increasing".
329181 Upgrade (to 12.5.1) process hangs while trying to upgrade a database that is enabled for 'async log service'.
329205 Add new procedure, sp_showtext, that can re-generate the text from syscomments for compiled objects

like procedures, triggers, views, so that the output matches exactly what was submitted by the user

when creating the object. Output can be generated with line numbers, and also as a context

block of SQL text around a given line number. Output can be generated as a stand-alone DDL script

which can be then used to recreate the object in most cases. Use 'sp_showtext' without any arguments

to get usage syntax help.

329229 When the sp_configure parameter "default unicode sortorder" is set to something

other than the default value "binary", search conditions '=' and 'not ='

can result in null values being selected.

329242 CIS: In rare circumstances, sp_showplan may be infected with signal 10 or 11 and

core dumps, or causes ASE to hang in a CIS environment.

329286 In rare circumstances:

The scenario only happens when using java internal JDBC driver, and on text/image column

with NULL value and the user defined function has wasNull() API called on text/image column.

329300 sp_autoformat now also formats datatypes integer, numeric, money, date/time, float/real, and also formats user-defined datatypes and NULL values correctly.
329302 sp_lock now returns both the object name and id for locked objects.
329328 A 2603 error, "Insufficient space (<num> bytes) on logical page <page_num> of index <ind_id> for object '<obj_name>' when inserting row of length <num> bytes on index page." may be reported when an ALTER TABLE command has been previously run to change the length of a column that is part of an index.
329357 Able to create Column level constraint from column properties.

From 燙olumn爌roperties,爏elect constraint爐ab.燙lick on "Add" button, Check constraint wizard starts. In the constraint expression screen, user can click the "columns" button which opens the "Paste columns for check constraint" screen and select columns to be included for the constraint.

329375 CIS: INSERT <local table> SELECT * FROM <proxy table> inserts garbage when the proxy table has CHAR type column inserted into TEXT column of local table or BINARY type proxy column inserted into IMAGE column of local table.
329430 Feature request to put additional information regarding server name and interfaces file location in the backupserver errorlog.
329444 It is not possible to clear the "bypass recovery" indicator for the master

database if Adaptive Server is re-started after this indicator has been set.

With this fix, when Adaptive Server is booted with the 3477 trace flag, it

ignores and clears the "bypass recovery" indicator in the master database.

329454 Incorrect results may be returned for a query having more than one derived table with group by aggregates in the derived table expression.
329483 Before upgrade, when a server boots using an installation from an older version, it will produce a confusing collection of messages. The first messages say that certain databases can't be upgraded because tempdb is not available, and instruct customers to issue "online database" for those databases. The next messages say that the server is upgrading those databases.

The server DOES upgrade those databases. Customers should ignore the instruction to issue "online database".

329488 A 10711 error: "Cannot find a public method named '<method name>' in class '<class>'.

Either the method does not exist, or it is being called with the incorrect argument

types." may be raised when trying to execute a new method added to a java class

in a database that has been just loaded.

329635 ASE does not start as a service on the Windows 2003 operating system. Attempts to

start the service result in the message 'the service terminated unexpectedly'

329680 Database will be able to issue a checkpoint

Issuing a database checkpoint

A checkpoint is an automatic mechanism to guarantee that data pages changed

by completed transactions are regularly written from the cache in memory to

the database device. Each time it issues a checkpoint, Adaptive Server does the

following:

* Freezes all current data modification transactions

* Writes pages that have been modified in memory, but not on disk, since the last checkpoint, to the database device

* Writes a checkpoint to the transaction log

* Unfreezes the current transactions

329758 Feature requst for a PRODUCT aggregate function, similar to SUM, but multiplying the values rather than adding them.
329917 Execution of the DBCC CHECKSTORAGE command may take an abnormally long time to gather object information when run against a database that contains many objects.
329919 1. Remove dump tran tempdb with truncate_only sp_sysmon_collect

2. Excessive traceon(8399) messages occur in errorlog. Add filter.

329921 Feature request Sybase able to use OS new AdvFs "Direct I/O" feature
329938 Few doc bugs in the installation and configuration guide for ASE on Digital Unix.
330061 The Waits column of the monSysWaits table contains negative values once a large number of waits have occured for a particular WaitEventID.
330066 The message "nclose: Unknown servtype, 0" will appear in the ASE error log while disconnecting from

a remote site (such as backupserver) that uses a TLI network listener if ASE is not using a TLI

network listener.

330107 Feature Request: allow a local backupserver other than SYB_BACKUP to be specified in the dump /

load database command.

330159 Multiple sessions get blocked on Address locks when running Java applications.

This blocking results in a poor performance for these connections. Optimizations were made to the JAVA VM to allow more concurrency.

330178 On IBM AIX, in rare circumstances, high CPU utilization may be seen

because a server kernel thread was being sent a SEGV. Upgrading to

OS patch level ML4 on AIX causes the problem to not occur.

330279 Some of database devices failed to be displayed due to an Arithmetic overflow occur when ASE Plugin issue the SQL to retrieve the database devices information.

The database devices retrieval SQL is corrected to avoid the Arithmetic overflow exception.

330311 Spurious 100002 Hard fault reported by dbcc checkstorage when running concurrently with operations such as select into.
330319 CIS: For a query having a local table and a proxy table, OR search conditions of the proxy table will not be passed to the remote server if the local table is chosen as the outer table for the JOIN, and there is a builtin in the WHERE clause at the same time. A traceflag 11262 has been added

to fine-tune OMNI optimizer to pass OR search conditions as many as possible.

330327 The message "current process infected with 11" in the module 'run' together with a stack

trace which includes the modules 'exec_eop' and 'execute' may be reported in the error log

when executing an UPDATE SET col_name = (<subquery>) WHERE CURRENT OF cursor_name.

330361 srvbuildres using a resource file is not correctly handling sizes of sybsystemdb

when using other then the defaults

330401 enhance to support connecting to TRS and gwless
330488 In a server with CASE INSENSITIVE sort order, creating an index on a Data Only Locked table with SORTED_DATA option may cause DBCC CHECKTABLE to report 9996 errors; DELETEs on the table may fail with 644 errors.
330569 CIS: When a transaction that is executing an INSERT..SELECT (insert to proxy

table) has been imposed as the deadlock victim, the session fails to

acknowledge this error event and continues.

330678 Feature request for a built-in encryption function that could be used to maintain a password history without revealing previous passwords in plain-text
330811 When ASE is configured for High Availability with SunCluster3.0, proper error message
is not logged in the HA agent's callback log if ASE resource fails to boot dataserver
becuase of permission problems with RUN_server file.
330841 Starting with ASE 12.5.0.3, CPU utilization may go to 100% when "enable housekeeper GC" is set

to 1, and the housekeeper queues have filled up to more than 80% of their maximum capacity

because of an old open transaction.

330852 A 804 error "Unable to find buffer 'value' from cache 'value' holding logical

page 'value' in sdes 'value' kept buffer pool for object 'value'." may be hit

in module "bufunkeep_sdes" with a stack trace in the error log showing modules

"closetable" and "endscan" if earlier the session has been unable to delete

for some reason a row from a Data Only Locked table.

330858 Job Scheduler: feature request for dependencies between jobs, such as don't start job 2 before job 1 completes.
330962 The JVM could incidentally trap with a Segmentation Violation (Infected with 11) during engine offline requests.
331016 When user wants to delete login that has alias users or direct mapping users,

a login delete dialog will display with all the login related users and ask the user whether he/she wants to delete all the users that associated with the login. This is a requirement for dropping the login. After the confirmation, all the users and login will be deleted.

If the login does not has associated users, the dialog will not be shown and login delete as normal.

331025 Feature request for a means to modify the definition of a user-defined datatype and have the change automatically applied wherever the datatype is referenced.
331052 A global variable @@version_number is now available to return the

full version number with minor version included. In 12.5.2,

@@version_number returns 12520. This complements @@version_as_integer,

which returns the upgrade version number (12500 as of 12.5.2).

331064 xmlextract queries may return a wrong result, if the xpath contains a wildcard and fetches an attribute.
331083 A 511 error, "Attempt to update or insert row failed because resultant row of size <value> bytes is

larger than the maximum size (<value>bytes) allowed for this table." maybe reported when executing

an INSERT statement based on a SELECT using a view and a UNION clause. The error is raised when the

target table has a column with a DEFAULT using a builtin function like suser_id().

331107 The VCS HA agent for resource type Sybase may invoke 'monitor' and 'clean' scripts continuously

and no failover occurs if thorough probe is used and ASE server fails to respond to probe before

monitor times out.

331120 doc correction in "Creating the dbccdb database".
331168 Increasing "size of process object heap" causes slow response time when executing single user java applications. Also at times Out of memory error is returned under a multi user scenario.
331183 Raise an error and rollback the transaction when an attempt is made to update a table in a 1-to-many join.
331296 On Windows NT platform, part of the instmstr script was truncated leading to errors on running the instmstr.
331412 A timeslice error may be reported during failover in an HA system

when recovery is attempting to reconfigure the cache memory pools

for optimum usage. Cache memory pools are no longer reconfigured

during HA failover.

331477 The message "current process infected with 11 in ns__exec_stmt" is printed in the errorlog

together with a stacktrace containing the modules 'call_ns_exec', 'ns_execute' and 'ns__exec_stmt'

when using internal JDBC with the CallableStatement.setNull() methode passing in a

java.sql.Types.INTEGER datatype as second param.

331537 From HA wizard, user can add a remote server which can be used for a HA companion server
331545 After loading a database from an older server version (that is, one which requires upgrade to make it usable by the current server), "online database for standby_access" performs the upgrade even though the database is marked as being in standby mode. This prevents subsequent LOAD TRAN in that database.
331553 Customer finds bcp -b documenation confusing
331565 Migration of database information is not allowed unless server wide information has also been migrated.
331606 The message "Database '<db>' is now online with a lower server version number. Refer to the higher version release notes on the limitations of backward compatibility", may be incorrectly printed during the online of a database that was loaded from a dump which originated on an 11.9.x (or earlier) version of Adaptive Server.
331700 A 207 error "Invalid column name '<colname>'." followed by 11050 error "Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors ..." will be reported when an ALTER TABLE command to ADD or MODIFY a column is run on a temporary table having a constraint.
331717 Wrong makefile for testmon, Monitor Client sample program, missing header files..
331758 Under some circumstances incorrect results may be returned

when executing a query using "GROUP BY" clause on columns

defined with fixed char datatype and when the Adaptive Server

is configured with a non binary sort order.

331764 When "sysbystemdb" is stored on a user created device besides master,

then during ASE restart if the given user device is not accessible,

"sybsystemdb" is silently recovered without a warning message being

reported. This may later cause problems in this database.

331777 Mirroring of master device on IBM may lead to 'uninitialized logical page' message
332122 The ASE localization utility sqlloc does not allow built-in UTF-8 non-binary

sort orders to be selected.

332229 Extend "sp_dbextend 'help', 'list'" command to also report the

usage for "'list', 'threshold'" command.

332240 Enhancement request for sqlupgarde utility to continue upgrading even if errors are encountered during upgrading.
332265 After loading a transaction dump, the segmap information in sysusages may be incorrectly altered.
332268 When ASE runs out of LOCKS, 707 error "System error detected during

attempt to free memory at address 0x<value>..." may be raised resulting

in the session being killed. Alternatively an "infected by 11" error

may occur. A stack trace will be reported in the error log showing modules

'proc_read', 'proc__fetchphdr' and 'proc_read__backout'.

332349 When Adaptive Server is configured with a 'sql server clock tick length' greater than 500000, the following message will appear in the error log:

00:00000:00002:2003/11/11 15:04:29.48 kernel uasetalarm: ticks value 0, must be positive

332378 A UNION VIEW used in an INSERT query may result in a 622 error where the database for the target

table for the INSERT is different than the database for the base table of the view.

332427 Enhance description of package synchronization in cluster
332447 When loading a transaction dump into a database that is bigger than 38000 pages, if the source and target databases have a different layout, the segment map will be set to SYSTEM + DEFAULT (segmap = 3) if the source database has segregated log. If the source database has mixed log and data, the segment map will be set to SYSTEM + DEFAULT + LOGSEGMENT (segmap = 7).
332462 Provide JavaHelp for ASE Plugin

Help button is enable for properties page.

332464 A local variable using an extended datatype (Java Object) can contain an

incorrect value when a field in this Java Object is from a subclass and is

assigned a value from a SELECT FROM <table> statement.

332536 The branch of a distributed transaction will continue to persist after the transaction manager has committed the transaction, if the branch has incorrectly nested transactions.
332574 Make visible Replication Agent parameter 'ha failover'
332642 A column with a high number of rows of NULL value can result in unbalanced statistics.
332663 The fractional seconds of the datetime value will be discarded, If datetime value of a proxy_table is mapped to an Oracle TIMESTAMP column.
332671 Stored procedure wrappers for monitoring tables.
332711 On the AIX platform, in rare circumstances, ASE may hang or may show 100% CPU utilization at the

operating system level even when no users are active. Boot-time traceflag 4073 has been added to

reduce the likelyhood of these events.

332752 In the Disk section of sp_sysmon report rename 'Disk Semaphore' to 'Mirror Semaphore' since it is only relevant for disk mirroring purposes.
332766 The ONLINE DATABASE command is incorrectly audited when the

'load' audit option is enabled for a database, instead of when

the global 'security' option is enabled.

333052 The "charset" utility should allow for the update of character set definitions

in SYSCHARSETS, even when (or especially when) the character set corresponds

with the server's currently configured default character set. This will make it

possible to update character set definitions as support for them evolves - notably

from pre-12.5.1 definitions of UTF-8 (limited to character widths of 3 bytes)

to the 12.5.1 definition of UTF-8 (which includes support for 4-byte characters).

333068 Multi-byte characters that are equivalent to '[' and ']'

are not handled properly as delimiters to bracketed identifiers.

333077 Queries containing GROUP BY with an expression using local variable may return duplicate rows. The workaround for this problem is to remove the local variable from the GROUP BY list or to add a

DISTINCT clause to the query.

333148 In rare circumstances on a multi-engine server, an undetected deadlock may occur

when running the 'data_pgs' builtin while there are a lot of concurrent table drops.

333160 Feature Request: Add a configuration option that would result in message 311, "The optimizer could

not find a unique index which it could use to scan table <table> for cursor <cursor>" being raised

at procedure creation time instead of procedure execution time.

333197 A timing issue with process terminating and exceeding time limits

will cause segmentation fault in rg__time_limit_hdlr() routine.

333213 sp_help Parameter_name output islimited to 15 characters eventhough you can have a

stored procedure parameter name which consists of 30 bytes.

333216 The error 643 together with a stack trace that includes the module 'tmp_check_nulls', or the error 233 reporting an empty column name, will be incorrectly raised if a table is created inside a stored procedure including the 'ON segment' option.
333293 ASE Replicator: Error message during startup on AIX: "JRE: not found".
333350 When the server's default character set is UTF-8 and a non-binary sort order

is configured, error message 1579 can occur in unexpected circumstances (e.g. have invalid

characters in the table).

333354 A 701 error "There is not enough procedure cache to run this procedure,

trigger, or SQL batch. Retry later ..." may be reported while a sort

operation is undergoing followed by an "infected with 11" message

in module "dealloc_merge" with a stack trace in the error log showing

modules "sortclean", "startsort" and "sort".

333357 If user configured the Web Services from the installer, runproducer.bat won't work with "ws.properties" file on Window platforms. This is because "ws.properties" file uses single "\" file separators.
333402 A 243 error "Type '<type>' is not a defined system type." may be

correctly raised but mistakenly followed by a stack trace in the

error log in module 'closetable' during the execution of a stored

procedure that creates a table making usage of a user defined

datatype that has been dropped in the meantime. Module 'tmp_check_nulls'

will also be reported.

333439 Feature Request: improve the performance of sp_helpdb for databases with many device fragments.
333519 If the Adaptive Server has a large number of databases, the sqlupgrade[res] did not wait long enough for all of the databases to recover before doing the installmaster.
333614 Server fails to boot and will raise 1569 error when changing character set

from utf-8 with one of the external sortorders (big5bin:194, cp932bin:192,

cyrdict:140, eucjisbn:192, euckscbn:161, gb2312bn:137, gbpinyinbn:163,

rusdict:165, sjisbin:179 and turdict:155).

333618 A stacktrace may occur if the user runs a java methods and java is not enabled on the server.

In the stacktrace, the following functions may be found : s_normquery()-norm3_driver() and

n3_res_udf().

333638 Implementation of Pluggable Authentication Modules feature in ASE.
333676 Implement support for Mac OS X 10.3
333685 The message 632, "Memmove() was called with a length of <length> - maximum allowed length is 2048." may be reported together with a stacktrace which includes the modules 'cursfix__saverow', 'cursfix_main', 'delirow' and 'delparent' if a DELETE statement is used on a row which is also the current row used in a cursor. After this message, the clustered index can be corrupted and dbcc checktable may report 7930 errors.
333830 sp_configure displays a NULL value in the type column for the configuration parameters "total data

cache size" and "executable codesize + overhead".

333836 When a user named cache has been configured, sp_sysmon may report an

erroneously high "large I/Os denied due to Pool < Prefetch Size" percentage

for the 'default data cache'.

333850 When a UTF-8 non-binary sort order is configured, the charindex

built-in function may yield incorrect results if the length of

the expression1 does not equal the length of the matching string

within expression2.

333873 SQL Derived tables cannot have unnamed columns. The columns have to be always named either using the "AS" clause or the derived column list. Else, the user will get 11073 error.

select * from (select sum(advance) from titles) d1 will get 11073 error. Rewrite as: select * from (select sum(advance) from titles) d1(a1) or: select * from (select sum(advance) as a1 from titles) d1

334069 Re-loading the Job Scheduler sequencer code by multiple stop / start operations can cause

corruption within the JS Task sequencer memory table resulting in Job Scheduler Task violations

such as Segmentation violations or Bus errors. When this happens the only way to restart the

Job Scheduler is by rebooting ASE.

334075 sp_configure output gives "number" as the units for "i/o accounting flush interval". It should be "clock ticks".
334087 New feature request to provide allocation information for SYSGAMS when the command DBCC GAM is

executed with the 'check' option.

334132 DBCC DBCACHEREMOVE command removes a dbtable for a given database from cache.

This command should be used in those cases where open count errors are reported

and no active session appears to be using the database. Executing this command

may not succeed in all cases, therefore care must be taken when running this DBCC.

This command has to be executed by the SA, its syntax is as follows:

dbcc traceon(3604)

go

dbcc dbcacheremove(<dbid>|<dbname>)

go

334170 The up/down arrow keys do not scroll the items in drop down lists on Mac OS X Java 1.4 (1.3 works).
334194 sp_object_stats fails to report some deadlocks
334289 Performing an unmount database command in the Sybase Central ASE Plugin

immediately after creating a database with the ASE Plugin will fail with

the error 'Cannot unmount database 'dbname' because you are not

currently in the master database.'

334358 In rare circumstances, a distributed transaction may be left in an "In Abort Tran" state after one thread of the transaction manager attempts to issue a rollback request for the transaction when another thread was still busy using the transaction. This would typically happen when some sort of error had been encountered by the transaction (for example, an out of locks error).
334364 Feature request to enhance convert() function with a style for converting to/from th e Julian date format
334445 During ASE startup, the following messages appeared together:

Successfully initialized the security mechanism 'csfkrb5'. The SQL Server will support use of this security mechanism.

Security Control Layer was not initialized. The SQL Server will not support use of any external security mechanisms.

The second message which indicates an error occurred was incorrectly displayed.

Kerberos had been successfully initialized and would work.

This fix avoids the incorrect second message.

334451 An enhancement to allow a transaction to be heuristically completed using dbcc complete_xact() when completion had already been initiated by the transaction manager, but this failed to complete.
334458 CIS: timeslice error occurs when SELECT from <proxy table> is interrupted because connection

to remote server has been broken. The connection to remote server is broken due to either remote

server being shut down or the remote connection being disconnected via 'kill spid' on the

remote server.

334499 Feature request for an is_datetime() built-in function to determine whether a given character string represents a valid datetime value.
334500 Feature request for an isnumeric() built-in function to determine whether a given character string represents a valid numeric value.
334547 Improve the performance of xml value index generation.
334620 The DBCC CHECKCATALOG command has been enhanced to perform Sysindexes

consistency checking. Errors found by this utility may be fixed using

the new DBCC CHECKCATALOG(<dbname>, fix) syntax.

334632 When UTF-8 is configured as the server's default character set and a case

or accent-insensitive sort order is chosen, variable and database object

names are not case or accent-insensitive, and must be specified exactly

as they were declared.

334667 Kerberos for Solaris 64 platform is now enabled and supported in this release.
334674 Enhance the sp_shmdumpconfig stored procedure to report the total amount of server memory used by data caches, procedure cache and server data sturctures. This can be used to estimate the size of shared memory dump files.
334695 Feature Request that Rep Agent Thread should not send empty BEGIN or COMMIT log records to RepServer when ASE session has "set replication off" enabled.
334700 Kerberos support in ASE is now enabled.

ASE relies on OS provided Kerberos libraries,utilties, and

Kerberos KDC, as well as the Sybase Connectivity provided

Kerberos driver.

See Kerberos Interoperability Matrix for more details on testing.

334729 On Solaris, HP, AIX and Linux platforms, Job Scheduler template files

installTemplateProcs.bat, installTemplateXml.bat and installTemplateXml are missing.

334752 would like to have installdbccdb script preserve dbcc_exceptions table if script is rerun and if it has entries
334814 When 'create table' and 'insert' are in the same store procedure, and

the table is a temp table with identity column, the identity column

data is not inserted correctly.

334831 If a row level access rule is attached to a table involved in an outer-join query it may generate incorrect results.
334842 An 691 error may occur when accessing SYSGAMS in TEMPDB database when the size is bigger than 63 GB.
334922 The monCachedObject table returns no rows when a CacheID or a CacheName are used as exact match search arguments, e.g. select * from monCachedObject where CacheID=1
334980 Subquery predicates are not pushed down to the materialization step

of the view with union worktable (if the view can't be merged).

335173 The maximum number of subqueries within a single side of a UNION has been increased from 16 to 50.
335317 A 913 error, "Could not find row in sysdatabases with database id ... Run DBCC

CHECKTABLE on sysdatabases" may be reported when executing a stored procedure

in a recently loaded database that uses a cursor and fetches values in local

variables using extended datatypes (i.e. java classes).

335343 CIS : Conversion/truncation errors may occur, When an Engine is brought online after it was offlined and while inserting into proxy database involving Unichar columns.
335465 The message "current process infected with 11" in the module 'q_match_cols' may be reported in the

error log when cross-database queries reference a database that is in single user mode and another

session is using this database.

335485 Improve the performance of xmlextract() result generation process.
335495 Provide quick access to JISQL and SQL Advantage (Windows only) from a server connection. To execute queries using these tools, right-click the connections and select 'Open JISQL' or 'Open SQL Advantage' menu item.
335542 CIS: An outer join query declared inside a cursor can't be passed to the remote server completely even if all tables involved are on the same remote server. Cursors involving remote tables are READONLY by default. They can be made UPDATE-ABLE by default upon enabling traceflag 11218.
335557 DBCC CHECKSTORAGE may report 100030 error when large TEXT data was inserted.
335560 ASE doesn't take HP setting fs_async into account when opening filesystems. As a result

synchronous io is used.

335571 Column statistics may not be taken into account for non optimizable

IN() clause, this may lead to suboptimal plan selection for a query

with IN()or OR clauses which joins multiple tables.

To take benefit of the change server must be started with -T301 trace flag.

335572 Referential integrity may not be enforced for UPDATE or INSERT query

if the query is executed with the option SET ROWCOUNT.

335586 This is a feature request to have a query using a SARG with an escaped wild card to actually

use the index instead of table scanning which tends to causes a performance degrade.

335588 When insert large index rows (that each page can only hold 3 rows), the index splitting may cause index level increase linearly with the number of row inserted, soon it will run out of the max index level.
335628 tracking of page splits per object
335657 The message "current process infected with 10" together with stack trace

which includes the module 'PDFreeDataChain' may be reported when

an error is found at SSL initialization or while adding a certificate.

335741 Using trace 4048 and the char_length() builtin function having a CHAR datatype parameter will

cause trailing blanks to be trimmed from the parameter used.

335774 If there are two derived tables at the same level and only one of them has a derived column list, then it may result in error 11061.
335847 CIS : In a HA environment, updates to existing external login using sp_addexternlogin does not get propagated from primary to companion server.
335878 A new Feature has been added to Support Veritas Clusters version 2.1 on Linux platforms With ASE12.5.2 release for ACTIVE/ACTIVE cluster setup

Requirements : veritas Volume Manager 3.5 , Veritas Cluster Software ver.2.1

336053 In ASE 120/125 releases, parse and compile time is longer for queries with multiple aggregates and a long IN list.
336077 The message "current process infected with 11" may be reported in module

'mda_populate_monOpenObjectActivity' during the collection of monitoring

data when the configuration option 'enable monitoring' is set resulting

in the session being killed. The stack trace reported in the error log

will also mention modules 'execrpc', 'exec__native_rpc' and 'mdarpc_exec'.

336127 The monProcess table incorrectly contains rows for inactive worker processes.
336265 SQL text capture may be turned off in the ASE when the Monitor Server terminates. This will cause collection of data for the monProcessSQLText and monSysSQLText MDA tables to stop.
336289 In rare circumstances on a multi-engine server, an undetected deadlock may occur

when running the 'curunreservedpgs' builtin while a database's information is

cached for the first time or it is replaced due to the "number of open databases"

being less than the total number of databases on the server.

336320 When using a larger network packet size than the normal default size, ASE may encounter

'invalid length' TDS protocol errors during login.

336354 ASE sets dsync on by default for raw partitions when physname is symbolic link
336384 Feature request for progress monitors for some common DBA commands such as alter table, update statistics, and reorg.
336556 Replication Agent may send a wrong value of Zero for a identity column, when table has text columns marked as replicate_if_changed.
336575 Clicking 'Generate Mapping' icon does not create mappings between the element and source object

To reproduce:

1) Generate XML model from project.pdm (do not select 'generate mapping' option)

2) In the XML model, create a datasource with project.pdm selected as the model

3) On the mapping tab, associate this datasource to the 'employee' element

4) Add the employee table as an element source

5) Select the Attribute Mapping tab and click on the 'Generate Mapping' icon

Note: No changes are made

336578 The error 923 will be raised up to 16 times, followed by the error 4402

if a user tries to select from a view that reads a table in a different

database that is set up for DBO use only.

336620 Occasionally, if there is UNION in VIEW in a query, Abstract Plans cannot be generated if the same table is referenced both inside and outside the view.
336646 On the windows platform, xpserver commands do not execute in the context of the ASE user as they do on unix.
336789 Add 'License' field on Server Properties to display edition and enabled licensed features. For example, 'Enterprise Edition, Java Services" means the ASE is an Enterprise Edition, with Java Services enabled.
336846 CHECKSTORAGE thread could not send FAULT message (error -3).

Increase the memory per worker thread.

This message gets displayed on the console but does not get printed in the ASE errorlog.

336858 On Sun Solaris, in rare circumstances, Adaptive Server may hang as a result of ASE threads deadlocking on mutexes due to signal delivery.
336870 As of EBF 10911, Rep Server 12.5 DSI will pack "is NULL", instead of "=NULL". when a value of a column is NULL in a where clause. However, the syntax of "column_name IS NULL" was not supported by SSQueue, causing the error "Unsupported syntax ...". This problem is now fixed by supporting the new syntax.
336886 The new cast() function, though described in the Whats New document, is not documented with the other functions in the 12.5.1 Reference Manual vol 1.
336921 Running xmltract() or xmltest() with the xpath query : "/*[*]", may cause a server to stacktrace.
337106 Message 17230, "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure." is incorrectly raised when a DBO aliased user executes sp_dbcc_delelehistory.
337398 sp_helptext will truncate trailing spaces when displaying the source text from syscomments.
337405 Sub-optimal performance may result when executing a SELECT with OUTER JOIN and ORDER BY because a potentially useful index in the outer table is not chosen to avoid using worktable for the sorting.
337406 There was a problem where servers with user-created tempdbs would generate SEGVs upon reboot after changing the default sort order. This occurs while commiting the transaction under rec_system_ix(). User-created tempdbs should not be rebuilding indices due to a sort order change.
337444 Database will be able to reallocate space for "for load" database.

It is used only after "create database for load", when user must re-create the space allocations and segment usage of the database being loaded from a dump.

337452 ASE server stacktrace sometimes when processing the following

query:

select cast(int) = 1

337499 CIS: create proxy table gives syntax error when the source table has an ASE reserve word and the remote server does not support quoted identifier.
337538 The scope of the fix for CR 316222 is extended such as it includes

the drop of temporary definition time and partitioned tables.

Furthermore this optimization is applied as far as the drop operation

is not done under the scope of a user's defined transaction context,

irrespectively to the setting of the DDL-IN-TRAN database option

in the tempdb database(s).

337592 Running dbcc upgrade_object() on an object which is renamed using sp_rename can cause messages to

be raised using the 'old' name of the object.

337611 The sybsybtax database used by sp_syntax is missing entries for new functions added in 12.5.0.3 (len, left, day, year, etc.)
337629 When unichar/univarchar data is converted to varbinary and stored in a column,

any trailing null bytes (0x00) are trimmed. A subsequent conversion back to unichar/univarchar may fail if the original unichar/univarchar data, when

viewed as a byte-stream on the given platform, contains trailing null bytes.

This typically the case for ASCII data on a little-endian platform, since

Unicode characters U+0000..U+007F are seen as the byte-streams 0x00 00..

0x7F 00 on little-endian platforms.

337672 The -I switch for srvbuild, srvbuildres and sqlloc on Unix platforms does not work and the interfaces file in the default location is always used.
337689 In rare circumstances, Adaptive Server may hang as a result of engine process self deadlocking on malloc mutex.
337749 If ssxtract was run with the -l command line option, to set the isolation level of the

connection pulling data from the consolidated database, the error "Incorrect syntax near the keyword 'TEMPORARY'" would have been reported, and the isolation level of the connection would never have been changed. This has now been fixed.

337760 Error 233 is raised when inserting a null value into a proxy table that maps to a base table

column that has a default, as the proxy table doesn't automatically import the default

definition. Workaround is to add a default to the proxy table.

337892 In a xsd XML model go to the tab attribute of an element PS

Click on the customize column and filter tool

In this window, the attribute type is missing

337902 Sybase Central doesnt report database segment usage for a device when the device only has a default segment on it. It is corrected in ASEP 12.5.2
337920 Error message #11740 still exists in sysmessages.
337931 Killing a connection to SQLAdvantage: produces a pop-up saying "Internal Error - contact System Admin. or Sybase Tech. Support.
337934 If a view contains a scalar aggregate and is used as the inner member of an outer join, then

stacktrace (signal 11) could occur if the view is not materialized. This has been fixed

by materializing all such views.

338053 Feature request to have ASE support "before" triggers as ASA does.
338077 Enhancement to improve the performance by tuning the local cache partition number for the default data cache.
338151 A user with SSO role incorrectly receives a permission denied error when executing the stored procedures sp_addalias or sp_dropalias.
338157 ASE 12.5.1 does NOT support XPath functions.

However, an XPath query with function operator gives

incorrect error message 'insufficient memory' instead of

'XPATH: Parenthesized expression not supported'.

338189 If ASE receives an attention from client during executing EXECUTE IMMEDIATE statement,

this can lead to stack overflow which results in ASE shutdown.

338213 Query like : SELECT <column list>, (SELECT column from view) FROM ...

may return incorrect result if subquery selecting from the view

returns empty set and the view definition includes UNION operator.

338249 View materialization does not benefit from transitive closure SARG generation.

Worktable generation may not have as good performance as expected.

338331 Incorrect monitor statistics may be reported on a table if a clustered index is dropped and recreated on that table.
338337 Running xmlextract()queries with xpath parameter '//*' causes a stacktrace.
338357 CIS: DROP TABLE <proxy_table> may drop the remote table when the local server is a HA node and

the remote server is not.

338359 View with CASE expression may be materialized even if there is no need

for a materialization.

338387 Adding a threshold count for the HS alarms to fire after x consecutive times a condition is met
338523 In rare circumstances, running a Java native call produces a hard fault in the ASE Java Subsystem.

The message "current process infected with 11" in the module 'ubffree' together with a stack trace

which includes GarbageCollection modules may be reported in the error log on Unix platforms.

338531 Enables XML Services feature on HP-UX 32 and 64 bit platforms. Feature description and usage can be found in the release documentation.
338714 srvbuild and srvbuildres could not recognize veritas

volumes bound to rawdevice interface on Linux.

338877 Feature request for support of devices larger than 32 GB.
338900 Add support for Real Time Messaging Systems. This licensed feature integrates ASE with messaging systems such as TIBCO JMS. The support in ASE Plug-in includes the management of subscriptions, messaging service providers, and login mappings. Use"Messaging Services" folder to access the feature.
338919 MacOS X: Rework processor synchronization routines to be compatible with G5 hardware. Prior to this change, 2-engine configurations caused problems when running on G5 systems.
339092 langinstall syntax in 12.5 and 12.5.1 documentation has references to -I twice.
339139 XPserver: Request improvement in XPserver error reporting when attempting to open Extended Procedure library files.
339173 Missing New SQL command option for Update Statitstics: sampling=percent option

in Reference Manual

339176 SAG Doc Fig 8-1 error, ASE does not support direct conversion between cp850 and cp1252

TABLE 8-1 is correct.

339177 A command that does a partially logged operation (like SELECT INTO or bulk copy) in a temporary database may be blocked for an unnecessarily long period of time when the log is being automatically truncated.
339211 A deadlock may be reported between a session creating a table

with declared defaults and another session dropping such a table.

The deadlock call stacks will show for the former session

the module 'crt_main' and for the latter session the modules

'dropo', 'delcol' and 'dropo' again.

339328 Omni is ignoring the DBCC CIS setcap settings for cap_id 124 (CONVERT function).
339331 Provide the capability for SQL Advantage to use HA failover to reach a secondary ASE if the primary ASE has failed over. The capablility being requested is similar to the isql -Q support.
339411 sp_displayaudit to show audit options for sybase_ts_role
339436 The error "ct_options(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect" may be raised and the connection terminated, when calling the ct-library function ct_options(connection, CS_SET, CS_OPT_AUTHON, "<rolename>", rolename_len, NULL), to enable

a role after a connection is established.

339459 Selecting from a view defined with UNION ALL clause may sometimes return

error 421 " TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT".

This happens when the view returns TEXT or IMAGE fields and requires materialization.

339501 Configuration parameter 'disk i/o structures' is supported in sp_monitorconfig.

The sp_monitorconfig column 'Reused' has been changed to 'Num_Reuse'

to provide the number of reuse requests as opposed to the earlier 'Yes/No'

indicator of reuse requests.

339590 Error 225 (Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization) is encountered for Select into queries when the donor table involves identity and aggregates.
339713 CIS: In a transaction, SELECT from <rpc table> after an 'execute' or 'sp_remotesql' call is

issued to a remote procedure which insert/update/delete the same table may result in blocking

at the select call. The is resolved by removing the changes introduced in CR 321261. The fix

creates a new traceflag 11228 for CR 321261. This traceflag has to be turned on to allow

create table command in the remote procedure.

339731 Executing a stored procedure whose name has been stored into a T-SQL variable of

CHAR datatype may fail and raise an unexpected 2812 error stating the stored

procedure was not found whereas it actually exists in the database.

339767 Progress message for sp_dbcc_deletehistory should be changed because the current message is inconsistent with the behavior.
339802 When several sessions use java, they may get locked while acquiring address locks.
339826 CIS : Page count statistics for a proxy table maybe incorrect after ASE is restarted.
339880 The message "current process infected with 10" in the module 'plc__flush' together with a stack

trace which includes the modules 'xls_preflush' and 'write_prepare_rec' may be reported in

the error log if a transaction is opened in one database and a Java method modifies a table

in another database.

339897 A 2540 error, "Table Corrupt: Page is allocated but not linked ..." may be reported

when running DBCC TEXTALLOC on an indexed table having the 'ignore_dup_key' attribute

and at least one text column.

340006 Sybase Central ASEPlugin connection attempts to the server would apparently be refused if the job scheduler database (sybmgmtdb) was created but not populated, or if sybmgmtdb was marked suspect.

The Sybase Central User would see a java stacktrace containing the following frames if the details button was clicked:

com.sybase.jdbc2.jdbc.SybSQLException: Invalid role string received.

at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)

at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)

at com.sybase.jdbc2.tds.TdsResultSet.nextResult(TdsResultSet.java:585)

at com.sybase.jdbc2.tds.TdsResultSet.next(TdsResultSet.java:323)

at com.sybase.jdbc2.jdbc.SybResultSet.next(SybResultSet.java:148)

at com.sybase.aseplugin.sql.ASResultSet.getNextRow(ASResultSet.java:215)

at com.sybase.aseplugin.so.ScheduledJobsCtrSO.checkRole(ScheduledJobsCtrSO.java:170)

340007 sysmon_dcachestats now uses the parameter as '@Reco_option'. So the problem should be fixed.
340028 The message "current process infected with 11" in the module 'apl_getnext'

together with a stack trace which includes the modules 'pr_do_database' and

'lock_objstats' may be reported in the error log when the execution of

the system stored procedure 'sp_object_stats' hits 1205 error

"Your server command ... encountered a deadlock situation.

Please re-run your command.".

340083 A suboptimal plan may be chosen by the optimizer when a buffer pool for a

particular cache used by the query has been configured with a size bigger

than 2 Gigabytes.

340121 ASE on Mac OS X now utilizes the PAM user authentication facility. Documentation that has been written describing the interface on other platforms applies to the Mac OS X platform. Using PAM, any user authentication mechanism available on macosx can be used with ASE. The interface requires the presence of /etc/pam.d/ase, which can be copied from /etc/pam.d/login
340140 A offical ducumentation request with regards to Sybase mirroring within an Active/passive Ha configuration.
340143 Customer requests that a traceflag be implemented which prevents ASE from booting

if ISM (solaris) is not available

340146 "sp_helpsort recognizes only 6 char sets: ascii7, iso_1, cp850, cp437, roman8 and mac"
340197 Feature request to enhance the output of DBCC CHECKVERIFY to include a total count of faults in the database
340261 After upgrading from Mac OS X 10.2 to 10.3 all attempts to login to ASE fail due to invalid passwords.
340340 new HS direct load feature
340399 New feature: "top n" clause for select, update, delete.
340568 A 5888 configuration error, " Two Named Caches with the 'cache status' defined as 'default data cache' is not allowed" may be reported in case of case-insensitive server during boot or while verifying the entries of a configuration file using the sp_configure.
340570 Installshield's log file is pitiful
340573 Customer want to see cross database dependencies using sp_depends
340577 add blocked and non-blocked network i/os counter in sp_sysmon and in monitor tables
340606 Editors used in these places do not save the file unless using the "Save as" function.

- DBCC Wizard

- Backup/Restore Wizard

- Log SQL Statements

- DDL Generator

This behavior is corrected. By selecting the "Save" menu item or clicking the "Save" tool bar button, the file is saved immediately.

340658 In "Disk I/O Management" section of sp_sysmon output, we may find wrong values on Device Semaphore Granted/Waited fields if there is a skipped vdevno and async disk I/Os are delayed.
340771 If a dump or CHECKPOINT is attempted on a database that has been quiesced using QUIESCE DATABASE ... HOLD, it is possible that server logins and other activity unrelated to the quiesced database may become blocked.
340783 A new option, '[NO] DYNAMIC OWNERSHIP CHAIN' has been added to the sp_procxmode system stored procedure, to change the ownership chain when validating the permissions of a dynamic sql (execute immediate) statement inside stored procedures. Dynamic SQL in a procedure with this execution mode set, will validate the permissions against the procedure creator, instead of the procedure executor.
340814 SIGHUP message in backupserver start-up log on ASE v12.5.1 is harmless.

and the message will be suppress in later version.

340903 Under heavy load, if a client disconnects abnormally, ASE may encounter panic termination of

the Java VM associated with that client. This will be followed by the message

'Java services are temporarily unavailable while the Java system is being recycled'.

340908 In very rare circumstances, it was possible for ssremote to report that a connection had been marked as dead when applying messages, but no disconnect error would have been logged on the ASE server. A particular instance where this could have occurred has been fixed.
340914 Incorrect version of installsecurity script being distributed with ASE 12.5.1 on Windows platform.

Correct script to use is distributed as instsecu script.

340938 Coordinated dumps using the compress option fail: the backupserver doesn't finish writing

the dump. No LOGCONN messages can be seen in the ASE log.

341033 When adding new resource limits, ASE does not warn if resource limits are disabled on the server.
341036 Request to modify sp_addtype to remove the constraint that datatypes be no larger than the server's page size, to allow wider datatypes. These wider types could be used only for variable declarations.
341040 Provide ability to be able to add a resource limit on a user for all applications except 1.
341156 DUMP command may fail with a message that "The 'open' call failed for device

'/work2/test.dmp' with error number 2 (No such file or directory)" giving the name of the dump device. The problem is actually with a database device having been DISK INITed with a trailing space in the name or space with-in the name.

341211 Derived tables do not accept Null values in columns return 530 message
341273 CIS: Message "Bad token from SQL Server: Datastream processing out of sync" or other TDS errors may be raised by SQL Server when a pre-5.0 TDS client is used to connect to ASE accessing remote

objects.

341330 An equality SELECT FROM the sysprocesses table on 'program_name' may incorrectly return no results.
341428 If the ASE default language is not English and the 'plan text pipe active' and 'plan text pipe max messages' configuration parameters are set then showplan messages are sent to the client. These messages should not be sent to the client, they should be captured in the plan text pipe for use by the monSysStatement table.
341465 Installshield uninstall on HP fails to remove all components it installed
341502 optdiag statistics may fail with tables that have more than 127 columns.
341558 CIS: Execution of the query INSERT <proxy> SELECT from <local> where <proxy> contains

text column mapped to remote varchar column will result in NULL text column being

inserted. This is now resolved for backend running DCO 12.5.0.4 ESD#3 or above.

341612 Euro character not available in cp936 (Simplified Chinese)

and cp949 (Korean). Undefined characters in EUCCNS

should be 2 bytes wide. Charindex built-in gives wrong results

with unichar datatype and prefixes consisting of only spaces.

Obscure problems with normalization and surrogate pairs.

341696 Provide Czech sortorder support for iso88592, cp1250 and cp852.
341735 MacOS X: Remove previous ASE/MacOSX limitation of 2GB memory; limitation no longer exists with Panther/G5 hardware
341746 A network endpoint (entry in interfaces file) can have multiple server names (or alias'es). There is an consistany while printing server name in some of error messages. This fix is to resolve so that server name displayed in the error message is always the one used by user in his commands.
341747 Allow the user to specify whether or not a configured shared memory dump should cause the non-dumping engines to halt while the dump is being performed. This is implemented using the existing sp_shmdumpconfig stored procedure.
341752 For Internal/External use:

User will also get additional information for certain error messages thrown by FOR XML.

FOR XML catches errors thrown from modules underneath it and throws out the error message text under a different message name/number. This fix makes FOR XML also throw out the error message number of the error it caught from the modules underneath it.

341787 Add 'cis connect timeout' feature. The OCS fix 430150 checked in to Conn 15.0 ESD #7 is

needed for the timeout to work correctly. Traceflag 11235 has been added to allow the

behaviour of ignoring connection failures during compile-time.

341809 Few libraries (dsparser.jar and jConnect jar files) needed to run web services functionality in ASE will be picked up from the OCS-12_5 directory in the sybase release structure. In 12.5.1 ASE release these were present in WS-12_5 directory also.
341812 A 2622 error: "Insufficient room on this page to insert a row of length <length>" may occasionally be raised upon running UPDATE STATISTICS with SAMPLING command on a DATA ONLY locked table.
341823 A 2823 error, "Process <spid> tried to remove a PROC_BUF <hex. address> named 'stored procedure

name' that it does not hold in the hold procedure linked list." may be raised when some processes

are running concurrently stored procedures that use the same SQLJ function.

341852 In a Warm Standby replication environment, Replication Server may report the error 226 when trying to execute an 'alter table' command from within a user transaction.
341903 testmon Monitor Client sample program will not compile on UNIX
341904 testmon Monitor Client sample program will not compile on UNIX
341917 Doc Request - Cust requests that we update the release notes to indicate that it's not recommended to use automated startup scripts for ASEs in Sun Cluster 3.x HA configurations.
341919 Have ASE confirm that the HA logical host is available before beginning database recovery.
341929 srvbuild utility can be used in gui mode as well as in non-gui mode
341939 ASE servers upgraded from 11.0.x or 11.5.x may show an expected SPID

number reported in the 1249 message text, if ever this error is raised.

341976 The execution of sp_helprotect 'role name', incorrectly reports all the permissions

granted to all roles and users when the role has no granted permissions on the database.

341983 64bt Open Server installs are missing $SYBASE/config/trusted.txt
341999 Enable load database of a dump file from a byte-swapped architecture platform.
342006 Support extending segments past 32 per db
342024 Domain errors (3622), caused when generating NaN (not a number), are only reported with severity EX_INFO even if traceflag 3625 is enabled.
342027 Java variables may get nulled when the stored procedure get recompiled.
342030 When trying to do a compressed dump or load, the backup server fails to find the runtime compress library required for the operation. The following error may be seen in the session/backupserver console.

Library path is

'$SYBASE/ASE-12_5/lib/libcompress.sl'. shl_load()

returned:

Code=2, Message=No such file or directory

Msg 8009, Level 16, State 1:

Line 1:

Error encountered by Backup Server. Please refer to Backup Server messages

342048 FR: ASE auto optimized itself for more resource: open database, indexe, objects
342074 Add SSL support for ASE communication with LDAP Directory Servers.
342136 Customer would like ASE Coverletter to have a reference such as:

"For Open Client EBFs, please refer to SDK URL in MySybase site".

342138 blank line before closing parenthesis of create stmt in SP causes incorrect jump in sqldbgr and Embarcadero RapidSQL debugger
342184 More tables will be considered for parallel sort. ASE will now consider any table that does not completely fit within the available number of sort buffers for parallel sort.
342197 Enhance dbcc checktable so it keeps checking additional indexes rather than aborting after finding a major error
342244 When a proxy database is rebuilt after failback in an HA system, all the tables are created as owned by DBO, no matter who the current table owner is.
342256 Update-statement with aggregate functions like isNull((min(abc),xyz ) updates all

rows instead of updating specified row(s).

342290 When installing ASE 12.5.1 on Mac OS X the preference panel may replace existing panel with same id.
342320 The configurable shared memory dump (CSMD) facility, as well the manual "sybmon" memory dump

mechanism, will now include procedure cache in the default memory dump. The administrator can

override this by manually specifying their preference for dump file contents using the

sp_shmdumpconfig stored procedure for CSMD, and the memdump command for manual "sybmon" dumps.

342374 Customer requests that Sybase implement LEAD and LAG functionality in ASE.
342418 FR: Able to use a wild card to assign multiple

applications to multiple tempdb with on command.

342421 feature request: wants a update stats option added to alter db for proxy_update
342447 CIS: Sending DATE/TIME values to ASA/ASIQ backend may result in TDS token errors and subsequent

commands may hang in 'remote i/o'.

342523 When Adaptive Server is re-started after a polite shutdown, an unexpectedly

large amount of time is spent in filling in the free space information

for a database that has the 'read only' database option turned on.

342605 A stacktrace contaning the modules 'result' and 'pre_aggview' may be raised

if a stored procedure tries to access a column that has been dropped

using ALTER TABLE DROP <column>.

342612 A 691, 692 or 605 error may be reported in the error log with a stack trace in module 'pg__nextnonzeroentry' during the execution of a DML command that needs to perform a new page allocation in module 'pg_allocate', when earlier a REORG REBUILD command on the given Data Only Locked table has failed.
342625 sp_helpconfig "heap memory per user" display

wrong help message.

342655 Feature Request: Provide a mechanism to force the full allocation of a mirror device on file systems. This is to prevent problems associated with Unix sparse / lazy file allocation. A new "clear = TRUE" option has been added to the disk mirror command to address this.
342720 An error in a conditional statement (IF or WHILE) may result in unexpected execution flow.
342734 The commands CREATE LOGIN, ALTER ROLE and UPDATE STATISTICS may fail with a syntax error when some of the command qualifiers are used in uppercase and the default server sort order is case sensitive.
342760 Server Configuration Error: Cannot write out file '(servername).cfg' due to system error 'Resource temporarily unavailable'. With this fix, the operation will be retried up to 5 times with a warning message. Ultimately, if all retries fail, the operation will be abandoned, thus the current failure message may still be seen.
342764 An insert...select into a local table from a proxy table which includes a text column can result in a 605 error.
342767 On a Solaris 32bit ASE Server, concurrent login attempts using Kerberos authentication fail.
342848 An upgrade of Adaptive Server from previous versions to 12.5.1 and beyond results in the failure to start

the HA services and loss of HA functionality.

342856 Under very rare circumstances, DBCC CHECKSTORAGE may incorrectly report a large number of 100018 soft faults.
342876 A 1525 error, "Sort Failure. Rollforward of sort encountered sort descriptor timestamps out of sequence..." followed by a 4313 error may be reported when loading a transaction dump that contains a CREATE CLUSTERED INDEX with the SORTED_DATA option. The workaround is to turn on the command line trace flag 1538 at runtime, or not to use the SORTED_DATA option.
342880 The installdbextend file is missing in 12.5.1 GA release on Linux Itanium platform.
342966 sp_cacheconfig is displaying change info to be the function of sp_listener which is incorrect.
342969 Feature Request to enhance CR#217318 (automatically perform dbcc REBUILD_TEXT)
342974 CIS: The message "current process infected with 11" in the module 'char_get_str' together with a stack trace which includes the modules 'match_pattern' and 'pattern' may be reported in the error log if a SELECT statement with square brackets '[]' as wildcard characters runs against a DCO12.0 as the backend.
342981 sp_locklogin doesn't take account of user defined roles which have sa_role or sso_role assigned to them when deciding if the last login with these roles directly assigned to it is being locked.
342988 The following system sp are not in the sybsyntax database. They do not exist in ins_syn_sql script either.

sp_dbextend ; sp_ldapadmin; sp_listener ; sp_tempdb ; sp_dbcc_recommendations

sp_dbcc_help_fault ; sp_dbcc_exclusions

343010 Some queries including more than one aggregate function

may return incorrect results when they are executed in

parallel.

343065 The message "current process infected with 11" in the module 'stat_check_sampling_perct' together with a stacktrace which includes the modules 'statbuild_noindex' and 'startsort' may be reported in the errorlog if parallel UPDATE STATISTICS is executed within a stored procedure.
343114 As the number of cachelets for a given cache increases, the overhead increases dramatically and

at times the growth is more than the actual size of the cache. On Linux and HP-UX on IA64 platform,

we incorrectly increment the wait count for a spinlock and report as %100 waited on any spinlock.

343115 Two processes setting up a site_handler may hit a race condition, causing a hang.

The hang will be accompanied by the message

"A call to srv__waitfor_read() was interrupted by an attention".

--EOF--

  • 本文链接地址:https://www.dbainfo.net/sap-ase-cr-number-1.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《SAP Adaptive Server Enterprise的所有已知BUG列表(1)》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)