Symptom
After upgrading from SAP IQ 15.x to IQ 16 SP08 some delete statements fail with
- Invlaid key length found in dictionary errors
I. 02/06 20:39:11. 0000006958 [20917]: Delete of 1 rows started for table:
I. 02/06 20:39:11. 0000006958 Invalid key length found in the dictionary: maxLength = 50
I. 02/06 20:39:11. 0000006958 .. invalid key length = 17731
I. 02/06 20:39:11. 0000006958 .. invalid key length = 17731
- Query fails with Non-Fatal Internal errors detected in s_dpidx.cxx
I. 02/06 20:39:11. 0000006958 ** Non-Fatal IQ Internal Error Detected
I. 02/06 20:39:11. 0000006958 ** at slib/s_dpidx.cxx:1706 on thread 107 (TID 9)
...
I. 02/06 20:39:12. 0000006958 Exception Thrown from slib/s_dpidx.cxx:1706, Err# 16, tid 9 origtid 9
I. 02/06 20:39:12. 0000006958 O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
I. 02/06 20:39:12. 0000006958 [20238]: IQ Internal error. Please report this to SAP IQ support.
-- (slib/s_dpidx.cxx 1706)
- Stack trace is produced with failure at call to hs_dpidentity*hs_dp::GetIdentity
***************** This is the STACKTRACE ***************
I. 02/06 20:39:12. 0000006958
===== Thread Number 107 (IQ connID: 0000006958) =====
I. 02/06 20:39:12. 0000006958 pc: 0x0 (0x9, 0xfffffd7b97a87dc6)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b96b7384c void StackTraceForThisThread(const char*,int,const char*,const char*,const char*)+0x3c4(0x6aa99342e40, 0xfffffd7b98db5340)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9739e6ab void hs_ThrowIdxException(const char*,int,hs_idxexception::hs_idxerrors,const s_index*,unsigned,const char*,const char*)+0x297(0x0, 0x0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b96e33854 const hs_dpidentity*hs_dp::GetIdentity(int&)+0x36c(0x93b0a4ba8, 0x93ad4a838)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b97a893d5 hos_exception*db_IndexDef::FlushIndexIdentity()+0x275(0xfffffd7b00000000, 0x0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b97909a5e void db_IndexDef::CloseSIndex(s_index*,int)+0x606(0x0, 0x93b14f310)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9798bda0 void hdb_hdelete::Delete(const char*)+0x5c4(0x93b14f310, 0x93b14e9f8)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b964ef95d void dfo_DeleteRoot::Complete()+0x2b1(0xfffffd7b9b83bc40, 0xfffffd7b9642ec34)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b977e0c8a void st_cursorIQtoSA::Complete()+0x812(0xfffffd7b993b44f0, 0xfffffd7b9b83c9a0)
I. 02/06 20:39:12. 0000006958 pc: 0xfffffd7b9627fabd void df_Delete::Complete()+0x2d(0x1a, 0x0)
...
Read more...
Environment
SAP IQ 15.x upgraded to SAP IQ 16 SP08
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.