远程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:392975
CR Number:   392975
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2005 Fixed
05 Oct 2005 Fixed
Description
CTLIB: For security sessions, ct_con_drop() may core dump if the security credential has expired.



CR:393327
CR Number:   393327
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2005 Fixed
6.05 14 Jul 2005 Fixed
5.5 ESD#18 14 Jul 2005 Fixed
Description
jConnect: Recieve Error - 3933: "Attempt to start an external transaction failed. It is illegal to begin an external transaction from with in the scope of a local transaction." when starting an external transaction in Weblogic application server.



CR:393343
CR Number:   393343
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Fixed
31 Jan 2006 Fixed
Description
ADO.NET: Enhancement request to support positional bind for stored procedure calls.



CR:393344
CR Number:   393344
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#10 22 Aug 2005 Fixed
1.15 ESD#1 26 Sep 2005 Fixed
Description
ADO.NET: AseParameter does not accept null input values for stored procedure calls.



CR:393655
CR Number:   393655
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2006 Fixed
03 Apr 2006 Fixed
Description
ISQL: Isql should have validity check on the values of the -w width parameter.



CR:393764
CR Number:   393764
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 002 08 Sep 2005 Fixed
Description
Transactions abended on a MAX TASK or TCLASS condition, when SYCH timed out before the new task started.



CR:393857
CR Number:   393857
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Presently Not Targeted For Any Future Release Of This Product
Description
The SYLB Default Trans start error MSGs are confusing and need to be Cleaned up.

SYBASE 14:40:58 TRANID SYLB TSKNO 00043 TRANSACTION START FAILED WITH RESP=00000045 RESP2=00000008

SYBASE 14:40:58 TRANID SYLB TSKNO 00043 35039 TRAN START ERROR: TRANSACTION SYGH NOT DEFINED IN THE PCT OR IS DISABLED.



CR:393871
CR Number:   393871
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 31 Jan 2006 Fixed
Description
ODBC Driver by Sybase: Improve SQLGetTypeInfo performance by caching results from previous queries to ASE.



CR:394010
CR Number:   394010
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Error 3146 in DAO application on MoveNext command



CR:394097
CR Number:   394097
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2006 Fixed
18 Jan 2006 Fixed
Description
jConnect: DatabaseMetaData.getProcedures() does not return procedures owned by non-sa_role users if the current login holds sa_role privilege.



CR:394616
CR Number:   394616
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Include discussion and example/s of DNS-less connection string in Chapter 2 of the Adaptive Server Enterprise ODBC Driver 12.5.1 User's Guide.



CR:394847
CR Number:   394847
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2005 Fixed
22 Sep 2005 Fixed
Description
jConnect: New feature request to be able to obtain connection information from Sybase interfaces / SQL.INI files.



CR:395045
CR Number:   395045
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 23 Dec 2008 Fixed
Description
Need precise description of the CS_NUMERIC struct and contents so that custom conversion routines may be developed.



CR:395393
CR Number:   395393
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2005 Fixed
Description
Avoid error "rp_lang: Unable to determine language length" which jConnect based clients.
Workaround Description
 None.



CR:395467
CR Number:   395467
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   Open ClientCONNECT for IMS and MVS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 001 12 Sep 2005 Fixed
12.50.10 005 12 Sep 2005 Fixed
Description
Memory Leak in OCC when calling the OCC initial setup APIs in a loop.



CR:395518
CR Number:   395518
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2006 Fixed
05 Jan 2007 Fixed
Description
NETLIB: Open Client applications hang in ct_results when SSL is enabled and the negotiated packet size is larger than 4K.



CR:395851
CR Number:   395851
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Microsoft Windows NT
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OpenSwitch running as windows service should STOP when requested by service manager.
Workaround Description
 Manually shutdown OpenSwitch with rp_shutdown



CR:396157
CR Number:   396157
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 01 04 Jan 2008 Fixed
Description
TCPIP is slower then SNA.



CR:396740
CR Number:   396740
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2005 Fixed
Description
ODBC Driver by Sybase: Request to add Kerberos sample to sample directory.



CR:396743
CR Number:   396743
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Fixed
01 Sep 2005 Fixed
31 Aug 2005 Fixed
17 Jan 2006 Not a Bug
Description
ODBC: On Windows platforms, added Kerberos ADO sample to samples directory. This is used for both ODBC and OLEDB Products.



CR:397199
CR Number:   397199
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.05 27 Sep 2005 Fixed
25 Jul 2005 Fixed
Description
jConnect: Incorrect number of rows affected returned by executeBatch method when IGNORE_DONE_IN_PROC is set to true and statements executed cause triggers to execute.



CR:397247
CR Number:   397247
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2005 Fixed
Description
CTLIB: When using a scrollable cursor with ct-lib, if an array bind count is set to less than the

cursor pre-fetch buffer size (CS_CURSOR_ROWS), the application would return less rows than

expected and could fail unpredictably.
Target Version
 Galaxy



CR:397348
CR Number:   397348
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2005 Fixed
13 Sep 2005 Fixed
Description
BLKLIB: Bulk copy in via gateway server may fail across platforms.



CR:397481
CR Number:   397481
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2005 Fixed
5.5 ESD#17 29 Sep 2005 Fixed
Description
jConnect: Incorrect return value (XAER_PROTO) when a failed XA transaction is ended. The correct return value is XAER_NOTA.



CR:397650
CR Number:   397650
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2005 Not a Bug
Description
ADO.NET: Clarification on Character set conversion issues between cp850 and cp1252 code pages on Windows.



CR:397928
CR Number:   397928
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2005 Fixed
Description
OLEDB: Application may see one extra RecordSet when executing a stored procedure using Connection.Execute or Command.Execute (with .CommandType = adCmdText). This is not seen when using Command.Execute (with .CommandType = adCmdStoredProc) or when "Select Method" = Cursor.
Workaround Description
 Use Select Method = Cursor



CR:397947
CR Number:   397947
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2005 Fixed
Description
Make SRV_TRACE flags dynamic via RPC rp_traceflag



CR:398262
CR Number:   398262
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 001 13 Sep 2005 Fixed
Description
CTCANCEL was not clearing out the result sets properly, affecting the second or third reqexec in CSA processsing.



CR:398330
CR Number:   398330
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2005 Fixed
Description
OLEDB: Command Timeout was not working. Application would behave as if there was no Command Timeout set, and would continue normal processing.



CR:398618
CR Number:   398618
Product Name:   jConnect
Product Component:   Ribo
Status:   Closed
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.05 17 Aug 2005 Fixed
Description
Ribo gets exception when trying to decode TDS_PARAMFMT2 tokens



CR:398925
CR Number:   398925
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 ESD#18 27 Jul 2005 Fixed
Description
Cause : BigInt was not Supported when using ASE15.0



Added support for BigInt for use with ASE15.0



CR:399131
CR Number:   399131
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2005 Fixed
27 Jul 2005 Fixed
Description
jConnect: NullPointerException is thrown when duplicate insert occurs and an OpenServer gateway such as OpenSwitch is being used between jConnect client and ASE.



CR:399274
CR Number:   399274
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2006 Presently Not Targeted For Any Future Release Of This Product
Description
OCC CSA Sample Transaction RDO Def use 'C' as the first letter of the Tran name.



CR:399350
CR Number:   399350
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2006 Fixed
24 Feb 2006 Fixed
Description
If both companions in a Mutual Aware OpenSwitch cluster are started with the "-O" command, they will both be running as the Primary Companion, and the companion that started first will be running in a single-server mode. In addition if Secondary OpenSwitch is running and Primary is brought up with -O option the configuration of Secondary Companion OpenSwitch is changed halfway without warning.



CR:399481
CR Number:   399481
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2008 Fixed
15 Jul 2008 Presently Not Targeted For Any Future Release Of This Product
15 Jul 2008 Fixed
15 Jul 2008 Fixed
Description
OpenSwitch and Coordination Module components now provide MIT kerberos network authentication service for their end-to-end connectivity support.



CR:399542
CR Number:   399542
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2005 Fixed
06 Oct 2005 Fixed
Description
BCP: On UNIX platforms, suppress the password that is visible from the command line when running bcp with '-P<password>' argument.



CR:399620
CR Number:   399620
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#11 08 May 2006 Fixed
15.0 ESD#1 08 May 2006 Fixed
Description
OLE DB Provider by Sybase: Add support for OLE DB IRowsetLocate interface. This will enable recordsets created to support bookmarks.



CR:399741
CR Number:   399741
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE-DB: Version 2.70.0052 may hang executing certain stored procedures with "Select Method = Cursor".
Workaround Description
 Perhaps use "Select method = direct"



CR:399753
CR Number:   399753
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 001 12 Sep 2005 Fixed
Description
Binary output pipes were returned as character instead of binary columns.



CR:399867
CR Number:   399867
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Fixed
29 Aug 2005 Fixed
Description
CPRE: cpre truncates the size of text inserts to 16K.



CR:399917
CR Number:   399917
Product Name:   jConnect
Product Component:   jutils
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2005 Fixed
Description
jConnect: DatabaseMetadata.getProcedureColumns() returns incorrect length for ASA connections.



CR:399924
CR Number:   399924
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 001 09 Sep 2005 Fixed
Description
sp_capabilities should return 0 for object case sensitivity.



CR:399934
CR Number:   399934
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2009 Fixed
05 Aug 2009 Fixed
Description
Problem: Need to add breakpoint and bookmark related context menu in SQL Editor.

Workaround: 1. Shortcut key 'CTRL+SHIFT+B' is used to set a breakpoint quickly. This feature may meet the first requirement. 2. Set an individual RulerContextMenuId for SQL Scrapbook, and create a popupMenu "Add Bookmark...". UI changes: a. Added "Bookmarks" view as one of "Database Development" perspective default views. b. Added "Bookmarks" view shortcut.



CR:399989
CR Number:   399989
Product Name:   Connectivity Utilities
Product Component:   defncopy
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2005 Fixed
06 Oct 2005 Fixed
Description
DEFNCOPY: On UNIX platforms, suppress the password that is visible from the command line when running defncopy with '-P<password>' argument.



CR:400217
CR Number:   400217
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2005 Fixed
Description
jConnect: Unable to create a scrollable ResultSet object that contains a JAVA_OBJECT type.



CR:400339
CR Number:   400339
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2005 Fixed
12 Sep 2005 Fixed
Description
CTLIB: existing synchronous connections always use the old timeout value even when CS_TIMEOUT has been updated by ct_config.



CR:400577
CR Number:   400577
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 004 11 Oct 2005 Fixed
Description
ISQLCICS abended when running any query after SP_HELP had been run.



CR:400695
CR Number:   400695
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#1 001 09 Sep 2005 Fixed
12.50.10 005 31 Jul 2006 Fixed
Description
OSC performed ASCII to EBCDIC conversion even if the column was NULL, returned a Truncation error.



CR:400805
CR Number:   400805
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2005 Fixed
25 Aug 2005 Fixed
Description
OLE DB Provider by Sybase: Empty record set returned when calling stored procedures with parameters.



CR:400849
CR Number:   400849
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2005 Fixed
Description
BLKLIB: blk_done(CS_BLK_ALL) after blk_done(CS_BLK_CANCEL) can send an incorrect TDS

token stream to ASE causing a server error message. No invalid data is inserted.



CR:400950
CR Number:   400950
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2006 Fixed
Description
OLEDB: In an ADO application, when executing a SELECT statement with CursorLocation=adUseClient and connected to Open Switch, an unspecified error is thrown.



CR:401332
CR Number:   401332
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 31 Jan 2006 Fixed
Description
ODBC Driver by Sybase: Add support for scrolling by Bookmark.



CR:401492
CR Number:   401492
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 15 Mar 2006 Fixed
Description
ODBC Driver by Sybase: Request 32-bit ASE ODBC Driver to be certified on 64-bit Windows x64 platform.



CR:401541
CR Number:   401541
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
setting dbcctraceon 3604 , 1217 (or 1212) and then selecting from a table that has a text column will cause isql to terminate its connection.
Workaround Description
 use 3605 to send it to errorlog instead of 3604



CR:401723
CR Number:   401723
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 002 08 Sep 2005 Fixed
Description
CSP sp_databases did not return correct results.



CR:401774
CR Number:   401774
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
Description
ADO.NET: Memory leak observed in ADO.NET Data Provider when Connection pooling is enabled.



CR:401992
CR Number:   401992
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2005 Fixed
Description
jConnect: Exception JZ0EM is being thrown on Connection.close() internally and seen in debug output. This causes some unnecessary code being executed.



CR:402050
CR Number:   402050
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
Description
ODBC Driver by Sybase: Improve SQLGetTypeInfo performance by caching results from previous queries to ASE.



CR:402184
CR Number:   402184
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2007 Duplicate
Description
New feature that allows Open Server to cache the interfaces file in memory.

Includes a registered procedure "rp_refresh_interfaces" which allows the user

to refresh the interfaces file at will.
Workaround Description
 Use a small interfaces file.



CR:402337
CR Number:   402337
Product Name:   Open Client
Product Component:   dblib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Hostnames greater than 30 characters cannot be handled by dblib interfaces code. Customers are forced to create and use shorter alias names.
Workaround Description
 Make a short alias for long hostnames.



CR:402352
CR Number:   402352
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 002 08 Sep 2005 Fixed
Description
OCC used binary zeros instead of spaces to pad Char/VarChar data types.



CR:402365
CR Number:   402365
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.05 01 Dec 2005 Fixed
01 Dec 2005 Fixed
Description
jConnect: Inconsistent update counts returned by execute/executeUpdate/executeBatch functions when IGNORE_DONE_IN_PROC and DYNAMIC_PREPARE connection properties are set to true and a trigger will be invoked by the query.



CR:402422
CR Number:   402422
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6.ESD1 002 08 Sep 2005 Fixed
Description
Incorrect padding character was used by OCC in ct_bind.



CR:402886
CR Number:   402886
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
Description
ODBC Driver by Sybase: Request to add support for SQL initialization string, which will contain SQL statement(s) that will be executed after a new database connection has been established.



CR:402890
CR Number:   402890
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
Description
OLE DB Provider by Sybase: Request to add support for SQL initialization string, which will contain SQL statement(s) that will be executed after a new database connection has been established.



CR:402893
CR Number:   402893
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.15 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
Description
ADO.NET: Request to add support for SQL initialization string, which will contain SQL statement(s) that will be executed after a new database connection has been established.



CR:402910
CR Number:   402910
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2005 Fixed
21 Nov 2005 Fixed
22 Dec 2005 Fixed
09 Dec 2005 Fixed
23 Dec 2005 Fixed
05 Jan 2006 Fixed
02 Mar 2006 Fixed
31 Jan 2006 Fixed
31 Jan 2006 Fixed
03 Feb 2006 Fixed
22 May 2007 Not a Bug
Description
DBLIB: On Windows 32bit, Solaris 32bit/64bit and Linux 32bit, DBLibrary now supports to be activated for the Kerberos authentication and mutual authentication features. To activate this feature, it is required:

(1) For version 15.0

SDK 15.0 ESD #3 (or later) and Sybase DBLib Kerberos Authentication Option 15.

(2) For veresion 12.5.1

SDK 12.5.1 ESD #12 (or later) and Sybase DBLib Kerberos Authentication Option 12.5.



CR:403143
CR Number:   403143
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add an RPC rp_traceflag to CTOS to make SRV_S_TRACEFLAG flags dynamic



CR:403378
CR Number:   403378
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2006 Fixed
Description
Customer wants OpenSwitch 12.5.1 certified on Linux AMD64



CR:403523
CR Number:   403523
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#2 30 Jan 2006 Fixed
1.1 ESD#12 30 Jan 2006 Fixed
Description
ADO.NET: XmlReader.Read() fails when result set contains data from a Unitext table column.



CR:403696
CR Number:   403696
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2005 Fixed
27 Sep 2005 Fixed
28 Sep 2005 Fixed
28 Sep 2005 Fixed
Description
CTLIB: Dynamic SQL client may get stack corruption from ct_fetch().



CR:403838
CR Number:   403838
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2005 Fixed
06 Jan 2006 Fixed
12 Apr 2013 Presently Not Targeted For Any Future Release Of This Product
Description
This feature implements scrollable cursor functionality in Open Server. The 'ctos' sample
has been changed to allow scrolling.



CR:403919
CR Number:   403919
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2005 Fixed
16 Sep 2005 Fixed
Description
jConnect: Calling setAutocommit(false) twice gives Exception: SQLException: JZ016: The AutoCommit option is already set to false.



CR:403945
CR Number:   403945
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2006 Fixed
Description
jConnect: Request to support JDBC 3.0 ResultSet holdability feature.



CR:404027
CR Number:   404027
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2006 Fixed
Description
ADO.NET: New feature request to provide a connection parameter that will cause driver to ignore raiseerror conditions and continue execution of the stored procedure.



CR:404071
CR Number:   404071
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 01 10 Nov 2005 Fixed
12.6 ESD#2 005 10 Nov 2005 Fixed
Description
MFC Client Option for CICS API CTBCANCEL ends abnormally or returns TDS_INVALID_CONHANDLE



CR:404088
CR Number:   404088
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2005 Fixed
28 Sep 2005 Fixed
Description
CTLIB: When HA failover has completely failed during ct_results(), there is no error message displayed to indicate that the connection has failed.



CR:404560
CR Number:   404560
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 19 May 2006 Fixed
Description
OLE DB Provider by Sybase: Cannot get the error number fom an error raised by raiseerror.



CR:404571
CR Number:   404571
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2005 Fixed
Description
OLEDB: A raiserror is not considered as an error anymore. ADO applications exit as if there was no error.



CR:404628
CR Number:   404628
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2005 Fixed
11 Nov 2005 Fixed
Description
CPRE: HA ESQL/C application crashes during failover in ct__tds_dynres_undo



CR:404648
CR Number:   404648
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2005 Fixed
Description
In a mutually-aware setup, if a network connection is lost with a companion OpenSwitch and later restored, the companion that has experienced the total network failure will shut itself down, but the other companion will not notice it, and will try to connect to it continuously in a loop, and any "rp_*" commands involving communicating with the companion will hang.



CR:404983
CR Number:   404983
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 01 29 Mar 2006 Fixed
Description
MFC Server Option for CICS, dynamic execution of an SQL Insert statement into a numeric column using a parameter returns an error



CR:405263
CR Number:   405263
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Fixed
28 Oct 2005 Fixed
Description
The CM timer may become a bottleneck if it does an operation such as a cm_ping to a very busy ASE.



CR:405441
CR Number:   405441
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Fixed
Description
An OpenSwitch which has been defined as a mutually-aware companion for another OpenSwitch is currently allowed to start even if its MUTUAL_AWARE configuration parameter is set to 0. Such "hibrid" clusters (where one companion is mutually-aware and the other isn't) should not be allowed, and a check should be put in to prevent the second server from starting. In the meantime please make sure that both companions in the OpenSwitch cluster have MUTUAL_AWARE set to 1 before you start them.



CR:405551
CR Number:   405551
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2005 Fixed
Description
When the network to a companion OpenSwitch is down and CMP_FAIL_ACTION is set to MANUAL, the server status can still be changed before 'rp_go' is issued, even when FREEZE_CFG_ON_FAIL is set to 1.



CR:405561
CR Number:   405561
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Fixed
Description
When OpenSwitch is running with MUTUAL_AWARE set to 1, executing "rp_cfg" causes a core dump. Use the other RPCs instead to change a configuration parameter, for example, "rp_set" to change a [CONFIG] parameter, "rp_pool_*" to modify the pool section, or "rp_server_*" to modify the server section.



CR:405579
CR Number:   405579
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
If RCM_AUTOSTART is used to start an RCM for a secondary OpenSwitch, and this RCM is later shut down, the secondary OpenSwitch might experience a segmentation fault when it tries to handle a server failover after the RCM has gone down.



CR:405764
CR Number:   405764
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 10 Nov 2005 Fixed
Description
MFC Server Option for CICS, Terminal Security needs to work for gatewayless connections



CR:405769
CR Number:   405769
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2005 Fixed
07 Nov 2005 Fixed
Description
DBLIB: On Windows, dbpoll crashes when NULL dbproc is used.



CR:405858
CR Number:   405858
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2005 Fixed
11 Jan 2006 Fixed
Description
BCP: bcp in to a table with an index that has "ignore_dup_key" enabled will cancel the batch that contains duplicate rows.
Workaround Description
 1) Use the "bcp" executable from a release prior to 12.5.1 ESD#4.

2) Omit the "-b" flag and use the default batch size of 1000.



CR:405864
CR Number:   405864
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2005 Fixed
Description
OLEDB: Application hangs when executing simple SELECT of 'text' data from within a transaction if "CursorLocation = adUseClient" and "Select Method=Direct".
Workaround Description
 Use Select Method = Cursor, or cursor location to default (server) or don't run SELECT in a transaction.

Also, changing lock type to adLockUnspecified or adLockReadOnly also avoids the hang.



CR:406034
CR Number:   406034
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 02 29 Mar 2006 Fixed
Description
MFC Server Option for CICS, using ASE 15.0, tests for unsigned integers with update statements fail



CR:406039
CR Number:   406039
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Mar 2006 Fixed
Description
The Install Steps, out of order for TRS CSP, need to create Tables,before binds, in the MFC 12.6 DB2 UDB for CICS install Guide



CR:406102
CR Number:   406102
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2005 Fixed
26 Oct 2005 Fixed
Description
ISQL/BCP/DEFNCOPY: Closing stdin before an exec of this utility could cause a 'write to pipe' error.



CR:406117
CR Number:   406117
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Fixed
10 Nov 2005 Fixed
Description
CTLIB: On non-threaded platforms, synchronous connection with CS_ASYNC_NOTIFS set is not receiving notifications.
Workaround Description
 Changing the sleep(1) loop to do a ct_poll will make it work.



CR:406384
CR Number:   406384
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT DOC
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2006 Not a Bug
Description
This doc CR applies to both MFC Server Option versions 12.5.x and 12.6.x.



The Customers may not be familiar with CICS Executive Interface Block Function (EIBFN), thus, would not be able to decipher the cryptic error message in the CICS log and diagnose that the root cause, namely: having MFC OSC configured with trace options enabled (see below)without enabling CICS AUXILLLARY Trace config parameters in the CICS System Initiatilisation Table (SIT).



MFC OSC Trace options:

DEBUGSW=Y (in source module "SYOSCUST")

TRACE=ON (in source module "SYLSCFG")



<Hints & Tips on enabling CICS AUX Trace:

In order for Sybase to write out to the CICS Aux Trace Facility these CICS System Initialization(SIT) Parameters must be on

+ INTTR=ON

Code this parameter to specify whether the internal CICS trace destination is to be activated at system initialization.

+ SYSTR=ON

Code this parameter to control the master system trace flag.

+ USERTR=ON

Code this parameter to set the master user trace flag on or off. If this Parameter is set to off, then the EXEC CICS ENTER TRACENUM command will receive an INVREQ condition if EXCEPTION is not specified. If the program does not handle this condition the transaction will abend with a AEIP.>



CR:406401
CR Number:   406401
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 EOL'd version. Not to be Fixed.
Description
CTLIB: CT-Lib incorectly enables pthread cancelability which can break existing applications if the user code has this disabled.
Workaround Description
 None known.



CR:406460
CR Number:   406460
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#3 31 Jan 2006 Fixed
1.1 ESD#13 31 Jan 2006 Fixed
Description
ADO.NET: Can't use a cloned connection if the parent connection string is not set.



CR:406589
CR Number:   406589
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Fixed
31 Oct 2005 Fixed
Description
Currently, a mutually-aware OpenSwitch can start up even if its companion-sensitive configuration parameters are different from those on its companion. The correct behavior is that the OpenSwitch should fail to start, and an appropriate message explaining the nature of the failure should be displayed. The companion-sensitive configuration parameters are MUTUAL_AWARE, MUTUAL_CLUSTER, FREEZE_CFG_ON_FAIL, UPDATE_CFG, SVR_FAIL_ACTION, CMP_FAIL_ACTION, NET_FAIL_ACTION, and all ASE Servernames in the [SERVER] and [POOL] sections.



CR:406707
CR Number:   406707
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2005 Fixed
30 Oct 2005 Fixed
14 Nov 2005 Fixed
15 Feb 2006 Fixed
15 Dec 2005 Fixed
Description
With PING_THREAD set to 1, OpenSwitch would run out of memory and file descriptors after awhile.
Workaround Description
 PING_THREAD = 0





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