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.
SAP Knowledge Base Article - Preview