远程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:484055
CR Number:   484055
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 06 Dec 2007 Fixed
15.0 23 Jan 2008 Fixed
Description
In rare circumstances, a complex query involving many derived tables and virtual

columns could cause server failure in dfo::DFEMightBeNullHere().



CR:484204
CR Number:   484204
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 11 Dec 2007 Fixed
Description
The DDL version for the ADO.NET 2.0 driver shipped with Sybase IQ 12.7 ESD #3

for Windows did not match the IQ build version. This issue has been resolved.



CR:484268
CR Number:   484268
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2009 Fixed
11 Sep 2009 Fixed
15.2 02 Feb 2010 Fixed
Description
Sqllog should log complete sql and not limit it to 32K



The whole query text is now logged in the request log as compared to current limit of 32k.

If the output of logging is directed to server log/console then only 32k size of query text will be logged.

Stored procedure sa_get_request_times will truncate the request log record to 64k size.



CR:484702
CR Number:   484702
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2008 Fixed
12.7 e04 01 Feb 2008 Fixed
12.7 e04 29 Feb 2008 Fixed
12.7 e04 17 Mar 2008 Added to user documentation
15.0 14 Aug 2008 Fixed
15.2 08 Mar 2010 Added to user documentation
Description
The IQ server supports TDS password encryption when clients with this capability connect. However, clients shipped with Sybase IQ 12.7 do not support TDS password encryption. In order to use this feature, you must use Open Client 15.0 ESD #7 or later.



CR:484711
CR Number:   484711
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Solaris
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add functionality of IGNORE_DUP_KEY in IQ



CR:484934
CR Number:   484934
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to allow set option Temp_extract_NameN to have value larger than 127 characters.



CR:485021
CR Number:   485021
Product Name:   Sybase IQ ETL
Product Component:   Installer
Status:   Open
OS:   Windows 2003
Original Version:   4.2.1 EBF #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Failed
16 May 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: The install and readme packaged with the product make reference to 揈TL Development 4.2.1 ESD#1.

Workaround: Ignore the references to ESD#1 it should read ESD #2.



CR:485022
CR Number:   485022
Product Name:   Sybase IQ ETL
Product Component:   Installer
Status:   Closed
OS:   Linux Red Hat
Original Version:   4.2.1 EBF #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2009 Fixed
Description
Problem: The uninstall script for Linux does not remove the products.

Workaround: The user can delete the installation from the install directory manually.



CR:485316
CR Number:   485316
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 25 Apr 2008 Fixed
Description
When explicitly inserting values to the DEFAULT AUTOINCREMENT/IDENTITY column of a table is allowed, the "Tried to insert a duplicate value into a unique index" error will occur, if the user:

1. inserted N (an integer or an exact numeric type with scale 0) to the DEFAULT AUTOINCREMENT/IDENTITY column, and

2. inserted N-1 to the DEFAULT AUTOINCREMENT/IDENTITY column, and

3. tries to insert a value to another column of the table.



CR:485470
CR Number:   485470
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 20 Feb 2008 Fixed
Description
When connecting to ASE or Microsoft SQL Server, the Remote Data Access layer was setting the QUOTED_IDENTIFIER option to ON at connect time, thus always quoting identifiers when querying data from ASE or SQL Server. Due to a restriction in the ASE server, always using quoted identifiers caused issues if the column name was 29 or 30 characters in length. Now, when connecting to ASE or SQL Server remote servers, the QUOTED_IDENTIFIER option on the remote server is set to match the local setting.



CR:485609
CR Number:   485609
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 11 May 2008 Fixed
Description
A query server may become unresponsive during multi-user tests and some multiplex

verification tests. This has been fixed.



CR:485692
CR Number:   485692
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Solaris
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer request (Infoco N.V.)enhancement request for the AUDITING option to include userid / connection id information in the audit record created

i.e. who is associated with the failed event being audited



CR:485694
CR Number:   485694
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request: Implement COUNT_BIG function for compatibility with MS Link Server



CR:485741
CR Number:   485741
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 07 May 2008 Fixed
15.0 15 Dec 2008 DEFER
20 Nov 2009 Fixed
Description
The current mechanism of generating query plans depends on a user connection to get the query text. Operations like event handling and triggers are connectionless, and

with this fix, the query plan displays a more meaningful message "Statement text unavailable".



CR:485910
CR Number:   485910
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.6 e08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request: An error or warning when implicit conversion a numeric data into an integer.



CR:486216
CR Number:   486216
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 3 13 Apr 2008 Fixed
12.7 e05 3 04 Jun 2008 Fixed
Description
In the sql that follows, no rows are returned from "select * from #temp_t1".



select * into #temp_t1 from sp_iqstatus();

select * from #temp_t1;



This is incorrect and rows will be returned in 12.7 esd5.



CR:486261
CR Number:   486261
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2013 Presently Not Targeted For Any Future Release Of This Product
Description
nogui dbisql does not display the notification message of login procedure.



CR:486491
CR Number:   486491
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e10.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 19 May 2008 Fixed
12.6 e11 12 Aug 2008 Fixed
Description
A LOAD TABLE could possibly cause the server to stop processing, if the LOAD allocated more threads for processing than the number of indexes in the table. This problem rarely occurs.
Workaround Description
 Eng suggested to set fixed number of threads ( index count + 1) to prevent

over allocated threads in loading.

But this work-around cuased performance degradation bacause load peration goes

single threads mode ( slow mode ). Due to it, customer doesn't accept to apply

the suggested W/R.



CR:486663
CR Number:   486663
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 23 Jan 2008 Fixed
Description
Installing Linux 32-bit version of Sybase IQ on a Linux 64-bit system now selects the correct version of the SDK, when an ESD includes the SDK.



CR:487341
CR Number:   487341
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 06 Nov 2008 Fixed
12.7 e04 12 Mar 2008 Fixed
12.7 e06 14 Nov 2008 Fixed
Description
On certain Sun Sparc machines, scjview fails to load libdbput9_r.so file, even though the

file is available with proper permissions in lib directory.
Workaround Description
 rather than providing the db engine server name in the connection dialog, use host:port#.



CR:487417
CR Number:   487417
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 07 Jan 2008 Fixed
Description
A lock table attempt may give a different error from previous Sybase IQ versions. A simple sequence to illustrate the problem is

user1:

create table t1;

lock table t1 in shared mode;

user2: (who does not have select permission to user1.t1)

lock table user1.t1 in exclusive mode;



The lock table attempt by user2 used to report error "Permission denied: you do not have permission to alter t1.". In 12.7 ESD #4 and later, the lock attempt now returns error "User 'user1' has the row in 't1' locked."



CR:487710
CR Number:   487710
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to allow CONSTANT in the ORDER BY clause in the OLAP window.



CR:487746
CR Number:   487746
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When 'group by' is used by subquery in view, NULL attribute of column is reset.



CR:487747
CR Number:   487747
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When 'group by' is used by subquery in view, NULL attribute of column is reset.



CR:487748
CR Number:   487748
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When 'group by' is used by subquery in view, NULL attribute of column is reset.



CR:487749
CR Number:   487749
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   HP-UX
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When 'group by' is used by subquery in view, NULL attribute of column is reset.



CR:488335
CR Number:   488335
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 24 Jan 2008 Fixed
15.0 24 Jan 2008 Fixed
Description
A select with a scalar value subquery in the SELECT list causes server failure when a TOP qualifier or ROWCOUNT option is set with an ORDER BY clause, where the first entry is also an outer reference in the subquery.
Workaround Description
 Use dml_options2=8388608. There may be some modest performance impact.



CR:488546
CR Number:   488546
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 25 Jun 2008 Fixed
Description
IQ 12.7 server fails, when closing cursor.



CR:488964
CR Number:   488964
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 09 May 2008 Fixed
Description
Running the following commands using ISQL will cause tds protocol error:



create table test_table (c1 int);

go

insert into test_table values (1);

go

alter table test_table add c2 bit not null default 0;

go

select * from test_table;

go



The error is:



CT-LIBRARY error:

ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received.
Workaround Description
 Do not use isql for such alter commands. Use dbisql



CR:489037
CR Number:   489037
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2003
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
Description
IQ is downed without error message and stacktrace when a query including sum and group is executed.



===Fix by Engineering=== ( Imran )



IQ server crashed on "Group by" while costing was calculated as security_code_cookie check was inserted by MS VC for windows 64 bit platform. Care has been taken security cookie is not set any more for this function.



CR:489069
CR Number:   489069
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2009 Fixed
12.7 e06 17 Nov 2008 Fixed
Description
BuildClient Name displaying internal build name on windows



CR:489234
CR Number:   489234
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e09 11 Oct 2009 Fixed
Description
Selecting from a view involving an outer join may cause an "An illegal token received"

error. This has been fixed.



CR:489327
CR Number:   489327
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2008 Presently Not Targeted For Any Future Release Of This Product
Description
writer dbremote keeps sending messages to an excluded query server



CR:489624
CR Number:   489624
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2000
Original Version:   12.6 e09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When sp includes output parameter, execute immediate command fail. execute iimediate returns error of -946.
Workaround Description
 As a work around can you can use just any 'select statement' after the call to the procedure.



eg.

BEGIN

DECLARE OUT1 VARCHAR(128);

CALL sp_immediate(OUT1);

SELECT 1234 from dummy;

END



Or there are other known obvious options like

1. doing select into <out_param> instead of assigning value to varable using SET

2. Using the result clause

3. Using cursors.



CR:489674
CR Number:   489674
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04.x 05 Jun 2008 Fixed
12.7 e05 19 Jun 2008 Fixed
15.0 14 Oct 2008 Fixed
Description
A server failure may result from memory corruption.



CR:490076
CR Number:   490076
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 31 Oct 2008 Fixed
12.7 e06 17 Feb 2009 Fixed
Description
A query involving a subquery may return incorrect results with a join index present.
Workaround Description
 Try to add additional column to join index and also see if the left and right tables can be interchanged.



CR:490477
CR Number:   490477
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
load table consistent messages when field that exceeded the limit of a column



CR:490478
CR Number:   490478
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
enhance "load table" for putting problematic data in one of the diagnostic files



CR:490480
CR Number:   490480
Product Name:   IQ
Product Component:   Sybase Central
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 12.7 esd #3 , plugin 12.7.070907 gives error Invalid column index value 15 when using iAnywhere driver



CR:490797
CR Number:   490797
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 20 May 2008 Fixed
15.0 14 Oct 2008 Fixed
Description
Load was generating wrong identity values if extract column delimiter in the last row.

Now identity values are generating correctly.



CR:490818
CR Number:   490818
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 07 Nov 2008 Fixed
12.7 e06 10 Nov 2008 Fixed
Description
If the constant 0.0 (one decimal separator and all digits zero) is used in the target

list of a select INTO <permanent_table> statement, the statement fails with the

"Syntax error near '0' on line 1".
Workaround Description
 1) use CAST() or CONVERT() function, for example:



select dummy_col,CAST(0.00 as float(4)) as f_value into #S2 from iq_dummy;



OR



2) Use expression instead of constant, for example

select dummy_col, (0.00 * 1) as f_value into #S2 from iq_dummy;



CR:491041
CR Number:   491041
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2003
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04.x 16 Apr 2008 Fixed
Description
Using a signed value for array indexing may lead to a negative index due to bad code optimization on Windows x64. This has been fixed.



CR:491070
CR Number:   491070
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 19 Aug 2008 Fixed
12.7 e06 19 Nov 2008 Fixed
12.6 e11 05 Sep 2008 Fixed
15 Oct 2008 Fixed
Description
Derived table and proxy table give wrong correlation name.



CR:491377
CR Number:   491377
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2008 Duplicate
Description
document how to calculate resources needed for a split group by



CR:491480
CR Number:   491480
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04.x 05 Jun 2008 Duplicate
01 Feb 2010 Consult Complete
Description
The server may fail at s_buf.cxx:1534. This failure should not occur under normal circumstances. It has happened very rarely. In order to help determine the cause, in the event of a failure, diagnostics will be output to the iqmsg file.



CR:491483
CR Number:   491483
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
12.7 e10 18 Mar 2010 Added to user documentation
Description
The allowed value of the MAX_QUERY_PARALLELISM option is an integer less than, greater

than or equal to number of CPUs. When MAX_QUERY_PARALLELISM is set, the number of parallel

arms in a UNION GROUP BY can be greater than the number of CPUs.



CR:491609
CR Number:   491609
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04.x 30 Apr 2008 Fixed
12.7 e04.x 07 Mar 2008 Fixed
Description
Queries of type

select count(*) from ... where (((... is null) or (... in ...)) and ...)

may cause the IQ server to crash. This is due to an attempt to write to a

read-only bock map. In this case, a copy of the block map needs to be made

and used. This has been fixed.



CR:491748
CR Number:   491748
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 15 Jan 2009 Fixed
Description
Server fails at server.css:1192, signal 11 in hos_dfe_datetime_HOUR.

This problem occurred while estimating cost of a correlated sub-query. The fix resolves cost estimation issue and query now runs without error.



CR:491779
CR Number:   491779
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 12 Mar 2008 Fixed
Description
Silent install removes 12.4.3 install, but does not install 12.7 client



CR:491964
CR Number:   491964
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqcolumn does not include global temp table. sp_iqcolumn is made only for base table.
Workaround Description
 use sp_columns.



CR:491979
CR Number:   491979
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e04 17 Mar 2008 Fixed
12.7 e05 16 Jun 2008 Fixed
15.0 12 Jan 2009 Fixed
Description
On Windows 64-bit machines, running getiqinfo.bat gives the "asiqsrv12 is not running. Can not run stored procedures" error, and the subsequent 5 steps are missing.

What's needed is the x64 version of Psapi.lib to build findproc.cxx. This has been fixed.



CR:492077
CR Number:   492077
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SUBCASE NUMBER: 11409837-11

CUSTOMER NAME: RBC DOMINION SECURITIES

ASIQ Version: IQ 12.7 esd #3

PLATFORM and OPERATING SYSTEM: Solaris





BASIC INFORMATION:

Customer will like to have some means that will show table names and blocks usage in TEMP space store (like ASE).



CR:492374
CR Number:   492374
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbisql will not exit when connection is killed or onerror exit is used.



CR:492468
CR Number:   492468
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 09 Jul 2010 Fixed
12.7 e05 29 Jun 2008 Fixed
12.6 e11 26 Aug 2008 Fixed
12.7 e05 10 Jul 2008 Fixed
Description
IQ shut down with a fatal error because a call to pthread_mutex_destroy returned EBUSY.

As a part of fix we raised an exception string and report the value returned by the call to pthread_mutex_destroy , in this way, we are ignoring the EBUSY return .



CR:492507
CR Number:   492507
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Unknown
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 15 Jul 2009 Fixed
Description
On Windows, the FINDIQVER utility returned 32bit for a

64bit installation.



CR:492996
CR Number:   492996
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2009 Not a Bug
Description
The IDLE option is not included in Admin Script which Sybase Central generated. The dbremote connection started from script will be disconnected in default timeout of IQ. But the dbremote connection started from Sybase Central is not disconnected by timeout. Please modify script, if timeout is prevented. "idle#0" is added to a SQLCONNECT variable.
Workaround Description
 "idle#0" is added to a SQLCONNECT variable.



CR:493414
CR Number:   493414
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e09 18 Sep 2009 Not a Bug
Description
The bitwise operators are defined for integer and bit array

data types only. They are not defined for bit type. Because

of this, the input operand of the bit negation operation is

casted to integer first. After applying the bit negation, we

try to cast the resulting integer value to bit again, which

does not work.



CR:493441
CR Number:   493441
Product Name:   Sybase IQ ETL
Product Component:   ETL Connectivity
Status:   Closed
OS:   Windows XP
Original Version:   4.2.1 EBF #2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2008 Fixed
23 Jun 2008 Fixed
10 Jun 2008 Fixed
Description
A new keyword has been introduced for the

Default.ini file. The keyword is 'timeout'

and it belongs in the Network area of the

.ini file. The valid values for timeout

are specified in seconds in a range from

1 second to 2,147,483 seconds.



An extract of the Default.ini file contents

shows the appropriate syntax. For more

details on default.ini contents, refer to

the User's Guide.





==Begin snippet of default.ini======

# The timeout setting must be in the

# Network section. The beginning of the

# Network section is defined by the line below.



[Network]



timeout=3600

=End snippet of default.ini===========



Please note this timeout affects only

the ETL software acting as an ftp client.

This timeout value will not affect any

timeout setting that are defined on the

ftp server or enforced by the network at

the TCP layer.



CR:493563
CR Number:   493563
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 28 Apr 2008 Fixed
15.0 14 Oct 2008 Fixed
Description
SELECT COUNT (*) may return incorrect results in a UNION ALL view.
Workaround Description
 *** Monday, April 07, 2008 8:09:51 AM *** aldrich ***

set option dml_options4=1024; or set as temporary option.



CR:493567
CR Number:   493567
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows XP
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 19 Jun 2008 Added to user documentation
Description
row_number () is not supported in the current IQ version when used in OLAP context



CR:494004
CR Number:   494004
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2010 Added to user documentation
25 Feb 2010 Added to user documentation
Description
Adjusting FS cache on RH4 and RH5 to reduce performance problems



High FS cache on Red Hat 4 and Red Hat 5 impacts concurrent transactions on IQ 12.7.



FS-Cache is a kernel facility by which a network filesystem or other service can cache

data to improve performance. Because the current transaction version in IQ 12.7 is

released only after the FS cache is totally flushed to disk, a high FS cache can

impact concurrent transactions.



Reducing the vm.dirty_background_ratio and vm.dirty_ratio parameters increases the

number of flushes, but decreases the duration. Shorter flush times release the current

IQ version more quickly and reduce performance problems.



Note

-- Red Hat 4 has no configuration parameter to limit FS cache size. In Red Hat 4,

FS cache depends on machine memory.

-- With Red Hat 5, this should be worked around by enabling direct I/O on the OS

level to disable FS caching (not available in RH4).



CR:494230
CR Number:   494230
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Too Many UNION ALL requires time for creation of a query plan.
Workaround Description
 There is no workaround for the long time taken to gather the query plan. Once the query is established and working properly, don't request the query plan.



CR:494668
CR Number:   494668
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 09 Oct 2008 Fixed
15.0 09 Oct 2008 Fixed
Description
A query involving DISTINCT, GROUP BY, and ORDER BY that had a SQL error could return a confusing error. A correct error message is now returned.
Workaround Description
 The column set to be DISTINCT and ORDER BY is made the same.



CR:494972
CR Number:   494972
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 25 May 2008 Fixed
Description
The following SELECT executed against the asiqdemo database would cause the server to fail.



select * from (select top 2 cust_id = rowid(t) from sales_order)t;



CR:495183
CR Number:   495183
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ cannot execute the next SQL. It is ANSI. However, ASE can execute the same SQL. The customer expects that the T-SQL function of IQ nears ASE. 1. select distinct a from tab1 group by a,b order by a,b;2. select distinct a from tab1 order by a,b;



CR:497147
CR Number:   497147
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 12 Nov 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
Windowing query with multiple columns in "partition by" clause was returning incorrect results. This issue is fixed now and correct results are returned regardless the number of columns in the "partition by" clause.



CR:497149
CR Number:   497149
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 03 Nov 2008 Fixed
Other 24 Jul 2008 Fixed
12.7 e06 29 Jan 2009 Fixed
Description
Attempting to start a database with -iqro flag may fail to start with

a Sybase IQ Abort error.



CR:497725
CR Number:   497725
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   SunOS
Original Version:   12.7 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 30 May 2008 Fixed
15.0 09 Sep 2008 Fixed
12.7 e04.x 05 Jun 2008 Fixed
Description
Fetch from a hold cursor could return a wrong answer.

As an example (in pseudo code):

drop table xxx;

create table xxx( c1 int );

open curs1 { select * from xxx };

insert into xxx values(1);

open curs2 { select * from xxx };

insert into xxx values(2);

open curs3 { select * from xxx };

insert into xxx values(3);

open curs4 { select * from xxx };

commit;



print 'cursor1 ======'

loop {

fetch curs1 relative 1 into c1

if SQLCODE = SQLE_NOTFOUND then { break loop } endif

print 'c1 = ', c1

} endloop



print 'cursor2 ======'

loop {

fetch curs2 relative 1 into c1

if SQLCODE = SQLE_NOTFOUND then { break loop } endif

print 'c1 = ', c1

} endloop



print 'cursor3 ======'

loop {

fetch curs3 relative 1 into c1

if SQLCODE = SQLE_NOTFOUND then { break loop } endif

print 'c1 = ', c1

} endloop



print 'cursor4 ======'

loop {

fetch curs4 relative 1 into c1

if SQLCODE = SQLE_NOTFOUND then { break loop } endif

print 'c1 = ', c1

} endloop



When running the script, the following results are produced



cursor1 ======

cursor2 ======

c1 = 1

cursor3 ======

c1 = 1

cursor4 ======

c1 = 1

c1 = 2

c1 = 3



The results for cursors 1, 2, and 4 are correct. The results for cursor3

are incorrect. Cursor3 needs to see rows with values 1 and 2; not just 1.



CR:498713
CR Number:   498713
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.1 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 e01 4 26 Aug 2009 Added to user documentation
17 Jun 2009 Fixed
Description
In earlier versions of Sybase IQ, running the stored procedure sp_iqdbspaceinfo on the entire database generated an error if any dbspace in that database was offline. In Sybase IQ 15.1 esd 1 and later, no error is reported if a dbspace is offline.



The dbspace_online column was added to the output of the sp_iqdbspaceinfo stored procedure. A value of Y means that the dbspace is online and that the procedure returned data for that row. A value of N means that the dbspace is offline, meaning that the procedure was unable to return data for that row, and reports 0B (0 bytes) for those data values.



The dbspace_id column was added to the output of the sp_iqdbspaceobjectinfo stored procedure.



If you upgraded the server from a version earlier than 15.1 esd 1, you must run ALTER DATABASE UPGRADE on existing databases. If you do not upgrade the database, running the sp_iqdbspaceinfo stored procedure results in a 揚rocedure no longer valid error.



CR:498862
CR Number:   498862
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 4 26 May 2008 Fixed
Description
Database names are limited to 40 bytes when the limit should be 250. This issue has been resolved.



CR:498912
CR Number:   498912
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Unknown
Original Version:   12.7 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e07 17 Jun 2009 Fixed
15.1 e01 17 Jun 2009 Fixed
15.1 e01 24 Aug 2009 Fixed
Description
stop_iq and stop_asiq have a new parameter: -version. Use this parameter to find either 12.x IQ servers and agents, 15.x IQ servers and agents, or both. Default remains the same: stop_asiq finds 12.x servers by default, and stop_iq finds 15.x servers by default.



12.7 Usage: stop_asiq -version [12|15|all]

15.1 Usage: stop_iq -version [12|15|all]



CR:499172
CR Number:   499172
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows 2000
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When the multi-byte character which has '5c' in a remote table name is included, IQ cannot define correct remote_location.
Workaround Description
 Please create view with an English name. And please set view to be proxy table.



CR:499234
CR Number:   499234
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   SunOS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 e01 16 Mar 2009 Fixed
Description
In SCJ:Information regarding Referential integrity constraints and Constraints will now be visible in the corresponding tabs.



CR:499572
CR Number:   499572
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Utility to reset the DBA password in IQ catalog if the password is forgotten



CR:500305
CR Number:   500305
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
defncopy ( 5.0/P-EBF13575 ESD #4 ) from IQ 12.7 esd #4 exports stored procedure ddl incorrectly.



CR:523750
CR Number:   523750
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2009 Fixed
Description
IQ was getting an data type conversion error while trying to cast an empty string as double. The error was as follows - "Data exception - data type conversion is not possible". This error is fixed now.



CR:523752
CR Number:   523752
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 12.7 improve error message -1001006 ( Data exception - data type conversion)



CR:528319
CR Number:   528319
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.7 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2008 Fixed
12.7 e06 25 Nov 2008 Fixed
12.7 e06 15 Jul 2009 Fixed
15.0 04 Mar 2009 Fixed
Description
The server may fail in st_cursor::GetCursorDetailUtilityInfo -> hos_strncpy() when

multiple cursors are being opened and destroyed and information on cursors is being

collected by sp_iqcontext.



CR:528569
CR Number:   528569
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2009 Presently Not Targeted For Any Future Release Of This Product
Description
iq_bcp cannot copy data to a table with a lot of columns.



CR:529339
CR Number:   529339
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.7 e05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 20 May 2008 Added to user documentation
Description
Database names are limited to 40 bytes when the limit should be 250. This issue has been resolved.



CR:529798
CR Number:   529798
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 e01 06 Mar 2009 Fixed
Description
In SCJ: Create database wizard will not allow user to assign a server port, which is already in use.



CR:530012
CR Number:   530012
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e11 12 Aug 2008 Fixed
12.7 e05 22 Jun 2008 Fixed
15.0 24 Sep 2008 Fixed
12.7 e04.x 05 Jun 2008 Fixed
Description
The platform-dependent limit on maximum virtual address space has been removed for 64 bit platforms Windows64, IBM Linux, and Linux64 AMD.



CR:530468
CR Number:   530468
Product Name:   IQ
Product Component:   Sybase Central
Status:   Closed
OS:   Windows XP
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 20 Aug 2008 Fixed
12.7 e06 19 Dec 2008 Fixed
15.0 03 Mar 2009 Fixed
Description
Using Sybase Central, the Create Table statement produced by copying a Table definition with a primary key constraint could have incomplete SQL that would return a syntax error when executed. This has been corrected.



CR:530516
CR Number:   530516
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Unknown
Original Version:   12.7 future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer (LEHMAN BROTHERS INC on 12.7 on solaris) would like a utility similar to the UDB db2ckbkp utility which will enable them to verify that a IQ backup is valid and restorable.



CR:531097
CR Number:   531097
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 3648 10 Jul 2008 Fixed
12.7 e05 3648 06 Jun 2008 Fixed
15 Apr 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
If an Open Client or jConnect application executed a query that involved the use of host variables within a batch, then the server would have failed. This has been fixed so that the query now correctly fails with the error message "Host variables may not be used within a batch".



CR:531331
CR Number:   531331
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05 03 Jul 2008 Fixed
15.0 03 Jul 2008 Fixed
12.7 e05 23 Jul 2008 Fixed
15.0 16 Oct 2008 Fixed
05 Jun 2013 EOL'd version. Not to be Fixed.
Description
Unable to backup a database built on raw partitions on Linux if raw partition's sector size is 4096.



CR:531717
CR Number:   531717
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 19 Mar 2010 Fixed
12.7 e07 15 Oct 2008 Fixed
12.6 e11 15 Oct 2008 Fixed
Description
The Sybase IQ Utility Guide documentation for the Backup utility (dbbackup) is incomplete. The option -xo should not be used in multiplex systems and the Sybase IQ servers must be stopped when -xo is used.



CR:531757
CR Number:   531757
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2008 Insufficient priority to fix
Description
As a further enhancement to CR's 396843 and 499055 the customer would like to be able to use the new LOAD TABLE DEFAULTS ON option to do partial-width insertions in tables with an autoincrement without having to change the auoincrement column to allow nulls.



CR:531820
CR Number:   531820
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.7 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e06 05 Dec 2008 Fixed
12.7 e06 19 Dec 2008 Fixed
Description
In IQ versions 12.7esd4 and later, sp_password doesn't work correctly. Original sp_password syntax is 'sp_password caller password, new password, [userid]'. In case if 'SQL' is DBA's password, executing command as "sp_password 'DBA', 'abcd'", does not give the syntax error message and changes the DBA's password to new password without verifying the old one.
Workaround Description
 See sp_password source and check if password verification line is missing or not.

It should have following line



...

call dbo.sa_verify_password( isnull( @caller_pswd, '' ) )



In case of being missing above, re-create 'sp_password' procedure with right source from 'iqprocs.sql'.



CR:532151
CR Number:   532151
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   12.6 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 e04 17 Jun 2008 Fixed
12.7 e05 09 Sep 2008 Fixed
12.6 e11 09 Sep 2008 Fixed
Description
On HP-UX, when a client application connect to IQ and aborts the connection while IQ is in the process of accepting the connection, IQ's listener thread aborts and no further connections can be made.



CR:532396
CR Number:   532396
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has a process where they backup their dtabase and restore it with renames on a different location. There is currently no supplied way or utility to rename the .db catalog file. The way to do this is a simple OS rename of the file and change the IQ startup scripts to point to the new name. However the entry for the name of the .db file is still stored in the SYSFILE system table as the original file name so when you look at the dbspace info in SC you still see the old names. We need a utility or method of changing the name of the ctalog store cleanly and fully.



CR:532409
CR Number:   532409
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux
Original Version:   future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
customer is after a feature request in IQ similar to Database Resource Manger in Oracle where they can set up user groups that have for example the ability to be guaranteed resources allocations. E.g. usergroup1 gets 80% of the CPU and usergroup2 only 20%.



CR:533250
CR Number:   533250
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2008 EOL'd version. Not to be Fixed.
12.7 e05 14 Jul 2008 Fixed
12.7 e05 18 Jul 2008 Fixed
Description
If a TCP/IP connection attempts to connect to IQ and the connection attempt terminates before IQ completes its accept processing, the IQ thread dies and cannot be used again by the server. Existing connections continue to work correctly.



CR:533545
CR Number:   533545
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Solaris
Original Version:   2.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2008 Duplicate
12.7 e06 09 Jan 2009 Fixed
15.0 26 Jan 2009 Fixed
Description
Debugging a stored procedure from SC caused the iqmsg file to fill

rapidly with Txn-Cmt-PostCmt messages.



CR:533619
CR Number:   533619
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   12.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e09 05 Jan 2010 Fixed
Description
Backup allocates an array of 2048 byte buffers to use for backup. The array is sized to the number of threads participating in the backup and each thread will work one of the buffers in the array.



LINUX requires that the size of the transfer for read and write must be an integral multiple of the device's blocksize. For a disk, this is its sectorsize, which is normally 512 bytes. The other valid sectorsize values are 1024 and 2048. A blocksize of 4096 will not work.



You may use any of these values: 512, 1024 or 2048. Then, provided raw partitions are correctly setup, IQ backup and restore are successful.



CR:533695
CR Number:   533695
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   12.6 e10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e05.x 18 Aug 2008 Fixed
12.7 e06 18 Aug 2008 Fixed
12.7 e05.x 15 Jul 2009 Fixed
12.7 e06 16 Dec 2008 Fixed
15.0 30 Jan 2009 Fixed
Description
If dbbackup is started and cannot complete its task, an orphan transaction will be left on the server and no further checkpoints will occur until the server is restarted.



CR:533736
CR Number:   533736
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.7 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2008 Work as design
12.7 e10 16 Mar 2010 Fixed
Description
Upgrading databases may change system table definitions and certain features may be unavailable. Use ALTER DATABASE UPGRADE to upgrade databases, but for limitations, see SQL Anywhere 11.0.1 > SQL Anywhere Server - Database Administration > Administering Your Database > Database administration utilities > Upgrade utility (dbupgrad). Sybase IQ does not support the dbupgrad utility.



CR:533956
CR Number:   533956
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Windows XP
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.1 future 13 Jul 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
The IQ plugin is now registered for dbisql as part of the install.



CR:534171
CR Number:   534171
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.7 e09 13 Oct 2009 Fixed
15.1 e01 17 Apr 2009 Fixed
Description
Output of the Join Node of the query containing outer join

and large nested CASE statements was blank. Now the

output of the Join node contains the required entry.



CR:534316
CR Number:   534316
Product Name:   Sybase IQ ETL
Product Component:   other
Status:   Closed
OS:   all
Original Version:   4.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2008 Fixed
Description
Problem:

The ETL Engine Monitor memory foot print grows over a period of time.



Resolution:

This was resolved by modifying our garbage collection, clearing unused objects and removing the saving of some unneeded diagnostic information in memory.





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