随着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:295830
|
|
295830 |
|
Open ClientCONNECT for CICS |
|
Open ClientCONNECT for CICS |
|
|
|
|
|
|
|
ISQL/CICS return unsupported datatype on select * from sysmessages against ASE12.5 |
|
|
|
CR:295833
|
|
295833 |
|
Open Client-Doc |
|
Client-Library C Reference Manual |
|
|
|
|
|
|
|
Open Client Reference Manual missing Multithreaded programming section |
|
|
|
CR:295867
|
|
295867 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: LDAP feature does not unbind the url session. When request is made to retrieve the SybaseAddress the connection from ODBC driver to ldap server remains OPEN until the odbc application terminates. The session now UNBINDs immediately after request to provide information has occurred. |
|
|
|
CR:295998
|
|
295998 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
28 Jan 2003 |
Fixed |
|
|
|
05 Feb 2003 |
Fixed |
|
|
|
|
|
SRVLIB: srv_descfmt fails to retrieve maxlength of a char parameter over 255 characters |
|
|
|
CR:296436
|
|
296436 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Stored procedure with a raiserror returned a warning (SQL_SUCCESS_WITH_INFO) instead of SQL_ERROR on execute. |
|
Workaround Description |
|
Not really - can use CtLib based (ODBC 12.0) |
|
|
|
CR:296714
|
|
296714 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
03 Feb 2003 |
Fixed |
|
|
|
17 Feb 2003 |
Fixed |
|
|
|
|
|
BCP: bcp fails to truncate and insert longchar XNL type data. |
|
|
|
CR:296725
|
|
296725 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: The ODBC driver now supports using the Sybase OCS SQL.INI interfaces file for ASE
server name resolution, providing a lookup for hostname and port number for connectivity.
To utilize this feature just bypass adding the Network Address in the DSN configuration. Go to the section in the General Tab titled "Use Interface File for Connection Information (Optional)". Enter the full path and filename of the SQL.INI interfaces file for the field labeled "Interfaces File", like "C:\SYBASE\INI\SQL.INI". Enter the ASE Server name as found in the SQL.INI file in the field for "Server Name". When you attempt to connect, the ODBC Driver will get the Hostname and Port number for the ASE Server, and use that information to make the connection. |
|
|
|
CR:296726
|
|
296726 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: The OLE DB Provider now supports using the Sybase OCS SQL.INI interfaces file for ASE server name resolution, providing a lookup for hostname and port number for connectivity. To utilize this feature just bypass adding the Server Name and Server Port under the General Tab when in the Sybase OLE DB Setup (or when using a connection string in your application). Go to the section in the Connection Tab titled "Use Interface File for Connection Information (Optional)". Enter the full path and filename of the SQL.INI interfaces file for the field labeled "Interfaces File", like "C:\SYBASE\INI\SQL.INI". Enter the ASE Server name as found in the SQL.INI file in the field for "Server Name". When you attempt to connect, the OLE DB Provider will get the Hostname and Port number
for the ASE Server, and use that information to make the connection. The attribute names to use when you are using a connection string in your application are "Interfaces File" and "Interfaces File Server Name". |
|
|
|
CR:296860
|
|
296860 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
16 Jul 2003 |
Fixed |
|
|
|
16 Jul 2003 |
Fixed |
|
|
|
17 May 2004 |
Not a Bug |
|
|
|
|
|
BCP: bcp out of NULLable char-type columns are padded with NULL-characters |
|
Workaround Description |
|
Use NOT NULL with CHAR column. |
|
|
|
CR:296954
|
|
296954 |
|
OpenTransport |
|
JMS Driver |
|
|
|
|
|
|
|
Description: Memory is seen to climb when accessing Sun's J2EE Reference Implementation Server or bea's WebLogic server with an application using the JMS ot driver. The memory is seen to climb in the server and in the application that is using the JMS ot driver.
work around: Set NNOT_TIL_GET_BLOCKING_TIMEOUT in each transport to infinite (-1) and the problem does not occur. |
|
|
|
CR:297008
|
|
297008 |
|
Open Client |
|
blklib |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
blk_rowxfer fails w/ nodebug libblk.dll, works w/ debug libblk.dll. Fails
with error: blk_rowxfer():internal BLK-Library error: No value or
default available and NULL not allowed. |
|
Workaround Description |
|
Use debug version of libblk.dll |
|
|
|
CR:297342
|
|
297342 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
30 Dec 2002 |
Fixed |
|
|
|
26 Jun 2001 |
Not a Bug |
|
|
|
|
|
ODBC: Error 2601, "Attempt to insert duplicate key row in object 'tableName' with unique index 'indexName'", was a warning with the ctlib-based driver and was returned as an error with the TDS-based driver. |
|
Workaround Description |
|
None available for the customer - they need tds based driver |
|
|
|
CR:297468
|
|
297468 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
14 Apr 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
OpenSwitch hangs client while CM is running during a server crash |
|
|
|
CR:297627
|
|
297627 |
|
OpenTransport |
|
JMS Driver |
|
|
|
|
|
|
|
you cannot use transactions when accessing EAServer with the JMS ot driver. You must set JMS_SES_TRANSACTED to FALSE. If you do not the adapter will work but: if you don't have NNOT_TIL_GET_BLOCKING_TIMEOUT set the adapter goes down after 10 minutes. If you have it set to 60000 (1 minute). It stays up. But, if you put any messages on the queue that the adapter is listening to after the 10 minutes, the adapter will immediately go down. |
|
|
|
CR:297665
|
|
|
|
|
|
|
09 May 2003 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
ESQL: Exposed structures may be changed by memory alignment compiler options. Applications consisting of modules using differing memory alignment may get various errors. |
|
Workaround Description |
|
Customers can edit Sybase header files to add #pragma directives to preserve default alignment. |
|
|
|
CR:297796
|
|
|
|
The 12005GA and upwards ebf had a fresh OC-ebf transition to 10228, this apparently did not have the fix for the convert bug and therefore, it caused convert to work differently by generating domain errors during the explicit conversion. |
|
|
|
CR:297888
|
|
297888 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
07 Nov 2002 |
Fixed |
|
|
|
07 Nov 2002 |
Fixed |
|
|
|
|
|
COMNLIB: Sporadic CreateMutex() failures on HP. |
|
|
|
CR:298282
|
|
298282 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Stored procedures did not return empty result sets. |
|
Workaround Description |
|
Only to use ODBC 12.0 preventing customer from migrating to 12.5 |
|
|
|
CR:298658
|
|
298658 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: COMPUTE clause through ODBC does not work. |
|
|
|
CR:298666
|
|
298666 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
29 Oct 2002 |
Fixed |
|
|
|
04 Aug 2003 |
Fixed |
|
|
|
|
|
SRVLIB: In a CIS environment using cursors to an sds Open Server does not handle cancel operations on the cursor correctly. More specifically, the TDS cursor LISTALL request is incorrectly handled by srv_cursor_props. This can result in a memmove using invalid pointers and data segment sizes. This fix corrects the results returned by srv_cursor_props in this situation. |
|
|
|
CR:298676
|
|
298676 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
10 Dec 2003 |
Fixed |
|
5.5 |
|
10 Dec 2003 |
Fixed |
|
|
|
|
|
jConnect now chains the original Exception to any BatchUpdateExceptions that are thrown. Therefore, clients that catch a BatchUpdateException may use the getNextException() method to see the original Exception that was generated during the batch execution. |
|
|
|
CR:298703
|
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
15 Nov 2002 |
Fixed |
|
|
|
15 Nov 2002 |
Fixed |
|
|
|
15 Oct 2003 |
Duplicate |
|
|
|
|
|
SSL: Can't complete handshake with chained certificate. |
|
|
|
CR:299019
|
|
|
|
|
|
|
06 Nov 2002 |
Fixed |
|
|
|
11 Nov 2002 |
Fixed |
|
|
|
06 Nov 2002 |
Fixed |
|
|
|
|
|
CTLIB: ct_con_alloc may SIGSEGV when there is insufficient memory to allocate the connection structure. |
|
|
|
CR:299032
|
|
|
|
CPRE: EXEC SQL UPDATE cannot handle table names with embedded '#' signs |
|
Workaround Description |
|
Rename the table or use a view on the table with a different name or use a stored procedure to do updates. |
|
|
|
CR:299219
|
|
299219 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
Null text columns in TDS results should be only a zero length text pointer without any other fields (time stamp and text length). |
|
|
|
CR:299262
|
|
299262 |
|
Connectivity Utilities |
|
isql |
|
|
Closed |
|
Microsoft Windows |
|
12.5 |
|
|
|
|
|
|
|
|
|
08 Mar 2004 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
10 Sep 2010 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
Request isql on NT defaults to cp850 characterset regardless of locales.dat |
|
|
|
CR:299451
|
|
|
|
The round() SQL function inserts incorrect rounded value, when issued from within ctlib program. It works fine outside ctlib. |
|
Workaround Description |
|
Workaround is to round the number with C++ function before inserting it into database table. |
|
|
|
CR:299624
|
|
299624 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
27 Oct 2003 |
Not a Bug |
|
|
|
17 Sep 2003 |
Duplicate |
|
|
|
|
|
When starting OpenSwitch, it starts listeners on the master and query ports |
|
Workaround Description |
|
1) The customer could put only a master entry in the interfaces file for OpenSwitch.
Then create a separate interfaces entry for the clients.
2) Use separate interfaces files for OpenSwitch and the clients. |
|
|
|
CR:299628
|
|
299628 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
13 Nov 2002 |
Fixed |
|
12.5.1 |
|
10 Apr 2003 |
Fixed |
|
|
|
|
|
BLKLIB: blk_colval failing on variable length column with Buffer size error |
|
|
|
CR:299879
|
|
299879 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
24 Jan 2003 |
Fixed |
|
|
|
23 Jan 2003 |
Fixed |
|
|
|
27 Feb 2003 |
Fixed |
|
|
|
|
|
BCP: bcp allocates huge chunks of memory when large batch size specified w/ -b flag |
|
Workaround Description |
|
1) Use a smaller batch size. In other words, use -b1000 instead of -b10000.
2) Remove any restrictions for memory allocation. In other words ("ulimit -v unlimited"
or "limit memorysize unlimited").
3) Revert to a version of bcp that does not have the |
|
|
|
CR:299893
|
|
299893 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Stored procedures executed as language commands returned errors as separate result sets instead of in the same result set. For example, if using the proc_role() function in a stored procedure, and if you pass an invalid role as a parameter, you received one message about the invalid role. You did not receive the other message indicating that you do not have the right role. |
|
Workaround Description |
|
None found except use ctlib driver. |
|
|
|
CR:299932
|
|
299932 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
|
|
|
17 Sep 2003 |
Duplicate |
|
|
|
17 Sep 2003 |
Duplicate |
|
|
|
|
|
isql/defncopy displays incorrect additional line in procedure syntax inside where clause
Tested with:
HP UX: OC 12.5 EBF 10665
Sun Solaris: OC 12.5 EBF 10659
WinNT 4.0 SP6: OC 12.5 EBF 10679
Important: Works ok with SQLAdvantage 12.5 and JISQL |
|
Workaround Description |
|
Use SQLAdv or JISQL instead of isql/defncopy. |
|
|
|
CR:299982
|
|
299982 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
04 Dec 2002 |
Fixed |
|
|
|
20 Dec 2002 |
Fixed |
|
|
|
04 Dec 2002 |
Fixed |
|
|
|
|
|
SRVLIB: Closing a sitehandler connection could fail to close a subchannel connection. |
|
|
|
CR:300194
|
|
300194 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
|
|
|
30 Apr 2003 |
Fixed |
|
|
|
26 Jun 2001 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
ISQL: End of line character sequence required at the end of the final line of an input buffer. |
|
Workaround Description |
|
Use an earlier version of 12.0 isql or use 12.5 |
|
|
|
CR:300371
|
|
300371 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: Inconsistency in setting of "Use SSL" attribute. |
|
Workaround Description |
|
1. First, start with 2.70.0000 and bring up the Configurator Manager. Create a New Data
Source, and observe that "Use SSL" = "0". If you change the value it is either 1 or 0.
2. Next, use 2.70.0010 and create a New Data Source. Observe that "Use SSL |
|
|
|
CR:300389
|
|
300389 |
|
Open ClientCONNECT for CICS |
|
Open ClientCONNECT for CICS |
|
|
|
|
|
|
|
Customer would like to have one SYGWHOST across multiple LPARS. |
|
|
|
CR:300563
|
|
300563 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Unable to connect to ASE using interfaces file through MS Excel application. |
|
Workaround Description |
|
None |
|
|
|
CR:300604
|
|
300604 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
25 Oct 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
25 Oct 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
OpenSwitch crashes in queue_completion |
|
|
|
CR:300717
|
|
300717 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
CICS 3.x Terminal type security, Possibly causing storage issue. |
|
|
|
CR:300733
|
|
300733 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
|
|
02 Jun 2003 |
Fixed |
|
|
|
03 Jun 2003 |
Fixed |
|
|
|
|
|
OpenSwitch -h flag doesn't display all available options (c,f,j) |
|
|
|
CR:300734
|
|
300734 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
rp_debug command missing some debug flags (a,f,j) |
|
|
|
CR:300751
|
|
300751 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
OpenSwitch help screen was showing outdated options, and command line options without parameters were not consistent in their default settings. Options like '-h' and '-v' should not require a configuration file to run. |
|
|
|
CR:300762
|
|
300762 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
09 Dec 2002 |
Fixed |
|
4.2 |
|
09 Dec 2002 |
Fixed |
|
|
|
|
|
jConnect could possibly hang while sending data to the server after a client had set a parameter with the setAsciiStream method. This problem has been fixed. |
|
|
|
CR:300764
|
|
300764 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
02 Dec 2002 |
Fixed |
|
4.2 |
|
02 Dec 2002 |
Fixed |
|
4.2 |
|
02 Dec 2002 |
Fixed |
|
4.2 |
|
02 Dec 2002 |
Fixed |
|
4.2 |
|
02 Dec 2002 |
Fixed |
|
4.2 |
|
02 Dec 2002 |
Fixed |
|
|
|
|
|
jConnect has been made smarter about when to send streaming and non-streaming data to the server. This is important because there are times when a client will want to ensure that data gets to the server in streaming parameter for (an example would be if the client needs to send in a value to a java method in the server that takes an InputStream as a parameter).
A good rule of thumb is that clients who want to send streaming data to the server should make sure to set the JCONNECT_VERSION connection property to 4 or higher (this is the default in jConnect 5.x), and they should call the PreparedStatement.set*Stream methods to set the parameter.
For clients using widetable-enabled ASE servers (version 12.5 and higher), and who are interested in sending values to large (> 255 byte) varchar and varbinary columns and stored proc params, the client should use the setString and setBytes methods. This will help clients avoid getting errors from the server saying that explicit CONVERTs are needed. |
|
|
|
CR:300795
|
|
|
|
|
|
|
02 May 2003 |
Fixed |
|
|
|
01 May 2003 |
Bundled Request |
|
|
|
26 Jun 2001 |
Fixed |
|
|
|
|
|
CTLIB: Unresolved Symbols when running ctlibrary example 'multthrd' on axposf. |
|
Workaround Description |
|
Modify the sybopts.sh file. Change the following line from:
dce_axposf) SYSLIBS="-threads -oldstyle_liblookup " ;;
to:
dce_axposf) SYSLIBS="-lm -lrt -threads -oldstyle_liblookup " ;; |
|
|
|
CR:300846
|
|
300846 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
21 Nov 2002 |
Fixed |
|
|
|
25 Nov 2002 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
27 Nov 2002 |
Fixed |
|
|
|
12 Jan 2003 |
Fixed |
|
|
|
|
|
SRVLIB: calls to srv_wakeup(SRV_M_WAKE_INTR), srv_ucwakeup(SRV_M_WAKE_INTR) or srv_event_deferred() result in open server spinning causing high CPU usage. |
|
|
|
CR:300904
|
|
300904 |
|
Connectivity Utilities |
|
isql |
|
|
|
|
|
|
|
|
|
|
03 Dec 2002 |
Fixed |
|
|
|
08 Dec 2003 |
Fixed |
|
|
|
21 Nov 2002 |
Fixed |
|
|
|
|
|
ISQL: Under some circumstance, ISQL may segfault with textsize set to the maximum. ISQL now will try to allocate 1/2 of the request first, then the default. If that fails, ISQL will exit gracefully. |
|
|
|
CR:300969
|
|
300969 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
Batched Cursor program are not processed properly Gatewayless |
|
|
|
CR:301187
|
|
301187 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows |
|
12.5 |
|
|
|
|
|
|
ODBC: Driver fails for SQLBindCol with SQL_C_NUMERIC for a particular number when it had 17 digits. However since the ODBC specification limits maximum digits of Numeric values to 16, any value greater than 16 will now fail with a numeric overflow error message. For example, this query will fail: select convert(numeric(17,0), 10000000000000001) with error message: "Numeric overflow. Error in column 1." |
|
|
|
CR:301383
|
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
19 Dec 2002 |
Fixed |
|
|
|
20 Dec 2002 |
Fixed |
|
|
|
02 Jan 2003 |
Fixed |
|
|
|
06 Jan 2003 |
Fixed |
|
|
|
|
|
CTLIB/NETLIB/SRVLIB: Memory and file descriptor leak when non-SSL/SSL connections fail. |
|
|
|
CR:301912
|
|
301912 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: If the OLEDB datasource does not contain the database name to connect to, and the current database to operate on is set by conn.DefaultDatabase = "dbname" then a subsequent instruction to set a parameter, cmd.Parameters.Item("@my_value").Value = <value>, resets the current database. So subsequent statements may fail because they do not exist in the database. This problem has been fixed in version 02.70.0016. |
|
Workaround Description |
|
If you run
conn.DefaultDatabase = "punydb"
after setting the parameter the subsequent procedure execution works fine |
|
|
|
CR:302049
|
|
302049 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
5.2 |
|
15 Sep 2003 |
Fixed |
|
5.5 |
|
15 Sep 2003 |
Fixed |
|
|
|
|
|
jConnect will no longer begin a transaction in chained mode when Connection.getAutoCommit() or Connection.getIsolationLevel() is called. This allows clients to use code such as the following:
if (! Connection.getAutoCommit())
{
Connection.setAutoCommit(true);
}
without getting an Exception from the database. |
|
Workaround Description |
|
updating spt_mda to use suggestions in this CR.
Jay - I think the test should be nested in an inner transaction.
begin tran
< perform metadate test>
commit tran
e.g. insert spt_mda values ('GET_ISOLATION', 2, 'begin tran select @@isolation c |
|
|
|
CR:302070
|
|
302070 |
|
Open Server |
|
srvlib |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
17 Dec 2002 |
Fixed |
|
|
|
07 Jan 2003 |
Fixed |
|
|
|
15 Oct 2003 |
Fixed |
|
|
|
|
|
SSL: Usage of SSL can cause access violations within open server. Can also happen within open client application that has multiple ssl connections in use. |
|
|
|
CR:302191
|
|
302191 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Request that SQL.INI setup by Default |
|
|
|
CR:302198
|
|
302198 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Could not connect with OpenServer gateway to ASE if the database name is not provided in the Connection String. |
|
|
|
CR:302223
|
|
302223 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
19 Dec 2002 |
Fixed |
|
|
|
27 Feb 2003 |
Fixed |
|
|
|
23 Mar 2003 |
Fixed |
|
|
|
|
|
BCP: BCP may generate core dump when doing bulk insert to a DOL table |
|
Workaround Description |
|
Specifying -b1 can help this situation. |
|
|
|
CR:302377
|
|
302377 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
09 Dec 2002 |
Fixed |
|
4.5 |
|
09 Dec 2002 |
Fixed |
|
|
|
|
|
jConnect will now send the client machine's name when logging into the server. Previously, if a client application did not set the HOSTNAME connection property, subsequent calls to 'select host_name()' on the server would return NULL.
With the new behavior, a client will still be able to specify a HOSTNAME using the connection property. But, if the client does not specify one, jConnect will attempt to learn the host machine's name, and will send that to the server at login time. |
|
|
|
CR:302395
|
|
302395 |
|
Open Server |
|
srvlib |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
|
|
|
05 Dec 2002 |
Fixed |
|
|
|
17 Dec 2002 |
Fixed |
|
|
|
23 Dec 2002 |
Fixed |
|
|
|
|
|
SRVLIB: Open Server generates access violations on NT Advanced Server. |
|
|
|
CR:302548
|
|
302548 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
Need to change setAutoCommit for XA Connection. |
|
|
|
CR:302579
|
|
302579 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: When using TClientDataSet object with Delphi and OLE DB Provider there are two problems inserting data:
1. An EOLEException with message "Errors Occurred" is raised when inserting Chinese characters.
2. An EOLEException with message "Parameter data overflow for small money at ordinal 6" is raised when inserting numeric data greater than 99999, eventhough in delphi the data type is ftBCD. |
|
Workaround Description |
|
Use the TdataSetProvider or have TClientDataSet DataSetProvide1's property "ResolveToDataSet " set to
"true" which simply applies all changes to the TdataSetProvider. |
|
|
|
CR:302586
|
|
|
|
|
|
|
28 Jan 2003 |
Fixed |
|
|
|
15 Jun 2004 |
Insufficient priority to fix |
|
|
|
16 Jun 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
23 Feb 2003 |
Fixed |
|
|
|
26 Mar 2003 |
Fixed |
|
|
|
|
|
ESQL/C:Connection fall back doesn't work when primary machine off line. |
|
|
|
CR:302753
|
|
302753 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: provider hangs when executing stored procedure. Tested and reproduced with OLEDB Provider 2.70.0010 and 2.70.0011 Other software involved: VB 6.0, MS Windows NT 4.0 SP6, ASE 12.5. |
|
Workaround Description |
|
No effective workarounds found until now.
Tried SkipDMLInBatches=1 and "set ansinull off" (Init string) but issue persists. |
|
|
|
CR:302937
|
|
302937 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
5.2 |
|
14 Apr 2003 |
Fixed |
|
|
|
14 Apr 2003 |
Fixed |
|
|
|
|
|
jConnect now provides a way through the javax.naming.Referenceable interface methods to see the values for all the settable connection property values. Now, when a Reference object is created through getReference(), we populate the Reference object with the current values of all the connection properties. These can be retrieved using code such as:
Reference.get("REPEAT_READ").getContent(); |
|
Workaround Description |
|
They are using ConnectionPool on this and cannot get access to these properties with the Borland Application. |
|
|
|
CR:303172
|
|
303172 |
|
Open Server |
|
srvlib |
|
|
Closed |
|
Microsoft Windows NT |
|
11.0 |
|
|
|
|
|
|
|
|
|
12 Aug 2004 |
Fixed |
|
|
|
13 Sep 2004 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
CSLIB: Memory leak when calling cs_dt_info. |
|
|
|
CR:303369
|
|
303369 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Inserting numeric values via stored procedure parameters causes fractional truncation error. |
|
|
|
CR:303559
|
|
303559 |
|
Other - Docs: Connectivity |
|
Other - Docs: Connectivity |
|
|
|
|
|
|
|
|
|
|
20 Feb 2004 |
EOL'd version. Not to be Fixed. |
|
|
|
|
|
Need to document requirement to recompile when upgrading to new major releases |
|
|
|
CR:303570
|
|
303570 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
12 Feb 2004 |
EOL'd version. Not to be Fixed. |
|
|
|
|
|
|
|
|
|
|
BCP: requires an equivilent if isql's -Q option to allow connection to HA servers after failover. |
|
Workaround Description |
|
Modify the interfaces file to have adirect entry for the failover server and use that when connecting using bcp |
|
|
|
CR:303635
|
|
303635 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: The OLE DB Provider was not displaying the duplicate insert error message in an ADO application. |
|
Workaround Description |
|
Use odbc driver. |
|
|
|
CR:303645
|
|
303645 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Support for Open Server. |
|
|
|
CR:303646
|
|
303646 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Open |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: Support for Open Server. |
|
|
|
CR:304000
|
|
304000 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: gives error: "Parameter data overflow for smallmoney at ordinal 2" when passing large values into adCurrency parameters. |
|
Workaround Description |
|
Use adDecimal(19,4) instead of adCurrency in application. |
|
|
|
CR:304048
|
|
304048 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
Calls to registered procedures from ASE via the SITEHANDLER protocol may hang if the RPC call fills exactly 3 x 512 byte TDS packets. |
|
Workaround Description |
|
Make sure paramter data stays under the 3 x 512 byte data size. |
|
|
|
CR:304088
|
|
304088 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: In an ADO application with CursorLocation set to adUseClient, a stored procedure hangs if it returns 0 rows and a print statement. |
|
|
|
CR:304226
|
|
|
|
|
|
|
07 Jan 2003 |
Fixed |
|
|
|
15 Oct 2003 |
Fixed |
|
|
|
|
|
LIBTCL: When the SSL driver is missing and a connection is attempted that requires SSL, an OC/OS application will SEGV. For example, ASE generates a stack trace in its log file with netp_ep_inactive on the stack. |
|
|
|
CR:304589
|
|
304589 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Select host_id() returns hexadecimal value instead of decimal. |
|
|
|
CR:304592
|
|
304592 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: Select host_id() returns hexadecimal value instead of decimal. |
|
|
|
CR:305116
|
|
305116 |
|
Open Server |
|
srvlib |
|
|
Closed |
|
Solaris |
|
To Be Determined |
|
|
|
|
|
|
|
|
|
02 Jun 2003 |
Fixed |
|
|
|
02 Jun 2003 |
Fixed |
|
|
|
04 Jun 2003 |
Fixed |
|
|
|
05 Jun 2003 |
Fixed |
|
|
|
|
|
SRVLIB: Open server applications may hang with heavy RPC activity. |
|
|
|
CR:305233
|
|
305233 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
If a non-Sybase client attempts to use the OpenSwitch port, OpenSwitch will crash with
the following error...ERROR: spid 230: SRVLIB: NUM=16315 SEV=15 ST=0: srv__read_packet:
Protocol error occurred: length in header (3338) more than packet size(512) |
|
|
|
CR:305449
|
|
305449 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
After bcp in operation completes spids are hanging in OSwitch and ASE |
|
|
|
CR:305455
|
|
305455 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
bcp in a table that contains text/image data through OpenSwitch hangs |
|
|
|
CR:305461
|
|
305461 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
A CT-Lib bulkcopy program hangs when running through OpenSwitch |
|
|
|
CR:305500
|
|
305500 |
|
Connectivity Utilities |
|
bcp |
|
|
|
|
|
|
|
|
|
|
20 May 2003 |
Fixed |
|
|
|
09 Jun 2003 |
Fixed |
|
|
|
|
|
BCP: bcp core dumps when bcp in a table that contains text/image data through OpenSwitch. |
|
|
|
CR:305625
|
|
305625 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
10 Apr 2003 |
Fixed |
|
5.2 |
|
10 Apr 2003 |
Fixed |
|
5.2 |
|
10 Apr 2003 |
Fixed |
|
5.5 |
|
10 Apr 2003 |
Fixed |
|
5.2 |
|
10 Apr 2003 |
Fixed |
|
5.2 |
|
10 Apr 2003 |
Fixed |
|
|
|
|
|
jConnect clients can now utilize the High-Availability Failover (HA) feature in ASE without needing an LDAP server to provide the failover server URL. This is accomplished with the new SECONDARY_SERVER_HOSTPORT connection property.
To setup jConnect to utilize failover (without using an LDAP server), clients should do the following:
1. Set the REQUEST_HA_SESSION connection property to true (note that clients must do this when using an LDAP server as well)
2. Set the new SECONDARY_SERVER_HOSTPORT property to the hostname and port number of the failover server. For example, if the failover server was on host machine foo, and the server was listening on port 4000, you might use the following lines of code:
Properties props = new Properties();
props.put("REQUEST_HA_SESSION", "true");
props.put("SECONDARY_SERVER_HOSTPORT", "foo:4000");
Note that a colon is placed between the hostname and the port number, just as in a typical JDBC URL. |
|
|
|
CR:305956
|
|
305956 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
05 Feb 2003 |
Fixed |
|
5.2 |
|
05 Feb 2003 |
Fixed |
|
5.5 |
|
05 Feb 2003 |
Fixed |
|
|
|
|
|
jConnect will no longer hang in certain (rare) special cases where deadlock exceptions are received during ResultSet processing. |
|
|
|
CR:306372
|
|
306372 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: In current EBF, if the database name field is not populated in the Data Source or connection string, and ODBC Driver is connected to an Open Server application that serves as a gateway to ASE, the resulting connection will fail due to a GPF Exception. |
|
|
|
CR:306442
|
|
306442 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
5.2 |
|
05 Feb 2003 |
Fixed |
|
5.2 |
|
05 Feb 2003 |
Fixed |
|
|
|
|
|
jConnect now properly handles cursor row updates when the table contains columns with more than 2,048 bytes. |
|
|
|
CR:306556
|
|
|
|
|
|
|
09 Sep 2003 |
Fixed |
|
|
|
11 Sep 2003 |
Fixed |
|
|
|
|
|
CTLIB: ct_close(CS_FORCE_CLOSE) cannot be called when secondary server is down during HA failover. |
|
Workaround Description |
|
Wait for failover to complete before closing the connection |
|
|
|
CR:306557
|
|
306557 |
|
OLE DB Provider |
|
OLE DB Provider |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
OLEDB: No rowcount information is returned when using clientside cursors in transactions. |
|
|
|
CR:306770
|
|
|
Open |
|
Microsoft Windows NT |
|
2.0 |
|
|
|
|
|
|
JISQL: Resultsets which include text datatype values are now formatted into columns when displayed using the "Present result set as" = "Text" option. |
|
Review Status |
Reviewed Aug 2003. Fix may be considered for a future release, but is currently not targeted. |
|
Workaround Description |
|
Write customer application. |
|
|
|
CR:307029
|
|
307029 |
|
OpenSwitch |
|
OpenSwitch |
|
|
|
|
|
|
|
|
12.5 |
|
02 May 2003 |
Not a Bug |
|
|
|
|
|
OpenSwitch should be configurable to failover at login timeout or connect timeout, and these timeout values should also be configurable in the OpenSwitch config file. |
|
Workaround Description |
|
None. |
|
|
|
CR:307040
|
|
307040 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
04 Feb 2003 |
Fixed |
|
2.0 |
|
04 Feb 2003 |
Fixed |
|
2.0 |
|
04 Feb 2003 |
Fixed |
|
2.0 |
|
04 Feb 2003 |
Fixed |
|
2.0 |
|
04 Feb 2003 |
Fixed |
|
2.0 |
|
04 Feb 2003 |
Fixed |
|
|
|
|
|
jConnect will now properly report the column default value (if one has been specified) when a client calls DatabaseMetaData.getColumns. Previously, if a user had set a default value via the sp_bindefault stored procedure, jConnect was not correctly picking up that default value. |
|
Workaround Description |
|
Currently there is no workaround |
|
|
|
CR:307251
|
|
307251 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: ODBC: SQLExecDirect() returns SQL_ERROR on stored procedure call that sends message through a PRINT T-SQL statement. Now it returns SQL_SUCCESS_WITH_INFO. |
|
|
|
CR:307258
|
|
307258 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
Listener Returning the wrong messaage for a Blank or null userID |
|
Workaround Description |
|
NONE |
|
|
|
CR:307268
|
|
307268 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
|
|
|
05 Feb 2003 |
Fixed |
|
|
|
05 Feb 2003 |
Fixed |
|
5.5 |
|
05 Feb 2003 |
Fixed |
|
|
|
|
|
jConnect no longer will hit an internal exception if it encounters a SQLException while doing a cursor fetch. |
|
|
|
CR:307272
|
|
307272 |
|
jConnect |
|
JDBC Driver |
|
|
|
|
|
|
|
jConnect: If jConnect creates a Statement internally to help execute a client statement, the query timeout value that may have been set does not get propogated to the internal statement. |
|
|
|
CR:307715
|
|
|
|
|
|
|
25 Feb 2003 |
Fixed |
|
|
|
20 Feb 2003 |
Fixed |
|
|
|
25 Aug 2003 |
Fixed |
|
|
|
09 Jun 2004 |
Fixed |
|
|
|
|
|
CTLIB: Using ct_poll on an asynchronous connection (CS_NETIO: CS_ASYNC_IO) could cause a SEGV. (Unix, non-reentrant libraries only.) |
|
|
|
CR:307796
|
|
307796 |
|
Open ServerCONNECT for CICS |
|
tcp/ip |
|
|
|
|
|
|
|
The Surrogate Connection Handle should point to the surrogate transaction's EIB block and IHANDLE not to the context Handler's(SYCH) EIB and IHANDLE.
Con_comres and con_ihandle field in the surrogate conhandle need to be updated when the surrogate conhandle is built to point to the correct EIB and IHANDLE's This will cauise OC4's when Tran Iso is turn on an a transaction tries to wirte to the SYTDLOG1, and there may be other problems that are not documented. |
|
|
|
CR:307874
|
|
307874 |
|
ODBC Driver Kit |
|
ODBC Driver Kit |
|
|
Closed |
|
Microsoft Windows NT |
|
12.5 |
|
|
|
|
|
|
ODBC: GPF when using Parameter set size. |
|
|
|
CR:307875
|
|
307875 |
|
Open Server |
|
srvlib |
|
|
|
|
|
|
|
|
|
|
12 Feb 2003 |
Fixed |
|
|
|
13 Feb 2003 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
17 Sep 2002 |
Not reproducible with latest version of the product available as of Resolution Date |
|
|
|
|
|
NETLIB: On unix platforms using the reentrant libaries, srv_ucwakeup(SRV_M_WAKE_INTR) will hang when called from the attention handler. |
|
Workaround Description |
|
Not sure this is a workaround. Instead of srv_ucwakeup( srvproc, SRV_M_WAKE_INTR), call srv_ucwakeup( srvproc, 0) will not hang Repserver during Repserver OST tests. |
|
|
|
CR:307978
|
|
|
|
RCM should display message when started |
|
|
|
--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------