SAP Knowledge Base Article - Preview

2239651 - Crash at slib\s_dpidx.cxx:1758 on DELETE - SAP IQ


  • IQ crashes on delete.

Excerpts from iqmsg file:

[20917]: Delete of 9010 rows started for table:
Invalid key length found in the dictionary of indexDBA.f_Raw_ComponentMetrics.ASIQ_IDX_T773_C66_FP (datatype as varchar): maxLength = 64
.. token (0): length=13, offset=0
.. token (2): length=14, offset=16
.. token (137): length=13110, offset=1866 *** invalid key length ***
.. token (138): length=13877, offset=1908 *** invalid key length ***
.. token (139): length=13358, offset=1924 *** invalid key length ***
.. token (140): length=13870, offset=1938 *** invalid key length ***

**       Non-Fatal IQ Internal Error Detected
**       at slib\s_dpidx.cxx:1758  on thread 3524 (TID 2)
**       Please report this to SAP IQ support
**       with the following diagnostic information,
**       and, if possible, with the user's command.
**  Error from IQ connection:  SA connHandle: 6644  SA connID: 30  IQ connID: 0000065614  User: DBA
**  Time of error:  2015-10-15 19:46:09
**  IQ Version:  SAP IQ/16.0.0/150721/P/sp08.35
**  OS info:  IQ built on: MS/Windows 2003,  Executed on: Windows/host123/WinNT/6.1/Build 7601/Service Pack 1/x86 Family/level 6/Model 44/Stepping 2/4 CPU(s)
**  Command status when error occured:  CURSOR ACTIVE
**  Command text:
delete from "f_Raw_ComponentMetrics" where "tKey_TimeStamp" < 1436869740

**************** This is the STACKTRACE ***************

===== Thread Number  3524  (IQ connID: 0000065614) =====
 void __cdecl pcpstack(unsigned long,unsigned long,class db_log * __ptr64,class hos_fd * __ptr64,int) 00000001805e52e0 f hos_stacktrace.obj +0x117
 void __cdecl StackTraceForThisThread(char const * __ptr64,int,char const * __ptr64,char const * __ptr64,char const * __ptr64) 00000001805e7150 f hos_stacktrace.obj +0x3f6
 public: __cdecl hs_idxexception::hs_idxexception(char const * __ptr64,int,enum hs_idxexception::hs_idxerrors,class s_index const * __ptr64,unsigned int,char const * __ptr64,char const * __ptr64) __ptr64 00000001809ca90 f s_index.obj +0x1d3
 void __cdecl hs_ThrowIdxException(char const * __ptr64,int,enum hs_idxexception::hs_idxerrors,class s_index const * __ptr64,unsigned int,char const * __ptr64,char const * __ptr64) 00000001809c42c0 f s_index.obj +0x44
private: class hos_exception * __ptr64 __cdecl db_IndexDef::FlushIndexIdentity(void) __ptr64 0000000180d97ac0 f db_indexn.obj +0xe6
private: void __cdecl db_IndexDef::CloseSIndexWithLock(class s_index * __ptr64,int) __ptr64 0000000180caa2f0 f db_index.obj +0x1a9
public: void __cdecl db_IndexDef::CloseSIndex(class s_index * __ptr64,int) __ptr64 0000000180caea50 f db_index.obj +0x125
private: void __cdecl hdb_delete_indices::Cleanup(int) __ptr64 0000000180cfb190 f db_delete.obj +0x5a
public: void __cdecl hdb_delete_indices::Delete_Indices(void) __ptr64 0000000180cfc520 f db_delete.obj +0x28f
public: virtual void __cdecl hdb_hdelete::Delete(char const * __ptr64) __ptr64 0000000180cfc7f0 f db_delete.obj +0x1ab
public: virtual void __cdecl dfo_DeleteRoot::Complete(void) __ptr64 00000001801e54b0 f dfo_Root.obj +0x2cb
public: virtual void __cdecl st_cursorIQtoSA::Complete(void) __ptr64 0000000180bfe970 f st_cursor.obj +0x1e0
private: virtual void __cdecl df_Delete::Complete(void) __ptr64 00000001800566f0 f df_dmlcommands.obj +0x57
public: void __cdecl st_command::DoCmdThroughResourceGate(void) __ptr64 0000000180bf7840 f st_command.obj +0xf1
Exception Thrown from slib\s_dpidx.cxx:1758, Err# 16, tid 2 origtid 2
O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
IQ Internal error. Please report this to SAP IQ support.
-- (slib\s_dpidx.cxx 1758)





SAP IQ 16.0


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.