Symptom
DQP query fragment may fail with following key messages in .iqmsg
********************************************************
** Non-Fatal IQ Internal Error Detected
** at vplib/vpp_Bloom.cxx:204 on thread 237215 (TID 920)
** Error detected for expression: (sup_111.LK_SuppKey_Address PROBABLY_IN BV(1, NULL )) [0x0x2755419de8, hn:17400, qb:3] **
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Command status when error occured: NO COMMAND OR CURSOR ACTIVE
===== Thread Number 237215 (DQP queryID: 99935) =====
.pcstkwalk(stk_trace*,int,db_log*,hos_fd*)+0x1c8()
.ucstkgentrace(int,int)+0x10c()
.StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x4fc()
.df_Exception::df_Exception(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x288()
.df_Exception::ThrowException(const char*,int,df_Exception::df_ErrorCode,const char*,const char*,const dfo*,const df_Evaluable*)+0x38()
.vpp_BloomSemiJoin::Prepare()+0x3bc()
.st_workerQueryFragment::Prepare(hos_Deserializer&)+0x2e8()
.st_workerQueryFragment::Exec()+0x94()
.st_workerContextContainer::SetupWorkAllocatorExec(st_workerQueryFragment*)+0x4ac()
.st_workerContextContainer::sSetupWorkAllocatorExec(void*,void*)+0x10()
.hos_thread::Main()+0x228()
.hos_lwtask::Start(hos_lwtask*)+0x64()
.IQWorkerStarter(void*)+0x6c()
.run_task_body+0x48()
.UnixTask::pre_body(void*)+0x134()
**
Exception Thrown from vplib/vpp_Bloom.cxx:204, Err# 0, tid 920 origtid 920
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
[20238]: IQ Internal error. Please report this to SAP IQ support.
-- (vplib/vpp_Bloom.cxx 204)
DQP_CXT worker : st_workerQueryFragment::Run Exception throw Leader ID : 5, Txn ID : 115713408, DQP Context ID : 1407374883653215, Work handle ID 1, Fragment ID 40
Read more...
Environment
IQ 16 sp11 pl11+
Product
Keywords
DQP_CXT , st_workerQueryFragment , vpp_BloomSemiJoin::Prepare , join_preference , vplib/vpp_Bloom.cxx:204 , DQP , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.