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 ONE Support launchpad (Login required).

Search for additional results

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