2132792 - DELETE fails after upgrade from SAP IQ 15 to SAP IQ 16 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2132792 - DELETE fails after upgrade from SAP IQ 15 to SAP IQ 16

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 ONE Support launchpad (Login required).

Search for additional results

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