远程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:295830
CR Number:   295830
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Mar 2003 Fixed
Description
ISQL/CICS return unsupported datatype on select * from sysmessages against ASE12.5



CR:295833
CR Number:   295833
Product Name:   Open Client-Doc
Product Component:   Client-Library C Reference Manual
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
Description
Open Client Reference Manual missing Multithreaded programming section



CR:295867
CR Number:   295867
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   295998
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2003 Fixed
05 Feb 2003 Fixed
Description
SRVLIB: srv_descfmt fails to retrieve maxlength of a char parameter over 255 characters



CR:296436
CR Number:   296436
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   296714
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2003 Fixed
17 Feb 2003 Fixed
Description
BCP: bcp fails to truncate and insert longchar XNL type data.



CR:296725
CR Number:   296725
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2002 Fixed
Description
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
CR Number:   296726
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2002 Fixed
Description
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
CR Number:   296860
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2003 Fixed
16 Jul 2003 Fixed
17 May 2004 Not a Bug
Description
BCP: bcp out of NULLable char-type columns are padded with NULL-characters
Workaround Description
 Use NOT NULL with CHAR column.



CR:296954
CR Number:   296954
Product Name:   OpenTransport
Product Component:   JMS Driver
Status:   Closed
OS:   Windows 2000
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2002 Fixed
Description
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
CR Number:   297008
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2002 Not a Bug
Description
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
CR Number:   297342
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
26 Jun 2001 Not a Bug
Description
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
CR Number:   297468
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
OpenSwitch hangs client while CM is running during a server crash



CR:297627
CR Number:   297627
Product Name:   OpenTransport
Product Component:   JMS Driver
Status:   Closed
OS:   Multiple
Original Version:   2.6.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2003 Not a Bug
Description
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
CR Number:   297665
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2003 Presently Not Targeted For Any Future Release Of This Product
Description
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
CR Number:   297796
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2002 Not a Bug
Description
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
CR Number:   297888
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2002 Fixed
07 Nov 2002 Fixed
Description
COMNLIB: Sporadic CreateMutex() failures on HP.



CR:298282
CR Number:   298282
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   298658
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2004 Fixed
Description
ODBC: COMPUTE clause through ODBC does not work.



CR:298666
CR Number:   298666
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2002 Fixed
04 Aug 2003 Fixed
Description
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
CR Number:   298676
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
Description
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
CR Number:   298703
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2002 Fixed
15 Nov 2002 Fixed
15 Oct 2003 Duplicate
Description
SSL: Can't complete handshake with chained certificate.



CR:299019
CR Number:   299019
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2002 Fixed
11 Nov 2002 Fixed
06 Nov 2002 Fixed
Description
CTLIB: ct_con_alloc may SIGSEGV when there is insufficient memory to allocate the connection structure.



CR:299032
CR Number:   299032
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2003 Fixed
Description
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
CR Number:   299219
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Mar 2003 Fixed
Description
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
CR Number:   299262
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
Request isql on NT defaults to cp850 characterset regardless of locales.dat



CR:299451
CR Number:   299451
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 Duplicate
Description
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
CR Number:   299624
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2003 Not a Bug
17 Sep 2003 Duplicate
Description
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
CR Number:   299628
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2002 Fixed
12.5.1 10 Apr 2003 Fixed
Description
BLKLIB: blk_colval failing on variable length column with Buffer size error



CR:299879
CR Number:   299879
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2003 Fixed
23 Jan 2003 Fixed
27 Feb 2003 Fixed
Description
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
CR Number:   299893
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   299932
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2003 Duplicate
17 Sep 2003 Duplicate
Description
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
CR Number:   299982
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2002 Fixed
20 Dec 2002 Fixed
04 Dec 2002 Fixed
Description
SRVLIB: Closing a sitehandler connection could fail to close a subchannel connection.



CR:300194
CR Number:   300194
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2003 Fixed
26 Jun 2001 Presently Not Targeted For Any Future Release Of This Product
Description
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
CR Number:   300371
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
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
CR Number:   300389
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2004 Fixed
Description
Customer would like to have one SYGWHOST across multiple LPARS.



CR:300563
CR Number:   300563
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2003 Fixed
Description
ODBC: Unable to connect to ASE using interfaces file through MS Excel application.
Workaround Description
 None



CR:300604
CR Number:   300604
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
OpenSwitch crashes in queue_completion



CR:300717
CR Number:   300717
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Mar 2003 Fixed
Description
CICS 3.x Terminal type security, Possibly causing storage issue.



CR:300733
CR Number:   300733
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Fixed
03 Jun 2003 Fixed
Description
OpenSwitch -h flag doesn't display all available options (c,f,j)



CR:300734
CR Number:   300734
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2003 Fixed
Description
rp_debug command missing some debug flags (a,f,j)



CR:300751
CR Number:   300751
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2003 Fixed
Description
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
CR Number:   300762
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
Description
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
CR Number:   300764
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
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
CR Number:   300795
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Digital UNIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2003 Fixed
01 May 2003 Bundled Request
26 Jun 2001 Fixed
Description
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
CR Number:   300846
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
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
CR Number:   300904
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2002 Fixed
08 Dec 2003 Fixed
21 Nov 2002 Fixed
Description
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
CR Number:   300969
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Aug 2003 Fixed
Description
Batched Cursor program are not processed properly Gatewayless



CR:301187
CR Number:   301187
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2003 Fixed
Description
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
CR Number:   301383
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2002 Fixed
20 Dec 2002 Fixed
02 Jan 2003 Fixed
06 Jan 2003 Fixed
Description
CTLIB/NETLIB/SRVLIB: Memory and file descriptor leak when non-SSL/SSL connections fail.



CR:301912
CR Number:   301912
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2003 Fixed
Description
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
CR Number:   302049
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 15 Sep 2003 Fixed
5.5 15 Sep 2003 Fixed
Description
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
CR Number:   302070
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2002 Fixed
07 Jan 2003 Fixed
15 Oct 2003 Fixed
Description
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
CR Number:   302191
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Request that SQL.INI setup by Default



CR:302198
CR Number:   302198
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Could not connect with OpenServer gateway to ASE if the database name is not provided in the Connection String.



CR:302223
CR Number:   302223
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2002 Fixed
27 Feb 2003 Fixed
23 Mar 2003 Fixed
Description
BCP: BCP may generate core dump when doing bulk insert to a DOL table
Workaround Description
 Specifying -b1 can help this situation.



CR:302377
CR Number:   302377
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2002 Fixed
4.5 09 Dec 2002 Fixed
Description
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
CR Number:   302395
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2002 Fixed
17 Dec 2002 Fixed
23 Dec 2002 Fixed
Description
SRVLIB: Open Server generates access violations on NT Advanced Server.



CR:302548
CR Number:   302548
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to change setAutoCommit for XA Connection.



CR:302579
CR Number:   302579
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
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
CR Number:   302586
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
ESQL/C:Connection fall back doesn't work when primary machine off line.



CR:302753
CR Number:   302753
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   302937
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 14 Apr 2003 Fixed
14 Apr 2003 Fixed
Description
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
CR Number:   303172
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   11.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2004 Fixed
13 Sep 2004 Presently Not Targeted For Any Future Release Of This Product
Description
CSLIB: Memory leak when calling cs_dt_info.



CR:303369
CR Number:   303369
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2003 Fixed
Description
ODBC: Inserting numeric values via stored procedure parameters causes fractional truncation error.



CR:303559
CR Number:   303559
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 EOL'd version. Not to be Fixed.
Description
Need to document requirement to recompile when upgrading to new major releases



CR:303570
CR Number:   303570
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 EOL'd version. Not to be Fixed.
Description
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
CR Number:   303635
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
OLEDB: The OLE DB Provider was not displaying the duplicate insert error message in an ADO application.
Workaround Description
 Use odbc driver.



CR:303645
CR Number:   303645
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Support for Open Server.



CR:303646
CR Number:   303646
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB: Support for Open Server.



CR:304000
CR Number:   304000
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2003 Fixed
Description
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
CR Number:   304048
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2002 Duplicate
Description
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
CR Number:   304088
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Dec 2002 Fixed
Description
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
CR Number:   304226
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2003 Fixed
15 Oct 2003 Fixed
Description
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
CR Number:   304589
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 29 Apr 2003 Fixed
Description
ODBC: Select host_id() returns hexadecimal value instead of decimal.



CR:304592
CR Number:   304592
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2004 Fixed
Description
ODBC: Select host_id() returns hexadecimal value instead of decimal.



CR:305116
CR Number:   305116
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2003 Fixed
02 Jun 2003 Fixed
04 Jun 2003 Fixed
05 Jun 2003 Fixed
Description
SRVLIB: Open server applications may hang with heavy RPC activity.



CR:305233
CR Number:   305233
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2003 Duplicate
Description
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
CR Number:   305449
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
After bcp in operation completes spids are hanging in OSwitch and ASE



CR:305455
CR Number:   305455
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
bcp in a table that contains text/image data through OpenSwitch hangs



CR:305461
CR Number:   305461
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2003 Fixed
Description
A CT-Lib bulkcopy program hangs when running through OpenSwitch



CR:305500
CR Number:   305500
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2003 Fixed
09 Jun 2003 Fixed
Description
BCP: bcp core dumps when bcp in a table that contains text/image data through OpenSwitch.



CR:305625
CR Number:   305625
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
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
CR Number:   305956
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2003 Fixed
5.2 05 Feb 2003 Fixed
5.5 05 Feb 2003 Fixed
Description
jConnect will no longer hang in certain (rare) special cases where deadlock exceptions are received during ResultSet processing.



CR:306372
CR Number:   306372
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2003 Duplicate
Description
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
CR Number:   306442
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.2 05 Feb 2003 Fixed
5.2 05 Feb 2003 Fixed
Description
jConnect now properly handles cursor row updates when the table contains columns with more than 2,048 bytes.



CR:306556
CR Number:   306556
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2003 Fixed
11 Sep 2003 Fixed
Description
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
CR Number:   306557
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2003 Fixed
Description
OLEDB: No rowcount information is returned when using clientside cursors in transactions.



CR:306770
CR Number:   306770
Product Name:   jConnect
Product Component:   Jisql
Status:   Open
OS:   Microsoft Windows NT
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
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
CR Number:   307029
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 02 May 2003 Not a Bug
Description
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
CR Number:   307040
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
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
CR Number:   307251
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
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
CR Number:   307258
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
MAP012 06 Aug 2003 Fixed
Description
Listener Returning the wrong messaage for a Blank or null userID
Workaround Description
 NONE



CR:307268
CR Number:   307268
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2003 Fixed
05 Feb 2003 Fixed
5.5 05 Feb 2003 Fixed
Description
jConnect no longer will hit an internal exception if it encounters a SQLException while doing a cursor fetch.



CR:307272
CR Number:   307272
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2005 Fixed
Description
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
CR Number:   307715
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2003 Fixed
20 Feb 2003 Fixed
25 Aug 2003 Fixed
09 Jun 2004 Fixed
Description
CTLIB: Using ct_poll on an asynchronous connection (CS_NETIO: CS_ASYNC_IO) could cause a SEGV. (Unix, non-reentrant libraries only.)



CR:307796
CR Number:   307796
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Aug 2003 Fixed
Description
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
CR Number:   307874
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2003 Fixed
Description
ODBC: GPF when using Parameter set size.



CR:307875
CR Number:   307875
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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
Description
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
CR Number:   307978
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 23 Jun 2003 Fixed
Description
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)上提取数据的非常规恢复工具

  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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------