SAP Knowledge Base Article - Preview

2784962 - DELETE statement may have caused a server hang on some NBit FP columns, with error 's_dpidx.cxx:7742' -- SAP IQ

Symptom

  • A DELETE statement may have caused a server hang on some NBit FP columns.sp_iqcheckdb VERIFY returned no errors.
  • The load jobs were resubmitted again and ran through fine.
  • This could also have lead to "Non-Fatal IQ Internal Error Detected" ... "at slib/s_dpidx.cxx:7742". 

Non-Fatal IQ Internal Error Detected at slib/s_dpidx.cxx:7742 on thread 779 (TID 773)
with Query_Name: Dynamic

void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x47c(ffff80ff86d73b68, 4b831558e8)
void hs_dp::CheckIndexConsistency(int)+0x48ed(0, ffff80ffa0ef5def)
void hdb_delete_indices::Unit_of_Work(int)+0x2ac(ffff80ffa29968a0, 30500000001)
int hdb_delete_indices::hdb_delete_index_iter::ExecWork(int&,unsigned)+0x156(0, 468e8b5650)
void workAllocator::DoWork(unsigned)+0x21d(0, ffff80ffa2bf9810)
int hos_thread::Main()+0x3a0(0, 0)
int hos_lwtask::Start(hos_lwtask*)+0x241(1000, ffff80ff86cfd000)
void IQWorkerStarter(void*)+0x49(8, e24850)
void*UnixTask::pre_body(void*)+0x1b3(0, 0)
_fini+0x19c17009(0, 0)


Read more...

Environment

SAP IQ16.1 SP02.14

Product

SAP IQ 16.1

Keywords

's_dpidx.cxx' , CheckIndexConsistency , 'hdb_delete_indices' , , 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.