远程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:702172
CR Number:   702172
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2012 Fixed
26 Jun 2012 Fixed
03 Jul 2012 Fixed
30 Jul 2012 Fixed
Description
SRVLIB: Performance improvement of Open Server message queue operations.



CR:702209
CR Number:   702209
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 25 May 2012 Fixed
Description
ODBC Provider by Sybase: Positioned updates with cursors producing "Internal error (30002)".



CR:702467
CR Number:   702467
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 02 Dec 2012 Fixed
Description
ODBC Driver by Sybase: Microsoft Access displays #DELETED if a numeric column is selected as primary key.
Workaround Description
 WorkAround:

--------------

Don't use 15.7 ESD#01 or higher until problem is fixed.



CR:702740
CR Number:   702740
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 1 03 Apr 2012 Fixed
Description
ODBC Driver by Sybase: Update the SQLCancel() implementation in the ODBC Driver to match ODBC 3.5 and TDS 3.11 specifications.



CR:702747
CR Number:   702747
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#4 25 May 2012 Fixed
25 May 2012 Fixed
Description
jConnect: Request to add support for DatabaseMetaData.getClientInfoProperties().
Target Version
 7.07 ESD#4



CR:703448
CR Number:   703448
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 29 Apr 2013 Fixed
15.7 SP100 29 Apr 2013 Fixed
Description
ADO.NET: Sybase ADO.NET provider fails to store user credentials in Microsoft's reporting server(SSRS).
Workaround Description
 WorkAround:

--------------

Customer is adding credentials in the connection string.



CR:703996
CR Number:   703996
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2012 Fixed
03 Mar 2013 Fixed
Description
BLKLIB: blk_init() in 15.7 ESD #1 may throw errors or 'invalid pointer' and core dump if it attempts to access a non-existing temporary table. It should produce error 208 instead.
Workaround Description
 None known.



CR:704044
CR Number:   704044
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#4 16 Apr 2012 Fixed
24 Apr 2012 Fixed
24 Apr 2012 Fixed
Description
jConnect: NullPointerException is thrown while listing the available charsets.
Target Version
 7.07 ESD#4



CR:704149
CR Number:   704149
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Aug 2012 Fixed
Description
Improve metadata collection for libblk.



CR:704187
CR Number:   704187
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Apr 2012 Not a Bug
Description
Tested and reproduced with:



- jConnect (TM) for JDBC(TM)/7.00(Build 26548)/P/EBF19559/JDK16/Thu Sep 29 9:30:50 2011

- jConnect (TM) for JDBC(TM)/7.07 GA(Build 26686)/P/EBF19793/JDK 1.6.0/jdbcmain/Tue Dec 20 04:39:14 PST 2011

- ASE 15.5 ESD#3 one-off EBF 19324



Problem description:



A "SELECT @@IDENTITY" after an insert into a table with identity column returns zero in jConnect 7.0x. It's a regression from jConnect 6.05, where the same works fine.



CR:704310
CR Number:   704310
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 19 Jun 2012 Fixed
Description
ODBC Driver by Sybase: Starting a batch while another batch is in progress can cause a hang.



CR:705099
CR Number:   705099
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 28 Oct 2012 Bundled Request
Description
jConnect: Syntax error in metadata stored procedures raises Msg 105, "Unclosed quote before the character string..."



CR:705369
CR Number:   705369
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2012 Fixed
Description
ISQL: On Windows, ISQL may fail silently when the value of environment variable %TMP%/%TEMP%/%USERPROFILE% is longer than 65 characters.



CR:705371
CR Number:   705371
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Valgrind reports invalid memory error on ctlibrary



CR:705528
CR Number:   705528
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 09 Aug 2012 Fixed
Description
ODBC Driver by Sybase: Memory leak detected after closing statements using SQLFreeStmt and SQLFreeHandle().
Workaround Description
 WorkAround:

--------------

Set DP=0, but there is a small SQLDriverConnect leak (CR # X) in which I haven't found a workaround yet.



CR:705572
CR Number:   705572
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 28 Nov 2012 Fixed
Description
ODBC Driver by Sybase: Observed some memory leak in SQLDriverConnect function.
Workaround Description
 WorkAround:

--------------

None



CR:705623
CR Number:   705623
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Change odbc Driver default setting for 'password encryption' to enable.



CR:705625
CR Number:   705625
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to have the option to change default settings for Sybase ODBC Driver

when you created a new DSN.



CR:706202
CR Number:   706202
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 18 Jun 2012 Fixed
Description
ODBC Driver by Sybase: Incorrect syntax in getversion.sql results in not being able to update metadata stored procedures.
Workaround Description
 WorkAround:

--------------

Replace the getversion.sql script with version from ESD#01/02



CR:706347
CR Number:   706347
Product Name:   OCS Database Driver for PERL
Product Component:   DBD:SybaseASE
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2012 Bundled Request
Description
Feature request to enhance the Sybase perl driver to use RSA encryption.

DBD::SybaseASE (supplied from 15.7 GA) to set CS_SEC_EXTENDED_ENCRYPTION for the connection

properties when specifying encyptPassword=1 in the connect. Currently only the open source

driver can make use of encyptPassword=1 in the connection and this will use Sybase

proprietary encryption (CS_SEC_ENCRYPION).
Workaround Description
 Use ocs.cfg and add the following:-



[SybaseASE]



CS_SEC_EXTENDED_ENCRYPTION = CS_TRUE

CS_SEC_ENCYPTION = CS_TRUE



--or



Use the open source DBD::Sybase module, modify dbdimpc.c, changing the section regarding

mp_dbh->encryptPassword to the following and rebuild.





if (retcode == CS_SUCCEED) {

if (imp_dbh->encryptPassword[0] != 0) {

int i = CS_TRUE;

if ((retcode = ct_con_props(connection, CS_SET, CS_SEC_EXTENDED_ENCRYPTION,



(CS_VOID*)&i, CS_UNUSED, (CS_INT*)NULL)) != CS_SUCCEED) {

warn("ct_con_props(CS_SEC_EXTENDED_ENCRYPTION, true) failed");

return 0;

}

}

}



CR:706385
CR Number:   706385
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Admin install needs to state the EZAC backlog parameter is a value greater than zero.



CR:706459
CR Number:   706459
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2012 Fixed
23 Jul 2012 Fixed
12 Sep 2012 Fixed
Description
BLKLIB: In Bulk-Library, we had a limitation when copying LOB data into a database table. Namely, if a LOB column is marked for transfer using blk_textxfer(), all subsequent columns of these types must also be marked for transfer using blk_textxfer(). The limitation has been removed now.



CR:706723
CR Number:   706723
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 05 Oct 2012 Fixed
Description
ODBC Driver by Sybase: MFC ADO applications executing stored procedures receiving missing table exception.
Workaround Description
 WorkAround:

--------------

[Customer unable to use suggested work arounds due to CR 490740]

IDCaseWorkAround = 0 but this affects other portion of application that requires to perform updates



Maybe use different connection for this proc call separate from other transactions - however, this proc might be part of the whole transaction involving the updating of records.



CR:706841
CR Number:   706841
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 23 Sep 2012 Fixed
Description
ODBC Driver by Sybase: Crash/Core in SQLDisconnect when used with Boost library(shared_ptr)
Workaround Description
 WorkAround:

--------------

Use older driver, or ignore the segmenation fault - though it can be annoying.



CR:707027
CR Number:   707027
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jun 2012 Work as design
Description
Separate environment variable that preside the Posix LC_ALL or LANG environment for CS_LOCALE.



CR:707235
CR Number:   707235
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 10 Jul 2012 Fixed
25 Jul 2012 Fixed
Description
jConnect: Clients redirected to another Cluster Edition instance not establishing the connection with server's default network packet size.



CR:707355
CR Number:   707355
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#4 15 May 2012 Fixed
15 May 2012 Fixed
Description
jConnect: Encountering java.lang.NullPointerException exception when connecting with connection property USE_METADATA set to false and CHARSET property set to utf8.
Target Version
 7.07 ESD#4
Workaround Description
 Set USE_METADATA=true or set CHARSET to any value other than utf8 (including blank, allowing charset negotiation with the ASE server).



CR:707568
CR Number:   707568
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 30 Jul 2012 Fixed
Description
ODBC Driver by Sybase: Garbled Data is returned for columns that are nullable user defined types based on datetime type.
Workaround Description
 WorkAround:

--------------

No workaround using 15.7. Fails even when using SQLBindColumn (SQL_C_CHAR)



Use 15.5 ODBC Driver. However, exposure occurs when fixing a bug in 15.5 by upgrading to 15.7



CR:708298
CR Number:   708298
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 06 Jun 2013 Fixed
15.7 SP110 06 Jun 2013 Fixed
Description
ADO.NET: NotSupportedException being thrown when an Entity Data Model project tries to retrieve stored procedure column information
Workaround Description
 WorkAround:

--------------

None



CR:708864
CR Number:   708864
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2012 Fixed
Description
SRVLIB: srv_xferdata() returned CS_PARAMS_MORE without copying parameters when using batched parameters in an RPC.



CR:708904
CR Number:   708904
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 04 Oct 2012 Fixed
Description
ODBC Driver by Sybase: SQLBulkOperations() does not correctly propagate errors encountered during metadata collection.



CR:709008
CR Number:   709008
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2012 Fixed
Description
Openswitch doesn't allow disabling truncation of OpenSwitch log file.



CR:709161
CR Number:   709161
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2012 Bundled Request
Description
Openswitch doesn't check the range value of MAX_LOGSIZE in config file



CR:709224
CR Number:   709224
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 02 Jul 2012 Fixed
Description
ODBC Driver by Sybase: Executing SQL statements with arithmetic functions such as SUM on numeric or decimal columns result in "Data overflow" errors.



CR:709439
CR Number:   709439
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2013 Fixed
14 Nov 2012 Fixed
14 Nov 2012 Fixed
06 Jan 2013 Fixed
Description
Performance issues might be noticed in a Mutual Aware Support OpenSwitch server.



CR:709763
CR Number:   709763
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 19 Jul 2012 Fixed
19 Jul 2012 Fixed
19 Jul 2012 Fixed
19 Jul 2012 Fixed
19 Jul 2012 Fixed
19 Jul 2012 Fixed
Description
jConnect: Bulk Insert writes wrong data value in non-APL tables if last column in the table is a variable length column.



CR:710440
CR Number:   710440
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 26 Aug 2013 Fixed
15.7 SP110 05 Aug 2013 Fixed
15.7 SP110 05 Aug 2013 Fixed
Description
ADO.NET: Stored Procedures in EDM passing null parameter instead of actual value
Workaround Description
 WorkAround:

--------------

There is no workaround - can't use ASE ADO.NET with stored procedures and parameters



You can't use ODBC or OLEDB connections in .NET 4.0 under EDM.



CR:710528
CR Number:   710528
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 26 Jun 2012 Fixed
13 Jul 2012 Fixed
26 Jun 2012 Fixed
26 Jun 2012 Fixed
23 Jul 2012 Fixed
20 Jul 2012 Fixed
Description
jConnect: Using qualified table names like dbo.table_name for Bulk Inserts raises exceptions.



CR:710593
CR Number:   710593
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 18 Sep 2012 Fixed
Description
ADO.NET: Using AseBulkCopy class raises Exception: Sybase.Data.AseClient.AseException: Incorrect syntax near '@table_id'.
Workaround Description
 WorkAround:

--------------

In the sp_drv_common_157.sql script I find in sp_drv_bcpmetadata, there are comments in the code that seem to contribute to this problem.



If I remove all the comments, then the AseBulkCopy will work.



CR:711278
CR Number:   711278
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#4 13 Jun 2012 Duplicate
Description
jConnect: Calling PreparedStatement.clearParameters() before PreparedStatement.executeBatch() is executed clears previously added parameter sets.



CR:711303
CR Number:   711303
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 20 Aug 2012 Duplicate
Description
jConnect: Failed to insert into table with 663 columns using PreparedStatement.



CR:711523
CR Number:   711523
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NativeError property in OledbException Errors collection returns 0
Workaround Description
 WorkAround:

--------------

Customer has workaround. It's possible to tokenize/parse item from the Message text.



CR:711929
CR Number:   711929
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 27 Jun 2012 Fixed
27 Jun 2012 Fixed
Description
jConnect: Performance regressions observed in Bulk Insert code path for jConnect 7.07 GA driver.



CR:711996
CR Number:   711996
Product Name:   OCS Extension module for Python
Product Component:   sypydb
Status:   Open
OS:   all
Original Version:   2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2012 Fixed
20 Jul 2012 Fixed
12 Oct 2012 Fixed
25 Oct 2012 Fixed
07 Nov 2012 Fixed
31 Dec 2012 Fixed
31 Dec 2012 Fixed
31 Dec 2012 Fixed
30 Dec 2012 DEFER
Description
A new feature request to implement the bulkcopy functionality in Extension Module for Python.



CR:712291
CR Number:   712291
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 18 Sep 2012 Fixed
Description
ADO.NET: Driver does not return correct error message when non logged version of bulk copy fails.
Workaround Description
 WorkAround:

--------------

EnableBulkLoad=1, or turn on dboption "select into/bulkcopy/pllsort" to the target database



CR:712293
CR Number:   712293
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 13 Jul 2012 Fixed
16 Jul 2012 Fixed
16 Jul 2012 Fixed
23 Jul 2012 Fixed
Description
jConnect: Using jConnect 7.07 to bulk insert rows in Adaptive Server versions earlier than 15.7 results in JZBK7 exception.



CR:712354
CR Number:   712354
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 12 Jul 2012 Fixed
Description
jConnect: Request support for setClientInfo() and getClientInfo()API for SybConnectionProxy class.



CR:712581
CR Number:   712581
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2012 Fixed
Description
ISQL: ^D at password prompt on AIX crashes.



CR:713017
CR Number:   713017
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Product: ADO.NET Provider 15.7 ESD#3

Client: VStudio 2008

OS: Windows XP



Issue description:

------------------



This is for Banco BMG customer.



Customer executes a stored procedure and populates an AseDataAdapter. This routine is run as a batch many times. Sometimes, the following exception occurs in VStudio application:



System.NullReferenceException occurred

Message=Object reference not set to an instance of an object.

Source=Sybase.AdoNet2.AseClient

StackTrace:

em Sybase.Data.AseClient1.AseDataReader.GetFieldType(Int32 index)

em Sybase.Data.AseClient.AseDataReader.GetFieldType(Int32 index)

em System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetFieldType(Int32 ordinal)

em System.Data.ProviderBase.SchemaMapping.SetupSchemaWithoutKeyInfo(MissingMappingAction mappingAction, MissingSchemaAction schemaAction, Boolean gettingData, DataColumn parentChapterColumn, Object chapterValue)

em System.Data.ProviderBase.SchemaMapping..ctor(DataAdapter adapter, DataSet dataset, DataTable datatable, DataReaderContainer dataReader, Boolean keyInfo, SchemaType schemaType, String sourceTableName, Boolean gettingData, DataColumn parentChapterColumn, Object parentChapterValue)

em System.Data.Common.DataAdapter.FillMapping(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 schemaCount, DataColumn parentChapterColumn, Object parentChapterValue)

em System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)

em System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

em System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

em System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

em System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

em asp023.clsSybase.RetornaDataSet(IDbCommand objCommand) na C:\vainner\asp023_acesso_seguranca_negocio\aplicacao\ASSybase.vb:linha 161

InnerException:



CR:713038
CR Number:   713038
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2012 Fixed
Description
BCP: BCP includes a new command line option --quoted-fname. The functionality of this option is to allow users' data file names to contain special characters, such as commas and double-quotes. Besides using this option, users also need to quote their file names using double quotation marks preceded by backslashes(\").
Workaround Description
 WorkAround:

--------------

It's possible to create a soft link to get around the problem



CR:713327
CR Number:   713327
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2012 Fixed
29 Jul 2012 Fixed
07 Aug 2012 Fixed
24 Aug 2012 Fixed
12 Sep 2012 Fixed
03 Mar 2013 Fixed
27 May 2013 Fixed
Description
NETLIB: On AIX platforms, isql may fail to execute with the -X parameter or fail to load SSL filter depending on the order in which shared libraries are specified in the LIBPATH environment variable.



CR:713538
CR Number:   713538
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 04 Oct 2012 Fixed
Description
ODBC Driver by Sybase: Some numeric values being fetched with incorrect sign.



CR:714081
CR Number:   714081
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#7 07 May 2013 Duplicate
Description
jConnect: The error code field in SQLException is not populated for the exception raised when password has expired.



CR:714096
CR Number:   714096
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 03 Aug 2012 Fixed
07 Aug 2012 Fixed
07 Sep 2012 Fixed
07 Sep 2012 Fixed
Description
jConnect: Executing a batch update PreparedStatement with DYNAMIC_PREPARE=false with numeric values may cause numeric overflow, JZ0BE exception.
Workaround Description
 Set jConnect connection property HOMOGENEOUS_ BATCH to false (default is true)



CR:714583
CR Number:   714583
Product Name:   OCS Extenstion module for PHP
Product Component:   sybaseasephp
Status:   Closed
OS:   Windows
Original Version:   5.3.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2012 Fixed
21 Sep 2012 Fixed
Description
PHP: Error "An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information." is reported while running PHP programs on Windows. Note that even after applying this fix, a compatible PHP installation that is built using Visual C++ 8.0 (part of Visual Studio 2005) must be used as the Adaptive Server Enterprise extension module for PHP 15.7 is built using the Visual C++ 8.0 compiler.



CR:714671
CR Number:   714671
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 03 Sep 2012 Fixed
Description
ODBC Driver by Sybase: ODBC driver does not correctly process row count results.



CR:715074
CR Number:   715074
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 18 Sep 2012 Fixed
Description
ODBC Driver by Sybase: ODBC driver sends wrong date literal value for DB2 Access Service back ends.
Workaround Description
 WorkAround:

--------------

Customer will fallback to using the old OEM Driver, 3.0.1 version!



Unable to make code changes and hardcode value - too many applications and they are on a schedule for application rollout.



CR:715188
CR Number:   715188
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 18 Sep 2012 Fixed
Description
ADO.NET: The stored procedure used to collect index information for tables does not return correct index information.



CR:715717
CR Number:   715717
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 09 Oct 2012 Fixed
Description
ADO.NET: GetSchema() API returns incorrect information for indexes on a table.
Workaround Description
 WorkAround:

--------------

Customer us using code modified to call sp_oledb_getindexinfo (They did encounter CR 715188, using modfied script so it produces correct results)



CR:715926
CR Number:   715926
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Oct 2013 Fixed
12 Nov 2013 Fixed
Description
jConnect: Incorrect results returned by execute for "SELECT INTO" DML statements.



CR:716362
CR Number:   716362
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for Provider to set SYBASE variable within context of the AseConnection. If possible provide charsets in comprehensive ASE ADO.NET Provider dll.



CR:716426
CR Number:   716426
Product Name:   Other - Docs: Connectivity
Product Component:   SDK
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2013 Fixed
Description
Document all the connection property for Jconnect in one place.



CR:716432
CR Number:   716432
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2012 Fixed
Description
Solaris x64 dsedit core dumps when started.



CR:716527
CR Number:   716527
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2013 Fixed
08 Nov 2013 Fixed
18 Oct 2013 Fixed
31 Oct 2013 Fixed
22 Oct 2013 Fixed
01 Nov 2013 Fixed
08 Nov 2013 Fixed
Description
Problem: ISQL Performance is reportedly slow retrieving large datasets with IQ 15.6



Solution: ISQL performance has been improved by reworking number-to-string conversions that appeared a major bottleneck. A new commandline flag (--fast) has been added to invoke faster processing at expense of existing output format.



CR:716689
CR Number:   716689
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 18 Sep 2012 Fixed
Description
ADO.NET: Insert operation on text column truncates the data for chinese charset.



CR:717104
CR Number:   717104
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 18 Jun 2013 Fixed
15.0 ESD#6 18 Jun 2013 Fixed
15.0 ESD#6 19 Jun 2013 Fixed
15.0 ESD#6 21 Jun 2013 Fixed
15.0 ESD#6 25 Jun 2013 Fixed
09 Aug 2013 Fixed
09 Aug 2013 Fixed
15.0 ESD#6 04 22 Jul 2013 Fixed
15.0 ESD#6 05 18 Nov 2013 Fixed
Description
TCP gatewayless connections are utilizing excess cpu and other resources due to the practice of having a seperate socket handler (SYSH) transaction for each connection.



CR:717281
CR Number:   717281
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2013 Fixed
Description
Secondary companion OpenSwitch shuts itself down while connected to primary ASE in a Mutual Aware OpenSwitch setup when there is a site failure.



CR:717412
CR Number:   717412
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2012 Fixed
22 Oct 2012 Presently Not Targeted For Any Future Release Of This Product
Description
BCP: "bcp -h" does not include option '--initstring'.



CR:717791
CR Number:   717791
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2013 Fixed
08 Jan 2013 Fixed
Description
Jconnect to include a default ASE SSL implementation this is current done with plug in an socket implementation see the manual.



CR:718250
CR Number:   718250
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2014 Fixed
19 Jun 2014 Fixed
16 Jun 2014 Fixed
28 Aug 2014 Fixed
28 Aug 2014 Fixed
Description
jConnect: When ENABLE_BULK_LOAD is enabled, NULL values can be inserted in NOT NULL columns.



CR:718402
CR Number:   718402
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to create bcp format file without having to use the "out" option.
Workaround Description
 WorkAround:

--------------

Just do it the way it is



CR:718677
CR Number:   718677
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 09 Oct 2012 Fixed
Description
ADO.NET: Driver throws exception if bigdatetime value is null.
Workaround Description
 WorkAround:

--------------

It's possible to convert the column in the SQL dialect but this becomes impractical as there is much code to change where this is involved.



CR:719180
CR Number:   719180
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#7 23 Oct 2012 Fixed
07 Nov 2012 Fixed
26 Nov 2012 Fixed
Description
jConnect: Feature request to improve efficiency of getTransactionIsolation() and getCatalog() Connection methods.
Workaround Description
 n/a



CR:719236
CR Number:   719236
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2013 Fixed
Description
NETLIB: Connection fails to server with 64 master/query entries in interfaces file.



CR:719510
CR Number:   719510
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 28 Oct 2012 Fixed
Description
ODBC Driver by Sybase: Issues with result set processing if warnings are encountered in result set stream.
Workaround Description
 WorkAround:

--------------

Setting ANSINULL = 0 will prevent the ASE warning from being received.



In this particular case, customer doesn't want to implement this as they are uncertain of possible side effects with their applications.

(When using 15.0/15.5 ASE ODBC Driver they didn't encounter this problem)



CR:719703
CR Number:   719703
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 04 Oct 2012 Fixed
Description
ODBC Driver by Sybase: The invalid conversion error message does not contain any information about the cause.



CR:719720
CR Number:   719720
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2013 Fixed
11 Jul 2013 Fixed
02 Aug 2013 Fixed
02 Aug 2013 Fixed
09 Apr 2014 Fixed
09 Apr 2014 Fixed
Description
When application user inserts data using PreparedStatement.executeBatch that contains insert query with mixed dynamic & non-dynamic parameters, "java.lang.ArrayIndexOutOfBoundsException" is thrown.



CR:719947
CR Number:   719947
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 28 Nov 2012 Fixed
15.7 ESD#7 28 Nov 2012 Fixed
Description
ADO.NET: AseBulkCopy class does not correctly insert null and default values in the destination table.
Workaround Description
 WorkAround:

You can set BatchSize = 1 but for practical bulk loading this becomes impractical - very slow and may as well turn off bulk load.



CR:719996
CR Number:   719996
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 22 Oct 2012 Fixed
Description
ADO.NET: Chinese data incorrectly stored in ASE with default character set gb18030.



CR:720001
CR Number:   720001
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2012 Duplicate
Description
Jconnect to include a default ASE SSL implementation this is current done with plug in an socket implementation see the manual.
Workaround Description
 Jconnect support the SSL to ASE use plug in an socket implementation



When it comes down to SSL for jconnect this in the documentation.

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc39001.0707/html/prjdbc0707/X11145.htm?resultof=%22%53%53%4c%22%20%22%73%73%6c%22%20



CR:720030
CR Number:   720030
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Jconnect change the default for IS_CLOSED_TEST.



CR:720301
CR Number:   720301
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2012 Fixed
Description
SSPI: To ship 32bit libsybsspiwrapper.dll for 64bit Windows platform.



CR:720312
CR Number:   720312
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 28 Oct 2012 Fixed
15.7 ESD#5 03 Oct 2012 Fixed
Description
ODBC Driver by Sybase: Calling SQLFreeStmt(stmt, SQL_CLOSE) at some time after calling SQLFreeStmt(stmt, SQL_RESET_PARAMS) results in a core dump or windows crash.
Workaround Description
 WorkAround:

--------------

None found yet



CR:720463
CR Number:   720463
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
MySSLSocketFactoryASE sample NullPointerException.
Workaround Description
 Add a null check for the props in

public Socket createSocket(String host, int port, Properties props)



CR:720484
CR Number:   720484
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to add driver-side PreparedStatement caching, rather than requiring use of additional third party products.



CR:720535
CR Number:   720535
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2012 Fixed
Description
In jConnect for JDBC 7.07, package name for character-set converter classes (TruncationConverter, PureConverter, etc) has been changed from "com.sybase.jdbc4.util" to "com.sybase.jdbc4.charset".



CR:720573
CR Number:   720573
Product Name:   OCS Extenstion module for PHP
Product Component:   sybaseasephp
Status:   Open
OS:   all
Original Version:   15.7 ESD #12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update the PHP driver supplied with ASE\SDK to be based on later release (5.4.6\5.4.7 or

whichever is latest version at point of implementation)



CR:720579
CR Number:   720579
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using a discard file bcp will automatically adjust the batch size to 1 for wide rows, such as

ones with a text columns. This is a feature request for revisiting the current behavior and possibly

making some enhancements.



CR:720585
CR Number:   720585
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#7 26 Nov 2012 Bundled Request
Description
jConnect: Request to enhance performance of the isClosed(), isReadOnly() and getAutoCommit() methods on java.sql.Connection class.
Workaround Description
 None known.



CR:720693
CR Number:   720693
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2012 Fixed
24 Oct 2012 Fixed
24 Oct 2012 Fixed
Description
DBLIB: On AIX, compiling with dblib dynamic library fails with many unresolved symbols.



CR:720762
CR Number:   720762
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Jconnect Failover to use Dual TCP connection to stop connection storm.



CR:720809
CR Number:   720809
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 15 Oct 2012 Fixed
Description
Memory leak.



CR:720921
CR Number:   720921
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows Vista
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SQLGetInfoW SQL_CONVERT_NUMERIC with ASE Odbc driver does not work correctly.



CR:720990
CR Number:   720990
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2014 Fixed
17 Sep 2014 Fixed
Description
ISQL: Plain text password is visible in memory.



CR:722918
CR Number:   722918
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 28 Feb 2013 Fixed
15.7 ESD#7 28 Nov 2012 Fixed
15.7 SP100 28 Nov 2012 Fixed
Description
ADO.NET: When command timeout is encountered on a local transaction, connections are improperly closed leaving rows locked on ASE table.
Workaround Description
 WorkAround:

--------------

Use older Provider (pre 15.7)



CR:723012
CR Number:   723012
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 02 Dec 2012 Fixed
Description
ODBC Driver by Sybase: Microsoft Access displays #DELETED if a bigint column is selected as primary key.
Workaround Description
 WorkAround:

--------------

If ASE int is used in the primary key field this works, but can't open large tables if using bigint or numeric as the primary key.



An unsigned int will NOT work as Driver and/or Access with map parameters to int so arithmetic overflow will occur.



CR:723100
CR Number:   723100
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 SP100 21 Mar 2013 Fixed
28 Mar 2013 Fixed
26 Mar 2013 Fixed
28 Mar 2013 Fixed
Description
jConnect: Unable to use getLineNumber() function on exceptions thrown by jConnect.



CR:723210
CR Number:   723210
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 20 Jan 2013 Fixed
Description
ODBC Driver by Sybase: ODBC driver crashes on a call to SQLFreeStmt(StatementHandle, SQL_RESET_PARAMS)



CR:723620
CR Number:   723620
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 08 Nov 2012 Fixed
Description
Product:



Organic ODBC Driver 15.07.00.411 (one-off provided to customer from previous CR#714671)

Visual Basic 6.0

Adaptive Server Enterprise/15.5/EBF 19324 SMP ESD#3 ONE-OFF/P/RS6000/AIX 5.3/asear155/2532/64-bit/FBO/Thu Jun 9 19:17:14 2011



OS: Windows 2003 Enterprise.



Tested and reproduced it here with /indigo61/rfucuhar03 database (replica from BMG database). The issue happens when there is a trigger involved in update operation.



CR:723762
CR Number:   723762
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Microsoft Windows
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for bcp to log character truncation information in the error file.





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