Symptom
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.
Read more...
Environment
SAP IQ 16 SP 08 PL 27
Product
Keywords
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
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.