SAP Knowledge Base Article - Preview

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

Symptom

  • 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)


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

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.