Sybase数据库技术,数据库恢复 » SAP ASE/IQ/RS/SDK/SQL Anywhere/PB的BUG信息

随着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:766748

CR Number:	766748
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP130		14 Jul 2014	Fixed

15.7 SP130		08 Jul 2014	Fixed

Description

ODBC Driver by Sybase: Unexpected changes to Float values converted to string, displays excess precision

Workaround Description

WorkAround:

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

Use older ASE ODBC Driver (15.7 GA or prior)

CR:767041

CR Number:	767041
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows Vista
Original Version:	15.7 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP130		22 Jul 2014	Fixed

Description

ODBC Driver by Sybase: Calling SQLTables API against an ASE server with older ODBC MDA scripts may result in "Table qualifier must be name of current database" error.

CR:767146

CR Number:	767146
Product Name:	ADO.NET Data Provider
Product Component:	ADO.NET Data Provider

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP123

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP140		04 Aug 2014	Fixed

Description

ADO.NET: AseDataReader throws exception when using CommandBehavior.SchemaOnly

Workaround Description

WorkAround:

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

There is no workaround available - other than manually modifying the query to not use subquery.

This means coder has to write code in their application to parse out the subquery/join portion.

CR:767147

CR Number:	767147
Product Name:	ADO.NET Data Provider
Product Component:	ADO.NET Data Provider

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	16.0 sp01

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
16.0 sp01		04 Aug 2014	Fixed

Description

Internal Only:
use setfmtonly on for returning schema information rather tahn appending where 1=2 to the sql statement

CR:767230

CR Number:	767230
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	15.7 ESD#1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		16 Sep 2014	Fixed

		15 Sep 2014	Fixed

		15 Sep 2014	Fixed

		16 Sep 2014	Fixed

		16 Sep 2014	Fixed

		16 Sep 2014	Fixed

		16 Sep 2014	Fixed

Description

jConnect: In version 7.07, a java.sql.Date object constructed without zeroing the hours, minutes, seconds and milliseconds components will retain the time component when inserted to a datetime column. Previous jConnect versions did not retain the time component.

Workaround Description

Set these connection prooperties:

HOMOGENEOUS_BATCH=false

SUPPRESS_PARAM_FORMAT=false

CR:767291

CR Number:	767291
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	Unknown
Original Version:	7.07 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		18 Aug 2014	Fixed

		18 Aug 2014	Fixed

Description

jConnect: Request to improve performance of "LITERAL_PARAMS=true" option for PreparedStatement execution with Text columns.

CR:767517

CR Number:	767517
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	7.07 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		17 Nov 2014	Fixed

		07 Jan 2015	Fixed

Description

jConnect: Unicode value insertion in a text column of a SAP ASE database can throw an SQL exception with wrong message of "Operand type clash: VARBINARY is incompatible with TEXT" when DYNAMIC_PREPARE is set to false and LITERAL_PARAMS is set to true. Moreover, by sending Unicode values as binary, ASE was not performing byte swapping, so if target ASE is on little endian platforms (Linux or Windows), then the column values were being corrupted.

CR:767784

CR Number:	767784
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	15.7 SP131

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		05 Aug 2014	Fixed

Description

ODBC Driver by Sybase: Table names larger that 64 characters are truncated.

CR:768185

CR Number:	768185
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		13 Aug 2014	Fixed

Description

ODBC Driver by Sybase: When using offset bindings and scrollable cursors the driver may crash.

Workaround Description

WorkAround:

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

None found for Windows 2012.

CR:768309

CR Number:	768309
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	7.07 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		28 Aug 2014	Fixed

		28 Aug 2014	Fixed

Description

jConnect: When ENABLE_BULK_LOAD is enabled, NULL values cannot be inserted in NULL column which is compressed.

CR:768315

CR Number:	768315
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	7.07 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		26 Aug 2014	Fixed

		25 Aug 2014	Fixed

Description

jConnect: Setting parameter values using Parameter name for Callable statement results in SQLException.

CR:768473

CR Number:	768473
Product Name:	Open Client
Product Component:	ctlib

Status:	Open
OS:	all
Original Version:	To Be Determined

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		25 Aug 2014	Fixed

Description

CTLIB: Correct data race condition with ct_cancel.

CR:768912

CR Number:	768912
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	AIX
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		09 Sep 2014	Fixed

Description

ODBC Driver by Sybase: The ODBC driver reports "Attempting to read past EOM" when executing a prepared statement with SELECT query that returns an error or warning for the first row. This error occurs only if SuppressRowFormat connection property set to true, which is the default setting.

CR:769170

CR Number:	769170
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		28 Aug 2014	Fixed

15.7 SP131		28 Aug 2014	Fixed

Description

ODBC Driver By Sybase: SQLDescribeParam call returns errors on certain sql and causes PowerBuilder application to take an undesirable code-path.

Workaround Description

WorkAround:

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

Customer uses OEM driver which instead of sending dynamic SQL on the SQLDescribeParam call it sends literal parameter values.

DataDirect (OEM) driver returns a message that it doesn't support the SQLDescribeParam call so the PowerBuilder interface is interpretting this and returning the message:

DarkRoom_GA a90-1594 EXIT SQLDescribeParam with return code -1 (SQL_ERROR)

HSTMT 01561B70

UWORD 1

SWORD * 0x0012F0B8

SQLULEN * 0x0012F0C0

SWORD * 0x0012F090

SWORD * 0x0012F074

DIAG [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function (0)

LANGUAGE Token (0x21); variable length.

Length [4]: 447

Status [1]: UNUSED (0x00)

Text Length [0]: [446]

Text [446]: "Insert into camra_user.jpm_000 ( customer_number , customer_name , report_datetime , report_type , custodian_name , request_number , loaded_to_jpm_cust ) select convert ( varchar ( 10 ) , '0000000109' ) , convert ( varchar ( 50 ) , 'NeW' ) , convert ( datetime , '20140609 12:00:00AM' ) , convert ( char ( 1 ) , 'C' ) , convert ( varchar ( 40 ) , 'JPMorgan Chase Bank, N.A. ' ) , convert ( int , 0 ) , convert ( char ( 1 ) , 'N' ) "

CR:769411

CR Number:	769411
Product Name:	Open Server
Product Component:	srvlib

Status:	Closed
OS:	all
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP130		19 Aug 2014	Fixed

Description

Build and release Open Server 15.7 SP130.

CR:769479

CR Number:	769479
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows XP
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
16.0 GA PL05		12 Nov 2014	Fixed

Description

ODBC Driver by Sybase: SQLGetData() may get a wrong data after setting a row position in the result set by SQLSetPos() and UserCursor Connection property is set to 0. A 30088 error with the message "Attempt to read past the end of the result set." may occur in the end.

Workaround Description

Turn on UseCursor

CR:769568

CR Number:	769568
Product Name:	Open Client
Product Component:	ctlib

Status:	Open
OS:	all
Original Version:	To Be Determined

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		13 Oct 2014	Fixed

Description

CTLIB: Correct SEGV issue when CS_FORCE_CLOSE is used.

CR:769623

CR Number:	769623
Product Name:	OpenSwitch
Product Component:	OpenSwitch

Status:	Open
OS:	Generic
Original Version:	15.1

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)

Description

OpenSwitch Install Anywhere installer support.

CR:769869

CR Number:	769869
Product Name:	Organic OLE DB Provider
Product Component:	OLE DB Provider

Status:	Closed
OS:	Microsoft Windows 2000
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP140		17 Sep 2014	Fixed

Description

OLEDB Provider by SAP: New Provider String property called ReturnPrepareErrors has been added to return errors on a prepare call when set to 1. The default value is 0.

CR:769873

CR Number:	769873
Product Name:	Connectivity Utilities
Product Component:	bcp

Status:	Closed
OS:	NA
Original Version:	16.0

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		19 Sep 2014	Fixed

		19 Sep 2014	Fixed

Description

BLKLIB: If there is a trailing lob column that will fit in row, data will be transferred incorrectly to ASE.

CR:769885

CR Number:	769885
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Open
OS:	NA
Original Version:	7.07 SP120

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)

Description

Request to optimize the isClosed() test so the default query sent to verify the state of the connection is something other than the stored procedure call sp_mda(?, ?).

Workaround Description

WorkAround:

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

Customer is using IS_CLOSED_TEST with either select 1 or INTERNAL and it appears to resolve their ASE utilization issue.

CR:770117

CR Number:	770117
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		07 Oct 2014	Fixed

Description

ODBC Driver by Sybase: Passwords are exposed by Excel when specified as pwd in the connection string.

CR:770194

CR Number:	770194
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Oct 2014	Fixed

Description

ODBC Driver by Sybase: When retrieving time values as character data, a warning message for string truncation is returned even when there is enough buffer length allocated.

CR:770201

CR Number:	770201
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Red Hat Enterprise Linux
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		26 Sep 2014	Diagnostic Provided

Description

ODBC Driver by SAP:

CR:770240

CR Number:	770240
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Open
OS:	NA
Original Version:	To Be Determined

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		15 Oct 2014	Fixed

		15 Oct 2014	Fixed

Description

jConnect: Driver wrongly raises error "JZ0PC: The number and size of parameters in your query require widetable support......" when the number and or size of parameters in a prepared statement exceeds 65535 bytes.

CR:770308

CR Number:	770308
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Open
OS:	NA
Original Version:	16.0 sp03

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		09 Jan 2015	Fixed

Description

jConnect: Data values stored in ASE may differ from the values sent when LITERAL_PARAMS connection property is set to true and value sent includes a backslash followed by a newline character.

CR:770385

CR Number:	770385
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	7.07 SP110

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		18 Dec 2014	Fixed

		18 Dec 2014	Port Not Needed

Description

jConnect: Request to improve performance of "LITERAL_PARAMS=true" option for PreparedStatement execution with Text columns.

Workaround Description

Set "LITERAL_PARAMS" to "FALSE"

CR:770401

CR Number:	770401
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Open
OS:	NA
Original Version:	To Be Determined

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)

Description

jConnect: SybConnection.getMetaData().getImportedKeys(String catalog, String schema, String table) method throws SQLException when table name is more than 30 characters.

CR:770405

CR Number:	770405
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	16.0

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
16.0 sp01		24 Sep 2014	Fixed

Description

ODBC Driver by Sybase: A small memory leak detected during ODBC connection open sequence.

CR:770585

CR Number:	770585
Product Name:	Organic ODBC Driver
Product Component:	TDS Library

Status:	Closed
OS:	all
Original Version:	16.0

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP131		19 Sep 2014	Fixed

16.0		15 Sep 2014	Fixed

16.0		18 Sep 2014	Fixed

16.0		18 Sep 2014	Fixed

16.0		19 Sep 2014	Fixed

Description

ODBC driver by SAP : Support the Certicom FIPS provider on AIX

CR:770861

CR Number:	770861
Product Name:	ADO.NET Data Provider
Product Component:	ADO.NET Data Provider

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Oct 2014	Fixed

		10 Oct 2014	Fixed

Description

ADO.NET: Unsupported charset Exception is thrown when using charset sjis.

Workaround Description

WorkAround:

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

Customer using 12.5 version - confirming exact release. I've gone back to 15.5 ESD09 and fails same way.

Also, possible cp932 might work.

CR:770865

CR Number:	770865
Product Name:	OCS Extension module for Python
Product Component:	sypydb

Status:	Closed
OS:	Linux
Original Version:	16.0

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		25 Nov 2014	Fixed

		11 Dec 2014	Fixed

		10 Dec 2014	Fixed

		11 Dec 2014	Fixed

Description

CTLIB: ct_results failed to report a CS_CMD_FAIL for errors in dynamic sql

PYTHON: Errors in parametrized commands were not correctly detected and the exception was raised too late.

CR:770925

CR Number:	770925
Product Name:	Open Client
Product Component:	ctlib

Status:	Closed
OS:	AIX
Original Version:	16.0 sp01

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		17 Dec 2014	Work as design

Description

AIX platform hits An Illegal Value of 4096 with no scroll insensitive cursor parameter called.

CR:770986

CR Number:	770986
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows XP
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP140		03 Oct 2014	Workaround

		27 Oct 2014	Fixed

Description

ODBC Driver by Sybase: Microsoft Excel VBA macro using DAO with ASE ODBC Driver connects to Adaptive Server every time the macro runs without closing the existing connections.

CR:771219

CR Number:	771219
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	Unknown
Original Version:	15.7 SP131

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		03 Oct 2014	Fixed

		10 Nov 2014	Fixed

Description

jConnect: The jConnect driver incorrectly retains time values in a java.sql.Date object or date values in java.sql.Time object if these objects are initialized with some values in those fields.

CR:772211

CR Number:	772211
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	16.0 sp01

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Nov 2014	Fixed

16.0		05 Nov 2014	Fixed

Description

ODBC Driver by Sybase: ODBC Driver crashes if a statement executing asynchronous statement is freed.

CR:772564

CR Number:	772564
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
16.0 sp01		10 Nov 2014	Fixed

16.0 sp01		10 Nov 2014	Fixed

Description

ODBC Driver by Sybase: SQLGetFunctions needs to be implemented in the driver.

Workaround Description

Customer continues to use OEM - but they are migrating to x64 platform in Windows and require to use ASE ODBC Driver.

CR:772750

CR Number:	772750
Product Name:	OCS Extension module for Python
Product Component:	sypydb

Status:	Closed
OS:	Linux
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		09 Dec 2014	Fixed

		11 Dec 2014	Fixed

Description

SYBPYDB: rowxfer on a blkcursor failed for numeric columns.

Workaround Description

WorkAround:

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

Only thing I can think of is to change ASE datatype to decimal

CR:772911

CR Number:	772911
Product Name:	Open Client
Product Component:	ctlib

Status:	Closed
OS:	Solaris
Original Version:	16.0

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		20 Nov 2014	Fixed

		28 Nov 2014	Fixed

Description

CTLIB: Connection failure due to incorrect login may result in core dump at comn_malloc().

Workaround Description

WorkAround:

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

SDK 15.7 doesn't have this problem.

CR:772977

CR Number:	772977
Product Name:	ADO.NET Data Provider
Product Component:	ADO.NET Data Provider

Status:	Closed
OS:	Microsoft Windows 2008
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
15.7 SP133		13 Nov 2014	Fixed

Description

ADO.NET : The driver would return a TDS stream error while processing some queries with compute clauses.

Workaround Description

WorkAround:

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

None at this time other than to do the computes separately

CR:773013

CR Number:	773013
Product Name:	jConnect
Product Component:	JDBC Driver

Status:	Closed
OS:	NA
Original Version:	7.07 SP110

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Nov 2014	Fixed

		10 Nov 2014	Fixed

Description

jConnect: Use of batching (addBatch/executeBatch) for CallableStatement with large number of parameters could cause a hang or BatchUpdateException.

Workaround Description

WorkAround:

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

LITERAL_PARAMS=true seems to be working

CR:773281

CR Number:	773281
Product Name:	Open Client
Product Component:	blklib

Status:	Closed
OS:	all
Original Version:	15.7 SP131

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		30 Oct 2014	Fixed

		30 Oct 2014	Fixed

		05 Dec 2014	Fixed

		12 Dec 2014	Fixed

		01 Nov 2014	Fixed

		03 Nov 2014	Fixed

Description

BLKLIB: blklib can send ASE incorrect offset entry(s) in the offset table from blklib for trailing LOB cols.

CR:773688

CR Number:	773688
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Closed
OS:	all
Original Version:	corona

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Dec 2014	Fixed

corona		29 Dec 2014	Fixed

		02 Jan 2015	Fixed

Description

ODBC Driver by Sybase: ODBC Driver fails to create a connection to deactivated primary server when DRNoKillDuringDeactivation connection property is set to 1.

CR:775118

CR Number:	775118
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Open
OS:	all
Original Version:	corona

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Dec 2014	Fixed

Description

ODBC Driver by Sybase: ODBC Driver does not return correct error when failover happens from primary to secondary HADR server.

CR:775320

CR Number:	775320
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

- Sybase ASE ODBC Driver for Linux:

[oracle@stbdoracle01 bin]$ ./odbcversion -fullversion

Sybase ASE ODBC Driver/15.7.0/ESD#1/P/x86_64/Linux/drvmain/Build 104/64-bit/Normal/Sat Jan 28 UTC 04:19:45 2012

[oracle@stbdoracle01 bin]$ ./odbcversion -version

15.7.0.104

- ASE 15.7

- Oracle Database Link 11.2g

- OS: Linux Red Had 64-bit Linux stbdoracle01.tjpe.gov.br 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux

Customer is trying to configure Oracle Database Link with our ODBC driver and he is getting these errors:

Failed to load ODBC library symbol:

/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so(SQLGetFunctions)

Log below:

Oracle Corporation --- MONDAY NOV 24 2014 17:09:49.543

Heterogeneous Agent Release

11.2.0.2.0

Oracle Corporation --- MONDAY NOV 24 2014 17:09:49.542

Version 11.2.0.2.0

Entered hgogprd

HOSGIP for "HS_FDS_TRACE_LEVEL" returned "255"

Entered hgosdip

setting HS_OPEN_CURSORS to default of 50

setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"

setting HS_FDS_RECOVERY_PWD to default value

setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG

setting HS_IDLE_TIMEOUT to default of 0

setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"

setting HS_NLS_NCHAR to default of "AL32UTF8"

setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"

setting HS_FDS_DATE_MAPPING to default of "DATE"

setting HS_RPC_FETCH_REBLOCKING to default of "ON"

setting HS_FDS_FETCH_ROWS to default of "100"

setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"

setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"

setting HS_FDS_PROC_IS_FUNC to default of "FALSE"

setting HS_FDS_MAP_NCHAR to default of "TRUE"

setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"

setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"

setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"

setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"

setting HS_FDS_QUERY_DRIVER to default of "TRUE"

setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"

Parameter HS_FDS_QUOTE_IDENTIFIER is not set

setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"

setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"

setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"

HOSGIP returned value of "32" for HS_FDS_SQLLEN_INTERPRETATION

setting HS_CALL_NAME_ISP to

"gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;g

tw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"

setting HS_FDS_DELAYED_OPEN to default of "TRUE"

setting HS_FDS_WORKAROUNDS to default of "0"

Exiting hgosdip, rc=0

ORACLE_SID is "TJPEFIN"

Product-Info:

Port Rls/Upd:2/0 PrdStat:0

Agent:Oracle Database Gateway for ODBC

Facility:hsa

Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:TJPEFIN

Exiting hgogprd, rc=0

hostmstr: 0: HOA After hoagprd

hostmstr: 0: HOA Before hoainit

Entered hgoinit

HOCXU_COMP_CSET=1

HOCXU_DRV_CSET=178

HOCXU_DRV_NCHAR=873

HOCXU_DB_CSET=178

HS_LANGUAGE is AMERICAN_AMERICA.UTF-8

LANG=en_US.UTF-8

HOCXU_SEM_VER=112000

Entered hgolofn at 2014/11/24-17:09:49

HOSGIP for "HS_FDS_SHAREABLE_NAME" returned

"/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so"

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLAllocHandle

symbol_peflctx=0xaaca8510

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLBindCol

symbol_peflctx=0xaaca47f0

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLBindParameter

symbol_peflctx=0xaaca5500

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLCancel

symbol_peflctx=0xaaca5860

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLDescribeParam

symbol_peflctx=0xaac8fdf0

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLDisconnect

symbol_peflctx=0xaaca7280

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLEndTran

symbol_peflctx=0xaaca5a80

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLExecute

symbol_peflctx=0xaaca4d30

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLFetch

symbol_peflctx=0xaaca4ae0

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLFreeHandle

symbol_peflctx=0xaaca9110

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLFreeStmt

symbol_peflctx=0xaaca4290

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLGetData

symbol_peflctx=0xaac8c760

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLGetEnvAttr

symbol_peflctx=0xaaca6b20

hoaerr:0

Exiting hgolofns at 2014/11/24-17:09:49

Entered hgolofns at 2014/11/24-17:09:49

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLGetFunctions

peflerr=6521,

libname=/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so,

funcname=SQLGetFunctions

hoaerr:28500

Exiting hgolofns at 2014/11/24-17:09:49

Failed to load ODBC library symbol:

/u01/sybase/DataAccess64/ODBC/lib/libsybdrvodb.so(SQLGetFunctions)

Exiting hgolofn, rc=28500 at 2014/11/24-17:09:49

Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:417

FUNCTION:hgoinit() ID:Loading ODBC aray of function ptrs

hostmstr: 0: HOA After hoainit

RPC Calling nscontrol(0), rc=0

hostmstr: 0: RPC Before Exit Agent

hostmstr: 0: HOA Before hoaexit

Entered hgoexit

HS Gateway: NULL connection context at exit

Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110

FUNCTION:hgoexit() ID:Connection context

hostmstr: 0: HOA After hoaexit

hostmstr: 0: RPC After Exit Agent

CR:775393

CR Number:	775393
Product Name:	Organic ODBC Driver
Product Component:	ODBC Driver

Status:	Open
OS:	all
Original Version:	corona

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)
		10 Dec 2014	Fixed

Description

ODBC Driver by Sybase: ASE ODBC Driver does not account RetryDelay value in seconds.

CR:775560

CR Number:	775560
Product Name:	Open Client
Product Component:	dblib

Status:	Open
OS:	Linux
Original Version:	15.7 SP130

Fixed Version	Build	Resolution Date	Closure Code (If Appropriate)

Description

When calling DBDEAD on a killed ASE spid, after dbpoll() is called, the process status returns false and the dbproc is not dead as expected.

Workaround Description

WorkAround:

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

Customer can kill app and restart but inconvenient - it's an application, single connection to ASE.

Without retry someone had to manually intervene to get the application reconnected.

--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB：

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

适用于所有的SQL Anywhere版本包括：5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
适用于所有的UltraLite版本
能够恢复出来表结构和数据
能够恢复自定义数据类型
能够恢复存储过程等对象的语法
能够导出到目标数据库
能够导出到SQL文件并生成导入脚本
支持多种字符集，包括：cp850、cp936、gb18030、utf8等
能够恢复未加密或者简单加密类型的数据
简单易用
限制：不支持AES加密的数据文件

请参考：研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作：

误截断表(truncate table)
误删除表(drop table)
错误的where条件误删数据
误删除db或log文件
误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景：

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back

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

Sybase ASE数据库恢复工具READSYBDEVICE：

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具！
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能：

被勒索病毒加密数据文件及备份文件情况下的恢复；
系统崩溃只剩下数据文件的情况下的恢复，甚至数据库文件不存在而只有损坏的备份文件情况下的恢复；
因断电、硬盘坏道等造成数据库文件损坏情况下的恢复；
delete数据恢复、误update数据恢复、误删除表(drop）恢复、误truncate表恢复等；
各种Sybase内部系统表损坏、索引错误的修复；
master数据库损坏而无法正常运行情况下的恢复；
Sybase数据库被标记为可疑，不可用等情况的恢复；
Sybase数据库中数据文件内部出现坏块情况下的恢复；
Sybase数据库无数据文件但有日志文件的情况下的恢复；
Sybase数据库只有数据文件无任何日志文件的情况下的恢复；
Sybase数据文件被误删除情况下的碎片提取恢复；
磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复；
数据库sysobjects等系统表损坏无法正常应用情况下的恢复；
Sybase数据库还原数据库出现失败情况下的恢复；
Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本：

Sybase ASE 11.0.x，11.5.x，11.9.x，12.0.x，12.5.x，15.0.x，15.5.x，15.7.x，16.0.x

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

SQL Server数据库恢复工具SQLRescue：

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具！
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能：

系统崩溃只剩下数据文件的情况下的恢复，即无日志文件或者日志文件损坏情况下的恢复；
断电导致数据库文件损坏情况下的恢复；
硬盘坏道造成数据库损坏情况下的恢复；
数据文件内部存在坏页情况下的恢复；
企业管理器误删除数据表记录，管理软件误删除数据表记录的恢复；
并闩锁错误、格式化、误删除后导致软件不能使用的情况；
无法读取并闩锁页sysindexes失败情况下的修复；
数据文件被误删除情况下的碎片提取恢复；
系统表损坏、索引错误、误删除数据库表、删除记录的数据找回；
master数据库损坏而无法正常运行情况下的恢复；
数据文件无法附加情况下的数据恢复；
数据库被标记为可疑，质疑，不可用等情况的恢复；
数据库sysobjects等系统表损坏情况下的恢复；
数据被误(drop、delete、truncate）删除表数据的恢复,误update后的数据恢复等；
还原时报一致性错误，错误823等情况下的数据恢复，各种错误提示的数据库文件修复；
数据库被误格式化等情况下的数据库恢复；
日志收缩造成数据库损坏情况下的恢复；
仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点：

只要SQL Server数据库的数据文件存在，我们就有办法帮您从数据文件中找回重要数据。

从数据文件中直接恢复数据
不能附加时直接恢复数据并生成新的数据库
系统表损坏的数据库修复
快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本：

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------