远程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:279309
CR Number:   279309
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Fixed
Description
Using BCP with packetsize larger than 32767 may fail on ASE running on the windows NT, Linux and Dec Alpha platforms.
Workaround Description
 use packetsizes < 65536



CR:279344
CR Number:   279344
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.0.104P1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.0 06 May 2003 Fixed
12.5.0.105P2 12 Jun 2002 Fixed
Description
ASE Replicator: Sporadically, text/image replication fails when running for a long time.



CR:279406
CR Number:   279406
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2002 Fixed
24 May 2002 Fixed
Description
A 551 error or the message "current process infected with 11" is reported in the error log together with a stack trace when a row is inserted into a table that has a rule which references a constant value which is outside the range of the column datatype.
Workaround Description
 Ensure range falls in datatype range. Alter
Create Rule R_ID AS @ID between 0 and 2000000000
to
Create Rule R_ID AS @ID between 0 and 200000000
or
exec sp_addtype 'T_ID','numeric(9,0)','not null'
to
exec sp_addtype 'T_ID','numeric(10,0)','not null'



CR:279474
CR Number:   279474
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2003 Fixed
Description
Check constraint expression shows name of the constraint along with the defination. This happens only when user changes the constraint name in the property page and applies the changes.



CR:279520
CR Number:   279520
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2002 Fixed
15 Jul 2002 Fixed
Description
When a connection is terminated while running Java, the message "Java services are temporarily unavailable while the Java system is being recycled" is reported in the error log and all other Java operations may be terminated so that no further Java operations can be performed. All subsequent attempts to use Java in ASE are rejected with a 10734 error.



CR:279558
CR Number:   279558
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2003 Fixed
13 Jun 2001 Presently Not Targeted For Any Future Release Of This Product
Description
CIS : Performance slows down when there are many idle CIS connections within ASE.



CR:279568
CR Number:   279568
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2002 Fixed
14 Jun 2002 Fixed
Description
The message "current process infected with 11" together with stack trace which includes the module 'jvmh_mem_p_sema' will be reported in the error log if a reference is made to a Java class before recovery has completed.



CR:279595
CR Number:   279595
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   SunOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2002 Fixed
24 May 2002 Fixed
Description
If the source ASE has large free spaces in the logical devices and runs Migration Tool in "setup" session, Migration Tool will throw the IndexOutOfBoundsException error in "CALC_DEVICE_SIZE" thread.



CR:279606
CR Number:   279606
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.0.0.3 18 Oct 2002 Fixed
26 Jun 2003 Fixed
Description
ASE 12.0 used to send back the actual table name in the row format information when responding to PowerBuilder. Now with ASE 12.5 the view name is sent back in the row format information instead of the actual table name and this causes PowerBuilder to try an update against the view instead of the actual table.



CR:279616
CR Number:   279616
Product Name:   ASE Replicator
Product Component:   DDBAdmin
Status:   Closed
OS:   Generic
Original Version:   12.5.0.103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.109P6 31 Jan 2003 Fixed
2.0.0 06 May 2003 Fixed
12.5.0.109P6 16 May 2003 Fixed
Description
ASE Replicator: During initial setup, an instance directory is created and RUNinstance scripts are generated. On Unix, the RUNinstance script also has its permissions changed to include execute permission. If there is a problem setting the permissions, an uninformative error message is returned, and the sp_helpddb.sql script does not get generated which causes problems later on. Now, the sp_helpddb.sql script is generated first, and, if there is any problem setting permission on the RUNinstance script, a warning is logged in the system.log, but setup completes successfully. The user will have to manually set the proper execute permissions on the RUNinstance script.



CR:279617
CR Number:   279617
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2004 Insufficient priority to fix
Description
A request to allow aliases to the real server name

to be used with kerberos network based security feature



CR:279641
CR Number:   279641
Product Name:   SybNotifier
Product Component:   Engine Processing
Status:   Closed
OS:   Solaris 2.5.1
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2002 Not a Bug
Description
This is a test
Workaround Description
 WA :



*** 05/15/2002 17:17:22 *** wkhan ***



CR:279816
CR Number:   279816
Product Name:   Sybase InstallShield
Product Component:   InstallShield
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2002 Fixed
3.1 21 May 2002 Fixed
3.0 21 May 2002 Fixed
3.0 21 May 2002 Fixed
3.0 21 May 2002 Fixed
3.0 21 May 2002 Fixed
3.0 21 May 2002 Fixed
Description
This just removes the conditional line that would only add a flatfileRepositoryXML if there hadn't already been one added. In this regard, we always add one now. This will be a problem if there are ever two instances of the RepositoryInfoPanel in a single Wizard Tree. Not very likely...



RepositoryInfoPanel:

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

-Removed all other references of the boolean.



CR:279855
CR Number:   279855
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Digital UNIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 EOL'd version. Not to be Fixed.
12 May 2005 Duplicate
Description
When a table in a DB2 DRDA Direct Connect has a VARCHAR column greater than 255, a SELECT statement that has a joins involving the VARCHAR column will fail.
Workaround Description
 none



CR:279862
CR Number:   279862
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2002 Fixed
Description
Incorrect limit of AND and OR in a query is returned in 404 error messege,

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



CR:279883
CR Number:   279883
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2002 Fixed
08 Jan 2003 Fixed
22 Sep 2002 Fixed
05 Sep 2002 Fixed
09 Jan 2003 Fixed
Description
Performance enhancements made to SELECT INTO by making use of large I/O and extent

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

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

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

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

this enhancement.



CR:279902
CR Number:   279902
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2002 Fixed
Description
The message "Msg 225, Level 16, State 1 Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization."

maybe reported when executing a SELECT INTO statement using

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



CR:279928
CR Number:   279928
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2002 Deferred
25 Sep 2002 Deferred
14 Jan 2003 Third Party Problem
Description
On the AIX platform, during situations of heavy I/O activity, ASE may report 823

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



CR:279964
CR Number:   279964
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2004 Duplicate
Description
Process hit on error 1295 and sometimes some processes are blocked due a 'latch sleep'



CR:279981
CR Number:   279981
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   11.9.2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2002 Fixed
15 Nov 1999 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstances, a 6902 error may be reported when recovering an aborted transaction at boottime or during LOAD DATABASE or LOAD TRAN, after an earlier stack trace was reported in the error log at runtime which included the modules 'terminate_process', 'hdl_default', 's_handle', 'ex_raise' and 'rec_undo_session'.
Workaround Description
 For the particular underlying cause for this customer (11.9.x), increase the no. of connections in order to increase the number of transaction descriptors.



CR:280035
CR Number:   280035
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2003 Fixed
31 Jan 2003 Presently Not Targeted For Any Future Release Of This Product
Description
In rare circumstances, a 2620 error may be reported during the reboot of Adaptive Server if it was terminated abnormally whilst LOAD TRANSACTION was in progress and it had recovered an index page split.



CR:280052
CR Number:   280052
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2004 Not a Bug
11 Nov 2005 Fixed
Description
A SELECT with an aggregate function containing a subquery on a proxy table mapped to a MS SQL Server table results in a 30291 error "Cannot perform an aggregate function on an expression containing an aggregate or a subquery."



CR:280073
CR Number:   280073
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2002 Fixed
10 Sep 2002 Fixed
Description
In rare circumstances, Adaptive Server may generate wrong results when executing extended stored

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

declaration list.
Workaround Description
 Change the following line in the repro :



from :



3. create proc xp_echo as external name "examples.so"





to :



3. create proc xp_echo @type varchar(05) as external name "examples.so"



CR:280089
CR Number:   280089
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   SunOS
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Aug 2002 Presently Not Targeted For Any Future Release Of This Product
02 Aug 2002 Fixed
04 Nov 2002 Fixed
13 Sep 2002 Fixed
13 Sep 2002 Fixed
13 Feb 2003 Fixed
Description
Under some conditions the optimizer may incorrectly assume that a scan is able to use I/O greater than 2K thus underestimating the cost of a plan.
Workaround Description
 1- create a named cache

2- enable sort-merger with sp_configure "enable sort-merge join and JTC",1

3 - change order of tables in the query



CR:280090
CR Number:   280090
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2002 Fixed
Description
ASE only sends out ENVCHANGE token when client is requesting a different character set from server's

and character set conversion is enabled.



CR:280099
CR Number:   280099
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2002 Fixed
26 Sep 2002 Fixed
Description
7411, 7417 or 7418 errors may be reported by DBCC CHECKCATALOG when checking a database that has a non-dedicated log and which contains user table extents in its log segment.
Workaround Description
 See CR description.



CR:280133
CR Number:   280133
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.0.0.6 11 Jun 2002 Fixed
12.5.0.2 18 Jun 2002 Fixed
Description
A stored procedure will sometimes be unnecessarily renormalized when it is run on a 32-bit server having originally been created on a 64-bit server.



CR:280148
CR Number:   280148
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2002 Fixed
Description
Executing a select textvalid(<image-column>) of a proxy table mapped to Oracle in a server configured for the utf8 charset caused a stack trace (current process infected with 11) in routine omni_parse_name.



CR:280177
CR Number:   280177
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Linux
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2004 Fixed
30 Jul 2002 Fixed
Description
The use of CIS connections with SSL is fixed on Linux 32bit platform.

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

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

Agent, Proxy Tables, and CIS RPC calls.



CR:280196
CR Number:   280196
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2002 Fixed
Description
User with "sa role" but without "sso role" can incorrectly execute

SP_ADDLOGIN, SP_DROLOGIN and SP_LOCKLOGIN stored procedures.



CR:280231
CR Number:   280231
Product Name:   Adaptive Server Enterprise
Product Component:   srvbuild
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2002 Fixed
Description
Added support to srvbuild for Linux ATARAID, RAID and LVM devices.



CR:280237
CR Number:   280237
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2002 Fixed
Description
Executing an ALTER DATABASE ... FOR PROXY_UPDATE command resulted in a stack trace (current process is infected with 11) in routine omni_parse_name when the server was configured for the utf8 character set and the remote server was Oracle.



CR:286067
CR Number:   286067
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2002 Fixed
18 Jun 2002 Fixed
21 Jun 2002 Fixed
Description
The automatic drop of a temporary table may sometimes fail with a 216 error together with a stack trace as a result of an incorrect 3702 error, "Cannot drop the table because it is currently in use".
Workaround Description
 N/A



CR:286077
CR Number:   286077
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2002 Fixed
05 Jun 2002 Fixed
Description
Setting the 'close on endtran' option in a session may result in error 559 or

102 when a SQL query involving proxy tables is executed.



CR:286078
CR Number:   286078
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2002 Fixed
14 Jun 2002 Fixed
24 Jun 2002 Fixed
25 Jun 2002 Fixed
10 Jul 2002 Fixed
12 Jul 2002 Fixed
31 Jul 2002 Presently Not Targeted For Any Future Release Of This Product
Description
255 error may be returned for a grouped aggregate query with space() or replicate() builtin function.
Workaround Description
 Drop the view and create view WITHOUT group by clause.

Use the "group by" clause in the "select" statement , instead in the "create view".



CR:286082
CR Number:   286082
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2004 Insufficient priority to fix
05 Feb 2004 Not a Bug
Description
A select query by a view referencing a proxy table fails with 4409 error

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



Status: Reviewed Sep 2002. Fix targeted (but not commited) to the 12.0.0.7 release.
Workaround Description
 Create view view_test2

as

select * from view_on_remote vl

where isnull((select count(*) from sysobjects so where so.id < convert(int,vl.b1 ),0 ) between 1 and 5

go



CR:286098
CR Number:   286098
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2002 Fixed
12.5.0.2 25 Jul 2002 Fixed
03 Oct 2003 Not a Bug
Description
The occurrence of SIGURG (typically as a result of old style pre TDS5
cancel command) may result in ASE hang.



CR:286136
CR Number:   286136
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Not a Bug
13 Nov 2002 Fixed
Description
Allow elapsed time resource limit to fire whether spid is issuing sql or not.





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



CR:286187
CR Number:   286187
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5/23 03 Jul 2002 Presently Not Targeted For Any Future Release Of This Product
10 Jul 2002 Fixed
Description
Create proxy_table command against ASA/ASIQ may sometimes change the order of columns.



CR:286191
CR Number:   286191
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2003 Fixed
22 May 2003 Fixed
10 Jun 2003 Fixed
12 Sep 2003 Fixed
22 Aug 2003 Fixed
27 Oct 2003 Fixed
27 Nov 2003 Fixed
Description
The login audit event is extended to contain additional information such as the IP address where the login attempt originated. This feature can be disabled using the command line trace flag -T7603.



CR:286346
CR Number:   286346
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Digital UNIX
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2002 Fixed
Description
Pre 12.5.0.3, on Digital True64 Unix, only synchronous i/o was supported for file system devices. In 12.5.0.3, asynchronous i/o on file systems is supported.



CR:286418
CR Number:   286418
Product Name:   SQL Remote for Adaptive Server Enterprise
Product Component:   Database Tools Interface
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.2 3473 28 Jun 2002 Fixed
8.0.1 3018 28 Jun 2002 Fixed
8.0.0 2317 28 Jun 2002 Fixed
7.0.4 3348 28 Jun 2002 Fixed
7.0.3 2145 28 Jun 2002 Fixed
6.0.04 3801 28 Jun 2002 Fixed
Description
Starting with ASE 12.5 GA, TEXT columns modified on ASE would not have replicated correctly. They would have meaningless values such as '/00000016\x01'. IMAGE columns would replicate correctly. TEXT columns now replicate correctly.



CR:286421
CR Number:   286421
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2006 Fixed
Description
The fix displays percentage completion for dbcc gam().



CR:286430
CR Number:   286430
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2002 Bundled Request
Description
While reading the SYSGAMGS table, error 691 is encountered with a request to

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

the SYSGAMS extent allocation.



CR:286432
CR Number:   286432
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2002 Fixed
26 Nov 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Missing SYSGAMS extents are not detected until a session tries to allocate

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

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



CR:286438
CR Number:   286438
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2002 Fixed
09 Oct 2002 Fixed
16 Sep 2003 Fixed
16 Sep 2003 Fixed
Description
Introduced new group on sp_sysmon for ASE replication agent performance and tuning analysis.



CR:286499
CR Number:   286499
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jun 2002 Fixed
09 Jul 2002 Fixed
Description
CIS: The identity value does not increment when the command SELECT <select list> INTO <local table> FROM <remote table> is executed and an identity column is specified in <select list>.



CR:286576
CR Number:   286576
Product Name:   Adaptive Server Enterprise
Product Component:   FTS SDS
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.2 24 Jul 2002 Fixed
12 Nov 2002 Fixed
Description
EFTS: query on text index using a mix of sequenced operator index_any columns and non-sequenced operator index_any columns returns invalid results.



CR:286613
CR Number:   286613
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2002 Fixed
11 Jun 2002 Fixed
11 Jun 2002 Fixed
Description
In rare circumstance, a query which includes a LIKE clause and that uses the Dynamic OR strategy can return incorrect results.



CR:286644
CR Number:   286644
Product Name:   Adaptive Server Generic Docs
Product Component:   Troubleshooting:Error Messages
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Doc Set to reflect changes to buildmaster and sybinit utilities in ASE 12.5 and later. More detailed info in http://my.sybase.com/detail?id=1016939



CR:286674
CR Number:   286674
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2002 Fixed
Description
When ASE is configured for High Availability on Sun Cluster3.0, (1) the fault monitor program doesn't work if the environment file SYBASE.sh is not present in the specified location and (2) modifying any resource property fails.



CR:286675
CR Number:   286675
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2002 Fixed
Description
When ASE is configured for High Availability on Sun Cluster3.0, the fault monitor program doesn't work if the interfaces file is not present in $SYBASE.



CR:286717
CR Number:   286717
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2002 Fixed
Description
"Error: 1515, Severity: 20, State: 1" is found in the error log when a parallel

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

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

'sortclean' will be found in the error log.
Workaround Description
 sp_configure 'enable sort-merge join and JTC',0



CR:286718
CR Number:   286718
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2003 Fixed
17 Jul 2003 Fixed
Description
Ability to reserve at least one user connection for SA that can always be used to login to ASE, even if the user connections are all being used. This should allow sa to login to the server and maybe rectify the problem or shutdown gracefully.



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



CR:286719
CR Number:   286719
Product Name:   Sybase InstallShield
Product Component:   InstallShield
Status:   Closed
OS:   Generic
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2002 Fixed
3.0 06 Jun 2002 Fixed
3.0 06 Jun 2002 Fixed
3.0 06 Jun 2002 Fixed
3.0 06 Jun 2002 Fixed
3.0 06 Jun 2002 Fixed
03 Aug 2002 Not a Bug
Description
This bug fixes the refresh issue on the summary panel. I had to change the InstallationSummaryPanel to remove _subPanel from the content pane and then re-add it every time we hit the entered method. This allows for re-calculation of activated products, and then draws them to the screen properly.



CR:286723
CR Number:   286723
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.0.2 05 Aug 2002 Fixed
Description
Support added for IBM's HACMP / ES under AIX 4.3.3 for ASE 12.5

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

and two patches - APAR IY26561 & APAR IY26492.



CR:286756
CR Number:   286756
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2003 Fixed
Description
On various properties/wizard pages where a file path is needed, the browse button is disabled when the server is not running on the local host. Also a warning message tells the user that the path entered is relative to the remote host.



CR:286771
CR Number:   286771
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2002 Fixed
31 Jan 2003 Fixed
Description
Table Properties under Lockings Tab, option text is corrected to "Reserve page gap" from "Reseve page gap"



CR:286788
CR Number:   286788
Product Name:   ASE Replicator
Product Component:   DDBAdmin
Status:   Closed
OS:   Generic
Original Version:   12.5.0.103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.0 06 May 2003 Fixed
12.5.0.105P2 12 Jun 2002 Fixed
Description
ASE Replicator: If there is any mixed case or upper case in the fully qualified primary article name, then trying to add a replicate article that includes image/text columns for that primary article will fail.



CR:286789
CR Number:   286789
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.0.103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.0 06 May 2003 Fixed
12.5.0.105P2 12 Jun 2002 Fixed
Description
ASE Replicator: Replication of images greater than approximately 16K fails -- only 450 bytes are replicated.



CR:286794
CR Number:   286794
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2009 Insufficient priority to fix
Description
Feature request to have sp_help show what datatype a user-defined datatype was declared as. For example, a datatype declared as a float(8) actually is stored as a real; sp_help currently shows that the datatype is a real with no way to reverse-engineer that it was actually declared as a float with a specified precision.





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



CR:286862
CR Number:   286862
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2002 Fixed
11 Oct 2002 Fixed
Description
With "sort_merge" enabled, the optimizer may sometimes fail to choose a cheaper non-merge join plan.



CR:286906
CR Number:   286906
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Presently Not Targeted For Any Future Release Of This Product
19 Jul 2002 Fixed
Description
The message "current process infected with 11" in the module 'n3__get_sig_size' may be reported in the error log

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

this column is accessed via a subquery.



CR:286939
CR Number:   286939
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2002 Fixed
11 Jun 2002 Fixed
12 Jul 2007 Fixed
Description
In certain situations, trying to do an UPDATE to a row on an ALLPAGE locked table where the page already has 256 rows in it, may result in a 2620 error - "The offset of the row number at offset <offset> does not match the entry in the offset table of the following page: <pageid>."
Workaround Description
 Use DOL table instead of APL



CR:287000
CR Number:   287000
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2002 Fixed
29 Aug 2002 Fixed
Description
A 3944 error is reported when using a view, trigger or stored

procedure that requires recompilation and the database is

in READONLY or STANDBY_ACCESS mode. Likewise, the view,

trigger or stored procedure is unnecessarily suspended temporarily

when a QUIESCE DATABASE command is active.



CR:287087
CR Number:   287087
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2002 Fixed
25 Jun 2002 Fixed
04 Jul 2002 Fixed
18 Jul 2002 Fixed
Description
A 692 error, "Uninitialized logical page '<pageid>' was read while accessing

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

exceeds 2016 GB.



CR:287133
CR Number:   287133
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2002 Fixed
Description
When a SQL Query on a proxy table is executed

using JDBC interface, it may result in error 103,

if the columns in a table are of length greater than 28 bytes
Workaround Description
 In the JConnect application, add ...executeQuery("execute <dummy stored procedure>") right after the connection is established. This will reset the P4_PROC_QUOTED_IDENT bit in the PSS.

Yet, the problem might arise again later when a stored procedure in q



CR:287215
CR Number:   287215
Product Name:   Adaptive Server Generic Docs
Product Component:   EFTS SDS and SFTS SDS
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2003 Fixed
Description
Remove "The highlighting feature is no longer supported." from EFTS - Chapter 6 (What's New in Version 12.0.1),Installation and Release Guide states.



CR:287221
CR Number:   287221
Product Name:   ASE Replicator
Product Component:   Distributor
Status:   Closed
OS:   Generic
Original Version:   12.5.0.103
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0.0 06 May 2003 Fixed
12.5.0.105P2 12 Jun 2002 Fixed
Description
ASE Replicator: Text/Image replication fails in cases where the LOB columns either precede or are interleaved with primary key columns in column order. In the case where all primary key columns are followed by the LOB columns, replication succeeds.



CR:287224
CR Number:   287224
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2003 Fixed
Description
list_appcontext ('contextname') raises error 11021 if less than 2 arguments are passed to the function
Workaround Description
 Use list_appcontext('*','*') if you need to list all the contexts in the current session.

Use list_appcontext(context_name,'*') if you need to get info on a particular context.



CR:287236
CR Number:   287236
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2004 Bundled Request
Description
Feature request. Tempdb space and transactional elapsed time resource limits are enforced outside of their timerange.



CR:287353
CR Number:   287353
Product Name:   Adaptive Server Generic Docs
Product Component:   Reference Manual:Building Blocks
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2002 Fixed
Description
"NEW" is a Potential SQL92 Reserved Word, that is the reason why, it does not have the same restrictions as a T-SQL reserved word. ASE 12.5 Ref guide, Vol 1 Chap 8 http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/refman/@Generic__BookView

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



CR:287392
CR Number:   287392
Product Name:   Adaptive Server Enterprise
Product Component:   omni
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2003 Fixed
21 Nov 2004 Presently Not Targeted For Any Future Release Of This Product
Description
CIS: In rare circumstances, a SELECT INTO statement which includes outer join of proxy tables may return wrong result.
Workaround Description
 Use T11210 or

Use ANSI Style outer join.



CR:287401
CR Number:   287401
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2002 Fixed
03 Mar 2003 Fixed
Description
In rare circumstances the message "current process infected with 11" may be reported in the error log together with a stack trace which includes the module 'a_rgused' when processing a query that contains an aggregate within a subquery.
Workaround Description
 None available.



CR:287419
CR Number:   287419
Product Name:   Adaptive Server Enterprise
Product Component:   sybmigrate
Status:   Closed
OS:   NA
Original Version:   12.5.0.1 Intl
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
16 Jul 2002 Fixed
Description
The script "$SYBASE/$SYBASE_ASE/bin/sybmigrate" is changed to use Bourne Shell because not all platforms have Korn shell.



CR:287474
CR Number:   287474
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2002 Fixed
Description
When ASE is configured for High Availability on Sun Cluster3.0, if any error condition occurs (because of incorrect configuration, such as -e option not specified for dataserver in RUN_server_file) the fault monitor program doesn't exit properly. Because of this, the fault monitor program keeps loading and exiting infinitely without doing its job, i.e monitoring ASE and taking appropriate actions such as restarting/failing over ASE as and when required.



CR:287501
CR Number:   287501
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
11 Sep 2002 Fixed
22 Aug 2002 Fixed
Description
An 806 error may be reported, or DBCC CHECKTABLE may report 7951 or 12953 errors on text pages that originate from a pre-12.0 installation and which, subsequent to upgrading to 12.0 or beyond, have been the target of an UPDATE or DELETE operation that has been rolled back. This differs from CR 276568 in that it fixes text pages that have already been incorrectly modified. CR 276568 fixes the original problem.
Workaround Description
 bcp out data,truncate table,bcp in data



CR:287505
CR Number:   287505
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2003 Fixed
25 Aug 2003 Fixed
Description
Feature request to remove or make configurable the limit on the size of the symbol table, which limits the number of variables allowed in a batch. Error 1908 is currently raised if more than ~2-3 thousand variables are declared in a batch.



CR:287513
CR Number:   287513
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2009 Insufficient priority to fix
Description
Need Sanitized customer visible description for this CR as this CR has been referenced

in 12.5.0.1 ESD#2 and later Coverletters.



CR:287524
CR Number:   287524
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2003 Fixed
Description
A 7928 error "Index <value> is not consistent; found <value> leaf rows

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

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

either a CLUSTERED or NONCLUSTERED index with the SORTED_DATA

option but ASE was first shutted down with the NOWAIT option.
Workaround Description
 Do not shutdown ASE with the 'nowait' option.



CR:287559
CR Number:   287559
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2002 Fixed
Description
"NEW" is a Potential SQL92 reserved word . The row referencing NEW in spt_values should be removed.



CR:287585
CR Number:   287585
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2002 Fixed
19 Jun 2002 Fixed
17 Jun 2002 Fixed
18 Jun 2002 Fixed
14 Jun 2002 Fixed
Description
An incorrect result may be returned by the MAX() aggregate function when the clustered index on an all-page locked table is used to determine the value and the configuration parameter "allow backward scans" is set to 0. Similarly, the MIN() aggregate may return an incorrect result using a descending clustered index.
Workaround Description
 - Don't disable backward scans.
or
- Use DOL table.
or
- Use nonclustered index.



CR:287659
CR Number:   287659
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2003 Fixed
12.5.1 12 Feb 2003 Fixed
Description
Proxy Tables can be created on all allowed non-ASE datasources like Oracle, DB2, ASIQ, ASA, MSSQL Server.



CR:287661
CR Number:   287661
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2003 Presently Not Targeted For Any Future Release Of This Product
25 Mar 2003 Fixed
Description
There is no option to map a role to a remote login(a login in a remote server).



CR:287681
CR Number:   287681
Product Name:   Adaptive Server Enterprise
Product Component:   Historical Server
Status:   Closed
OS:   Solaris
Original Version:   0.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2003 Fixed
03 Feb 2003 Fixed
10 Mar 2003 Fixed
Description
During procedure I/O monitoring, the messages "**NoObject**" and "**NoDatabase**" may clutter the Historical Server output.
Workaround Description
 The customer can get rid of the extra unrequested information by using filters on procedure ID = 0 with the following syntax: hs_create_filter

process_io_sproc2, "Procedure ID", "Value for Sample", neq, 0.



CR:287734
CR Number:   287734
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to enhance ALTER TABLE so it can add BIT columns to a table.



CR:287739
CR Number:   287739
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Sep 2002 Fixed
Description
Use of a host variable in lieu of an identifier in parameterized

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

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

host variable may instead be supplied using a datatype of UNICHAR

or UNIVARCHAR (assuming the requirements for use of these datatypes

are met).



CR:287744
CR Number:   287744
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   12.5.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2002 Fixed
Description
A negative or zero value may be incorrectly reported as the percentage completed during the undo or redo recovery passes, respectively.



CR:287778
CR Number:   287778
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2003 Fixed
04 Mar 2003 Duplicate
Description
On a multi-engine server, the transaction start time from the syslogshold table may get ahead of the OS time.



CR:287810
CR Number:   287810
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 04 Mar 2003 Duplicate
Description
Sybase Central ASE Plugin: does not support connection to servers that contain space characters in the network definition of the SQL.INI interfaces file.



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



CR:287816
CR Number:   287816
Product Name:   Adaptive Server Enterprise
Product Component:   Sybase Central ASE Plug-in
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sybase Central ASE Plugin: does not support connection to servers using the $BASE$00 syntax in the SQL.INI interfaces file.



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



CR:287845
CR Number:   287845
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   NA
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Fixed
Description
A feature request to remove the limits on the number of tables per query (50) and the number of subqueries per query (16), making them unlimited.



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



CR:287899
CR Number:   287899
Product Name:   Adaptive Server Enterprise
Product Component:   xpserver
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Fixed
13 Mar 2003 Fixed
Description
xpserver: "Recursive calls to srv__seterr()" may be entered into the xpserver errorlog when executing xp_logevent.
Workaround Description
 None. The code in the DLL needs to change.



CR:288059
CR Number:   288059
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Solaris
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2002 Fixed
24 Jun 2002 Fixed
27 Jun 2002 Fixed
15 Jul 2002 Fixed
Description
The stored procedure sp_statistics always returns a 'collation' value of "A" for both ascending and descending index columns.



CR:288066
CR Number:   288066
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX 5.1
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2002 Fixed
Description
The error message "I/O error detected for device" is sometimes displayed on IBM platforms.



CR:288092
CR Number:   288092
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.0.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2002 Fixed
30 Sep 2002 Presently Not Targeted For Any Future Release Of This Product
13 Jun 2001 Presently Not Targeted For Any Future Release Of This Product
Description
When running a SELECT query that has a UNION of more than 250 columns in the select list, the

query may hang or return wrong results.
Workaround Description
 ASE 12.5.x doen't have this problem.



CR:288099
CR Number:   288099
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
03 Dec 2006 Fixed
08 Feb 2007 Fixed
Description
ASE optimizer is not able to perform statistics interpolation for char and varchar

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

As consequence some queries may be executed using suboptimal plans.
Workaround Description
 Increasing step count for the column statistics may or may not help since data is dynamic.



CR:288100
CR Number:   288100
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   HP-UX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Sep 2002 Fixed
Description
The Large I/O effectiveness section under the "cache summary" section

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



CR:288109
CR Number:   288109
Product Name:   Adaptive Server Enterprise
Product Component:   dataserver
Status:   Closed
OS:   AIX
Original Version:   12.5.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE encounters java.lang.NoClassDefFoundError when multiple java sessions started concurently.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------