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