远程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:723826
CR Number:   723826
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 SP100 25 Mar 2013 Fixed
26 Mar 2013 Fixed
28 Mar 2013 Fixed
29 Mar 2013 Fixed
Description
jConnect: Incorrect updates performed when ENABLE_BULK_LOAD connection property is set and execute() or executeUpdate() API is used with an UPDATE statement that specifies columns out of order against the table schema.
Workaround Description
 Use AddBatch()and executeBatch() if using ENABLE_BULK_LOAD



CR:723860
CR Number:   723860
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
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). When a stored procedure returns more than one result set, the following error occurs:



Run-time error '3251':



Current provider does not support returning multiple recordsets from a single execution.



CR:724039
CR Number:   724039
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)
29 Nov 2012 Bundled Request
Description
jConnect: A NullPointerException is encountered when client performs a HA fail-over for ASE Cluster Edition.



CR:724040
CR Number:   724040
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
JDBC Jconnect Fast Connection Failover for ASE Cluster Edition.



CR:724243
CR Number:   724243
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 10 Dec 2012 Fixed
15.7 ESD#7 28 Nov 2012 Fixed
15.7 ESD#5 23 Jan 2013 Fixed
Description
ODBC Driver by Sybase: When the connection property SkipRowCountResults is set to 0, the Driver does not identify the end of a result-set correctly thereby causing some VB applications to produce an error when using conditional statements such as "ADODB.RecordSet is Nothing".



CR:724253
CR Number:   724253
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 12 Dec 2012 Fixed
Description
OLE DB Provider by Sybase: The OLE DB provider throws unsupported type exception on DeriveParameters() call.
Workaround Description
 WorkAround:

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

You can explicitly set the data type to decimal:



IDataParameter[] clonedParameters = CloneParameters(discoveredParameters);

AssignParameterValues(clonedParameters, param1);



(clonedParameters[1]).DbType = System.Data.DbType.Decimal;



OR you can explicitly set parameter to decimal in the stored procedure:



CREATE PROCEDURE TestParamsSybase2(@Param1 varchar(20), @Param2 numeric(21,8) = NULL OUTPUT)

AS

BEGIN

select @Param1, getdate()

END

GO



CR:725009
CR Number:   725009
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 10 Sep 2014 Consult Complete
Description
OLEDB Provider by SAP: sydbrvadm utility does not have the correct privileges when run in 64bit mode on certain Windows platforms.
Workaround Description
 WorkAround:

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

Install in different location (but VirtualStores won't work). In this case:

1) x86 version, you can change the DSNFolder but you must create the directory if it doesn't exist.

2) x64 has no permissions to change DSNFolder - in options we get "user does not have permissions for this operation"

3) Both x86 and x64 can create data sources. Keep in mind that in order to provide their Own DSNFolder they must create the directory manually at first.



Admin can open rights to the DSN folder and possibly adjust registry.



CR:725161
CR Number:   725161
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)
21 Dec 2012 Fixed
Description
CSLIB: CS_UNICHAR conversions were slow and did not scale.



CR:725467
CR Number:   725467
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 07 May 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Request to change default on enablebulkload from 0 to 2



CR:725844
CR Number:   725844
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SSIS Execute SQL Task failing when executing stored procedure with parameters
Workaround Description
 WorkAround:

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

Customer is using ADO.NET and so far all is working.



CR:725991
CR Number:   725991
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   AIX
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2012 Fixed
Description
The bcp data file is created with permissions 600, not 640 as documented
Workaround Description
 WorkAround:

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

Customer can chmod the file after created.



CR:726089
CR Number:   726089
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Incorrect varchar binding when table used as a proxy in ASA or IQ.



CR:726982
CR Number:   726982
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   HP-UNIX
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2013 Fixed
Description
ESQL: ESQL/C generates incorrect code when it parses embedded SQL INSERT statement with values to be inserted in the form of element of a structure.



CR:727119
CR Number:   727119
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 21 Jan 2013 Fixed
Description
A 96 byte memory leak was detected.



CR:727379
CR Number:   727379
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 29 Apr 2013 Fixed
Description
ODBC Driver by Sybase: ODBC driver throws Data over flow error for numeric value between -1 and +1 (-1 < n < 1).
Workaround Description
 WorkAround:

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

Unable to since the pyodbc is performing the work internally.



In ODBC API you can set Precision = 7, Scale =6



In C++ I can set value as .0056, instead of 0.0056, but in the python sample this is not working.



CR:727590
CR Number:   727590
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2014 Fixed
Description
Request to certify SDK on Windows 8



CR:727861
CR Number:   727861
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 SP100 31 Jan 2013 Fixed
Description
ODBC Driver by Sybase: SQLGetData() API does not retrieve entire column data if buffer length is passed as 0.



CR:728185
CR Number:   728185
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 SP100 17 Feb 2013 Fixed
Description
jConnect: Internal query used to retrieve list of stored procedures can select bad query plan.



CR:728251
CR Number:   728251
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 03 Jun 2013 Consult Complete
Description
Request to support msdev 2012, .NET 4.5 and EF 5.X



CR:728471
CR Number:   728471
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 22 Mar 2013 Fixed
15.7 SP110 05 Jun 2013 Fixed
Description
ODBC Driver by Sybase: ODBC driver does not return database name, user name and password in output connection string when SQLDriverConnect() is called with SQL_DRIVER_NOPROMPT.
Workaround Description
 In DSN you could add uid and password and connection occurs, but this isn't practical since password is stored in registry and there may be many users involved, hence the logon capability.



CR:728480
CR Number:   728480
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 19 Jun 2013 Fixed
Description
OLE DB Provider by Sybase : Sybase 15.7 OLEDB Provider performs slower than 15.5 provider.



CR:728797
CR Number:   728797
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 Jul 2013 Fixed
Description
ODBC Driver by Sybase: Application crashes in SQLMoreResults()



CR:729587
CR Number:   729587
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 12 Apr 2013 Fixed
Description
ADO.NET: SSIS Custom Destination component does not work with Microsoft Visual Studio 2010
Workaround Description
 WorkAround:

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

Don't use msdev 2010 until we figure this out.



CR:730336
CR Number:   730336
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Organic OLEDB Provider 64-bit on Windows 7 with Kerberos and Active Directory as the KDC:



If the OLEDB data source is configured with a blank user principal in the security tab then

there is a connection error: Acquiring Kerberos Credentials Failed.



If the User Principal is explicitly given then the connect succeeds.



CR:730359
CR Number:   730359
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 29 Apr 2013 Fixed
Description
OLE DB Provider by Sybase: The substitute character for non-convertible characters was changed to ASCII 26 from the previous versions where the substitute character was ASCII 63.



CR:730404
CR Number:   730404
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.7 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2013 Fixed
Description
CTLIB: Memory leak may occur when ct_cursor() fails to declare a cursor.



CR:730742
CR Number:   730742
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)
02 Apr 2013 Fixed
02 Apr 2013 Fixed
Description
SRVLIB: Support for blocking message queues when full.



CR:730972
CR Number:   730972
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2013 Fixed
Description
DBLIB: bcp_sendrow() may fail due to a 20074 error (Attempt to bulk-copy an oversized row to the server.).
Workaround Description
 Run update statistics syscolumns on the target database.



CR:731196
CR Number:   731196
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2013 Fixed
23 Jul 2013 Fixed
13 Apr 2014 Fixed
Description
When user calls setByte on a PreparedStatement using the connection properties DYNAMIC_PREPARE=false & HOMOGENEOUS_BATCH=true, a batch Update Exception "java.sql.BatchUpdateException: JZ0BE: BatchUpdateException: Error occurred while executing batch statement: A query plan cannot be generated for DML command executed with homogeneous batch parameters. The batch was aborted." was thrown.



CR:731197
CR Number:   731197
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2013 Fixed
Description
SRVLIB: srv_log() adds newline after timestamp in the server log.



CR:731476
CR Number:   731476
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 29 Apr 2013 Fixed
Description
ADO.NET: AseBulkCopy class fails to insert data using bulk insert protocol if data contains empty string in it.
Workaround Description
 WorkAround:

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

You can perform the SSIS transfer without using bulk, however, this takes too long when tables are large in size.



CR:731833
CR Number:   731833
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 07 Jun 2013 Consult Complete
15.7 SP110 20 Jun 2013 Fixed
15.7 SP110 05 Aug 2013 Fixed
Description
OLE DB Provider by Sybase: SSIS project fails to map columns if sql is parameterized.
Workaround Description
 WorkAround:

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

None



CR:732130
CR Number:   732130
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 SP100 25 Mar 2013 Fixed
25 Mar 2013 Fixed
09 Apr 2014 Fixed
Description
jConnect: A large batch update operation can hang the jConnect client connection if DYNAMIC_PREPARE connection property is set to false.



CR:732159
CR Number:   732159
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2013 Fixed
Description
CTLIB: Connection fails with error "ct__string_extended_encryption: user api layer: internal common library error: Client password encryption fails."
Workaround Description
 WorkAround:

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

Linux can workaround with -rpath in build command



Solaris - we're still trying to figure it out on how to do this without LD_LIBRARY_PATH[_64]

- On Solaris you can explicitly dynamically link libsbgse2 and libsybcsi_core28:



CC -Bstatic -g -DSYB_LP64 -m64 -I. -I/$SYBASE/OCS-15_0/include -Dsun_svr464=1 firstapp.c

-L$SYBASE/OCS-15_0/lib -lsybct64 -lsybtcl64 -lsybcs64 -lsybcomn64 -lsybintl64 -lsybunic64

-R$SYBCSILIB -L$SYBCSILIB -Bdynamic -lsbgse2 -lsybcsi_core28 -lrt -lsocket -lnsl -ldl -lm -ldl -lc -o firstapp



ldd:

->ldd firstapp

libsbgse2.so => /sybase/ocs/syb157e7/OCS-15_0/sample/ctlibrary/sybcsi/libsbgse2.so

libsybcsi_core28.so => /sybase/ocs/syb157e7/OCS-15_0/sample/ctlibrary/sybcsi/libsybcsi_core28.so



For some reason the Sun compiler is too dumb to figure out the runtime without explicitly telling it the location during link time, including lib names



Also when building do this:



setenv SYBCSILIB $SYBASE/OCS-15_0/sample/firstapp/sybcsi <-- where I keep them

# The point of the location is that it is relative ../sybcsi to my build location of the executable



CC -Bstatic -g -DSYB_LP64 -m64 -I. -I/$SYBASE/OCS-15_0/include -Dsun_svr464=1 firstapp.c

-L$SYBASE/OCS-15_0/lib -lsybct64 -lsybtcl64 -lsybcs64 -lsybcomn64 -lsybintl64 -lsybunic64

-R../sybcsi -L$SYBCSILIB -Bdynamic -lsbgse2 -lsybcsi_core28 -lrt -lsocket -lnsl -ldl -lm -ldl -lc -o firstapp



ldd:

libsbgse2.so => ../sybcsi/libsbgse2.so

libsybcsi_core28.so => ../sybcsi/libsybcsi_core28.so





Then this can be moved to where ever you want but preserve the relative path



CR:732321
CR Number:   732321
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 22 Jul 2013 Workaround
Description
ADO.NET: ADO.NET Provider can磘 accomodate a computed column decimal number (1.43456000000000000000000000000000000) returned from ASE and throws the following error:

Unable to cast object of type 'System.OverflowException' to type 'System.IConvertible'.Couldn't store <System.OverflowException: Value was either too large or too small for a Decimal.



CR:732349
CR Number:   732349
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2013 Fixed
Description
CPRE: Precompiler generates unsigned integer data format when unsigned long parameter is used. For backward compatibility with pre-15.0 cpre, it will now generate signed integer data format if precompiler option -V CS_VERSION_125 or earlier is specified.
Workaround Description
 WorkAround:

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

You can change the c type in the cp code to int/long, anything unsigned.



However, in this case customer is in between migrating from ASE 12.5.X to 15.7. They want to use SDK 15.7 to build/migrate applications and don't want to

change their source codes as there are too many to change feasibly.



CR:732491
CR Number:   732491
Product Name:   ADO.NET Data Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2014 Fixed
Description
ADO.NET: DDEX GUI not updating the properties for Quoted Identifier and Enbale Tracing correctly.
Workaround Description
 WorkAround:

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

Manually adjust the settings from the "All" view.



CR:732677
CR Number:   732677
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 SP100 03 Apr 2013 Fixed
04 Apr 2013 Fixed
09 Apr 2014 Fixed
Description
On attempting to insert BigDecimal value using setBigDecimal() api of PreparedStatement, scale part of value got lost and instead value present before decimal point.



Issue seen with SQL Anywhere 11 & 12 server



CR:732746
CR Number:   732746
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 01 May 2013 Fixed
Description
ODBC Driver by Sybase: The SQLBulkOperations API raises an error when a column has a streaming length.
Workaround Description
 We have swapped the installation to pick up SQLLEN4. The ABAP import completed successfully. The remaining steps in the installation also progressed.



CR:733229
CR Number:   733229
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 07 Jun 2013 Fixed
15.7 SP120 30 May 2013 Fixed
Description
ASE ODBC Driver by Sybase : SQLGetData() does not get a correct double-byte character data if client and server charset's are different.



CR:733365
CR Number:   733365
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 07 Jun 2013 Fixed
Description
ODBC Driver by Sybase: Sybase ASE ODBC provider fails to retrieve special Japanese double byte character if ASE's charset is eucjis and communication charset is ServerDefault.



CR:733384
CR Number:   733384
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 07 Jun 2013 Fixed
Description
ODBC Driver by Sybase: SQLExecute() with SQLBindParameter() does not send correct double byte character to ASE if server and client charset's are different.



CR:733458
CR Number:   733458
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2013 Fixed
06 Sep 2013 Fixed
13 Sep 2013 Fixed
13 Sep 2013 Fixed
Description
jConnect: Prepared Statement objects created on SQLAnywhere database not implicitly removed if Prepared staement objects are not explicitly closed by the user.



CR:733490
CR Number:   733490
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 08 May 2013 Fixed
15.7 SP100 30 May 2013 Fixed
Description
ADO.NET: Microsoft IIS Webserver application becomes unresponsive when the Webserver Application Pool is recycled.
Workaround Description
 WorkAround:

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

None



CR:733504
CR Number:   733504
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASE ODBC Driver by Sybase : A new feature request to implement an option to filter out informatinal messages at login time.



CR:733938
CR Number:   733938
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 26 Apr 2013 Fixed
Description
OLE DB Provider by Sybase: Syntax error in OLE DB MDA script that was introduced in SDK 15.7 ESD2
Workaround Description
 WorkAround:

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

Edit the script to add newline after the "go" command



CR:733940
CR Number:   733940
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 01 May 2013 Fixed
Description
OLE DB Driver by Sybase: MDA install fails, but no errors are reported.
Workaround Description
 WorkAround:

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

We can direct customer to make similar adjustments



CR:734045
CR Number:   734045
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 Apr 2013 Fixed
Description
ODBC Driver by Sybase: MDA install fails on servers between 15.7 GA and 15.7 ESD2.
Workaround Description
 WorkAround:

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

Comment out the sections referencing the predid column in oledb_mda_157.sql



CR:734147
CR Number:   734147
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 01 Jul 2013 Consult Complete
15.7 SP110 22 Jul 2013 Consult Complete
Description
ADO.NET : Crash in sybdrvado20.dll when using connection pooling, parallel LINQ and Entity Framework.



CR:734208
CR Number:   734208
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2013 Fixed
26 Jun 2013 Fixed
Description
While executing a long running query, jConnect internally executes meta-data stored procedure to retrieve information about the column metadata of the query. This internal query was piped to Adaptive Server's Request queue. When user cancel the execution of the query, the cancel request is also piped to the Adaptive Server's Request queue next to the meta-data query request. This causes delay in cancel request processing by Adaptive Server. In some situations, the cancel would take as much time as it would take to execute the query.



CR:734300
CR Number:   734300
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2013 Not a Bug
Description
BCP copies in illegal columns



CR:734403
CR Number:   734403
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2013 Fixed
20 May 2013 Fixed
Description
When using PreparedStatement.executeBatch() to insert data using query which has embedded parameters containing built-ins, an IndexOutOfBoundsException is thrown.



CR:734474
CR Number:   734474
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 01 May 2013 Fixed
Description
ADO.NET: The substitute character for non-convertible characters was changed to ASCII 26 from the previous versions where the substitute character was ASCII 63.



CR:734607
CR Number:   734607
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 Jul 2013 Fixed
Description
ADO.NET: AccessViolation exception seen when trying to cancel command.
Workaround Description
 WorkAround:

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

If pooling = true (default) we always throw the Command has timed out error



CR:734719
CR Number:   734719
Product Name:   OCS Database Driver for PERL
Product Component:   DBD:SybaseASE
Status:   Closed
OS:   NA
Original Version:   15.7 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2013 Fixed
23 Jul 2013 Fixed
16 Aug 2013 Fixed
19 Jul 2013 Fixed
15 Aug 2013 Fixed
30 Jan 2014 Fixed
16 Aug 2013 Fixed
19 Aug 2013 Fixed
Description
Added kerberos as DSN option to SybaseASE Perl Driver.
Workaround Description
 WorkAround:

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

Customer is using ocs.cfg and libtcl.cfg



CR:735084
CR Number:   735084
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
jconnect SEND_BATCH_IMMEDIATE property should be SEND_BATCHPARAMS_IMMEDIATE.



CR:735506
CR Number:   735506
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2013 Fixed
25 Apr 2013 Fixed
29 Apr 2013 Fixed
29 Apr 2013 Fixed
02 Jul 2013 Fixed
23 Jul 2013 Fixed
09 Apr 2014 Fixed
09 Apr 2014 Fixed
09 Apr 2014 Fixed
Description
jConnect: When HOMOGENEOUS_BATCH is enabled, LOB data is truncated at the length of 16KB.



CR:735556
CR Number:   735556
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2014 Fixed
05 Sep 2014 Fixed
Description
jConnect: Session temporary tables created by 揝ELECT INTO #<table name> 厰 query executed from a PreparedStatement go out of scope immediately after execution of the PreparedStatement when DYNAMIC_PREPARE is true.



CR:736691
CR Number:   736691
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 19 Jun 2014 Diagnostic Provided
15.7 SP130 18 Jul 2014 Fixed
Description
ODBC Driver by Sybase: MS Access application returns ODBC Call failed when accessing a DB2 DATE field defined as a primary key, through DB2 Access Service (backendtype = MFC DB2 Access Service) and initialization string is DateResults=char_odbc. The final Data is displayed as "#name?" or #deleted.
Workaround Description
 WorkAround:

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

Customer has to remain on OEM driver



CR:736780
CR Number:   736780
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 31 May 2013 Fixed
Description
ODBC Driver by Sybase: It is possible for a statement to fail to execute in circumstances whereby the previous statement effected no rows and operated against an empty batch.
Workaround Description
 Porting team has tested ODBC driver 15.7.0.410 in this very situation and found it working.



Confirmation/acceptance of validation is outstanding.



CR:736790
CR Number:   736790
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2013 Fixed
26 Jul 2013 Fixed
Description
When Adaptive Server Enterpise version 15.5 ESD#5.1 (updated with installmaster of ESD version 5.2) was used to execute insert query using PerpareStatement object, a "java.sql.SQLException: S0022: Invalid column name 'ENCRYPTED_COL'" is thrown.



CR:736920
CR Number:   736920
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 SP110 07 Jun 2013 Fixed
15.7 SP110 07 Jun 2013 Fixed
15.7 SP110 05 Aug 2013 Fixed
Description
ODBC Driver by Sybase: SQLGetDiagRec does not log output parameters



CR:737307
CR Number:   737307
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 16 Aug 2013 Fixed
Description
ODBC Driver by Sybase: SQLFetchScroll with orientation SQL_FETCH_FIRST incorrectly returns SQL_ERROR.



CR:737348
CR Number:   737348
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 06 Jun 2013 Consult Complete
carina 26 Aug 2013 Fixed
Description
ADO.NET : Visual Studio 2010 crashes when adding a DataSet using TableAdapter.
Workaround Description
 Use CREATE INDEX command instead of CONSTRAINT PRIMARY KEY clause.



CR:737650
CR Number:   737650
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 25 Apr 2013 Fixed
15.7 ESD#5 25 Apr 2013 Fixed
15.7 SP110 04 Jun 2013 Fixed
Description
ODBC Driver by Sybase: Using SQLBincColumnDA can corrupt date columns.



CR:737717
CR Number:   737717
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   RedFlag Linux
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 23 May 2013 Fixed
Description
ODBC Driver by Sybase: When receiving a large response the driver might report an unsupported TDS token.



CR:738023
CR Number:   738023
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 08 Jul 2013 Consult Complete
15.7 SP110 26 Jun 2013 Fixed
15.7 SP110 25 Jul 2013 Fixed
15.7 SP110 15 Jul 2013 Fixed
15.7 SP110 25 Jul 2013 Fixed
15.7 SP110 25 Jul 2013 Fixed
Description
ODBC Driver by Sybase: Windows 2012 64-bit ODBC Administrator crashes when editing an Adaptive Server Enterprise DSN
Workaround Description
 WorkAround:

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

If developing applications use DSN-less connection string for Winx64 applications until this is resolved.



CR:738609
CR Number:   738609
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP101 30 Apr 2013 Fixed
Description
ODBC Driver by Sybase: ODBC driver will hang sometimes if the connection to ASE dies



CR:738626
CR Number:   738626
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#28
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request for BCP utility to verify that the format file matches the target table for BCP in.



CR:738673
CR Number:   738673
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2014 Fixed
10 Jun 2014 Fixed
Description
jConnect: When ENABLE_BULK_LOAD is enabled, setting NULL values for trailing columns can lead to DBCC CHECKSTORAGE reporting consistency errors.
Workaround Description
 None known.



CR:738697
CR Number:   738697
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2013 Fixed
Description
Jconnect method setClientInfo gives java.sql.SQLException, java.sql.SQLClientInfoException. "EXECUTE permission denied on object sp_jdbc_set_client_info, database sybsystemprocs, owner dbo"
Workaround Description
 use sybsystemprocs

go

exec sp_procxmode 'sp_jdbc_set_client_info', 'anymode'

go

grant execute on sp_jdbc_set_client_info to public

go

exec sp_procxmode 'sp_jdbc_getclientinfoprops', 'anymode'

go

grant execute on sp_jdbc_getclientinfoprops to public

go



CR:738962
CR Number:   738962
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 SP101 10 May 2013 Fixed
15.5 ESD 5 10 May 2013 Fixed
Description
ODBC Driver by Sybase: Using server side cursors and SQLBindColumnDA may result in not fetching all rows.



CR:738998
CR Number:   738998
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   carina
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 08 May 2013 Consult Complete
15.7 SP110 13 May 2013 Fixed
Description
ODBC Driver by Sybase: Fixed memory leak from unbound columns.



CR:739095
CR Number:   739095
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP131 26 Sep 2014 Fixed
10 Sep 2014 Fixed
Description
ADO.NET: Introduce new AseBulkCopyOptions to allow the BulkLoad option to be set for each AseBulkCopy



CR:739503
CR Number:   739503
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   15.7 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2013 Fixed
Description
DBLIB: On certain UNIX platforms, dblib applications fail to compile with unresolved symbols unless it is explicitly linked with libsybunic.
Workaround Description
 WorkAround:

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

You can add the libsybunic[64].so to compile/link command:



cc -g -DSYB_LP64 -m64 -I$SYBASE/OCS-15_0/include -L$SYBASE/OCS-15_0/lib -R$SYBASE/OCS-15_0/lib example1.c -Bdynamic -lsybdb64 -lsybunic64 -o example1_dyn



solex@/solex1/pvero/sdk157_esd07/dblib->ldd example1_dyn

libsybdb64.so => /remote/releases/solarisx64/rel157.64_ocsdk_ebfs/ebf20769/OCS-15_0/lib/libsybdb64.so

libsybunic64.so => /remote/releases/solarisx64/rel157.64_ocsdk_ebfs/ebf20769/OCS-15_0/lib/libsybunic64.so

libc.so.1 => /lib/64/libc.so.1

librt.so.1 => /lib/64/librt.so.1

libm.so.2 => /lib/64/libm.so.2

libsocket.so.1 => /lib/64/libsocket.so.1

libnsl.so.1 => /lib/64/libnsl.so.1

libdl.so.1 => /lib/64/libdl.so.1

libaio.so.1 => /lib/64/libaio.so.1

libmd.so.1 => /lib/64/libmd.so.1

libmp.so.2 => /lib/64/libmp.so.2

libscf.so.1 => /lib/64/libscf.so.1

libdoor.so.1 => /lib/64/libdoor.so.1

libuutil.so.1 => /lib/64/libuutil.so.1

libgen.so.1 => /lib/64/libgen.so.1



CR:740087
CR Number:   740087
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2014 Already Fixed by Another CR
Description
jConnect: Request for validation of data such as NULL constraint violation when ENABLE_BULK_LOAD is enabled.



CR:740224
CR Number:   740224
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   AIX
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 25 Jun 2013 Fixed
15.7 SP110 08 Jul 2013 Fixed
Description
ODBC Driver by Sybase: Under some conditions SQLFetch may incorrectly report a bad TDS stream.



CR:740899
CR Number:   740899
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Sep 2014 Fixed
02 Oct 2014 Fixed
Description
BLKLIB: If quoted id's is set on the server, blk_init() may fail on a quoted tablename.



CR:740915
CR Number:   740915
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 30 Jul 2013 Fixed
Description
ADO.NET: CommandTimeout or killing SPID produces unexpected AccessViolation exception.
Workaround Description
 WorkAround:

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

None known.



CR:741176
CR Number:   741176
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 02 Jul 2013 Fixed
Description
ODBC Driver by Sybase: SQL fails if parameters are unbound in TSQL.
Workaround Description
 WorkAround:

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

Customer is migrating off OEM driver, and we will have them try using 15.5 ESD#12 since it works.



CR:741345
CR Number:   741345
Product Name:   OCS Extenstion module for PHP
Product Component:   sybaseasephp
Status:   Closed
OS:   all
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2014 Already Fixed by Another CR
Description
TBD



CR:741956
CR Number:   741956
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update release bulletin to point out problems with missing Linux package. Installer fails if Linux 64-bit system (Redhat 5/6) is missing library libXp.so.6.
Workaround Description
 Workaround: Install the Linux 'libXp' package by using the command yum install libXp.



CR:741998
CR Number:   741998
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP132 21 Nov 2014 Fixed
Description
ASE ODBC Driver by Sybase and OLEDB Provider by Sybase show garbled Japanese ODBC/OLE DB error messages.



CR:742170
CR Number:   742170
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 24 Sep 2013 Fixed
Description
OLE DB Driver by Sybase: Query Timeout property set on a Linked Server Object is not being honored by provider, defaults to 30 seconds instead.
Workaround Description
 WorkAround:

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

Use OEM - but this customer never used OEM Provider



or use syntax:



EXEC ('exec usp_wait45') at PVW71572



CR:742618
CR Number:   742618
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
JConnect to support random from the list of host,port specified in the URL, sql.ini or

Ldap.



CR:742851
CR Number:   742851
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 SP110 23 Jul 2013 Fixed
15.7 SP110 09 Jul 2013 Fixed
15.7 SP120 16 Aug 2013 Fixed
15.7 SP110 30 Jul 2013 Fixed
Description
ODBC Driver by Sybase: ODBC data batching with Bulk insert option selected falls back to regular inserts if SQL statements include embedded comments.



CR:742961
CR Number:   742961
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2013 Fixed
Description
CTLIB: Binding more parameters than the number of placeholders in a dynamic SQL command could lead to a memory corruption.



CR:743044
CR Number:   743044
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2013 Fixed
12 Jul 2013 Fixed
Description
BLKLIB/BCP: BLKLIB created incorrect rows for 'not null not materialized' decimal/numeric columns.



CR:743690
CR Number:   743690
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2013 Fixed
19 Aug 2013 Fixed
Description
jConnect: Wrong/misleading error message is returned when Bulk load ENABLE_BULK_LOAD=BCP option is used and the 'select into/bulkcopy/pllsort' database option is not enabled on the target database.



CR:743836
CR Number:   743836
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2013 Consult Complete
Description
jConnect, Change default value for EARLY_BATCH_READ_THRESHOLD property.
Workaround Description
 Change jConnect property.

EARLY_BATCH_READ_THRESHOLD=value



CR:743933
CR Number:   743933
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Open
OS:   AIX
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for RCM's to handle/manage Replication Server in Multi-Site Availability



CR:744035
CR Number:   744035
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2014 Fixed
17 Jan 2014 Fixed
10 Feb 2014 Fixed
10 Feb 2014 Fixed
10 Feb 2014 Fixed
11 Feb 2014 Fixed
Description
jConnect: Trailing space characters are not truncated for fixed length character columns when using the ENABLE_BULK_LOAD connection property.
Workaround Description
 Code application to rtrim character data before bulk insert.



CR:744143
CR Number:   744143
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 18 Nov 2013 Fixed
Description
ODBC Driver by Sybase: Binding a column to SQL_C_DOUBLE on numeric calculations can cause overflow error.
Workaround Description
 WorkAround:

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

Works in ASE ODBC Driver SDK 15.5 ESD#11 and with 15.7 GA (15.7.0.80) - from 15.7 ESD#1 and up it fails with overflow.



CR:744150
CR Number:   744150
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   Linux
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2013 Fixed
25 Aug 2013 Fixed
Description
ESQL/Cobol: On little-endian platforms, heap corruption may occur when using indicators with array fetches.
Workaround Description
 Customer coded explicit cursor loop instead of using arrays for the multiple rows returned by the SELECT statement. This works fine (no error). This customer is unable to implement such change since they maintain 1000s lines of code.



CR:744269
CR Number:   744269
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect will send PARAMFMT tds Token as BIGDATETIMEN(bigdatetime) when we expect DATEN (datetime).
Workaround Description
 set jConnect property HOMOGENEOUS_BATCH to false.



CR:744583
CR Number:   744583
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2013 Fixed
Description
CTLIB: Plain text passwords are visible in memory.



CR:744688
CR Number:   744688
Product Name:   OCS Database Driver for PERL
Product Component:   DBD:SybaseASE
Status:   Open
OS:   Linux
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to support Perl 5.16.



CR:744691
CR Number:   744691
Product Name:   OCS Database Driver for PERL
Product Component:   DBD:SybaseASE
Status:   Open
OS:   Linux
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to provide Perl Module source code.



CR:744973
CR Number:   744973
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 24 Sep 2013 Fixed
15.7 SP120 25 Sep 2013 Fixed
Description
ADO.NET: When an application running a query on a Adaptive Server Enterprise proxy table encounters a command timeout it causes the provider to hang.
Workaround Description
 WorkAround:

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

no workaround - customer must restart web application server to clear out the problem.



CR:745193
CR Number:   745193
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 04 Oct 2013 Consult Complete
15.7 SP120 25 Oct 2013 Fixed
15.7 SP120 23 Oct 2013 Fixed
15.7 SP120 21 Oct 2013 Fixed
15.7 SP120 21 Oct 2013 Fixed
15.7 SP120 21 Oct 2013 Fixed
Description
ODBC Driver by Sybase: In Microsoft Query applications, adding a table with a unique index fails with General ODBC error.





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