SAP Knowledge Base Article - Preview

3291405 - SAP IQ abort on dfo::GatherPlanStats after a cancellation request - SAP IQ


  • IQ abort after a cancellation request and with the stack trace below.
  • The process that crashed the IQ server runs regularly. Thus, the crash is not reproduceable at will.

Excerpt of IQMSG

Exception Thrown from slib/s_dpNBit.cxx:953, Err# 0, tid 24 origtid 24
O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
[2188]: Statement interrupted by user
***   SAP IQ Abort:
***      Rethrown from:  oslib/hos_throw.cxx:281
***      PID: 17667
***      Exception Location: 0xcee0b8
***      Error ID: 519,  Exception Type: hos_attnexception
***      Thread: 202  (TID: 24, Original TID: 24)
***      Error #: 0,  O/S Error #: 0
***      Argument:  
-- (slib/s_dpNBit.cxx 953) 
**  Command text:  
  lock table "table_A" in write mode wait '00:30:00';
  update "table_b"
    set "col0" = :p0,
    "col1" = :p1,
    "col2" = :p2,
    "col26" = :p26 
  where "col27" = :p27

void hos_ABORT
void Throw
void hos_attention::_Check
int hos_dmConvert_LONGVARCHAR_VCHAR
int hos_dmConvert
void dfo::AttachStatsForDFE
void dfo::GatherPlanStats
void dfo_Root::Complete
void db_sqlinsert::Shutdown
void hos_ObjectStack::Throw
void Throw
void hos_attention::_Check
void s_dictionary::ReallocateStrTab
void s_dpNBit::Delete
int hs_dp::DeleteNBit
void hs_dp::DeleteInternal
void hs_dp::Delete
unsigned hs_dpUpdate::Prepare
void db_sqlinsert::UpdatePrepare
void db_sqlinsert::Prepare
void st_command::DoCmdThroughResourceGate
unsigned st_iqdml::Update



SAP IQ 16.1


827623; CR827623; CR#827623 , 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 for Me (Login required).

Search for additional results

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