SAP Knowledge Base Article - Preview

2267757 - SAP IQ 16: A SELECT query with a combination of conditions and with a CMP index would cause non-fatal failure in vpp::CreateShadow.

Symptom

A SELECT query on one table with a combination of 3 conditions and with a CMP index would cause non-fatal failure in vpp::CreateShadow.
The table has a CMP index.


The SELECT would succeed if:

  • one the 3 conditions is removed.
  • or the CMP index is removed
  • or add the LF index suggested by the index advisor. 

Excerpt of IQMSG

Advice: Add LF index on T.CHANNEL_GENRE  Predicate: (T.CHANNEL_GENRE = 'Kids')
Advice: Add LF index on T.previous_channel_genre  Predicate: (master_events_build.P83_Viewing_201510.previous_channel_genre = 'Kids')
   
********************************************************
**
**       Non-Fatal IQ Internal Error Detected
**       at vplib/vpp.cxx:260  on thread 3359471360 (TID 30)
 

vpp::CreateShadow
vpp_Boolean::CreateShadow
vpp_Combiner::CreateShadowVppTree
vpp_Combiner::SetupParallelFind
vpp_Combiner::ExecuteOpus
vpp::Execute
vp_Predicates::PreExecute
 
Exception Thrown from vplib/vpp.cxx:260, Err# 0, tid 30 origtid 30
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23


Read more...

Environment

SAP IQ 16 SP 4.11

Product

SAP IQ 16.0

Keywords

vpp_Boolean::CreateShadow ; vpp_Combiner::CreateShadowVppTree ; vpp_Combiner::SetupParallelFind ; vpp_Boolean ; vpp_Combiner ; CreateShadow ; CreateShadowVppTree ; SetupParallelFind; CR#793001 ; CR793001 ; 793001 ; , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.