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

随着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
670907 ASE may crash unrecoverably with signal 11 in ct_poll when a connection to a remote server

running an SQL query is killed.

670973 When more than one column is encrypted with same key encrypted by user password, even if wrong password is specified for one of the columns during bcp out, no error is given and bcp succeeds.
671049 sp_sysmon I/Os Delayed by is not reported correct for linux 64 bit platform.
671084 Error 644 may be reported on a nonclustered index of an APL table that has a clustered index that allows duplicates, and the row being inserted is a duplicate.
671096 A query involving a join between proxy tables may receive an infected with 11 with a stacktrace containing the function CtlibRemoteAccess::cursorClose(_cscommand*, CtlibRemoteAccess::CURSOR_STATE, char*, const char*, bool)
671101 For a new XSM, the default code format is Mixed Case; suggest it should be Upper CamelCase, to avoid generating tag names with underscores
671104 When adding attributes to elements, the element symbol overlaps nearby symbols. There is noway to correct the diagram except to toggle the Display Preferences\orientation attribute from horizontal to vertical

To reproduce:

1) create a new XML model

2) create a new element (element_1)

3) add three new elements to element(element_1)

(The three new elements branch off the sequence)

4) add several attributes to element_2

NOTE: element_2 now overlaps the other elements

Neither collapsing the sequence, auto-layout, nor redisplay corrects the issue.

The only workaround is to change the orientation from horizontal to vertical

671105 Parameter substitution in XSM Language menu

Open a XML model

Click Language menu

The menu reads...

Generate %s File

Reverse Engineer %s File

Instead of...

Generate Schema Files

Reverse Engineer Schema Files

671131 Under rare circumstances an undetected deadlock may occur between 3 sessions.

Session #1 is running DUMP TRAN WITH NO_LOG, already holds the append log semaphore lock

and is waiting for an exclusive latch lock on syscolumns page 'P1' to be granted.

Session #2 is running DROP TABLE, holds the conflicting with session #1 exclusive latch

lock on syscolumns page 'P1' and is waiting for a PLC lock to be granted. Session #3

is running DROP TABLE, holds the conflicting with session #2 PLC lock and is waiting

for the append log semaphore lock to be granted, which lock is held by session #1.

671152 Both a user-defined threshold and a last chance threshold may not be fired and ASE runs out of

log free space with a 1105 error and a 3475 error on a mixed data and log database.

671228 ASE running on Linux platforms with batch I/O enabled (which is enabled by default) could hit timeslice errors in the module basis_flushbatchio().
671238 The message "current process infected with 11" in the module 'proc_find_subscribable' together with a stack trace which includes the modules 'lt_sqlrep_exec_polic' and 's_mustrecompile' may be reported in the error log when a stored procedure is marked for replication and ASE is checking if the stored procedure needs recompilation.
671337 The error 15700, "Failed to read the virtual page 'n' from the device 'm'", together with "sddone: Invalid argument", can be raised when trying to load an archive database if the archive database devices have been initialized with any of the options DSYNC or DIRECTIO set to TRUE, explicitly or by default configuration.
671370 Correct Documentation for exp_row_size and it's maxlen and minlen value.
671405 Authentication error message does not clearly specify that something might be wrong with the host name or port number of the registered ASE resource.
671418 Adaptive Server running in threaded mode with a single client that is doing heavy i/o workload can incur response time performnce loss.
671436 Job Scheduler runs a job multiple times over a minute under some situations.
671437 Parallel query plans are not chosen over serial query plans when using

a large number of engines due to over optimistic costing of serial query

plans.

671439 Feature request to implement an option to stop sp_helpsort consuming transaction log on master.
671440 Under some rare circumstances, ONLINE DATABASE or LOAD TRAN command may fail with a stack trace showing module xls_pre_alloc_numclrs and plc__flush. This may happen after loading a transaction dump including log records written by a CREATE INDEX command run for a DOL table.
671536 In certain circumstances, a query that contains an OR clause with multiple joins may generate a sub-optimal plan, with respect to result accurracy, when executed with the optimizer level of 慳se_default�.
671569 Be able to only send sql statements for a table while other tables do not replicate sql statements.
671592 Lots of concurrent logins may result in error 290024 and stacktraces during ASE authentication.
671598 A 15760 error, "Invalid dump header when loading the database with ID '<value>'"

may be reported when attempting to load a valid database dump into an archive database.

671752 Truncation od text at the Data Cache Manangement section causes spinlock contention information not to be reported by sp_sysmon.
671764 This problem happens on Monitoring view of Cluster Edition ASE in the Database view. When the database item on the top table is changed, the label "Selected database: <name>" in the bottom tab does not change. This resolution fixes the problem.
671788 When running dbisql from pcclient distribution, trying to use the import function, it is reported that the JDBC driver is missing.
671950 DDL generated by sp_helptext using the 'ddlgen' option may result in an error. This occurs due to the expansion of "*" to the individual column names.
671953 slow bcp performance on linux platforms when using DIRECTIO for devices
671997 On AIX, memory leak may happen when remote server option "net password encryption" is turned on.
672040 In rare circumstances, 2510 error, Key mismatch between index page and data page, is returned when dbcc checktable is run for a table with a replication index.
672046 For the job having output with large column length, the JS agent may fail to execute job with following errors in JSAGENT log ( With -T3641):

00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker string provided is too long to add to buffer provided

00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker jsj__AddToBuffer() failed

672144 A 2540 error may be reported by DBCC CHECKALLOC following instance failover recovery when a REORG REBUILD (index), CREATE INDEX, DROP TABLE or TRUNCATE TABLE command had completed on the instance just prior to its failure.
672181 Backup Server: On 64-bits Windows platforms, dumps to existing files do not reset the file size when the dump size is less.
672196 MERGE UNION DISTINCT plan could return duplicate rows incorrectly when

the union view/derived_table is participating in an equijoin join with another table and

there is also a constant sarg (col=<const>) on the other table's equijoin column.

672255 In some circumstance, the CPU usage of ASE might increase to near 100% after turning on the 損lan text pipe active� option.
672395 143360 bytes only 140K does not appear to be a large enough stack. Just about all customers will have to increase this with sp_configure or experience stack overflow errors.
672446 After entered the ASE login/password in the login dialog to configure the existing ASE, syconfig crashed.
672597 In rare circumstances, the error 614, Severity: 21, State: 7 might raise when executing

a stored procedure and UPDATE a temp table.

672606 In some cases the output from the sp_opt_querystats stored procedure would be formatted incorrectly due to lines being broken in the middle of words or due to missing letters or characters.
672733 A 820 error may be raised when executing BCP-IN with all INSERTSs that causes duplicate key errors during aggressive HOUSEKEEPER garbage collection.
672829 There can be high spinlock contention on the ASE network memory pool spinlock.
673130 Sub optimal plan with ase_current related to view and more and 6 tables.
673156 Missing brackets for bracketed identifier in abstract plan generation.
673169 Msg 5893 prints wrong values while trying to increase the number of user connections.
673179 A user defined function or a stored procedure that calls the radians() function with numeric parameter may start returning NULL for all executions once it has been called once in a way that passed NULL to the radians() function.
673339 In rare circumstances a 3327 error, "During redo, the page timestamp check found page <pageno> needs redo when the log record is before the first log record in phase 1 that needs redo...", may be reported when loading a database dump that was dumped on a relaxed-durability database (RDDB).
673377 Feature request to allow login triggers to set the sessions default transaction isolation level.
673379 Under some rare circumstances, SELECT INOT on UNION view may fail with error 225, "Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization".
673426 sybmigrate raises error about non existent index when one table has a text/image column
673434 Sub optimal plan with ase_current related to 631416.
673487 In limited cases, parallel GROUPBY queries that use 2-phase grouping strategies and have two or more XCHG operators beneath the 2-phase grouping operator may return duplicate groups with partial aggregate results.
673494 Historical Server will hang if one attempts a recording session and the monitor server name doesn't start with a letter or this name does't exist in the interface file.
673625 Sub optimal plan with INSERT and/or SELECT INTO using an ORDER BY occurring when optcriteria avoid_bmo_sorts is on
673638 Allow DISK INIT to avoid clearing all pages on a raw device
673656 Distinguishedname lookups for LDAP cannot exceed 255 characters. Trying to set the dn_lookup_url for primary or secondary to larger values are not possible
673663 Bcp documentation leads one to believe that "fast" bcp is a better performer than "slow" bcp in all cases. We need more comprehensive information to help select the best options for the customer.
673764 While 'lob compression' is enable, BCP and SELECT INTO operations will reserve more pages than the original table, which may cause regression in LOB reserve space.
673792 Improve disk diagnostic for OS and Batch IO delays for linux platform.
673834 ASE/CIS: Dropping a 'proxy_table' when the remote server is not in sysservers unnecessarily causes error:

Msg 7218, Site '<remote_server' not found in sysservers.

673857 Set SYBASE_TS_MODE=GLOBAL as the default behaviour of ASE for enabling diagnostic tool access to ASE by default.
673971 New monitor counters are added to the monEngine, monOpenObjectActivity and monOpenPartitionActivity MDA tables.
674006 Under certain circumstances, two competing SQL queries that read and update a datarows locking table may interfere with each other leading to an unexpected set of data being returned that may not be repeatable when the update has completed.
674064 ALTER TABLE ADD PARTITION on a Data-only Locked table followed by a CREATE CLUSTERED INDEX with sorted_data option and some DMLs may result in a 1581 error, "Create index was aborted because pages in the data only locked table are not linked."
674110 DBCC checkcatalog reports errors after a view is created based on the xmltable() function.

The usertype field in syscolumns is not being set correctly.

674188 Signal 11 in plc__flush during transaction dump load
674199 Linux Huge Page Support - platforms restrictions incorrect
674225 EBF 17426 one-off generate wrong stacktrace.
674235 A 8213 error, "Failed to acquire address lock on object <value>" may be reported in the error

log preceded by a stack trace which includes the modules 'des_idtnewval' and 'des__errhdl'.

The stack trace information should not be reported.

674251 A roundhash N to roundrobin 1 NLJ strategy may return too few rows if compile-time thread adjustment is done. Typically, compile-time thread adjustment might occur if "max parallel degree" is not configured at least one (or more) higher than "max scan parallel degree".
674278 In limited scenarios, right nested outer joins optimized in parallel

mode could generate a SEGV. This would occur if the outer stream

of the right nested OJ had replicated partitioning. The stack would

contain a calls to OptDeepPDTransform() and eqcGenNlJoinPop().

674415 ASE crashes with access violation exception in either spinobtain or uboalloc_from_engine
674505 Document that changing directory for logfiles (user data) can be done in userdata.conf
674535 Products:

ASE 15.5 ESD#3

SQL Advantange 12.5.3 EBF 12338

DBISQL version 11.01, build 2430

Problem Description:

Customer reports that DBISQL does not report as much detailed message compared with SQL Advantage.

Since SQL Advantage is deprecated customer is requesting FR to be implemented:

674587 When using CE and backupserver are configured ROUNDROBIN, only local instance can start the backupserver automatically.
674601 installshield hangs forever on /usr/bin/which command in tcsh+
674607 The threads required to run a parallel query may be under calculated.

The problem occurs in plans that contain store_index or N-to-1 Nlj

strategies. This can lead to the selection of plans that require

more threads than the system/query was configured for. This fix

is enabled with optcriteria cr647607.

674622 A query with a LIKE clause using a long LIKE term and having escape characters may return incorrect results.
674627 When a table is being replicated to a table that includes an additional IDENTITY, an error "AOP not found in getAopt" is raised.
674632 Enhance index scan perforamce on little-endian platforms if the index includes large mount of duplicated keys.
674645 If a database has LOB compressed tables which stores compressed XML doc, DBCC CHECKDB may report 15960 error message for LOB compression issues.
674764 If a spid in ASE which is dumping a database is killed, it can leave the sybmulbuf processes in a hung state. The "dump to" device is unusable until the backupserver is recycled.
674767 Add new ASE configuration option 'enable console logging' to control console logging, with DEFAULT value of 0 to disable console logging after server boot.
674877 Performance issue on SELECT INTO from encrypted tables for non-privileged user.
674890 A 2601 error, "Attempt to insert duplicate key row in object ...", may be raised when there are two sessions running the same MERGE statement concurrently against a table with unique index.
674926 RTDS: CPU associated with the Q engine always report usr+sys=100% by nmon on AIX only.
675179 Possible incorrect index selection when using OR predicates with equalities referencing multiple attributes of an index. For example, (a = 5 and b = 6) OR (a = 15 or b = 16) when an index exists on (a,b) could be incorrect (notice the multiple attributes, the issue does not exist for IN lists). The change is enabled thru optcriteria cr675179
675292 Undo of inserts into data-only locked tables that have an index, either by transaction rollback or by database recovery, is slow due to poor prefetch of affected index pages.
675504 A private install is always increasing the version of the .cfg file on each cluster reboot even when there are NO changes to the configuration. The cluster in question is using a 4K page size and the problem occurs if a cache pool of 32K is configured.
675563 sp_configure/sp_helpconfig report 0 in Memory Used column for config

option "heap memory per user"

675594 A 8203 error, "Expected to find the descriptor for object <negative id>

in database 2 in DROP state." together with a stack trace which includes

the modules 'sqt_free' and 'des__markdestroy' may be reported in the

error log when a session is trying to release a dynamic SQL statement

(previously prepared) and concurrently another session is trying to access

the same prepared statement, for example using the OBJECT_NAME() builtin

with the id used by the internal procedure created for the prepared

statement.

675622 A new feature request for an option to fully allocate the tempdb devices at startup.
675791 Enhance sp_rename stored procedure to rename data and index partitions.
675990 After cross-platform dump and load of a database containing a view

defined on a base table with an encrypted column and a decrypt default,

the decrypt default information may be lost leading to a 3762 error:

"The decrypt_default for column id 27 was not found in the system

catalogs."

675995 Enabling replication in a database can reduce the transaction throughput and can cause a high CPU usage.
675998 JS doesn't print error message numbers to the JS log, only the message text
676013 The MDS table monSysLoad may contain NaN,Infinity values for some statistics
676122 ASE does not respond and appears to hang when invalid packets are sent to it.
676148 The ASE PCI layer responsible for the execution handshake of ADT and UDF Java operations with the integrated COTS JavaVM is enhanced to achieve better performance.
676195 Following installation of ASE 15.5 ESD#3 on Windows, the gui tool Server Config appears to be unaware of character set cp1250.
676226 CIS connections fail on a single engine of a server, causing the dataserver to have to be re-cycled. Erros 11216, 11206 get ct_connect() error message of -1 (minus one).
676329 Signal 4 report from routine ct__tds_readall
676357 Errors 225 on UPDATE of computed column that uses UDFs after load from database with different dbid
676358 ASE fails to recognize , symbol as decimal notation for german, danish, french in config file
676453 An ASE task may be terminated with a timeslice error while issuing an asynchronous i/o. This is caused by a hang in the operating system, and can lead to recovery errors in Adaptive Server. Adaptive Server has been modified to avoid terminating the task, and will print an informational message instead. Recovery errors will be avoided, but ASE engine will hang until the operating system responds.
676488 Signal 11 in VbmManager::_VbmPutBm when using semantic partitioning
676500 FR: cannot send and cannot read message to include both suid and spid
676650 The average metrics value often appears as zero and can't capture the elapsed time less than 3ms in monCachedStatement and sysquerymetric
676654 In rare circumstances an uncommitted change to text/image data by the execution

of a WRITETEXT non logged command may not be rolled back during ASE boot time recovery

and after ASE was shutdown with nowait.

676853 Feature request for a TSQL extension that would allow isolation level 0 (dirty reads) to be used with SELECT INTO and the SELECT part of an INSERT SELECT.
676991 High CPU usage may be seen along with with high rprocmgr_spin contention.
677059 When parse_text() builtin with execute immediate is run concurrently in many sessions with each session running the query multiple times in a loop, it will result in segmentation violation in prot_desc().
677101 In a high volume server with many processes accessing and updating a DRL table with a TEXT/IMAGE or off-row JAVA column, sometimes it could return inconsistent data.
677132 Documentation correction: Prior to 15.0, if a client did not specify a packet size, it defaulted to 512 bytes rather than using the ASE configuration for default packet size. The 15.5 System Administartion Guide still states "If you change the default packet size, clients must request the larger packet size when they connect." but that is no longer correct.
677153 When loading a dump generated by an ASE 12.5 (which is not AIX) to an ASE 15.5 AIX server, an invalid column length error may be raised raised.
677167 Requesting Sybase to supply stored procedures or Sybase Central or SCC improvements to the automation of reorg rebuild activities performed within a database.
677281 Need better ETL documentation to avoid possible port conflicts
677364 ASE 15.0.3 EFTS query is slow after upgrading from 12.5.4e10 to 15.0.3
677481 In rare circumstances, Adaptive Server may hit signal 11 at mda__process_sdes during a query on the monProcessObject MDA table.
677487 Checkpoints stop occurring after the "number of checkpoint tasks" configuration parameter has been decreased until Adaptive Server is restarted or the configuration parameter is increased.
677528 An 8201 error is reported with functions dropindex, ptn_delete_row, and ptn__link_pdes_to_xdes on the stack.
677539 Unrecovered tempdb cause SIGSEGV when select from fake table
677580 When executing SP_SETREPTABLE with the parameter value 'USE_INDEX', the indexes created for

the replication of off-row text/image columns may become inconsistent when the table does

not have any other non-clustered index. In that case 'DBCC CHECKTABLE' would report error 7928.

'UPDATE' or 'WRITETEXT' may fail with error 644 or error 7165 respectively.

677603 In some cases, even there is no IBM MQ message operation, Q engine still hold high CPU usage. Open traceflag 15104 to workaround this issue.
677698 ASE install required reboot on windows XP
677805 SCC has been enhanced to dynamically generate the repository server name on startup. The name will follow the convention "scc[<host>:<dbport>]". This enhancement, coupled with the ability to modify SCC ports enable multiple concurrent SCC instances to be run on the same host.
677826 When 'enable literal autoparam' is on, executing a dynamic SQL query with numerical literal with precision over NUME_USERPREC(38) could cause errors 2756 and 706.
677850 The ASE server has a memory leak that is hit when the ASE server is run in threaded mode

and several client connections are simultaneously made using encrypted passwords.

677991 Sometimes after a failed attempt to drop a large buffer pool in a busy system, the pool may still be be available for use even if sp_cacheconfig shows the pool status as "Unavailable/deleted". However, subsequent use of the pool may, under rare circumstances, lead to timeslice error with modules like pg_allocate(), bufnewpage() and cm_cache_wash() reported in the stack.
678070 Under certain circumstances, queries that contain multiple views and/or derived tables may encounter a stack trace in vu_fixupvar. If it is possible to re-write the query to use temporary tables rather than derived tables, the problem can be avoided.
678124 Shared memory dump conditions of type "signal" on the 64 bit Microsoft Windows platform are not displayed correctly in sp_shmdumpconfig.
678129 customer is requesting the PK columns of a PDM to become elements in XSM

currently when generating an XSM from a PDM, columns could be generated to XSM as either all Elements or all Attributes

customer claims that PK columns should be coming into XSM as child elements, whereas the non-PK columns are Attributes

i.e.

- create Table_1, Col_1 (PK), Col_2 and Col_3

- generate XSM from PDM

- if columns are selected to be generated as Elements, then the outcome diagram is

Root --S---> Table_1 --S---> Col_1, Col_2, Col_3, where --S---> is Sequence and Table_1, Col_1, Col_2 and Col_3 are elements

- if columns are selected to be generated as Attributes, then the outcome diagram is

Root --S---> Table_1 | Col_1, Col_2, Col_3 |, where --S---> is Sequence and Table_1 is Element, and Col_1, Col_2, and Col_3 are attributes of Table_1

- customer thinks that the following should be the outcome diagram:

Root --S---> Table_1 | Col_2, Col 3 | --S---> Col_1, where --S---> is Sequence, Table_1 and Col_1 are Elements, and Col_2 and Col_3 are attributes of Table_1

workaround

defining manually through XML builder workaround provided - however, it will not work very well if the numbers of tables get large.

678184 In rare circumstances, checkstorage may report the error 835, "Illegal attempt to change contents of buffer" followed by a stack trace that includes the module pchk_copy_page().
678230 SH_LATCH request should be granted when nobody holding a latch on the OAM page
678252 sp_shmdumpconfig raises error 265 in subprocedure sp_shmdumpdisp when the memory dump would exceed 99999 MB in size. As a workaround, the procedure can be modified by changing the varchar size in the code line 'select @cdumpsize = (convert(varchar(5), @dumpsize) + " " + "MB")'
678257 Prepared statements with String parameters and univarchar columns may not find results correctly
678258 Stacktrace could happen in CgpPop::_CgpInitProjection() for bushy tree plan or

right nested plan. Optimizer could choose such plans under allrows_dss optgoal

or under abstract plan forcing.

678271 If a hostname exceeds 30 characters and the commonName on an SSL certificate also exceeds 30 characters, then the dataserver will not start this listener.
678278 BCP into a range partitioned DOL table can result in excessive unused space.
678287 Memory allocated for the internal ASE server DES is not freed after a failed connection attempt

that results in error 7218. The entire memory pool runs out with an error 11223 after 1024 failed

connection attempts.

678432 If a target list for a view maps to more than one encrypted column in the

base table with the decrypt_default attribute, Adaptive Server may fail to

check the user's decrypt permission and incorrectly return the decrypt_default

value instead of the actual column value.

678476 New Feature Request (NFR) ASE 1502 ... make it possible to have a role with srid but role is unusable

customer does not want to turn the role off. customer essentially wants a way to have a role so that it uses an srid and exists on all machines. However the customer does not want it usable on all machines. the customer does not want people to be able to grant permissions to it. the customer just wants it there as a placeholder so that the customer can keep all their dataserver permissions in sync except down to the grant level.

678527 In some long running ASE servers, an 8203 error - "Expected to find the descriptor for object <objid> in database <db_num> in <state> state." might be raised with crt_main in the stack trace while creating a temporary table.

There will be an information message "INFO: Total Object Ids in temporary database generated:<total id count>, LWPs generated: <LWP id count >" printed for every 100 million object ids generated

678544 Under certain circumstances, "transfer table ... for csv" can repeat the initial bytes of a transferred character column as the final bytes of that column.
678586 Auditing process fails to wake up later even if enough locks have been freed up
678605 Optgoal to be printed in Query Plan from showplan.
678633 Invalid pointer param error when running showplan with compatability mode on
678639 Closing a connection in ASE may cause high cpu usage.
678736 Upgrading from 15.5 ESD to 15.7 release, if tables have partitions, ASE may generate seg fault involving functions s_readparseProcText() -> s_cpytxt().
678763 Updates on tables that have foreign key constraints may take exclusive row locks on non-qualifying rows.
678799 Feature request: add support in next available release of SCC to shrink repository db as it is possible with SQLanywhere dbunload utility.
678812 Sybmigrate hits a 247 error (Arithmetic overflow during explicit conversion of NUMERIC value to a INT field) on tables with more than 2.1 billion rows.
678975 The message, "Invalid column length:... . Value must be between ... and ... at offset ... for 'all-pages' row with minimum length of ...", together with a stack trace which includes the modules 'LeSubst', 'LeScanOp::_LeOpNext' and 'execproc' may be reported in the error log when the 299 command line traceflag is used and under some circumstances a stored procedure which queries a user temporary table created outside is executed with different schemas for that table but the same plan is reused.
678990 FR: create big_row_count() function that can handle more than 2bil rows
679134 Job Scheduler fails to execute job with "Multiple password found" error even when sp_addexternlogin is done only once for a user.
679190 (internal only) Correct a segmentation violation related

to the replication of row-level compressed data.

679255 In a partitioned cache, any attempt to drop a large buffer pool,

using the stored procedure sp_poolconfig, when the total number

of buffers in the pool is not evenly distributed amongst the

cachelets, will fail with the following 852 error:

"Command Failed: Invalid request to move 'X' buffers from the

'<pool-size>'K pool of the '<cachename>' cache to the '2048'K pool.

Source pool only contains 'Y' buffers. Retry the command

specifying fewer buffers."

679267 In rare circumstances, the error 8203 followed by a stack trace that includes the module des_create_inxact() could be raised when rolling back a transaction.
679292 Increase default unreserved log pages for instance/s joining an existing cluster which is running.
679300 Updating configuration parameter on ASE Cluster Edition gives error, "Notification failed for parameter 'esp execution priority'"
679376 Job Scheduler Output contain line breaks at width 80 characters.
679393 Feature request to have str_replace function work on text and image datatype values.
679561 When max number replications paths is 1 and physical paths/bindings exist, print the following warning message on Rep Agent startup: Warning: the maximum number of replication paths is set to 1. All bindings for database ID '%d' will go to the default path despite the presence of %d physical paths.
679609 A 803 error may be raised together with some diagnostics information if recovery fault isolation is configured to page level and more than 12 pages have been isolated and added to the suspect page list.
679797 Under certain circumstances, running multiple instances of the third party monitoring tool asemon can lead to stack traces due to signal 11. The more instances that are running, the higher the chance of a re-occurrence of this issue.
679807 For a SELECT statement in a stored procedure, if the table has more then one partition keys and not all the partition keys in the predicates are constants, neither compiler time partition elimination nor dynamic partition elimination occurs.
679820 transactions usually abort when trying to access a table that is undergoing REORG REBUILD, but under traceflag 2792 they will instead just be blocked until the REORG completes. However, they do not show as being blocked processes in sp_who output.
679835 Error 3606 (Arithmetic overflow) occurs if configure more than 2G procedure cache size by sp_configure "procedure cache size",0,"2G", instead of specifying the number of 2k pages.
679960 When a Replication Server issues a 'suspend' to a Rep Agent configured for 'multithread rep agent' the request causes the Rep Agent to perform a full shutdown rather than suspend.
680073 In rare circumstance, 501 error (timeslice) or sig 11 error will be reported along with stacktrace when inserting rows into

DOL table with placement index on AIX platform.

680173 Signal 11 in stat_add_histogram
680181 In rare circumstances, checkstorage may report the error 835, "Illegal attempt to change contents of buffer" followed by a stack trace that includes the module pchk_copy_page().
680278 A new feature request to implement a new dynamic server wide configuration parameter to control identity gap on identity columns.
680360 In Adaptive Server version 15.5 ESD#3 or later, failure to move requested

memory between buffer pools using the sp_poolconfig system stored procedure,

may lead to error 2747: "Incorrect position specifier in format string of PRINT

command" followed by message: "Transaction count after EXECUTE indicates

that a COMMIT or ROLLBACK TRAN is missing. Previous count = X, Current

count = X+1".

680362 dynamic partition elimination should be modelled in the optimizer
680424 Sybase Central Editor used by ASE Plug-in does not have the help menu correctly configured.
680469 Include SYSAM CR 659498 in a upcoming ASE 15.5 ESD Release.

"SySAM2: cpuinfo detects too many Itanium quad core chips"

680590 clarify upgrade instructions for ASE 15.5
680730 In rare circumstances, a spid in Adaptive Server may hang. A stack trace of the hanging spid will involve the modules mda_populate_monOpenObjectActivity() and des_get().
680753 The installdbccdb script raises several 4963 errors if run when the default lock scheme is not set to allpages. The messages can be ignored.
680758 Feature request to improve the performance of DBCC GAM by using worker processes to scan allocation pages in parallel.
680759 In rare circumstances, terminating an idle CIS connection may result in some form of memory corruption in the next connection attempt.
680776 When using some devices (i.e. EQLOGIC) on Linux with multipathing, ASE cannot correctly locate the alternate paths to the raw devices for I/O fencing which may prevent ASE from starting up.
680783 A shared memory dump hangs if the ASE server encounters a signal 11 in the malloc system call.
680789 After upgrade from 155ESD#3 to ESD#4, sybcluster is unable to start an instance.
680885 ASE CE to support "rolling upgrade" between releases.
680891 User publication material for dropping instances from a cluster via sybcluster are incomplete when the instance has private devices/local user databases which must be handled in the "drop instance" handling.
680899 sybcluster should have a way to back off incomplete removal or alternately the CR 680891 should provide complete instructions for recovery from errors during "drop instance".
680944 This resolution addresses issue where alerts do not refresh within the property sheet automatically. Customer needs to close and reopen window for refresh
680992 Coverletter for ASE CE releases need updating.
681056 The first run of DBCC CHECKSTORAGE following an upgrade to 15.x can take much longer to run than usual due to having to perform deferred upgrade work on allocation pages. As a workaround, run DBCC GAM(dbname,0,0,'check') prior to the first run of DBCC CHECKSTORAGE.
681087 Problem stopping ASE as a windows service
681107 With using Sybase Central ASE-Plug-in, clicking database -> right click Property -> device tab may result in a Java error, "java.lang.Integer cannot be cast to java.lang.String" when the database has user-defined segment.
681109 If there are some NULL values in a TEXT column of a table, ASE may return " " instead of NULL when converting values in the TEXT column to CHAR data type.
681213 TDS error occurs after using set fmtonly
681347 The number of page-level compressed rows in the DBCC CHECKTABLE message is zero on nt386 platform.
681352 Replication Agent starts while the number of replication paths configured is less than the number of replication paths stored in sysattributes.
681382 Allow non sa/oper users to examine non-upgraded archive databases
681516 Under Windows 2003 NT platform when ASE is booted using the COTS JVM version JRE-6.0.24

from Oracle/Sun, the JRE headless mode is not correctly supported therefore allowing methods

using that mode to be executed although they should not.

681538 When installing ASE using one off release EBF #19426, misleading warnings about connectivity may be reported. These can be ignored.
681570 Under certain circumstances a query that has an outer join to a view that is itself included in an outer join no query plan may be identified by the optimiser. At least one of the view included in the query must also contains a query in the select list of the query that defines the view.
681574 show_cached_plan_in_xml() does not display BIGDATETIME and BIGTIME values correctly.
681587 feature request for sysobjects lastusage column for stored procs
681622 Enable HA support on Windows 64 bit platform
681629 "alter database ... set lob_compression = 0" command doesn't work when executed following

"alter database ... set compression = <new compression schema>" command. The LOB compression

level will stay unchanged after the command.

681652 For roundrobin partitioned table, if each individual partition has its own compression level, the compression level setting is lost after create global clustered/placement

index.

681666 The message "Error #0; Result Table was expected but not received" may be reported in Sybase Central when running "Object Page IO Monitor" in monitors folder.
681716 Feature request to make reorg compact not take shared table lock when it finds OAM entries with zero used/unused page.
681719 Documents should be updated with reorg compact take shared table lock when it find

OAM entries with zero used/unused page.

681729 Feature request for a CHORE(service task) to do the maintenance of the DOL tables with no customer interaction.
681811 The IOR_INTER_CALL error message is incorrect and is missing the device name.
681817 When configuration parameter 'FIPS login password encryption' is enabled and there is

no valid ASE_ASM license, sp_configure unexpectedly succeeds. License checks done at

ASE startup correctly report that no license is available, but unexpectedly allow

continued use of the FIPS login password encryption configuration option.

681948 The threshold status passed to the threshold stored procedure sp_thresholdaction may contain

some unexpected data for thresholds other than the last chance threshold.

681970 In rare circumstances executing dbcc sqltext(spid) might cause signal 11 and stacktrace.
682053 A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1." will be reported when running ALTER TABLE ... ADD COLUMN NOT COMPRESSED with 'enable compression' being configured as 0.
682117 Add valid check on default value in create table command.
682220 Minor typo in 15.5 configuration guide incorrectly references 12.5
682354 Allows stored procedures which reference temp tables created outside the

procedure to not require recompilation for every execution. This was

previously supported by trace flag 299.

682360 New Feature Request: to be able to specify optimizer timeout limit specifically to individual stored procedures when created.
682374 When capturing metrics using 憇p_configure 揺nable metrics capture敀 stack traces may be reported in mem_pageallocate. The issue does not occur if 慹nable metrics capture� is not configured.
682470 ASE is inconsistant when handling the letter 'E' as a numeric constant
682479 Upgrades involving views or procedures whose definitions contain "select *"

might fail if any of the column names in the expansion of "*" requires delimited identifiers.

682486 Add a new fake table in 'master', named 'syslogsdetail'. This is used to serve up the log records

details, only metadata and not including user data, as a result set.

682506 Current installation instructions do not adequately handle upgrade of Cluster Edition, CE, releases. Simplied instructions for upgrading existing private and shared installations should have clarified steps for the simple upgrades
682559 infected with 11 in txt_seek with update trigger using 'for xml'
682636 Any uppercase letter 'Z' in column name will be mistakenly converted into lowercase letter 'z' in the output of SELECT FOR XML.
682738 CIS creates the first text page in an INSERT-SELECT query even though the source data is null.

To activate the fix, trace flag 11241 needs to be turned on.

682864 Error 17290 can be reported by syconfig when creating a backupserver even though it is correctly created and setup in the ASE.
682931 When running DBCC PGLINKAGE with the target page being identical to the starting page, the target page will not be found and thus leads to a searching failure.
682958 Using bigdatetime caused DML performance drop when 'stmt cache monitoring' enabled, Revert bigdatetime back to datetime to fix performance drop issue, these changes will cause the granularity of elapsed time increase to 3ms.
682987 ASE may not release memory allocated to MEMC_MEMAUXBUF_1 in some circumstances such as when we use BCP to load data into table with large number of partitions. This may lead to error 701.
683008 In rare circumstances, e.g under heavy load environment, Adaptive Server may encounter timeslice error when querying the MDA table monCachedProcedures.
683014 Replication Agent related MDA tables like monRepLogActivity in a multi-engine ASE environment may report wrong values for various monitor counters.
683015 The execution of DBCC LOGTRANSFER may be aborted with the error message "ct_fetch(): network

packet layer: internal net library error: Net-Library operation terminated due to disconnect"

when attempting to process a BIGTIME value.

683027 Feature request to enhance dbcc checktable and tablealloc with some extra checks for syslogs pages containing the last checkpoint record, oldest open transaction, and ltm marker.
683028 Dynamic Partition Elimination is not used for a store procedure with EXEC IMMEDIATE.
683064 A procedure executing a function bound using des_bind encounters a 8242 error if a DDL statement is executed concurrently.
683068 On Windows 64bit platform, if multiple network interfaces are available on the system, the Job Scheduler (JS) Task may fail to connect to JSAgent leading to failure of JS configuration.
683127 DDL is now replicated within user stored procedures.
683137 Using Sybase Central ASE-Plug-in to set the Cluster Edition (CE) cluster admin password does not work.
683163 Queries in parallel mode using trace flag 16953 may generate bad plans because costing for parallel operators is incorrect. This is due to incorrect costing of one of the cost components in the parallel cost object.
683192 After downgrading from ASE 15.7 to ASE 15.5, when booting the ASE 15.5 server, a segmentation fault may be encountered during startup while attempting to reconcile the downgraded configuration options. This prevents successful completion of the server boot.
683203 Doc: Contrary to the explanation of Performance and Tuning guide, sysstatistics is affected by CREATE TABLE command.
683262 Shutting down the coordinator may cause the new coordinator to fence itself out which will cause it to error and shutdown.
683269 Change this:

"see Installing version 15.5 over an existing 15.x Adaptive Server."

to this:

"Installing Adaptive Server Using Binary Overlay"

683378 Enhance Active Messaging to avoid memory leak for MSGRECV() and MSGCONSUME() with STRING property.
683443 In rare circumstances, the next_identity() could return NULL in ASE 15.5 ESD#1 after

upgraded from 15.0.3 ESD#4.

683542 Feature request to include database name or dbid in addition to the table name currently printed in REORG related messages in the ASE errorlor
683582 There are some wrong description about transfer_table audit option in ASE 15.5 System Administration Guide.
683626 Abstract plan error message could be reported when using "set forceplan on" for

outer join query with subquery.

683708 On IBM and HP platforms, when running in HA mode, console logging has to be enabled regardless of the setting of 'enable console logging' configuration parameter.
683815 A 16321 error, "Integer value '<value>' is disallowed." may be reported when a CREATE LOGIN command is executed and the option FULLNAME, PASSWORD EXPIRATION and SUID are specified. ALTER LOGIN command may result in similar error when the options FULLNAME and PASSWORD EXPIRATION are specified.
683882 Excessive I/O to quorum devices is observed when SCC is up and cluster is down.
683887 query with a VERY large IN (over 23K) list fails with stackguard word corruption
683967 In case of language batch parameter processing, error 2834 may be reported together with the stack trace involving module proce_release(), s_copytmps() and s_cleanframe().
683997 When show_cached_plan_in_xml is executed, the time calculated for AVG and MAX time is in milliseconds. If a query takes less than a millisecond, the time displayed is 0. A more granular time mechanism is now provided to display the query execution time in microseconds.
683998 ROW data-compression type is wrongly displayed as PAGE data-compression type in the Database Properties dialog.
684046 Free the Kernel Resource Memory after copying the thread pool configuration.
684110 Under rare circumstances, a 8601 error, "Process <pid1> tried to keep the PSS for process <pid2> when it already had the PSS for process <pid3> kept", may be reported when executing utility functions, such as sp_showplan, which query another active spid.
684174 When a scheduled job is deleted before its next execution time, then when its actual schedule time comes and if the number of 'job scheduler tasks' is less than number of jobs running simultaneously, then at this point of time the Job Scheduler task may stop with error "Job Scheduler Task state set to stop".
684188 When the systabstats row for a table is deleted and the DES for the table is flushed (such as on a reboot), the table can no longer be accessed. A 15601 error, "Failed to cache systabstats contents for database <dbname>, object <objname>" may subsequently be reported in the errorlog.
684222 The message, "WARNING: The transaction log for database '<dbname>' (dbid <dbid>) can no longer be

dumped due to user '<username>' (suid <suid>) executing <cmdname>", should not be raised for

databases with "trunc log on chkpt" enabled.

684229 Feature request for a method to mark user procedures or procedure parameters sensitive so that sensitive parameter values (such as passwords) are not captured by auditing of cmdtext or procedure execution, and are hidden in the output of MDA sql capture tables.
684244 Sometimes, when ASTC task gets error 1204, out of lock error, ASTC task may fail release shared page lock on a page in syslogins table, which might lead to blocking in the server.
684249 Implement Deferred Compilation for batches and select into
684304 On AIX 6.x and 7.x platforms, Adaptive Server running in threaded mode may stop responding to some clients under heavy i/o load. This is due to AIX APAR IV10828. Contact IBM to get a fix for this bug.
684459 On AIX platform, the mapping of addresses to function names in SAP ASE stack traces has been improved. This will provide a superior mapping when the address is in a shared library.
684549 A new session level trace flag 11908 is added, if it's turned on, zero used/unused OAM entries will not be removed when running reorg compact.
684554 When 'restricted decrypt permission' is enabled, implicit decrypt permission is NOT granted to sso_role although documentation states it should be.
684602 feature request: add the ability to extract the collection data in a bcp format for distribution
684618 doc bug: alter table not allowed in transaction missing from docs
684623 The document "Using Backup Server with IBM� Tivoli� Storage Manager" should include a clear note stating that the use of remote backupservers with this option is not supported.
684690 Would like the capability supplied to SCC and ASE plugins to generate alerts related to long running ASE transactions. Would like the alerts to also be able to provide the actual sql statement and query plan of the long running transactions.
684701 The "for xml" clause is being stripped off of the text which is saved in syscomments. This makes for difficulty in re-compiling procedures which need these clauses.
684705 "int" appears to be a typo in the doc for dbcc purgesqlcache. Should be removed.
684753 Occasionally with 15.7 ASE on HP Itanium the message "Current process ... infected with

signal 4 (SIGILL)" in the module 'pci_launcher_trigger' together with a stack trace

which includes the modules 'jcnstCopy' and 'LeExecEvalsExec' may be reported in the error

log when queries that are using Java datatypes are being executed.

684761 A 2799 error, "'ALTER TABLE' command failed because 'COMPRESSION' is not enabled. A user with System Administrator (SA) role must reconfigure 'enable compression' to 1.", will be reported when running ALTER TABLE ... MODIFY <non-LOB column> NOT COMPRESSED or ALTER TABLE ... DROP COLUMN on compresssed table with "enable compression" having been configured to 0.
684763 Request to enhance ASE's handling of timeouts while writing to SAN disks during 'disk init' command.
684770 ASE Web Service fails to start if any of the databases on it's ASE are offline.
684849 Code optimization in the compression module to reduce the repeated acquisition of the resources and to use the local information as much as possible to avoid referring to global structures.
684903 sp_help_rep_agent <dbname>,'scan' does not correctly show log_recs_scanned and oldest_transction.
684918 The message "current process infected with 11" in the module 'upsleepgeneric' together with

a stack trace which includes the modules 'ha_checkalive' and 'ha_vcs_getgroup' may be

reported in the error log during the installation of ASE HA Cluster companionship on AIX.

684938 In rare circumstances, if TEXT/IMAGE/UNITEXT columns have NULL value previously, they may not be updated to have the new value in some qualifying data rows when running UPDATE command on these columns.
684964 Error msg 1579 is raised if the second char_expression is longer than 255 in builtin function compare().
684967 Only one text page for compressed LOB columns will be allocated during INSERT/UPDATE, others will be allocated on demand. This will reduce unnecessary text page reservation and is enabled only with a new session level Traceflag 7192.
685000 If the version of source server is ASE 15.0, the exception "Error while getting the configuration of net password encryption reqd for server" may be raised.
685079 There is no help topic for Options dialog for an editor window (such as the one for the DDLGen output).
685098 New interface sp_chgattribute <objectname>, 'ptn_locking', 0/1 to enable/disable partition locking
685159 The sections about ssdone error for ASE 15.x. in Troubleshooting Guide is not correct.

"Adaptive Server Enterprise 15.0 > Troubleshooting Guide: Error Messages Advanced Resolutions > Kernel Errors"

685171 When the set option "timestamp_insert" is enabled, an invalid value may result when inserting a "NULL" value into a timestamp column.
685267 suboptimal plan for query with sub query and max() with CR# 624835 enable

the CR# 624835 improve thing but it still not a good plan.

685349 New columns are added to the monCachedStatement MDA table to provide data on rows read, lock usage and sort activity.
685367 A user who does not have the sso_role should not be authorized to run the installmaster script.
685409 While restarting ASE after a non polite shutdown, Asynchronous Pre-Fetch subsystem may be inefficient for the allocation page scan happening during data free space recalculation. This may happen for dedicated log databases having one or several log fragments in between their data

fragments.

685536 The CompRowUpdated value in the monTableCompression MDA table is not increased after a UPDATE is done on a Datapages Locked table.
685585 Enhance checkcatalog to catch an invalid combination of status bits in sysprocedures.
685718 Performance improvement for disk init on XFS and EXT4 file system devices in AIX and Linux platforms.
685736 feature request to drop user in all dbs and master login with one cascading sp_droplogin command similar to CR 613678 (@with_override), in response to the workaround for CR 652640.
685808 Trailing blanks are not trimmed whn converting in-row UNITEXT/TEXT into VARCHAR/UNIVARCHAR.
685833 Off-lining and on-lining engines when running ASE in kernel process mode on HPUX (HPIA64) platform to migrate the ASE PCI integrated COTS JavaVM should be prefented as desingated memory allocations within the COTS JavaVM plugin do leave stale references under its process model. See HPUX platform RB note under CR 595859.
685854 sp_sysmon raising error 1902 on #temp_sysmon_baseline
685874 A 3250 error, "The devices <value> and <value> specified in the command should be differnt" may

be reported if the devices name length is more than 127 bytes when running a DUMP DATABASE command.

685956 On Solaris, in rare circumstances, some tasks may hang trying to send data.
685996 Abstract plan error could happen failing to apply a right nested outerjoin abstract

plan. It is more likely to happen when there is a subquery at the inner side too.

Same issue could also cause optimizer to ignore certain legit merge/hash

outerjoin bushy plan too under allrows_dss optimization goal.

686131 I/O fencing on AIX uses raw SCSI-3 PGR commands which may not be supported on some IBM storage devices. ASE will display I/O fencing reservation errors and will fail to boot.
686141 sp_showplan cannot show spid doing BCP IN to heap table using large I/O. Need clarification in document.
686159 Login and login profile attribute-value 'authenticate with ANY' fails.
686160 In the case of working with DOL tables that are marked as hot objects using DBCC TUNE(..des_bind) there is still contention on the locks.
686186 Wrong result could happen when using an IN clause over a complex union view column and

one side of the union is directly projecting a constant for the column and the constant

is also part of the IN clause list.

686209 When statement cache is on and after a variable assignment from a column of a table statement is cached, it will return wrong results for the subsequent select of the variable value if the lwp for the statement need to be recompiled.
686223 Some performance improvements are made by 1) reducing client-server communication overhead when client passes parameters to dynamic SQL statements and 2) by optimizing the ASE code path for processing dynamic SQL batch commands when configuration option 'streamlined dynamic SQL' is enabled.
686230 For SDC server, the Database Creation wizard will not show the Durability page for user to select different level of durability because it assumes full durability for all user created database.
686282 Idle timeout value for a thread pool is set to 0 if it is set to 'DEFAULT' in configuration file.
686341 Recovery may fail with an 8201 error when the configuration parameter "per object statistics active" is enabled.
686372 Not to generate new audit record for SA login on log full in sybsecurity database.
686385 In a Sun Cluster 3.x High Availability environment, executing the kill_ase_engines function may lead to lots of time being spent constructing the pid list.
686436 New feature to allow DUMP TRANSACTION to run concurrently with DUMP DATABASE.
686441 When batch inserts are executed on a compressed DOL heap table, the compression ratio

maybe lower than the compression ratio obtained from reorg rebuild. Certain conditions that

can contribute to this run-time space bloating issue are addressed.

686456 add bullet items describing the difference in reorg rebuild with regards to update statistics on the leading column of an index
686461 The Add Login wizard is enhanced to take care of a 15.7 server that has no login-profile.

1. When there is no login-profile in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page.

2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is only single 15.7 server appeared in the Login Profile page.

3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.

686481 311 errors can occur on every second execution of a stored procedure that uses dirty reads on a #temptable/index created within the stored procedure.
686549 The output from the sp_opt_querystats stored procedure only contains the plancost diagnostics if the exec or allexec options are specified. This was a documentation error.
686604 The output of the LogicalReads column in the monProcessActivity table is always 0.
686631 Pre-fetch allocation page while inserting forward row and while de-allocating the DOL data page. At the same time, use hint from placement index while inserting into a DOL table without page linkage

status bit.

686690 There are PCIDB spelling errors within the stored procedure arguments.
686706 After 15.0.3 to 15.5 upgrade by binary overlay, sp_spaceused and rowcount() on customer's server may incorrectly report 0 rows for user tables.
686798 Other processes may encounter an 8233 message while a function-based index is being created on a table, as an ALTER TABLE is being performed internally. This CR requests the message be enhanced to mention create index as a possible cause to avoid confusion.
686821 Trigger support is enabled for the MERGE statement.
686891 DSParser's discoverInterfacesServerNames(), which uses SyInterfacesDriverBase.loadFile(InputFileStream), may raise a NullPointerException.
686943 A 9236 error, "Unknown dbid '0' specified. Please check the dbid specified."

may be reported when executing the system stored procedure SP_HELP_REP_AGENT

with no parameter.

687001 When MetaData Reduction is turned on ASE RepAgent sends integers in Metadata rows with the integer data type and with no data type for Data Only rows. This causes problems when HVAR is being used. The ASE RepAgent has been changed to always send integers as character strings.
687006 A new feature request for a Transact-SQL function that will report the stack utilization for a

given process.

687106 In syconfig.exe, many sort order options are missing if user chooses to set utf8 as the default character set.
687139 ASE stalls when the license server host machine dies (or is shutdown). During that period ASE does not accept new connections.
687265 When configuring a new ASE server,the configuration may fail and terminate while configuring PCI because the max memory configuration is not enough to allow "enable java".
687303 We need a code change for histserver to allow the increase of the SRV_S_DEFQUEUESIZE for customers who use histserver against multiple ASEs. The current default is not sufficient.
687372 A 697 error, "An attempt was made to fetch logical page <pagenum> for database <dbname>....", during transaction rollback, if the transaction is doing some DMLs to upgrade row lock to table lock.
687418 This description supersedes the one in 686461.

The Add Login wizard is enhanced to take care of a 15.7 server that has no login-profile.

1. When there is no login-profile in all 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page. Otherwise, if there is LP in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected by default in the Login Profile page.

2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is no common LP data found among the 15.7 server that has data of LP.

3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.

687523 In rare circumstances on a heavily-loaded multi-engine system, a 8201 error

"Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1. Instead 0 was found."

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

the modules 'des__unkeep' and 'close_range' when an INSERT, DELETE or UPDATE is

executed on a table that has many referential integrity constraints defined and

after the execution of one of its triggers. Alternatively the message "infected with 11"

in the modules 'seq_schema_check_virtab' or 'LeScanOp::_LeOpOpen' may be reported.

687551 A UNION ALL query which involves ORDER BY and an in-row LOB column, where the column coming from the first side of the UNIONALL is not an in-row LOB column, but a corresponding column from the second or subsequent side is, can cause error 7139 to be raised.
687576 When Metadata Reduction is turned on but an insufficient Replication Server exec cache size is configured, RS may return a cache error. The logic for processing cache errors on the ASE RepAgent side is changed to skip records that were already sent to RS.
687587 Documentation enhancement request to document that dumps of the master database can be loaded into an Archive database.
687623 Documentation enhancement request for more comprehensive information on the GUI Query Plan Viewer that comes with Interactive SQL
687640 The titles of wizard appeared in ASEMAP 3.2.2 are changed:

Create Database Wizard -> Add User Database

Create Temporary Database Wizard -> Add Temporary Database

Create Temporary Database Group Wizard -> Add Temporary Database Group

Create Proxy Database Wizard -> Add Proxy Database

Create Archive Database Wizard -> Add Archive Database

Create In-Memory Database Wizard -> Add In-Memory Database

Create In-Memory Temporary Database Wizarde -> Add In-Memory Temporary Database

Create Login Profile Wizard -> Add Login Profile

687735 Populating a proxy table that contains TEXT columns with several hundred rows of data using INSERT INTO... SELECT may fail with Error 3651, "This transaction has been rolled back, rather than only the current statement."
687787 Sybdiag does not work if it cannot log into the ASE server
687824 Additional syntax for the UPDATE STATISTICS command is implemented to support an ordered tuple mode for non-indexed columns. The new syntax is: update statistics (col1), (col2) .... (coln)
687834 Under unusual conditions, error 5030 may be raised in error when an online database is altered over a 63GB boundary, requiring a new sysgams extent to be allocated.
687909 Adaptive Server may disconnect a client with TDS version below 5.0 logging "nast_readpost: Invalid tdslength" message in the error log.
687982 sp_showoptstatus does not handle BIGDATETIME datatype.
688086 A 529 error may be raised when all of the following conditions are met:

(1) The configuration option 'enable functionality group' is enabled.

(2) The configuration option 'statement cache size' is larger than 0.

(3) A dynamic SQL statement with at least one parameter whose dataype depends upon a table-column referenced in the statement has been prepared and executed at least once, so that a query plan is available.

(4) The table-column's datatype has been changed to a type that is not implicitly convertible to the original type by dropping and re-creating the table.

(5) The dynamic SQL statement is re-executed with a parameter type that matches the new column dataype.

688108 show_plan() documentation should be corrected how this could be used on a spid.
688148 sybmigrate setup migrate_server_data fails on duplicate row in sysusers, syslogins, or sysroles, but not everything is rolled back, causing customers to need help cleaning up the target so they can migrate database data in the migrate mode.
688155 On little-endian platforms, timestamp column values are displayed as big-endian values, while @@dbts is still displayed as native little-endian value, and must be manually swapped to compare with timestamp column values using "reverse(substring(@@dbts,1,2)) + 0x0000 + reverse(substring(@@dbts,5,4)) "
688166 The Assertion ((varNo == VR_NOENTRY) || (addIn.varNo == varNo)) may fail for queries with parallel

reformatting strategies where the reformatted table is partitioned N-ways.

688198 Nested loop join plan with StoreIndex (reformatting) could return wrong result when there

is an expression join predicate and the expression involves columns from both sides of the

join (e.g. t1.c1*t2.c2=t1.c3).

688284 When updating a LOB column with itself, if the original LOB data is compressed while neither this LOB column is defined to be compressed nor the table has LOB compression currently, ASE does not decompress the original LOB data.
688338 Query involving column relop NULL clause may result in a 403 error message if the column projects NULL and the relop is =, >=, >, <= or <.
688352 Using Replication Agent with the 'meta data reduction' option enabled can result in a large number of 'remove table' commands being send towards Replication Server.
688414 Drop index may hang in a 3-node Cluster setup.
688481 The message "current process infected with 11" in the module

sdes_num_in_chain() together with a stack trace which includes the

modules kill_proc() and LeExecSqlFunc() may be reported in the error

log if a long running user-defined SQL function session gets killed.

ASE may need to be rebooted following this error.

688495 If a new instance is dynamically added to the cluster in SDC mode, it may not be able to join the cluster when no other activity is taking place in the cluster.
688595 The MDA table monCachedStatement is enhanced to include new AdjustToParallel, AdjustToSerial and ThreadDeficit columns to track parallel runtime adjustment.
688611 Need additional messages to help diagnose which paths are having problems.
688706 ASE WebServices server fails to start on Winx64 platform.
688843 The help text for system stored procedure sp_replication_path includes an incorrect syntax for the unbind action with a path as a target.
688849 Server hangs after a timeslice error with a stack that includes the functions dmpx__truncatemain and des_checkpoint.
688856 A query containing an OR clause nested under another OR clause might generate a SEGV. This could occur if the in_list_general_or optcriteria is on. The optcriteria is enabled in the ase1503esd4

optlevel and above. The stack will show that we're code generating (CgpGlobal::CgpGenerate()) and trying to resolve a relop (ResRelOp) for a predicate bitmap (CgpPop::_CgpPePredBmToScalar).

688895 Rep Agent does not stop. signal 6 and stack in ASE log.
688908 statement cache on , sp_renamedb wrong relsults with inserts
688932 sybase central device tab java error when segmap 0 for tempdb
688938 add messaging to Error: 11031, to include dbid or database name
689004 Setting the configuration parameter 'send doneinproc tokens' to zero, can cause the global variable @@rowcount to report an incorrect value inside a stored procedure or trigger.
689019 update documentation about the setting for 'send doneinproc tokens'.
689028 When creating a new ASE, syconfig prompts for whether the optgoal should be set to OLTP, DSS or MIX but it never sets the configuration option 'optimization goal'.
689037 Case insensitive sort + encrypted index column leads to table scan
689056 An UPDATE that modifies more than one column may cause an infected with 11 stacktrace in the module CgpPop::CgpInplaceUpdateVars. As a workaround, begin a transaction and update each column one at a time.
689074 Following an upgrade by binary overlay or substitution, in memory object statistics may not be initialized, leading to poorly optimized plans. Following the upgrade of online databases, ASE should be rebooted once as a final step of the upgrade process to force reinitialization of memory structures from the ugpraded tables.
689084 In replication environment, if a table has data compression, and some data rows becomes forwarded

due to UPDATE, rep agent will report 9275 error "%S_REPAGNT: Could not locate the %s image for the

%s log record at (%d,%d)."

689117 sysamcap command may hang on nPar if there are many VMs.
689142 Executing ALTER DATABASE to extend a database onto a new device may fail after loading a dump of a read only or single user Quiesce database.
689153 15.7 docs still refers to monitor/historical server which are no longer included in the ASE release package.
689176 A segmentation fault followed by a stack trace involving the functions LeDataRow::_copyVarnoToCnst(), LeDataRow::readRow() and LeSortOp::_LeOpNext() may arise when a query with all of the following is executed:

(1) An outer join the projects a LOB column from the inner side of the join and

(2) A UNION ALL operation and

(3) An ODERBY clause.

689180 Queries may return rows where the column value is null and the search argument is NOT a value from an implicit conversion. Whereas, if there in no implicit conversion, the null values are not returned.
689195 When a user chooses "Optimize Adaptive Server configuration" during ASE installation with the GUI tool or resource file utility, the syb_default_pool thread pool is not set.
689200 HG index is not defined to proxy table
689206 Replication Agent treats normalization (NRM) errors from Replication Server as warnings. All normalization errors should be treated as fatal.
689214 SCC may raise a syntax error for sp_cacheconfig when trying to configure a cache larger than 9GB in size. Workaround is to run sp_cacheconfig directly though isql or similar client.
689217 The context menu for Users object in the Admin Console for ASEMAP is changed to "Transfer Object Ownership" from "Transfer Object Owner".
689224 When marking a database with sp_reptostandby and 'use_index', some TEXT columns may be handled unexpectedly with a replication status do_not_replicate instead of replicate_if_changed.
689230 The message "current process infected with 11" in the module "uwdisconnect" may be reported in the error log when a DBCC CHECKSTORAGE was aborted by CTRL+C or client application was killed.
689235 cpuinfo and sysamcap may incorrectly recognize machine-wide physical CPUs on nPar.
689359 Sig 11 occurred when running a simple query where clause having 129 value lists IN.

But having 128 value lists for the same query works fine without problem.

689431 UPDATE on DOL table with non-clustered index on two fixed length columns may fail with a 644 error.
689470 Feature request for greater control over CSMD triggers including state value for numbered errors and particular function names on the stack for signal conditions.
689633 sp_object_stats "xx:xx:xx" doesn't produce an output
689650 The message "current process infected with 11" in the module 'open__common_sdes_setup'

together with a stack trace which includes the modules 'open__lwpbyname' and 'proc_get' may

be reported in the error log and the session killed if a 603 error has been previously hit

"There are not enough system session descriptors available to run this query. Raise the value

of the configuration parameter 'number of aux scan descriptors' or retry your query later.".

689691 The Resource->rpdeshash_spin may result in high contention under some workloads.
689798 Under rare race conditions, when BCP IN is in progress with the INSERTs running concurrently on the same table, BCP may encounter an 820 error where the process tries to dirty a buffer which is already pinned to another PLC.
689809 When sp_configure "capture missing statistics" is turned on, lists of comma-seperated column names may be output to the console window.
689812 syconfig.exe does not set/add backupserver name to master..sysservers.
689835 New feature request to improve locking mechanism for DML to access text data.
689860 ASE will fail to dump shared memory when 'number of dump threads' are configured to 2 or more. The errorlog will contain an infected with 11 stacktrace that includes shm_mergedump.
689889 Automatic partitioning of data caches does not occur in threaded mode if "number of engines at startup" does not equal number of engine threads.
689906 The error 8009, "Logical page <page number> is not in the given database map." could be raised by the backup server when trying to load a database that has a hole and the physical size of the target database is bigger than the physical size of the archived database but the logical size is smaller.
689990 Using "SET STATISTICS" type tracing without appropriate user permissions can result in a stacktrace in OptGlobal::_GblSearchEngine(int*) being reported in the ASE errorlog.
690028 In rare circumstance, error 9209, "Missing datarow in TEXT/IMAGE/UNITEXT insert log record.

Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker =

(page id, rowid))", will be reported if a TEXT/IMAGE/UNITEXT columns is defined to be compressed

explicitly, or the table it belongs to has LOB compression, and this column is configured to

be replicated.

690064 A 11051 error, "ALTER TABLE '<table_name>' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.".
690380 In ASE 15.5 Cluster Edition, under rare circumstances, rows in a DOL tables may get inserted into a deallocated page and lead to consistency errors later on. For example, the error 12301, "Internal error: the index (id = <indid>) and the data for row (<page>, <row>) in table '<table>', database <dbid> are inconsistent; data is marked deleted but index is not. Aborting the transaction." may be reported in the errorlog.
690406 When the coordinator node is shutdown, the new coordinator may be fenced out when new instance joins the cluster. The new coordinator will display write errors and then shutdown e.g. "sddone: write error on virtual disk 0 block 4598". This issue has been resolved via CRs 680776 and CR 686131.
690437 Expression subquery was always evaluated as part of the aggregate input expression

even when the subquery is under CASE expression and the actual execution of the CASE

doesn't need the result of the subquery. This could lead to unexpected exception

during the unnecessary execution of the subquery.

690496 A SYSAM-2 generated license will not work if the word "GROUP" appears at the beginning of a line. The quotes around the enire line/phrase seem to be ignored and the work, "GROUP" looks to be treated as a keyword.
690533 A wrong result could happen for an equi-join between two columns with different

datatypes (such as INT2 = INT4) and there are two or more OR predicates (including

IN list predicates) on one of the joining columns.

690630 A stored procedure that calls a T-SQL function such as reserve_identity, identity_burn_max or

next_identity will encounter a 10330 or 10354 error. This will occur even if the user has execute

permission for the stored procedure and the stored procedure and the referenced object are owned by

the same user.

690665 The cpu utilization may be excessively high when 'enable hp posix async i/o' is set as 0 and 'allow sql server async i/o' is set as 1 on HPIA64 platform.
690704 Feature: use sp_maplogin to map external users for Kerberos authentication instead of sybmapname
690707 ASE running on Windows platform crashes on startup when the configuration parameter 'allow sql server asynch i/o' is set to the non-default value of 0.
690730 High rprocmgr spinlock contention may be observed under heavy workload of dynamic SQL and stored procedures.
690748 When a Replication Server issues a 'suspend' to a Rep Agent configured for 'multithread rep agent' the request causes the Rep Agent to perform a full shutdown rather than suspend.
690805 When a server user executes the SQL builtin valid_user(<suid>) passing

his own server id to the function, the builtin incorrectly returns TRUE in

the case where the server user is NOT a valid user in any database but where

there exists a guest user in at least one database.

690835 Dataserver hits stack overflow during Job Scheduler startup.
690990 The message "current process infected with 11" in the module 'rec_undo_session' together

with a stack trace which includes the modules 'xact__rollback_local' and 'crt_main' may be

reported in the error log when the 1105 error was previously reported during the creation

of a table.

691039 When there is a declare cursor on deleted/inserted table in an instead of trigger on a view, INSERT/UPDATE/DELETE on those views triggers the error message.
691073 sybmigrate: initial login screen doesn't see servers named with "query"
691074 sybmigrate: initial login screen doesn't see servers named with "query"
691085 When marking a database or a table for replication and for using replication indexes for text/image columns, a syntax error 156 may be reported when processing a table whose name is a quoted identifier.
691248 When tempdb_space resource limit is reached, any subsequent work table creation operation fails and does not release the buffers and the allocated tempdb pages during the execution.
691255 Grouping by UNIVARCHAR column may return wrong result if the UNIVARCHAR column contains NULL and

pure blank values and a GROUP HASHING plan is chosen.

691291 Using JDBC with SELECT_OPENS_CURSOR=TRUE and isolation level 0, error number 16820 is sometimes reported when cursors are erroneously changed from readonly to updatable.
691306 feature request to have SCC pop up window for sso_role that is the same as:

set role sso_role with passwd xxxxxxxxx on

So that clients with sso_role can see all encryption keys in all databases without having to login and use isql or dbisql.

Server menu now included 'Role Activation' dialog.

691315 A signal 11 followed by a stacktrace involving the module 'stb_insertvalue' may be reported when UPDATE STATISTICS is run on one column of an All-pages Locked table and the All-pages Locked table has at least one index with the updated column being one of the key column in the index.
691367 LIO and PIO appear to be the same always when using histserver recording sessions.
691374 The reported problem seems not be an issue related to the ASE integration with JavaVM and the ASE_JAVA execution but more of a problem related on how the IBM JVM(R) J9 VM prompts / responses to memory cleanup within its GC (Garbage Collection) mechanism.
691412 The error, "worker Server message: Unclosed quote before the character string '<string>'", followed by error messages "worker jsd_GetResults() failed" and "worker jso_FlushBuffer() failed" may be reported by the JS Agent in the JS agent log.
691458 LDAP errors, such as "The LDAP URL string '' is invalid. LDAP subsystem reported error '(URL row not found in sysattributes)'", may be reported in the ASE errorlog at startup if traceflag 3635 is enabled. This occurs even if "enable ldap user auth" is 0.
691478 Replication Server may raise the error 14138 when attempting to process a writetext LTL command that was generated using metadata reduction.
691504 The system stored procedure sp_reptostandby now reports the progress of its execution.
691572 Under rare circumstances, selecting over 32 columns using DISTINCT and with the configuration option 'avoid_bmo_sorts'/'ase_current' can lead to 325 errors.
691582 In rare cases, a DUMP TRAN command is incorrectly allowed following a DUMP DATABASE command during which a partially-logged command like SELECT INTO was active that also commits some time towards the end of the DUMP DATABASE command. The partially logged operation will be lost when the database dump and transaction log are loaded.
691595 Full syntax object defination is not allowed for ALTER ENCRYPTION KEY ... MODIFY OWNER command.
691627 The message "current process infected with 11" in the module

'css_deallocate' together with a stack trace which includes

the modules 's_free' and 's_cleanframe' may be reported in the

error log under some circumstances if the execution of a stored

procedure using a cursor was aborted by an error (like a 1205

error caused by a deadlock) and the plan being executed was

just recompiled.

691734 New Feature Request for binary datatype that allows NULL values but does not truncate trailing zeros.
691753 fingerprint function for objects with hidden SQL text
691764 sp_flushstats no longer clears systabstats emptypgcnt column in 15.x like it did in 12.5.4.
691780 In rare circumstance, error 874, "Process <process id> is trying to unkeep buffer <buffer address>

(dbid: <dbid>, pageno: <page id>) without releasing the exclusive latch it holds on the buffer.",

may be reported with stack trace when running UPDATE/WRITETEXT commands on TEXT/IMAGE/UNITEXT

columns, or DELETE...FROM/TRUNCATE TABLE/DROP TABLE commands on tables which have TEXT/IMAGE/UNITEXT

columns, or DROP DATABASE command on databases which have tables contains TEXT/IMAGE/UNITEXT

columns.

691812 After the master key owner sets the password for the master key on one cluster instance, creating a column key protected by master key on another cluster instance may result a 2950 error (master key copy does not exist).
691854 The Reference Manual entry for sp_monitorconfig indicates that only System Administrators can execute it. The permissions actually require either sa_role or mon_role.
691914 Using 15.7 default configuration, old client drivers using a 512 byte packetsize gets disconnects/hangs. ASE sees nast_readpost() Invalid tdslength errors. When sending more than 1024 bytes.
691929 If the character set is UTF8 and a stored procedure is created with upper() or lower() builtin function and it has a LIKE clause to compare this upper() or lower() with another parameter, a 2431 warning message may be raised when the stored procedure is recompiled.
691967 Dynamic SQL execution with noexec set correctly suppresses execution but does not result in a query plan. This results in no output from show_cached_plan_in_xml().
692003 Sybmon failed to load memory dump with error 13 on ibmaix64 platform.
692050 After inserting XML data into compressed TEXT column using BCP IN/ODBC BULK/WRITETEXT BULK, 7136

error, "ASE is now using a multi-byte character set, and the TEXT character counts have not

been re-calculated using this character set for table <table name>. Use DBCC FIX_TEXT on this table

before running the query again", may be raised when query data from this compressed TEXT column.

692086 A task may hang even though the connection at other end is down.
692132 Request to certify ASE with NUMA architecture, which is available with several hardware options and supported by Oracle and MS-SQL.
692176 In ASE Cluster Edition, dropping a database and recreating a new local temporary database reusing the same database ID may result in issues during runtime.
692233 When Replication Server set dsi_bulk_copy 'on' to replicate compressed LOB data to the replicates ASE, the replicated ASE may be not able to recognize the compressed LOB data and insert them incorrectly as plain TEXT.
692237 Starting the Backup Server with -D4096 will suppress messages "Attempting DSync I/O for device '<value>'." from being reported in the Backup Server error log during the execution of a DUMP DATABASE command.
692246 When replicating compressed data, the RepAgent thread is leaking memory from the 'compression info'

memory pool. As a consequence, error 716 may be reported ("Unable to allocate memory of size <n> bytes from the 'compression info' pool.").

692333 In rare circumstances on a heavily-loaded multi-engine system, the message "timeslice <value>, current process infected" together with a stack trace which includes the modules 'jldr_ReleaseLocalLoader' and 'pci_free' may be reported in the error log when applications use JAVA extensively.
692345 A new feature request for an sp_addmessage option that will suppress echoing the newly added message

text back to the client.

692359 Performance Enhancements to BCM Latching without Cache spinlock in addition to Buffer ELC changes for ASE Scaleup.
692431 When executing an EQUI-JOIN using a local index scan at the inner side of a NESTED LOOP JOIN, a stacktrace involving the module CgpUnion::_cgpInit() may be reported in the errorlog.
692509 sp_sysmon 'cache wizard' got Msg 3606 "Arithmetic overflow occurred"
692550 A 11060 error, "This statement has exceeded the maximum number of recompilations (10). This indicates an internal error. Please note the error prior to this one and contact Sybase Technical Support.", may be reported under some circumstances when a stored procedure containing a SELECT INTO ... UNION statement is executed and references session temporary tables and/or stored procedure parameters.
692691 Documentation: ASE System Admin Guide, Changing character set or sort order should warn that no database can be read_only and that precludes changing the charset on servers that have existing archive databases.
692711 The dbcc reindex comand is only documented currently with no options. There are situations where one many wish to rebuild indices without checking.
692775 The message "current process infected with 11" in the module 'open__common_sdes_setup'

together with a stack trace which includes the modules 'pggam_getfree_lowhigh' and

'crt_work' may be reported in the error log and the session killed if a 603 error

has been previously hit "There are not enough system session descriptors available

to run this query. Raise the value of the configuration parameter 'number of aux scan

descriptors' or retry your query later.". Alternatively a stack trace which includes

the modules 'open__lwpbyname' and 'sqt_get_plan' may be reported.

692870 Enable pinning of dynamic SQL query plans via the configuration option 'dynamic SQL plan pinning'. This is a productization of trace flag 480.
692872 In rare circumstances, Adaptive Server may hang as a result of an undetected deadlock between a process that is executing a DUMP TRANSACTION and another process that is running a query that uses the last-chance threshold builtin LCT_ADMIN.
692873 ASE client connection (sometimes a replication agent connection) hangs in a call to ct_cancel with the message, "kernel usrcancel: request structure in use", reported in the errorlog.
692898 The stored procedure, sp_reptostandby, will now print a message warning that the execution can take a long time.
692946 Merge partition into an existing partition but not a different segment is not supported, but the command will succeed even though the command takes no effect.
692959 ASE on Windows platform crashes with a storage access violation followed by a stacktrace in the errorlog involving the modules 'spinobtain' and 'ws__nclose_defer'.
692961 Trailing zeroes from varbinary (or binary null) columns in proxy tables are truncated even though 'disable varbinary truncation' is set.
693011 An infected with 11 may occur in function sprintf with EquivClass::eqcCostComputeTree on the stack when literal autoparam is active.
693221 When one of the configuration options, enable functionality group or streamlined dynamic SQL, is enabled and a query containing a COMPUTE clause is executed more than once and the query is either a dynamic SQL or an ad hoc query that is stored in the SQL statement cache, then an extra empty row may be returned on the second and subsequent executions.
693269 sp_who in chained mode fails with 226, 17260, and 3701 errors due to misplaced select in installmaster script.
693322 Users who have replication_role should not be able to truncate system catalogs

or audit tables.

693329 In rare circumstance, the message, "current process infected with signal 11" or error 632, "Attempt to move memory with an incorrect length of <length>. Maximum allowed length is <max length>." may be reported with stack trace after upgrading to ASE 15.7.
693355 When the ASE ESD number is not an integer (e.g. 1.1, 4.1 or 5.1 etc), then anything using the sp_versioncrack stored procedure (e.g. sp_spaceusage) may encounter a 249 error (conversion error).
693358 After inserting data into TEXT column using java string in ASE server which uses multi-byte character set, a 7136 error, "ASE is now using a multi-byte character set, and the TEXT character counts have not been re-calculated using this character set for table <table name>. Use

DBCC FIX_TEXT on this table before running the query again", may be raised when querying data from this TEXT column.

693413 The wash size may be returned as a negative value in the ASE configuration file.
693430 PCI enabled with PAM auth allow native thread send signal to ASE
693442 Under a rare situation, if a CONVERT node is needed for the like clause, it could return wrong result.
693483 In 15.0.3 ESD#4 and earlier, monCachedProcedures would return view, rules, default in addition to triggers and stored procedures
693485 require to have the capacity to disable auditing of trigger activity.
693491 A transient 605 error may be raised by a query against a table(lock scheme datarows) having des_bind and REORG REBUILD has just been done. Please use dbcc tune(des_unbind,dbid, objname) to unbind the object before REORG REBUILD to avoid the error.
693592 DUMP TRAN may fail with a 4205 error if the database has any sysusages rows in the master database with a NULL value for the location column and an unreservedpgs value larger than 65535.
693685 Instrumentation: In ASE Cluster Edition, user tasks may hang, and cannot be killed, and also block other user tasks from proceeding by holding locks.
693728 A 204 error followed by a stack trace involving the modules 'norm3_propagate', 'norm3__driver' and 'normalize' may be reported in the errorlog when a parameter, other than the allowed integer datatype, is specified for the identity() built-in.
693762 In some circumstances in a cluster environment ALTER DATABASE can get a self deadlock.
693772 Unicode sort order 54 is incorrectly described as being accent insensitive when it should be accent AND case insensitive.
693775 Job Scheduler is enhanced to execute job from startdate:starttime to enddate:endtime under new schedule property 'continuous_run'.
693794 Comparisons under utf8 sort order 54 can give incorrect results
693798 An error 2836, "The cursor 'cur' is already tracking another procedure. This is an internal error.", followed by a stacktrace involving the modules 'curs_release', 'curs_close' and 'css_deallocate' may be reported when a cursor that needs to recompile is opened.
693828 Doc CR: ASE sysdatabases status columns need to include newer values in manual pages.
693835 Compared to ASEMAP 3.2.5, new icon is used to separate already-revoked permission (x mark in dark blue) from to-be-revoked permission (x mark in red) in ASEMAP 3.2.6.
693925 When Server Discovery is enabled and "UDP" discovery service is included, server discovery such as "Find" on Connect Dialog, or verifying cluster name on Create Cluster Wizard may take a very long time.
693982 alter table fails to update status2 in syscolumns when column being modified to add/drop a default value
694051 avoid redundant logging for updates with the identical values
694123 The 10330 error message is issued on a select from a join with a normal table and a view after dump/load database. The view and the normal table both have encrypted columns that have decrypt_default. The server has restricted decrypt permission set.
694167 When using the distribution by connection model and "ddl path for unbound objects" is set to "default", DDL is not replicated to the correct path.
694188 The message "current process infected with 11" in the module 'sg_simulate_corruption' together with a stack trace which includes the modules 'bt_traverse_get_apf_pagenos' and 'getcachedpage' may be reported in the error log during the rollback of a transaction either at run time or at ASE boot recovery stage, when the recovery fault isolation feature for a user database, which governs how

recovery behaves when it detects data corruption, is active.

694197 Executing 'sp_encryption null, login_passwd_check' may mistakenly report that the key copy's login password is not synchronized with the assignee's login password.
694262 When using BCP to import data to a Page-locked table that permits nonmaterialized columns, ASE will incorrectly report that a data set contains badly formatted rows if it happens that the first row in the data set has a NULL immediately preceding the first nonmaterialized column in the row.
694368 The OSPID value in the monEngine MDA table does not match with the osprocid value in sysengines.
694401 Job Scheduler does not print error messages in the error log without trace flag 3641.
694407 Documenting change request:

As of 12.5.3 ESD #3, the QUIESCE DATABASE and UNMOUNT DATABASE commands

are allowed to operate on any number of databases. This is the result of

CR 379513. Currently, the QUIESCE DATABASE docs specify:

You can specify a maximum of eight databases in a single quiesce database

hold command. If you must suspend updates to additional databases, execute

additional quiesce database hold commands.

694413 Decompression may fail when we update one forwarded row during RID scan.
694417 investigate options for kernel.randomize_va_space
694470 New Feature Request: for configuration option to prevent users without decrypt permission from updating encrypted columns.
694488 In rare circumstances the message "Infected with 11" together with modules like s_cleanframe, s_senddone followed by spid termination may occur when set statistics time is enabled with a create proc referencing a non-existent temporary table and a particular Sybase supplied traceflag is enabled.
694495 The command DBCC SETTRUNC('ltm', 'end') extends the transaction log with one page before setting the Secondary Truncation Point to the new end of the log so as to avoid unwanted data replication.
694511 Introduce randomization in TDS login protocol (CVSS Rating: 5.5)
694531 When the proxy table contains a LOB column, executing an INSERT-SELECT queries joining a local and proxy column may hang or result in Ct-library errors such as "Ct-library: Msg 0x0101013e Fatal (Layer=1 Origin=1 Severity=1 Number=62): ct_get_data(): user api layer: external error:".
694571 Impementation to error 2780 to reports details about the object
694606 Kerberos support is needed in DBISQL for it's access to ASE. The support should be available from Sybase Central when using DBISQL also.
694678 The SsqlId column in the monSysStatement MDA table incorrectly shows zero instead of the correct statement cache ID.
694724 In ASE Cluster Edition, during cluster reboot after a shutdown cluster with no_wait has happened, in rare circumstances the cluster is not bootable, with 12314 error and a stack trace with "des__set_clstats".
694750 For a table which has more than one LOB columns, if one LOB column is set to be replicated and at least one of other LOB column which follows the replicated LOB column is compressed, update on the compressed LOB columns may not take effect.
694804 SYSAM is not checking the number of CPU after changing from SMT-4 to SMT-2
694828 Need to have SCC support complete single signon access via Kerberos (Unix/Windows) and SSPI (Windows).
694839 When there is non-contiguous free space between rows (due to a row shrinking) in DOL tables, the length is stored at the beginning of the free space. If that freespace length value is incorrect, DBCCs report a variety of misleading error messages including 614, 7928, 9991.
694912 Exception is raised from localize command in sybcluster if ASE-15_0/locales contains unnecessary files/dirs.
694916 In rare circumstance, 691 error, "Encountered invalid logical page '<page no>' while

accessing <parition name>. This is an internal system error. Please contact Sybase

Technical Support.", may be raised when inserting data in bulk mode into replicated

table with compression and LOB columns while sp_reptostandby is turned on.

694939 Error 11060 may be raised by an INSERT into a view with an INSTEAD OF TRIGGER when SET CIPHERTEXT is ON and no encrypted columns on the underlying table.
694946 This resolution fixes an upgrade defect from SCC 3.2.3 to 3.2.4.
694961 Reservation conflict messages may appear in the system log on systems with multipathing when I/O fencing is enabled.
694980 In ASE Cluster Edition when the 'print deadlock information' configuration option is set or traceflag 1204 is turned on, for locks involved in the deadlock, incorrect identity may be printed when the lock is a Globally Unique Identifier (GUID) lock.
695090 In extremely rare circumstances under Multiple Path Replication, it is possible that the retrieval order of path information from sysattributes could be different between Rep Agent runs causing log data to be sent to different Rep Servers which could lead to undetected duplicate records on the replicate database.
695113 Feature request to change where the threshold action proc runs in a multi-node cluster.
695135 The message, " Expected object passed to kmuxtskGetThreadpool is not of type Multiplexed Task", is reported in the errorlog.
695156 When ASE is configured with multi-bytes charset with 'statement cache' and 'literal autoparam' enabled, repeatedly executing a SQL batch with comments containing multiple byte characters can cause error 102.
695217 PDM > XML generation: length and precision of columns/domains defined in PDM are missing in corresponding simply types.

As examples,

- number(s,p) becomes xs:decimal, length and fraction digits are both empty.

- varchar(n) becomes xs:string and length is empty.

This also happens with columns not associated to any domain: length and precision have been lost.

695221 Upgrade fails when system tables are bound to a named cache.
695224 Allow "max resource granularity" 50% hard limit to be configurable
695283 Under some rare conditions, the message, "current process infected with signal 11", together with a stack trace involving the functions s__setup_tabsdes() and s_setuptables() or a 8201 error message may be reported when multiple processes are running stored procedures involving many tables.
695390 The message "current process infected with 11" in the module 'LeRun' together with a stack trace which includes the modules 'LeBulkOpOpen' and 'bulk_main' may be reported in the error log when running a bulk copy operation into a table defined with materialized computed columns involving expressions using system functions like CURRENT_BIGDATETIME(), GETDATE(), etc.
695552 Error 9275, "Could not locate the before image for the INSERT log record at (<page_number>,<row_number>).", may be reported by the RepAgent thread when a table that has

compressed rows is marked for replication, resulting in the RepAgent thread terminating itself.

695556 DBISQL needs user guide/reference manual
695557 Allow a nondefault sql.ini location to be specified in dbisql
695592 To document syslogins.audflags
695614 If the old RUN_<server> file has multiple -T arguments, sqlupgrade[res] only copies the last -T argument to the new RUN_<server> file.
695655 The 420 message, "The TEXT, IMAGE and UNITEXT datatypes cannot be used in an ORDER BY clause or in the select list of a query in a UNION statement.", may be reported when selecting a TEXT column from a proxy table in a UNION ALL query.
695738 For the schedules running over midnight, Job Scheduler sometimes misses execution of first valid schedule job and sometimes executes scheduled job on invalid schedules time.
695763 ASE running on Windows platform may exit with no message, stack trace or other indication in the error log when stack limits are exceeded.
695852 A spelling error "sp_temodb" is found in P&T: Physical Database Tuning. It should be sp_tempdb.
695917 Instrumentation: Under heavy i/o load on HPIA64 platform, ASE may report infected with signal 11 followed by a stack trace with iocRunController() and basis_dpoll() on the stack.
695923 During an upgrade from ASE 15.5 to ASE 15.7, an error may occur on upgrade step [ID 246]: clear unused columns (table sysindexes). This is followed by a storage access violation with a stacktrace involving the modules 'upgd__do_clear_columns', 'collocate' and 'col_find_default'.
695927 The values of the ExclusiveLockWaitTime, SharedLockWaitTime and UpdateLockWaitTime columns in the monOpenObjectActivity MDA table are not updated when queries are blocked by locks.
695937 The request requires the function base index column not to get mapped over on remote site.
696006 The message, "current process infected with signal 11" in the function 'pthread_mutex_lock', together with a stack trace involving the function 'os_get_prev_stk_desc' may be reported in the errorlog under heavy loads.
696020 32-bit GNU C Libraries package (glibc-2.xx-x.xx.el6.i686.rpm) also needs to be installed before installing ASE 15.7 64-bit to a Redhat Enterprise Linux 6.x x86_64.
696067 ASE running on IBM AIX platform stack traces with exception code 4 in iocPoll+0x54().
696150 When changing the replication status of a table, error 7941 may be reported when processing a table whose owner is not the current user or the dbo.
696227 In-place upgrade from older versions of ASE to ASE 15.7 may fail because the new ASE fails to start with error "The configured value '4096' for parameter 'kernel resource memory' is too low.". This occurs when ASE is configured with large "number of user connections" and "open indexes".
696250 When executing the stored procedure, sp_reptostandby, the message warning that the execution can take a long time is not returned to the user immediately.
696290 When a partitioned table has a local index and a query is used with a unbounded predicate and an order by clause that matches the key of the index, the query plan still uses a merge union all operator to preserve the sort ordering.
696320 When the Job Scheduler is setup on a server whose master database is replicated, the replication of the DDL command executed on the primary ASE by the JS task to set the password of the 'jstask' user fails due to missing credentials in the LTL sent by RepAgent to Replication Server.
696325 Remote Server crashes when local server uses 'cis packet size' with different value from DEFAULT
696329 join order ignored from PLAN clause
696416 The DROP THREAD POOL command may lead to multiple stack traces, signals and timeslice errors.
696440 The Backup Server error, "The 'write' call failed for database/archive device while working on stripe device '<archive name>' with error number 22", may be raised if the trace flag 256 is used to enable DIRECT_IO on archive files and the dump is compressed.
696470 In rare circumstances the message "Infected with 11" together with modules like senderror(),send_msg(), tdsrecv_errorhdl() followed by spid termination may occur when set statistics time is enabled with a create proc failed with syntax error.
696493 The services key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SybaseUAService

is missing in winx64 for 15.5 esd #5 and 15.7 GA.

696515 The signal 11 together with a stack trace which includes the modules 'inserttext' may be reported in the error log when a LOB column with NULL value is updated to itself with replication mode.
696543 sp_who may show a spid continuing to run (as opposed to sleeping) after KILL is issued. DBCC STACKTRACE(spid) shows module LeSortInputStream.
696587 In rare circumstances, a 644 error, "Index row entry for data row id (<pg>, <row>) is missing from index page <pg> of index id of table 'sysstatistics' in database '<db>'", may be reported during the load of an 12.5 database in a 15.7 dataserver.
696636 The message "current process infected with 11" together with a stack trace which includes the module 'omniCursorsInUse' may be reported in the errorlog when executing an UPDATE proxy table command in a cursor operation.
696642 The message, "current process infected with 11", together with a stack trace which includes the module 'ulreleasespinlock' may be reported in the ASE errorlog when the remote server is shut down abruptly using 'shutdown with nowait' when a transactional query is in progress.
696649 'drop view' inside stored proc does not replicate when proc is marked for replication.
696669 3916 error when running a stored proc after ALTERing a table
696676 When a query with IN list chooses a special OR strategy, the query plan still shows a RESTRICT operator which is superfluous and can be quite expensive up to 35%
696728 DBISQL Feature Request: OEM.ini option to disable DBISQL 'Query Editor' (i.e. grey out the [Tools -> Edit Query] feature).
696737 ASE/CIS : If "strict dtm enforcement" is enabled, then the first time an RPC is executed on a remote ASE after it has been killed (or diconnected) and then restored will result in error 7223: "Cannot read from site '<local ASE>'". No error occurs if "strict dtm enforcement" is disabled.
696804 Login account locked due to inactivity remains locked even after being unlocked by sp_locklogin.
696837 In a 2 node or greater ASE Cluster Edition setup, a database with a log segment threshold defined may result in incorrect values for unreserved data pages and no thresholds enabled. The database will report log is full and transactions will either suspend or abort, depending on the configuration paremeter "abort tran on log full" value. This can only occur when the database has multiple thresholds and the second threshold is crossed before the first one is completely handled.
696869 Errors 10850, 10860 and 10861 are wrongly reported as EX_USER, they should be EX_INFO.
696882 Running 'reorg rebuild' on tables in the dbcc checkstorage database 'dbccdb' will cause 'dbcc checkstorage()' to fail with error: Msg 9950, Level 17, State 2:

"Workspace 'def$scan$ws' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace."

696928 deadlock victim followed by a retry the sproc, occasionally hits a 267 error on #temp table created within the sproc with a select into.
696973 When migrating from Adaptive Server 15.5 or earlier to 15.7 using the sybmigrate utility and the 'quoted identifier enhancement' option is enabled on the target 15.7 server, an error message similar to "The specified object 'sp_migrate_db_lockprom' is not found in database 'testdb'." may be reported.
697003 When HA companion is dropped, sp_addexternlogin tries to acquire lock on companion server.

This lead to following error:

Could not acquire a lock within the specified wait period. DTM_SERVER level wait period=...

Cannot lock table 'master.dbo.rmt_ha_sysattributes'.

HA Internal Error: Cannot acquire locks for stored procedure 'sp_addexternlogin' on server ''. Retry later.

697042 The message, "current process infected with signal 11" in the function 'pthread_mutex_lock', together with a stack trace involving the function 'os_get_prev_stk_desc' may be reported in the errorlog under heavy loads.
697104 Needs a new proc/function to calculate and report the remaining column space for a table

for adding new columns in the table.

697124 When auditing is enabled for login events, then an incorrect audit message appears in the

audit trail for Extended Encrypted Password login protocol and for

Extended Plus Encrypted Password login protocol to describe the password encryption used.

697125 When using sp_downgrade to downgrade from 15.7 ESD#2 or later version of SDC server to 15.x SDC

server, prepare will fail and raise message "One or more databases still permit wide DOL rows."

on local system and global temporary databases.

697129 Supporting Lock Remastering for SAP ASE Cluster Edition. When the master assignment is set to affinity mode, the masters will gradually get re-allocated to the instances that initiates the lock convert requests, if 揺nable lock remastering� is set to 1(ON) in the configuration file. By default, 揺nable lock remastering� is set to 0 (OFF). It is not recommended to set 揺nable lock remastering� to 1 (ON) for badly partitioned cases.
697138 When network password encryption is used with the UTF8 character set, auditing is enabled for login events, and the password specified is longer than the ASE limit of 30 characters, then the client connection is closed instead of reporting the generic login failure error and no audit event with the cause of the failure is placed in the audit trail.
697148 DBISQL removes ASE-related preferences when closed without a connection to an ASE.
697163 ASE can incorrectly run multiple engines under development license
697172 FR: the ability to monitor the number of times tempdb session TLC is flushed independently of the ULC user log cache.
697303 While executing a repeating scheduledjob, the run_now job for same scheduledjob fails with its job state (jsh_state in js_history) set to B(Busy).
697307 For data caches using strict replacement policy, the run_replacement and config_replacement column values are incorrect in the syscacheinfo and syscachepoolinfo views.
697384 ASE may incur segmentation violation in the function uppwakeup under certain circumsnatnces when the number of engines is decreased via the command 'aleter thread pool'.
697522 In rare circumstances the message "Infected with 11" together with modules like ex_printmsg(), senderror() followed by spid termination may occur when SET STATISTICS TIME is enabled with a create proc referencing an existent temporary table and a particular Sybase supplied traceflag is enabled.
697533 ASE on Solaris platforms reports 694 or 823 errors along with messages like "kernel sddone: write error on virtual disk 3 block 145536", "kernel sddone: 16384 bytes passed, 0 returned on write for virt disk 3 block 145536" or "kernel sddone: read error on virtual disk 6 block 6812351", "kernel sddone: I/O error". There are no corresponding disk i/o error messages reported in the Operating System logs.
697542 ASE may raise error 8201, when number of open object, indexes, partition is insufficient.
697546 A 7153 error, "Premature end-of-message received while reading TEXT data from network. Host program may have stopped responding or may be sending TEXT data containing a partial character at the end.", may be reported in the error log during the replication of a table that has compressed TEXT/IMAGE data.
697573 ASE should impose ASE login policy when LDAPUA or PAM configured but not functional
697612 ASE running in Threaded kernel mode does not generate shared memory dump if CSMD condition is encountered by a non-engine thread.
697690 internal-only: new feature. Add command: shutdown instance <instancename> wait <time>
697751 For an LOB column which is defined both in-row and LOB compressed, if the column is marked as replicated, when replicating the LOB data from this LOB column, the data selected from the target table may be corrupt.
697800 Feature request for a non-blocking dbcc command to correct OAM pages, resolving errors such as "The requested update to the OAM for object ... would cause a negative page count"
697823 A 7975 error, "Page number <number> is out of range for this database master", will be reported when running DBCC TEXTALLOC on a table with TEXT column.
697828 High rprocmgr or rpmctrl spinlock contention may be observed under heavy workload of dynamic SQL or stored procedures.
697886 Improve optimization for single key self-referential integrity checks.

This feature is to streamline the query plan is specific scenarios where the attributes

and indices have specific properties in order to remove any unnecessary scans.

697890 The selectivity costings for referential integrity probes use the total density for

the join selectivity which can cause inefficient plan choices in circumstances involving

data skew.

This request is to look to improve the selectivity calculations to take advantage of any

histogram that might be usable on the child table.

697891 Feature request to extend the abstract plan API to allow the specification of

operators used for referential integrity checking during dml operations.

697908 UNION query (using MERGE or HASH UNION operators) against semantically partitioned table may fail to remove duplicates when executed in parallel mode with constant literal search arguments for predicates on each side of the union operator.
698059 Multiple failed connection attempts may result in memory related stacktraces in Ct-library and hang up the server completely. This is resolved by OCS CR 585954 (fixed in OCS 15.5 GA onwards).
698063 When an INSERT query attempts to insert an explicit value for a TIMESTAMP column a warning

will be reported, but query execution continues. If the explicit value for the TIMESTAMP

column is the result of evaluating an expression, and the query plan for the INSERT is

re-executed (i.e. because the statement cache and literal auto parameterization are

enabled or because the INSERT query is part of a stored procedure), memory corruption may

occur, leading to various stack traces.

698066 Sybmigrate uses one worker process per partition for partitioned tables is unable to migrate tables with more than 255 partitions as ASE has a hard limit for "max parallel degree". Sybmigrate raises a message suggesting configuration to an unsupported value: "Attention: Configuration check failed for migration of path.... The config parameter 'max parallel degree' should be configured to a minimum value '[value > 255]'" on the source server. Workaround is to repartition to fewer than 256 partitions prior to migration.
698070 Feature request to increase or eliminate the current hard limit of 255 on "max parallel degree".
698083 Installer fails to optimize ASE if user chooses to configure an 16k page size ASE.
698089 A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database '%.*s' (id %d)" may be reported under some circumstances when Adaptive Server has been booted with trace flag 3608, shutdown after some operations and then restarted in normal mode.
698105 Replication Agent may incorrectly send "remove table" to Replication Server when a stored procedure is removed from the schema cache.
698134 In some rare scenarios, procedure cache memory tracking data structures may get accessed after they are freed to global memory queue. This may lead to procedure cache memory corruption.
698209 Permission is denied when a procedure is executed as a RPC event not as a LANGUAGE event.
698315 The message "current process infected with 11" in the module 'bufpindirty' together with a stack trace which includes the modules 'xact__rollbackxact' and 's_execute' may be reported in the error log if a SELECT INTO statement involving a big number of tables (more than 96) is aborted with a 226 error, "SELECT INTO command not allowed within multi-statement transaction". If after that a ROLLBACK TRAN is executed by the same session a 6203 error "Unable to do cleanup for the killed process; received Msg ..." may also be reported in the error log.
698331 The message "current process infected with 11" in the module '_memcpy' together

with a stack trace which includes the modules 'AnyDataType::AnyConvertType',

'EmbedDataSet::embedConvertType' and 'OptBlock::OptDoPredElim' may be reported

in the error log when a UNION query is run with a parameterized WHERE clause

on a semantically partitioned table.

698363 Customer may hit error 257 on sp_downgrade while running installmaster.
698381 In ASE Cluster Edition, changing a database from a non mixed-log-and-data to mixed-log-and-data may invalidate an internal assumption and server may exhibit unknown issues.
698388 In rare circumstances, the message "current process infected with 11" together with a stack trace which includes the module 'jvmh_utl_printn' may be reported in the error log when ASE attempts to bootstrap the COTS JVM. This will result in Java operations being impossible to execute.
698393 dog bug:ASE Cluster Edition 15.5 Install documentation contradiction.
698494 After DBISQL receives an out of memory error when retrieving the rows of a large resultset, it fails to cancel the underlying query. Instead, it allows the query to run to completion and hold locks and other ASE resources for the duration.
698506 Signal 11 may be seen in function yyparse() and the spid terminated after having received

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

within begin..end block.

698657 The error 'Invalid RPC sequence at RPC as_cmd' may be reported by the Backup Server when a dump is attempted using a remote backup server and the local interfaces name is different from the remote backup server start-up name.
698692 After loading a dump from ASE version 15.5 or lower into a ASE version 15.7 server, when the server is first onlined, a signal 11 may be encountered followed by a stacktrace involving the modules 'ptnc_get_ptncond', 'ptnc_fill_ptnvals' and 'ind_ides_init'.
698873 When using the binary overlay upgrade method, a polite shutdown (rather than with nowait) should be used both initially and once the upgrade has completed before putting the upgraded server into service.
698897 New Feature Request to confirm the progress of long running queries.
698913 SELECT list and GROUP BY clause containing a CASE expression with/without variables/parameters may produce inconsistent results.
699094 In ASE Cluster Edition, if a node crashes in the middle of DROP DATABASE, a signal 10 may be reported when the crashed node re-joins the cluster.
699115 A 9830 error, "Compression version 0 is invalid for table 'Invalid pointer param number 3, pointer value 0x11' (ID <tblID>), database <dbName> while compressing page <pageid>.", may be reported when doing a deferred INSERT into a table having page compression enabled.
699211 The 'no_DBISQL' variable is missing in ASEIP.bat
699381 The error message, "symbol _port_dispatch: referenced symbol not found", may be reported on Solaris 11 platforms. The '_port_dispatch' function call is no longer supported on Solaris 11 and is replaced by 'port_send'.
699429 In process mode, ASE may not accept new connections and "ncheck: select, Bad file descriptor" messages fill up errorlog after stopping/restarting listeners.
699485 ALTER TABLE MOVE PARTITION can fail if the destination segment does not have enough space. However the transaction does not get rollback successfully. The SYSPARTITION update does not get rollback.
699534 Instrumentation: ASE reports a timeslice error and shared memory dump for the error shows a

circular "Cancel Queue" leading to the timeslice error.

699592 Creating a replication index, using sp_setreptable, sp_reptostandby or ALTER TABLE, on an in-row LOB column whose maximum in-row length is larger than the maximum allowable size for an index fails with error 1903.
699665 Error 1526 occurs due to using estimated sort buffers for the wrong cache if the login is not binded to the cache.
699818 ASE may encounter a SEGV after issuing DBCC STACKUSED and the task issuing DBCC STACKUSED may hang.
699826 Kerberos users can't dump imdb
699862 In ASE Cluster Edition, DROP DATABASE may transfer locks reserved for non-logical locks to logical lock pool causing server to run out of non-logical locks.
699976 DBISQL login with expired password can fail if invalid entries are present in the sql.ini
700034 A parameterized varchar column in the SELECT lists combined by a UNION (ALL) clause in the derived table may

return unexpected trailing spaces if statement cache is enabled.

700227 Reduce additional logging done on page compressed DMLs for replication support, trigger support, and online utilities support.
700231 This resolution addresses an issue which prevented the SCC LDAP login module from handling ecrypted passwords
700292 A cross-platform load may fail with a timeslice error with function lddb__unscr_phys_pages on the stack, due to the dump containing unallocated pages containing garbage values. As a possible workaround, try executing sp_dumpoptimize 'archive_space = minimum' to include only allocated pages in the dump, then dump and load the database again.
700356 In diagserver, the message "current process infected with signal 11" together with a stack trace which includes the modules "mda__read_lock_table" may be reported in errorlog when the monLock MDA table is queried.
700361 Under certain circumstances, in ASE Cluster Edition, CREATE DATABASE immediately following a DROP DATABASE may hang with messages in the error log indicating failure to reclaim active locks.
700379 Shared locks, which are blocked by demand lock on an earlier lock request, cannot be requeued after the blocking process is killed.
700382 Shared locks, which are blocked by a demand lock on an earlier lock request, cannot be requeued after the blocking process is killed.
700388 sp_helpthread shows a value of 0 for TargetSize in 15.7 ESD1 SMP.
700404 Optcriteria 619756 (enabled in optlevels ase1503esd4 or ase_current) could generate a SEGV and/or assertion failure. The stacktrace associated with the SEGV will typically include references to optimizer routines. In a diagserver, the following assertion (eqc->eqcIsUnrefed() || OptDuringGtuLocalGroupingPrimingHack()) may fail.
700405 In rare circumstances queries that contain HAVING clauses that contain aggregate functions may hit signal 11 or access violations referencing modules CgpPop::_CgpReplaceVars
700512 When a table has some compressed LOB columns and is marked as replicated, slow BCP'ing data into this table will hit 7105 error and stack trace.
700602 Feature request to enhance the pssinfo() function so it can return the spid, CMD, and various status bitmap fields.
700640 In Threaded kernel mode, if an ASE task which is doing remote I/O is killed more than once, a

SIGSEGV followed by a stack trace that includes the module np__conn_doconnect() may occur and the dataserver then crashes.

700645 FR: create some user friendly canned reports in SCC
700652 In rare circumstances, a signal 11 may be reported in the errorlog with a stack trace involving the sort module if a reformatting query plan is used.
700762 In scenarios where the return value of a user-defined function may be null and it

is evaluated against a constant under 'set ansinull off' (default behaviour)

it is possible for behaviour to return to legacy behaviour seen prior to version

15.0.2 ESD#5.

700765 The behaviour described in the T-SQL Users Guide with regards to system-generated

NULL behaviour under ansinull off (default):-

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/sqlug94.htm

is no longer applicable since 15.0.2 ESD#5, we need to update the documentation

700777 When increasing the parameter 'number of disk tasks' on ASE on the IBM AIX platform, a stack trace and/or error 823 may be reported and the server becomes unresponsive.
700877 ASE on Linux platform cannot start second or subsequent disk controller threads.
700895 Request to document "OAM count threshold" and its relevance for checkstorage:-

The 'OAM count threshold' respresents the percentage by which the discrepancy between

between the actual row count and the row count as reported by the OAM pages can vary

before checkstorage will raise error 100025 - 'row count error'.

Under normal circumstances it is safe to leave this at the default value of 2%.

701065 In rare circumstances, a 2601 error, "Attempt to insert duplicate key row in object 'syspartitions' with unique index 'ncsyspartitions'", may be reported when creating or partitioning a table, some time after the creation of a table within the database was recovered (either after an impolite shutdown, or by LOAD DATABASE or LOAD TRAN).
701083 The error message, "Heap memory not freed", is printed in the error log during character encoding compression.
701154 The message, "timeslice -501, current process infected at 0x<address>", in the module 'cm_writelogdes_upto_sequence' together with a stack trace which includes the modules

'cmcc__wri_bcmt_proc' and 'bufwritedes_log' may be reported in the error log when ASE flushes a syslogs page on disk while downgrading the physical lock held on this syslogs page in a 2 node Cluster Edition setup.

701256 Changing the default for configuration of "number of histogram steps"

would not have an effect on subsequent update statistics commands for

columns which already have statistics. The number of steps used by update

statistics should only be preserved from earlier commands if it was run

with the option "using <step> values".

The "with sampling = <value> percent" will be preserved in the same way

as a explicit "using <step> values" between update statistics commands.

That is, a preserved explicit value will become the default when

subsequent commands do not specify a value, ignoring the configured default.

701299 Implement variable network packet size for better performance.
701310 ASE does not support the NOLOCK hint, but does not raise a warning or syntax error when it is used.
701471 After upgrading to ASE 15.7, DDLGEN may generate incomplete "lob_compression=" clauses

in 'create table' DDLs.

701512 This problem happens in ASEMAP 3.2.6 when object permission is granted to a role or a group in Table view. The Adaptive Server Enterprise does not allow granting object permission with with-grant option to a role or a group. It is corrected in ASEMAP 3.2.7.
701575 The full logging for alter table feature also supports alter table partition command.

But this feature does not support alter table lock command.

701585 The SCC server that hosts the RMS will not start on a Sun Solaris computer when the language is set to Chinese. The workaround is to edit the script $SYBASE/SCC-3_2/bin/sccinstance. Change the line that sets the path from 'PATH=/usr/bin:/bin:/usr/local/bin' to 'PATH=/usr/xpg4/bin:/usr/bin:/bin:/usr/local/bin'.
701608 Signal 11 in LeSarg::mapSarg is reported due to incorrect classification of Transitive Closure predicates, at optimization time.
701629 Adaptive Server Enterprise 15.7 > Performance and Tuning Series: Query Processing and Abstract Plans > Controlling Optimization > Viewing current optimizer settings

There is a reference to 'auto_template_stats'

This should read 'auto_temptable_stats'

701632 The ASE server is unable to online an additional engine in Process kernel mode if Kerberos is enabled. The engine online will fail with the message, "engine <engine_id>, os pid <os_pid> exited" reported in the error log.
701639 On Dell powerdedge servers with RHEL6, hostid does not work for the purpose of generating a license.
701688 If the server is configured using multibyte charset, READTEXT with 'using chars/characters' option from compressed TEXT/UNITEXT/IMAGE column may encounter a signal 11 followed by a stack trace that includes the module txt__position() and readtext().
701705 New monitors have been added to collect each engine resource's Engine Local Caches (ELC) performance.
701747 ASE Reference Manual incorrectly states that Regular Expressions are supported. Currently only wildcard patterns _, %, [], and [^] are supported.
701749 Executing sp_monitorconfig 'all' will display 'kernel resource memory' twice but fails to display

'compression info pool size' information.

701958 Feature request to have dumps made via the Backupserver API include all the default headers needed to allow them to be loaded without using the API.
702011 Permission information is missing in some system procedures and commands.
702014 Please add Permission information about 3 system procedures in Cluster environments.
702022 set option command of Interactive SQL Commands does not work as described in Reference Manual: Commands.
702031 DocBug : System Administration Guide 2 ( DOCUMENT ID: DC31644-01-1570-01 / P191)

DTM Option is included in base ASE license after ASE15.x.

702038 In ASE Cluster Edition, error 941 may be reported when executing sp_configure "current audit table".
702047 This is a new feature request to allow login triggers to set a session-level lock-wait limit.
702073 In situations whereby there may be existing in-memory identity information, it is possible for a insertion into a table with an identity column to produce a duplicate identity value after dump\load. This may be specific to a change in server-level 'identity grab size'.
702161 A 712 message, "There is insufficient heap memory to allocate <number_of_bytes> bytes. Please increase configuration parameter 'heap memory per user' or try again when there is less

activity on the system.", may be reported when creating an index on a table with a large number of partitions.

702162 When an insensitive cursor is declared over a result set that contains at least two LOB columns and

one of these columns is an in-row LOB with at least one result value actually stored in the row, a SIG BUS may be raised when the result set is FETCH. This error only occurs on platforms that require memory address alignment.

702220 sp_sysmon show confusing values for committed xacts per CPU unit in 15.7 in a low Engine

utilization ASE.

702240 Feature request for a housekeeper check for timestamp values increasing at an abnormally rapid rate.
702339 After upgrading to release 15.7 ldap logins fail. Initial attempt fell back to ase login. Next attempt received 'Server is unwilling to perform'.
702345 In ASE Cluster Edition, if create database reuses the dbid of a dropped database, it may hang due to blocking on some locks.
702355 sp_helprotect now displays owner name as part of the object name

column for objects like tables, database etc.

702362 In rare circumstances, the message "current process infected with signal 11" together with a stack trace may be reported when involving compressed tables.
702377 Doc bug: 3rd parameter "remaining" is not needed in the syntax of sp_listener in threaded mode.
702409 This feature request is to allow non-alphabetic first character for 'login name' (as

specified using 'create login') and to also switch 'login name' to a large identifier

(255 chars). It is also to allow the use of a period '.' in the login name.

702411 This request is to document login name restrictions under :-

Adaptive Server Enterprise 15.7 > Reference Manual: Commands > Create login

Parameters

login_name

specifies the name of the login account to be created. <It must start with an

alphabetic character and cannot exceed 30 characters in length.>

702482 sybmigrate: error needs to be changed to "config check failed, disable xact coordination
702532 In rare circumstances, ASE may shut down with the message, "Stack guardword corrupted" reported in the error log when running queries with LIKE clauses on LOB columns.
702549 Preupgrade may report an error that huge master device size is needed for upgrade to 15.7 ESD#2.
702653 When a primary key contains IDENTITY columns, INSERT INTO and SELECT statements may create bad LTL causing the RepServer to report the error message, "Incorrect syntax near the keyword FROM".

This is fixed via CR 674627.

702657 Doc CR: take out "do not modify" for "number of messages" error
702704 Feature request to have the preupgrade checks output a warning when the database timestamp is very high (it may be better to rebuild the database in this case than upgrade in place).
702725 In circumstances whereby the select list of an INSERT SELECT with ORDER BY does not include the 'order by' columns, it is possible that the optimizer will favor a non-matching index scan using an index with the order by column(s) as opposed to a more efficient plan using a matching index scan for one or more of the filter predicates. A new optcriteria cr702725 has been introduced for this change. Use "set cr702725 1" to turn on the change and "set cr702725 0" to turn it off.
702770 Dataserver might hit SIGSEGV in is_vpar() during startup on HP PA-RISC vPar.
702799 sp_recompile with statement cache enabled changes query results in 155x and 157
702816 A timeslice error followed by stack trace that contains the module 'adb__sync_dmap' may happen when trying to load a very large database into an archive database.
702896 Request to suppress informational message - "Failed to get ocm lock".
702907 In specific circumstances it is possible to receive a 2601 error on execution of a stored procedure. The issue is much more likely to happen with 'deferred name resolution' enabled. This can happen when a stored procedure has been initially created, then for the 'first' execution, multiple concurrent connections all run the procedure at the 'same'time. If running with 'deferred name resolution' enabled at create procedure time, the error is much more likely to occur.

It could also happen in circumstances where the query tree needs to be recreated from text

as in after the ASE is upgraded.

702968 This fix enables LDAP usernames with simplified Chinese characters to login to the SCC
703049 improve the space estimation in Sybmigrate.
703063 Update statistics with sampling can fail to correctly write the sampling percent

to sysstatistics, optdiag\sp_showoptstats will report zero.

This is a diagnostic issue only, sampling is performed during the update statistics

command.

703122 The message, "current process infected with signal 11", together with a stack trace involving the functions keclearown(), uppopaffinity() and threadpool__update() may be reported when number of threads in a thread pool is changed, for example from 2 to 1 via "alter thread pool <thread pool> with thread count = 1" under ASE threaded mode.
703123 Predicates that contain more than 128 or-terms in a disjunct may not

be optimized using a general-or strategy. In cases where such a general-or

strategy provides the only efficient search strategy, query performance

could be poor.

703134 ASE provides inaccurate estimation for 'kernel resource memory' configuration parameter.
703213 The error, "Page Verification Error: Page mismatch. Page # contains # in page header", may be reported in the Backup Server log file if the database has two fragments on a database device where first logical page of the first fragment is smaller than the first logical page of the second but the first virtual page number of the second fragment is smaller than the first virtual page of the second.
703265 view with column created using substring and charset is utf8 converts columns incorrectly on linux
703285 ASE logs the message "Expected object passed to utGetOsId is not of type thread" and "Expected object passed to utGetThid is not of type thread" repeatedly.
703375 Dumping on Windows using 'WITH COMPRESSION' clause can perform worse that the same command using the API library "compress::".
703377 ASE may fail to find a License when running under a virtual machine
703424 This fix addresses an issue which prevented the automatic repository purge processing from completing
703426 In rare circumstances, the Invalid column length error 290024 may be raised

when "capture missings statistics" is ON and executing a LWP and doing

compilation optimization.

703427 When the database is large, user viewing the ASE Monitor Databases screen on the large database such as selecting the large database on the top of the screen may impact viewing other ASE Monitor screen and may also block scheduled collection jobs. This fix solves the problems.
703437 ASE reports message "kshpnetctlrWaitForCompletion : received error 8 for psn ..." when a connection gets killed abruptly.
703607 Backup Server is enhanced to provide Multithread support needed for Tivoli Storage Manager options such as LAN-FREE. This support is off by default. It can be turned on by using the new 朌8192 option during Backup Server startup. For example: ${BACKUPSERVER} -SSYB_BACKUP -I$SYBASE/interfaces -M${SYBMULTBUF} -D8192&
703655 This resolution fixes an incorrect default start time within the create collection job wizard
703685 The message, "current process infected with signal 11", together with a stack trace involving the

functions hk__compress_page() and pg_modify_spacebits() may be reported durng HOUSEKEEPER garbage collection.

703796 In installations with large number of user connections, the message "current process infected with signal 11" together with a stack trace involving the function sybcsi_default_entropy() may be reported from the housekeeper chores process or the job scheduler process.
703897 Signal 11 in LeHashOp::LeOpSaveIOStats
703905 A 3146 error, "ASE cannot load this database dump because the version in the dump is newer than

the version in the database...", may be reported when a database dump from a Cluster Edition

server is loaded in a newer SMP server.

703919 DROP proxy table in a database marked for replication with "sp_reptostandby, 'ALL'" may fail.
703947 A database that is created without "full logging" (for example, "full logging for alter table") may incorrectly inherit this property from a database that has been dropped which had the full logging mode set prior to it being dropped. As a result, the volume of logging might be more than expected.
703975 LIKE pattern match issue with square brackets
703992 When running TF 299 and multiple tempdbs it is possible for a query execution referencing

a temporary table to hit an error 225

Msg 225, Level 16, State 3:

Server 'SOGDEN157', Line 1:

Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

This is timing specific and can only occur during parallel execution of a statement

referencing the same temp table name.

704012 A 706 message, "Process <pid> tried to remove PROC_HDR <prochdr address> that it does not hold in Pss.", may be reported in the errorlog when either the 'streamlined dynamic SQL' or 'enable functionality group' configuration options is enabled and recompilation occurs while a dynamic SQL query is being executed and an exception occurs during the recompilation.
704029 In rare circumstances, the message, "current process infected with signal 11", together with a stack trace involving the functions collocate(), run() and s_execute() may be reported when executing a simple INSERT query with compatibility_mode enabled.
704038 Customer would like to request that an enhancement be made to the resource limits

feature on ASE. Specifically, he would like to be able to configure resource limits

on the number of locks similar to number of rows. Often there is a situation

where a process is unable to escalate to a table level lock on an object due to

other processes having lock(s) on the same object. Though this is more likely

on a DOL (especially Datarows lockscheme) table, it is possible on very large

Allpages lockscheme tables also.

704085 When multiple encrypted columns with the decrypt_default attribute are

selected through a view, ASE may incorrectly return decrypted data on

some of the columns.

704095 Queries with OUTER JOIN on encrypted columns may not return expected rows from the outer table if the ON clause is on columns with decrypt_defaults and there is a where clause.
704477 In rare circumstances, the message "current process infected with signal 11" together with a stack trace that include the modules collocate(),LeSubst() and getnext() may be reported when compressed tables are involved in the query.
704481 A signal 11 may happen in CgpPop::CgpInplaceUpdateVars() for an INSERT...SELECT...ORDERBY query when the insertion involves RI constraint checking and one of the ORDER BY columns has a different datatype from its destination column (so that an implicit convert will be added) or the ORDER BY column is an expression.
704487 In rare circumstances, the message, "Could not locate the before image for the INSERT log record", may be reported in the error log when replication is on the page-compressed table.
704582 Add a configuration option 'enable ISM' to use Intimate Shared Memory (ISM) as follows, Boot with ISM if available else regular shared memory, only with ISM, only with regular shared memory.
704624 Large number of pages used on procedure cache when TF 450 is enabled.
704641 A 5851 error, "Configuration Error: Configuration file <config_filename> has an unknown format on line <line_num>.", may be reported during ASE reboot.
704671 While executing large amount of dynamically prepared statements we could find DBT_SPIN as still contentious.
704679 DISK REFIT fails to restore 'durability' and 'crdate' column information in sysdatabases system table.
704691 sp_downgrade prepare with 1502/15.0.2 as the @toversion reports "'15.0.2.0' is not a valid downgrade version" message.
704699 Found a wrong maximum size of a database device (disk partition) in Adaptive Server Enterprise 15.7 Configuration Guide for UNIX.
704724 Remote Backup Server name is now allowed to be specified as 'hostname:portnumber'.
704739 On AIX plattform, "<num> suspect conditions" may be reported by DBCC CHECKSTORAGE and Fault 100018, 100019 and 100015 may be reported by sp_dbcc_faultreport.
704744 Log an informational message in the error log when memory allocation with Linux 'hugepages' succeeds. Add a configuration option 'enable HugePages' to control allocation as follows, with HugePages if available else regular pages, only with HugePages and fail if not available, only with Regular Pages.
704899 Add new configuration option 'enable HugePages' for Linux to control whether to boot ASE with HugePages and 'enable ISM' for Solaris to control whether to boot ASE with ISM
704902 To improve Error Msg 1509 to have more details include object id, index id,database id,login name and appname
704934 The message, "current process infected with signal 11", together with a stack trace involving the function norm3_get_node_sqlt() may be reported during DISTINCT operator code generation when a DISTINCT view/derived table is participating in an expression EQUIJOIN.
705024 The host-id for unserved shared-capacity (sysamcap MACHINE) licenses for VMware ESX virtual machines may have changed. Existing licenses will continue to work but you will need to Check-in and re-generate the licenses at SPDC for any new VMs added after the SYBASE_SAM_CAPACITY environment variable was previously generated. The host-id reported by 'sysamcap MACHINE' should be checked against the HOSTID field in the unserved license to determine whether the license needs to be re-generated.
705093 Extensions to the Remote Backup Server name feature allowing to be specified

as 'hostname:portnumber'.

705107 On a symbolic binary, the datachange() built-in may hit a signal 11 during the cleanup of the execution after hitting 1105 error due to space crunch in tempdb. On an FBO binary, it may execute unnecessary code during the cleanup.
705129 290024 invalid column length in collocate reported during execution
705160 DOC CR : The default value of max network packet size is 512 in System Administration Guide. But it should be 2048.
705192 DBISQL on Windows fails to start if VM_ARGUMENTS property value in DBISQL.ini is longer than 255 characters.
705198 When generating ddl for proxy tables using ddlgen, it will unnecessarily generate create

index ddl for the proxy table.

This may fail when running the script created by ddlgen as those indices will

implicitly be added to the proxy table index definitions from the source table after the

proxy table is created.

705260 query hits signal 11, 6 in Nsql::nsExecute and gsignal when the where clause is included.

zombie spid is left behind

705261 The srvbuild/srvbuildres (UNIX) and syconfig.exe/sybatch.exe (Windows) utilities now require user to specify the System Administrator password when configuring a new ASE.
705267 nonfatal errors during ASE15.7ESD#1 install on a RHEL6.2 VM
705283 Doc: Request to add notes about ASE starting with trace flags.

Start Adaptive Server with a trace flag only when instructed to do so in this manual or as directed by Sybase Technical Support or a Cover letter. Commands or stored procedures which are not directed under these flags at any other time or way may create an error or a stack trace or other problems.

Especially trace flags 3607 and 3608 are used when a special recovery procedure is performed. Do not attempt a normal shutdown after using trace flags 3607 or 3608. Always use shutdown with nowait in these cases.

705331 SySAM properties file is truncated to zero bytes in situations such as the disk filling up.
705332 Feature request to allow customer to create their own unicode sort orders.
705335 Bring sort order id 55 'espdict' into line with modern Spanish
705379 When the master database is setup for replication, the command 'ALTER ROLE... LOCK' succeeds but is not replicated and an error 11314 is reported.
705385 There is no entry for entering backend server SA user password for creating a new cluster.
705390 number of checkpoint tasks has to be set to default or 1 before upgrade, or it will fail, and require manually editing the config file before restarting the upgrade process. This should be handled in the preupgrade.
705451 DOC CR : The Description column of "action" of sysprotects in Reference Manual: Tables does not have

Create Function (280).

705470 When execution of a local java method (classes loaded into ASE, so pci and java enabled)

calls a web service (which uses java.xml.ws package) it is possible for the execution to

hit the following error:-

Unhandled Java Exception:

javax.xml.ws.WebServiceException: class <class> do not have a property of the name {....}<parameter>

at com.sun.xml.internal.ws.client.sei.BodyBuilder$DocLit.<init>(Unknown Source)

at com.sun.xml.internal.ws.client.sei.SEIMethodHandler.<init>(Unknown Source)

at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.<init>(Unknown Source)

at com.sun.xml.inte.

705516 Feature request to improve sp_configure to perform kernel resource memory consistancy checks.
705520 In very specific timing related circumstances, the message, "current process infected with signal 11", together with a stack trace involving the function keclearown() may be reported when modifying threadpool information. The server will be left unreachable (or down) and will need to receive a kill -9 in order to restart.
705545 DBISQL/ASE Set command has been removed. The related documentation was not updated.
705677 The message, "current process infected with signal 11", together with a stack trace involving the functions stat_mergestats_all(), sort() and cri_ptn_index() may be reported when a parallel CREATE INDEX specifies that 0 histogram steps should be used, effectively disabling histogram creation, and multi-attribute density creation.
705723 In some ASE customer scenarios, PDES chain spinlocks are found to contain high contention.
705733 In some situations, a signal 11 may occur in lock__get_heldlocknum if a deadlock or lock timeout event happens.
705891 While running ASE, the time a task waits on a lock is incorrectly calculated by adding a overlapped time.
706391 RepAgent hang and stacktraces repeatedly.
706483 Can insert null image values into not null image columns via INSERT SELECT
706501 The ASE default task stack space is too low for default execution coverage.
706543 sybmigrate and DDLGen fail when there is "&" in the object name
706581 The message, "current process infected with signal 11", together with a stack trace involving the function prot_view_decdef_cols() may be reported with a complex query when access is made through a VIEW and the accessed columns are encrypted with decrypt_default.
706647 Shutdown ASE when IO controller SEGV. wish is unrecoverable.
706653 ASE should restart IO controller if they have problem.
706690 ASE kernel message stating SySAM: Failed to connect to SMTP host [ip address]on port [port]" may be raised when SySam is configured for email notification but the SMTP host is not up. Either start the SMTP host or use sp_lmconfig to change to a different host or disable email notifications.
706764 Feature request to expand the sp_dbextend functionality to include expansion onto devices

not currently allocated to the database.

706769 During shutdown of Backup Server isuing 'shutdown SYB_BACKUP' from ASE, it is possible

for the backupserver binary to core dump due to a SEGV in srv__q_defevent()

706777 The message text for error 9262 has been changed to report the database name and ID values

such as "A Rep Agent Thread for database '<dbname>' (dbid=<value>) is already running".

706799 Memory allocation failures appear in the ASE errorlog when the network memory pool is exhausted or when fragmentation of memory occurs due to memory that is not freed.
706842 When using tables with 64 or more partitions and parallelism is enabled with max parallel degree more than 64, ASE will stack trace in bitstr::test() method.
706866 When a DUMP TRAN is done on a non-existent database, the expected 911 error, "Attempt to locate entry in sysdatabases for database '<database name>' by name failed - no entry found under that name. Make sure that name is entered properly.", is not reported.
706877 ASE does not raise an error when an rpc-based proxy table is passed an invalid parameter such as a value larger than MAXINT to an INT parameter. No error is raised because execution of the stored procedure is short-circuited.
706937 ASE threaded mode reports Msg 15025 "sp_listener: parameter 2 specifies an invalid network protocol tli" when sp_listener stored procedure specifies a tli address like "sp_listener start,'tli:<host>:<port>' as TLI is not supported in threaded kernel mode.
707065 In rare situations, a 1514 error might occur while creating the index with a reserved page gap.
707149 The message, "The Begin Timestamp=<ts1> of the completing transaction in database <dbid> is lower than the Database Commit Timestamp=<ts2>", may be printed in the error log together with a stack trace that contains the modules dbts_commits_remxdes() and xact_end_session() when chained transactions are used, and ASE is started with the diagserver binary.
707260 In rare circumstances, when replicating compressed LOB data, the replicate ASE may raise error 7153, and the Replication Server may abort the connection.
707304 Filter columns within the SCC Alert Monitor now match the selected/display columns within the main monitor panel
707351 When running UPDATE INDEX STATISTICS or UPDATE STATISTICS for a specific column, the leaf level of an index is scanned to get the values of any non-leading columns (if available). It is possible for ASE not to select the most efficient index to do this operation if the column exists as a non-leading column in more than one index.
707411 In rare cases with tables having non-unique indexes with huge duplicates, the index might end up having lot of near empty pages.
707548 identity insert error - Incorrect syntax near the keyword 'Log off'
707555 When using ASE Multiple Path Replication with distribution per connection and while replicating LOB data, the Replication Server DSI may shut down itself with either error 5139, "DSI encountered an error when processing an rs_writetext command for object '<Object Name>', text column '<Column Name>'. This rs_writetext command is not marked as the first chunk for the column. However, there is no previous rs_writetext command that is marked as the first text chunk." or error 5147, "DSI encountered an error when trying to do writetext operation for object '<Object Name>', column '<Column Name>'. The data row that the writetext command is associated with is missing.". Under rare circumstances the Replication Server may also shut down itself.
707783 When using traceflag 7738 to enable statement cache user id sharing, sometimes an error 622 (Opentable was passed a varno of ...) may be raised if compatibility mode is also enabled.
707886 Non clustered Index for DOL table can be created with with online option.
707969 A select having a SQLJ function to convert a column of data fails with messages 10707, 10745 if there are many rows in the select.
708020 On non-binary sort order servers (version 15.0 and higher)

When a query involves an equi-join between two char columns

and there exists only an equivalence between the values ('a'='A' for example), it is

possible for a query to return unexpected results if a built-in function (or comparable

operator) in the predicate is reliant on the specific value from one side of the join.

Examples of this may be the compare() function when using a binary collation as the 3rd

argument or conversion of the column value in order to do a binary comparison.

708033 Altering a Load Script generates ReferenceError errors in system.log when run
708044 sybdiag shows "14000 - Interfaces Load Error" if non-default interface file is specified with -I option in the command line.
708058 Extend sp_helpconfig to support a new "estimate" clause to estimate the size of 'compression info pool size' config option based on other config parameters, or user-overrides.
708071 In ASE Cluster Edition during instance failover recovery, the checkpoint process may be blocked by the threshold manager process that is doing free space accounting recovery for a large database that has the "trunc log on chkpt" database option turned on.
708089 The Auto Refresh checkbox is located on the bottom right of the status bar in ASE Monitor window. When "Auto Refresh" is unselected, any change of state of the ASE Monitor window such as clicking the maximize/minimize icon of the window will turn the "Auto Refresh" back to selected. This checkin for ASEMAP 3.2.7 corrects this unexpected behavior of the Auto Refresh such that it will not change state from maximize/minimize operation.
708096 This resolution addresses accessibility problems within the SCC UI which prevented keyboard access
708100 This fix addresses an issue where the screen reader did not work in some cases
708134 A 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.", may be reported when replicating in-row LOB data that is marked as "replicate_if_changed" and the UPDATE statement does not modify the in-row LOB data.
708143 asehostname() can return null or truncated values when the hostname is greater than 30 characters.
708240 For RTC (run to completion) threads such as syb_system_pool & syb_blocking_pool, values from monThread for BusyTicks shows it is alway busy. It is corrected to reflect work done.
708273 For an update query with instead of trigger, if it updates numeric column, it could return wrong result if literal autoparam configuration parameter is turned on.
708356 Invoking the reog rebuild command on a table with a bracketed identifiers will generate a warning claimin an Abstract Plan (AP) syntax error.
708388 Feature request to include optimization time (suggested as OptimizeTime)

for currently executing as well as previously executed statements in the relevant

MDA tables

monCachedProcedures

monProcessStatement

monProcessProcedures

monCachedStatement

monSysStatement

708392 The attempt to alter a database in the Devices tab of the ASEMAP Admin Console Database Property Sheet to increase the size by more than 1000 MB will fail with "Incorrect syntax" error. This problem is fixed in ASEMAP 3.2.7.
708472 DBCC CHECKALLOC can't fix fault 100007 reported by checkstorage
708502 ALTER TABLE <table name> split partition <partition name> into <partition values> or ALTER TABLE <table name> move partition <partition name> to <seg name> will encounter 691 error when db option 'full logging fopr alter table' is enabled.
708519 When upgrading from a pre-15.7 ASE version that does not support compression, RepAgent ASE 15.7 incorrectly assumes that compression is on for uncompressed tables.
708527 The message, "Current process (0x<value>) infected with signal 11 (SIGSEGV)", in the module 'kbfalloc' together with a stack trace which includes the modules 'ra__process_xtext' and 'ra__process_txtblk' may be reported in the error log when replicating large, compressed TEXT columns.
708756 Non clustered Index for APL table can be created with with online option.
708798 In specific circumstances involving execution of a stored procedure under execute immediate in combination with additional statements it is possible for the following

error..

CT-LIBRARY error:

ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read

..to be observed when using isql or any other ct-lib client and the subsequent statement

(after the execute immediate) to not be executed. The issue only arises under very

specific circumstances when certain statements that are deferred for compilation at

runtime have to be compiled when under an execute immediate.

708821 Checktable and Checkdb report an error that "An invalid 'data row id' value was found in first text page of a text/image/unitext column." for replicated DOL tables that have text columns with values on forwarded rows. As a workaround, run REORG FORWARDED_ROWS to eliminate forwarded rows before running the DBCC check.
708830 sp_dump_history returns error 17152, version missing or invalid, when dump history file does not exist.
708876 When the user specifies for dump configurations a default directory for the dump stripes

with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when

generating the list of commands that are needed to create a target database with the same

layout as the source database.

708900 In rare circumstances, when a query involves join with many remote tables, a message "current process infected with 11" in the module 'sdes_hookup' together with a stack trace which includes the modules 'omni_remote_name' may be reported in the error log. The problem occurs when 'showplan' is on or 'plan text pipe active' is configured to 1.
708912 monCachedObject contents can vary depending on current database
708945 In rare circumstances, when replicating compressed IMAGE/UNITEXT LOB data, the replicate ASE may raise a 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end", and the Replication Server may abort the connection.
708946 doc bug: sp_downgrade procedure still states '1502' is not suppported. However, we do support it as of 15.7 esd #2.
709056 In ASE Monitoring screen for Data Cache, the Pool Information could catch numeric overflow under any of following conditions

1. the Size(MB) is over 99999.99 MB

2. the Usage(%) is over 99.99

This fix allows the Pool Information without causing numeric overflow

1. the Size(MB) up to 9999999.9 MB or 9999.9999 GB

2. the Usage(%) up to 9999.9

In addition, the Usage(%) in this fix corrects the value by a factor of logical page size of the server in KB (that is either 2,4,8 or 16).

709060 When creating a cluster or adding an instance, sybcluster cannot detect invalid device name immediately after it is entered.
709078 Under certain circumstances, the load of an archive database may fail with a timeslice error. The stack trace that is reported in the error log includes the module 'fm_item_by_index'.
709090 Release DBISQL 16 for ASE.
709184 Improve UTF-8 sort order 25 performance for well-formed UTF-8, under sp_configure parameter "enable permissive unicode".
709187 This resolution addresses a deadlock situation in the framework classloader during the startup of alert and messaging services
709211 Following an abnormal termination of ASE, the recovery analysis and redo passes can be unnecessarily long in recovering large databases that had a very large number of different pages flushed to disk since the last checkpoint prior to the termination.
709255 In some rare case, it could stacktrace when we print query execution info or final plan in XML.
709276 When an installation is created by ASE version 15.0.3 or before, then upgraded to 15.5, and then further upgraded to 15.7 or later, then if the upgraded server is downgraded back to 15.5, the booting of the 15.5 server may encounter a segmentation fault. This fault prevents recovery from completing.
709343 The table of convert() styles in Reference Manual Vol 1 is missing entries for new styles 36-40 that display microsecond granularity.
709371 The message, "timeslice <value>, current process infected at <value>", in the module 'io_submit' together with a stack trace which includes the module 'bufawrite' may be reported in the error log when ASE is started in threaded mode and while it is creating a large database.
709444 Sometimes a 619 error, "A deferred update was requested but the query is not one of INSERT, DELETE or UPDATE", may be reported while executing WRITETEXT command on an in-row LOB column.
709453 If an application passes an invalid TEXTPTR to different LOB-related T-SQL commands (e.g READTEXT, WRITETEXT, TEXTVALID, etc) for an IN-ROW LOB, sometimes the command may report fatal 605 or 625 errors.
709474 A new SpinlockSlotID column has been added to the monSpinlockActivity MDA table. This column provides a unique identifier for each spinlock in the current ASE server. This ID is not persistent across servers or restarts of the server.
709479 In the 15x manuals

Adaptive Server Enterprise 15.7 > System Administration Guide: Volume 2 > Checking Database

Consistency > Upgrading compiled objects with dbcc upgrade_object

This section advises that post successful upgrade the sysprocedures.version should read

12500, this is incorrect, after a successful upgrade it should read 15000 for any version

from 15.0 to 15.7.

709510 Enabling I/O fencing may result in "reservation conflict" messages in the system log.
709572 A 301402 error, "Backup Server: 3.14.2.4: Logical page <page_number> is not in the given database map.", may be reported by the Backup Server during the execution of LOAD WITH VERIFYONLY on a database whose size is bigger than 2147483647 pages in an ASE installation that uses page size greater than 2K page.
709646 ASE-UA Role Mapping (Roles Folder), UA Security Modules (Server Properties Agent page) and UA Attributes/Operations (Server details panels) are no longer supported due to upgrade to SCC 3.2.7.
709651 A number of different errors and stack traces might be seen in the error log in an ASE CE system after executing ONLINE DATABASE on one instance, having loaded one or more dump that were taken on an earlier version of Adaptive Server compared to that into which they are loaded, on another instance.
709721 When an in-row LOB column which has both data compression and LOB

compression properties defined has its schema changed by setting

the LOB compression property to not compressed, ASE following a SELECT

query execution may return incorrect results for this column for data

that was inserted into this column before the column schema change occured.

709754 It is possible for a spid to terminate and a stack trace to appear in the SAP ASE error log

containing the functions memset and bi__xml_query/bi_xmlextract.

This can happen under heavy usage when the session heap memory pool has become starved.

709770 A config parameter making the multiple user tempdbs recover before all user databases.
709778 Customer requesting the ability to view associated data in XML model structure.

The are looking for similar functionality as 'View Data' in the PDM model.

709805 In some case, downgrade could cause memory corruption issues and stacktrace.
709808 A config parameter making the multiple user tempdbs recover before all user databases.
709817 The EXECUTE command raises errors such as 11037 or 203 when passed a unichar or univarchar variable for a procedure name or char_variable.
709922 can 15.7 boot with 250G or more default data cache?
709947 Syntax is added to the UPDATE STATISTICS command to allow printing of progress messages while the command is running. The new syntax is UPDATE STATISTICS <tablename> ... with "print_progress"=<0|1>

where 0 = disable and 1 = enable. The default value is 0.

709951 Message "The %ldK memory pool of named cache %s (cache id %d, cachelet id %d) is configured too small for current demands (state %d). Transaction progress may cease or response time may increase." filled up errorlog. Please check tempdb_cache configuration to see if the buffer pool is too small for the value of parameter 'max buffers per lava operator', and check if the message is due to multiple sessions trying to use the same buffer pool.
709963 If a union view creator does not specify the owner of base views, it could get error msg 225 if the same base view name is created by an sa and the union view creator.
710043 Create cluster using sybcluster failed with message, "Unable to retrieve the environment variables to run the Sybase tools".
710048 A 1525 error, "Sort Failure. Rollforward of sort encountered sort descriptor timestamps out of sequence. Old timestamp in log: <old_ts>. New timestamp in log: <new_ts>. Timestamp in sort descriptor: <sort_ts>.", may be reported when loading a transaction dump that contains a CREATE INDEX command that was executed using parallel sort. ASE should have disallowed a transaction dump to be taken if it contains a parallel index creation.
710057 The timing and IO metrics in monCachedStatement for running queries were unchanged until the query completed. Four new columns have been added to provide intermediate updates. The new columns are called TotalLIO, TotalPIO, TotalCPUTime and TotalElapsedTime.
710125 rdesmgr_spinlock is hot, with lot of acquires and spins in some customer scenarios.
710240 Sybmon would report a signal 11 error when the quite command is executed on 32bit or 64bit windows platform.
710300 Deploy plugin raises an error but reports that it succeed
710328 In rare circumstances the server can be shutdown after an error in the module dbts_commits_remxdes() followed by a message 'The Begin Timestamp=<n> of the completing transaction in database # is lower than the Database Commit Timestamp=<n>'.
710333 The result set may not be correctly sorted in descending order when the SELECT statement has the ORDER BY DESC clause and the FOR BROWSE option.
710430 A histogram with a range cell at the very end of the histogram may have the weight of the lower bound of the cell incorrectly added to the last cell. Range cells by convention are exclusive of the lower bound of the cell. This may result in mis-estimates and poor query plans when predicates in queries reference the lower bound value. This is especially true if the lower bound has a high row count associated with it.
710495 On Linux platforms, monThreads.OSThreadID is sometimes reported as a negative number that does not match the OS reported thread ID.
710496 When Replication Agent is enabled to use the multipath distribution per connection model,

and if the option "ddl path for unbound objects" is set to "default", it is possible that DDL

commands are replicated to the incorrect path.

710536 Data may be corrupted during page compression if there is a compressed in-row LOB column in the table.
710575 Request to improve the accuracy of index creation time estimates from sp_estspace
710582 webservices FR: ASE Webservice support for WS-Security soap mechanism in 15.7x
710589 Column statistics histogram may be skewed in the last histogram step if the total sampling row count is greater than 2,147,483,647 when updating statistics.
710594 DBT_SPIN is hot when there are lot of queries or stored procedures that work across multiple databases.
710603 A 1163 error, "The space allocated to the sysgams table in database 'tempdb' (dbid = 2) must be at least 16 pages.", together with a stack trace which includes the modules 'pggam__srchonegampage', 'pg_allocate_syslogs' and 'crdb__logtrunc' may be reported at ASE startup if the system tempdb is bigger than 63GB and has dedicated log devices which are placed out of the 63GB range.
710683 Contrary to the documentation, trigger 'self_recursion' remains on even after the trigger with 'self_recursion' causes another trigger to file.
710693 For the jobs having repeat interval of one minute, if job creation time is less than starttime of job, second execution of the job is missed. In addition, for the jobs having repeat interval of one minute, if starttime is greater than or equal to endtime, alternate executions of the job are missed after midnight till endtime. Finally, for the jobs having the same startime and endtime with any repeat interval, the job starts executing before starttime if startdate is same as job creation date.
710754 When sort_resources is on, negative row count maybe be reported when executing CREATE INDEX, UPDATE INDEX STATISTICS or UPDATE ALL STATISTICS on table with more than 2147483647 rows.
710755 doc request: make the ebf coverletter for n-offs more specific
710843 While running a batch of ADD or DROP constraints out of which a few fail due to valid reasons, the subsequent ADD/DROP constraints may fail with the error 4956.
710847 The error messge, "Page Verification Error: Virtual page <page_num> in device <dev_num> is out of database range." may be reported in the Backup Server error log as a result of a LOAD DATABASE command.
711008 ASE becomes unresponsive, ASE's network controller thread loops consuming 100% of one cpu.
711082 This feature request is to modify the architecture of concrete identification (introduced

in version 12.0) to allow implicit permissions to be granted on an underlying object

used by a stored procedure (or equivalent) when the object is in a different database

and was created by a different login than that which created the stored procedure.

The logins used to create both stored procedure and object would be aliases to the same

equivalent user in each database.

The current behaviour is a documented restriction:-

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/BABHCJBA.htm?resultof=%22%63%6f%6e%63%72%65%74%65%22%20%22%63%6f%6e%63%72%65%74%22%20%22%69%64%65%6e%74%69%66%69%63%61%74%69%6f%6e%22%20%22%69%64%65%6e%74%69%66%22%20%22%63%72%6f%73%73%2d%64%61%74%61%62%61%73%65%22%20

711106 OPTDIAG and sp_showoptstats has been enhanced to support Precomputed Resultsets.
711156 This resolution fixes an issue with alert creation for IQ with logical servers where when the resource property alert page is refreshed after the alert is created, the alert may be displayed multiple times depending on the number of logical servers defined.
711168 In rare circumstances, when the ASE configuration parameter "disable varbinary truncation" is set to 1, a delete from a DOL table which has a unique index which has varbinary columns may hit a 644 error, "Index row entry for data row id (Pageid, Rowid) is missing from index page <page id> of index id <index id> of table <table name> in database <db name>. Xactid is (<Transaction Id>). Drop and re-create the index."
711170 When enabling the RepAgent configuration parameter 'activate monitoring', after stopping

and restarting the RepAgent, the setting automatically reverts back to 'disabled' mistakenly.

711205 Customer request to certify ASE 15.5 & ASE 15.7 HA option with Sun Cluster 3.3
711220 DBISQL stacktrace when loading an xml plan generated by sp_showoptstats
711239 The following messages appear for a cluster which has only a single private interconnect configured,

The cluster interconnect protocol has not been defined in the cluster input file.

Cannot resolve host name '' for the local interface of the link to monitor.

Cannot resolve host name '' for the remote interface of the link to monitor.

711245 The stored procedure sp_replication_path 'list' output is enhanced to include information about the default path for a more complete picture of the replication topology.
711248 Error 14575, "CREATE TABLE WITH COMPRESSION is not supported for in-memory database",

followed by error 11050, "Adaptive Server cannot process this ALTER TABLE statement

due to one or more preceding errors. If there are no preceding errors, please contact

Sybase Technical Support.", and error 11934, "REORG REBUILD of table 'tabname' failed

due to an internal error. Please contact SYBASE Technical Support", may be reported

when running 'reorg rebuild' command on table which has data or LOB compressedion

defined after user is bind to temporary in-memory database.

711255 scc.sh parameters do not work - the services-config.xml file overrides args
711299 ASE running in threaded kernel mode allows user to decrease the value of 'max online engine' less than the total number of engine threads leading to a boot failure while rebooting the server. A message saying "The total number of mux threads X is exceeding cmaxonline Y." may be reported.
711328 Using sybcluster to add an instance in interactive mode failed.
711332 ASE may not be able to start a large number of engines with the ASE kernel configured for Process mode as a Spinlock allocation error can be encountered.
711354 Doc CR:Correct print_switch_output_to_errorlog to print_switch_output_to_log
711355 Database selection dropdown is not initialized when open new window.
711373 Documentation for sp_errorlog is missing from the 15.5 and 5.7 Reference Manuals.
711406 Feature request for a configuration option that would cause update index statistics to use the configured step count and histogram tuning factor settings rather than the step count for the current histogram.
711412 When the user is running a batch query with a temp table creation outside a stored procedure, and execute the stored procedure referencing this temp table, the procedure will be renormalized each time. When there're many processes calling this batch query at the same time, random signal 11 stack traces will be observed.
711417 If ASE config file is manually edited and a config section is added at the end after thread pool section, ASE reports "Unexpected attribute for thread pool 'syb_default_pool'" during boot.
711453 Permissions through roles granted to non-default login profiles can be lost or reduced if there exists a default login profile that has not been granted all the roles that the non-default login profile has and a permission changing event (such as a grant or revoke) occurs in the server.
711494 Server hang when executing ALTER TABLE spt_TableTransfer SET TRANSFER TABLE OFF.
711534 feature request to give SCC the ability to select certain timeframes where email alerts are sent
711623 FR: set option to prevent update trigger firing when no actual update is made
711654 The ASE errorlog may contain many instances of the kernel message "Expected object passed to blkioDescriptor is not of type BLKIO,..."
711713 In rare circumstance, when replicating an off-row compressed LOB column, the replicate ASE may raise the 7153 error, "Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end." and Replication Server will abort the connection.
711819 Replicating a SELECT-INTO statement fails when the source table contains quoted column names.
711928 sp_sysmon would report a 265 error, "Insufficient result space for explicit conversion of SMALLINT value '100' to a VARCHAR field" if ASE is configured with more than 100 engines.
711953 When attempting to execute a stored procedure in a database that the user is not a user

in two error messages will be displayed stating that the user is not a user in the database.

711978 A segmentation violation can occur when configuration parameter "suspend audit when device full" is set to 0 after the audit segment becomes full.
711991 Removed privileges "connect" and "set tracing" from privilege set of GRANT ALL.
712042 sp_monitorconfig "number of sort buffers" may show Num_active and Max_Used higher than the configured value if multiple connections are concurrently performing sort operations.
712050 A set option to change the date that the getdate() returns.

Something similar to the TZ variable at OS level.

712082 subquery hits sig 11 in ResRelOp and terminates in ResRelOpProcess
712089 Job Scheduler: jobs may fail to run if they require 'large identifiers'. Currently Job Task clients are limited to OpenClient 12.5 capabilities.
712125 If there are more than 32 columns used in an UPDATE STATISTICS command, either explicitly or implicitly through the auto_temptable_stats feature, then there is a possibility of a stacktrace.
712139 Two query performance problems which are related to costing issues, data skew and suboptimal plans.

The optimizer may generate optimal plans for the related queries after creation of a new index which may work better for the queries.

712144 In rare circumstances, executing a stored procedure might hit the Signal 11

caused by the plan corruption.

712258 TOP N syntax is not shipped to the IQ server.
712340 FR: new datatype of datetime for last time row was modified.

Similar to timestamp but in a format that is useful.

712435 After drop-cluster the same cluster cannot be re-created without restarting the agents.
712461 If multi-column syntax is used with update statistics tabname (colname1, colname2,...) using out_of_range {on | off | default }, then the assignment of out_of_range behavior may not be associated with the correct columns.
712480 The LAVA based index creation is enhanced to support the case where the index leading columns are duplicated.
712495 DEUTSCHE BANK AG request to publish the complete list of MDA Wait Events

in public product document.

712502 Wrong Errorlog location in ASE CE 15.7 Installation Guide.

(NG) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/errorlog.

(OK) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/<servername>.log.

712531 In rare circumstances the query on FDP table might get some uninitialized data after the FDP table is re-sized.
712541 sp_displayrole does not report expired password. User get error 11176.
712554 The message "infected with 11" together with modules like "tdsrecv__dynexec" and "sequencer" if using jconn3.jar with text/image datatypes and an ASE157 releases. Often, message 3805 will be reported too.
712579 On AIX platforms, isql may fail to execute with the -X parameter depending on the order in which shared libraries are specified in the LIBPATH environment variable.
712636 Too many steps may be created for a histogram when parallelism is used during create index or update statistics.
712697 To have option to enable referral chasing for LDAPUA to be used with AD
712783 When multiple queries are executed on one of the MDA FDP Tables with Adaptive Server Enterprise Cluster Edition the same row may appear in the results of multiple queries. This is not expected since the FDP tables should not present the same row in multiple queries.
712808 In some cases, DBCC CHECKTABLE may report error message 7948 after a clustered index is created on a compressed APL table which contains only 1 row.
712847 DBISQL Table and procedure name lookup is slow (F7 / F8).
712855 Invoking the soundex() or difference() built-ins on unichar/univarchar strings

larger than 127 characters (254 bytes) may cause the process to be terminated.

712897 sp_bindcache information is missing from DDLGen output.
712903 Idle connections may fail to migrate during instance shutdown.
712940 Complex queries (often with a large number of group-by columns and a large number of joins

where generally each grouping column belongs to a different "joined" table)

may SEGV after generating a 331 error terminating the session. The 331 error is raised

because the query has exhausted the sort id namespace.

712949 When dbcc page() for text page with print option 3 or 4, the output may be out of the range of the page size or hit infinite loop, also, if dbcc page() for text page with print option 1, 3 or 4, it may report a corrupt row message.
712957 sybcluster will fail to connect to the cluster if duplicated agents are specified.
712970 Enhancement is made to sp_placeobject system procedure to support partitions.
712996 sp_showoptstats output has been changed for the <statsOutRan> tag to have a value of "on" if the "using out_of_range on" phrase was used in update statistics, and "off" if the "using out_of_range off" phrase was used, and will not be printed if "default" is in effect. Previously "true" was printed when "on" or "off" was used.
713032 ASE has been added new restriction to dbo-owned object in transfer object ownership.

1. DBO cannot transfer ownership on dbo-owned objects.

2. Any user or executor with sa_role cannot transfer ownership on dbo-owned objects.

In the new restriction, the wizard will not allow user to select objects that he has no privilege to transfer ownership on.

713074 Monitor server has been retired since 15.7 GA but sybcluster still contained the operations for configuring monitor server. These operation options have now been removed.
713135 In scenarios whereby a join may exist only on attributes which form a unique key on the

inner-side it is possible for the estimate number of rows to be higher than the number of

rows being passed in from the left. In reality in this situation the maxiumm number of rows

the join may produce is less than or equal to the number of rows from the left.

713189 If the Cluster Editions is configured with both backup or xp servers, then adding an instance with an xml input file may fail.
713228 Support "lock shared memory" under Microsoft Windows
713231 Enhance the optimizer to detect when a query has the requirements and correct referential

integrity definitions for us to be able to bypass any access to the child table during the

execution of a query involving a join from child to parent table.

713281 This fixes an issue which occurs if you execute "SCC-3_2/bin/sccinstance - refresh" for an ASE Cluster installation, the ASE SDC plug-in instance directory is deleted.
713291 In rare circumstance, error 1204, "ASE has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure ASE with more LOCKS.", and error 5619, "Adaptive Server internal error. Could not obtain count of in-doubt

transactions for space reservation.", may be reoported when running BCP IN/INSERT/UPDATE on table with TEXT/IMAGE/UNITEXT columns marked replicated.

713367 Multi-user tests sometimes run into error 716, "Unable to allocate memory from compression info pool size", even when the appropriate configuration option is set very high. Statements encountering this error while accessing compressed tables cause a transaction rollback. Fragment memory in the compression info memory pool found to be heavily fragmented, and memory fragments are seen to be in-use even when there are very few user connections active in the server.
713411 When replicating the value from an LOB column which have both in-row and LOB compression property, if the defined in-row length of LOB column at replicate side is so long that is close to

@@maxpagesize, replicate ASE may raise error 7153 'Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.' and Rep Server abort the connection.

713441 Documentation: Clarify that writetext update does not update row timestamp
713464 Error 1503 may occur when index is created with LAVA based index creation if the number of distict index value is not greater than CONSUMERS number.
713481 Negative row count may be shown in the output of DBCC CHECKTABLE and CHECKINDEX commands if there are more than 2,147,483,647 rows in the table.
713540 When the user specifies for dump configurations a default directory for the dump stripes

with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when

generating the list of load database and load transaction commands that are needed to

repopulate the database to a specified point in time.

713547 A wrong number of rows may be updated with INSTEAD OF TRIGGER when the base table of the view has predicates defined on it.
713572 A 12319 error followed by a stack trace that includes the modules LeMergeStmtOp::_LeOpClose() and dol_def_update() may be reported when a MERGE statement is using cloned plans.
713631 Error 832 may be reported when creating an index whose depth is greater than 6 if 'number of sort buffers' is configured as smaller value.
713632 DBISQL/ASE Connect Dialog Advanced tab replaces connection parameters' "=" with escaped sequence "^003d" when disconnecting and reconnecting to an ASE.
713638 LIKE predicate optimizer estimations may be incorrect when UTF-8 is used. Optcriteria cr713638 is added to correct this issue.
713677 Include OCS CR 672301 to fix an AIX specific memory leak.
713707 The message, "Current process infected with signal 11", together with a stack trace which includes the modules 'bi__xml_query' and 'bi_xmlextract' may be reported in the error log when an external KILL signal is issued to a regular XML query session.
713728 After upgrade from 12.5 to 15.7 ESD#1 or later version, if the 15.7 server is SMP server, "allow wide DOL rows" option is missing on tempdb; if is SDC server, this option is missing on the local temporary databases.
713800 With plan sharing enabled, and under heavy workloads consisting of concurrent queries that qualify for query plan sharing, some shared plans may be prematurely terminated.
713840 'dbcc markproc' was failing with error 12309 : Expanding update on object was failing on page due to insufficient free bytes.
713848 On the Solaris platform, when ASE is running on a cluster in threaded kernel mode, if the XP server of an instance is shutdown from an isql session on another instance, the isql session will hang.
713855 When migrating from Adaptive Server versions 12.5.4 or 15.0 to version 15.7 ESD #2 using sybmigrate, the execption, "Failed to add the role 'sa_serverprivs_role' into the current database catalogs", may be raised.
713881 A 9830 error may be reported when inserting a row into a table with compressed data.
713915 ICR: Messenging: timeslice in rtms_svrToUtf8 and cpu pegged using TIBCO
713937 Request to include in the documentation a discussion of the various ANSI SQL Standards and better explain for each command what we mean when we say is is ANSI compatible or an extension.
713945 In some circumstances, the message "current process infected with 11" in the module 'LeScanOp::_LeOpRelease' together with a stack trace which includes the modules 'LeUnionOp::_LeOpRelease' and 'LeEmittOp::_LeOpRelease' may be reported in the error log after an error message 716 if the query involves a UNION ALL clause.
713950 A stacktrace may occur when using UPDATE STATISTICS with HASHING on character string datatypes which have a non-binary sort order, and there are more than 65535 unique values.
714034 DBCC CHECKTABLE or CHECKINDEX may report error 803 if the index is very deep.
714061 Forwarded row count in the SYSTABSTATS for a table that underwent 'REORG REBUILD <tabname> WITH ONLINE' may be incorrect.
714086 In some cases, if a union query involves concate varchar type of variable, it could return wrong result due to unexpected truncation.
714094 When a predicated privilege is granted on a table for a set of columns, Adaptive Server may occasionally apply the predicate to a column outside the set of columns.
714131 In some customer scenarios with stored procedures or sql accessing multiple databases, rdbtmgr_spin would show high contention.
714153 Parallel index creation may fail because of error 832 if 'number of sort buffers' is configured as very small and the index depth is very large.
714198 FR for ability to turn off user ability to grant privileges to the 'public' group
714217 Supplying an overflow or underflow search constant to a query on a proxy table may return incorrect result.
714288 Under very specific circumstances it is possible for a database load to fail with error:-

Backup Server: 4.141.2.22: [23] The 'read' call failed for database/archive

device while working on stripe device <device> with error number 14 (Bad address).

This has been reported when loading a striped dump taken using 'with compression=100', but

only sporadically.

714306 When 'literal autoparam' is enabled, it could raise an error if a query has a literal in order by clause such as ' ', 'a' and the query was cached in statement cache and it needs to be recompiled.
714315 Feature request to make Statement Cache Hash Table size configurable.
714330 Add functionality to the LOAD ... WITH LISTONLY=CREATE_SQL command to

include the various database options (applied with sp_dboption) and

attributes (applied with CREATE and ALTER DATABASE) of the source

database, in the generated SQL.

714352 BigDecimal value rounded to INT value when executing java through ASE JVM. This problem is not a bug but genuine implementation of the ASE Internal JDBC driver which originated from the 1.1 standard where specific functionality was introduced under JDBC 3.0. If this functionality is needed a feature request should be filed.
714355 It is difficult to understand just what 'dbcc markprocs' in sp_downgrade is doing, so replace the statement in sp_downgrade with a more understandable SQL update.
714466 The TSQL Guide incorrectly states about shared temporary tables that "The table exists until the current session ends or until its owner drops it using drop table." Shared temporary tables exist until explicitly dropped or the tempdb is rebooted.
714478 In some rare case, if a plan has a Hash operator in it, it could cause stacktrace in LeHashInputSet::releaseExtents(), LeHashOP::LeOpSaveIOStates() when a stored procedure or a cached statement is executed multiple times and its plan has LeHash operator.
714612 A 2846 error, "SQL function 'dbo.sp_<function name>' not found. Specify

owner.objectname or use sp_help to ..." may be incorrectly reported when

a SQL user defined function created in sybsystemprocs database with

a name prefixed by "sp_" is invoked from a database while a open

transaction in the same database is creating a stored procedure, view,

trigger, rule or default.

714638 monEngine connections column is wrong for kernel mode threaded.
714641 monEngine column connections is not describe correctly.
714670 sp_downgrade_esd does not report tables which are configured for in-row LOB compression.
714773 In a multi-engine ASE running on the Unix platform, the tracefile for the spid (created using 'set tracefile <path> for <spid>') is truncated in pre 15.7, while the tracefile is not populated post 15.7 in process kernel mode, when the spid being traced is affiniated to an engine other than the one which created the tracefile initially (This can happen if the engine that created the tracefile is offline).
714798 On AIX platform, ASE Cluster Edition may fail to start if logical volumes are used and I/O fencing is enabled.
714806 When ASE is shut down using the 'nowait' option and while data is loaded using fast bulk-copy into a table that is created with the 'for load' attribute, on ASE restart some data may be lost.
714830 When downgrade from 15.7ESD#2 CE to 15.7ESD#1 or GA CE, after downgrade_esd completed and reboot

the 1st node with the lower version server, when booting the 2nd node, ASE will hit SIGSEGV at 1st

node and hang the 2nd node.

715048 Complex queries with predicates having aggregates and subqueries could lead to wrong results.
715086 When shutdown cluster is issued from one instance, busy user tasks running on other instances may be immediately terminated.
715094 A 716 error, "Unable to allocate memory of size %d bytes from the '%S_MSG' pool" may be reported when querying a partitioned view including compressed tables many times.
715183 The replication of a stored procedure for which a 'request function replication definition' has been created fails with Replication Server error 5157 indicating that the transaction owner's password is missing.
715203 DBCC CHECKSTORAGE does not detect LOB compression flag inconsistencies in the TIPSA. With DBCC

CHECKTABLE and DBCC CHECKDB these types of inconsistencies were already being reported with message 15960.

715228 Wrong result could happen when referencing a non-correlated scalar aggregate view at the inner side of an OUTER JOIN.
715234 On AIX, the monThread MDA table incorrectly indicates that the Listener thread is consuming 100% CPU.
715240 ASE Cluster Edition allows user to create thread pool when "max online engines" is not sufficient.
715312 Use of online utilities like 'reorg rebuild with online' might lead to incorrect used/unused counts in the OAM for the table. This is reflected by a later 'dbcc checkalloc' on the table reporting error messages 7949 and 7940.
715398 This PC-Client EBF is based on SDK 15.7 ESD#4. A list of changes in that SDK 15.7 ESD#4 is available at http://download.sybase.com/swr/15934/EBF20102_Buglist.txt
715670 CS_IODESC.name has view name instead of table name for LOB column.
715785 Signal 11 in set_password or sync_password
715798 When trying to launch SybCpnSrvSetup.msc results in 'bad file format' error reported with a stacktrace and subsequent unloading of the dll.
715835 Modify auditinit utility to create log file with 600 permission, instead of user's umask.
715967 auditinit utility requires user to enter non-null sa password for existing ASE.
716047 Shared memory dump attempt fails with an infected with 11 in function shm_mergedump
716054 Linux Installation Guide has outdated RHEL raw device configuration information
716059 tables referenced in a procedure only in LOCK TABLE commands are not reflected in sysdepends or sp_depends output
716165 Arithmetic overflow may occur causing SCC to stop monitoring the ASE.
716166 A 12324 error, "In database 'dbname' the server failed to open required

table 'syspartitions'. Please contact Sybase Technical Support." may be

reported during the execution of either LOAD DATABASE or USE <database>

commands when ASE is requested to calculate threshold information by

performing OAM scans.

716262 On HPIA64 platforms, ASE may report error 16747, "The 'enable hp posix async i/o' configuration option is only available on the HPUX platform. This option is not valid on the current platform." if 'number of disk tasks' is set as larger than 1 when 'enable hp posix async i/o' is enabled.
716284 asecfg core dumps when started on Solaris x64.
716349 In some cases, ONLINE DATABASE or DBCC CHECKDB executed on a database with large number of compressed objects might fail with error 716 (Unable to allocate memory from the compression info memory pool), when the 'compression info pool size' configuration option is set too low (e.g. the default value of 4096).
716457 The ASE Backup Server process has a memory leak when dumping and loading databases, which causes it to grow until it exceeds the memory limit.
716567 A query having MDA table monProcessObject caused signal 11 in routine mda__process_sdes() with an invalid SDES in a cursor. This CR seems a concurrency issue since another session was doing 'OPEN CURSOR' and the related internal cursor structures might be changing.

May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject.

716609 In SCC 3.2.7 build 4819, in the Import Resources wizard, the Confirmation page and the Import Results page are empty and does not show the imported resources. However, the resources do get imported properly.
716618 When use TF7751 and TF7752, sometimes it could cause stacktrace during plan printing.
716642 If replication is set for master device, then job scheduler will fail to boot with following message in the ASE error log file :

"background task error 18388: You must be in the master database in order to run 'sp_locklogin'."

716645 During an UPDATE command on a table that has in-row LOB columns defined,

ASE may move some of these columns from in-row to off-row or vice-versa

if the size of a datarow exceeds configured limits. When such a table has

a datarow with an off-row LOB column that is not explicitly updated, ASE

may not log this column data correctly. This will result in replication

failing if this column is marked as always_replicate.

716654 Instrumentation: ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error. This is instrumentation to capture diagnostic information upon any update to controller's cancel queue.
716663 This resolution fixes an issue in the Collection Job History tab where it does not update correctly when schedule selected
716679 When network password encryption is used and sp_passwordpolicy option 'unique keypair per session' is set to 0, client connections will fail with error message:

Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line

CT-LIBRARY error:

ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED.

716720 Remove error # 12061 when a query is executed on an MDA Table that contains localized message text when the client is configured to use a language into which the MDA Table messages have not been translated. Specifically, if the client language is set to 'german' error 12061 will no longer occur when a query is executed on the monWaitEventInfo table.
716729 Document no blanks are allowed in Install Path for Windows platform
716736 Error: 8210, Severity: 20, State: 2 + stack trace crt_work+0x148() run_crtable+0x294() LeWkTbl::crtWkTbl(int,short,int)+0x160() LeStoreOp::_LeOpAcquire(ExeCtxt&)+0x2a4()
716798 select involving aggregates and having predicated privileges defined at column level on the table could result in wrong results.
716831 Add a section to the install guides that explains Optional Features and how to install them with SYSAM 2.0
716870 Adaptive Server may not kill a task that is marked for termination, which is reporting shortage of buffers in buffer pool like "cache is configured too small for current demands".
716957 In rare circumstances, a 614 error, "Adaptive Server accessed a row that has an illegal length of <value> while in data base <database>" may be reported when running DBCC FIX_TEXT on a data-only-locked table.
716960 ASE fails to boot on Windows Server 2012 with a stacktrace containing kiprint_os_version() on the stack.
716981 When the configuration option 'number of network tasks' is set to greater than 1, ASE running on HP-UX may hit infected with signal 11 (SIGSEGV) in module kstcpnetctlrCancelRequests.
717026 Improve spinlock efficiency on Solaris SPARC platform.
717050 A 3502 error, "DUMP TRANSACTION requires a dump configuration name because the configuration option 'enforce dump configuration' is enabled." may be reported during the installation of an ASE ESD release on top of 15.7 ESD #1 version while 'instmsgs.ebf' is installed and ASE uses a dump configuration. Alternatively when ASE uses a dump configuration the execution of "DUMP TRANSACTION <database> WITH NO_LOG" will fail.
717078 Feature request for a ROW_NUMBER function to return the number of a row in a given ordering.
717079 The ASE COTS JavaVM version is updated to version JRE 6 update 33 for each supported platform in the sybpcidb database.
717212 An infected with 11 (SIGSEGV) stacktrace in statinit soblddolpages occurs when trying to ALTER TABLE to add a column to a table with indexes.
717224 Execution of sp_sysmon by a user other then "sa" can result in error 4066 when "sa" login is locked.
717232 When using update statistics with hashing there may be a stacktrace when the number of unique values in the column is greater than 65535.
717258 Request to be able to create key copies for login_association when

logins are externally authenticated using Kerberos\LDAP

717371 Feature request to allow built-in access to the java.util.concurrent class library.
717481 If with hashing is used, and the column has more then 65535 unique values then there is a possibility that the sarg density and unique count for the column are under-estimated.
717491 Importing data in DBISQL by selecting Data -> Import from a database menu option, fails with password length issue JZ002
717492 ICR: 1837 error for IMDB, root cause from CSMD
717496 ASE returns error message (Msg 16341, Level 19, State 1) when split a range partitioned table when partititoning filed is a VARCHAR, DATETIME fields.
717574 Event ID 178's description is updated, it is wait time for client connections.
717610 when using hash-based statistic gathering, the default column width should be used for fixed length columns instead of being computed.
717627 sp_showoptstats would always display 4.00 as the default average width for any fixed length column
717662 When using fast logged bcp to insert data into a table that is marked for replication and

has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated.

717673 Allow delimited identifiers to be 255 bytes long; allow double right bracket as an escape for right bracket in bracketed identifiers; disallow embedded null bytes in identifiers.
717740 Bcp-in was failing for a table with columns more than 128 column and having one of them as text column.
717811 Implement "Copy Connection String" feature in DBISQL 12.0.1 Connect Dialog for ASE.
717828 A 9254 error, "Could not locate schema version for object id '0' in the transaction log."

followed by a 9204 error, "Could not locate schema for object with id = (0), current marker

(0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum

and the 憁ultipath distribution model� is enabled. This will result in the Rep Agent

Thread shutting down itself.

717861 ASE should report license message when setting minimally logged operations on tempdbs without a valid IMDB license.
717871 On Solaris 10 updates earlier than Update 11 (Generic_147441-23), ASE running in kernel threaded mode might experience a temporary time shift from local time to GMT. For example, time value of 10:00 might change to 18:00 for a short period. To resolve, upgrade Solaris 10 OS to Update 11 or later.
717879 When a set role command is executed within a procedure or SQLUDF, it takes effect during the context of the procedure or UDF only.
717910 When the built-in function GETREPDEFMODE() is called in a query involving a table,

an error 622 may be reported together with a stack trace in the error log which includes

the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'.

717976 In SCC 3.2.7 ESD1, in the Heatchart view, for a KPI is not updating properly according to the set thresholds when there is an overlap in the threshold boundaries.
717984 implement implicit conversions char, varchar to numeric, decimal
718044 This fixes an issue where duplicate managed object hierarchy records can be created
718119 Add support for non-class resources in JAR files within ASE
718133 If more than one process tries to materialize a deferred table, they all will be stuck in a deadlock and only one process would succeed causing all others to rollback.
718141 wrong row count when creating an index with parallel and "with statistics using 0 values"
718191 Error 2812 or 11214 is raised when accessing an MDA table specifically mapped as a proxy table.
718203 When stopping Job Scheduler using the undocumented sp_controljob procedure it may be

possible under rare circumstances for a stack trace to appear in the error log

in function upsleepgeneric() with js_wakeup() also appearing. The server will necessarily shutdown as this path holds spinlocks.

718206 If the master database has a secondary truncation point set during an upgrade from 15.0.1 to 15.7,

an error 950(Database 'master' is currently offline. Please wait and try your command again later) will

be raised during the upgrade.

718253 Utilities like haisql, HAase agent or MSCS HA agent, connects to the ASE server, however not using login/password encryption on the network.

When configuration parameter "net password encryption reqd" is set to 1/2, the utilities like haisql, HAase Agent or MSCS HA agent will fail to login to server with following errors :

Msg 1640, Level 16, State 2:

Adaptive Server requires encryption of the login password on the network.

Msg 4002, Level 14, State 1:

Login failed.

CT-LIBRARY error:

ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

718259 Running sp_monitor will lead to an error 2812 raised via sp_monitor_server.

1> sp_monitor

2> go

Msg 2812, Level 16, State 11:

Server '<server>', Procedure 'sp_monitor_server', Line 57:

Stored procedure '' not found. Specify owner.objectname or use sp_help to check

whether the object exists (sp_help may produce lots of output).

718261 Running sp_monitor will lead to an error 2812 raised via sp_monitor_server.
718284 An 823 error, "I/O error detected during wait for BUF=<value> ... cid=0

('default data cache') ... " may be reported when an ASE 12.5.4 database

dump is loaded into an in-memory database and while ONLINE DATABASE is

run. This will result in a database upgrade failure.

718398 Update statistics options are 'sticky', meaning previous values which are

explicitly set will continue to be used for future update statistics and

create index commands on the same table if these options are not specified.

These sticky options are:

step count (using step values);

histogram_tuning_factor;

sampling;

hashing, partial_hashing, no_hashing.

This CR implements a configuration parameter "enable sticky statistics"

to control statistics stickiness server wide. The default for

"enable sticky statistics" is 1, which matches existing sticky statistics

behavior. To turn off sticky statistics, use:

sp_configure 揺nable sticky statistics� , 0

718440 When executing sp_dboption without any parameters to list database options, the output is hard to read due to a lot of empty spaces.
718466 A 1508 error, "Create index aborted on duplicate rows. Primary key is 'spinlock_p, -32768'" may be reported when running sp_sysmon and sp_sysmon runs very slowly.
718500 Illegal outer-join request gives infected 11 in oj_syboj_ojdepends_maps instead of an error.
718587 A task deleting rows from a DOL table in an in-memory database might wait indefinitely for an EX_LATCH by holding the SH_LATCH on the data page.
718606 Enhance 696 error reporting to facilitate investigation
718628 Signal 8 can occur when the "update statistics hashing" configuration parameter is used
718637 Parallel queries with the following query plan scenario MIGHT fail with a "Command has been aborted" message and no other warnings/errors reported in the error log: (1) There is a merge-join op where one of its child trees contains a replication exchange operator. (2) There is no "draining" operator (e.g. sort operator) between the merge-join and the exchange operator. (3) The merge-join's other child drains its input stream before the child with the replication exchange does.
718658 A signal 11 (SIGSEGV) error occured in kmuxtskGetThreadpool() while running sp_sysmon. This is a timing-related issue that is not easy to reproduce. It occurs only on a server that is running in threaded kernel mode.
718696 When an AP plan clause is specified as part of a dynamic SQL prepare statement, the plan clause is not saved in the statement cache when such statement is cached under 慹nable functionality group� or 憇treamlined dynamic SQL�.
718710 The message "current process infected with 11" in the module

's_begupdate' together with a stack trace which includes the

modules 's_execute' and 'execproc' may be reported in the

error log when a stored procedure executes a DML statement

which was compiled at runtime.

718714 During execution of a java class within ASE that uses the internal jdbc driver, sybase.asejdbc.ASEDriver, it is possible under rare circumstances that a particular statement encounters a specific error and that spid may hit an error 1265 and a stack

trace will appear in the ASE error log. This will terminate the jvm thread. This can and

will leave the ASE in an inconsistent state and will require a restart.

Error: 1265, Severity: 20, State: 1

An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x14a01f000, lrmagic=f).

718733 Support a 'WITH RECOMPILE' clause at the statement level.
718741 Signal 11 in bufdlink() *also reporting ups_nosort_init_prestat() & us_allocate_stat_proc_hdr() * may appear in the error log along with the server shutting down.

This can happen when there is a worktable used by an update statistics command

that resides on an in-memory tempdb (IMDB)

718778 The message "current process infected with 11" in the module 'ra__process_xchange'

together with a stack trace which includes the modules 'decompress_row' and

'decompress__crow_to_apl' may be reported in the error log, after an alter table with

no datacopy command is run on a table that has compressed data, and while the replication

agent task is attempting to decompress data to be sent to the Rep Server.

718876 sybdiag fails with an unhelpful error on Solaris when the SYBASE_JRE6 environment variable is not set
718945 In rare conditions DEADLOCKs may occur involving 'sysqueryplans' if users attempt to clear query metrics using "sp_metrics 'drop', '1'" while query metrics gathering is enabled.
718966 Bringing ASE JVM to latest JDBC spec. to bring in the BigInteger scaling functionality

which was introduced when Java RC2 arrived.

718982 Cross platform load works serially when updating pages on very large databases meaning a very long time before database can be onlined. Parallelism is requested.
719019 An argument to error message 103 (The <msg> that starts with '<string>' is too long. Maximum length is <n>.) is too long. The argument needs to be truncated.
719023 The error message "A00: SYBMULTBUF ERROR: Internal error: The number of archive strings

in the database info file exceeds the maximum number of allowed stripes." may be reported

by the backupserver when an attempt to execute a DUMP TRANSACTION command with many STRIPE ON

clauses is made.

719124 ALTER TABLE SPLIT raises errror 16341 for range partitioning when it is based on DATETIME values.
719138 The ASE server fails to boot on the HP-UX IA64 platform in Process mode if Kerberos is enabled.
719162 When using fast logged bcp to insert data into a table that is marked for replication and has compressed TEXT/IMAGE/UNITEXT columns, the compressed TEXT/IMAGE/UNITEXT data may not be inserted successfully and the bcp command fails.
719176 Unable to drop/delete/remove the SCC login user.
719212 Applications running against ASE on Solaris platform (SPARC and x64) in threaded mode may experience poor performance (response time and throughput). Analysis of sp_sysmon outputs and MDA tables may show high I/O Busy% and high wait times on disk-related events. Solution requires installation of OS patch for Oracle Bug 16054425 and setting ASE configuration parameter "solaris async i/o mode" to 1. This issue only affects ASE on the Solaris platforms.
719290 When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file 慴ackup_tape.cfg� exists, ASE will not be able to read it and the dump will fail. The Backup Server will report an error: "The format of the device configuration file <$SYBASE>/backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0".
719295 Docs: Infomaker Powerdesigner, Powerbuilder are not certified on win2008 R2
719361 The reported database name is truncated to 20 characters when executing sp_dbrecovery_order for a database with database name longer than 20 characters.
719374 When changing the character set to a multibyte character set and running DBCC FIX_TEXT for the table with TEXT columns, the DBCC CHECKTABLE will fail with error 7951, "Data size mismatch while checking a text value".
719389 In sybmon, shared memory dump will not be compressed if "memory dump compression level" is set as 0 although the "memdump compress" command is executed explicitly.
719399 When the followng three conditions are met:

- the SQL statement has enough predicates to generat at least 400 SARGs and

- the SQL statement is executing at isloation level 0 (dirty reads) and

- a unique index with at least 10 columns is chosen by the optimizer to use for repositioning the scan,

A 702 error can be raised with the function, setupSargArray in the call stack.

719408 doc request: include one more line in "what sybmigrate does not do" = downgrade
719449 Adaptive Server may encounter a storage access violation error when query execution is interrupted or some special query is executed on 64bit diagsrvr.exe or 32bit sqlsrvr.exe on windows platform.
719532 When GP (Granular Permissions) is enabled, booting ASE could result in a 10331 (Permission denied..) error.
719560 On ASE Cluster Edition Solaris platform, when a user with sa_role executes 'set role sa_role on' followed by 'alter thread pool' command, the login connection hangs with following message in the error log: "There is no thread pool named '' defined in the system."
719597 Report the compressed shared memory dump file size and configuration setting in the sp_shmdumpconfig stored procedure.
719616 When ASE Cluster Edition is configured error message 969 "You can access database '<db>' only from its owner instance.." is not being raised when the sp_ddlgen_permissions stored procedure accesses a tembdb on another instance. Errors such as 567 "You must have the following role(s) to execute this command/procedure.." or 17230 "You must be the System Administrator (SA) or the Database Owner (dbo) to execute this procedure" were reported instead.
719639 The message "Missing datarow in TEXT/IMAGE/UNITEXT insert log record. Transaction log

may be corrupt." may be reported when attempting to replicate data after an alter table drop

column with no datacopy command is run on a table with LOB data.

719643 If hash based statistics collection is used with a large number of steps, then a stack trace in the function ups_stat_memalloc() may be encountered.
719673 A 14108 error, "Could not find partition descriptor for objid %d, indid %d, ptnid %d in dbid %d" may be reported when running DBCC DBREBOOT if traceflag 12315 is off.
719678 Under some circumstances, in a Shared Disk Cluster environment, sessions may hang because space usage on the segment has been put incorrectly in a freeze state, owing to threshold manager limits being mistakenly hit when they should not have been.
719683 A 3223 error, "Attempt to read a dump header failed; returned error code is 12." followed

by a 3208 error, "Unexpected end of file while reading beginning of dump. Please confirm

that dump media contains a valid ASE dump. The ASE error log may contain more information

on the problem." may be reported due to a corrupted dump header while loading a database dump that was taken on ASE 15.7 ESD#2 and the database was created with a template.

719696 dbcc checkcatalog to check the value and range for suid,uid,gid in sysusers.
719716 Add a better error messages for grant permission role when it hit

2601 insert duplicate key row in object 'sysusers'

719722 The values for the IOTime column in the monIOQueue table are incorrect.
719728 Improve documentation of sp_chgattribute 'identity_burn_max' option.
719752 When GP (Granular Permissions) is enabled, booting ASE could result in 16802 (You must have the following permission to execute this command/procedure..) error.
719785 ASE15.7 can be upgraded using ASE12.5.4 or later.
719838 Executing the incorrect syntax 'grant execute on set_appcontext to <user>' causes a system exception (signal 11) referencing 'grrev_nullflush'. The command should be 'grant SELECT ...'
719859 If data row decompression is used, then update index statistics may be slower since an unnecessary data row decompression is performed.
719911 DDLGen is not backward compatible for archive databases in ASE 15.7 ESD#2
719915 DDLGEN fails to include the LOB_COMPRESSION attribute when run on a database that was upgraded from ASE 15.0.3.
719961 Under some rare cases, a signal 11 (SIGSEGV) could occur in open_byname() when executing nested stored procedures.
720002 Error 1120, 803 with sp_helpdb on a database with a cache binded
720139 When doing upgrade using upgrade utilities or downgrade for such databases which name contains blank or tab character,

upgrade utilities or sp_downgrade/sp_downgrade_esd will report syntax error on the database name.

720162 When the system stored procedure sp_help_rep_agent is executed with no parameter

or a null value for @dbname, error message 18374 may be unexpectedly printed

with an empty database name.

720196 a new column called predid is introduced in sysloginroles but its not documented.

This info need to add to user documentation.

720215 SQL statement replication, extra WHERE clause added when SET statement contains a column that has a rule.
720222 MERGE INTO sets @@rowcount to the number of rows scanned from the USING table rather than the number of rows affected (inserted/updated) in the INTO table.
720224 Errors 7961 and 2759 are raised when a variable is used in a GRANT ROLE predicate definition. The errors are raised correctly but the wording is cryptic.
720313 ASE 15.7 fails to start during upgrade from ASE 12.5 due to the lack of enough ASE kernel resource memory being reserved.
720390 Feature Request: DBCC REINDEX to use a seperate transaction per index instead of one for all indexes.
720417 If the user does not have sso_role when running installmaster, the message

"You must possess System Security Officer (SSO) role to run the installmaster

script" will be displayed when on a Cluster Edition server instead of

"You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Suport role and Monitor and Diagnosis role to run the installmaster script."

720522 doc: sp_sysmon syntax missing "clear" option
720608 query terminates signal 4 in StatObject::StatJoinObjects with allrows_dss with a larger default data cache.
720635 New Feature Request: sysaudits extrainfo column to allow more than 255 characters
720655 If running:-

sp_restore_system_role 'sa_serverprivs_role'

after having re-created 'sa_serverprivs_role' and the role id for 'sa_serverprivs_role'

is greater than 99, you will receive error 265

Msg 265, Level 16, State 1:

Server 'UBUSAP', Procedure 'sp_restore_system_role', Line 202:

Insufficient result space for explicit conversion of INT value '100' to a

VARCHAR field.

(return status = -6)

720659 There may be very slow optimisation of queries with large IN clauses or excessive stack usage with aggregate queries with large IN clauses.
720703 The first row insertion into DOL table might lead to in-correct emptypgcnt value in SYSTABSTATS

due to '0' emptypgcnt set by the task creating the index on empty DOL table.

720934 Inconsistent\unpredictable multi attribute costing and diagnostics.

Multi-attribute costing can lead to some undesired estimates in both search engine evaluation and plancost outputs.

720951 SCC Arithmetic Overflow error 3606 raised when Monitoring Datacache
720971 On ASE Cluster Edition, a user connection may not execute the global login trigger.
720980 In rare circumstances, ASE might report a signal 11 (SIGSEGV) in collectMonCSInfo() when querying the monCachedStatement MDA table.
721003 When downgrade from 157ESD#3 or later version to pre-155, downgrade prepare step will fail with error message

"ERROR: Cannot downgrade to '15.0.0.0' server, which does not support bigdatetime and bigtime datatypes."

721028 NFR: allow optdiag stats extraction without sa_role and add optdiag insert and optidiag extract to granular permission options.
721093 The informational error 16833 was added to extend parallel diagnostics.

This error provides a CSMD point to dump the system state at the point

that parallel primary error processing begins. At this point, all of the

parallel family's state is available for diganostic analysis.

721144 If Java in the database is being used, then if the "same" shared configuration file

is used by more than one instance or Server, then there is a race condition during

JVM initialization where it is possible that the message 揷urrent process infected

with signal 11� in the function 慾vminit� may be reported in the error log, followed

by the message 揊ailed to initialize Java services". This may result in ASE shutting

itself down.

721269 Add support for use of LIKE clause in an immediate PRS.

Currently this is not supported as LIKE clause uses a built-in function to

do its processing. This will lead to error 7721.

Msg 7721, Level 16, State 6:

Server 'xxxx', Line 1:

Precomputed result set definition error: Immediate PRS with built-ins

is/are invalid or not allowed; no PRS has been created.

721270 Immediate PRS creation with a LIKE clause throws a misleading error message that involves a builtin clause, because LIKE is internally converted to a BUILTIN operator.
721278 A 691 error "Encountered invalid logical page '0' while accessing database ... This is an internal system error ..." may be reported in the error log followed by a stack trace which includes the functions 'set_repdb_status', 'txtimg_upd_table' and 'pg_oamscan_startscan' if a database that has the option "deferred table allocation" set is being marked for replication with SP_REPTOSTANDBY and the 'all' option.
721289 Feature Request: sp_helprotect to report from type of action (select, delete, etc) perspective
721291 Change description of monTask in MDA table description to remove SPID\KPID, these

columns do not exist in this table.

721294 Feature request to have DBISQL INPUT and OUTPUT commands support current EXCEL file formats (i.e. Excel .xlsx, .xlsm, .xls).
721296 FR 721403 has been opened to address the sp_helpdb output being the same for explicit and implicit.

However, a warning in the IMDB users guide and ref manual should be created

721375 dump configuration command misses out "to dump_dir"
721386 dump database shoud have "using config" not "configuration" in documentation.
721403 The status field in sp_helpdb output does not give any indication for temporary databases created with durability of "no_recovery" and normal temporary databases.
721482 sp_configure "o/s file descriptors" may show a larger value than the actual number of file descriptors as indicated in the error log.
721500 ASE is not able to boot with more than 50 thread pools
721543 When using a resource file with sybmigrate, despite having plenty of room on the repository device specified, sybmigrate does not create the work database at the size specified in the resource file.
721559 On AIX, if ASE threaded kernel mode is being used, then ASE may report a SIGSEGV in mda_nap_start along with a "Scheduler infected: exiting" message in the ASE errorlog.
721594 If plan sharing is enabled, an error 8210 "Duplicate of work table descriptor found in the id hash table for temporary object <n>." with stacktraces including des_wkinstall() and crt_work() may be reported in the ASE errorlog.
721620 Msg 2601 duplicate key on 'sysindexes' with unique index 'csysindexes' when dropping and recreating constraint on a partitioned APL table changed to DOL locking scheme.
721627 Request to extend support predicated privileges on views in circumstances where view

and referenced table have an ownership chain available.

Also to support grantable predicated privileges on views directly.

721628 Extend 'execute as caller' functionality to triggers\UDFs to allow

predicated privileges to be respected on referenced tables where there exists

an ownership chain between trigger\UDF and referenced table.

721665 You are about to upgrade your server to 15.x. Are you sure? Y/N?
721731 ASE Alarm Subsystem may stop working which can result in "wait for delay hh:mm:ss" to exceed specified time or even hang. This can also cause log records to have stale time values that can prevent "point in time restore of a database" from working.
721735 After ASE upgrade, Job Scheduler may fail to boot with error "Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state." Running "dbcc upgrade_object" on sybmgmtdb resolve the problem.
721737 When updating a column to have NULL value and an immediate refresh pre-computed result

set (materialized view) exists which selects that column, the session will be disconnected unexpectedly and a stack trace that includes the module memmove() will be reported in the error log.

721781 The value of the 'status' column of most rows of system group in 'sysconfigures' table will be changed from 2 to 386 when upgrading to 15.7 ESD#2 or later version.
721799 The user usedb_user should not be allowed to create any objects.
721809 ASE at times sends extra TDS DONE packet for ct_cancel CT-Lib call.
721824 When the following is true: (1) the statement cache is on and (2) a dynamic prepared SQL statement containing a abstract plan clause is executed and (3) the same statement is prepared and executed by another ASE session, then the entry in the statement cache that was created by the first execution is not found when the dynamic prepare command is executed in the second session. As a result, a new LWP is created by the second session.
721846 From 15.7 ESD#3 it is possible to use the 'using out_of_range' clause

with update statistics when specifying mutiple columns (multiple column syntax was

added in ESD#2)

update statistics t1 (c1),(c2) using out_of_range off

This request is to allow separate distinct out_of_rang clauses for each column in the

list:-

update statistics t1 (c1) using out_of_range on ,(c2) using out_of_range off

Currently this will raise a syntax error.

721858 In the 'Reference Manual: Tables' , KTID is not currently documented as a column in

monProcessLookup

721887 With partitioned tables, some query plans may choose the MERGE UNION ALL operator, rather than Dynamic Partition Elimination.
721889 When either 'streamlined dynamic SQL' or 'enable functionality group' is configured and a client cursor containing host variables is declared through embedded SQL, and the cursor statement references the same host variable more than once, an error like:

-201 : Prodecure <procedure_name> expects parameter <parameter_name>

where <parameter_name> is the name of the host variable that appears more than once in the cursor-declare statement, will be generated.

721959 Literal auto parameterization of large IN lists may cause performance issues. Trace flag 7786 was introduced to turn off literal auto parameterization of queries with large IN lists (> 128 constants) as well as avoiding caching of the respective statement. Trace flag 7786 only has an effect if literal auto parameterization is turned on i.e. if literal auto parameterization is turned off, then the statement will still be cached.
722025 In ASE 15.7 ESD#3, when restoring to a different target server, sybrestore would prompt the user to provide mapping directories. But sybrestore does not give out any warning to the user when it detects cyclic pattern in the mapping directories. In addition, when using external dump files to load the database onto a different target server than the source server, mapping directories are ignored in the load database and load tran commands.
722058 sybmigrate fails with the error, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'" at set up stage (sybmigrate -m setup).
722099 Sybase Central ASE Plug-in will not work on IBM platforms due to a IBM jre issue which restricts running Sybase Central 4.x versions with jre 6.
722240 ASE Agent Plugin does not automatically detect the ASE error log file location changes.
722246 Doc request: Object Coherency Block Information message
722341 In ASE 15.7 ESD#3, if the database is dumped with a protected password, stack trace will be thrown when the database is selected in sybrestore. This has been corrected and support is added for loading the database dump with a protected password.
722436 Provide an option so that sp_password and other commands can use encrypted passwords as arguments so this information is not sent in clear text over networks.
722488 Feature request: dump database to confirm physical dump stripe (to disk)-- size aligns with data size recorded in the stripe header.

Basically, they encountered a failed load database because of a corrupt dump stripe.

This feature is to have backupserver run a final verifyonly like check on the dump before "dump is complete" is printed.

722539 DDLGen does not support object dependency export.
722547 On Unix systems the execution of DBCC DBTABLE may report descriptions of DBT3 bits when printing DBT2 bits mistakenly. On Windows systems a stack trace in the module 'prSTAT_str' may be reported in the error log due to a storage access violation.
722591 Execution of a stored procedure sometimes raises message 10334, "Permission related internal error was encountered". The statement being executed involves many UNIONs selecting from derived tables based on a temp table and the server is configured for multiple tempdbs.
722620 Note to add to writeup of Error 241: If Statement Cache is active and contains a matching insert statement, an insert of a numeric value that would normally raise Error 241 during compilation of the statement will instead raise error 3624 "Truncation error occurred. Command has been aborted."

during execution of the statement.

722659 ASE reports a timeslice error with ksnetctlrPostWrite and ksmaskspost on the stack. Shared memory dump for the error shows a circular "Cancel Queue" leading to the timeslice error.
722673 The execution of the command "DROP PRECOMPUTED RESULT SET <prs_name>" on the primary database cannot be replicated into the standby database successfully.
722709 The values of the SharedLockWaitTime, UpdateLockWaitTime and ExclusiveLockWaitTime columns in the monOpenObjectActivity table are incorrect when the DBID, ObjectID and IndexID parameters are fully specified in a query on the monOpenObjectActivity table.
722767 The remote backup server name length for DUMP/LOAD commands has been expanded to support more than 30 characters.
722777 ASE does not respond and appears to hang when certain invalid packets are sent to it.
722778 When checking 'tempdbname' from sp_who or running tempdb_id() for a spid.

When a spid is a worker process of a utility command such as dbcc checkstorage,

the 'tempdbname'\dbid reported will incorrectly be that of the current spid's db context

executing the sp_who\tempdb_id. This does not indicate any issue with actual

temporary storage locations.

722801 Support is now provided for "high domain" (i.e. > 65535 unique values) parallel create index HASH based statistics gathering on minor attributes.
722823 Different behaviour for ISNULL on a MAX() or MIN() aggregate of a character column may be observed when statement cache is used with esql.
722856 In an HA environment when a role that contains a role activation predicate is dropped on

the primary server the secondary server does not remove the predicate metadata.

722867 On Windows machines having multiple network interfaces i.e. both IPv4 and IPv6, ASE may fail to boot Job Scheduler with error, "JS: Failed to connect on socket" whereas JS Agent log indicates that JA Agent is listening with message, "SYB_JSAGENT waiting for connection".
722898 Under some circumstances, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table." may be reported while a temporray is being dropped. Such temporary table is found to have a dlevel0cnt = 12.
722902 DDLGen generates data partition names instead of index partition names in the index partition clause for a clustered index on an all pages locked table . Also the semantic order of partitions in the index partition clause for both clustered and non clustered indexes is not correct.

Also if index partition names are system generated, then they are not generated in the partition spec , when -XPN option is specified

722910 doc cr: take out the "_" and add the "-i" in the command.
723015 The backupserver error message "3.27.2.1: Invalid RPC sequence at RPC as_cmd." followed by

"5.7.2.7: RPC ('as_cmd') execution failed." may be reported when a LOAD DATABASE is executed and the backupserver name "hostname:portnumber" cannot be resolved correctly.

723026 In rare circumstances, a stack overflow resulting in stack corruption may occur with a stack trace involving the modules 'XmlMallocFragment' and 'xml_malloc_fragment' when an XML query is executed with insufficent heap memory.
723098 A NULL result may be returned from select partition_id(table name, partition name) for a partitioned

APL table with a local clustered index.

723116 sp_sysmon spinlock contention values are incorrectly reported as zero.
723178 A new configuration option "ENABLE LARGE CHUNK ELC" is added to enable/disable large allocation auto tuning feature in engine local cache.
723200 FR: allow monitoring sprocs accessable to mon_role w/o license, ct can do it already with workaround.
723226 After changing the owner of a replicated user table while DDL is not setup for replication, RepAgent may replicate DML commands on that table using the wrong owner name.
723235 FR: read only proc plans for high concurrent sproc usage
723236 Feature request: a new tool for updating date-based versioning licenses across large installments.
723244 After downgrading from ASE 15.7 to ASE 15.5GA, when booting the ASE 15.5GA server, a segmentation fault may be encountered during start up while attempting to reconcile the downgraded configuration options.
723250 Granting an invalid permission to a user will cause the dataserver to print a stack trace and terminate the process.
723259 In rare circumstances, a task may hang when LIKE clause or patindex builtin operator is used on columns which contain LOB data marked as compressed.
723265 Hit error 806 when shrink database on APL table.
723268 When granular permissions is not enabled and a user has sso_role if the user tries to online a database error message 2736 will be raised.

When granular permissions is enabled a user with online any database privilege can not online a database.

723356 A segmentation fault in tally_fetch() after a 249 error may occur during BCP IN due to invalid column default. Previous CR number is 552227 and the fix is under trace flag -T2781. Please turn on the trace flag to check column default data type during table creation time.
723397 Signal 11 or timeslice error having idt_remove_all_reservations() in stack trace on 15.7 ESD2 ASE and up.

A possible workaround is:

Sp_configure 'identity reservation size',1

Sp_configure 'identity grab size',1

The workaround may have side effects including identity gap and performance impact.

723437 A new database option "deallocate first text page", and a new configuration value 2 of table

attribute "dealloc_first_txtpg", are provided for tables having TEXT/IMAGE/UNITEXT off-row storage

columns, to control whether to deallocate the first text page after updating off-row LOB value from

non-NULL to NULL, or whether to allocate a first text page when updating LOB value from NULL to

NULL.

723481 FR: allow db_maint aliased as dbo to replicate objects owned by users
723482 feature requesting a stored proc that will determine which devices hold the

extents of a given object.

723500 When using Replication Server with HVAR turned on and an update statement against a table on the primary causes non-updated in-row LOB datums to be moved off-row so the new data could fit in the target row, then the LTL generated by Rep Agent may be wrong, and replication may result in those datums being set to NULL on the replicate.
723566 The audit option sproc_perms can not be configured with sp_audit.
723588 Under certain circumstances, sp_monitorconfig 'number of locks' reports Max_Used as the total number of locks configured in SDC.
723602 A 156 error, "Incorrect syntax near the keyword 'default'" may be reported when executing ALTER TABLE MOVE PARTITION to 'default' segment.
723647 Adaptive Server Enterprise 15.7 ESD #2 - New Features Summary and Performance Tuning Guide describe "monLockTimeouts", but it should be "monLockTimeout".
723650 Doc: Request to include the change of the default value of "permission cache entries" from 15 to 64 to New Features Summary.
723672 An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbname>" may be reported when executing DBCC CHECKTABLE.
723731 FR: create new function 'current_utcbigdatetime()' and convert functionality for microseconds
723756 When hash based statistics gathering is used, the histogram tuning factor is not correctly reported by optdiag
723777 During installation, ASE Default Master/Tempdb Device Size is 0 on very large disks.
723847 SELECT INTO and INSERT SELECTs that use UNION statements terminated by a UNION ALL statement may fail with a signal 11 and stack trace that includes the module tree*GcElement::GcGetVar(). This tends to happen if the table being inserted into contains any identity columns that are not explicitly generated in the UNION ALL query.
723861 During ASE boot in "process" kernel mode, when configured with a high value for configuration parameter 'number of engines at startup', an engine fails to come online with 'ulinitspinlock' error.
723872 If there is an UNIQUE index with IGNORE_DUP_KEY option on a partitioned table with many partitions such as 60, the BCP loading performance of OLD DATA may be much slower than that of NEW DATA. NEW DATA means most rows of it will be loaded into the table. OLD DATA means most rows of it will be ignored because they have been loaded into the table.
723880 Column information is unnecessarily displayed when executing sp_help for an object that is not a view, system table or user table.
723882 When granular permissions is enabled a user can not online a database that needs an upgrade. The error message 969 will be displayed.
723939 "If you attempt to drop a partition from a table that is referenced by another table,

and the partition to be dropped and the referencing table are not empty, the command

fails because of possible violations with the foreign-key constraint, and Adaptive

Server displays error message 13971."

Msg 13971, Level 16, State 1:

Server 'UBUSAP', Line 1:

Could not drop partition with data from table 'p', because there are referential

constraints defined on the table and there are data rows in some of the

referencing tables.

1>

This is a feature request to extend the referential integrity checking to the alter

table command so as not to require that the parent table be empty when dropping a

partition whose rows have no dependant children.

723952 Wish to have upgrade in-place instructions from minor versions which include using the same $SYBASE as the customer is upgrading from.
723984 Additional diagnostics have been added for hash based histogram gathering under trace flag 2740.
723986 After 'reorg rebuild' or 'change lock' an empty table, the emptypgcnt of systabstats

becomes 0, which, however, should be 1.

724023 The message "current process infected with 11" in the module 'bufreserve' together with

a stack trace which includes the modules 'drop_al_dbid' and 'alterdb' may be reported

in the error log when an ALTER DATABASE LOG OFF command is executed to shrink this

database log space.

724074 If SET PROXY is used in a stored procedure, then an 4058 error "Login currently under set session authorization. It is required to go back to the original identity before performing another set session authorization." may be reported.
724175 The Remote Backup Server name is extended to allow the use of IPV6 hostnames with domain name.
724184 more Engine utilization with client cursor.
724292 load database with listonly=create_sql requires that "enable dump history" configuration parameter is 1.
724343 When configuring RepAgent to use a security mechanism, the RepAgent Thread may fail to start and report a 9210 error. Moreover, RepAgent is using the ASE server name instead of the ASE principal name.
724369 SELECT DISTINCT fails to filter out duplicate values from IDENTITY columns. (Duplicate values can be inserted through the use of SET IDENTITY_INSERT ON).
724423 When a new item such as a database is created, the new item is added in the Admin Console. However, the context menu for the new item shows the default menu that typically displays all the drop-down menu items. For example, the menu such as "Quiesce Release" should be disabled and "Online" should be hidden for the newly created database but these menu items are visible and enabled. This resolution corrects the context menu for the new database item in the Admin Console.
724424 The 15.7 ESD 2 P&T Guide description of the literal autoparam feature is still referencing the old limit of 16384 bytes on the size of cached statements. The limit was increased to 2MB in ESD 2.
724444 Some web methods added with OVERRIDE clause need to be re-added when ASE WS is restarted.
724472 In rare circumstances, recreation of in-memory databases during start up of SAP ASE may hang when there are more than one in-memory databases with the same template database. SAP ASE can still be used, but an attempt to use the in-memory databases that are not recreated will result in an error 962, "Database with ID '<value>' is not available. Please try again later." being reported.
724593 In some rare cases, a UNION query could return wrong result resulting in truncation.
724603 When executing a JOIN involving a proxy table, and the optimizer chooses GROUPINSERTING for the NESTED LOOP JOIN plan, the ordering information in the query is lost and the result is not ordered as expected.
724711 ASE installer should not force a shutdown of a remote license server started with lmgrd
724722 In order to retrieve the tag name from monOpenDatabases table, 'enable monitoring' configuration must be set and the user must have mon_role.

In ASEMAP 3.2.6 and 3.2.7, if the server is not configured for 'enable monitoring', user could not quiesce release the database. In this case, an error message is displayed in an error dialog box:

"Collection of monitoring data for table 'monOpenDatabases' requires that the 'enable monitoring' configuration option(s) be enabled. To set the necessary configuration, contact a user who has the System Administrator (SA) role."

In ASEMAP 3.2.8, it allows Quiesce Database Release to proceed by prompting for the tag name to quiesce release the database despite that 'enable monitoring' configuration is not set on the server.

724723 4 documentation errors have been found in New Features Summary Adaptive Server Enterprise 15.7 ESD #2.
724815 sp_config_dump stored procedure will now display usage information if invoked as sp_config_dump help or sp_config_dump 'help'.
724818 This fix addresses an issue which prevented customers from configuring SMTP in some environments
724822 write all upgrade SQL to the errorlog or enhance detailed output to sqlupgrade
724843 Signal 11 in OmniQuickPass::targetlist()could occur for SQL statement with subquery when show_transformed_sql is on.
724873 Feature request for a persistent method of binding DES structures to cache. i.e. similar to DBCC TUNE des_bind, but objects would automatically bind when first accessed after an ASE reboot.
724888 Documentation on DBCC TUNE des_unbind indicates the database must be single user. However, trying to use sp_dboption to set the database to single user mode will fail. The note just means that there can't be any other users in the database at the time. DBCC TUNE will itself temporarily set the database to single user mode if there are no users when it is run.
724959 When a database is loaded, the dump history file does not show any record for it and hence it is not possible to generate the dump sequence for this database.
724987 A 3475 error: "There is no space available in SYSLOGS to log a record for which space has been reserved in database <dbname>" may happen under rare circumstances along with the below message in the errorlog:"ERROR: Can't get a new log page in db <dbid>. num_left=<numlogrecords1> num_in_plc=<numlogrecords2>".
724988 doc feature: add msg 12324 to the troubleshooting guide
724990 In 15.x, under the default isolation level (Level 1), DELETEs/UPDATEs involving JOINs and/or correlated SUBQUERY could cause more number of exclusive locks to be acquired even when the qualifying number of rows are much less.
725001 merge statement leads to 2601
725017 The Thread Utilization (OS%) section of sp_sysmon on threaded kernel system is very wrong.
725065 DBCC SERVERLIMITS displays a wrong value for the limit 'Max database device size'.
725086 INSTRUMENTATION: ASE running under trace flag 7822 may lead to server hang.
725097 Signal 11 in rec_undo_session when cancelling queries involving temporary tables.
725140 In some rare cases, running queries involving SQLUDF could lead to stacktrace in cpysqludf().
725185 Optdiag reports incorrect sampling percentage for leading column.
725195 The monThread MDA table should list all ASE threads, however, on Windows platforms, the ASE clock thread is not listed in this table.
725209 ASE on Windows may report "LAST CHANCE EXCEPTION HANDLER on OS thread id <threadID> ...A SERIOUS UNHANDLED EXCEPTION HAS OCCURRED SERVER MAY NOT BE ABLE TO CONTINUE" with kcierrfmt() on the stack during shutdown when the server is forcefully shutdown, for example through CTRL-BREAK.
725211 ASE engines may start consuming 100% CPU which can result in ASE being unresponsive. New client connections may not also be possible.
725220 When there is no file named interfaces under $SYBASE directory, ASE WS will fail to start up.
725242 When multiple license servers are referenced in license files in the licenses directory 'sysam stop' attempts to shut down all of the license servers. A parameter should be added to only attempt to shut down the license server running locally on the host where the command is run. Note that remote license servers that are started via the 'sysam start' command can only be shut down from the same host, but license servers started via alternative mechanisms which don't specify the -local parameter to the lmgrd program can be shut down from remote machines.
725254 A 1865 error, "Altering database '' onto 'Invalid pointer param number 4, pointer value

0x0x1200000002' is not allowed because the database has mixed data and log segments."

may be reported incorrectly during the execution of CREATE DATABASE command as opposed to

"Altering database is not allowed because the database has mixed data and log segments."

725312 signal 11 in s_clean_encrkeys
725315 The VERIFY option for the DUMP and LOAD commands does not give the user any indication of whether errors were found or not. The errors are currently reported only in the backupserver errorlog.
725318 The dataserver gets a segmentation violation when dropping a login while the dataserver configuration for 'number of open databases' is less than the actual number of databases defined in sysdatabases. The segmentation violation is followed by a 905 error, 揢nable to allocate a DBTABLE descriptor to open database 'dbname'. Close or drop another database before opening this one, or ask your System Administrator to raise the configuration parameter 'number of open databases'�
725376 Hit error 806 when running shrink database and reorg defrag concurrently.
725389 Feature Request to maintain version numbers in the Sybase Central ASE plugin jar file.
725454 When using create a new index with an existing index name, user will see the sql generated with incorrect ignore_dup_key parameter.
725608 When resource limits is activated and a maximum transaction elapsed time is set, in CHAINED mode, a transaction is not rolled back after the specified elapsed time limit is exceeded.
725661 The performance of the rollback of a skewed transaction, that is, a transaction that has bursts of activity separated by periods of inactivity, is unnecessarily slow.
725667 Miscellaneous enhancements to the performance of boot time, LOAD DATABASE and LOAD TRAN recovery including better performance in undoing long-running (incomplete) transactions i.e. those that have bursts of activity separated by periods of inactivity.
725669 New feature that reduces the amount of recovery time during LOAD DATABASE at the expense of increasing the time taken by DUMP DATABASE. Data that is changed while DUMP DATABASE is active is included in the dump so that the dump has more up-to-date contents. This is enabled using sp_configure 'optimize dump for faster load', <percentage>. Changed data is included in the database dump when the percentage of database data changed during DUMP DATABASE is more than <percentage>. This defaults to 0 in which no changed data is copied, and there is no reduction in the recovery time of LOAD DATABASE.
725677 Allow multiple dump stripes to use device "/dev/null".
725708 The KILL WITH STATUSONLY command has been enhanced and now provides information on the amount of log space scanned and to be scanned for a full transaction rollback. It differentiates different types of rollbacks, and reports a subset of information in cases where the rollback is not a full transaction rollback.
725714 A new feature request to avoid sysattributes look-ups for user defined role activation during login

processing.

725734 MDA: inconsistencies with monOpenObjectActivity counts
725767 On big-endian platforms, queries involving BIGINT columns in MDA tables may return wrong results.
725810 The message "current process infected with 11" in the module 'th_curunreservedpgs' together

with a stack trace which includes the modules 'LeRun' and 'exec_lava' may be reported

in the error log when a session executes a SELECT statement that uses the T-SQL function

"curunreservedpgs" while another session is in the process of extending the size of the current

database with ALTER DATABASE command.

725858 A 15095 error, "An invalid 'data row id' value was found in first text page of a text/image/unitext column." may be reported when running DBCC CHECKTABLE or DBCC CHECKDB on replicated Data Only Locked tables that have TEXT columns with values on forwarded rows.
725864 Improve "ddlgen" performance for generating ddl for schema objects
725872 Print extra information for home location of DOL forwarded rows in DBCC PAGE output.
725885 srvbuildres cannot configure ASE when the available free space on the disk is very large.
725914 When the stat gathering mechanism reverts to sort based stats (for any reason) in part

or in full, it would be very helpful in diagnosing what went wrong during an extended

maintenance window etc if we logged a message to the error log.

This could detail the object name and relevant column(s) and what has changed in the

stats gathering mechanisms.

We could also report if\when the resource granularity setting

has been hit and multiple scans have been issued for hashing multiple columns.

725956 If a previous Job Scheduler configuration failed, syconfig.exe and sybatch.exe do not re-install the ASE-15_0/scripts/installjsdb script in a rerun.
725998 Running ins_syn_sql on a 2K page ASE may lead to the log segment being full.
726003 In the cases of extreme heavy loading, it is possible that CREATE CLUSTERED INDEX in parallel on a big table causes a small volume of data to be lost.
726004 On Solaris SPARC, HP-UX and AIX systems an incorrect result may be reported when executing sp_tran_dumpable_status <dbname>.
726032 'usedb_user' is included in users list and group public when granular permission is turned on.
726092 The file permissions are not as expected for database devices, the errorlog and the configuration

file on the Microsoft Windows platforms.

726158 Under some rare conditions, a query using a NESTED LOOP JOIN in an OUTER JOIN may encounter a signal 11 followed by a stack trace that contains the module LeSarg::mapSarg().
726160 Load database command with listonly=create_sql may show an unknown_device in the listed create database command after you shrank one of log devices on the database.
726224 FR: "des_greedyalloc" setting on the table should be recognized by sp_chgattribute & viewable via sp_help.
726234 A timeslice error followed by a stack trace that includes the module rvm_dispatch() may be reported when show switch or any server-wide statement is executed in stored procedures.
726357 Fixes issue associated with Auth dialog no longer enabling OK button on first character of password
726378 dbcc sqltext may fail with an infected with 10 in function oh_printsql.
726379 A 11051 error, "ALTER TABLE '<table_name>' failed. Table is currently being used by one or more other tasks." may be reported when a REORG REBUILD command is run while another process concurrently runs a SELECT query on the same table at isolation level read uncommitted. Following this error and while the SELECT query continues to execute, any process that attempts to reference this table will fail mistakenly with an error such as 17461 "Object does not exist in this database.".
726439 Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur.
726480 Documentation for 'dump configuration' command is incorrect. It is missing 'to' clause to specify directory (which needs to be in quotes).
726551 DDLGen does not extract DDLs correctly when stored procedures are grouped.
726601 Load database command with listonly=create_sql may show an unknown_device in the listed create database command after you shrank one of log devices on the database.
726760 sp_helpsegment reports wrong used_cnt after shrink database.
726763 The command ALTER DATABASE LOG OFF can result in the error 5057 ("The free space counts for the log are incorrect ...") being raised if the database has been loaded from a database dump where the command ALTER DATABASE LOG ON was run initially to extend the log.
726770 In rare cases of extreme heavy loading, it is possible that BCP/SELECT INTO a big table might lose allocation page entries from the OAM.
726776 The message, "Current process infected with signal 11" followed by a stack trace that includes

the module altdb__clear_chunk() may be reported when executing SHRINKDB concurrently with sp_placeobject.

726852 doc cr: simply using a number, whether in quotes or not is incorrect for sp_downgrade_esd argument. Must be like "GA", or "ESD1" "ESD#1"
726863 On solaris, we support vxfs for ASE, but not yet for backupserver. The result is:

SYBMULTBUF ERROR: Failed to turn direct i/o on for database device

726864 The Signal 11 issue could be caused by memore corruption because of no any changes on a table with

five TEXT columns after upgraded from ASE 15 32-bit to ASE 15.7 64-bit.

726869 SCC Administration Console for ASE might not display large number of rows ( tens of thousands of rows) completely. This problem might occur when users are trying to expand a large result set message row to display say a list of large number of user tables.
726936 When I/O fencing is enabled, the server may fail to correctly fence the devices and start up.

Need environment variable SYBASE_MAX_MULTIPATHS to override number of paths iterated which should be set to 1 if PowerPath is enabled.

726957 The message "current process infected with 11" in the module 'ksct_startio' together

with a stack trace which includes the modules 'ra_init_rs' and 'ra__connect_server'

may be reported in the error log when the Rep Agent Thread attempts to open a new

connection to the Replication Server and a previous connection attempt has failed.

727071 With very large tables it is possible under rare circumstances for the sum total of all

the step weights of a domain in a column's histogram to be less than 99%. Optdiag input

of these statistics will fail.

This can happen when there are a large number (non-default) number of steps in the histogram.

727073 DDLGen does not generate DDLs of a logical key on VIEWs when using -TLK or -TV.
727123 Display Stat Wizard may fail with the error message, "Client password encryption fails".
727134 Reduce the use of MASTER..SYSDATABASES scans in order to avoid high SPINLOCK contention on "DEFAULT DATA CACHE" in some cases.
727186 ASE may report errors like "JS: failed to receive jsagent response" and "Job Scheduler Task lost its Agent connection". JS Agent terminates without any errors in the JS Agent log. If core dumps are enabled on the platform, a core file is generated from JS Agent that contains the function sybcsi_mem_free() on the stack.
727191 DBISQL Feature Request to allow sending multiple results to a single output file via the Export Wizard
727259 A 9284 error, "RepAgent(<dbid>). Cannot allocate <value> bytes of memory.

You may need to reconfigure the parameter 'replication agent memory size'

with more memory.", followed by a 9219 error, "RepAgent(<dbid>): Internal

coding error. Rep Agent Thread for database '<name>' (dbid = <value>) terminated

abnormally with error. (major 92, minor 19)" maybe be reported in the error log

if the Rep Agent Thread is recycled many times and compressed data is replicated.

727277 Auditinit may fail to add devices on space larger than 1 TB.
727310 The message "current process infected with 11" in the module 'th_curunreservedpgs' may be reported when a session executes a SELECT statement that uses the T-SQL function "curunreservedpgs" while another session is in the process of extending the size of the current

database with ALTER DATABASE command.

727364 java.util.regex.Pattern class not understood by ASE_JAVA JCS hard coded Sysxtypes entries. This is because specific class did arrive from Java 5. Staying KonaVM compliant specific layer was left untouched. There is a project defined under CR 651059 named JNI Isolation to dynamically generate and overlay Sysxtypes from the JRE when the JavaVM bootstraps. Short this functionality is not available yet.
727475 If the user is granted system roles indirectly through a user defined role, execution of sp_addthreshold fails with error message 10353 "You must have any of the following role(s) to execute this command/procedure: '<names>' . Please contact a user with the appropriate role for help."
727482 CONVERT( datatype not null, null) returns an undefined / arbitrary value rather than raise an error. While the behavior is documented, this CR is a request to consider whether it would be more appropriate to raise an error.
727484 A 17260 error, "Can't run sp_dbextend from within a transaction" may be reported when sp_dbextend is invoked in CHAINED mode.
727505 Feature request for the ability to run ASE Web Services on Windows as a Service.
727509 Generate new release packages for ASE 15.7 ESD#3 and later.
727514 feature request for higher hard limit configuring user-defineded role
727562 Feature Request: Option to set In-Memory Database (IMDB) as system tempdb
727597 Under deferred compilation or parallel processing it is possible when executing a procedure that the incorrect statement may be executed (one statement ahead of the correct one). The correct statement will be missed entirely, and the subsequent statement executed twice leading to wrong results or spurious errors.
727693 ASE task is stuck in global queue and not being scheduled
727762 Query with long IN list might cause stack corruption.
727816 sp_downgrade 'downgrade' will fail at step 990 with a 137 error, "Must declare variable '@show_'".
727846 The APFPercentage value in the monCachePool MDA table may report incorrect value.
727884 Downgrade to versions lower than 15.7 ESD#2 will not remove the predid column from sysprotects.csysprotects. sp_fixindex or dbcc reindex will not change the index to the pre 15.7 ESD#2 definition.
727887 Trace flag 364 support added for ASE 15.0 which uses the range density instead of the total density for optimizer costing when constant sarg values are unknown. Trace flag 16982 is created which uses the total density instead of the computed join histogram density. If trace flag 364 and 16982 are both set, then the sarg density will be used for the join.
728000 A 206 error "Operand Type Clash" with an INT4 datatype is raised by clients using parameterized SQL when statement cache is disabled but not when statement cache is active.
728027 In rare cases, the TRANSFER TABLE command may skip exporting an updated row if a target table is a Datapage or Datarow Locked table and it has forwarded rows or may hang up if a target table is a Datapage or Datarow Locked table and it has forwarded rows and large I/O buffer pools are configured.
728065 The 15.7 ESD 3 New Features Guide is missing from the infocenter webpage.
728081 In rare circumstances the Signal 11 occurs in OptPool::_PoolReclaimLegacyArray()

when executing the query with distinct and/or with WHERE IN long list of values.

728157 Auditinit may a core dump if the "LANG" environment variable is not set correctly.
728173 When inserting data into a table containing LOB columns and ASE happens to run out of log space, the message "Space available in the log segment has fallen critically low in database <dbname>. All future modifications to this database will be aborted until the log is successfully dumped and space becomes available" followed by a stack trace that includes the module logmodify() may be reported in the error log.
728201 Error 208 is raised when using sqldbgr on a server with multiple tempdbs when trying to access a temporary table. This happens when the sqldbgr process is assigned a different tempdb than the process being debugged.
728235 Fixes issue related to the workflow of the collection job wizard where the authentication page is not always skipped if already authenticated
728237 allow the logial table in the trigger accessible by the nested sprocs
728364 An 806 error, "Could not find virtual page for logical page <pagenum> in database <dbname>" may be reported when executing a stored procedure whose query plan is cached.
728419 DDLGen does not generate the partition name and segment information for a hash partitioned All Pages Locked table with a clustered index. Only the number of partitions are generated in the DDLGen output.
728430 Running UPDATE STATISTICS on an index containing non-materializing column may hit an error with a stack trace containing the modules stat_bld_row() and collocate().
728444 A 2601 error, "Attempt to insert duplicate key row in object 'sysattributes' with unique index 'csysattributes'", followed by an 11068 error, "Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.", may be reported in the error log during ASE startup in a Windows environment, if the configuration file has a 'Dump Configuration' section where the 'stripe directory' option is set to a value where backslash characters are specified.
728451 Error 839 was raised in a tempdb against 15.7 ESD1 Refresh #2 release:

"Error: 839, Severity: 21, State: 1, Grabbed buffer dirty but not writing:..."

728497 The message, "Current process infected with signal 11" followed by a stack trace that includes

the module init__data_vs_strategy() may be reported when running REORG REBUILD following which a DROP TABLE is executed.

728520 The normal wcpu value is between 1 and 65534. So expect error when executing dbcc tune('wcpu',0), but actually this command executed succeed.It's big-endian platform specific issue.
728528 Upgrade from 12.5.4 may fail at step 1564 with message 3606, "Arithmetic overflow occurred."
728563 In ASE 15.7 ESD#2 and above, under some circumstances, ASE may encounter signal 11 or timeslice error with a stack trace involving the module idt_remove_all_reservations() while cleaning up identity reservations assigned for specific object.
728592 When attempting to start Web Services using runws (runws.bat on Windows)

if the parameter for the ASE service (-S) is set to a name which does not exist

in the interfaces file the following error will be displayed in the webservice.log file:-

2013-01-04 14:49:32.561 FATAL [main] - IllegalArgumentException error has occurred: java.lang.NumberFormatException: null

And Web Services will fail to start.

728594 Update Web Services to use the 1.7 JRE supplied under $SYBASE/shared/JRE-7_0_1_64BIT

by default and document those changes.

728634 A 17879 error, "Only users that have System Administrator (SA) authorization granted directly may add, or modify thresholds in that database" may be reported if a user that has been granted sa_role indirectly through a user defined role executes sp_addthreshold in a database where the user is not the actual owner.
728719 DBISQL intercepts 'set showplan on/off' to only show query plans from user-issued query executions
728745 Case insentivive is not being considered when using hash partition
728752 At times in threaded mode, error messages in ASE error log describing errno can be misleading.
728753 A database dump from 15.5 taken using the "compress::" method fails to load

in 15.7 ESD 3 and the current nightly build. The same dump loads without error

in 15.7 ESD 2. The error raised is "Label validation error: first label not VOL1." The "with compression = " method does not encounter this problem.

728759 When the number of statements in the Adaptive Server statement cache is large (approximately 13,000 or more) a query on monCachedStatement may terminate with error 3621, "Command has been aborted".
728804 A procedure having SELECT INTO a temp table having UNION ALL and encrypted columns could result in wrong data in the target table and a subsequent SELECT from the table will result in a 15417: "An internal error occurred during a decryption operation (error code <n>). Please contact Sybase Technical Support." error.
728845 When attempting to migrate objects that may have storable comments such as PROCEDUREs, VIEWs, UDFs, PRE-COMPUTED RESULTSETs etc, if there are braces (curly brackets) within the comment section migration will fail with with a java.sql.SQLException. The same error will be observed if a curly brace appears anywhere in the proc DDL (search argument for example).
728894 ASE fails to install with Job Scheduler on roman8 charset.
728903 Under some rare conditions, if there is a HASH AGGREGATE operator above a JOIN operator, wrong query results may occur and it could also lead to data corruption.
728961 Error 207 may occur while running the sp_dboption stored procedure if quoted_identifier is turned on. This may also affect the Sybase Control Center Database Properties dialog by preventing the database options from being viewed or modified within Sybase Control Center.
728963 Fixed spelling abbraviation error, mesc (millisecond) to proper abbreviation: sec.
728979 The documentation for sp_dump_config should have a note that it does not support tape devices. The parameter @stripe_dir must be a file system directory, not an tape device.

If a tape device is specified, backupserver will raise the error "Volume validation error: failed to obtain device information"

728995 The "expired login" status bit in syslogins may be off even though sp_displaylogin indicates the password is expired. This is because the status bit is not set on until the first time that user attempts to log in after their password has expired. This CR is for a minor documentation enhancement to clarify the behavior of the status bit.
729022 For some special table names, REORG REBUILD and ALTER TABLE fail with an infected with 11 error on IdentifierType::IdentifierType.
729074 The message "current process infected with 11" in the module 'xact_beginupdate' together with a stack trace which includes the modules 'tmp_alldrop' and 'clean_process' may be reported in the error log when a task attempts to clean up its temporary objects while disconnecting.
729088 ASE on Windows crashes due to system exception (0xc0000005) generated by a storage access violation with error message "attempted write to memory location 0000000000000000 from instruction at location 0x0000000000000000". This issue only affects ASE on the Windows platforms.
729192 Deadlock may occur when SHRINKDB runs concurrently with REORG DEFRAG.
729204 Data Only Locked tables with placement index undergoing ALTER TABLE MERGE PARTITION may lead to index corruption with 696 errors.
729246 A new option WITH COPYONLY=<target_file_path> is added to LOAD DATABASE/TRANSACTION commands allowing to extract a DATABASE/TRANSACTION DUMP from a storage system and copy it into a local directory.
729284 ASE raises error 1703 with severity 10 although the documentation says the severity is 17.
729335 ALTER TABLE MERGE PARTITION may fail with error 14108 on a empty range partitioned All Page Locked table with a clustered index.
729373 During the execution of DUMP DATABASE if the "compress::" option is used and only one stripe is specified, ASE 15.7 ESD#3, 15.7 ESD#3.1 and 15.7 ESD#4 will ignore the compression option prefix, resulting in an uncompressed dump. Additionally loading a valid pre-15.7 ESD#3 compressed single stripe dump will fail.
729461 Columns with more than 65535 unique values, which also have some skewed values (i.e. represented as frequency cells in the histogram) could result in inconsistent histograms in which weights are outside the range of 0.0 to 1.0
729509 An 8201 error, "Keep count of descriptor was expected to be 1. Instead 0 was found" may be reported by the upgrade utility when upgrading from 12.5.4
729551 Load database is ignoring compress::<>:: syntax if single dump device.
729603 In rare cases, after the last chance threshold is crossed and the user executes DUMP TRANSACTION to free up log space, the last chance bit DBTH_LASTCHANCE will remain set in memory in DBTABLE, which will continue to cause processes to be suspended by the last chance threshold mistakenly.
729624 Cluster deadlock occurs when process allocating a new page holding LLOL waits on WAIT_FOR_BASTPENDING. This issue only affects ASE Cluster Edition.
729664 This PC-Client EBF is based on SDK 15.7 ESD#5. A list of changes in that SDK 15.7 ESD#5 is available at http://download.sybase.com/swr/16225/EBF20570_Buglist.txt
729666 upon recovery and rescan alloc page only if there are negative values.
729715 While displaying a large number of User Tables or Proxy Tables in Administration Console of an ASE server, the UI might be hung. Navigation within the Monitoring view and Administration Console is not responsive .
729766 A new configuration value of '2' is added to configuration option 'enable xml' for external entity reference in XML documents, ie, set "sp_configure 'enable xml', 2" for external entity reference in XML documents.
729795 The incorrect message "The dump configuration '<value>' supplied for SELECT is invalid. The change is completed. The option is dynamic and ASE need not be rebooted for the change to take effect." may be reported by sp_config_dump with an option that is longer than the supported length.
729919 In very rare situations where incorrect port number is specified for sp_listener, subsequent calls to sp_listener might fail.
729937 Enhancement is made to reduce the use of MASTER..SYSDATABASES scan for better performance when accessing tables in other databases.
729957 A 2626 error, "Illegal attempt to insert duplicate key row in the clustered index partition

database <dbname>, object <objname>, index <idxname>, partition <ptnname>" followed by a stack trace involving the module indinsert() may be reported when inserting and deleting duplicate key rows in the clustered index partition for All Pages Locked table numerous times.

729984 getpass.exe which is utilized in Web Services on Windows only, is currently not compatible with x64 platforms. This issue only affects ASE on the Windows 64 platform.
730051 When REORG REBUILD WITH ONLINE is running in parallel with DMLs, DMLs may fail with a 540 error - "Schema for database object '<name>' has changed since compilation of this query. Please re-execute query.".
730070 When running sp_downgrade with @override = 1 for a SDC server, ASE will raise error 969 for attempting to access local temporary databases from non-owner instances.
730082 DBCC REINDEX has been enhanced to provide a new option (option value: 32) to drop suspect replication indexes only. The syntax is DBCC REINDEX (tab_name | tabid , 32)
730153 Execute immediate on sp_configure does not return result for 1 row result set.
730154 Increase the number of expressions allowed in an ORDER BY clause.
730164 When shrinkdb try to move pages from 256, it may hit error 691 like this:

Encountered invalid logical page '0' while accessing database 'tdb1' (4), object

'sysdams' (58), index 'sysdams' (0), partition 'sysdams_58' (58).

730183 Extended stored procedures added using sp_addextendedproc are malformed leading to failure of the extended stored procedure. sp_helpextendedproc shows an extraneous '[' character in the DLL name.
730215 The message, "Current process infected with signal 11" followed by a stack trace that includes

the modules d_deleteplan() and proc_plan_get() may be reported in the SAP ASE errorlog when executing DBCC DELETEPLAN.

730276 The Backup Server error message indicates that there is RPC parameter count mismatch between ASE 15.5 and Backup Server 15.0.3.

The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE.

730280 12308 error with delete or update against table in a query with distinctness e.g. joining to a distinct view or distinct derived table, and exists subquery, a union view or union in a derived table.

changes associated with optcriteria cr669847 are enabled by default, but previous behavior (i.e. turn on fix only if optcriteria cr669847 is on) can be obtained by using trace flag 16987

730281 The sense of Trace Flag 7773 has been inverted. Use of Trace Flag 7773 now disables the fix for CR 653511, which is on by default, ie, if a stored procedure undergoes recompilation, and the procedure makes assumptions regarding the session's state (ie session environment settings), the resulting recompiled plan can be significantly different than the original. This fix is now disabled when Trace Flag 7773 is on.
730354 sp_sysmon can return incorrect CPU metrics.
730437 Signal handler diagnostics have been added for the JS Agent process. Fatal signals are now logged in the JS Agent error log.
730503 An update of a view that has an INSTEAD OF trigger can cause an infected with signal 11 stacktrace in function copy_one_resdom() if the update assigns values to local variables.
730608 ASE might report the 225 error that some query--referenced object cannot be dropped during query optimization in sp_sysmon_kernel_threaded when running sp_sysmon in parallel.
730656 Cache bindings may be ignored if a 'strict' database recovery order is specified.
730673 The PCI Memory management layer is enhanced to better service memory allocation requests for ASE tasks executing JAVA operations. The layer now makes a better decision from where to allocate the requested memory. It either uses the PCI Fragment memory pool for end-user coded objects, or the O/S system run-time for JavaVM internal operations.
730730 Enable auto restart of the Job Scheduler after an abnormal Job Scheduler shutdown.
730758 FR: SSLv3.0/TLSv1.0 Protocol Weak CBC Mode Vulnerability port 8283/tcp over SSL
730782 Doc cr: let's fix this odd example usage of sp_configure sp_countmetadata for "number of open partitions"
730787 CREATE LOGIN does not check if the login name already exists before calling sp_extrapwdchecks. This can cause sp_extrapwdchecks to update information stored for the existing login.
730788 Feature Request: change the traceflag to a more user friendly optcriteria, and give users the ability to change the switchable status of deferred compilation on/off at the session level without sa_role/sso_role

set deferred_compilation {on | off}

730807 While using the partition_name builtin on multiple objects, the active objects could be recycled resulting in an information message, "Increase the config parameter 'number of open partitions' to avoid descriptor reuse. Reuse may result in performance degradation" being printed in the ASE errorlog.
730815 ASE crashes in scl__reuse_cred
730831 sybcluster: create cluster complain release not exist when just no permission
730901 Infected with 11 in fix_multiref() occurs when literal autoparam is on and stored procedure executes a SELECT statement that contains a complex ORDER BY clause.
730906 Isolation level 0 queries occasionally fail with errors when REORG REBUILD WITH ONLINE is in progress concurrently on the same table.
730938 There are two problems fixed in this resolution

1. Logical devices such as the one created by sp_dumpdevice are shown in the Database Devices view.

2. Archive database is displayed in the User Databases view for SDC server.

730953 The global variable @@tranchained shows inconsistent value when "SET CHAINED ON" is executed in the login trigger.
730962 When running installhasvss, an error message indicating that it has 'failed to locate the sybsecuritydb' is hit.
730982 When downgrading from 15.7 SP100 to a lower version, a 943 error will be raised when booting the server with the lower version and a stack trace will be encountered when running installmaster.
731023 Relax restriction when we Msg 3193 in relation to alter database <database> off <device_name> the load transaction.
731026 Certain stored procedures created with "execute as caller" may encounter errors at execution time.
731065 DUMP DATABASE is getting a inappropriate warning message about DUMP TRAN with truncate_only
731079 The number of unreserved pages may be incorrect after LOAD DATABASE has been executed if the database dump is from an older ASE version and it contains a large number of tables, each having multiple partitions.
731137 New Feature: Maintenance mode for databases which can be applied when databse is in use.
731171 An arithmetic overflow error may be reported by the function sp_f_getval when sp_spaceused is executed against large tables.
731179 The recovery redo pass unnecessarily attempts to fix problems with deallocations and reservations for some committed transactions in cases where there was a long-running transaction at the time of the last checkpoint.
731180 Upgrading ASE can cause Web Services to fail to boot
731193 Job scheduler upgrad sometimes hit this error failing Job Scheduler to boot :

"Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state"

731305 PC Client installer first screen says ESD#2, but should say ESD#4
731354 A signal 11 occurs in the function collectMonCSInfo when a query is executed on the monCachedStatement MDA table and the statement cache contains a statement that was created with a user-defined optimization goal.
731372 On tables with indexes, heavy insert activities can lead to 1295 errors, "Unconditional lock request for table or page was made while holding a latch".
731424 Instrumentation: ERP upgrade from 15.7 ESD#3 to 15.7 ESD#4 fails in R3load due to client connections timing out. This instrumentation captures timestamps of major login phases to identify if the timeout is caused during login and which module is introducing the delay.
731437 DUMP DATABASE with verify[=header | full] options and LOAD DATABASE with verify[only][=header | full] options commands have been enhanced to detect a mismatch between the page header and tail timestamps for Data Only Locked tables.
731468 sp_versioncrack returns NULL as ESD, with new ASE version strings.
731531 Enhancement is made to use less SYSTYPES scans when creating table.
731617 When DUMP DATABASE or DUMP TRANSACTION is run to a tape device, if the tape device configuration file 慴ackup_tape.cfg� exists, ASE will not be able to read it and the dump will fail. The Backup Server will report the error, "The format of the device configuration file <$SYBASE>/backup_tape.cfg is invalid. Remove the configuration file and reconfigure the device by issuing a DUMP with the INIT qualifier. Return code = 0".
731644 Doc CR: remove arguments codepoint and debug from the ref manual section on the sp_shmdumpconfig. Also, add comments on dbcc.
731718 When a character set conversion is required for very long string input (> 255 character), for example converting client Windows code page 1252 to a server using code page 850, if the input string had a character unconvertible to the server character set, the connection would be inappropriately killed (with a stack trace), in addition to the issuance of the server conversion error message.
731753 If ALTER TABLE is used to add a NOT MATERIALIZED column <c2> with a default, then another nullable column <c3> is added to the table and REORG REBUILD the table, a query to the table will also assign the default to the column <c3>.
731758 When executing UPDATE STATISTICS with an object name that contains unusual characters, the command may fail with an internal error.
731769 In case of an exception, SAP ASE hits an error 1265 while aborting / rolling back the transaction.

Abort or rollback of the transaction may happen because of some internal / external error.

Error: 1265, Severity: 20, State: 1

An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family.

731783 The message, "An internal memory management error has occurred. Error code: Invalid slot id.", followed by a stack trace involving the modules mda_exec() and mda_populate_monTask() may be reported when querying table monTask with clause KTID=0.
731808 If a LIKE predicate is used, then optimizer estimates for keys for a limiting index scan may be incorrect if a VARCHAR variable is used for the pattern match. This is especially true when there are no pattern matching characters used e.g. r.a LIKE "ABC". optcriteria CR731808 can be used to correct the optimizer estimate issue. Command line trace flag 16965 will also enable the fix.
731818 The Backup Server is enhanced to perform consistency checks on All Pages Locked (APL) and Data Only Locked (DOL) data pages during DUMP DATABASE execution. If an error is detected on a page, the page is reread for validation. These checks will be performed if DUMP DATABASE is executed using WITH VERIFY option. Alternatively, start up the backup server with boot time trace flag -D64, or use the run time trace flag SYB_BACKUP...qatraceon 8, to enable these checks by default.
731874 A 15432 error, "A validation check failed when Adaptive Server decrypted an encryption key. This error may indicate an incorrect password" is raised when a user with login association of a key executes a stored procedure that accesses a column that is encrypted with the key.
732011 In rare cases a process attempting to cache a statement in the statement cache may fail with an

infected with 11 in sqt_deallocate().

732064 The message, "Current process infected with signal 11", followed by a stack trace that includes

the module ptn_get_aphintpage() may be reported when executing a CREATE INDEX or REORG REBUILD command.

732131 Recovery may raise a 3474 if DBCC SET_IDENTITY_BURN_MAX was used to reset a columns identity value to 0 when it was already set to 0.
732185 An ALTER TABLE command issued on a partitioned table where the partition degree is greater than the user's parallel degree may result in various failures.
732227 Certain stored procedures when executed repeatedly may result in a signal 10 or signal 11 in the functions rvm_clean_pcrtree(), proc__setdb_pcr() or rvm_fetch_attr(). In some cases error 10350 (Permission related internal error was encountered. Unable to continue execution.) is also printed in the errorlog.
732231 When a table has been created with partition conditions these will create compiled objects

whose source text is stored in syscomments.

If the conditions are non-standard dateformat, then when these conditions are re-created

from text under a different dateformat. (which will happen after upgrade or via

upgrade_object) it is possible for a 247 error to be raised and a stack trace to appear in

the error log in function name s__recrtPtncond(), the session will be terminated.

732258 DBCC UPGRADE_OBJECT with the "check" option may raise bogus 11031 (Execution of <type> <name> failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate <name>) errors on every object checked after it encounters an object with an actual error.
732318 If running with server-level 'deferred name resolution' = 1

then running the command:-

set deferred_name_resolution off

from a session will not function and it will behave as if it were still enabled.

732329 Under some rare conditions, a 4720 error "Cannot truncate table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table" may be reported if auto_temptable_stats is turned on.
732385 The message, "Current process infected with signal 11" followed by a stack trace that includes

the module VTABRemoteAccess() may be raised when accessing a proxy table materialized at procedure whose name starts with a '$'.

732393 An 804 error, "Unable to find buffer <buffer address> from cache <cache name> holding logical page <page number> in sdes <sdes address> kept buffer pool for object <table name>", may be reported when inserting data into TEXT/IMAGE/UNITEXT columns.
732406 sybmigrate does not preserve indexes in the indexid order.

--EOF--

  • 本文链接地址:http://www.sybrepair.com/sap-ase-cr-number-7.htm
  • 本文为dbainfo个人原创,请在尊重作者劳动成果的前提下进行转载;
  • 转载务必注明原始出处 : Sybase数据库技术,数据库恢复专家
  • 对《SAP Adaptive Server Enterprise的所有已知BUG列表(7)》有何疑问或见解,请在本文下方发表;
  • 对网站还有其他问题或建议,请提交在留言板,谢谢!
  • 目前还没有任何评论.
    :wink: :twisted: :roll: :oops: :mrgreen: :lol: :idea: :evil: :cry: :arrow: :?: :-| :-x :-o :-P :-D :-? :) :( :!: 8-O 8)