远程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:406722
CR Number:   406722
Product Name:   Organic OLE DB Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#12 13 Oct 2005 Fixed
Description
ODBC Driver by Sybase: Installing the Driver Meta Data SQL scripts will leave the Adaptive Server with 'allow updates' enabled.
Workaround Description
 Edit script and change to:

sp_configure 'allow updates',0

go

print 'Installed sp_version...'

go



CR:406830
CR Number:   406830
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2005 Fixed
Description
OpenSwitch CMON connection to set CS_APPNAME and CS_HOSTNAME.



CR:406880
CR Number:   406880
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 31 Jan 2006 Fixed
12.5.1 ESD#12 31 Jan 2006 Fixed
Description
OLE DB Provider by Sybase: Arithmetic overflow errors encountered using Decimal or Numeric data types in ADO recordset.AddNew or OLE DB IRowsetChange::InsertRow methods.



CR:406944
CR Number:   406944
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
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 server is in a LOCKED state when a client tries to connect, and the server status is later changed to UP, the clients that were blocking will fail over to the next available server if the command to change the status came from another OpenSwitch.



CR:406946
CR Number:   406946
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
17 Oct 2005 Duplicate
Description
During a server failure, if the SVR_FAIL_ACTION script (custom or manual) returns with an exit code of '2', the idle clients connected to this server can be left in a hanging state, when they should be disconnected.



CR:407009
CR Number:   407009
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 31 Jan 2006 Fixed
Description
ADO.NET: Using DTC transactions with non-pooled database connections may cause errors in application.



CR:407036
CR Number:   407036
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2005 Fixed
Description
If the network of the primary OpenSwitch companion goes down and the primary companion goes down as a result of it, future configuration changes on the secondary companion, such as setting the server status with rp_server_status, are not written to the configuration table on the CFG_STORAGE Adaptive Servers.



CR:407048
CR Number:   407048
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2005 Fixed
25 Oct 2005 Fixed
Description
If a primary Adaptive Server failure occurs when one companion OpenSwitch is servicing at least one busy client, and another companion is servicing only idle client(s), the user action script (if SVR_FAIL_ACTION is set to CUSTOM or MANUAL) might be executed twice, once on each companion OpenSwitch.



CR:407276
CR Number:   407276
Product Name:   Open Client-Doc
Product Component:   Client-Library C Reference Manual
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 23 Dec 2008 Fixed
Description
Current documentation does not detail how the signal handling of threaded programs is accomplished. The documentation does not detail customer responsibilites or how he is to setup his own signal handling to coexist with Sybase behavior.



CR:407280
CR Number:   407280
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sybase OLEDB: does not support ADODB.Connection.OpenSchema() functions.
Workaround Description
 Use DataDirect OLE-DB provider.



CR:407294
CR Number:   407294
Product Name:   Open Client
Product Component:   blklib
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Want blk_rowxfer, blk_rowxfer_mult and blk_done to return CS_CANCELED if canceled

from ct_cancel().



CR:407646
CR Number:   407646
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: Applications may get Socket Closed error when they request and use larger packet sizes than the ASE default.
Workaround Description
 Configure ASE 'default packet size' to equal that requested by the client.



CR:407680
CR Number:   407680
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 07 23 Mar 2006 Fixed
Description
Connnection Router Transaction still list the 12.5.01 version String



CR:407783
CR Number:   407783
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)
04 Oct 2012 EOL'd version. Not to be Fixed.
Description
SP_MDA, COBOL prog SPMDACSP, writing info to temp storage, should be written to Memory



CR:407805
CR Number:   407805
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2005 Fixed
02 Dec 2005 Fixed
16 Feb 2006 Fixed
05 Dec 2005 Fixed
17 Feb 2006 Fixed
Description
SRVLIB:In srv_dbg_stack(), the return value of the user-provided function is not checked. If the return value is CS_FAIL, the stack trace is terminated.



CR:407845
CR Number:   407845
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)
04 Apr 2006 Fixed
Description
ODBC: Money output parameter returns an incorrect value.

ASE returns the correct value, but ODBC delivers a huge number.



CR:407931
CR Number:   407931
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a jConnection connection attempt is made with a url like: jdbc:sybase:Tds:localhost:5000/pubs2, if the database pubs2 is unavailable a SQLWarning is thrown and not a SQLException. Because the context of the connection is wrong, SQLWarnings often not checked and the circumstances are relatively rare; user sql can fail/hang presenting production problems.
Workaround Description
 Set the "sqlinitstring=use <database>", on the connection this will throw an exception.



CR:407939
CR Number:   407939
Product Name:   jConnect
Product Component:   Ribo
Status:   Closed
OS:   Solaris
Original Version:   6.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2005 Not a Bug
Description
Ribo does not display the TDS state transition that is recorded in the raw TDS



CR:408233
CR Number:   408233
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)
30 Oct 2005 Fixed
Description
ODBC: When inserting Chinese character data into Sybase database with charset=UTF8 using invalid SQL_TYPE of SQL_LONGVARCHAR, a crash occurred.



CR:408348
CR Number:   408348
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.1 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#6 21 Dec 2006 Fixed
Description
ADO.NET: ExecuteReader(CommandBehavior.SingleRow) does not restrict a result set to a single row.
Workaround Description
 Use 'set rowcount 1' or 'top' syntax with ASE 12.5.3.



CR:408376
CR Number:   408376
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 27 Mar 2006 Fixed
Description
MFC Server Option for CICS, Date and Time data types missing from sp_jdbc_datatype_info CSP call result



CR:408575
CR Number:   408575
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2013 Fixed
Description
ODBC Driver by Sybase: A run-time error 40002 is raised when trying to update a row on a Visual Basic 6.0 application using RDO.



CR:408725
CR Number:   408725
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2005 Fixed
22 May 2007 Not a Bug
Description
SRVLIB: Clients on little-endian hosts (linux, nt386) are not able to connect to open

servers on Linux IBM pSeries.



CR:408741
CR Number:   408741
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2007 Fixed
15 Jan 2008 Fixed
09 Jan 2008 Fixed
18 Feb 2008 Fixed
Description
ISQL: Allow dynamic redirection of query output results to a file (> or append it with >>), or piping them through utility programs. This corresponds to ISUG enhancement request #2801.



CR:408746
CR Number:   408746
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2007 Fixed
Description
ISQL: This CR adds the --retserverror command line option to isql.

When set, isql exits whenever a server error is encountered with a severity >= 11. With this option, when a 'real' server error is received, isql will return '2' to the calling program (shell/command prompt) and write 'Msg[tab][server error nbr.]' to stderr.
Target Version
 15.0 ESD#10



CR:408759
CR Number:   408759
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for the ability to customize the isql prompt so that it shows the servername:



isql -Uusername -Sservername -P

SERVERNAME:(1)>

SERVERNAME:(2)>



CR:408760
CR Number:   408760
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#3 25 Oct 2006 Fixed
Description
SP_MDA CSP writes too many records to Temporary Storage on CICS startup.



CR:408892
CR Number:   408892
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2005 Fixed
07 Dec 2005 Fixed
18 Dec 2005 Fixed
12 Jan 2006 Fixed
Description
DBLIB: A dblib application may hang on HP Itanium or HP PA-RISC platform if the application has more than 32 or 1024 open files respectively.
Workaround Description
 Open database connections before opening other files.



CR:408906
CR Number:   408906
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2005 Fixed
Description
SRVLIB: Clients connecting to Open Server application using Kerberos may hit error: "ct_connect(): network packet layer: external error: There is a protocol packet error. An illegal length was received "



CR:409120
CR Number:   409120
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2006 Fixed
15 Jun 2006 Fixed
15 Jun 2006 Fixed
16 Jun 2006 Fixed
30 Jun 2006 Fixed
22 Jun 2006 Fixed
22 Jun 2006 Not a Bug
22 Sep 2006 Fixed
Description
SRVLIB: This implements a new token TDS_DBRPC2. With this implementation a fully qualified rpc name can now be greater than 255 bytes, but the individual component of the rpc name is still limited to 255 bytes



CR:409193
CR Number:   409193
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2006 Duplicate
Description
Certification of OpenSwitch 12.5.x on Red Hat EL 4.0 (AMD64/EM64T)



CR:409358
CR Number:   409358
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2005 Fixed
20 Jan 2006 Fixed
23 Jan 2006 Fixed
Description
Existing connections hang if the CMON of Secondary ASE is invalid.



CR:409514
CR Number:   409514
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 Jan 2006 Fixed
Description
jConnect: Request to update documentation files installed in $SYBASE/jConnect-6_0/docs directory.



CR:409589
CR Number:   409589
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CT-Lib: enhance ct_res_info() to return the last error message struct received from the server.
Workaround Description
 Use inline message handling via ct_diag() or CS_USRERDATA populated by the callback handler. Both of these solutions make for much more complicated application code.



CR:409629
CR Number:   409629
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT for IMS/MVS
Status:   Closed
OS:   MVS IMS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 29 Mar 2006 Fixed
Description
SRYT IMS EBFI0368 is returning the wrong message on an error

"33607..SYBASE..CATRPC.REQUESTED MODULE NOT LOADED"



CR:409633
CR Number:   409633
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2006 Fixed
01 Dec 2005 Fixed
01 Dec 2005 Fixed
Description
jConnect: The length of table name, column name input arguments in the MDA stored procedures used by the jConnect driver are not long enough to account for names with escape characters like [_].



CR:409766
CR Number:   409766
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 16 May 2006 Fixed
Description
OLE DB Provider by Sybase: Add support for OLE DB Services. These are used for automatic transaction enlistment apart from other uses.



CR:409793
CR Number:   409793
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows Vista
Original Version:   12.5.3 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2009 Fixed
02 Nov 2009 Fixed
02 Nov 2009 Fixed
Description
OLE DB Provider by Sybase: Cannot install OLE DB meta-data stored procedures if ASE db option "allow nulls by default" is set to true.
Workaround Description
 The workaround is to turn off 'allow nulls by default'



sp_dboption "sybsystemprocs", "allow nulls by default", false

-- then run installmaster



CR:409921
CR Number:   409921
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2006 Fixed
17 Feb 2006 Fixed
Description
OpenSwitch crashes on Windows if the environment variable %TMP% has spaces in it. This happens at boot time for Mutually-aware OpenSwitch, or after the first client is connected without mutually-aware but with PING_THREAD set to 1.



CR:414593
CR Number:   414593
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 02 23 Jan 2006 Fixed
Description
MFC Client Option for CICS overlays storage when fetching a Nullabe Char with 1 byte of data in the column



CR:414608
CR Number:   414608
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)
30 Jan 2013 EOL'd version. Not to be Fixed.
Description
bcp should allow inserts to tables with timestamp column specifying not null even

if the data file to be copied in does not contain data for the timestamp column.



CR:414657
CR Number:   414657
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 May 2013 Fixed
Description
ODBC Driver by Sybase: The length of table name, column name input arguments in the MDA stored procedures used by the ODBC Drivers are not long enough to account for names with escape characters like [_].



CR:414693
CR Number:   414693
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
02 Mar 2006 Fixed
20 Mar 2006 Fixed
23 Mar 2006 Fixed
23 Mar 2006 Fixed
12 May 2006 Fixed
Description
RCM attempts to do the replication switch more than once when a failover situation occurs. The subsequent switch attempts will fail and have no impact on client applications.



CR:414784
CR Number:   414784
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
21 Mar 2006 Fixed
Description
In a Mutual Aware Setup with SVR_FAIL_ACTION set to MANUAL, CUSTOM or CUSTOM_MANUAL, if all existing clients on OpenSwitch are idle when a ASE Server fails, and a new client attempts to connect after that but before the existing clients become busy again, the new client is connected to the Secondary ASE data server, but the existing clients hang.
Workaround Description
 Workaround: You will not run into this problem if you have SVR_FAIL_ACTION set to DEFAULT. If you have SVR_FAIL_ACTION set to CUSTOM, MANUAL or CUSTOM_MANUAL, make sure that there is at least one busy client connected to the OpenSwitch at all times. If not all of your clients are busy all the time, you can create a busy client running in the background by creating a sql script, say busy.sql, with the following content:



while (1=1)

waitfor delay "00:30"

go



Run this script through isql in the background as a regular user to OpenSwitch:

isql -U<username> -P<password> -S<OpenSwitch_name> -i busy.sql &



You should run this on both OpenSwitch companions. The server failure can be detected by the busy client as soon as it occurs, and handled appropriately.



CR:414785
CR Number:   414785
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2006 Not reproducible with latest version of the product available as of Resolution Date
05 Sep 2006 Not reproducible with latest version of the product available as of Resolution Date
Description
If you return with an exit status of 1 from NET_FAIL_ACTION CUSTOM or MANUAL scripts, after the network is successfully restored any changes you make to the pool/server may not get synced with its companion.
Workaround Description
 To workaround this issue always return an exit status of 0 from the CUSTOM or MANUAL scripts for NET_FAIL_ACTION.



CR:415430
CR Number:   415430
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)
05 Dec 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Customer and we need to have Milli Secs in the OSC Tracing written to the CSML



CR:415517
CR Number:   415517
Product Name:   Embedded SQL/COBOL-Doc
Product Component:   COBOL Supplement
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2006 Fixed
Description
Programmer's Supplement missing lower case options for cobpre
Workaround Description
 Use the 12.5.1 documentation



CR:415556
CR Number:   415556
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2006 Fixed
15 Feb 2006 Fixed
Description
When the network between OpenSwitch and the primary ASE server breaks, the first client that tries to connect to the primary ASE Server through OpenSwitch can take several minutes to detect the failure, even with PING_THREAD set to 1.
Workaround Description
 Set the client's login timeout to a high value ( recommended value : 240 seconds or higher ).



CR:415689
CR Number:   415689
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2005 Fixed
01 Jan 2006 Fixed
Description
When CMP_FAIL_ACTION is set to CUSTOM, MANUAL or CUSTOM_MANUAL, OpenSwitch does not execute the custom or manual script during a network outage between the companions. You can see the following messages about failure to suspend the pools and execute the scripts.



manual_action: Executing manual.sh (server=sosw, reason=1006)

pool_set_prop_atomic: Failed to preset pool status in companion.

coord_suspend: Cannot change status of pool POOL1 to SUSPENDED

manual_action: Suspending OpenSwitch failed.

do__useraction: Failed to execute the manual script for CMP_FAIL_ACTION. Check the error messages above for reasons of failure.

All future changes to the server/pool configuration are prohibited.



CR:415798
CR Number:   415798
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2007 Fixed
09 Mar 2006 Fixed
Description
The problem occurs if we hit a error while force closing a socket during a network failure. The Secondary Companion OpenSwitch's configuration may get out of sync with the Primary Companion OpenSwitch's configuration.
Workaround Description
 Workaround: Make sure that there is at least one busy client connected to the Primary Companion OpenSwitch at all times. If not all of your clients are busy all the time, you can create a busy client running in the background by creating a sql script, say busy.sql, with the following content:



while (1=1)

waitfor delay "00:30"

go



Run this script through isql in the background as a regular user to OpenSwitch:

isql -U<username> -P<password> -S<OpenSwitch_name> -i busy.sql &



The server failure can be detected by the busy client as soon as it occurs, and handled appropriately.



CR:415891
CR Number:   415891
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT DOC
Status:   Closed
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 29 Mar 2006 Fixed
Description
MFC Client Option for CICS 12.6 documentation does not list error message -275 TDS_LICENSE_CHECK_FAIL



CR:415910
CR Number:   415910
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 02 13 Apr 2006 Fixed
Description
MFC Server Option for CICS, attribute DEFAULT_TXN_ISOLATION row missing from the result of sp_server_info CSP call



CR:416078
CR Number:   416078
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
25 Jan 2006 Fixed
Description
CTLIB: Enable MIT Kerberos 1.4.3 support for HPUX64.



CR:416247
CR Number:   416247
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Unable to retrieve data from columns of timestamp data type in a ASE 15.0 database.



CR:416248
CR Number:   416248
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 10 Jan 2007 Fixed
12.5.1 ESD#16 10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLColumns returns type name varchar for timestamp data type.



CR:416250
CR Number:   416250
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 10 Jan 2007 Fixed
12.5.1 ESD#16 10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLColumns returns type names varchar and char for nvarchar and nchar data types respectively.



CR:416262
CR Number:   416262
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLProcedureColumns does not return correct information for stored procedure parameters of type bigint.



CR:416419
CR Number:   416419
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jan 2006 Fixed
16 Jan 2006 Fixed
Description
BLKLIB:bcp through open server crashes the open server in blk_50_sendrow when copying in row data that has several trailing NULLs.
Workaround Description
 bcp directly to ASE and bypass the Open Server



CR:416448
CR Number:   416448
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
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#2 19 May 2014 Insufficient priority to fix
12.5.1 ESD#12 19 May 2014 Insufficient priority to fix
15.7 SP130 30 May 2014 Fixed
Description
OLE DB Provider by Sybase: ASE Data Source Administrator connection fails if the charset is capitalized



CR:416449
CR Number:   416449
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 07 24 Mar 2006 Fixed
Description
MFC Server Option for CICS returns incorrect error code for license key error



CR:416541
CR Number:   416541
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Request for ODBC driver to implement SQLPutData to handle long data values in manageable chunks.
Workaround Description
 None known.



CR:416737
CR Number:   416737
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2006 Fixed
06 Apr 2006 Fixed
21 Feb 2006 Fixed
Description
DBLIB: A dblib application may fail on HP Itanium if the application has set the file descriptor limit to be more than 2048 with the following error:

Operating-system error:

Bad file number
Workaround Description
 Reset setrlimit(RLIMIT_NOFILE,) to FD_SETSIZE.



CR:416759
CR Number:   416759
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2006 Fixed
02 Feb 2006 Fixed
01 Feb 2006 Fixed
Description
jConnect: Request to support getDatabaseMajorVersion(), getDatabaseMinorVersion(), getJDBCMajorVersion() and getJDBCMinorVersion() functions on the DatabaseMetaData class.



CR:416869
CR Number:   416869
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB Driver needs to return more specific error messages for kerberos to the client applications



CR:417005
CR Number:   417005
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)
11 Aug 2006 Presently Not Targeted For Any Future Release Of This Product
Description
IBMLISTNR message thats a catch all

35039,' TRAN START ERROR: TRANSACTION %s NOT DEFINED IN THE PCT OR IS DISABLED.'

Needs to change.



CR:417041
CR Number:   417041
Product Name:   Open Client-Doc
Product Component:   Release Bulletin
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 19 Apr 2006 Fixed
12.5.1 26 Jan 2006 Fixed
Description
Require Solaris libsocket patch: #111328-04: SunOS 5.8_x86 to avoid

Repserver memory leak.
Workaround Description
 Install Solaris patch: #111328-04: SunOS 5.8_x86: libsocket patch



CR:417233
CR Number:   417233
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 07 23 Mar 2006 Fixed
Description
An abnormal end occurs in MFC Server Option for CICS with CICS SIT parameter XUSER=YES and CICS surrogate user defined to RACF with insufficient authority



CR:417417
CR Number:   417417
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect should throw proper exception XAER_HEUR type return codes when transactions have been "prepared", dbcc complete_xact(commit | rollback) but not heuristically forgotten via dbcc forget_xact().
Workaround Description
 Workaround is to be sure to run dbcc forget_xact() for any heuristic transactions.



CR:417539
CR Number:   417539
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.5 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
jConnect: For User-defined datatypes, the DatabaseMetadata.getColumns(TYPE_NAME) returns the underlying native datatype name and not the User-defined datatype name.
Workaround Description
 Get the column type info from getTypeInfo() vs. getColumns)



CR:417585
CR Number:   417585
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 Not a Bug
Description
An ommission from the Install and Admin Guide for MainframeConnect Server/Client Options (see Appendix A) - when configuring OSC 12.6 to use IBM z/OS conversion utility and services (i.e. USEIBMUNICODE=Y), OSC specific non-ER conversion definition entries must be manually added before generating the IBM z/OS conversion image using CUNMIUTIL.



CR:417628
CR Number:   417628
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 07 27 Mar 2006 Fixed
Description
MFC Server Option for CICS, non-DB2 CSP sp_datatype_info returns an out-of-range precision value of 4GB for IMAGE data type and causes ODBC error message



CR:417711
CR Number:   417711
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: When sending the statement "WRITETEXT table_name.column_name, text_pointer, text_data" from the OLE DB application to ASE, and if the text_data contains the substring "exec" then the OLEDB provider considers the rest of the string following "exec" as a stored procedure name. Thus, ASE fires the error "Stored Procedure sproc_name not found. Specify owner.objectname or use sp_help to check that the object exists".



CR:417721
CR Number:   417721
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)
18 Jan 2006 Fixed
19 Jan 2006 Fixed
Description
jConnect: Statement.getUpdateCount() does not return a valid update count after Statement.executeUpdate() is executed.



CR:417723
CR Number:   417723
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: metadata is not availble after SQLPrepare...causing the odbc application to stop abnormally
Workaround Description
 Set the driver property "Dynamic Prepare" to "ON".



CR:417755
CR Number:   417755
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 03 26 May 2006 Fixed
Description
In MFC Server Option for CICS, introduce support for RPC names with the format of "dbname..rpcname"



CR:417760
CR Number:   417760
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)
04 Apr 2006 Fixed
Description
ODBC: With COMPUTE clause in a SQL query, the compute result set is not being retrieved by driver, but it is being sent in the response from the ASE.



CR:417914
CR Number:   417914
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.NET: Connecting to OpenSwitch as an admin user fails



CR:418120
CR Number:   418120
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2006 Fixed
Description
BCP: bcp stops when ASE encounters a duplicate key row in a batch (e.g. -b1)
Workaround Description
 Use bcp from version 12.5.1



CR:418124
CR Number:   418124
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2006 Fixed
Description
ODBC Driver by Sybase: When using SQLDriverConnect with SQL_DRIVER_PROMPT Option, changes made to the connect string in the prompt dialog are not reflected in the OutConnectString.



CR:418260
CR Number:   418260
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
Description
jConnect: NullPointerException when updateTimestamp() method is called.



CR:418275
CR Number:   418275
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2008 Fixed
Description
Request for ASE ADO.NET 2.0 Provider.



CR:418335
CR Number:   418335
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2006 Fixed
23 Feb 2006 Fixed
Description
CPRE: cpre occasionally gives Access Violations precompiling some source files.
Workaround Description
 None known at this time.



CR:418449
CR Number:   418449
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#18 07 Apr 2009 Duplicate
Description
ADO.NET: New feature request for ASE ADO.NET Data Provider to trim blanks from a null "char" column.



CR:418530
CR Number:   418530
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   5.5 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SQLWarnings chained off Statements should be cleared on execute() of a statement. Not clearing the SQLWarnings can lead to memory leaks.
Workaround Description
 call <statement>.clearWarnings(); explicitly or process all SQLExceptions instead of some of them.



CR:418625
CR Number:   418625
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#9 08 Dec 2013 Fixed
12.5.1 ESD#19 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Fetching numeric data with scale = 0, bound as SQL_C_CHAR returns a string with a trailing decimal point. So number zero is returned as "0."



CR:418664
CR Number:   418664
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2008 Fixed
09 Jun 2008 Fixed
09 Jan 2008 Fixed
09 Jan 2008 Fixed
25 Oct 2010 Fixed
17 Dec 2010 Fixed
Description
jConnect: Implement support for ASE Cluster Edition features: Login redirection, Connection migration and extended failover.



CR:418913
CR Number:   418913
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 16 Jan 2007 Fixed
12.5.1 ESD#15 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: String columns with null characters embedded in the value are truncated after the first null character.
Target Version
 15.0 ESD#3



CR:419030
CR Number:   419030
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2006 Fixed
12.5.1 ESD#13 02 May 2006 Fixed
Description
ODBC Driver by Sybase: Binding a datetime column to SQL_C_TYPE_DATE returns invalid Indicator length.



CR:419306
CR Number:   419306
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLNumParams reports incorrect number of parameters if the query being executed contains "@" sign.



CR:419579
CR Number:   419579
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Fixed
02 Mar 2006 Fixed
02 Mar 2006 Fixed
Description
jConnect: The column names used to describe ResultSet MetaData do not conform to the JDBC specifications.



CR:419583
CR Number:   419583
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
OLEDB: When using the MS DataShape Service and Provider connection property SelectMethod=Cursor, executing a Stored procedure, with SHAPE, or SHAPE and APPEND, application would hang.



CR:419671
CR Number:   419671
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)
07 May 2006 Duplicate
Description
When ISQL displays double-byte column data e.g. Simplified Chinese from a resultset, on reaching the end of a line as determined by the -w parameter setting, ISQL does not preserve the integrity of the double-byte data string i.e. it splits the string not at the correct double-byte character boundary but between the two bytes of a double-byte character.



CR:419684
CR Number:   419684
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 07 23 Mar 2006 Fixed
Description
MFC Server Option for CICS caused TDS errors in a gateway environment if the specified packet size was greater than 512 bytes



CR:419724
CR Number:   419724
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2006 Fixed
20 Mar 2006 Fixed
21 Mar 2006 Fixed
Description
Customer wants OpenSwitch to cancel query when RESPONSE_TIMEOUT expires
Workaround Description
 With JConnect/JDBC you can implement a setQueryTimeout() method, which is

the logical equivalent of the OpenSwitch timing out. You can set this value

to something smaller than RESPONSE_TIMEOUT so that when the setQueryTimeout

limit is hit in JConnect, the row is not inserted and a SQLException is returned.



CR:419730
CR Number:   419730
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Feb 2006 Fixed
Description
jConnect: PreparedStatement.setObject(paramIndex, String, java.sql.Types.BIT) does not set underlying boolean column to true if string value provided is "1".



CR:419831
CR Number:   419831
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
jConn: Request for support invoking getTypeMap and setTypeMap (Connection)



CR:419856
CR Number:   419856
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)
04 May 2010 Not reproducible with latest version of the product available as of Resolution Date
Description
ODBC Driver by Sybase: Selecting a smalldatetime column that does not allow NULL may cause an Internal Error 30016.
Workaround Description
 Use smalldatetime (allows null value) data type.

But it may be unacceptable if your customer has too many smalldatetime (not null) columns.



CR:419921
CR Number:   419921
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)
01 Feb 2006 Fixed
01 Feb 2006 Fixed
01 Feb 2006 Duplicate
Description
jConnect: Installing jConnect meta-data stored procedures (sql_server*.sql or installmaster script) on an ASE setup with Japanese character set fails due to character set conversion issues.



CR:419959
CR Number:   419959
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2006 Fixed
Description
jConnect: Output parameters registered as JDBC type of FLOAT are returned as Float objects when getObject() is called. These should be returned as Double as per JDBC specification.



CR:420087
CR Number:   420087
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 19 May 2006 Fixed
02 Dec 2013 Fixed
Description
ODBC Driver by Sybase: SQLGetInfo SQL_MAX_PROCEDURE_NAME_LEN returns invalid value.





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