远程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:703390
CR Number:   703390
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 15.3: LOAD TABLE ... USING CLIENT FILE in SP prompting for options to be ticked



The issue is not with the load table command itself but with calling a stored proc with the load table command in it. If you create a stored proc with the load table command inside and call that stored proc you will see the prompt. (screen prompting for options to be ticked...etc)



(DBA)> call test_load()

A procedure or trigger is requesting to read the file 'E:\temp\BA_F_JOUR_MOUV.out'.

1. Allow this transfer

2. Deny this transfer

3. Allow this and all subsequent transfers for this connection

4. Deny this and all subsequent transfers for this connection

Select an option: 1

2 row(s) affected

Execution time: 5.719 seconds



The customer would like a option similar to set temporary option isql_allow_read_client_file = 'ON' that will prevent the default PROMPT action. Perhaps enhance ALLOW_READ_CLIENT_FILE = 'ON' to have an option like ALLOW_READ_CLIENT_FILE = 'ON NO PROMPT'



CR:703526
CR Number:   703526
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
when "OFF" is set as a CONTINUE_AFTER_RAISERROR option, procedure does not stop after a RAISERROR statement.



CR:703878
CR Number:   703878
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 15 Jun 2012 Fixed
12 Dec 2012 Fixed
Description
When using a NOT EXISTS subquery, IQ may generate a non fatal internal error when tables are created with minimized storage option.
Workaround Description
 use DML_Options6='16777216'



CR:703882
CR Number:   703882
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 01 May 2012 Fixed
15.4 e02 13 Jul 2012 Fixed
30 Oct 2012 Fixed
Description
A non-fatal error occurred on NTILE and RANK functions run on tables of a million rows.



CR:704146
CR Number:   704146
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2012 Insufficient info provided
Description
IQ 15.4. Writer crash randomly in hs_csortInsertPkg::NextLoc().



CR:704248
CR Number:   704248
Product Name:   Sybase IQ ETL
Product Component:   Licensing
Status:   Open
OS:   Solaris
Original Version:   Denali
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SySAM loses checkout message in a Japanese language environment.

An issue will be reproduced when ja_JP.eucJP and ja_JP.SJIS are specified.



CR:704298
CR Number:   704298
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   future
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add non-equijoins by transitivity. When the where clause has these conditions:

T1.c1 >= T2.c2

T2.c2 = constant

then IQ should automatically add this condition:

T1.c1 >= constant



CR:704302
CR Number:   704302
Product Name:   IQ
Product Component:   Sybase Central
Status:   Open
OS:   Windows 2008
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sybase Central crashes when filter objects by dbo and click on events folder.



CR:704383
CR Number:   704383
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   15.2 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 22 Aug 2012 Fixed
16.0 05 Sep 2012 Fixed
Description
A query with two "IN" clauses may return an incorrect result set.
Workaround Description
 For this specific query, dropping LF indx of an indx made good result.



CR:704771
CR Number:   704771
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2012 Presently Not Targeted For Any Future Release Of This Product
Description
GA version release notes no longer contain CRs fixed in that GA version



CR:705105
CR Number:   705105
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
make Data movable when splitting a patition in IQ



CR:705108
CR Number:   705108
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR: possibility to change data in the partitioned key in IQ

Currently data in the partitioned key can not be changed (even if the data will be afterwards in the same partition).



CR:705288
CR Number:   705288
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2012 Presently Not Targeted For Any Future Release Of This Product
15.4 e01.x 30 Apr 2012 Fixed
15.4 e02 13 Jun 2012 Fixed
13 Jun 2013 Fixed
15.4 e02
16.0 15 Jan 2013 Fixed
02 Jul 2013 Fixed
Description
IQ 15.4 on Linux may have I/O failure if the storage devices are raw disks with sector size other than 512 bytes.



There is no work around.



CR:705510
CR Number:   705510
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e03.x 21 Sep 2012 Fixed
15.4 e03 16 Nov 2012 Fixed
16.0 28 Nov 2012 Fixed
Description
Nested loop pushdown (NLPD) join with more than one uncorrelated IN subquery crashes at st_server.cxx:1412, server abort at dfo::CheckMarkInvariant.

The problem is fixed.
Target Version
 15.2 e03.x
Workaround Description
 Please note they say that if they alter subquery at the end changing ....



( Select CIF_ID from ODS_FBS.FBS_PORTFOY1 WHERE E_MAIL_ADRES IN (Select EMAIL from u037687.EMAIL_HATA)



into this.....



Select CIF_ID from ODS_FBS.FBS_PORTFOY1 p, u037687.EMAIL_HATA m WHERE p.E_MAIL_ADRES=m.EMAIL



the query runs ok. But this is BO generated queries so they can not control this. They also found that the modified working query as described above strated failing again when they changed this subquery...



AND CRM2.BEST_EMAIL.CIF_ID IN ( SELECT DISTINCT CIF_ID FROM CANDO.CIF_CLUB_PROGRAM_SAHIPLIK WHERE (WORLD_CLUB_FLG = '1'



adding this or statement...



OR OPET_FLG = '1') )



But if they remove the GROUP BY it works again.



CR:705535
CR Number:   705535
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2012 Fixed
16 Aug 2012 Fixed
Description
Bookkeeping errors could be caused when all secondary servers are excluded and then immediately the coordinator is killed. During crash recovery the coordinator does not recover the bookkeeping records correctly and can cause database corruption.



CR:705829
CR Number:   705829
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqsysmon/IQ UTILITIES display cumulative InUse% for temp cache and and does not decrease even the temp cache/buffers are released.



CR:706080
CR Number:   706080
Product Name:   IQ
Product Component:   Install
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The GNOME desktop manager of RHEL5 mounts a DVD volume name to "/media."

However, the blank is included in the IQ15.4 DVD volume name.

IQ15.4 installer is not supporting the file name/path including a blank.
Workaround Description
 Please mount DVD media manually. ex)mount -t udf /dev/hda /media/dvd



CR:706098
CR Number:   706098
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01.x 23 May 2012 Fixed
15.4 e02 07 Jun 2012 Fixed
09 Nov 2012 Fixed
Description
this is a deadlock due to lock order violation due to a defect in IQ. It is a timing dependent issue with no work around



CR:706184
CR Number:   706184
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows Vista
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01.x 31 May 2012 Fixed
Description
When a client side load operation is either aborted by user, the signal on the thread handling it is not cleaned up. When such thread picks up any other request in future, the new thread gets aborted as well.



CR:706824
CR Number:   706824
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2003
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2012 Fixed
Description
If a jConnect or Open Client connection prepared a statement and called a stored procedure with a set of host variables, then the server could have crashed or returned an odd "variable already exists" error if the stored procedure had a parameter or variable named @p0. This problem has now been fixed.



CR:707370
CR Number:   707370
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 15 Aug 2012 Fixed
15.4 e03 15 Aug 2012 Fixed
16.0 15 Aug 2012 Fixed
05 Mar 2013 Fixed
Description
A query that contains an orderby operator with many thread and many sort

runs can use excessive memory.



CR:707398
CR Number:   707398
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2013 Fixed
03 Jun 2013 Fixed
03 Jun 2013 Fixed
Description
Fix of issue within the alert subsystem where new alert for MPX node shows twice in the alert table



CR:707612
CR Number:   707612
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2008
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 16 Jul 2012 Fixed
16.0 12 Oct 2012 Fixed
15.4 e01.x 02 Sep 2014 Fixed
Description
On the Windows platform only, a random query may abort in st_server.cxx:675 or 690 and leave the connection in a state where it cannot be dropped without restarting the server.



CR:707649
CR Number:   707649
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03.x 26 Apr 2013 Fixed
15.4 e00.x 04 Mar 2013 Fixed
15.4 e00.x 19 Mar 2013 Fixed
16.0 sp02 04 Oct 2013 Fixed
15.4 e04 03 Jul 2013 Fixed
16.0 sp01.x 17 Oct 2013 Fixed
Description
Some queries perform poorly because the IQ optimizer evaluates the less useful predicate(Invariant) first rather than the most useful predicate.



CR:707865
CR Number:   707865
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
And a lot of data(eg. 50000 rows) was inserted in the table using Load Table.

However, Load Table makes a gap to the value of an AUTOINCREMENT column.
Workaround Description
 Please set a small value(eg. 3 or 4) to MAX_IQ_THREADS_PER_CONNECTION.

Or Core_Options54 = 1.



CR:707992
CR Number:   707992
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01.x 05 Jun 2012 Fixed
15.4 e02 06 Jun 2012 Fixed
16.0 07 Jun 2012 Fixed
16.0 07 Jun 2012 Fixed
Description
Query using the Rank or the Row_Number function with a partition by clause may return incorrect result.



CR:708061
CR Number:   708061
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 19 Feb 2013 Fixed
Description
Toggling the radio button for data type, built-in or domain, did not properly update the system defined list.



CR:708197
CR Number:   708197
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
add support for global autoincrement that guarantees uniqueness across whole db even when a transaction rolls back (so that no two transactions can get the same value, no matter what commits and what rolls back)



CR:708205
CR Number:   708205
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
implement autonomous transactions to allow persistent logging no matter whether transaction commits or rolls back



CR:708818
CR Number:   708818
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
If a user cancels a load operation, the response time to the cancellation request is not adequate. It may take longer for the IQ server to respond to cancel the load transaction.



CR:708860
CR Number:   708860
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 01 Oct 2012 Fixed
Description
In order that IQ15.4 is using the path for some Symbolic Link absolutely, it cannot copy an installation image to a different path.



CR:708892
CR Number:   708892
Product Name:   Sybase IQ ETL
Product Component:   Runtime Manager
Status:   Closed
OS:   Windows 2003
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Unable to get task scheduled in windows 7 task manager for an Infoprimer project, 32 or 64bit



CR:709160
CR Number:   709160
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Consult Complete
Description
erroneous handling of isnull() resulting in division by zero exception



CR:709231
CR Number:   709231
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 26 Jun 2012 Fixed
Description
In IQ 16 ALPHA, a hash partitioned table has the following restriction:



All columns in a hash partitioned table must be fixed-width data types and flat (i.e. IQ unique(0)).



CR:709904
CR Number:   709904
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
NFR: implement ability to push filer predicate down to view or leaf level.



CR:710047
CR Number:   710047
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Official answers for compatibility IQ 15.4 + ASE 15.5 + SDK 15.7 ESD3



CR:710054
CR Number:   710054
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01 11 Jul 2012 Fixed
Description
IQ 15.4 sends wrong char length to JDBC clients when those conditions are met:

- IQ 15.4 runs on LINUX64

- collation must be UTF8

- JDBC retrieves a CHAR column value.

This results in JDBC clients getting "End of data" error.



CR:710120
CR Number:   710120
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 12 Mar 2013 Fixed
Description
Table's dbspace for a partitioned table was consuming more space than expected. This fix resolves this issue.



CR:710169
CR Number:   710169
Product Name:   Sybase IQ ETL
Product Component:   Installer
Status:   Open
OS:   AIX
Original Version:   Denali
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
InfoPrimer15.3 installer of the UNIX edition shows Japanese License Agrrement by UTF-8.

License Agreement could not be read when OS character set is except UTF-8.



CR:710208
CR Number:   710208
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2012 Fixed
15.4 e03 21 Nov 2012 Fixed
16.0 28 Nov 2012 Fixed
Description
IQ can report a non-fatal internal error from dfo_Ranking.cxx when there is an uncorrelated subquery on top of a ranking function.
Workaround Description
 set temporary option IN_Subquery_Preference='1' // Prefer Sort based Algo



CR:710418
CR Number:   710418
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 24 Jul 2012 Presently Not Targeted For Any Future Release Of This Product
Description
Sybase IQ 16.0 Alpha does not support INSERT LOCATION, BEGIN/END PARALLEL IQ, secondary file LOB LOAD and some other LOB Functionality, the WD and TEXT indexes, database upgrades, or referential integrity (Primary/Foreign Key relationship not enforced).



CR:710442
CR Number:   710442
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02 16 Jul 2012 Duplicate
Description
Fixed a condition where dbstop failed to shut down the IQ server.



CR:710657
CR Number:   710657
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2012 Fixed
15.4 e03 19 Dec 2012 Fixed
15.4 e03 26 Apr 2013 Added to user documentation
21 Dec 2012 Fixed
16.0 10 Jan 2013 Fixed
Description
On non-Windows platforms, the ROUND SQL function may return a different value from an IQ table than from an SA table. For example, a call of ROUND(convert(double,0.5), 0) returned 0 from an IQ table whereas the same call returned 1 from an SA table. A customer may want to have 1 as the returned value in this case.



CR:711339
CR Number:   711339
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
data type conversion is not possible dfe_Cast.cxx:918 when data contains blanks, expected behaviour as we can not convert a ' ' blank/space to a numeric. However there is an issue where using MINIMIZE_STORAGE='OFF' and WHERE clause, the convert error is ignored and the query is allowed to run through which is incorrect.



CR:711351
CR Number:   711351
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   AIX
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2012 Fixed
Description
CREATE or ALTER LDAP SERVER takes over a minute to execute when setting the SEARCH DN access account password on some platforms.



CR:711731
CR Number:   711731
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2012 Bundled Request
Description
Server crashes with CREATE USER and ALTER USER statements with password when VERIFY_PASSWORD_FUNCTION is enabled in 15.4.
Workaround Description
 Engineer made W/A,



Please use the following work-around to avoid the server crash.



CREATE FUNCTION DBA.f_verify_pwd

( user_name varchar(128),

new_pwd varchar(255) )

RETURNS varchar(255)

BEGIN



-- WORKAROUND START

execute immediate with quotes 'begin tran;'; -- Add this line in the beginning of verify password function

-- WORKAROUND END



-- enforce password rules

IF new_pwd = user_name then

RETURN('Password cannot be the same as the user name' );

END IF;

-- return success

RETURN( NULL );

END;



CR:712235
CR Number:   712235
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When restoring from backup, customer would like the ability to use the RESTORE .... RENAME to change / manage which raw device a dbfile should be restored to (i.e. swap around and reuse existing definitions)



For example if the system backed up contains MY_DBFILE1 on /dev/raw/raw1 and MY_DBFILE2 on /dev/raw/raw2, they wish to be able to restore this swapping which raw device the dbfile resides on, something like this...

restore database '/mydatabase.db'

from 'my-backup-file'

rename MY_DBFILE1 to '/dev/raw/raw2'

rename MY_DBFILE2 to '/dev/raw/raw1'



The currently can not do this as the restore logic and the UNIQUE constraint in ISYSDBSPACE (as identified in CR 649181) does not allow this so you get this error...



Could not execute statement.

Dbspace file with name or path '/dev/raw/raw1' already exist.

SQLCODE=-1234, ODBC 3 State="42000"



CR:712250
CR Number:   712250
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   HP-UX
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2012 Consult Complete
Description
While one can create 2 indices of same name in different case, one encounters an 'ambiguous index name' erro trying to drop either variant



CR:712256
CR Number:   712256
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2013 Not reproducible with latest version of the product available as of Resolution Date
Description
sending a NaN for a double form a .net app can crash server dumping core.



CR:712373
CR Number:   712373
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04 07 Jan 2013 Fixed
Description
Using insert-location to insert time data into a time column

from a time column on a remote IQ server results in error

"Cannot convert to time."
Workaround Description
 cast the TIME to TIMESTAMP on the select from location



eg,

insert into test_time(id,mytime) location 'iqrepro.iqrepro' {select id,CAST(mytime AS TIMESTAMP) from test_time};

-- This will work and will keep the right precision.



CR:712378
CR Number:   712378
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customers are asking for Sybase to provide a DDL extraction tool as part of the product that works just as well as the 12.7 to 15.x migration tool iqunload.



There is also a specific requirement for this to also be able to extract the user id with password.



CR:712540
CR Number:   712540
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Syntax error near 'tables' on line X at end loop if tables is used as a loop name
Workaround Description
 change tables to tables1 or such



CR:712589
CR Number:   712589
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 18 Aug 2012 Fixed
15.4 e01.x 23 Aug 2012 Fixed
27 Aug 2012 Fixed
Description
The union operation now supports up to 2048 table references instead of 512 table references.



CR:712709
CR Number:   712709
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01.x 28 Aug 2012 Fixed
15.4 e03 16 Dec 2012 Fixed
25 Jan 2013 Fixed
Description
A server failure could occur when a query has an IN clause with a subquery that has a filtering condition.
Workaround Description
 Following sql, avoiding the "not in" clause but functionally equivalent, does not crash the servers.



INSERT INTO dc.LOG_LoadStatus_15 (typename, timelevel, status, datadate, datatim

e ,

DATE_ID, modified) SELECT s2.typename, s2.timelevel, 'NOT_LOADED', '2012-06-18

00:00:00',

DATEADD(mi, min_id, DATEADD(hh, HOUR_ID, DATETIME('2012-06-18 00:00:00'))) ,

DATETIME('2012-06-18 00:00:00'),

NOW()

FROM dc.LOG_MonitoredTypes s1, dc.LOG_LoadStatus s2 JOIN ( SELECT

'1MIN' tlevel, hour_id, min_id FROM dc.dim_time UNION ALL SELECT '5MIN' tlevel,

hour_id, min_id FROM dc.dim_time WHERE mod(min_id,5) = 0

UNION ALL SELECT '10MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE mod(min_

id,10) = 0

UNION ALL SELECT '15MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id I

N (0,15,30,45)

UNION ALL SELECT '30MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id I

N (0,30)

UNION ALL SELECT 'HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id IN

(0,30)

UNION ALL SELECT '6HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id =

0 AND hour_id IN (0, 6, 12, 18)

UNION ALL SELECT '24HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id

= 0 AND hour_id = 0) datatimes

ON s2.timelevel = tlevel

WHERE s1.status = 'ACTIVE' AND ACTIVATIONDAY <= '2012-06-22 00:00:00' AND

s1.typename != s2.typename and

s1.timelevel != s2.timelevel

and s2.datadate = '2012-06-22 00:00:00'



CR:712751
CR Number:   712751
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2012 Fixed
Description
When using ODBC access to MS Access through IQ, you might encounter an error when exporting a table:



Column 'X' has an unknown datatype: 'nvarchar'.

-- (db_catalog.cxx 1162)



This has now bee fixed.



CR:712782
CR Number:   712782
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e01.x 02 Aug 2012 Fixed
15.2 e02 02 Aug 2012 Fixed
15.4 future 02 Aug 2012 Fixed
16.0
Description
Growcapacity was being called everytime and the release memory was

with the process. This was a major problem once the object size was big.

This use to consume a lot of memory of the system heap thus choking

the memory availability for the process/application.



CR:712864
CR Number:   712864
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2015 Presently Not Targeted For Any Future Release Of This Product
Description
NFR: implement JDBC driver load balancing between IQ servers



CR:713182
CR Number:   713182
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2003
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 23 Aug 2012 Fixed
16.0 05 Sep 2012 Fixed
Description
A server failure could occur in s_dpByteFetch::GetDistinctCount while running sp_iqcheckdb on a database containing a corrupt FP index.
Workaround Description
 Run the dataservices job on recreated destination table *after*

SET temporary option MINIMIZE_STORAGE = OFF ;



CR:713301
CR Number:   713301
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
AUTO_COMMIT/COMMIT_ON_EXIT is due to discontinue.

But IQ15.4 can use these options.



CR:713838
CR Number:   713838
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2012 Fixed
15.4 e03 16 Nov 2012 Fixed
16.0 28 Nov 2012 Fixed
Description
A Non-Fatal IQ Internal Error Detected at opt_Driver.cxx may occur during a query with a nested loop pushdown join (NLPD). The query will also have an incorrect result.
Target Version
 15.4 e02
Workaround Description
 Set Join_Preference to '-3', but it's not safe work-around.

Workaround:

----------

set temporary option dml_opions4 = '8388608'

This option forces not to add dfo_Store , hence avoids the validation.



This is a safe option.

-junaid



CR:713919
CR Number:   713919
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 15 Mar 2013 Fixed
Description
Events were prevented from being triggered when the coordinator was down. This was not a requirement for the event to be triggered and has been removed.



CR:713941
CR Number:   713941
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04 04 Jun 2013 Fixed
16.0 sp02 13 Jun 2013 Fixed
Description
sp_iqshowpsexe reports data under the incorrect column headers. MAX_STATEMENT_COUNT is reported as 'max_cursors', and MAX_CURSOR_COUNT is reported as 'max_statements'.



CR:715010
CR Number:   715010
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
27 Aug 2012 Added to user documentation
Description
Explicitly passing in null as the 3rd parameter

(algorithm) to the encrypt or decrypt function will result in the error

-973 "The string is too long (Parameter 3)", rather than having the

encryption/decryption default to AES128. The work around is to omit the

argument.



See "Known Issues" for more information.



CR:715165
CR Number:   715165
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2012 Fixed
Description
Index advisor may write a message advising rebuilding of index with minimize_storage = on, even though the option is already on in the IQ message file



CR:715316
CR Number:   715316
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2012 Duplicate
Description
LOAD TABLE may stop processing if not enough buffers are available



CR:715562
CR Number:   715562
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
need to document that [T|t]ables is now reserved word as of 15.4



CR:715563
CR Number:   715563
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
need to document that [T|t]ables is now reserved word as of 15.4



CR:715567
CR Number:   715567
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ documentation enhancement request to improve details and examples on how to set and define IQ-to-ASE connections with ODBC on Unix/Linux.



There is an excellent article published by Rob Vershoor highlighting this located at http://www.sypron.nl/iq_ase_odbc.html.



CR:715677
CR Number:   715677
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2012 Insufficient info provided
Description
server abort in an_id_hash_table::clean()(st_server.cxx:1430)



CR:715997
CR Number:   715997
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04 16 Apr 2013 Fixed
16.0 sp01 07 Mar 2013 Test Exists
16.0 sp01 11 Mar 2013 Fixed
Description
Certain queries could return different results

- when it is run on Simplex or MPX.

- when it is run several times on MPX
Workaround Description
 2 possible workarounds:



1- SET TEMPORARY OPTION CIS_OPTION=8



2- Rewrite the query as follows:



DROP table if exists a

CREATE table a (a_key char(30), a_val int not null)

INSERT a values('XXX', 100)



BEGIN

DECLARE @a_val int



SELECT @a_val = MIN(a.a_val)

FROM a , (SELECT cast('XXX' as char (30) ) as a_key ) z

WHERE a.a_key = z.a_key



SELECT @a_val



INSERT INTO a ( a_key, a_val ) SELECT 'XXX', @a_val

END



CR:716303
CR Number:   716303
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 26 Feb 2013 Fixed
Description
A server failure may occur in s_btParallelCursor::SetDeleteNotifier

when trying to insert a duplicate key.
Workaround Description
 Use "core_options27=1" for the INSERT VALUES or INSERT SELCT statement when inserting to a word index to avoid the problem.



CR:716358
CR Number:   716358
Product Name:   IQ Management
Product Component:   Web UI - Alerts
Status:   Closed
OS:   RH Linux
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Aug 2012 Fixed
13 Sep 2012 Fixed
Description
This resolution fixes an issue which occurs if you go to add an alert to a multiplex and in the alert wizard select on the first step a specific node, or even drill down a bit under that node, then on the Duplicates step all the other nodes for that multiplex should be listed.



CR:716554
CR Number:   716554
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
Description
Buttons on Table Wizard -> Partitions page not disabled/enabled properly in SCC.



CR:716563
CR Number:   716563
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04 05 Jun 2013 Fixed
16.0 sp02 03 Oct 2013 Fixed
Description
A query containing a Group by over a column with an empty string value reports an IQ Internal error (opt_QueryExp.cxx 309).



CR:716988
CR Number:   716988
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
incorrect result with nested exists clause
Workaround Description
 The work around :

1.

if exists (select 1 from pr_account where acnomajor like 'C[_]%' AND

@include_feeder = 'N'

and exists (select 1 from pr_account where acnomajor like 'A%[_]%' AND

@include_feeder = 'N'))



so it's if exists ( conditions

and exists ( conditions

))



2. Or using an or clause:





if exists (select 1 from pr_account

where @include_feeder = 'N' and acnomajor like 'C[_]%' or

acnomajor like 'A%[_]%' and @include_feeder = 'N'

)



CR:717018
CR Number:   717018
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.3 12 May 2013 Fixed
Description
Updated the synchronize server script to allow correct logon.



CR:717140
CR Number:   717140
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4 e01.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2012 Fixed
08 Oct 2012 Fixed
01 Nov 2012 Fixed
30 Nov 2012 Fixed
14 Dec 2012 Fixed
Description
In IQ MPX on secondary server, call to VERIFY_PASSWORD_FUNCTION is skipped when new password is specified through GRANT CONNECT, CREATE USER and ALTER USER statements.



CR:717361
CR Number:   717361
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2003
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Conversions on the result of DATEADD could return different values depending on whether the query is executed on the catalog or on IQ, due to the fact that:

select datalength (dateadd(hh,4, date(now()))) from dummy ==> returns 8

select datalength (dateadd(hh,4, date(now()))) from iq_dummy ==> returns 4



CR:717555
CR Number:   717555
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
sp_iqpassword fires" Syntax error " when the password contains special chars

such as: "!" , "?", "+" , ">" , "<" , "" , "|" , "*" , "&", "(", ")", etc
Workaround Description
 Use CREATE USER or ALTER USER or GRANT CONNECT



CR:717572
CR Number:   717572
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 07 Oct 2012 Fixed
16.0 23 Nov 2012 Fixed
Description
A select query with IN sub-query, which compares numeric columns of IQ and "IN SYSTEM" tables may give wrong results.
Workaround Description
 set temporary option CIS_OPTION=8; --> Old IQ 12.7 CIS behavior can be used as WA.



CR:717619
CR Number:   717619
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 14 Feb 2013 Fixed
Description
The Text Index page for table properties was giving an incorrect error about permissions to access functionality on the page.



CR:717877
CR Number:   717877
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 13 Feb 2013 Fixed
Description
Fixed issue where a new Text Index would be edited before it is officially created (applied).



CR:718091
CR Number:   718091
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2012 Fixed
29 Oct 2012 Fixed
16.0 23 Nov 2012 Fixed
Description
A query with outer join, group by and nested CASE statements containing columns from both the tables involved in join may result in exception at dfo.cxx:9689



CR:718155
CR Number:   718155
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 11 Mar 2013 Fixed
Description
The DDL created for a Foreign Key was incorrectly including the "NOT NULL" clause.



CR:718373
CR Number:   718373
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 15 Mar 2013 Fixed
Description
A 15.4 resource would indicate the user did not have correct authority on the constraints page. This has been resolved.



CR:718919
CR Number:   718919
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DQP Query run on reader crash coordinator/writer on hos_dtkeycmp_dtdate
Workaround Description
 The DQP query does not crash when setting the query plan generation OFF

set temporary option query_plan='OFF';

set temporary option query_plan_after_run='OFF';

set temporary option query_plan_as_html='OFF';



CR:719383
CR Number:   719383
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Windows 2003
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e02.x 07 Jan 2013 Fixed
02 Jan 2013 Fixed
17 Jan 2013 Fixed
Description
The query below returns wrong result when Nested loop is not used :



select count(1)

from REL_1_CityASM t1

join F_PUP_OrderHeader t2 on (cast(t1.Object_ID as bigint) = t2.PUP_Order_ID/1000000000)

join LU_Cassa t7 on (t1.Object_ID=t7.Object_ID )

where t1.ASM_ID=23

and (REMAINDER(t2.PUP_Order_ID,1000000000) <> 0)



CR:719590
CR Number:   719590
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2013 Fixed
Description
On a machine under heavy load, a TCP connection attempt could fail with an incorrect error code. On certain operating systems, the connection attempt could hang. This has been fixed.



CR:719831
CR Number:   719831
Product Name:   IQ Management
Product Component:   Web UI - Resource Authentication
Status:   Closed
OS:   Windows 7
Original Version:   3.2.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2012 Fixed
10 Oct 2012 Fixed
Description
There can be a failure to authenticate when using certain collations.



CR:720503
CR Number:   720503
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03 15 Jan 2013 Fixed
15.4 e02.x 18 Feb 2014 Fixed
Description
Space allocation may fail with error "DBSPACE is INVALID" trying allocate physical block numbers greater than 4GB.



CR:720539
CR Number:   720539
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2013 Fixed
15.4 e03.x 31 Jul 2013 Fixed
Description
INSERT LOCATION performance drops 10 times slower from 15.2 to 15.4 esd 2



CR:720584
CR Number:   720584
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Open
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: Request to enhance performance of the Connection methods: .isClosed(), .isReadOnly() & .getAutoCommit()



CR:720701
CR Number:   720701
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.2 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
intermittent st_server.cxx:1412 crases at calls hos_key_uncondA_dtint64 , s_packedRec::DeliverRec



CR:720782
CR Number:   720782
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
3.2.7 ESD1 13 Mar 2013 Fixed
Description
The Text Configuration Wizard did not give an appropriate error for resource user when they attempted to create as a user other than self.



CR:720912
CR Number:   720912
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 beta2 25 Oct 2012 Added to user documentation
Description
DROP USER will drop any objects owned by this user AND ALSO THE PERMISSIONS GRANTED BY THIS USER WILL BE REMOVED.

Please see reference for the REVOKE CONNECT command in the SA manual:

http://dcx.sybase.com/index.html#1201/en/dbreference/revoke-statement.html .



CR:721615
CR Number:   721615
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 19 Feb 2013 Fixed
Description
During load table with header skip option attention check was responding after very long time. This fix resolves this issue.



CR:721667
CR Number:   721667
Product Name:   IQ Management
Product Component:   Web UI - Administration
Status:   Closed
OS:   Generic
Original Version:   3.2.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2012 Fixed
3.2.7 Beta1 13 Dec 2012 Fixed
13 Dec 2012 Not a Bug
Description
You cannot create a table with partitioning if you specify that columns are stored in a different dbspace from the table. The workaround is to create the table, place the columns where you want them, and use Table Properties > Partitions to partition after creating the table.



CR:721949
CR Number:   721949
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2013 Duplicate
Description
incremental backup crashed st_server.cxx:1409 at _int_free call. This happens right after the backup process completes but before the final checkpoint completes.



CR:722006
CR Number:   722006
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2012 Fixed
16.0 18 Dec 2012 Fixed
Description
Fixes update crash on an RLV enabled range partitioned table.



CR:722122
CR Number:   722122
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e02
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2012 Consult Complete
Description
analysis of the request log containing a CALL statement needs huge catalog cache.

For example, when 50MB of request log contains 30000 times of CALL statements, request log analysis uses 170MB of catalog cache.





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