SAP Knowledge Base Article - Preview

2598852 - Query failed in in vplib/vpp_Bloom.cxx:204 -- SAP IQ

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

SAP IQ 16.0

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.