随着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:333665
|
|
333665 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
02 Oct 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
OpenSwitch 12.5.1 hangs against Open Server 12.5.1 |
|
|
|
CR:333851
|
|
333851 |
|
Open ServerCONNECT for CICS |
|
Open ServerCONNECT for CICS |
|
|
|
|
|
|
|
|
|
|
27 Nov 2013 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
Open Client/Open Server was enhanced to allow parameters with language events. Mainframe Connect will be enhanced to use this new feature. |
|
|
|
CR:334020
|
|
|
|
|
|
|
14 Mar 2004 |
EOL'd version. Not to be Fixed. |
|
|
|
10 Sep 2004 |
Fixed |
|
|
|
|
|
CTLIB, CSLIB: Allow use of SYBOCS_CFG environment variable to over-ride default configuration value. |
|
Target Version |
|
Galaxy |
|
|
|
CR:334158
|
|
|
|
|
|
|
24 Feb 2004 |
Deferred |
|
|
|
04 Nov 2005 |
Fixed |
|
|
|
23 May 2006 |
Fixed |
|
|
|
|
|
CTLIB: New Feature to allow CS_LOGIN_TIMEOUT & CS_TIMEOUT properties to be set at connection level as well as context level. |
|
Workaround Description |
|
Use multiple CS_CONTEXTs in a single application - yuk! |
|
|
|
CR:334178
|
|
334178 |
|
Open Client |
|
blklib |
|
|
|
|
|
|
|
BCP: BCP -Y does not do conversions for multibyte characterset columns greater than 255 bytes in length. |
|
|
|
CR:334361
|
|
334361 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
jConnect install document for 5.5 still refers to 5.2 version. |
|
Review Status |
Reviewed Mar 2004. The requested changes have been made to the jConnect 5.5. documentation. |
|
|
|
CR:334482
|
|
334482 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
16 Mar 2004 |
Fixed |
|
5.5 |
|
16 Mar 2004 |
Fixed |
|
5.5 |
|
16 Mar 2004 |
Fixed |
|
5.5 |
|
16 Mar 2004 |
Fixed |
|
5.5 |
|
16 Mar 2004 |
Fixed |
|
5.5 |
|
16 Mar 2004 |
Fixed |
|
|
|
|
|
jConnect has added a new connection property, QUERY_TIMEOUT_CANCELS_ALL. This property works in the following way: If a client has called Statement.execute(), and one of the SQL statements in the execute batch times out, jConnect will issue a cancel_all command on the Connection. This will cause all pending statements on the Connection to be canceled.
This behavior can be useful, for example, in a case where the timeout is caused by a deadlock situation. |
|
|
|
CR:334483
|
|
334483 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: Error running proc:"The name 'sp_who sa' is not a valid identifier" w/ adCmdText |
|
Workaround Description |
|
- change from adCmdText to adCmdStoredProc
- use ODBC Driver 4.20 TDS-Based instead |
|
|
|
CR:334644
|
|
334644 |
|
Open ClientCONNECT for IMS and MVS |
|
MVS |
|
|
|
|
|
|
|
On array processing, the fetch count is not being properly set. |
|
|
|
CR:334672
|
|
334672 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
Add getrlimit(RLIMIT_NOFILE) to warn user about file descriptors |
|
Workaround Description |
|
Decrease the CONNECTIONS parameter to something smaller
than the number of file descriptors so OpenSwitch does
not ever try to overrun that value. |
|
|
|
CR:334785
|
|
334785 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
SRVLIB: Open Server fails to perform necessary byteswapping on CS_UNICHAR characters |
|
|
|
CR:334856
|
|
334856 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
08 Oct 2003 |
Fixed |
|
5.5 |
|
08 Oct 2003 |
Fixed |
|
|
|
|
|
If a client does the following:
1. set DYNAMIC_PREPARE connection property to true
2. create a batch of PreparedStatements
3. call setFetchSize()
4. executeBatch()
jConnect will still properly execute the batch. Before this fix, jConnect would become confused by the setFetchSize(), which would create a cursor to process results (even though a cursor makes no sense in the context of executing a batch of statements). |
|
|
|
CR:335065
|
|
335065 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
Changed the OpenSwitch's default of suppressing some errors
to start displaying these errors. |
|
|
|
CR:335268
|
|
335268 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
Documentation needs clarification regarding batch rejection operations. During bcp operations, bcp rejects individual rows for problems it detects like converstion errors and placed information in the -e <errorfile>. bcp does not reject entire batches, the server does for errors in the batch that it detects. The current documentation leads one to believe that it is bcp rejecting a batches instead of rows on the client side of things. |
|
Target Version |
|
Galaxy |
|
Review Status |
Reviewed March 2004. The fix is targeted (but not committed) for the documentation that will be released with the next major product release. |
|
|
|
CR:335480
|
|
335480 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
OpenSwitch crashes in np_err_string |
|
Workaround Description |
|
Revert to OpenSwitch 12.0 |
|
|
|
CR:335484
|
|
335484 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
CTLIB: OpenSwitch crashes in np_err_string |
|
Workaround Description |
|
Revert to OpenSwitch 12.0 |
|
|
|
CR:335601
|
|
335601 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
When log size reaches MAX_LOGSIZE OpenSwitch overwrites the log |
|
|
|
CR:335650
|
|
|
|
|
|
|
27 Apr 2004 |
Fixed |
|
|
|
16 Apr 2004 |
Fixed |
|
|
|
20 Apr 2004 |
Fixed |
|
|
|
20 Apr 2004 |
Fixed |
|
|
|
20 Apr 2004 |
Fixed |
|
|
|
20 Apr 2004 |
Fixed |
|
|
|
20 Apr 2004 |
Fixed |
|
|
|
28 Apr 2004 |
Fixed |
|
|
|
28 Apr 2004 |
Fixed |
|
|
|
21 Apr 2004 |
Fixed |
|
|
|
28 Apr 2004 |
Fixed |
|
|
|
28 Apr 2004 |
Fixed |
|
|
|
27 Apr 2004 |
Fixed |
|
|
|
12 May 2004 |
Fixed |
|
|
|
29 Apr 2004 |
Fixed |
|
|
|
29 Apr 2004 |
Fixed |
|
|
|
09 May 2004 |
Fixed |
|
|
|
09 May 2004 |
Fixed |
|
|
|
12 May 2004 |
Fixed |
|
|
|
|
|
EXAMPLE: dblibary, ctlibrary and srvlibrary examples now have more readable 'Makefile' and helper script 'sybopts.sh'. Functions in the examples are also rewritten in ANSI format. |
|
|
|
CR:335688
|
|
|
Closed |
|
Microsoft Windows |
|
12.5.1 |
|
|
|
|
|
|
|
|
|
22 Oct 2003 |
Fixed |
|
|
|
14 Jan 2004 |
Fixed |
|
|
|
|
|
OCSCFG: On Windows NT, references to net library drivers in ocscfg.exe are not needed. |
|
|
|
CR:335891
|
|
335891 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
BCP, ISQL: In some circumstance, BCP and ISQL incorrectly report timing statistics.For example, they might report negative clock time if the running jobs span accross midnight. |
|
|
|
CR:336056
|
|
336056 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
OLEDB: Initialization String is limited to 40 bytes in ASE OLE DB Configurator. Manually editting the IDS file exceeds this limitation. |
|
Workaround Description |
|
Manually edit the IDS file |
|
|
|
CR:336076
|
|
336076 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
13 May 2004 |
Fixed |
|
|
|
13 May 2004 |
Fixed |
|
|
|
|
|
SRVLIB: multthrd example core dumps if no servername is specified on the commandline. |
|
|
|
CR:336195
|
|
336195 |
|
Organic ODBC Driver |
|
ODBC Driver |
|
|
Closed |
|
Microsoft Windows 2000 |
|
12.5.1 |
|
|
|
|
|
|
ODBC Driver by Sybase: Add support for some missing Data Source Information types in SQLGetInfo function: SQL_USER_NAME, SQL_TXN_CAPABLE, SQL_TXN_ISOLATION_OPTION, SQL_NON_NULLABLE_COLUMNS, SQL_NULL_COLLATION and SQL_MAX_TABLES_IN_SELECT. |
|
|
|
CR:336405
|
|
336405 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
|
12.50.04 |
124 |
25 Feb 2004 |
Fixed |
|
|
|
|
|
Memory leak in AMD2SPS Module. |
|
|
|
CR:336519
|
|
336519 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
Under isql version 10.0.4 compute results were displayed directly under the columm which generate the compute results. Under isql version 12.5 compute results are generated left aligned in the printout. |
|
Target Version |
|
Galaxy |
|
Review Status |
Reviewed March 2004. The fix is targeted (but not committed) for the documentation that will be released with the next major product release. |
|
|
|
CR:336538
|
|
336538 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
05 Nov 2003 |
Fixed |
|
|
|
10 Nov 2003 |
Fixed |
|
|
|
|
|
OpenSwitch gets error "mempool_getblock: mem_alloc() failed". |
|
|
|
CR:336585
|
|
|
|
RCM passes two undocumented parameters to the NOTIFICATION_PROCESS |
|
|
|
CR:336607
|
|
|
|
CTLIB: Using Wide Dynamic/ Cursors can cause a core dump in comnlib mapping routines. |
|
|
|
CR:336650
|
|
336650 |
|
Open ClientCONNECT for IMS and MVS |
|
MVS |
|
|
|
|
|
|
|
SYISQL fails with a code of -7, the region size must be increased appropriately. |
|
Workaround Description |
|
NONE |
|
|
|
CR:336670
|
|
336670 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
CMON thread makes multiple connections to same ASE |
|
|
|
CR:336674
|
|
336674 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
28 Jul 2006 |
Fixed |
|
|
|
27 Aug 2006 |
Fixed |
|
|
|
16 Aug 2006 |
Fixed |
|
|
|
16 Aug 2006 |
Fixed |
|
|
|
|
|
BCP: When bcp reaches its maximum number of errors it does not report the reason why it stops. |
|
Target Version |
|
To Be Determined |
|
Review Status |
Reviewed March 2004. This CR is still under review. |
|
|
|
CR:336709
|
|
336709 |
|
Open ClientCONNECT for CICS |
|
Open ClientCONNECT for CICS |
|
|
|
|
|
|
|
Multiple sockets for an OCC transaction are not closed on abend. |
|
Target Version |
|
12.50.04 |
|
|
|
CR:337095
|
|
337095 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB Provider 2.70.0022/2.70.0023: Precision error when stored procedure input parameter is set to Null |
|
Workaround Description |
|
Use ODBC Driver 4.20.00.06 instead. |
|
|
|
CR:337129
|
|
337129 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: ASE varchar was treated the same as char value when ODBC was connected to ASE via Open Server gateway such as Open Switch, and ASE was at version 12.0. The varchar data was being padded so the data displayed was "full length" of the varchar column as defined on ASE. The padding no longer occurs. |
|
|
|
CR:337320
|
|
337320 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
Request to support setObject(parmIndiex, NULL) |
|
Review Status |
Reviewed Mar 2004. This CR is in review by engineering. Needs to be discussed with Sun. |
|
|
|
CR:337422
|
|
337422 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
OLEDB: Literal empty string as parameter in ADO application fails against ASE 12.0 with the error: "While reading characters from the client, the receiving buffer has been detected to be too small." This is ASE Error 4020. |
|
Workaround Description |
|
None |
|
|
|
CR:337651
|
|
337651 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
11 Nov 2003 |
Fixed |
|
5.2 |
|
11 Nov 2003 |
Fixed |
|
5.2 |
|
11 Nov 2003 |
Fixed |
|
5.2 |
|
11 Nov 2003 |
Fixed |
|
5.2 |
|
11 Nov 2003 |
Fixed |
|
5.2 |
|
11 Nov 2003 |
Fixed |
|
|
|
|
|
When a client calls updateObject (int index, Object o), and the Object is a BigDecimal, jConnect will respect the value's scale. Previously, jConnect would incorrectly set the scale to 0. |
|
|
|
CR:337720
|
|
337720 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The ASE ADO.NET Data Provider does not support encryption of ASE Login password. |
|
Review Status |
Reviewed Mar 2004. This fix to this CR is targeted for SDK 12.5.1 ESD #2. |
|
Workaround Description |
|
Possibly use ADO.Net ODBC driver. |
|
|
|
CR:337724
|
|
337724 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
18 Feb 2004 |
Fixed |
|
5.5 |
|
18 Feb 2004 |
Fixed |
|
5.5 |
|
18 Feb 2004 |
Fixed |
|
5.5 |
|
18 Feb 2004 |
Fixed |
|
5.5 |
|
18 Feb 2004 |
Fixed |
|
5.5 |
|
18 Feb 2004 |
Fixed |
|
|
|
|
|
Clients can now pass in a Short object to setObject(). Previously, jConnect was missing some internal conversion methods, which resulted in an Exception being thrown in this case. |
|
|
|
CR:337822
|
|
337822 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The ASE ADO.NET Data Provider cannot use LDAP to obtain database connection information. |
|
|
|
CR:337825
|
|
337825 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The ASE ADO.NET Data Provider does not support setting up connections for fail-over in a High-availability cluster. |
|
|
|
CR:338060
|
|
338060 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET:DataOverflow Exception when inserting values greater than 127 into a TinyInt class. |
|
|
|
CR:338223
|
|
338223 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
SYGWCTXH is Abending OC4 at Offset 1972 |
|
|
|
CR:338256
|
|
338256 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: AseDataAdapter.fill() returns value from previous cell when current cell value is null. |
|
|
|
CR:338322
|
|
338322 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: AseException is generated when AseDataAdapter.Update(DataSet) command is called to update a table with newly inserted rows and target ASE table contains auto-incremented primary key values. |
|
|
|
CR:338334
|
|
338334 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Unable to display and input Traditional Chinese (Big5) characters correctly due to Big5 characters were incorrectly mapped into unicode when using datatype SQL_C_WCHAR. |
|
|
|
CR:338356
|
|
338356 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
Need to announce "no support" for ODBC/OLEDB in .NET Environment |
|
|
|
CR:338504
|
|
338504 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: The ASE install master script set incorrect values, that are not within the ODBC 3.X specification. To correct this problem now, you can modify the system tables. |
|
|
|
CR:338697
|
|
338697 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2003 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: New feature request to be able to obtain connection information from Sybase interfaces / SQL.INI files. |
|
|
|
CR:338706
|
|
338706 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2003 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The ASE ADO.NET Data Provider cannot use SSL encryption with ASE. |
|
|
|
CR:338799
|
|
|
|
NETLIB: ct_connect() does not failover to secondary interface entries. |
|
Workaround Description |
|
None. |
|
|
|
CR:338850
|
|
338850 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
|
|
|
16 Feb 2004 |
EOL'd version. Not to be Fixed. |
|
|
|
21 Oct 2007 |
Fixed |
|
|
|
22 Oct 2007 |
Fixed |
|
|
|
19 Nov 2007 |
Fixed |
|
|
|
19 Nov 2007 |
Fixed |
|
|
|
|
|
COMNLIB: Change the maximum length of a parameter of SDK utilities to PATH_MAX (Unix) or _MAX_PATH (Windows). This fix is not available on SGI platform now. |
|
Target Version |
|
12.5.1 |
|
Review Status |
Reviewed March 2004. The fix is targeted (but not committed) for a future 12.5.1 EBF. |
|
Workaround Description |
|
Use:
Shorter absolute paths
Relative paths
Run the utility in the required directory |
|
|
|
CR:339062
|
|
339062 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: On an exception condition if ASE generates a list of errors, AseException object contains only the first error |
|
|
|
CR:339090
|
|
339090 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The ASE ADO.NET Data Provider supports only a subset of charsets supported by ASE. |
|
|
|
CR:339123
|
|
339123 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
09 Apr 2004 |
Fixed |
|
|
|
27 Apr 2004 |
Fixed |
|
|
|
|
|
SRVLIB: Openserver RPC which uses parameters of type CS_UNICHAR_TYPE does not work. |
|
Target Version |
|
To Be Determined |
|
Review Status |
Reviewed Mar 2004. A fix is targeted for a future release of the product. |
|
Workaround Description |
|
Change the datatype of the rpc parameter on the open server to be CS_LONGBINARY_TYPE |
|
|
|
CR:339355
|
|
339355 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: Internal Error 30002 when a processing a null datetime column under certain circumstances. |
|
Workaround Description |
|
use sp :
CREATE PROCEDURE dbo.customers_test
AS
BEGIN
declare @NullDate datetime
select @NullDate=NULL
SELECT 1 as Tag,
NULL as Parent,
C.CustomerID as Customer_1_cid,
C.ContactName as Customer_1_name, |
|
|
|
CR:339371
|
|
339371 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
BCP: bulk copy in with -t option may crash when copying in a file larger than 2GB. |
|
Target Version |
|
12.5.1 |
|
Review Status |
Reviewed March 2004. The issue will be fixed in SDK 12.5.1 ESD #2. |
|
Workaround Description |
|
Use a 64bit version of bcp |
|
|
|
CR:339464
|
|
339464 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
Customer would like to AND connection attributes in their POOL |
|
|
|
CR:339515
|
|
339515 |
|
OpenSwitch |
|
OpenSwitch |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
01 Mar 2004 |
Diagnostic Provided |
|
|
|
|
|
Document and test installing OpenSwitch as a service on Windows |
|
Workaround Description |
|
1) Install it as a service:
C:\sybase\OpenSwitch-12_5\bin>OSwitch -c OpenSwitch.cfg -R install
INFO: service_install: Installed service named SWITCH1 using config file
OpenSwitch.cfg
I had to make a few changes to make this work.
2) I had to change |
|
|
|
CR:339567
|
|
|
|
CTLIB: OCS 12.5.1 client with its CS_NETIO property set to asynchronous mode will hang when trying to connect to pre-12.0 ASE. |
|
|
|
CR:339841
|
|
|
Closed |
|
Microsoft Windows NT |
|
6.0 ESD#2 |
|
|
|
|
|
|
|
6.0 ESD#2 |
|
02 Nov 2004 |
Fixed |
|
5.5 ESD#15 |
|
02 Nov 2004 |
Fixed |
|
|
|
|
|
ribo: Ribo throws java.lang.NullPointerException when converting a TDS file. |
|
|
|
CR:339984
|
|
339984 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows |
|
12.5.1 |
|
|
|
|
|
|
|
|
|
18 Aug 2004 |
Third Party Problem |
|
|
|
|
|
ODBC: Driver help file has different information about Select Method and Prepare Method than the default driver settings. |
|
|
|
CR:340075
|
|
340075 |
|
Organic ODBC Driver |
|
ODBC Driver |
|
|
Closed |
|
Microsoft Windows 2000 |
|
12.5.1 |
|
|
|
|
|
|
|
15.0 ESD#1 |
|
21 Dec 2005 |
Fixed |
|
|
|
|
|
ODBC Driver by Sybase: Request to add support for SQLBulkOperations. |
|
|
|
CR:340079
|
|
340079 |
|
jConnect |
|
JDBC Driver |
|
|
Open |
|
Microsoft Windows NT |
|
5.5 |
|
|
|
|
|
|
Statement.setMaxRows() should be honored within cursors as well as outside the scope of cursors. Currently the setMaxRows() does not within a cursor.
jConnect should be altered to code around the current ASE behavior to provide the proper JDBC behavior which is to limit the ResultSet to the setRowMax() number of rows whether a cursor is used or not. |
|
Workaround Description |
|
No known workaround. |
|
|
|
CR:340162
|
|
340162 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: Executing a stored procedure with "print" statements in the stored procedure code causes exceptions. |
|
|
|
CR:340163
|
|
340163 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: Return type for AseParameterCollection.Add method chnaged from Int32 to AseParameter. |
|
Workaround Description |
|
Do this operation in steps
AseParameter p1 = new AseParamter("@p1", AseDbType.Integer);
p1.Value = 123;
myCommand.Add(p1); |
|
|
|
CR:340381
|
|
340381 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
Today, only ODBC Driver has the Password Encryption feature. Customer would like to have password encryption feature to OLE DB Provider. |
|
Review Status |
Reviewed Mar 2004. There are currently no plans to implement this feature. |
|
|
|
CR:340565
|
|
340565 |
|
jConnect |
|
JDBC Driver |
|
|
Open |
|
Microsoft Windows NT |
|
5.5 |
|
|
|
|
|
|
setMaxRows() method is ignored when using setFetchSize() on a statement |
|
|
|
CR:340567
|
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
DBLIB: DB-Library doesn't return network errors. |
|
|
|
CR:340710
|
|
340710 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
Wants OpenSwitch to send message to clients issuing commands to LOCKED server |
|
|
|
CR:340715
|
|
340715 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
|
|
|
|
If a client application set LITERAL_PARAMS to true, jConnect would cause an Exception to be thrown when a database name was in the connection URL, or when a customer called Connection.setCatalog(String dbName). This error no longer occurs. |
|
|
|
CR:340817
|
|
|
|
|
|
|
02 Dec 2003 |
Fixed |
|
|
|
02 Dec 2003 |
Fixed |
|
|
|
|
|
CM applications that serve more than one OpenSwitch server may not detect the failure of a secondary OpenSwitch server right away. |
|
|
|
CR:341065
|
|
341065 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows |
|
12.5 |
|
|
|
|
|
|
ODBC:TDS ODBC Driver doesn't connect to an Asymmetric Secondary ASE in a HA setup |
|
|
|
CR:341137
|
|
341137 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: Set identity_insert tab ON causes SQL_ERROR on execution of stored procedure. Now it returns SQL_SUCCESS_WITH_INFO. |
|
|
|
CR:341442
|
|
341442 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
SRVLIB: Some platforms reported SRV_C_DEBUG capability without srv_dbg_stack() support. |
|
|
|
CR:341467
|
|
341467 |
|
Open Client |
|
blklib |
|
|
|
|
|
|
|
blktxt won't build, Makefile misleads customers there is dependency on libsrv |
|
Workaround Description |
|
Change:
BLKLIBS = `sh sybopts.sh blk srv` $(CTLIBS)
to:
BLKLIBS = `sh sybopts.sh blk` $(CTLIBS) |
|
|
|
CR:341667
|
|
341667 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Open |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: Request to configure WorkArounds attributes via GUI. |
|
Target Version |
|
To Be Determined |
|
Review Status |
Reviewed Mar 2004. This CR is targeted (but not committed) for a future release of the product in 2005. |
|
|
|
CR:341807
|
|
341807 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: If ASE returns informational message(s) as a result of execution of a command or stored procedure then the ADO.NET Data Provider may throw an exception. Typically these messages get generated as a result of print statements in sotored procedure or set commands such as "set showplan on". |
|
|
|
CR:341980
|
|
341980 |
|
Open ServerCONNECT for CICS |
|
Open ServerCONNECT for CICS |
|
|
|
|
|
|
|
|
12.50.05 |
008 |
24 May 2004 |
Fixed |
|
|
|
|
|
Customer needs a way to map language requests to more than one transaction depending on selected criteria, for example, the user's ID. See General Information and Technical Notes, item 1, for reference. |
|
|
|
CR:342025
|
|
342025 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
11 Dec 2003 |
Fixed |
|
5.5 |
|
11 Dec 2003 |
Fixed |
|
|
|
|
|
We have updated the jConnect Programmer's Reference Manual and the jConnect Installation Guide. We are now including these documents in the EBF zip files that customers can download from the web. The documents also are available online at http://manuals.sybase.com/jc.html |
|
|
|
CR:342043
|
|
342043 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
19 Feb 2004 |
Fixed |
|
|
|
13 Feb 2004 |
Fixed |
|
|
|
|
|
BLKLIB: blk_colval() getting invalid length when client is Windows NT and Open Server is Solaris. |
|
|
|
CR:342254
|
|
|
|
|
|
|
07 Jun 2005 |
Fixed |
|
|
|
09 Jun 2005 |
Fixed |
|
|
|
|
|
CTLIB: Occasionally fully async connections could lose SIGIO in non-reentrant library. |
|
|
|
CR:342554
|
|
342554 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: E_FAIL status with AddNew() and CursorLocation set to adUseClient in a Visual Basic ADO applciation. This is resolved by using the WorkArounds2=16 connection attribute. You can add this to the ADO connections string as "WA2=16". Another alternative is to add the "WorkArounds2=16" for the DSN as found in the registry under ODBC.INI. |
|
Workaround Description |
|
set cursor location to adUseServer (this is the default setting) |
|
|
|
CR:342620
|
|
342620 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
When client drops from network OpenSwitch makes Recursive Calls to srv__seterr |
|
|
|
CR:342785
|
|
|
|
|
|
|
28 Jan 2004 |
Fixed |
|
|
|
26 Jan 2004 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
05 May 2004 |
Fixed |
|
|
|
|
|
CTLIB: Odd file descriptor limit causes SIGBUS. |
|
Workaround Description |
|
To start ASE disable CT-Lib with trace flag 7821.
Reset fd's to a reasonable value, say 10,000, using the appropriate shell command:
in ksh: ulimit -n 10000 |
|
|
|
CR:342973
|
|
342973 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
SRVLIB: Open Server does unexpected charset conversion between non-japanese charset and japanese charset. |
|
Review Status |
Reviewed March 2004. Closed as not a bug. |
|
|
|
CR:343024
|
|
343024 |
|
Open ClientCONNECT for CICS |
|
Open ClientCONNECT for CICS |
|
|
|
|
|
|
|
OCC cannot process a message longer than 512 bytes. |
|
|
|
CR:343050
|
|
|
|
|
|
|
06 Jan 2005 |
Fixed |
|
|
|
20 May 2005 |
Fixed |
|
|
|
|
|
COBPRE: cobpre may generate COBOL codes that violate Columns 73-80 in Japanese environment. |
|
|
|
CR:343185
|
|
343185 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
08 Apr 2004 |
Fixed |
|
5.5 |
|
08 Apr 2004 |
Fixed |
|
|
|
|
|
jConnect no longer throws a StringIndexOutOfBoundsException in the following case: Customer sets DYNAMIC_PREPARE and SELECT_OPENS_CURSOR conn properties to true, and the query contains a ...FOR UPDATE clause. |
|
|
|
CR:343200
|
|
343200 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
5.5 |
|
08 Apr 2004 |
Fixed |
|
5.5 |
|
08 Apr 2004 |
Fixed |
|
|
|
|
|
When a client tried to set the BE_AS_JDBC_COMPLIANT_AS_POSSIBLE property, and passed that value in with a Properties object to the DriverManager.getConnection method, jConnect would wind up resetting all the prop values that are triggered when the jdbc compliance prop is set. jConnect now sets the JDBC compliance properties properly. |
|
|
|
CR:343207
|
|
343207 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
|
|
|
29 Jan 2004 |
Fixed |
|
|
|
09 Jan 2004 |
Fixed |
|
|
|
|
|
ISQL: Using ASE feature real-time messaging may cause core dump in ISQL. |
|
|
|
CR:343251
|
|
343251 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
ODBC: No updates were allowed on disconnected ADO Recordset from a stored procedure call, after upgrading to the 4.20 driver build. Application would recieve the error
"-2147217887 : Multiple-step operation generated errors. Check each status value." To prevent this from happening, a new connection option is required, ReportUnknownForUpdatable, which is False (0) by default. When set to TRUE (1), this option will always return SQL_ATTR_READWRITE_UNKNOWN for the SQL_DESC_UPDATABLE field of the result column descriptors. This will only apply to stored procedure result sets. |
|
Workaround Description |
|
Removal of EXEC keyword will enable this to work. However, this is unreasonable as customer has Many apps to change (1000) |
|
|
|
CR:343256
|
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
DBLIB: Allow dblib on Windows NT to use directory services other than the interfaces file. |
|
|
|
CR:343341
|
|
|
Closed |
|
Microsoft Windows NT |
|
12.5.1 |
|
|
|
|
|
|
NETLIB: sql.ini entries for name pipes using NAMEPIPE are not recognized |
|
Review Status |
Reviewed June 2004. Closed as a duplicate of CR 339270. |
|
Workaround Description |
|
manually change NAMEPIPE to MSNMP in the sql.ini. Note: also pre-339270, make the entry of the form:
master=MSNMP,\\.\pipe\sql\<name> |
|
|
|
CR:343354
|
|
343354 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
jConnect: If you call PreparedStatement.setBinaryStream() and at runtime, the user InputStream throws an IOException, jConnect does not cleanup the network buffers completely. As a result, the subsequent command including the call to rollback() will receive an exception. |
|
Target Version |
|
To Be Determined |
|
Review Status |
Reviewed June 2004. CR is still under review by engineering. |
|
Workaround Description |
|
1. Catch the IOException in the InsputStream so that it does not propagate to jConnect and after the insert/update is successful, then issue rollback().
2. OR catch the SQLException thrown by jConnect when the IOException thrown by InputStream is encountered, then call the rollback() method twice. The first rollback() will throw another SQLException due to state of network buffers. You need to catch that exception and reissue rollback() the second time. |
|
|
|
CR:343384
|
|
343384 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
09 Feb 2004 |
Fixed |
|
5.5 |
|
09 Feb 2004 |
Fixed |
|
5.5 |
|
09 Feb 2004 |
Fixed |
|
5.5 |
|
09 Feb 2004 |
Fixed |
|
5.5 |
|
09 Feb 2004 |
Fixed |
|
5.5 |
|
09 Feb 2004 |
Fixed |
|
|
|
|
|
jConnect now returns metadata properly when PreparedStatement.getMetaData is called. Previously, we were only returning metadata if the statement was dynamically prepared. |
|
|
|
CR:343430
|
|
343430 |
|
Open Client/Open Server-Doc |
|
Release Bulletin |
|
|
|
|
|
|
|
SDK and Open Server 12.5.1 require Solaris patch 108993-18 or later. |
|
|
|
CR:343643
|
|
343643 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: Version 2.70 ignores MaxRecords property when Select Method = Cursor |
|
|
|
CR:343967
|
|
343967 |
|
ADO.NET Data Provider |
|
ADO.NET Data Provider |
|
|
Closed |
|
Microsoft Windows 2000 |
|
1.0 |
|
|
|
|
|
|
ADO.NET: The "Max Pool Size" connection property is not being utilized to limit the maximum number of concurrent connections to the database. |
|
|
|
CR:344035
|
|
344035 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
Open Server leaks memory when shut down from a STOP_SRV event |
|
|
|
--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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)上提取数据的非常规恢复工具
- 适用于所有的SQL Anywhere版本 包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
- 适用于所有的UltraLite版本
- 能够恢复出来表结构和数据
- 能够恢复自定义数据类型
- 能够恢复存储过程等对象的语法
- 能够导出到目标数据库
- 能够导出到SQL文件并生成导入脚本
- 支持多种字符集 包括:cp850、cp936、gb18030、utf8等
- 能够恢复未加密或者简单加密类型的数据
- 简单易用
- 限制:不支持AES加密的数据文件
请参考:
研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍
ReadASADB适用场景
各种误操作:
- 误截断表(truncate table)
- 误删除表(drop table)
- 错误的where条件误删数据
- 误删除db或log文件
- 误删除表中的字段
本工具的应用场景:
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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------