远程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:759416
CR Number:   759416
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e03.x 17 Jun 2014 Fixed
01 Jul 2014 Fixed
15.4 e05 09 Dec 2014 Fixed
Description
Stored procedure sp_iqcontext can unexpectedly fail while freeing memory.



CR:759565
CR Number:   759565
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 25 Mar 2014 Added to user documentation
Description
Count() function is support the range of BIGINT type.



CR:759611
CR Number:   759611
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2014 Already Fixed by Another CR
Description
Customer upgraded from IQ 15.4 esd 1 on Linux to esd 3 and now a number of their production queries are failing with Exception Thrown from dfe_Cast.cxx:835, Data exception - data type conversion is not possible.
Workaround Description
 have found loading data with minimize_storage = 'off' or adjusting column order in the select list avoids the error, however this is not practical for the customer to do in a production system given the scale of the queries affected.



CR:760106
CR Number:   760106
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp03.x 21 Mar 2014 Fixed
16.0 sp08 21 Mar 2014 Fixed
16.0 sp04 01 May 2014 Fixed
Description
Simple "select count distinct" on 1 table cause IQ abort with stack trace when an HG index exists. It runs fine when this HG index is removed.



select "campaign_id","count"(distinct("walklist_household_key"))

as "Households" from "sk_prod"."WALKLIST_ROI_PLANNING_TMP"

group by "campaign_id"
Workaround Description
 set temporary option AGGREGATION_PREFERENCE=-2



CR:760313
CR Number:   760313
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 e04.x 02 Apr 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
A query which is cancelled or fails due to an internal error can result in server failure with EstimateNonLocalSelectivity in the call stack.
Workaround Description
 The crash is happening as we gather stats for the query plan. Turning off query_plan_after_run should avoid the crash.



CR:760575
CR Number:   760575
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DROP DATABASE statement with no directory permission to stop the utility db



CR:760749
CR Number:   760749
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
INSERT LOCATION between 2 IQ servers can hang or cause IQ fatal abort when

- the source DB is a single byte collation and contains a NON LATIN char ( or )

- the destination DB is UFT8BIN (INSERT LOCATION is executed on this server)



CR:760880
CR Number:   760880
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 28 May 2014 Fixed
16.0 sp04.x 02 Jun 2014 Fixed
Description
When running a 16.x server on a 15.x database, if an insert...values statement is run as the first read-write statement on a table and it fails with a simple error such as a "conversion error", the FP index may be corrupted due to partially upgraded metadata.



This problem has been fixed by a proper execution of a rollback upon command failure.
Workaround Description
 Plausible work around is to convert NBit indexes to Flat FP by setting count value to 0 in sp_iqrebuildindex

Using



sp_iqrebuildindex <tblname>, 'column <colname> [<count>]'



With count value == 0 or greater than 2,147,483,647 (i.e. say 3,147,483,647) will build FP index.



--- 4/25 (milind) workaround does not help



CR:760959
CR Number:   760959
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 21 May 2014 Fixed
Description
The server fails with a signal 11 during sp_iqrebuildindex.



CR:761033
CR Number:   761033
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 01 Apr 2014 Fixed
03 Apr 2014 Fixed
Description
Under rare circumstances a query may abort and bring down the server if Index Adviser is turned on.
Workaround Description
 turn off Index Advisor



CR:761157
CR Number:   761157
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2014 Not reproducible with latest version of the product available as of Resolution Date
Description
-dt option being ignored by IQ. Need to set IQTMP16 to configure the IQ temporary file directory
Workaround Description
 set IQTMP16 environment variable to point to a directory with sufficient space for temporary files created by IQ



CR:761259
CR Number:   761259
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 07 Apr 2014 Added to user documentation
Description
Incorrect default value of BT_Prefetch_Max_Miss on Manual.

Correct default values is 1.



CR:761260
CR Number:   761260
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 07 Apr 2014 Added to user documentation
Description
Incorrect default value of Cache_Affinity_Percent on Manual.

Correct default values is 75.



CR:761284
CR Number:   761284
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 08 May 2014 Fixed
16.0 sp08.x 14 May 2014 Fixed
16.0 sp04.x 11 Jun 2014 Fixed
Description
SAP IQ did not report any error if the file system on which the backup file was being written was full. The issue has been fixed to handle this situation and errors returned because of no space on the file system will be returned to the user.



CR:761435
CR Number:   761435
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
select MAX with WHERE clause = DATEADD on table with HG index = crash
Workaround Description
 Drop HG index



CR:761580
CR Number:   761580
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2014 Fixed
16.0 sp04.x 25 Jun 2014 Fixed
Description
Under some conditions, calling a stored procedure that had nested stored procedure calls could cause a server hang if this was the initial load of the involved stored procedures.
Workaround Description
 N/A



CR:761924
CR Number:   761924
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2014 Fixed
Description
Cannot be set 0 to MPX_IDLE_CONNECTION_TIMEOUT.



CR:761938
CR Number:   761938
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2014 Fixed
Description
In rare cases, the server may have crashed while parsing an incorrect IN search condition. This has been fixed.



Syntax parser fails to detect a non existing object in a query and crash IQ.

The query must have two WHERE conditions on the same column with OR/AND:

col1 = <constant value> OR/AND col1 IN <non-existing object name>



Ex: select * from departments where departmentID = 100 and departmentID in NO_Object;



DBSIQL receives this error:

Error! The connection to the database was closed by the server.

Connection was terminated

SQLCODE=-308, ODBC 3 State="HY000"

Line 1, column 1



CR:761954
CR Number:   761954
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 22 Apr 2014 Fixed
07 May 2014 Fixed
Description
Under some circumstances a query with an uncorrelated subquery may report a non-Fatal error at dfe_BaseColumn.cxx:1410 when a table in the subquery has no rows.



CR:761995
CR Number:   761995
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 15 May 2014 Fixed
07 May 2014 Fixed
Description
A query containing a left or right function in a procedure that uses integer variables with some sort of math operation in the call to left or right (for example, my_position + 1) might result in a server failure and stacktrace with hos_FreeHosMem at the top of the stack.
Workaround Description
 N/A



CR:762181
CR Number:   762181
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 16 Apr 2014 Fixed
16.0 sp04 29 Apr 2014 Fixed
16.0 sp03.x
15.4 e04.x
16.0 sp04 05 May 2014 Fixed
Description
The version of OpenSSL release with this update has been updated to 1.0.1g



CR:762183
CR Number:   762183
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 29 Apr 2014 Fixed
16.0 sp04 29 Apr 2014 Fixed
15.4 e04.x 29 Apr 2014 Fixed
Description
The version of Open Client include with this release has been updated to 15.7 SP126



CR:762204
CR Number:   762204
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   AIX
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbisql cannot read sql include japanese("0x5b","0x5d") on aix.

dbisql will output a syntax error.



CR:762222
CR Number:   762222
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 22 May 2014 Fixed
16.0 sp08.x 24 Jul 2014 Fixed
Description
Query with an uncorrelated subquery predicate hits a non-fatal failure on vpp_In::ExecuteOpus
Workaround Description
 Create an HG index on the column suggested by the index advisor.



CR:762390
CR Number:   762390
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2014 Failed
Description
"COALESCE" and "GROUP BY" return a error "Can not evaluate expression"
Workaround Description
 A workaround to this issue is to disable the case expression simplification using the following option:



set temporary option dml_options5 = 1073741824



Or replace the CASE statement.



SELECT COUNT(t_A3.COL1)

FROM

(

SELECT t_A2.COL1, MAX(t_A2.COL3) COL3

FROM

(

SELECT t_A1.COL1, CASE WHEN(t_A1.COL2 IS NOT NULL) THEN t_A1.COL2 WHEN(t_A1.COL3 IS NOT NULL) THEN t_A1.COL3 END as COL3 FROM tableA AS t_A1

) AS t_A2

GROUP BY t_A2.COL1

) AS t_A3

WHERE t_A3.COL3 > '2014-03-30';



CR:762619
CR Number:   762619
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 7
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2014 Fixed
Description
QUOTES ON load is read and processed in 16.0 as one thread per file. This results in a performance regression loading a single file with QUOTES ON. The IQ Load Engine has been updated to process QUOTES ON, single file load using multiple threads. This resolves the performance regression.



CR:762668
CR Number:   762668
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 16 May 2014 Fixed
16.0 sp08.x 04 Dec 2014 Fixed
Description
A simple DELETE on 1 table may cause the following possible errors:



- non-fatal error in hs_subohc::SmallDelete

- fatal abort with "IQ Internal Error Detected: Memory Corruption" in destructors s_dictionary::~s_dictionary or s_dpNBit::~s_dpNBit



These errors are prevented with this fix.



CR:762732
CR Number:   762732
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Windows 2008
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2014 Fixed
24 Apr 2014 Fixed
Description
DBISQL will terminated abnormally by Text completion feature



CR:762777
CR Number:   762777
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jan 2015 Duplicate
Description
Fatal aborts on " IQ Internal error on FP variable page! "



CR:762963
CR Number:   762963
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Suse
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 11 Jun 2014 Fixed
11 Jun 2014 Fixed
31 Jul 2014 Fixed
31 Jul 2014 Fixed
Description
Under rare circumstances a query with multiple predicates might result in a Non-Fatal IQ Internal Error Detected at vplib/vpp.cxx:6413.
Workaround Description
 Given the stacktrace the following dml_option setting should avoid the error:

dml_options12 = 67108864



CR:763120
CR Number:   763120
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2014 Fixed
16.0 sp08.x 24 Nov 2014 Backed Out
28 Oct 2014 Fixed
16.0 sp10 16 Jan 2015 Fixed
Description
On Linux x86 (RHEL and SuSE), IQ now uses O_DIRECT to open files. This allows IQ to bypass file cache and support IQ MPX on filesystem files including NFS and GPFS.



CR:763588
CR Number:   763588
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When you create an IQ database with UTF8BIN collation sequence in a Japanese environment, Japanese some error messages will be truncated.



CR:763678
CR Number:   763678
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 18 Jun 2014 Fixed
16.0 sp04.x 12 Jun 2014 Fixed
24 Jun 2014 Fixed
Description
The fix for CR 761995 was incomplete and could result in wrong results on some platforms under rare conditions.



CR:763801
CR Number:   763801
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04 15 May 2014 Fixed
15.4 e05 15 May 2014 Fixed
16.0 sp08.x 15 May 2014 Fixed
31 Jul 2014 Fixed
Description
A safety assert was triggered that caused the query to politely fail.



On investigation, the assert is too restrictive, and will now permit that condition to pass.
Target Version
 16.0 sp08.x



CR:763999
CR Number:   763999
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2014 Fixed
Description
grant execute command stop the utility server.



CR:764042
CR Number:   764042
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2014 Fixed
Description
When running sp_iqdbspaceinfo or sp_iqdbspaceobjectinfo on a 1254TRK collation database, error "table sysiqidx not found" or "table sysiqinfo not found" could be fired.



CR:764089
CR Number:   764089
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2014 Fixed
26 Aug 2014 Fixed
Description
Under rare circumstances IQ could crash while executing a simple query with the following message:



* Error =>



... ** Non-Fatal IQ Internal Error Detected

... ** at dflib/dfo_Combiner.cxx:2099 on thread 1363 (TID 1354)

... ** Error detected at DFO #216 Parallel Combiner

...

... Exception Thrown from dflib/dfo_Combiner.cxx:2099, Err# 0, tid 1354 origtid 1354

... O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23

... [20239]: IQ Internal error. Please report this to Sybase IQ support.



This has now been fixed.



CR:764235
CR Number:   764235
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
iqsrv16 will create an entry in the syslog as "Notice" the priority of all messages.



CR:764293
CR Number:   764293
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2 e02.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 e02.x 20 May 2014 Fixed
Description
The following fix has been removed from the product for esd 2.27

SwrID CR Description

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

ESD2.26 757044 We have backported a fix for an issue where IQ would purge

table versions which were in-use by read-only cursors. This

would lead to memory corruption and subsequent server

aborts at random locations.



CR:764486
CR Number:   764486
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
round function does not round off a double value.
Workaround Description
 Please convert to decimal values ​​before rounding.



CR:764646
CR Number:   764646
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 06 Jun 2014 Fixed
16.0 sp09 06 Jun 2014 Fixed
16.0 sp08.x 09 Jun 2014 Fixed
16.0 sp04.x 13 Jun 2014 Fixed
16.0 sp09 17 Jun 2014 Fixed
16.0 sp08.x 13 Jun 2014 Fixed
16.0 sp08.x 24 Jun 2014 Fixed
16.0 sp09.x 30 Jun 2014 Fixed
16.0 sp04.x 23 Jun 2014 Fixed
16.0 sp04.x 27 Jun 2014 Fixed
16.0 sp08.x 27 Jun 2014 Fixed
16.0 sp09 01 Jul 2014 Fixed
Description
Problems causing the following two errors in a database upgraded to SAP IQ 16 from versions 12.7 and 15.4 have been fixed.



'alter table X alter column NULL' fails with error



Internal state violation, please contact SAP IQ support

-- (slib/s_blockmap.cxx 6163)

and

IQ Internal error - s_blockmap.cxx; 3182 during LOAD TABLE.



CR:764874
CR Number:   764874
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 05 Jun 2014 Fixed
16.0 sp08.x 06 Jun 2014 Fixed
16.0 sp04.x 06 Jun 2014 Fixed
16.0 sp09 04 Sep 2014 Fixed
Description
The bug occurs when querying a table with large number of columns (more than 128). The symptom is that IQ server reports non-fatal internal error at slib/s_barry.cxx.



The workaround for the query is: set temporary option CORE_Options86 = N, where N is number of table columns.



CR:765098
CR Number:   765098
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2014 Fixed
16.0 sp09 26 Aug 2014 Fixed
16.0 sp04.x 25 Jul 2014 Fixed
Description
Fixed an issue introduced in 16.0 SP02 where queries that include

a RANK aggregate with a descending ordering key may fail with a

non-fatal internal error.
Workaround Description
 Set Both options

DML_options8=8 (avoid shadow parallelism) AND

DML_options9=8 (avoid delayed projection)



An alternative which seems to work:

dml_options12 = 1024



CR:765242
CR Number:   765242
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SELECT with LIKE clause return wrong results use V15 FP Index.
Workaround Description
 1. rebuild all FP index.

2. disable shadow parallelism

set temporary option dml_options8=128



CR:765340
CR Number:   765340
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jan 2015 Fixed
Description
When creating an existing remote table against SAP HANA or Hadoop where the tables a high number of rows, then ODBC call to SQLStatistics can take a long time to execute.



New cis_option to disable fetching of statistics (index info) when creating proxy tables in order to work around issues with back ends that take a very long time to return statistical information.



CR:765543
CR Number:   765543
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2014 Fixed
10 Oct 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
A SELECT query on columns of a view, which in turn is based on multiple views/tables with UNION ALLs and OUTER JOINS, caused IQ to ABORT.



CR:765824
CR Number:   765824
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Temp block leaks.

Create temp #table and insert rows in it.

Disconnect should release all the temp blocks used by this temp table.

Reconnect and use sp_iqstatus, you will see that not all the temp blocks previously used are released.

To reclaim temp space, the #table must be explicitely dropped or IQ must be recycled.
Workaround Description
 To reclaim temp space, the #table must be explicitely dropped or IQ must be recycled.



CR:765943
CR Number:   765943
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Windows 2008
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2014 Presently Not Targeted For Any Future Release Of This Product
Description
Default port value of SCC is used in IQ16 SP08 installer of non-english.
Workaround Description
 Please change installer language to english.



CR:766131
CR Number:   766131
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 24 Jun 2014 Fixed
16.0 sp08.x 08 Sep 2014 Fixed
16.0 sp04.x 02 Sep 2014 Fixed
Description
In rare circumstances, DBCC reported extra RIDS after an update of NULL rows in a Range Partitioned table.



CR:766277
CR Number:   766277
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2014 Duplicate
Description
IQ 15.4 esd 2.24 solaris, DBSTOP crashing with hos_throw.cxx:313 at s_bufpool::Rollback after sucessful checkpoint and throwing error "Allocation failed. Dbspace IQ_SYSTEM_TEMP is INVALID"



CR:766287
CR Number:   766287
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
IQ 15.2 esd 2.26 update statement caused IQ to abort s_blockmap.cxx:1705 "Message: TEMPORARY blockmap still owns dirty pages -- should have been destroyed" with a stack at call s_blockmap::Unlock()



CR:766290
CR Number:   766290
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
15.4 esd 3 Smaller temp cache has better performance than with larger temp cache.



CR:766931
CR Number:   766931
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 29 Jul 2014 Added to user documentation
Description
Typo error in "Subqueries in Search Conditions", in the SQL example,

instead of "lineitemWHERE", it should be a blank in between as "lineitem WHERE".



CR:766989
CR Number:   766989
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2014 Fixed
14 Aug 2014 Fixed
Description
IQ internal error was detected when a right outer join query was

executed on a table consisting of a combination of varchar column and NBIT FP index.

This has been fixed now.
Workaround Description
 set temporary option Revert_To_V15_Optimizer = 慜N



or



set temporary option DML_Options14 = 8;

set temporary option CORE_Options14 = 256



*** NOTE ******



The REVERT_TO_V15_OPTIMIZER currently does not disable the first (DML_Options14=8),

but does disable the second (CORE_Options14 = 256).



1) Disable for varchars and varbinarys the use of the maximum

width ever inserted, rather than the declared maximum width:



set temporary option DML_Options14 = 8



2) Disable the fast-in memory variant of the hash table:



set temporary option CORE_Options14 = 256



CR:767122
CR Number:   767122
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 11 Jul 2014 Fixed
16.0 sp08.x 14 Jul 2014 Fixed
16.0 sp09 15 Jul 2014 Fixed
Description
After upgrading a 12.7/15.x database to IQ 16, a load/insert/update/delete on an existing table (table exists prior to the upgrade) could cause a server failure.

The failure is specific to the following conditions

a) IQ 12.7/15.x table must be empty (i.e., contain zero rows)

b) IQ 12.7/15.x table contains at least one tokenized FP

c) IQ 12.7/15.x database upgraded to IQ 16

d) first readwrite operation on table *must* be one of



- create index on tokenized FP column, OR

- add Primary Key, Foreign Key, Unique Constraint to tokenized FP column
Workaround Description
 After upgrade



/remote/cases/11816000s/11816747/pseinfo-11/Repro/070914/frawtabwa.sql



Begin parallel iq



Create index









End parallel iq



load table



CR:767144
CR Number:   767144
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 21 Jul 2014 Fixed
16.0 sp09 18 Jul 2014 Fixed
Description
Fixed a performance issue with equality conditions that equate a constant

expression to a column that happens to be the hash partitioning basis

for a hash (or hash and range) partitioned table.



CR:767342
CR Number:   767342
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 23 Jul 2014 Fixed
Description
The OpenSSL included with this release has been update to verion 1.0.1h



CR:767679
CR Number:   767679
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp03.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 22 Jul 2014 Fixed
16.0 sp09 23 Jul 2014 Fixed
16.0 sp04 23 Jul 2014 Fixed
Description
Update causes IQ crash in hs_dpInsert::FinishedInsert under the following conditions:

a) updating a nullable nbit column

b) updating all rows on the column such that the update

effectively does an insert

c) during the update, the nullable nbit column rolls over to flat
Workaround Description
 Convert all the column data types from REAL/FLOAT/DOUBLE to DECIMAL or NUMERIC,

and cast the calculation to to DECIMAL or NUMERIC.



CR:767865
CR Number:   767865
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2014 Fixed
24 Sep 2014 Fixed
Description
The NOT TRANSACTIONAL clause of declare local|global temporary table throws "Not Supported" error. A database option "Give_Error_On_Not_Transactional_DDL" (default value = 'On') has been introduced and error can be ignored if this option is set to 'Off'.



CR:767908
CR Number:   767908
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In an environment where the private network is not registered in the MPX, when you add to MPX multiple hosts, DAS listener will block to stop the IQ server.
Workaround Description
 Add the private host addoress using alter multiplex server statement.



CR:767912
CR Number:   767912
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 26 Sep 2014 Fixed
16.0 sp09 02 Oct 2014 Fixed
Description
A query with a hash join over a grouping operator could fail with error -1001043 (internal error, can not evaluate expression) or -1006000 (internal error in s_packedRec). This has been fixed.
Workaround Description
 When below otion was set, tthe query completed well without error.



1) Aggregation_preferece='-3'

2) Dml_Options8=8



CR:767925
CR Number:   767925
Product Name:   IQ cockpit
Product Component:   Security
Status:   Closed
OS:   NA
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2014 Duplicate
Description
initial setting of uafadmin password is not written anywhere.



CR:767952
CR Number:   767952
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 24 Jul 2014 Fixed
16.0 sp09 25 Jul 2014 Fixed
16.0 sp04.x 24 Jul 2014 Fixed
Description
Database inconsistencies can occur if the first readwrite operation on an IQ 15.x table, after upgrading the IQ 15.x database to IQ 16, involves rebuilding a column (via sp_iqrebuildindex) on which there exists a non-unique single column HG index.



CR:767977
CR Number:   767977
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2014 Added to user documentation
Description
IQ Cockpit: initial password for sccadmin/uafadmin is not listed in the document
Workaround Description
 initial password of sccadmin/uafadmin is "Sybase4me".



CR:768008
CR Number:   768008
Product Name:   IQ
Product Component:   Documentation
Status:   Closed
OS:   Windows 2008
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 30 Jul 2014 Added to user documentation
Description
SAP IQ 16.0 SP08 Server and Network Client support Windows Server2012 and 2012 R2.



CR:768096
CR Number:   768096
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp04.x 25 Jul 2014 Fixed
16.0 sp08.x 25 Jul 2014 Fixed
16.0 sp09 25 Jul 2014 Fixed
Description
Database inconsistencies can occur when the very first readwrite operation on an IQ 15.x table, after upgrading the IQ 15.x database to IQ 16, is an insert..values statement that



a) is run with NOEXEC on

b) triggers a data conversion error



CR:768284
CR Number:   768284
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Windows 2008
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SAP IQ Directory Access Server. Copy a file from a directory to another using INSERT SELECT fires no error.

Although the file is copied to the correct directory but the content is empty (fie size 0 byte).



CR:768337
CR Number:   768337
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 14 Aug 2014 Fixed
15.4 e05 13 Aug 2014 Fixed
Description
A query that includes a rank function in the select list, a join clause and a group by

clause caused an internal error in dfo_cOrderBy.cxx
Workaround Description
 Temporary W/A is



Set tempoary option DML_OPTIONS9=8 ; ( To disables delayed projection transformation).



CR:768378
CR Number:   768378
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   HP-UX
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Oct 2014 One-off Provided
30 Oct 2014 Fixed
15.4 e05
Description
Interrupting a query that contains an Order By operator with CTRL-C or

drop connection could cause server threads to hang, leading to version

accumulation and possibly unresponsive server.



CR:768389
CR Number:   768389
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   HP-UX
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
DumpAllthreads causes IQ server to crash



CR:768469
CR Number:   768469
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 14 Sep 2014 Fixed
16.0 sp04.x 15 Sep 2014 Port Not Needed
16.0 sp09.x 15 Sep 2014 Fixed
Description
There was a bug in query plan generation logic during a 'load/create index' statement when option Query_plan_text_caching is set.



CR:768532
CR Number:   768532
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 14 Aug 2014 Fixed
15.4 e04.x 14 Aug 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
Queries of the form

WITH < temp_table > AS (SELECT * FROM orig_table) (Query using temp_table)

caused the server to fail in IQ 15.4.



CR:768537
CR Number:   768537
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2014 Fixed
15.4 e04.x 11 Aug 2014 Fixed
11 Aug 2014 Fixed
16.0 sp10 16 Dec 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
12 Dec 2014 Already Fixed by Another CR
Description
SAP IQ returned the error "Non-fatal IQ internal error detected at dfo_Ranking.cxx:197"

when a query running in parallel mode contained both a Number function and a Rank function. Non-deterministic function such as the Number function should not be produced in parallel mode. Parallel mode is now disabled for such queries.
Target Version
 15.4 e04.x
Workaround Description
 The work around for customer is to disable the parallel mode only for dfo_Ranking node; other query segments in this tree still can run in parallel.

Please set this option to disable parallelism for the top segment that contains Ranking node.



Set temporary option dml_options57 = 126;



Please Rerun query and save the query plan.

Please set dml_options10 = 'on'

and query_detail ='on'



if you still have problem please check query plan to see how many segment there are.

please try to set the dml_options57 to a large number ( 2^10 -2) or (2^16-2)

( in binary expression make it 11 111111110 -- last bit must be zero, that means disable the parallel for the top segment

All other segments are still enabled to run in parallel )



CR:768550
CR Number:   768550
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 08 Aug 2014 Fixed
16.0 sp09 08 Aug 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
An internal error may get generated from a query containing a correlated scalar value subquery in the SELECT list, and an uncorrelated IN subquery predicate whose body was a

UNION ALL.



CR:768643
CR Number:   768643
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)
16.0 20 Nov 2014 Work as design
Description
executing a procedure created by another user id, a select of rowid fails with db_sqlexception SQLCode: -1000266, SQLState: 'QDB09', Exception Thrown from db_sqlid.cxx:605, Table 'xxxx' not found (fixed in IQ 16)
Workaround Description
 upgrade to IQ 16



CR:768677
CR Number:   768677
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 23 Sep 2014 Fixed
15.4 e04.x 26 Sep 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
In IQ 15.4 select count distinct statement containing a WHERE ... OR xxx IN (.... UNION...) may return inconsistent results.
Workaround Description
 recode SQL to avoid using the UNION , or upgrade to IQ 16



CR:768755
CR Number:   768755
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 08 Aug 2014 Fixed
16.0 sp09 14 Aug 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
An internal error may get generated from a query containing a simplifiable COALESCE expression that appeared within an aggregate that was then used inside a larger

expression within the HAVING clause.
Workaround Description
 *** Thu Aug 7 11:19:16 EDT 2014 *** lil ***



I can reproduce it in 15.4 code line.

The work around is to disable case statement simplification. Please use the option below:

Set temporary option dml_options5 = 1073741824;



CR:768832
CR Number:   768832
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 23 Aug 2014 Fixed
15.4 e04.x 23 Aug 2014 Fixed
16.0 sp09 09 Sep 2014 Fixed
Description
A query in IQ 15.4 ESD 4.2 caused the "dfo.cxx:11439 Can not evaluate expression" error.

The query involved:

(a) a subquery using a join

(b) an expression using a function in the subquery select list

(c) the expression is used in the inner case expression of a nested case expression

which also shows in the subquery select list

(d) an outer join involving the table resulting from the subquery on a condition

involving the nested case expression
Workaround Description
 Not yet ( DML_OPTIONS5 =1073741824 is not work for this case )



CR:768989
CR Number:   768989
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2014 Consult Complete
Description
After creating a remote server from IQ to IQ, Assertion failed: 201503



CR:769001
CR Number:   769001
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 18 Aug 2014 Fixed
16.0 sp04.x 19 Aug 2014 Fixed
16.0 sp08.x 19 Aug 2014 Fixed
Description
Incremental insert into a range partitioned table may, in certain situations, trigger a server failure.



CR:769091
CR Number:   769091
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 02 Sep 2014 Fixed
Description
Under rare circumstances, a crash could occur while executing a SQL SECURITY INVOKER stored procedure. This has been fixed.



CR:769131
CR Number:   769131
Product Name:   IQ
Product Component:   SA Component
Status:   Closed
OS:   Solaris
Original Version:   15.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.2 29 Oct 2014 Not a Bug
Description
IQ 15.2 Solaris, JDBC application using prepared statements containing a batch of SQL statements that use Host Variables fails df_Exceptions "Host variable 'xxxx' is not initialized" (df_Heap.cxx 2711)



CR:769293
CR Number:   769293
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp10 07 Nov 2014 Fixed
15.4 e04.x 11 Nov 2014 Fixed
15.4 e05 11 Nov 2014 Fixed
16.0 sp08.x 01 Dec 2014 Fixed
16.0 sp04.x 11 Nov 2014 Fixed
16.0 sp09 12 Nov 2014 Fixed
Description
An outer join using a non nested loop join algorithm and on a join condition involving

the NULLIF function may return incorrect results. This has been resolved.
Workaround Description
 set temporary option Join_Preference='-4';



CR:769521
CR Number:   769521
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2014 Fixed
15.4 e05 03 Sep 2014 Fixed
16.0 sp09 09 Sep 2014 Fixed
Description
A query in IQ 15.4 ESD 4.5 caused the "dfo.cxx:11264 Can not evaluate expression" error.

The query involved:

(a) a complex cast expression that consists of 2 cast sums that are added together

(b) the cast expression showing up in a subquery select list and also in the select list

of a join as a virtual column occluding the cast expression

(c) the join having a group by clause followed by a rollup and a having clause
Workaround Description
 Nothing



CR:769609
CR Number:   769609
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 sp09 06 Nov 2014 Fixed
16.0 sp09 06 Nov 2014 Fixed
16.0 sp08.x 06 Nov 2014 Fixed
16.0 sp04.x 06 Nov 2014 Fixed
Description
Non-Fatal Error, s_bm.cxx; loading NULLs into range partitioned table
Target Version
 16.0 sp08.x
Review Status
 Loading NULLs into range partitioned table may get IQ BM internal error during LOAD or DBCC error after LOAD. The fix is in 16.0 SP08.20.



CR:769864
CR Number:   769864
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2003
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A SELECT query involving JOIN over a UNION ALL view which ran fine under IQ 15.4 using a Hash PushDown join, ran very slowly under IQ 16.0 SP8.0.2 and used a Hash join. Setting the Revert_To_V15_Optimizer cause non-fatal crash.



CR:769899
CR Number:   769899
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 01 Oct 2014 Fixed
15.4 e04.x 01 Oct 2014 Fixed
16.0 sp04.x 02 Oct 2014 Fixed
16.0 sp08.x 02 Oct 2014 Fixed
16.0 sp09 06 Oct 2014 Fixed
Description
This is a correctness bug, related to queries having either

(a) two or more OLAP-style partitioned aggregates having the

same PARTITION BY expressions and ORDER BY expressions, but

having different ordering directions

(b) at least one OLAP aggregate whose PARTITION BY expressions

and ORDER BY expressions together match the query's ORDER BY

clause except for a difference in ordering direction.
Workaround Description
 Eng suggested below workaround for this issue. It's to disable the optimizer抯 elimination of sorts that it thinks are redundant, via:



SET option 揚UBLIC.dml_options2 = 8388608 ;



For typical workloads, disabling this optimization publicly is expected to

have only a modest negative impact on overall performance, but some

individual queries may suffer more significant slowdowns.



CR:769913
CR Number:   769913
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When create a mirror file of the transaction log file, dbbackup -xo create a copy of the mirror file.This problem occurs only when use the transaction mirror.



CR:769931
CR Number:   769931
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 29 Oct 2014 Fixed
16.0 sp10 29 Oct 2014 Fixed
16.0 sp09.x 04 Dec 2014 Fixed
28 Oct 2014 Presently Not Targeted For Any Future Release Of This Product
Description
Loading a file created with IQ Binary Extract that contains a varchar or varbinary column may fail with an erroneous conversion error.
Workaround Description
 use a cast in the select statement that extracts the data, to cast the varchar(20) to a char(20).



The issue is related to a new 16.0 optimization for varchar/varbinary width minimization.

The workaround is to disable the optimization before the binary extract using dml_options14=8.



CR:769957
CR Number:   769957
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 19 Sep 2014 Fixed
16.0 sp09 29 Sep 2014 Fixed
16.0 sp08.x 23 Sep 2014 Fixed
16.0 sp08.x 24 Sep 2014 Fixed
Description
Queries that involve a mix of FP-based conditions and HG-Based

conditions that encounter an error during condition execution

(e.g. a data type conversion error) may cause the server to crash.



CR:769980
CR Number:   769980
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2014 Fixed
Description
When the port is changed that the IQ server is running on, the user could not logon to SAP IQ Cockpit. This has been fixed. When the discovery process runs the connection information for the server will be updated if it has changed.
Workaround Description
 None found yet.



Questions for finding workaround

- Even though discovery processseems to be discovering database, it does not seem to change infoirmation in reposiroty. Is that correct & need to be addressed ?

- How to loging in repository & which table can be changed to reflect port number change ?



CR:769981
CR Number:   769981
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp09 26 Sep 2014 Fixed
Description
There is an issue where the agent for cockpit could pickup the wrong IQ binaries to use in execution. This has been resolved to ensure we find the appropriate IQ binaries to execute against.
Workaround Description
 None found yet.



Questions for finding workaround

- Customer has rolled back but I have seen this problem multiple times.

Since plugins/com.sybase.iq/agent-plugin.xml points to wrong location, it has potential to cause cockpit issue.

Why cockpit after shutdown is using old value rather than latest in this file especially everywhere ( IQDIR16 ) is pointing to correct directory



CR:770015
CR Number:   770015
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Solaris
Original Version:   15.4 e03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Collation 1256ARA considers '2' and '' as equal.

Same problem with the chars '3' and ''



CR:770034
CR Number:   770034
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2014 Duplicate
Description
using the row_number() OLAP function twice in a query, once over order by asc and once by desc returns a wrong result
Workaround Description
 set option dml_options2 = 8388608



CR:770083
CR Number:   770083
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   HP-UX
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08 26 Sep 2014 Fixed
16.0 sp09 26 Sep 2014 Fixed
Description
Queries with inter-column comparisons using null-absorbing coalesce, isnull, or case expressions could generate incorrect results.



CR:770147
CR Number:   770147
Product Name:   IQ
Product Component:   Install
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Installer of IQ 16.0 SP08 raise a java exception during the installation of the SCC.



CR:770177
CR Number:   770177
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   HP-UX
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 19 Sep 2014 Fixed
16.0 sp09 19 Sep 2014 Fixed
Description
Performance regression between 15.4 and 16.x from a join

between a small table and a UNION ALL view over a set of

large tables where the 15.4 plan used a HPDJ algorithm

and the 16.0 plan incorrectly claimed that the HPDJ

algorithm was not valid for that join.



CR:770332
CR Number:   770332
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Oct 2014 Fixed
16.0 sp08.x 05 Nov 2014 Fixed
Description
Customers using PAM authentication might experience PAM authentication failures or a server crash during the recovery phase of database startup. This was caused by delaying the pam_init() call to post database start. This has been fixed by calling pam_init() prior to database start.



CR:770353
CR Number:   770353
Product Name:   IQ
Product Component:   Utility
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Create Database Wizard of SCC/COCKPIT will fail by "unexpected end of file" in the Bourne Shell(bash) on RHEL6.
Workaround Description
 Please change user login shell to C Shell.



CR:770406
CR Number:   770406
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 22 Sep 2014 Fixed
16.0 sp09 22 Sep 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
The Multiplex Writer node may hang when there are a large number of DML operations happening on the Writer and Coordinator node concurrently when lots of threads on the writer node are attempting to make global free list inquiry to the coordinator node.
Workaround Description
 Nothing





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