远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着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信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:670889
CR Number:   670889
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Fixed
Description
Cosmetic issue



In a XML model, the Orientation display preference options are misaligned.



To reproduce:

1) open a XML model

2) select Tools\Display Preferences

3) Select General setting and General tab

Note: for the Orientation section, the Horizontal option appears to centered vertically and the Vertical option appears to be set to 'Bottom'



CR:670907
CR Number:   670907
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2011 Fixed
13 Jul 2011 One-off Provided
21 Jul 2011 Fixed
26 Sep 2012 Fixed
Description
ASE may crash unrecoverably with signal 11 in ct_poll when a connection to a remote server

running an SQL query is killed.
Workaround Description
 Possible workaround is to adjust the 'cis connect timeout' or 'cis connection timeout'

values to alleviate any race conditions.



CR:670973
CR Number:   670973
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2011 Fixed
27 Jul 2011 Fixed
08 Aug 2011 Fixed
09 Aug 2011 Fixed
Description
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.



CR:671049
CR Number:   671049
Product Name:   Adaptive Server Platform_Specific Docs
Product Component:   Installation Guide for Linux
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2011 Presently Not Targeted For Any Future Release Of This Product
Description
sp_sysmon I/Os Delayed by is not reported correct for linux 64 bit platform.



CR:671084
CR Number:   671084
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
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.
Workaround Description
 Try to apply trace flag 655.



CR:671096
CR Number:   671096
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2013 Insufficient info provided
Description
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)



CR:671101
CR Number:   671101
Product Name:   XML Model
Product Component:   XML Model
Status:   Open
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
For a new XSM, the default code format is Mixed Case; suggest it should be Upper CamelCase, to avoid generating tag names with underscores



CR:671104
CR Number:   671104
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2011 Not a Bug
Description
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



CR:671105
CR Number:   671105
Product Name:   XML Model
Product Component:   XML Model
Status:   Closed
OS:   all
Original Version:   chambord
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2011 Duplicate
Description
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



CR:671131
CR Number:   671131
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2011 Fixed
Description
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.



CR:671152
CR Number:   671152
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
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.
Workaround Description
 (1) Set "trunc log on chkpt" to the database option if possible.

You can not set this db option to master database.

(2) Remove user-defined thresholds if possible.

(3) Run a dump transaction command with truncate_only manually and periodically.



CR:671228
CR Number:   671228
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 CGA Drop#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2011 Presently Not Targeted For Any Future Release Of This Product
27 May 2011 Fixed
01 Jun 2011 Fixed
03 Jun 2011 Fixed
Description
ASE running on Linux platforms with batch I/O enabled (which is enabled by default) could hit timeslice errors in the module basis_flushbatchio().



CR:671238
CR Number:   671238
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2012 Fixed
10 Feb 2012 DEFER
31 May 2012 Fixed
30 Jan 2013 One-off Provided
16 Apr 2013 Fixed
Description
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.



CR:671337
CR Number:   671337
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2011 Fixed
Description
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.
Workaround Description
 Boot the server with trace flag -T1623



CR:671370
CR Number:   671370
Product Name:   Adaptive Server Generic Docs
Product Component:   Transact-SQL Users Guide
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2014 Added to user documentation
Description
Correct Documentation for exp_row_size and it's maxlen and minlen value.



CR:671405
CR Number:   671405
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Generic
Original Version:   3.1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2011 Fixed
Description
Authentication error message does not clearly specify that something might be wrong with the host name or port number of the registered ASE resource.
Workaround Description
 Right mouse-click on the resource and bring up Properties. Left mouse on connection. Change the appropriate connection property and press apply. Then go back to the perspective and try and authenticate the server again.



CR:671418
CR Number:   671418
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.7 Drop#3B
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2012 Bundled Request
Description
Adaptive Server running in threaded mode with a single client that is doing heavy i/o workload can incur response time performnce loss.
Workaround Description
 Adaptive Server performs best when it runs on as few physical processors as possible.

If your host has four processors, but Adaptive Server only requires

one processor of power (including all of its cores), consider binding the dataserver process to that processor.

Similarly, if Adaptive Server needs two processors of power, consider binding dataserver to

two specific processors rather than allowing the operating system to schedule it between all four processors.

You can do this using the numactl command, the taskset command, or the cgroups (control groups) feature.



For example, to start Adaptive Server such that it will only run on processors 0 and 1, numactl can be used:



numactl --cpunodebind=0,1 startserver -fRUN_server



CR:671436
CR Number:   671436
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2011 Fixed
11 Dec 2011 Fixed
Description
Job Scheduler runs a job multiple times over a minute under some situations.
Workaround Description
 Use repeats=1d

exec sybmgmtdb..sp_sjobcreate 'sname=SAP_SCHEDULE_ATM_W3', 'sdesc=SAP ATM Window 3,days=Thursday,repeats=1d,startdate=2011-05-19,starttime=11:30'



CR:671437
CR Number:   671437
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2011 Fixed
03 Jun 2011 Reservation Made
29 Jun 2011 Fixed
Description
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.



CR:671439
CR Number:   671439
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to implement an option to stop sp_helpsort consuming transaction log on master.
Workaround Description
 Run dump tran master with truncate_only after sp_helpsort.

Or setup threshold.

Or comment out the line calling sortkey(null, "all") in sp_helpsort if acceptable.



CR:671440
CR Number:   671440
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2011 Fixed
07 Jun 2011 Fixed
16 Jun 2011 Fixed
01 Jul 2011 One-off Provided
13 Sep 2012 Fixed
Description
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.
Workaround Description
 1. Avoid that "dump tran" captures placement index creation i.e run

"dump database" each time a placement index is created.



or



2. During the load sequence, disconnect and reconnect to ASE between

"load database", each "load tran" and "online" commands. (This workaround

may or may not apply depending on how many 'create placement index' commands

are captured within a single transaction dump : it won't apply if

the same transaction dump contains 2 or more 'create placement index'

in a row, each of those causing btree splits)



CR:671536
CR Number:   671536
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.0.2 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2011 Fixed
30 Jun 2011 One-off Provided
20 Sep 2012 Fixed
Description
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.
Workaround Description
 When running the query under optimiser level ase_default, the option 憉se_mixed_dt_sarg_under_specialor should be turned off.



CR:671569
CR Number:   671569
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Be able to only send sql statements for a table while other tables do not replicate sql statements.
Workaround Description
 currently none because although you can set up sql statement replication by table (sp_setrepdefmode), one has to exceed the threshold. Therefore a statement has to affect a minimum of 2 statements for the sql statement to be run.



CR:671592
CR Number:   671592
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2011 Fixed
11 Jul 2011 One-off Provided
28 Jul 2011 Fixed
20 Sep 2012 Fixed
Description
Lots of concurrent logins may result in error 290024 and stacktraces during ASE authentication.



CR:671598
CR Number:   671598
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2011 Fixed
31 May 2011 Fixed
01 Jun 2011 Fixed
Description
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.



CR:671752
CR Number:   671752
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2011 Fixed
27 Jun 2011 Fixed
27 Jun 2011 Fixed
Description
Truncation od text at the Data Cache Manangement section causes spinlock contention information not to be reported by sp_sysmon.
Workaround Description
 Use the script of 'sp_sysmon_dcache_dtl' from ASE 15.5 ESD#2



CR:671764
CR Number:   671764
Product Name:   ASE Management
Product Component:   Web Console
Status:   Closed
OS:   Windows XP Pro
Original Version:   3.2.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2011 Fixed
Description
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.



CR:671788
CR Number:   671788
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   Windows XP
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#1 14 Nov 2011 Bundled Request
Description
When running dbisql from pcclient distribution, trying to use the import function, it is reported that the JDBC driver is missing.
Workaround Description
 modify the dbisql.ini file so that:



ADDITIONAL_CLASSPATH=<directory>\jconn3.jar



Note: jconn3.jar might not be in some distributions, get it from jConnect-6_0 directory in another distribution. Be sure to look for a copy of dbisql.exe that might be still running on the PC, even after you have exited the program. Kill it from the taskmgr and then attempt the workaround.



CR:671950
CR Number:   671950
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2011 Fixed
23 Nov 2011 Fixed
Description
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.



CR:671953
CR Number:   671953
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
slow bcp performance on linux platforms when using DIRECTIO for devices



CR:671997
CR Number:   671997
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2011 Not a Bug
16 Aug 2011 Fixed
15 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
On AIX, memory leak may happen when remote server option "net password encryption" is turned on.



CR:672040
CR Number:   672040
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
Description
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.



CR:672046
CR Number:   672046
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2011 Fixed
Description
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



CR:672144
CR Number:   672144
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2011 Fixed
Description
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.
Workaround Description
 N/A



CR:672181
CR Number:   672181
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2011 Fixed
12 Jun 2011 Fixed
Description
Backup Server: On 64-bits Windows platforms, dumps to existing files do not reset the file size when the dump size is less.
Workaround Description
 Remove larger files before running dump.



CR:672196
CR Number:   672196
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2011 Fixed
Description
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.
Workaround Description
 set merge_union_distinct off



CR:672255
CR Number:   672255
Product Name:   Adaptive Server Enterprise
Product Component:   MDA/Monitoring Tables
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2012 Fixed
27 Sep 2012 Fixed
08 Oct 2012 Fixed
Description
In some circumstance, the CPU usage of ASE might increase to near 100% after turning on the 損lan text pipe active option.



CR:672395
CR Number:   672395
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UNIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2012 Insufficient priority to fix
Description
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.
Workaround Description
 Increase stack size.



sp_configure "stack size", n



CR:672446
CR Number:   672446
Product Name:   Adaptive Server Enterprise
Product Component:   syconfig
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2011 Fixed
26 Aug 2011 One-off Provided
28 Sep 2011 One-off Provided
25 Oct 2011 One-off Provided
02 Nov 2012 Fixed
Description
After entered the ASE login/password in the login dialog to configure the existing ASE, syconfig crashed.



CR:672597
CR Number:   672597
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
In rare circumstances, the error 614, Severity: 21, State: 7 might raise when executing

a stored procedure and UPDATE a temp table.



CR:672606
CR Number:   672606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3A
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2013 Bundled Request
Description
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.



CR:672733
CR Number:   672733
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2012 Presently Not Targeted For Any Future Release Of This Product
29 Mar 2012 Fixed
30 Jun 2013 Fixed
18 Jul 2013 One-off Provided
18 Jul 2013 One-off Provided
Description
A 820 error may be raised when executing BCP-IN with all INSERTSs that causes duplicate key errors during aggressive HOUSEKEEPER garbage collection.
Workaround Description
 Don't use 'enable housekeeper GC' = 4



CR:672829
CR Number:   672829
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2011 Fixed
08 Jul 2011 Consult Complete
20 Jul 2011 Fixed
27 Jul 2011 Fixed
12 Oct 2011 One-off Provided
16 Nov 2011 One-off Provided
18 Sep 2012 Fixed
Description
There can be high spinlock contention on the ASE network memory pool spinlock.
Workaround Description
 Whenever the customer is not interested by DDL replication, the session can run "set proxy" cmd,

which cmd will bypass session password decryption.



CR:673130
CR Number:   673130
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2011 Workaround
Description
Sub optimal plan with ase_current related to view and more and 6 tables.
Workaround Description
 set cr606288 off

updating statistics, with a reduced sample set, seems to work.



CR:673156
CR Number:   673156
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2011 Fixed
Description
Missing brackets for bracketed identifier in abstract plan generation.



CR:673169
CR Number:   673169
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
14 Oct 2011 Fixed
17 Oct 2011 Fixed
18 Oct 2011 Fixed
Description
Msg 5893 prints wrong values while trying to increase the number of user connections.



CR:673179
CR Number:   673179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2011 Fixed
Description
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.



CR:673339
CR Number:   673339
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2012 Bundled Request
Description
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).
Workaround Description
 Load the database dump using the 3495 trace flag.



CR:673377
CR Number:   673377
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2011 DEFER
Description
Feature request to allow login triggers to set the sessions default transaction isolation level.



CR:673379
CR Number:   673379
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2011 Fixed
Description
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".
Workaround Description
 The customer can try to break the original query into two queries:



-- set 'select into' for a database

sp_dboption db_name,"select into", true

go



use db_name

go



create table #tt1 (a1 varchar(30))

go



select A.cusip AS T_cusip into existing table #tt1

FROM AbsCmoDb..Deal_new D

join AbsCmoDb..Tranche_new T on (D.dealId = T.dealId )

left outer join AgencyCmoDb..AlternateCusips_v_gk A on (D.dealName = A.dealName

and T.trancheName = A.trancheName)

where A.cusip = '464266AE5'

go



CR:673426
CR Number:   673426
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sybmigrate raises error about non existent index when one table has a text/image column
Workaround Description
 1) rename source table to have a short name.

sp_rename AuditLegalEntityAdditionalData,AuditL





2) ignore error, your table, indexes and data are migrated anyways.



CR:673434
CR Number:   673434
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2012 Consult Complete
Description
Sub optimal plan with ase_current related to 631416.
Workaround Description
 dbcc traceon(328)

set cr631416 off



CR:673487
CR Number:   673487
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2011 Fixed
29 Jun 2011 Fixed
26 Aug 2011 One-off Provided
Description
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.
Workaround Description
 Set tcf 15320 to enable N-to-1 order-preserving xchgs at the

risk of livelock scenarios in two-level xchg/group2psorted

strategies.



CR:673494
CR Number:   673494
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2011 Fixed
Description
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.
Workaround Description
 none - check that the entries are valid and the monitor server is up.



CR:673625
CR Number:   673625
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2011 Fixed
22 Jul 2011 Reservation Made
22 Jul 2011 Fixed
28 Nov 2011 One-off Provided
Description
Sub optimal plan with INSERT and/or SELECT INTO using an ORDER BY occurring when optcriteria avoid_bmo_sorts is on
Workaround Description
 use abstract plan



CR:673638
CR Number:   673638
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2011 Not a Bug
Description
Allow DISK INIT to avoid clearing all pages on a raw device



CR:673656
CR Number:   673656
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
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



CR:673663
CR Number:   673663
Product Name:   Adaptive Server Generic Docs
Product Component:   Utility Guide
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
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.



CR:673764
CR Number:   673764
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Control GA
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2011 Fixed
Description
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.



CR:673792
CR Number:   673792
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve disk diagnostic for OS and Batch IO delays for linux platform.



CR:673834
CR Number:   673834
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
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.
Workaround Description
 Temporarily add the 'proxy_server' while dropping orphaned proxy tables.



CR:673857
CR Number:   673857
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2011 Fixed
09 Aug 2011 Fixed
Description
Set SYBASE_TS_MODE=GLOBAL as the default behaviour of ASE for enabling diagnostic tool access to ASE by default.



CR:673971
CR Number:   673971
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2011 Fixed
21 Sep 2011 Fixed
Description
New monitor counters are added to the monEngine, monOpenObjectActivity and monOpenPartitionActivity MDA tables.



CR:674006
CR Number:   674006
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2011 Not a Bug
Description
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.
Workaround Description
 Run at a more restricted isolation level than the default isolation level



CR:674064
CR Number:   674064
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2011 Fixed
Description
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."
Workaround Description
 Remove status 512 from sysindexes.status. Then issue dbcc cacheremove() for the user object or

reboot the database or the dataserver.



CR:674110
CR Number:   674110
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DBCC checkcatalog reports errors after a view is created based on the xmltable() function.

The usertype field in syscolumns is not being set correctly.



CR:674188
CR Number:   674188
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2011 Duplicate
Description
Signal 11 in plc__flush during transaction dump load



CR:674199
CR Number:   674199
Product Name:   Adaptive Server Generic Docs
Product Component:   Adaptive Server New Features Guide
Status:   Closed
OS:   all
Original Version:   15.5 ESD #4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2011 Added to user documentation
Description
Linux Huge Page Support - platforms restrictions incorrect



CR:674225
CR Number:   674225
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.0.2 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2012 EOL'd version. Not to be Fixed.
Description
EBF 17426 one-off generate wrong stacktrace.
Workaround Description
 Generate nm output map and map to the correct function.

you have a nm here:

\\ecss\ts-cases\11674000s\11674902\nm_dataserver.ebf17426_gualala.txt



CR:674235
CR Number:   674235
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2011 Fixed
27 Jun 2011 Fixed
Description
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.



CR:674251
CR Number:   674251
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2011 Fixed
01 Aug 2011 Fixed
26 Aug 2011 One-off Provided
Description
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".
Workaround Description
 o Increase the "max parallel degree" to be at least one greater than

"max scan parallel degree". Although, you may want to increase this

even higher.



o Turn off traceflags 15331, 16970.



CR:674278
CR Number:   674278
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2011 Fixed
22 Jun 2011 Fixed
Description
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().
Workaround Description
 Turn off parallel optimization.



CR:674415
CR Number:   674415
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2011 Fixed
28 Jun 2011 Fixed
05 Jul 2011 Fixed
Description
ASE crashes with access violation exception in either spinobtain or uboalloc_from_engine



CR:674505
CR Number:   674505
Product Name:   Sybase ETL
Product Component:   other
Status:   Open
OS:   Unknown
Original Version:   4.9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Document that changing directory for logfiles (user data) can be done in userdata.conf



CR:674535
CR Number:   674535
Product Name:   Adaptive Server Enterprise
Product Component:   DBISQL
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2013 Fixed
Description
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:



CR:674587
CR Number:   674587
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using CE and backupserver are configured ROUNDROBIN, only local instance can start the backupserver automatically.
Workaround Description
 Start backup server on the remote instance.



CR:674601
CR Number:   674601
Product Name:   Adaptive Server Enterprise
Product Component:   InstallShield
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jun 2011 Third Party Problem
Description
installshield hangs forever on /usr/bin/which command in tcsh+
Workaround Description
 Do not install in tcsh+



CR:674607
CR Number:   674607
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2011 Fixed
08 Aug 2011 Reservation Made
16 Aug 2011 Fixed
11 Aug 2011 Fixed
10 Aug 2011 Reservation Made
16 Aug 2011 Fixed
Description
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.



CR:674622
CR Number:   674622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jul 2011 Fixed
Description
A query with a LIKE clause using a long LIKE term and having escape characters may return incorrect results.



CR:674627
CR Number:   674627
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2012 Fixed
18 Jan 2013 One-off Provided
18 Sep 2012 Fixed
02 Oct 2012 Fixed
Description
When a table is being replicated to a table that includes an additional IDENTITY, an error "AOP not found in getAopt" is raised.
Workaround Description
 Turn off SQL Statement replication:



sp_setrepdbmode <database>,'UDIS','off'

go

sp_stop_rep_agent <database>

go

sp_start_rep_agent <database>

go



CR:674632
CR Number:   674632
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2013 Consult Complete
30 Oct 2012 Reservation Made
30 Oct 2012 Fixed
31 Oct 2012 Fixed
Description
Enhance index scan perforamce on little-endian platforms if the index includes large mount of duplicated keys.
Workaround Description
 Make index unique, perhaps by including an identity column as an index key.



(update 11/09/11, JPMC modified their high duplicate nonclustered indexes via adding a existing unique value column id_tran to the indexes to make them become unique index)



CR:674645
CR Number:   674645
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2011 Fixed
01 Dec 2011 Fixed
02 Dec 2011 Fixed
Description
If a database has LOB compressed tables which stores compressed XML doc, DBCC CHECKDB may report 15960 error message for LOB compression issues.



CR:674764
CR Number:   674764
Product Name:   Adaptive Server Enterprise
Product Component:   backup server
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
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.



CR:674767
CR Number:   674767
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2011 Workaround
19 Jul 2011 Fixed
12 Jul 2011 Reservation Made
14 Jul 2011 Fixed
27 Jul 2011 Fixed
Description
Add new ASE configuration option 'enable console logging' to control console logging, with DEFAULT value of 0 to disable console logging after server boot.



CR:674877
CR Number:   674877
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2011 Fixed
25 Jun 2012 Fixed
Description
Performance issue on SELECT INTO from encrypted tables for non-privileged user.



CR:674890
CR Number:   674890
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2012 Fixed
05 Apr 2012 Fixed
Description
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.



CR:674926
CR Number:   674926
Product Name:   Adaptive Server Enterprise
Product Component:   Q Application Engine
Status:   Open
OS:   AIX
Original Version:   12.5.4 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RTDS: CPU associated with the Q engine always report usr+sys=100% by nmon on AIX only.



CR:675179
CR Number:   675179
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Fixed
06 Jul 2011 Reservation Made
12 Jul 2011 Fixed
13 Jul 2011 Fixed
Description
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



CR:675292
CR Number:   675292
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2011 Fixed
02 Dec 2011 Fixed
21 Dec 2011 Fixed
03 Jul 2012 Reservation Made
Description
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.



CR:675504
CR Number:   675504
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2011 Fixed
28 Dec 2011 Fixed
Description
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.
Workaround Description
 None except :



(1) live with it restarting each instance two times



or



(2) don't use a 32K bufferpool if a 4k pagesize



CR:675563
CR Number:   675563
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.7 Drop#3B Prelim
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2011 Fixed
Description
sp_configure/sp_helpconfig report 0 in Memory Used column for config

option "heap memory per user"



CR:675594
CR Number:   675594
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   15.0.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Duplicate
Description
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.



CR:675622
CR Number:   675622
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Open
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A new feature request for an option to fully allocate the tempdb devices at startup.



CR:675791
CR Number:   675791
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2012 Presently Not Targeted For Any Future Release Of This Product
19 Feb 2013 Fixed
Description
Enhance sp_rename stored procedure to rename data and index partitions.



CR:675990
CR Number:   675990
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   15.0.3 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2011 One-off Provided
14 Jul 2011 Fixed
22 Jul 2011 Fixed
25 Jun 2012 Fixed
Description
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."



CR:675995
CR Number:   675995
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2011 Deferred
12 Mar 2012 Fixed
08 Mar 2012 Reservation Made
Description
Enabling replication in a database can reduce the transaction throughput and can cause a high CPU usage.
Workaround Description
 Refer to the workaround possibility for CR 672829.



CR:675998
CR Number:   675998
Product Name:   Adaptive Server Enterprise
Product Component:   Job Scheduler
Status:   Open
OS:   Linux
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
JS doesn't print error message numbers to the JS log, only the message text



CR:676013
CR Number:   676013
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   15.7 Drop#3B RTC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2011 Fixed
Description
The MDS table monSysLoad may contain NaN,Infinity values for some statistics
Workaround Description
 Get the char value for the Infinity\NaN and use a conditional check to populate with null.



For example:-

insert into table (columns)

select case when convert(varchar (30),Max_1min ) = 'inf.0' then null else Max_1min end

,case when convert (varchar(30),Avg_1min) = '-nan.0' then null else Avg_1min end from monSysLoad



CR:676122
CR Number:   676122
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   all
Original Version:   12.5.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2012 Bundled Request
Description
ASE does not respond and appears to hang when invalid packets are sent to it.



CR:676148
CR Number:   676148
Product Name:   Adaptive Server Enterprise
Product Component:   Pluggable_JVM
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD #3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2011 Presently Not Targeted For Any Future Release Of This Product
12 Sep 2011 One-off Provided
03 Nov 2011 One-off Provided
17 Dec 2011 Fixed
02 Oct 2012 Fixed
18 Feb 2013 Presently Not Targeted For Any Future Release Of This Product
Description
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.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------