提供7*24专业Sybase数据库远程及现场技术支持，Sybase ASE及Sybase SQL Anywhere数据库修复服务，
请联系电话: (微信)，QQ: 289965371！
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持！
Email: 289965371@qq.com
扫描下方微信，联系我们：
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着Sybase被完全整合到SAP下，Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况，现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE，可以看到针对不同版本的CR（CR表示Change Request）简单描述信息列表。
需要注意的是：Targeted CR List for ASE列出的CR虽然绝大多数是BUG，但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息！

如有问题，请联系我！

QQ :289965371 联系我们获取数据库技术支持！
Email:
不仅仅包括BUG的详细描述信息，还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程；有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:770410
CR Number:   770410
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Unknown
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 24 Sep 2014 Fixed
16.0 sp04.x 24 Sep 2014 Fixed
16.0 sp08.x 25 Sep 2014 Fixed
16.0 sp09 06 Oct 2014 Fixed
15.4 e04.x 24 Sep 2014 Fixed
Description
Two wrong answer scenarios from GROUP BY ROLLUP aggregates were detected:

(1) COUNT(*) and COUNT(x) are incorrectly be set to NULL (instead of 0) for cases where (a) there are no input tuples flowing into the GROUP BY, and (b) the query plan chose

to execute the GROUP BY in parallel.

(2) The SUM(x) aggregate is incorrectly be set to 0 (instead of NULL)for cases where (a) either there are no input tuples, or where for a given rollup group all the SUM input values for x were NULL, and (b) the default data type for a SUM(SUM(x)) is different than

the data type for SUM(x)



CR:770652
CR Number:   770652
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.x 09 Oct 2014 Fixed
16.0 sp04.x 05 Nov 2014 Presently Not Targeted For Any Future Release Of This Product
15.4 14 Oct 2014 Fixed
16.0 sp08.x 14 Oct 2014 Fixed
16.0 sp10 05 Nov 2014 Fixed
15.4 e05 10 Dec 2014 Fixed
Description
SAP IQ returned internal error "cannot evaluate expression at dfo.cxx:11271" when a query running in parallel mode used the hash group by algorithm and contained group by rollup over an Union All view.
Workaround Description
 As Temporary W/A set below option. Customer's problem queries are work with the option.

However customer worries about performance slow as the option.



Set temporary option aggregation_preference=1' ;



CR:770717
CR Number:   770717
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   16.0 sp04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2014 Fixed
Description
database restore on AIX IQ 16 SP04.04 fails with "Error during backup/restore: unable to close device", "A file descriptor does not refer to an open file", SQLCODE=-697, ODBC 3 State="HY000"
Workaround Description
 upgrade to IQ 16 SP08



CR:770874
CR Number:   770874
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 30 Sep 2014 Diagnostic Provided
15.4 e04.x 15 Oct 2014 Fixed
15.4 e05 16 Oct 2014 Fixed
16.0 sp10 17 Oct 2014 Fixed
16.0 sp08.x 20 Oct 2014 Fixed
16.0 sp04.x 21 Oct 2014 Fixed
Description
Given certain set of data and under certain database option settings, queries with

an order by clause using items that are different from what is on the select list,

e.g., select 0 as x from t1 order by c1, can cause the IQ server to fail. This has

been resolved.
Workaround Description
 Disable shadow parallel order by retrievers



set temporary option dml_options8 = 268435456}



CR:770899
CR Number:   770899
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The option BLOCKING='ON' with 2 connections inserting into the same table:



- When using DBISQL JAVA, both connections hang forever.

- When isuing Open Client ISQL, cause:



SQL Anywhere Error -1000011: Transaction 11480715 attempted to access 'kntest'

created by transaction 11480722.



CR:771163
CR Number:   771163
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.x 10 Oct 2014 Fixed
Description
A double memory free could occur when concurrently executing a stored procedure,

that performs a load table, by more than 1 connection at the same time.



This has been fixed.



CR:771216
CR Number:   771216
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 13 Oct 2014 Fixed
Description
Fixed an issue where the discovery mechanism employed by SAP IQ Cockpit may not have discovered the running resources on the host. The resources are now discovered and the system list will be populated.
Workaround Description
 None



CR:771329
CR Number:   771329
Product Name:   IQ
Product Component:   Utility
Status:   Closed
OS:   Linux Red Hat
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2014 Fixed
Description
When you have specified the dbisql-statement, DBISQL might run 2 times a connection process.



CR:771336
CR Number:   771336
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)
02 Dec 2014 Fixed
16.0 sp10 17 Dec 2014 Fixed
16.0 sp10 15 Jan 2015 Fixed
Description
MPX coordinator stalled in rebooting from its previous crash if the other MPX secondary servers were not shut down.
Workaround Description
 No



CR:771360
CR Number:   771360
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Windows 7
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
disabling dqp_enabled is resulting in the following error in IQ 16:



Msg 102, Level 15, State 0:

SQL Anywhere Error -131: Syntax error near 'dqp_enabled' on line 2



CR:771549
CR Number:   771549
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Encrypted password support has been enhanced to restrict use to a particular computer/user and upgraded encryption algorithms. See KBA https://service.sap.com/sap/support/notes/2118895 for full details.



CR:771559
CR Number:   771559
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 20 Oct 2014 Fixed
16.0 sp09 20 Oct 2014 Presently Not Targeted For Any Future Release Of This Product
16.0 sp10 20 Oct 2014 Fixed
Description
Internal Error (opt_JoinNode.cxx:3043) from within the join optimizer for joins involving multi-column primary keys has been fixed.
Workaround Description
 We have two W/As, See CR notes for detail



1) Re-write query

2) Set Join_Preference = 1 or 4



CR:771956
CR Number:   771956
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e04.x 29 Oct 2014 Fixed
15.4 e05 29 Oct 2014 Fixed
Description
The SAP IQ server could fail with a SEGV error when a query contained an ANY, ALL, SOME

IN uncorrelated subquery. For example select * from t1 where c1 > ALL(select...



CR:772215
CR Number:   772215
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)
21 Oct 2014 Fixed
Description
When the Interactive SQL utility (dbisql) was run as a console application and connection parameters were specified, but the database password was not, dbisql would have exited without connecting. Now, dbisql will prompt for a password, given that the "-q" (quiet) option was not specified. Since a password is not required on the command line, the password will not be visible with OS utilities used to view process command lines.



CR:772339
CR Number:   772339
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2014 Fixed
16.0 sp08.x 21 Oct 2014 Fixed
Description
IQ crashes in dfiio_FP::CompleteOpus during an INSERT..SELECT. This issue may occur if an error is returned when executing the select. This issue has been fixed.



CR:772483
CR Number:   772483
Product Name:   IQ
Product Component:   other
Status:   Closed
OS:   AIX
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 15 Oct 2014 Fixed
Description
Open Client has been updated to 15.7 SP131 to resolve FIPs not loading on AIX. The fix limited to in this release only.



CR:772547
CR Number:   772547
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Linux Suse
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 28 Oct 2014 Fixed
16.0 sp04.x 28 Oct 2014 Fixed
16.0 sp09.x 28 Oct 2014 Fixed
16.0 sp10 28 Oct 2014 Fixed
Description
Under rare circumstances that is very data dependent, a server failure may occur after deletion of NBit rows from a varchar or varbinary column.



CR:772714
CR Number:   772714
Product Name:   IQ
Product Component:   SA 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 07 Jan 2015 Fixed
Description
IQ crash at will in RelocatableHeap::LoadCrossHeapPtr when:

- a user executes a system proc encapsulated within a stored procedure,

- and this user is not the owner of this stored proc.
Workaround Description
 Chaning the following in line in the CR 772714 repro avoids the problem



Change: execute sp_iqdbspace IQ_SYSTEM_MAIN



To: select * from sp_iqdbspace('IQ_SYSTEM_MAIN')







Regards,

Mary



CR:772905
CR Number:   772905
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
On IQ 16, simple INSERT INTO table (SELECT conn_handle FROM "satmp_request_time") or

SELECT conn_handle INTO table FROM "satmp_request_time"

executes for hours depending on the size of the zrlog.

The SELECT without insert runs around 15 mins.



CR:773004
CR Number:   773004
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 10 Nov 2014 Fixed
16.0 sp08.x 10 Nov 2014 Fixed
15.4 e05 06 Nov 2014 Fixed
Description
SAP IQ return error "non-fatal error at dfe_MinMaxAggregate.cxx:998".

when a query contained LAG or LEAD OLAP function and used NULL value as default value.



CR:773300
CR Number:   773300
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   15.4 e04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SQL via ODBC does not set the correct value to satmp_request_time.rowcount



CR:773343
CR Number:   773343
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2003
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 10 Dec 2014 Fixed
Description
The IQUNLOAD tool has been enhanced to support unload of a current iq database schema and data.



CR:773699
CR Number:   773699
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   15.4 e04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SELECT ... FROM several derived tables returns incorrect result.
Workaround Description
 With DML_OPTIONS8 = 268435456 the query returns the correct result. But it is not applicable for ct as it can cause performance drop for other queries, and also queries are generated by Business Objects.



CR:773817
CR Number:   773817
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 07 Nov 2014 Fixed
Description
Open Client has been upgraded to 15.7 SP130



CR:774071
CR Number:   774071
Product Name:   IQ
Product Component:   Install
Status:   Closed
OS:   Unknown
Original Version:   15.4 e05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 12 Nov 2014 Fixed
Description
Open Client has been upgraded to 15.7 SP130



CR:774119
CR Number:   774119
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 05 Dec 2014 Fixed
Description
Previously, Interactive SQL would fail to set its exit code to non-zero in a number of cases:



1. If no connection parameters are given, but a statement is given.



2. If a READ statement or the name of a SQL file is given on the command line, and the file exists, but the file cannot be read for any reason.



3. If an error is encountered while reading the results of a statement.



4. If a statement was using the TEMP_EXTRACT option



CR:774287
CR Number:   774287
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 Dec 2014 Duplicate
Description
MPX. If a client connection is launched from LINUX to the coordinator and run an IQ backup,

- on the writer, client operations accessing catalog data returns results.

- on the writer, client operations accessing user data hang forever.
Workaround Description
 Shut down the Writer.

Backup the database.

Restart the writer



CR:774457
CR Number:   774457
Product Name:   IQ
Product Component:   SA Component
Status:   Open
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x Fixed
16.0 sp04.x Fixed
15.4 e05 Fixed
Description
SAP IQ no longer support the SSLv3 protocol. All TLS connections must now be TLSv1 or higher.



CR:774469
CR Number:   774469
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 03 Dec 2014 Fixed
Description
IQ Server crash during a transaction which involves creation of a local temporary table as a part of transaction.
Workaround Description
 Making following change/s to UDF avoids the crash:

WorkAround 1:

begin

select Table_name,TabSeqId, a1, b1 into #tmp002 from

(select Table_name,TabSeqId,EDW.FN_Table_RowCount_IQ16(TABLE_NAME) as a1,EDW.FN_TABLESIZEGB_IQ16(TABLE_NAME) as b1

from edw.Mig_table_RowCount_14NOV14

where TabseqId between 2 and 10) aa;

select * into EDW.MIG_ROWCOUNT_IQ16B_tmp3 from #tmp002;

end



WorkAround 2:



begin



select Table_name,TabSeqId, a1, b1 into #tmp002 from

(select Table_name,TabSeqId,EDW.FN_Table_RowCount_IQ16(TABLE_NAME) as a1,EDW.FN_TABLESIZEGB_IQ16(TABLE_NAME) as b1

from edw.Mig_table_RowCount_14NOV14

where TabseqId between 2 and 10) aa;



insert into EDW.MIG_ROWCOUNT_IQ16B_tmp3 select * from #tmp002;



CR:775120
CR Number:   775120
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Unknown
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CREATE ANY OBJECT system privilege overrides REVOKE CREATE on DBSPACE privilege.



CR:775132
CR Number:   775132
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 25 Nov 2014 Fixed
15.4 e05 02 Dec 2014 Fixed
Description
When running iqunload against a 15.4 database that had a RAW dbspace file, the utility might suddenly exit without displaying any errors. This has been fixed.



CR:775135
CR Number:   775135
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 25 Nov 2014 Fixed
15.4 e04.x 25 Nov 2014 Fixed
Description
When running iqunload against a 15.4 MPX database, when connecting to the MPX coordinator, the utility might suddenly exit without displaying any errors. This has been fixed.



CR:775138
CR Number:   775138
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   AIX
Original Version:   15.4 e05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05 26 Nov 2014 Fixed
Description
The iqunload utility when run with the -v argument will now display table specific progress messages.



CR:775139
CR Number:   775139
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   15.4 e05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.4 e05
Description
When running iqunload with the -v argument, it will include additional progress messages about the specific tables being unloaded.



CR:775353
CR Number:   775353
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.x 06 Jan 2015 Fixed
16.0 sp04.x 06 Jan 2015 Fixed
16.0 sp09.x 06 Jan 2015 Fixed
16.0 sp10 06 Jan 2015 Fixed
Description
16.0 tokenized FP (nBit FP) for NUMERIC data types may become corrupted resulting in data loss when adding new values that causes the dictionary to be resized. This fix properly resizes NUMERIC nBit dictionaries.



CR:775708
CR Number:   775708
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Solaris
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Post multiplex upgrade from IQ 15.2 esd 2.27 on solaris to IQ 16 sp08.20 , coordinator node startup aborting st_server.cxx:1709 with a stack at call inc_iqnwi::SetupSender



CR:775857
CR Number:   775857
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 12 Dec 2014 Fixed
16.0 sp09.x 16 Dec 2014 Fixed
16.0 sp08.x 24 Dec 2014 Fixed
16 Dec 2014 Presently Not Targeted For Any Future Release Of This Product
Description
IQ 16 sp08.03 LOAD TABLE with ROW LOG aborted IQ process with s_violation::LogDataValueViolationInRowLog -> hos_extract_varchar_ascii

LOAD TABLE... ROW LOG was executed whenever a data conversion error was found at any field. It should be performed after the whole row has been processed.

The ROW LOG will be correctly performed at the end of a row to ensure that we are logging the correct data for the row.



CR:776148
CR Number:   776148
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Windows 7
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Install instructions for Windows 7 say to use AGREE_TO_SYBASE_LICENSE, but should say use AGREE_TO_SAP_LICENSE.
Workaround Description
 Use AGREE_TO_SAP_LICENSE rather than AGREE_TO_SYBASE_LICENSE.



CR:776295
CR Number:   776295
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 04 Jan 2015 Fixed
16.0 sp04.x 06 Jan 2015 Fixed
16.0 sp09.x 06 Jan 2015 Fixed
06 Jan 2015 Fixed
Description
When upgrading from 15.x to 16.0, tokenized FP (1-byte, 2-byte or 3-byte) indexes may become corrupted when deleting tokens from the nBit dictionary. This may lead to HG index metadata mismatched reported as hos_memmgr::FreeHosMem hs_subohc::~hs_subohc(). This fix properly compacts deleted token to avoid metadata corruption in the nBit index.



CR:776502
CR Number:   776502
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 sp08.x 24 Dec 2014 Fixed
Description
LOAD TABLE failed with a double throw error while writing to the row/message log.



CR:776538
CR Number:   776538
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dbping might hang if IQ started with -p flag. This has now been fixed.
Workaround Description
 USE CBSIZE= in -c



CR:776588
CR Number:   776588
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)
Description
When using encryption, there is no mean to check that it is enabled.

The customer would like a message displayed in IQMSG/SRVLOG such as:

"SSL context successfully created".



CR:776701
CR Number:   776701
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 13 Jan 2015 Fixed
09 Jan 2015 Fixed
Description
An equi-join query may fail that involved

- in the join predicate an equality comparison of 2 columns from the same table and

- in the select list a SQL function that uses the first column from the equality

comparison and

- in the select list the other column from the equality comparison

Or

- a where clause with an equality comparison predicate of 2 columns from the same

table and

- a join predicate using columns that are from 2 separate tables and are different

from those used in the equality comparison and

- a select list as described above
Workaround Description
 None found



CR:776708
CR Number:   776708
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
"IGNORE CONSTRAINT UNIQUE 0" will report the number of incorrect insertion rows.



CR:776709
CR Number:   776709
Product Name:   IQ
Product Component:   Documentation
Status:   Open
OS:   Linux Red Hat
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SAP IQ will always request the libaio package.



CR:776959
CR Number:   776959
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   AIX
Original Version:   16.0 sp04.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Multi-tape backups are failing when 3rd tape is required



CR:777046
CR Number:   777046
Product Name:   IQ
Product Component:   IQ Component
Status:   Open
OS:   Windows 2008
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the Entity Framework Data Model Wizard "Choose Your Database Objects and Settings" dialog, the SQL Anywhere .NET Data Provider did not return stored procedure and function names in the "Stored Procedures and Functions" list view for a case-sensitive database. This problem has been corrected.



CR:777203
CR Number:   777203
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 13 Jan 2015 Fixed
16.0 sp10 13 Jan 2015 Fixed
Description
Fixed an issue where a query over a hash partitioned table that included an equality condition on the table's hash partition basis column equating it to a constant expression resulted in an IQ Internal Error from vpp_Compares.cxx.
Workaround Description
 This problem can be worked around by setting:



set option PUBLIC.DML_Options12 = 2097152



This setting will disable the latest variant of predicate parallelism

and revert to the earlier variant. Setting this option could have a

modest (< 5%) impact on the performance on some of the other predicates

that were not hitting the internal error.



Once a fix is available, the setting can be reverted by:

set option PUBLIC.DML_Options12 = 0



CR:777332
CR Number:   777332
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)
Description
LOAD failed with internal error and dump of variable page in IQMSG.

Prior to LOAD, some rows at the end of row id chunk(s) have been deleted.

LOAD reused these deleted row ids, but not all have been reused.

When NBIT column reached rollover limit and partly rolled over to FLAT,

before the entire column rollover, LOAD attempted to merge the deleted

rows which resulted the reported internal error.

This can result s_barray or s_blockmap assertion due to memory corruption.



Potential trigger condition:

NBIT variable column reached rollover limit with prior DELETE operations.

CR762777 and 776088 are duplicates of this CR.
Workaround Description
 Recreate table.



CR:777445
CR Number:   777445
Product Name:   IQ
Product Component:   IQ Component
Status:   Closed
OS:   Solaris
Original Version:   16.0 sp08.x
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp08.x 14 Jan 2015 Fixed
Description
Added logic to detect nbit load/update issues and rollback the operation



CR:777605
CR Number:   777605
Product Name:   IQ
Product Component:   other
Status:   Open
OS:   Windows 2000
Original Version:   16.0 sp08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SYSAM issue

"Corrupt MS(Max DBSpace) value in license, restricting to 5GB" error message raised in iqmsg file





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB：

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括：5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集，包括：cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制：不支持AES加密的数据文件
请参考：研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作：

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景：

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况；
2.误操作，包括truncate table,drop table,不正确的where条件导致的误删除等；
Sybase SQL Anywhere无法打开时，比较常见的错误是：Assertion failed。
如：
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE：

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具！
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能：

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复；
  2. 系统崩溃只剩下数据文件的情况下的恢复，甚至数据库文件不存在而只有损坏的备份文件情况下的恢复；
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复；
  4. delete数据恢复、误update数据恢复、误删除表(drop）恢复、误truncate表恢复 等；
  5. 各种Sybase内部系统表损坏、索引错误的修复；
  6. master数据库损坏而无法正常运行情况下的恢复；
  7. Sybase数据库被标记为可疑，不可用等情况的恢复；
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复；
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复；
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复；
  11. Sybase数据文件被误删除情况下的碎片提取恢复；
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复；
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复；
  14. Sybase数据库还原数据库出现失败情况下的恢复；
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本：

Sybase ASE 11.0.x，11.5.x，11.9.x，12.0.x，12.5.x，15.0.x，15.5.x，15.7.x，16.0.x


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

SQL Server数据库恢复工具SQLRescue：

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具！
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能：

  1. 系统崩溃只剩下数据文件的情况下的恢复，即无日志文件或者日志文件损坏情况下的恢复；
  2. 断电导致数据库文件损坏情况下的恢复；
  3. 硬盘坏道造成数据库损坏情况下的恢复；
  4. 数据文件内部存在坏页情况下的恢复；
  5. 企业管理器误删除数据表记录，管理软件误删除数据表记录的恢复；
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况；
  7. 无法读取并闩锁页sysindexes失败情况下的修复；
  8. 数据文件被误删除情况下的碎片提取恢复；
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回；
  10. master数据库损坏而无法正常运行情况下的恢复；
  11. 数据文件无法附加情况下的数据恢复；
  12. 数据库被标记为可疑，质疑，不可用等情况的恢复；
  13. 数据库sysobjects等系统表损坏情况下的恢复；
  14. 数据被误(drop、delete、truncate）删除表数据的恢复,误update后的数据恢复等；
  15. 还原时报一致性错误，错误823等情况下的数据恢复，各种错误提示的数据库文件修复；
  16. 数据库被误格式化等情况下的数据库恢复；
  17. 日志收缩造成数据库损坏情况下的恢复；
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点：

只要SQL Server数据库的数据文件存在，我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本：

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------