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

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

CR:703390

CR Number:   703390 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ 15.3: LOAD TABLE ... USING CLIENT FILE in SP prompting for options to be ticked The issue is not with the load table command itself but with calling a stored proc with the load table command in it. If you create a stored proc with the load table command inside and call that stored proc you will see the prompt. (screen prompting for options to be ticked...etc) (DBA)> call test_load() A procedure or trigger is requesting to read the file 'E:\temp\BA_F_JOUR_MOUV.out'. 1. Allow this transfer 2. Deny this transfer 3. Allow this and all subsequent transfers for this connection 4. Deny this and all subsequent transfers for this connection Select an option: 1 2 row(s) affected Execution time: 5.719 seconds The customer would like a option similar to set temporary option isql_allow_read_client_file = 'ON' that will prevent the default PROMPT action. Perhaps enhance ALLOW_READ_CLIENT_FILE = 'ON' to have an option like ALLOW_READ_CLIENT_FILE = 'ON NO PROMPT'

CR:703526

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

CR:703878

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

CR:703882

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

CR:704146

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

CR:704248

CR Number:   704248 Product Name:   Sybase IQ ETL Product Component:   Licensing Status:   Open OS:   Solaris Original Version:   Denali Fixed Version Build Resolution Date Closure Code (If Appropriate) Description SySAM loses checkout message in a Japanese language environment. An issue will be reproduced when ja_JP.eucJP and ja_JP.SJIS are specified.

CR:704298

CR Number:   704298 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   future Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Add non-equijoins by transitivity. When the where clause has these conditions: T1.c1 >= T2.c2 T2.c2 = constant then IQ should automatically add this condition: T1.c1 >= constant

CR:704302

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

CR:704383

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

CR:704771

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

CR:705105

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

CR:705108

CR Number:   705108 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description NFR: possibility to change data in the partitioned key in IQ Currently data in the partitioned key can not be changed (even if the data will be afterwards in the same partition).

CR:705288

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

CR:705510

CR Number:   705510 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   AIX Original Version:   15.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.2 e03.x 21 Sep 2012 Fixed 15.4 e03 16 Nov 2012 Fixed 16.0 28 Nov 2012 Fixed Description Nested loop pushdown (NLPD) join with more than one uncorrelated IN subquery crashes at st_server.cxx:1412, server abort at dfo::CheckMarkInvariant. The problem is fixed. Target Version  15.2 e03.x Workaround Description  Please note they say that if they alter subquery at the end changing .... ( Select CIF_ID from ODS_FBS.FBS_PORTFOY1 WHERE E_MAIL_ADRES IN (Select EMAIL from u037687.EMAIL_HATA) into this..... Select CIF_ID from ODS_FBS.FBS_PORTFOY1 p, u037687.EMAIL_HATA m WHERE p.E_MAIL_ADRES=m.EMAIL the query runs ok. But this is BO generated queries so they can not control this. They also found that the modified working query as described above strated failing again when they changed this subquery... AND CRM2.BEST_EMAIL.CIF_ID IN ( SELECT DISTINCT CIF_ID FROM CANDO.CIF_CLUB_PROGRAM_SAHIPLIK WHERE (WORLD_CLUB_FLG = '1' adding this or statement... OR OPET_FLG = '1') ) But if they remove the GROUP BY it works again.

CR:705535

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

CR:705829

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

CR:706080

CR Number:   706080 Product Name:   IQ Product Component:   Install Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The GNOME desktop manager of RHEL5 mounts a DVD volume name to "/media." However, the blank is included in the IQ15.4 DVD volume name. IQ15.4 installer is not supporting the file name/path including a blank. Workaround Description  Please mount DVD media manually. ex)mount -t udf /dev/hda /media/dvd

CR:706098

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

CR:706184

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

CR:706824

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

CR:707370

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

CR:707398

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

CR:707612

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

CR:707649

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

CR:707865

CR Number:   707865 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description And a lot of data(eg. 50000 rows) was inserted in the table using Load Table. However, Load Table makes a gap to the value of an AUTOINCREMENT column. Workaround Description  Please set a small value(eg. 3 or 4) to MAX_IQ_THREADS_PER_CONNECTION. Or Core_Options54 = 1.

CR:707992

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

CR:708061

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

CR:708197

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

CR:708205

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

CR:708818

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

CR:708860

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

CR:708892

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

CR:709160

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

CR:709231

CR Number:   709231 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   16.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 26 Jun 2012 Fixed Description In IQ 16 ALPHA, a hash partitioned table has the following restriction: All columns in a hash partitioned table must be fixed-width data types and flat (i.e. IQ unique(0)).

CR:709904

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

CR:710047

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

CR:710054

CR Number:   710054 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01 11 Jul 2012 Fixed Description IQ 15.4 sends wrong char length to JDBC clients when those conditions are met: - IQ 15.4 runs on LINUX64 - collation must be UTF8 - JDBC retrieves a CHAR column value. This results in JDBC clients getting "End of data" error.

CR:710120

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

CR:710169

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

CR:710208

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

CR:710418

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

CR:710442

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

CR:710657

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

CR:711339

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

CR:711351

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

CR:711731

CR Number:   711731 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e01.x Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2012 Bundled Request Description Server crashes with CREATE USER and ALTER USER statements with password when VERIFY_PASSWORD_FUNCTION is enabled in 15.4. Workaround Description  Engineer made W/A, Please use the following work-around to avoid the server crash. CREATE FUNCTION DBA.f_verify_pwd ( user_name varchar(128), new_pwd varchar(255) ) RETURNS varchar(255) BEGIN -- WORKAROUND START execute immediate with quotes 'begin tran;'; -- Add this line in the beginning of verify password function -- WORKAROUND END -- enforce password rules IF new_pwd = user_name then RETURN('Password cannot be the same as the user name' ); END IF; -- return success RETURN( NULL ); END;

CR:712235

CR Number:   712235 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description When restoring from backup, customer would like the ability to use the RESTORE .... RENAME to change / manage which raw device a dbfile should be restored to (i.e. swap around and reuse existing definitions) For example if the system backed up contains MY_DBFILE1 on /dev/raw/raw1 and MY_DBFILE2 on /dev/raw/raw2, they wish to be able to restore this swapping which raw device the dbfile resides on, something like this... restore database '/mydatabase.db' from 'my-backup-file' rename MY_DBFILE1 to '/dev/raw/raw2' rename MY_DBFILE2 to '/dev/raw/raw1' The currently can not do this as the restore logic and the UNIQUE constraint in ISYSDBSPACE (as identified in CR 649181) does not allow this so you get this error... Could not execute statement. Dbspace file with name or path '/dev/raw/raw1' already exist. SQLCODE=-1234, ODBC 3 State="42000"

CR:712250

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

CR:712256

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

CR:712373

CR Number:   712373 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 07 Jan 2013 Fixed Description Using insert-location to insert time data into a time column from a time column on a remote IQ server results in error "Cannot convert to time." Workaround Description  cast the TIME to TIMESTAMP on the select from location eg, insert into test_time(id,mytime) location 'iqrepro.iqrepro' {select id,CAST(mytime AS TIMESTAMP) from test_time}; -- This will work and will keep the right precision.

CR:712378

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

CR:712540

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

CR:712589

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

CR:712709

CR Number:   712709 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01.x 28 Aug 2012 Fixed 15.4 e03 16 Dec 2012 Fixed 25 Jan 2013 Fixed Description A server failure could occur when a query has an IN clause with a subquery that has a filtering condition. Workaround Description  Following sql, avoiding the "not in" clause but functionally equivalent, does not crash the servers. INSERT INTO dc.LOG_LoadStatus_15 (typename, timelevel, status, datadate, datatim e , DATE_ID, modified) SELECT s2.typename, s2.timelevel, 'NOT_LOADED', '2012-06-18 00:00:00', DATEADD(mi, min_id, DATEADD(hh, HOUR_ID, DATETIME('2012-06-18 00:00:00'))) , DATETIME('2012-06-18 00:00:00'), NOW() FROM dc.LOG_MonitoredTypes s1, dc.LOG_LoadStatus s2 JOIN ( SELECT '1MIN' tlevel, hour_id, min_id FROM dc.dim_time UNION ALL SELECT '5MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE mod(min_id,5) = 0 UNION ALL SELECT '10MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE mod(min_ id,10) = 0 UNION ALL SELECT '15MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id I N (0,15,30,45) UNION ALL SELECT '30MIN' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id I N (0,30) UNION ALL SELECT 'HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id IN (0,30) UNION ALL SELECT '6HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id = 0 AND hour_id IN (0, 6, 12, 18) UNION ALL SELECT '24HOUR' tlevel, hour_id, min_id FROM dc.dim_time WHERE min_id = 0 AND hour_id = 0) datatimes ON s2.timelevel = tlevel WHERE s1.status = 'ACTIVE' AND ACTIVATIONDAY <= '2012-06-22 00:00:00' AND s1.typename != s2.typename and s1.timelevel != s2.timelevel and s2.datadate = '2012-06-22 00:00:00'

CR:712751

CR Number:   712751 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 24 Aug 2012 Fixed Description When using ODBC access to MS Access through IQ, you might encounter an error when exporting a table: Column 'X' has an unknown datatype: 'nvarchar'. -- (db_catalog.cxx 1162) This has now bee fixed.

CR:712782

CR Number:   712782 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Solaris Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e01.x 02 Aug 2012 Fixed 15.2 e02 02 Aug 2012 Fixed 15.4 future 02 Aug 2012 Fixed 16.0 Description Growcapacity was being called everytime and the release memory was with the process. This was a major problem once the object size was big. This use to consume a lot of memory of the system heap thus choking the memory availability for the process/application.

CR:712864

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

CR:713182

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

CR:713301

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

CR:713838

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

CR:713919

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

CR:713941

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

CR:715010

CR Number:   715010 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Solaris Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Aug 2012 Fixed 27 Aug 2012 Added to user documentation Description Explicitly passing in null as the 3rd parameter (algorithm) to the encrypt or decrypt function will result in the error -973 "The string is too long (Parameter 3)", rather than having the encryption/decryption default to AES128. The work around is to omit the argument. See "Known Issues" for more information.

CR:715165

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

CR:715316

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

CR:715562

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

CR:715563

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

CR:715567

CR Number:   715567 Product Name:   IQ Product Component:   Documentation Status:   Open OS:   Linux Red Hat Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description IQ documentation enhancement request to improve details and examples on how to set and define IQ-to-ASE connections with ODBC on Unix/Linux. There is an excellent article published by Rob Vershoor highlighting this located at http://www.sypron.nl/iq_ase_odbc.html.

CR:715677

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

CR:715997

CR Number:   715997 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e04 16 Apr 2013 Fixed 16.0 sp01 07 Mar 2013 Test Exists 16.0 sp01 11 Mar 2013 Fixed Description Certain queries could return different results - when it is run on Simplex or MPX. - when it is run several times on MPX Workaround Description  2 possible workarounds: 1- SET TEMPORARY OPTION CIS_OPTION=8 2- Rewrite the query as follows: DROP table if exists a CREATE table a (a_key char(30), a_val int not null) INSERT a values('XXX', 100) BEGIN DECLARE @a_val int SELECT @a_val = MIN(a.a_val) FROM a , (SELECT cast('XXX' as char (30) ) as a_key ) z WHERE a.a_key = z.a_key SELECT @a_val INSERT INTO a ( a_key, a_val ) SELECT 'XXX', @a_val END

CR:716303

CR Number:   716303 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Linux Red Hat Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e03 26 Feb 2013 Fixed Description A server failure may occur in s_btParallelCursor::SetDeleteNotifier when trying to insert a duplicate key. Workaround Description  Use "core_options27=1" for the INSERT VALUES or INSERT SELCT statement when inserting to a word index to avoid the problem.

CR:716358

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

CR:716554

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

CR:716563

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

CR:716988

CR Number:   716988 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Linux Red Hat Original Version:   15.4 e01.x Fixed Version Build Resolution Date Closure Code (If Appropriate) Description incorrect result with nested exists clause Workaround Description  The work around : 1. if exists (select 1 from pr_account where acnomajor like 'C[_]%' AND @include_feeder = 'N' and exists (select 1 from pr_account where acnomajor like 'A%[_]%' AND @include_feeder = 'N')) so it's if exists ( conditions and exists ( conditions )) 2. Or using an or clause: if exists (select 1 from pr_account where @include_feeder = 'N' and acnomajor like 'C[_]%' or acnomajor like 'A%[_]%' and @include_feeder = 'N' )

CR:717018

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

CR:717140

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

CR:717361

CR Number:   717361 Product Name:   IQ Product Component:   SA Component Status:   Open OS:   Windows 2003 Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Conversions on the result of DATEADD could return different values depending on whether the query is executed on the catalog or on IQ, due to the fact that: select datalength (dateadd(hh,4, date(now()))) from dummy ==> returns 8 select datalength (dateadd(hh,4, date(now()))) from iq_dummy ==> returns 4

CR:717555

CR Number:   717555 Product Name:   IQ Product Component:   IQ Component Status:   Open OS:   Unknown Original Version:   15.4 e01 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description sp_iqpassword fires" Syntax error " when the password contains special chars such as: "!" , "?", "+" , ">" , "<" , "" , "|" , "*" , "&", "(", ")", etc Workaround Description  Use CREATE USER or ALTER USER or GRANT CONNECT

CR:717572

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

CR:717619

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

CR:717877

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

CR:718091

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

CR:718155

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

CR:718373

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

CR:718919

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

CR:719383

CR Number:   719383 Product Name:   IQ Product Component:   IQ Component Status:   Closed OS:   Windows 2003 Original Version:   15.4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.4 e02.x 07 Jan 2013 Fixed 02 Jan 2013 Fixed 17 Jan 2013 Fixed Description The query below returns wrong result when Nested loop is not used : select count(1) from REL_1_CityASM t1 join F_PUP_OrderHeader t2 on (cast(t1.Object_ID as bigint) = t2.PUP_Order_ID/1000000000) join LU_Cassa t7 on (t1.Object_ID=t7.Object_ID ) where t1.ASM_ID=23 and (REMAINDER(t2.PUP_Order_ID,1000000000) <> 0)

CR:719590

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

CR:719831

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

CR:720503

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

CR:720539

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

CR:720584

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

CR:720701

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

CR:720782

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

CR:720912

CR Number:   720912 Product Name:   IQ Product Component:   Documentation Status:   Closed OS:   Unknown Original Version:   15.4 e02 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16.0 beta2 25 Oct 2012 Added to user documentation Description DROP USER will drop any objects owned by this user AND ALSO THE PERMISSIONS GRANTED BY THIS USER WILL BE REMOVED. Please see reference for the REVOKE CONNECT command in the SA manual: http://dcx.sybase.com/index.html#1201/en/dbreference/revoke-statement.html .

CR:721615

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

CR:721667

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

CR:721949

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

CR:722006

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

CR:722122

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