SAP Knowledge Base Article - Preview

2592982 - Inconsistent query results after upgrading from SAP IQ 15.4 -- SAP IQ

Symptom


1. After upgrade from SAP IQ 15.x to newer SAP IQ 16.x, sometimes queries return inconsistent results.

2. Following sequence works fine unless SAP IQ is under heavy workload.

< connect to SAP IQ  >

update lo_1355898 set rand_num = rand(1355898 + recNdx)  where use_ind = 1
update lo_1355898 set rand_order = number(*)  where use_ind = 1 order by rand_num
update lo_1355898 set use_ind = 0 where use_ind = 1 and rand_order > 38000

< Some records get updated. Check that value returned from last update is the correct value – and it is >
< disconnect from SAP IQ >

Different predicate, maybe 10 seconds later:

< connect to SAP IQ >
Select count(*) from lo_1355898 where use_ind = 1;

(count is > 38000 – in fact, NO RECORDS have use_ind = 0 even though there should have been some. )

< disconnect from SAP IQ >


Read more...

Environment

SAP IQ 16.x

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

tds , inconsistent , upgrade , chained , autocommit , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.