Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

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 = ON 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 optimizers elimination of sorts that it thinks are redundant, via: SET option PUBLIC.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