远程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:565247
CR Number:   565247
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Open Client:



Feature request to add CP1252 support in locales.dat for a new IQ collation 1252LT1ACC

"ISO with euro sign and accent-sensitive"



CR:565434
CR Number:   565434
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 14 Sep 2009 Fixed
Description
ADO.Net Provider request for support for LINKQ! and Entity Framework 3.5



CR:565442
CR Number:   565442
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Mar 2009 Fixed
26 Jun 2009 Fixed
Description
RCM disconnects users when standby ASE goes down and the status of the standby ASE within OpenSwitch might be set to SUSPENDED.



CR:566066
CR Number:   566066
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#25
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 24 Aug 2010 Fixed
Description
ODBC Driver by Sybase: Data overflow error when calling query with the sum for decimal types with large precision/scale.



CR:566270
CR Number:   566270
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2010 Fixed
23 Sep 2011 Fixed
Description
Mutual Aware Openswitch reports false communication failure with companion:

cmp_chk_ase: Error receiving results from companion.



CR:566386
CR Number:   566386
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2009 Duplicate
Description
OLE DB Provider by Sybase: Request support for Kerberos authentication in the Windows 64-bit Driver.



CR:566388
CR Number:   566388
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2009 Duplicate
Description
ODBC Driver by Sybase: Request support for Keberos authentication in Windows 64-bit Driver.



CR:566389
CR Number:   566389
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2010 Fixed
Description
ADO.NET: Request support for Kerberos authentication in Windows 64-bit provider.



CR:566532
CR Number:   566532
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2010 Presently Not Targeted For Any Future Release Of This Product
08 Apr 2009 Fixed
Description
OpenSwitch crashes in thrd__ctparams() if a cursor is declared and opened twice without deallocating the cursor.
Workaround Description
 Deallocate the cursor before you re-declare and re-open the same cursor name.



CR:566756
CR Number:   566756
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2009 Fixed
Description
When we do prepareStatement.setNull(1, Types.BIT), 0 was getting inserted, where as we should throw error instead.



With current fix we are throwing error when one tries to do prepareStatement.setNull(1, Types.BIT).



CR:566974
CR Number:   566974
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Incosistent behavior when standby ASE fails. If OpenSwitch is monitoring the standby ASE (due to a previous failover), OpenSwitch marks the standby DOWN if it fails for some

reason. If OpenSwitch is not monitoring the standby ASE when it fails, the status remains

UP.



CR:567229
CR Number:   567229
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for Performance Monitor counters



CR:567299
CR Number:   567299
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2009 Fixed
Description
Problem: Incorrect text in Create Multiple Sybase IQ Profiles. On an existing IQ profile in the Enterprise Explorer, right-click Menu > Create Multiple Sybase IQ Profiles. This will pop up the following dialog box: "Text refers to the a ASA profile", but we are working on a IQ profile.

Workaround: In the past IQ used the multiple db action action of ASA. The fix created a multiple db action for IQ.



CR:567400
CR Number:   567400
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2010 Fixed
Description
OLE DB Provider by Sybase: SQLCommand with stored procedure which has no parameters fails using SSIS. An error message about a required parameter is displayed and the execution of the package fails.



CR:567413
CR Number:   567413
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 13 May 2009 Third Party Problem
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ODBC tests were failing on Linux.



CR:567457
CR Number:   567457
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 14 May 2009 Fixed
Description
ODBC Driver by Sybase: When Binding TDS_CHAR DB2 TIMESTAMP value to SQL_C_TIMESTAMP the TIMESTAMP value is displayed

incorrectly.



CR:567536
CR Number:   567536
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Cannot use large memory size when using Adapter.FillSchema method
Workaround Description
 Use Adapter.Fill(Table) instead of Adapter.FillSchema(Table, SchemaType.Source)



CR:567552
CR Number:   567552
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#18 04 May 2009 Fixed
Description
ADO.NET: Transaction is not being completed after TransactionScope.Complete()is called in ASP.NET.



CR:567572
CR Number:   567572
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#19 14 May 2009 Fixed
Description
ADO.NET: When using AseDataAdapter to insert rows into a table, invalid data is stored in resultant table if the UpdateBatchSize property is set to a value greater than 1.



CR:567660
CR Number:   567660
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2009 Fixed
Description
Problem: 'CTRL+C' doesn't work in SQL Results view.

Workaround: Fixed. Also added accelerator key "Ctrl+R" for copy rows action. It avoids conflict with "Ctrl+C" for text copy.



CR:567752
CR Number:   567752
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 12 May 2009 Fixed
Description
ODBC Driver by Sybase: ADO.Update method is unable to qualify the object being updated with the targeted database name.



CR:567859
CR Number:   567859
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Unknown
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jul 2009 Fixed
25 Aug 2009 Fixed
Description
BCP: BCP terminates the operation without a proper message when the rows processed exceed 2^31 -1 row.



CR:568076
CR Number:   568076
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#21 13 May 2014 Fixed
Description
TDS is being expanded to add datetime2 and time2 data types.



CR:568093
CR Number:   568093
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2009 Fixed
19 Apr 2009 Presently Not Targeted For Any Future Release Of This Product
26 Apr 2009 Fixed
27 Jul 2009 Fixed
08 Jun 2009 Fixed
30 Jun 2011 Fixed
Description
CTLIB: ct_send_data() may intermittently report error "Cannot perform more than one read"



CR:568223
CR Number:   568223
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2009 Duplicate
Description
OSwitch -h parameter has incorrect description for k flag. It is described as the "death thread" when it is actually the "timer thread".



CR:568433
CR Number:   568433
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 05 May 2009 Fixed
Description
ODBC Driver by Sybase: ODBC application connected to an ASE Logical Cluster does not effectively round-robin the connections.



CR:568459
CR Number:   568459
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 05 May 2009 Fixed
Description
ODBC Driver by Sybase: When an ODBC application using cursors is connected to ASE 15.01.CE, adding an instance to the cluster generates an error in SQLExecute.



CR:568484
CR Number:   568484
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 05 May 2010 Fixed
Description
ODBC Driver by Sybase: In an ODBC application connected to ASE Cluster Edition, the connection becomes unsuable after failover and failback are attempted. The error "Could not SQLAllocStmt" is seen.



CR:568612
CR Number:   568612
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2009 Not a Bug
Description
Customer's existing .NET 2.0 application get problem after migrate to SDK15.0 ESD17.

It is identified that application use the Microsoft's "System.Transactions.TransactionScope" for transaction control on multiple DB connections.

Whenever there is a established DB connection, the second connection will hit error when try to open the second connection within the same TransactionScope.



"Sybase.Data.AseClient.AseException: Only One Local connection allowed in the TransactionScope

at Sybase.Data.ASEClient.ASEConnection.Open()

at WindowsApplication1.Form1.button1_Click( Object sender, EventArgs e)

at C:\......\.....\........\WindowsApplication1\Form1.cs: Line 51"



CR:568629
CR Number:   568629
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 04 May 2009 Consult Complete
Description
OLE DB Provider by Sybase:Several applications using the Organic OLEDB driver

of 15 while other applications that still need to be tested require the 12.5.1

OLEDB driver to run simultaneously.



CR:569007
CR Number:   569007
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2009 Fixed
08 Jun 2009 Fixed
Description
BCP: When bcp is invoked with argument 'in' to copy in character data and there are some illegal characters in the data, bcp should truncate data from the position of the first illegal character and continue to process partial data. A warning message should also be generated in this case.



CR:569215
CR Number:   569215
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2010 Fixed
14 Jan 2010 Fixed
Description
jConnect: Enabling password encryption feature causes login errors in a multi-threaded client.



CR:569511
CR Number:   569511
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.1.2 11 May 2009 Fixed
Description
Problem: Need to support customizing file name and hierarchy.

Workaround: Fixed.



CR:569545
CR Number:   569545
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 04 May 2010 Fixed
Description
ODBC Driver by Sybase: Calling SQLFreeStmt(StmtHandle, SQL_DROP) after executing a statement asynchronously causes SQLGetInfo to return the error "SqlState:HY010;NativeError:30102;[Sybase][ODBC Driver]Function sequence error".



CR:569749
CR Number:   569749
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 05 May 2010 Fixed
Description
OLE DB Provider by Sybase: Cannot select columns with reserved names in linked ASE table from Microsoft SQL Server Linked Server.



CR:569842
CR Number:   569842
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 02 Jun 2009 Fixed
Description
ODBC Driver by Sybase: Cannot insert Japanese text into an ASE text column from Microsoft Access 2003 application.



CR:570119
CR Number:   570119
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Linux
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer requestion 64 bit isql not to be replaced by current ESD

To have two versions 1- isql 32 bit 2- isql64 64 bit.

rather then just replacing the base release of 64 bit isql and reverting it

back to 32 bit isql.
Target Version
 To Be Determined
Workaround Description
 Customer has renamed the original 64 bit version of isql to isql64 and them

did the ESD#17 install so now he has 32 bit and 64 bit isql in place.



CR:570771
CR Number:   570771
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2009 Fixed
Description
jConnect: A JDBC connection to ASE Cluster Edition becomes un-usable after a connection failover followed by failback are attempted.



CR:570914
CR Number:   570914
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2009 Fixed
17 Aug 2009 Fixed
10 Aug 2009 Fixed
Description
OCS: Use Visual Studio 2005 for Windows 32bit.



CR:570920
CR Number:   570920
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 02 24 Mar 2010 Fixed
Description
Listener will get AICA ABEND if SEC=U and a bad User ID is used.



CR:571081
CR Number:   571081
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ct_data_info does not return fully qualified column names when connecting to an Open Server.



CR:571241
CR Number:   571241
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0 29 Jun 2009 Fixed
Description
Cause

=====

Bottlenecks in data processing before sending the rows to the server.



CR:571263
CR Number:   571263
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2009 Fixed
Description
Missing rcm.loc for character sets other than iso_1 causes error 'Unable to open Locales'.



CR:571283
CR Number:   571283
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#19 28 May 2009 Fixed
Description
ADO.NET: Executing a command using CommandBehavior.SingleRow does not return any rows.



CR:571603
CR Number:   571603
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2009 Fixed
06 Nov 2009 Fixed
24 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
30 Nov 2009 Fixed
Description
jConnect: Using Statement.executeUpdate() on large batches of T-SQL containing many "EXEC <stored_procedure>" commands may cause java.lang.StackOverflowError.
Workaround Description
 The correct way to do this is to use Statement.executeBatch() which works fine.

Also, jTds from SourceForge also works.



CR:571908
CR Number:   571908
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2009 Work as design
Description
Migrating from 1103 to 1502, some charset cannot display correctly



CR:572170
CR Number:   572170
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Windows 2000
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Product: OpenSwitch 15.1 for Windows



The Release Bulletin states that "Windows 2003 Enterprise Edition Service Pack 1 or later" would be certified to work with OpenSwitch 15.1.



http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc76342.1510/html/oswrb/BBCGJIJC.htm



According to OpenSwitch Engineering, Windows 2003 was never tested with OSW 15.1.



This may cause confusion to customers, who will probably install OSW 15.1 on Win2k3. So, we'd like to ask you to correct the Release Bulletin documentation to place correct platforms and remove Win2k3 reference.



Also, I'd like to ask you to update the information about OpenSwitch 15.1 at http://certification.sybase.com . There's no OSW 15.1 there at this point and customers ask us for it.



CR:572317
CR Number:   572317
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 25 May 2009 Fixed
Description
ODBC:



The ODBC Driver cannot connect to a database having capital names.



This problem is solved by installing the ODBC stored procedures of SDK15 ESD 18.



CR:572720
CR Number:   572720
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2009 Fixed
29 May 2009 Fixed
Description
In a Mutual Aware setup, upon the failure of active ASE, new clients might get connected to the standby ASE even before RCM completes its replication server failover procesing functions. This might cause data corruption in the ASE server which is undesirable.



CR:573315
CR Number:   573315
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#26
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#21 04 Nov 2009 Fixed
12.5.1 ESD#27 04 Nov 2009 Fixed
30 Mar 2010 Fixed
Description
ODBC Driver by Sybase: SQLGetData() with SQL_ARD_TYPE may return SQL_NO_DATA_FOUND for decimal and numeric columns.
Workaround Description
 If your application uses ADO, please use ASE OLE DB Provider or place the text column at the end of the SELECT column list if possible.

If your application directly calls SQLGetData() with SQL_ARD_TYPE, please call SQLBindCol() instead or call SQLGetData() with SQL_C_NUMERIC.



CR:573978
CR Number:   573978
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 02 24 Mar 2010 Fixed
Description
Listener needs to check if there is already a listener started.



CR:574127
CR Number:   574127
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2009 Fixed
Description
jConnect: Implement JDBC 4.0 interfaces in jConnect driver.



CR:574144
CR Number:   574144
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2009 Fixed
Description
as per jdbc4.0 specs jConnect have nchar/nvarchar related features implemented now.



CR:574414
CR Number:   574414
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a jConnect application is connected to an English server, getColumnType method returns CHAR ans VARCHAR as "-1".
Workaround Description
 If a customer does not require the Unicode conversion, please change the value of "enable unicode conversions" into 0.



CR:574441
CR Number:   574441
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 01 Jul 2009 Fixed
Description
jConnect: Exception when the bulk load is done with ENABLE_BULK_LOAD=true on a table with single column
Workaround Description
 set ENABLE_BULK_LOAD to false.



CR:574454
CR Number:   574454
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 29 Jun 2009 Fixed
6.5 ESD#17 09 Jul 2009 Fixed
Description
jConnect: ENABLE_BULK_LOAD with numeric datatypes can cause wrong value inserted.
Workaround Description
 ENABLE_BULK_LOAD=false



CR:574464
CR Number:   574464
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 2 16 Mar 2010 Not a Bug
Description
Organic OLEDB Provider

MS Link Server replication (parametrized) fails on German Umlaut characters



CR:574489
CR Number:   574489
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 01 Jul 2009 Fixed
Description
jConnect: Bulk insertion with ENABLE_BULK_LOAD=true throws exception when data is inserted to a table in different database than the currently connected one.
Workaround Description
 ENABLE_BULK_LOAD=false



CR:574694
CR Number:   574694
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 01 Jul 2009 Fixed
Description
jConnect: When ENABLE_BULK_LOAD=true, clearBatch() does't clear the batch.
Workaround Description
 ENABLE_BULK_LOAD=false



CR:574751
CR Number:   574751
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request SybTimestamp class to implement variable serialVersionUID



CR:575147
CR Number:   575147
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2009 Fixed
18 Jun 2009 Fixed
10 Jun 2009 Fixed
28 Jul 2009 Fixed
Description
ISQL: Introduction of isql --help option reports help when option -i is immediately followed by a script starting with the word "help".
Workaround Description
 Add a space between the -i parameter and the script:

% isql -Usa -P -Snstack_1502 -i helptest.sql



CR:575167
CR Number:   575167
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
BCP raises "Warning: Option "-E" is not set, DataServer will be generating the values for the identity column." for each batch if the source file does not contain an identity column value. This seems excessive, request is to raise the warning no more than once, and not at all if -N is used.
Workaround Description
 Use BCP version 15.0 ESD 7 or earlier.



or



Filter out the messages by piping bcp output through reverse grep



bret-sun2% bcp test..t1 in t1.txt -Usa -P -c -b5 | grep -v identity



CR:575312
CR Number:   575312
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2009 Fixed
08 Nov 2009 Fixed
Description
EXAMPLE: When a client executes a stored procedure through sample ctos, ctos can not return correct row counts to the client.



CR:575758
CR Number:   575758
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2009 Duplicate
Description
OLEDB Provider:

The euro symbol is not replicated from CP1252 to ISO-1 as was done in older drivers.



CR:576012
CR Number:   576012
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OSC/MFC Needs to support the BIGINT Data Type



CR:576053
CR Number:   576053
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2009 Fixed
23 Jul 2009 Fixed
Description
BCP: bcp in -c (character mode) of unichar data may truncate.



CR:576126
CR Number:   576126
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 01 Jul 2009 Fixed
Description
jConnect: Exception in bulk load with ENABLE_BULK_LOAD=true when table name in the insert statement is provided in the form dbname..tablename
Workaround Description
 ENABLE_BULK_LOAD=false



CR:576443
CR Number:   576443
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#20 14 Sep 2009 Fixed
Description
OLE DB Provider by Sybase:



Memory leak when updating across servers in MS Link Server configuration



execute('update ds_ase.ase_db.dbo.tCross set a.name = ''_'' + a.Name from

ds_ase.ase_db.dbo.tCross a, #f b where a.myid = b.myid ')



CR:576898
CR Number:   576898
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Make ISQL's command line argument checking strict



CR:576920
CR Number:   576920
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2009 Fixed
30 Nov 2009 Fixed
30 Nov 2009 Fixed
Description
jConnect: DataSource.setLoginTimeout() is not working as expected.



CR:577424
CR Number:   577424
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#26
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2009 Fixed
16 Jul 2009 Fixed
21 Jul 2009 Fixed
Description
DBLIB: dbcancel() sometimes does not respond for 60 seconds.
Workaround Description
 Use dbcanquery() if acceptable.

dbcanquery() seems to work around this problem. But dbcanquery() gets all rows by calling dbnextrow() repeatedly in itself.

dbcacquery() performance may be slower than dbcancel().



CR:577629
CR Number:   577629
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2009 Fixed
22 Jun 2011 Fixed
13 Aug 2009 Fixed
12 Aug 2009 Fixed
17 Feb 2011 Fixed
Description
BCP:BCP reports truncation error when doing client side conversion between character data that has different character set and the size of the character is different.



CR:578154
CR Number:   578154
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OpenSwitch Mutual Aware cluster tables are replicated from primary to standby
Workaround Description
 1) Make sure the CMON_USER's default database is one that is not marked for replication.

or

2) Disable replication on the OpenSwitch cluster tables. If the entire DB is not marked

for replication, you may be able to disable replication on just the OpenSwitch cluster

tables:

sp_setreptable table_name, 'false'



CR:578389
CR Number:   578389
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2009 Fixed
Description
OpenSwitch doesn't return the expected row count back to the jConnect app. executing a stored procedure when one of the statements (for example, select) didn't return any rows from the ASE server. getMoreResults() and getUpdateCount() JDBC API's doesn't work as advertised by the JDBC specification because of this issue.



CR:578667
CR Number:   578667
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2010 Fixed
30 Mar 2010 Fixed
Description
ODBC Driver by Sybase: When using the MaxRowsReturned property against MainFrame Connect DB2 Access Service, no message is received when MaxRowsReturned limit is reached.



CR:578735
CR Number:   578735
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#21 04 Nov 2009 Fixed
Description
ODBC Driver by Sybase: Custom error messages received from ASE are not displayed in the order received.



CR:579389
CR Number:   579389
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2009 Fixed
21 Aug 2009 Fixed
21 Aug 2009 Fixed
26 Aug 2009 Fixed
Description
Samples: Add new sample 'sendrpc' to the srvlibrary samples.



CR:579415
CR Number:   579415
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 27 Oct 2014 Fixed
Description
ADO.NET Driver by SAP : The driver fails to enlist in a distributed transaction with an access violation.



CR:579611
CR Number:   579611
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#21 23 Mar 2010 Fixed
12.5.1 ESD#27 23 Mar 2010 Fixed
15.5 ESD 1 04 May 2010 Fixed
Description
ODBC Driver by Sybase: The ASE Extended password encryption feature does not work with ASE 12.5.3 ESD#5 or later and ASE 15.0 versions.



CR:580020
CR Number:   580020
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 9 20 Jan 2011 Fixed
Description
ADO.NET: AseBulkCopy property BatchSize isn't working.



CR:580147
CR Number:   580147
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Nov 2009 Fixed
25 Nov 2009 Fixed
Description
jConnect: setMaxRows() method is ignored when used along with setFetchSize() on a statement.



CR:580226
CR Number:   580226
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2009 Fixed
Description
Under certain circumstances, when the network between OSW's is severed, OSW might allow the server/pool configurations to change when FREEZE_CFG_ON_FAIL=1.



CR:580414
CR Number:   580414
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 1 23 Nov 2009 Fixed
Description
OLE DB Provider by Sybase: The ADO OpenSchema call returns invalid data when CursorLocation is set to adUseClient and call field is greater than 127 characters.
Workaround Description
 WorkAround:

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

Use ASE ODBC Driver, or modify the oledb_mda_150.sql script

to convert the PROCEDURE_NAME field to varcahr(127) or smaller -

see the Observations in the CR description for details.



Also, with OLE DB Provider works when CursorLocation = adUseServer



CR:580586
CR Number:   580586
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RCM cfg parameter rs_user...should state explicitly...grant sa to this user in RepSrv



http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20190.1510/html/oswref/CHDGHBBA.htm



presently states this ...



Parameter Description Example Default

RS_USER The user name that the RCM uses to connect to the Replication sa None

Server. The user must have privileges to execute the following

commands: switch active, suspend log transfer from all, admin

quiesce_force_rsi, admin logical_status, and admin_health. This

is a required parameter.



it should read something like this...



Parameter Description Example Default

RS_USER The user name that the RCM uses to connect to the Replication sa None

Server. The user must have Replication Server sa privileges

(grant sa to <this_userid>). Below is an example of the steps

to create a new user in Replication Server and grant this sa

priviledge.

1. login into Replication Server using sa userid

2. create user rcm_user set password "rcm_user_ps"

3. grant sa to rcm_user

This RS_USER userid must have sa priviledges in Replication

Server in order to execute the following commands: switch

active, suspend log transfer from all, admin quiesce_force_rsi,

admin logical_status, and admin_health. This is a required

parameter.



CR:580745
CR Number:   580745
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#22 22 Jan 2010 Diagnostic Provided
Description
ADO.NET:

The applicaion is crashing in version 1.15.335.0 of Sybase.AdoNet2.AseClient.dll with sybdrvado20.



CR:580761
CR Number:   580761
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2009 Fixed
20 Nov 2009 Fixed
Description
DBLIB: If an openserver has dblib connections to a remote server then during the dblib connection processing, the openserver is blocked while waiting for tcp replies from the remote dataserver.
Workaround Description
 use threaded libs and set SRV_S_PREEPT or use 12.5.1 Openserver



CR:581077
CR Number:   581077
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   Solaris 10
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Provide Makefile for CEP sample programs



CR:581092
CR Number:   581092
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 26 Aug 2009 Fixed
15.0 ESD#21 26 Aug 2009 Fixed
Description
ODBC Driver by Sybase: User ID is incorrectly required for connections using Kerberos authentication in the ODBC Data Source Administrator User Interface and at run-time if SQL_DRIVER_PROMPT is set for the connection.



CR:581419
CR Number:   581419
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0 ESD#10 05 May 2011 Fixed
auriga 05 May 2011 Fixed
auriga 05 May 2011 Fixed
6.5 ESD#27 05 May 2011 Fixed
28 Jul 2011 Fixed
04 Oct 2011 Fixed
04 Oct 2011 Fixed
04 Oct 2011 Fixed
auriga 04 Oct 2011 Fixed
Description
jConnect: When the 揈NABLE_BULK_LOAD property is enabled on connection to SQLAnywhere or IQ database, misleading 揓Z0SJ: Metadata accessor information was not found on this database error is thrown.



CR:581959
CR Number:   581959
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   Solaris 10
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
example_query_window.c references wrong location for NamedWindows project



CR:581970
CR Number:   581970
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
example_query_window does not run due to incorrect public window name



CR:581972
CR Number:   581972
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
C/C++ sample programs do not have adequate error handling out of the box



CR:581973
CR Number:   581973
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Request API to install error handling callback



CR:581977
CR Number:   581977
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sample programs lack standardized comments/instructions



CR:581988
CR Number:   581988
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.0 08 Sep 2009 Fixed
Description
example_register_query errors out and does not return expected results



CR:582106
CR Number:   582106
Product Name:   Connectivity Utilities
Product Component:   dscp
Status:   Closed
OS:   S.U.S.E Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2009 Fixed
Description
DSCP: Dscp crashes when a new security attribute is added.



CR:582108
CR Number:   582108
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2009 Fixed
Description
CTLIB: A multi-threaded Client-Library application fails when it creates multiple threads to connect to an ASE via a ssl-enabled LDAP server.



CR:582125
CR Number:   582125
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2009 Fixed
10 Nov 2009 Fixed
Description
DBLIB: User API dbconvert() fails to convert a floating number into a string when the value of its parameter destlen is -1 or -2.



CR:582169
CR Number:   582169
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Unable to compile C++ SDK sample programs. Compilation fails with an unresolved symbol "_main" referenced in function "___tmainCRTStartup".



CR:582792
CR Number:   582792
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 Fixed
Description
Certify with CICS TS 4.1





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