2275668 - SAP IQ 16. Query fails on s_bArrayLocater::PrefetchBatchFindPageInLookahead

SAP IQ 16 SP 08 PL 27

Since upgrading from IQ 15.4 to IQ 16.0 a Stored Procedure fails with stacktrace below

  
********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at slib/s_barray.cxx:4985  on thread 262 (TID 253)
**
**       Please report this to SAP IQ support
**       with the following diagnostic information,
**       and, if possible, with the user's command.
**  Error from IQ connection:  SA connHandle: 57954  SA connID: 23  IQ connID: 0000735015  User: xxxx
**  Time of error:  2016-01-29 08:46:46
**  IQ Version:  SAP IQ/16.0.0/150224/P/sp08.27
**  OS info:  IQ built on: Sun_x64/OS 5.10,  Executed on: SunOS/rmdbd01/5.10/Generic_150401-22/i86pc
**  Command status when error occured:  CURSOR ACTIVE
**  Command text: 
call "xxxxx"



const unsigned long long*s_bArrayLocater::PrefetchBatchFindPageInLookahead
void s_bArrayLocater::LoadPage
 unsigned*s_bArrayLocater::LocateTokenRecord
int hs_dpfetch::FetchToken
 void vpp_FindIter::DoOneWorkunit
 int vpp_FindIter::ExecWork(int&,unsigned)+0xaf
 void workAllocator::DoWork
 int hos_thread::Main
 int hos_lwtask::Start
void IQWorkerStarter
void*UnixTask::pre_body
******************

The stored proccedure uses COALESCE function. When it is not used, the procedure is executed with success.

The sp_iqcheckdb 'verify database' has been executed and found no errors.

SAP IQ 16 SP 08 PL 27

s_bArrayLocater ; PrefetchBatchFindPageInLookahead ; s_barray.cxx ; REVERT_TO_V15_OPTIMIZER , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem